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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:

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

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)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata