View In:   ArcGIS Online Map Viewer

Name: Inspections

Display Field: site_contact_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -9771515.219407186
YMin: 5.664923641290895E-9
XMax: 6.327780442533911E-9
YMax: 5802550.785232775
Spatial Reference: 102100  (3857)  VCSWkid(115700)  LatestVCSWkid(115700)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [42, 170, 79, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• inspection_dt ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspection_dt )
• applicationid ( type: esriFieldTypeGUID, alias: ApplicationID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: applicationid )
• reportid ( type: esriFieldTypeGUID, alias: ReportID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: reportid )
• requestid ( type: esriFieldTypeGUID, alias: RequestID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: requestid )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: comments )
• inspection_type ( type: esriFieldTypeString, alias: Inspection Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: inspection_type )
• ref_id ( type: esriFieldTypeString, alias: Reference #, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ref_id )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: accela_ref_id )
• reference_id ( type: esriFieldTypeString, alias: Reference ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: reference_id )
• report_type ( type: esriFieldTypeString, alias: Report Type, editable: true, nullable: true, length: 35, defaultValue: original, modelName: report_type )
• amended_report_comment ( type: esriFieldTypeString, alias: Amended Report Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: amended_report_comment )
• next_inspection_type ( type: esriFieldTypeString, alias: Next Inspection Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: next_inspection_type )
• actrpt_2 ( type: esriFieldTypeString, alias: actrpt_2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: actrpt_2 )
• actrpt_3 ( type: esriFieldTypeString, alias: actrpt_3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: actrpt_3 )
• actrpt_4 ( type: esriFieldTypeString, alias: actrpt_4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: actrpt_4 )
• actrpt_5 ( type: esriFieldTypeString, alias: actrpt_5, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: actrpt_5 )
• public_act ( type: esriFieldTypeString, alias: Public Act and Law, editable: true, nullable: true, length: 255, defaultValue: null, modelName: public_act )
• status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: pending, modelName: status )
• inspection_location ( type: esriFieldTypeString, alias: Facility # / Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: inspection_location )
• tanks_inspected ( type: esriFieldTypeString, alias: Tank List, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: tanks_inspected )
• tank_facilityid ( type: esriFieldTypeString, alias: Tank FacilityID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: tank_facilityid )
• inspection_result ( type: esriFieldTypeString, alias: Result, editable: true, nullable: true, length: 35, defaultValue: null, modelName: inspection_result )
• num_tanks_inspected ( type: esriFieldTypeSmallInteger, alias: # Tanks Inspected, editable: true, nullable: true, defaultValue: null, modelName: num_tanks_inspected )
• num_violations_cited ( type: esriFieldTypeSmallInteger, alias: # Violations Cited, editable: true, nullable: true, defaultValue: null, modelName: num_violations_cited )
• tankid ( type: esriFieldTypeGUID, alias: TankID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: tankid )
• site_contact_name ( type: esriFieldTypeString, alias: Contact Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: site_contact_name )
• site_contact_information ( type: esriFieldTypeString, alias: Contact Info, editable: true, nullable: true, length: 255, defaultValue: null, modelName: site_contact_information )
• resolve_by_dt ( type: esriFieldTypeDate, alias: Complaince Required Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: resolve_by_dt )
• facilityid ( type: esriFieldTypeGUID, alias: FacilityID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: facilityid )
• parentglobalid ( type: esriFieldTypeGUID, alias: Activity ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parentglobalid )
• status_date ( type: esriFieldTypeDate, alias: Status Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: status_date )
• amended_yn ( type: esriFieldTypeString, alias: Report is amended, editable: true, nullable: true, length: 5, defaultValue: no, modelName: amended_yn )
• insp_start_time ( type: esriFieldTypeDate, alias: Start Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: insp_start_time )
• insp_end_time ( type: esriFieldTypeDate, alias: End Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: insp_end_time )
• accela_inspector_name ( type: esriFieldTypeString, alias: Accela Inspector Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: accela_inspector_name )
• accela_insp_desc ( type: esriFieldTypeString, alias: Accela Inspection Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: accela_insp_desc )
• accela_insp_result_date ( type: esriFieldTypeDate, alias: accela_insp_result_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: accela_insp_result_date )
• accela_insp_total_mileage ( type: esriFieldTypeDouble, alias: accela_insp_total_mileage, editable: true, nullable: true, defaultValue: null, modelName: accela_insp_total_mileage )
• accela_insp_start_mileage ( type: esriFieldTypeDouble, alias: accela_insp_start_mileage, editable: true, nullable: true, defaultValue: null, modelName: accela_insp_start_mileage )
• accela_insp_end_mileage ( type: esriFieldTypeDouble, alias: Accela Inspection End Mileage, editable: true, nullable: true, defaultValue: null, modelName: accela_insp_end_mileage )
• accela_hist_checklist_num ( type: esriFieldTypeDouble, alias: Accela Hist Checklist Number, editable: true, nullable: true, defaultValue: null, modelName: accela_hist_checklist_num )
• requested_inspection_dt ( type: esriFieldTypeDate, alias: Requested Inspection Dt, editable: true, nullable: true, length: 8, defaultValue: null, modelName: requested_inspection_dt )
• completed_inspection_dt ( type: esriFieldTypeDate, alias: Completed Inpsection Dt, editable: true, nullable: true, length: 8, defaultValue: null, modelName: completed_inspection_dt )
• systemid ( type: esriFieldTypeGUID, alias: System ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: systemid )
• next_inspection_dt ( type: esriFieldTypeDate, alias: Next Inspection Dt, editable: true, nullable: true, length: 8, defaultValue: null, modelName: next_inspection_dt )
• accela_hist_inspection_num ( type: esriFieldTypeDouble, alias: Accela Hist Inspection Num, editable: true, nullable: true, defaultValue: null, modelName: accela_hist_inspection_num )
• accela_insp_total_time ( type: esriFieldTypeInteger, alias: Accela Insp Total Time, editable: true, nullable: true, defaultValue: null, modelName: accela_insp_total_time )
• accela_insp_group ( type: esriFieldTypeString, alias: Accela Inspection Group, editable: true, nullable: true, length: 100, defaultValue: null, modelName: accela_insp_group )
• accela_is_required_insp ( type: esriFieldTypeString, alias: Accela Is Required Inspection, editable: true, nullable: true, length: 1, defaultValue: null, modelName: accela_is_required_insp )
• facility_no ( type: esriFieldTypeString, alias: Facility No, editable: true, nullable: true, length: 255, defaultValue: null, modelName: facility_no )
• facility_name ( type: esriFieldTypeString, alias: Facility Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: facility_name )
• facility_status ( type: esriFieldTypeString, alias: Facility Status, editable: true, nullable: true, length: 35, defaultValue: null, modelName: facility_status )
• facility_address1 ( type: esriFieldTypeString, alias: Facility Address 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: facility_address1 )
• facility_address2 ( type: esriFieldTypeString, alias: Facility Address 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: facility_address2 )
• facility_city ( type: esriFieldTypeString, alias: Facility City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: facility_city )
• facility_zip ( type: esriFieldTypeString, alias: Facility Zip, editable: true, nullable: true, length: 255, defaultValue: null, modelName: facility_zip )
• inspection_last_routine_dt ( type: esriFieldTypeDate, alias: Last Routine Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspection_last_routine_dt )
• inspection_last_type ( type: esriFieldTypeString, alias: Last Inspection Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: inspection_last_type )
• inspection_last_dt ( type: esriFieldTypeDate, alias: Last Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspection_last_dt )
• report_last_action ( type: esriFieldTypeString, alias: Last Action, editable: true, nullable: true, length: 50, defaultValue: null, modelName: report_last_action )
• system_type ( type: esriFieldTypeString, alias: System Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: system_type )
• system_subtype ( type: esriFieldTypeString, alias: System Sub Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: system_subtype )
• tank_qty ( type: esriFieldTypeSmallInteger, alias: Number of Tanks, editable: true, nullable: true, defaultValue: null, modelName: tank_qty )
• scheduled_inspection_dt ( type: esriFieldTypeDate, alias: Scheduled Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: scheduled_inspection_dt )
• facility_state ( type: esriFieldTypeString, alias: Facility State, editable: true, nullable: true, length: 255, defaultValue: null, modelName: facility_state )
• inspection_no ( type: esriFieldTypeString, alias: Inspection Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: inspection_no )
• site_contact_phone ( type: esriFieldTypeString, alias: Site Contact Phone, editable: true, nullable: true, length: 15, defaultValue: null, modelName: site_contact_phone )
• compl_reqd_dt ( type: esriFieldTypeDate, alias: Complaince Req Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: compl_reqd_dt )
• compl_rcvd_dt ( type: esriFieldTypeDate, alias: Complaince Rec Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: compl_rcvd_dt )
• piping_underground ( type: esriFieldTypeString, alias: Underground Piping, editable: true, nullable: true, length: 255, defaultValue: null, modelName: piping_underground )
• piping_cath_prot ( type: esriFieldTypeString, alias: Piping Cathoticaly Protected, editable: true, nullable: true, length: 255, defaultValue: null, modelName: piping_cath_prot )
• piping_release_det ( type: esriFieldTypeString, alias: Piping Release Detection, editable: true, nullable: true, length: 255, defaultValue: null, modelName: piping_release_det )
• system_location ( type: esriFieldTypeString, alias: System Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: system_location )
• regulated_substance ( type: esriFieldTypeString, alias: Regulated Substance, editable: true, nullable: true, length: 255, defaultValue: null, modelName: regulated_substance )
• refined_petro ( type: esriFieldTypeString, alias: Refined Petroleum, editable: true, nullable: true, length: 255, defaultValue: null, modelName: refined_petro )
• plan_review_req ( type: esriFieldTypeString, alias: Plan Review Required, editable: true, nullable: true, length: 255, defaultValue: null, modelName: plan_review_req )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• worker_id ( type: esriFieldTypeString, alias: Worker ID, editable: true, nullable: true, length: 128, defaultValue: null, modelName: worker_id )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• parent_inspectionid ( type: esriFieldTypeGUID, alias: Parent Inspection ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parent_inspectionid )

Templates:

• Name: Inspections
  Description:
  Prototype:
  worker_id: null
  inspection_dt: null
  applicationid: null
  reportid: null
  requestid: null
  comments: null
  inspection_type: null
  ref_id: null
  accela_ref_id: null
  reference_id: null
  report_type: original
  amended_report_comment: null
  next_inspection_type: null
  actrpt_2: null
  actrpt_3: null
  actrpt_4: null
  actrpt_5: null
  public_act: null
  status: pending
  inspection_location: null
  tanks_inspected: null
  tank_facilityid: null
  inspection_result: null
  num_tanks_inspected: null
  num_violations_cited: null
  tankid: null
  site_contact_name: null
  site_contact_information: null
  resolve_by_dt: null
  facilityid: null
  parentglobalid: null
  status_date: null
  amended_yn: no
  insp_start_time: null
  insp_end_time: null
  accela_inspector_name: null
  accela_insp_desc: null
  accela_insp_result_date: null
  accela_insp_total_mileage: null
  accela_insp_start_mileage: null
  accela_insp_end_mileage: null
  accela_hist_checklist_num: null
  requested_inspection_dt: null
  completed_inspection_dt: null
  systemid: null
  next_inspection_dt: null
  accela_hist_inspection_num: null
  accela_insp_total_time: null
  accela_insp_group: null
  accela_is_required_insp: null
  facility_no: null
  facility_name: null
  facility_status: null
  facility_address1: null
  facility_address2: null
  facility_city: null
  facility_zip: null
  inspection_last_routine_dt: null
  inspection_last_type: null
  inspection_last_dt: null
  report_last_action: null
  system_type: null
  system_subtype: null
  tank_qty: null
  scheduled_inspection_dt: null
  facility_state: null
  inspection_no: null
  site_contact_phone: null
  compl_reqd_dt: null
  compl_rcvd_dt: null
  piping_underground: null
  piping_cath_prot: null
  piping_release_det: null
  system_location: null
  regulated_substance: null
  refined_petro: null
  plan_review_req: null
  parent_inspectionid: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• LARA_SDE.LARA_ADMIN.facilityViolations (2) -- Related To: Facility_Violations (54)
• LARA_SDE.LARA_ADMIN.inspectionNotes (1) -- Related To: Inspection_Notes (56)
• LARA_SDE.LARA_ADMIN.inspectionRelease (0) -- Related To: Inspection_Release (58)
• LARA_SDE.LARA_ADMIN.inspectionVariances (3) -- Related To: Inspection_Variances (57)
• LARA_SDE.LARA_ADMIN.inspectionTanks (4) -- Related To: Inspection_Tanks (53)
• LARA_SDE.LARA_ADMIN.inspectors (5) -- Related To: Inspectors (36)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata