Layers:

Layer: Report (5)

Name: Report

Display Field: poclastname

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: -9858781.216976
YMin: 5.664923641290895E-9
XMax: 6.327780442533911E-9
YMax: 5980578.246555881
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [150, 54, 51, 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:
• report_id ( type: esriFieldTypeString, alias: Report No, length: 255 )
• subtype ( type: esriFieldTypeString, alias: Report Subtype, length: 50 )
• details ( type: esriFieldTypeString, alias: Details, length: 4000 )
• pocemail ( type: esriFieldTypeString, alias: Email, length: 100 )
• pocphone ( type: esriFieldTypeString, alias: Phone, length: 40 )
• poclastname ( type: esriFieldTypeString, alias: Last Name, length: 150 )
• pocfirstname ( type: esriFieldTypeString, alias: First Name, length: 150 )
• tankid ( type: esriFieldTypeGUID, alias: Tank ID, length: 38 )
• facilityid ( type: esriFieldTypeGUID, alias: Facility ID, 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• rpt5_txt ( type: esriFieldTypeString, alias: rpt5_txt, length: 255 )
• rpt1_int ( type: esriFieldTypeInteger, alias: rpt1_int )
• rpt2_int ( type: esriFieldTypeInteger, alias: rpt2_int )
• rpt3_int ( type: esriFieldTypeInteger, alias: rpt3_int )
• rpt4_int ( type: esriFieldTypeInteger, alias: rpt4_int )
• rpt5_int ( type: esriFieldTypeInteger, alias: rpt5_int )
• rpt1_dt ( type: esriFieldTypeDate, alias: rpt1_dt, length: 8 )
• rpt2_dt ( type: esriFieldTypeDate, alias: rpt2_dt, length: 8 )
• rpt3_dt ( type: esriFieldTypeDate, alias: rpt3_dt, length: 8 )
• rpt4_dt ( type: esriFieldTypeDate, alias: rpt4_dt, length: 8 )
• rpt5_dt ( type: esriFieldTypeDate, alias: rpt5_dt, length: 8 )
• siteid ( type: esriFieldTypeGUID, alias: Site ID, length: 38 )
• systemid ( type: esriFieldTypeGUID, alias: System ID, length: 38 )
• source ( type: esriFieldTypeString, alias: Source, length: 255 )
• status ( type: esriFieldTypeString, alias: Status, length: 255 )
• resolution ( type: esriFieldTypeString, alias: Resolution, length: 255 )
• resolutiondt ( type: esriFieldTypeDate, alias: Resolved On, length: 8 )
• report_type ( type: esriFieldTypeString, alias: Report Type, length: 255 )
• assign_userid ( type: esriFieldTypeString, alias: Assign UserID, length: 255 )
• rpt1_txt ( type: esriFieldTypeString, alias: rpt1_txt, length: 255 )
• rpt2_txt ( type: esriFieldTypeString, alias: rpt2_txt, length: 255 )
• rpt3_txt ( type: esriFieldTypeString, alias: rpt3_txt, length: 255 )
• x ( type: esriFieldTypeDouble, alias: x )
• y ( type: esriFieldTypeDouble, alias: y )
• submittedby ( type: esriFieldTypeString, alias: Submitted By, length: 128 )
• pocphoneext ( type: esriFieldTypeString, alias: pocphoneext, length: 50 )
• status_date ( type: esriFieldTypeDate, alias: Status Date, length: 8 )
• epoch_created ( type: esriFieldTypeDouble, alias: epoch_created )
• poccompany ( type: esriFieldTypeString, alias: Company Name, length: 255 )
• poccompanyaddr ( type: esriFieldTypeString, alias: Company Address, length: 255 )
• poctitle ( type: esriFieldTypeString, alias: Title, length: 255 )
• cosigner_name ( type: esriFieldTypeString, alias: Cosigner Name, length: 255 )
• cosigner_title ( type: esriFieldTypeString, alias: Cosigner Title, length: 255 )
• cosigner_phone ( type: esriFieldTypeString, alias: Cosigner Phone, length: 255 )
• cosigner_email ( type: esriFieldTypeString, alias: Cosigner Email, length: 255 )
• cosigner_date ( type: esriFieldTypeDate, alias: Cosigner Date, length: 8 )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, length: 50 )
• earliest_closure_date ( type: esriFieldTypeDate, alias: Earliest Closure Date, length: 8 )
• actual_closure_date ( type: esriFieldTypeDate, alias: Actual Closure Date, length: 8 )
• upgrade_due_date ( type: esriFieldTypeDate, alias: Upgrade Due Date, length: 8 )
• closure_due_date ( type: esriFieldTypeDate, alias: Closure Due Date, length: 8 )
• inspector_id ( type: esriFieldTypeString, alias: Inspector ID, length: 128 )
• revisionid ( type: esriFieldTypeGUID, alias: Revision ID, length: 38 )
• parentglobalid ( type: esriFieldTypeGUID, alias: Activity ID, length: 38 )
• insp_ref_facility_no ( type: esriFieldTypeString, alias: Facility No, length: 1000 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• confirmation_sent_date ( type: esriFieldTypeDate, alias: Confirmation Sent Date, length: 8 )
• submitdate ( type: esriFieldTypeDate, alias: Submit Date, length: 8 )
• expiration_date ( type: esriFieldTypeDate, alias: Expiration Date, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• insp_ref_tank_no ( type: esriFieldTypeString, alias: Inspection Report Tank Nos, length: 1000 )
• accela_hist_action_on_after ( type: esriFieldTypeDate, alias: Accela Action On or After, length: 8 )

Relationships:

• LARA_SDE.LARA_ADMIN.tankActionReports (0) -- Related To: Tank_Action_Reports (51)
• LARA_SDE.LARA_ADMIN.complaintReports (2) -- Related To: Complaint_Reports (26)
• LARA_SDE.LARA_ADMIN.releaseReports (3) -- Related To: Release_Reports (20)
• LARA_SDE.LARA_ADMIN.siteAssessmentReports (4) -- Related To: Site_Assessment_Reports (15)
• LARA_SDE.LARA_ADMIN.documents (5) -- Related To: Documents (24)

Layer: Application (3)

Name: Application

Display Field: type

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5077341.100051548

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: -9858781.216976
YMin: 5.664923641290895E-9
XMax: 6.327780442533911E-9
YMax: 5962015.329464462
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [78, 50, 135, 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:
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• appcity ( type: esriFieldTypeString, alias: City, length: 255 )
• appstate ( type: esriFieldTypeString, alias: State, length: 2 )
• appzip ( type: esriFieldTypeString, alias: Zip, length: 5 )
• appemail ( type: esriFieldTypeString, alias: Email, length: 100 )
• appmiloginid ( type: esriFieldTypeString, alias: MiLogin ID, length: 128 )
• appphone ( type: esriFieldTypeString, alias: Phone, length: 15 )
• type ( type: esriFieldTypeString, alias: Application Type, length: 50 )
• subtype ( type: esriFieldTypeString, alias: Application Subtype, length: 255 )
• install_description ( type: esriFieldTypeString, alias: Description, length: 1000 )
• num_tanks ( type: esriFieldTypeSmallInteger, alias: # Tanks )
• comments ( type: esriFieldTypeString, alias: Comments, length: 1000 )
• moreinfo ( type: esriFieldTypeString, alias: More Information Required, length: 5 )
• submitdate ( type: esriFieldTypeDate, alias: Submission Date, length: 8 )
• status ( type: esriFieldTypeString, alias: Application Status, length: 35 )
• tankid ( type: esriFieldTypeGUID, alias: TankID, length: 38 )
• facilityid ( type: esriFieldTypeGUID, alias: FacilityID, 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 )
• resp_party_id ( type: esriFieldTypeString, alias: Responsible Party ID, length: 25 )
• owner_type ( type: esriFieldTypeString, alias: Owner Type, length: 255 )
• propenddt ( type: esriFieldTypeDate, alias: Proposed Completion Date, length: 8 )
• propstartdt ( type: esriFieldTypeDate, alias: Proposed Start Date, length: 8 )
• var_requested ( type: esriFieldTypeString, alias: Variance Requested, length: 5 )
• app1_txt ( type: esriFieldTypeString, alias: app1_txt, length: 255 )
• app2_txt ( type: esriFieldTypeString, alias: app2_txt, length: 255 )
• app3_txt ( type: esriFieldTypeString, alias: app3_txt, length: 255 )
• app4_txt ( type: esriFieldTypeString, alias: app4_txt, length: 255 )
• app5_txt ( type: esriFieldTypeString, alias: app5_txt, length: 1000 )
• app1_int ( type: esriFieldTypeInteger, alias: app1_int )
• app2_int ( type: esriFieldTypeInteger, alias: app2_int )
• app3_int ( type: esriFieldTypeInteger, alias: app3_int )
• app4_int ( type: esriFieldTypeInteger, alias: app4_int )
• app5_int ( type: esriFieldTypeInteger, alias: app5_int )
• app1_dt ( type: esriFieldTypeDate, alias: app1_dt, length: 8 )
• app2_dt ( type: esriFieldTypeDate, alias: app2_dt, length: 8 )
• app3_dt ( type: esriFieldTypeDate, alias: app3_dt, length: 8 )
• app4_dt ( type: esriFieldTypeDate, alias: app4_dt, length: 8 )
• app5_dt ( type: esriFieldTypeDate, alias: app5_dt, length: 8 )
• systemid ( type: esriFieldTypeGUID, alias: SystemID, length: 38 )
• siteid ( type: esriFieldTypeGUID, alias: SiteID, length: 38 )
• appfirstname ( type: esriFieldTypeString, alias: First , length: 150 )
• applastname ( type: esriFieldTypeString, alias: Last, length: 150 )
• appaddr1 ( type: esriFieldTypeString, alias: Address Line 1, length: 255 )
• appaddr2 ( type: esriFieldTypeString, alias: Address Line 2, length: 255 )
• submittedby ( type: esriFieldTypeString, alias: Submitted By, length: 1000 )
• updatetype ( type: esriFieldTypeString, alias: Update Type, length: 25 )
• exh_item_loc ( type: esriFieldTypeString, alias: The locations of these items appear on the attached exhibits: (select multiple), length: 1000 )
• fin_res_type ( type: esriFieldTypeString, alias: Financial Responsibility Type (select multiple), length: 255 )
• fin_res_type_other ( type: esriFieldTypeString, alias: Financial Responsibility Type Other, length: 255 )
• ug_verifications ( type: esriFieldTypeString, alias: Verification obtained from following: (select multiple), length: 255 )
• ug_well_setbacks ( type: esriFieldTypeString, alias: No tanks within a distance of the following: (select multiple), length: 255 )
• storage_loc ( type: esriFieldTypeString, alias: Storage Location, length: 2 )
• public_act ( type: esriFieldTypeString, alias: Public Act, length: 255 )
• contents ( type: esriFieldTypeString, alias: Contents, length: 255 )
• primary_use ( type: esriFieldTypeString, alias: Primary Use, length: 255 )
• substance_form ( type: esriFieldTypeString, alias: Substance Form, length: 255 )
• total_capacity ( type: esriFieldTypeSmallInteger, alias: Total Capacity )
• epoch_created ( type: esriFieldTypeDouble, alias: epoch_created )
• application_id ( type: esriFieldTypeString, alias: application_id, length: 25 )
• updateid ( type: esriFieldTypeGUID, alias: Update ID, length: 38 )
• cosigner_company ( type: esriFieldTypeString, alias: Cosigner Company, length: 255 )
• cosigner_name ( type: esriFieldTypeString, alias: Cosinger Name, length: 255 )
• cosigner_title ( type: esriFieldTypeString, alias: Cosigner Title, length: 255 )
• cosigner_phone ( type: esriFieldTypeString, alias: Cosigner Phone, length: 255 )
• cosigner_email ( type: esriFieldTypeString, alias: Cosigner Email, length: 255 )
• cosigner_date ( type: esriFieldTypeDate, alias: Cosigner Date, length: 8 )
• apptitle ( type: esriFieldTypeString, alias: Applicant Title, length: 255 )
• appfullname ( type: esriFieldTypeString, alias: Applicant Full Name, length: 255 )
• appsigndate ( type: esriFieldTypeDate, alias: Applicant Sign Date, length: 8 )
• appcomments ( type: esriFieldTypeString, alias: Applicant Comments, length: 1000 )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, length: 50 )
• app_ref_id ( type: esriFieldTypeGUID, alias: Application Ref ID, length: 38 )
• a_operator_id ( type: esriFieldTypeGUID, alias: A Operator ID, length: 38 )
• b_operator_id ( type: esriFieldTypeGUID, alias: B Operator ID, length: 38 )
• ownerid ( type: esriFieldTypeGUID, alias: Owner ID, length: 38 )
• location_contact_id ( type: esriFieldTypeGUID, alias: Location Contact ID, length: 38 )
• json_data ( type: esriFieldTypeString, alias: Additional Data, length: 1000 )
• parentglobalid ( type: esriFieldTypeGUID, alias: ActivityID, length: 38 )
• app_last_insp_dt ( type: esriFieldTypeDate, alias: Last Inspection Date, length: 8 )
• app_last_insp_typ ( type: esriFieldTypeString, alias: Last Inspection Type, length: 255 )
• app_last_insp_result ( type: esriFieldTypeString, alias: Last Inspection Result, length: 255 )
• app_facility_no ( type: esriFieldTypeString, alias: Facility No., length: 255 )
• app_tank_no ( type: esriFieldTypeString, alias: Tank No(s), length: 255 )
• updatekey ( type: esriFieldTypeString, alias: Update Key, length: 6 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• expiration_date ( type: esriFieldTypeDate, alias: Expiration Date, length: 8 )
• status_date ( type: esriFieldTypeDate, alias: Status Date, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• updating_facility_info ( type: esriFieldTypeString, alias: Updating Facility Info, length: 255 )
• updating_tank_info ( type: esriFieldTypeString, alias: Updating Facility Info, length: 255 )
• accela_hist_application_type ( type: esriFieldTypeString, alias: Accela Application Type, length: 2000 )
• accela_hist_h2_sys_type ( type: esriFieldTypeString, alias: Accela H2 System Type, length: 2000 )
• accela_hist_liquidfill_bypass ( type: esriFieldTypeString, alias: Accela Liquidfill Bypass Connection, length: 2000 )
• accela_hist_liquid_withdraw ( type: esriFieldTypeString, alias: Accela Liquid Withdraw Connection, length: 2000 )
• accela_hist_no_cylinders ( type: esriFieldTypeString, alias: Accela No of System Cylinders, length: 2000 )
• accela_hist_piping_install ( type: esriFieldTypeString, alias: Accela Piping Installation, length: 2000 )
• accela_hist_pump_install ( type: esriFieldTypeString, alias: Accela Pump Installation, length: 2000 )
• accela_hist_vapor_meter ( type: esriFieldTypeString, alias: Accela Vapor Equalizing Meter, length: 2000 )
• accela_hist_ventpipe ( type: esriFieldTypeString, alias: Accela Ventpipe Stackfrom, length: 2000 )

Relationships:

• LARA_SDE.LARA_ADMIN.tankStaging (6) -- Related To: Tank_Staging (41)
• LARA_SDE.LARA_ADMIN.documents (7) -- Related To: Documents (24)
• LARA_SDE.LARA_ADMIN.facilityStaging (9) -- Related To: Facility_Staging (44)
• LARA_SDE.LARA_ADMIN.tankSystemStaging (10) -- Related To: System_Staging (42)

Layer: Facility_Staging (44)

Name: Facility_Staging

Display Field: facility_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: -9441635.282887513
YMin: 5.664923641290895E-9
XMax: 6.327780442533911E-9
YMax: 5391197.1089606015
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [129, 147, 72, 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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• facility_no ( type: esriFieldTypeString, alias: Facility No, length: 255 )
• facility_name ( type: esriFieldTypeString, alias: Facility Name, length: 255 )
• facility_phone ( type: esriFieldTypeString, alias: Facility Phone Number, length: 15 )
• county ( type: esriFieldTypeString, alias: Facility County, length: 50 )
• epa_region ( type: esriFieldTypeString, alias: Facility EPA Region, length: 5 )
• tribal_site ( type: esriFieldTypeString, alias: Facility Tribal Site, length: 5 )
• tribe ( type: esriFieldTypeString, alias: Facility Tribe, length: 255 )
• facility_status ( type: esriFieldTypeString, alias: Facility Status, length: 35 )
• plan_review_no ( type: esriFieldTypeString, alias: Plan Review No., length: 255 )
• plan_review_dt ( type: esriFieldTypeDate, alias: Initial Approval Date, length: 8 )
• last_final_insp_dt ( type: esriFieldTypeDate, alias: Last Final Inspection Date, length: 8 )
• cont_info_public ( type: esriFieldTypeString, alias: Facility Contact Is Public, length: 5 )
• siteid ( type: esriFieldTypeGUID, alias: Site ID, 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• applicationid ( type: esriFieldTypeGUID, alias: Application ID, length: 38 )
• num_tanks ( type: esriFieldTypeSmallInteger, alias: # Tanks )
• fac1_txt ( type: esriFieldTypeString, alias: fac1_txt, length: 255 )
• fac2_txt ( type: esriFieldTypeString, alias: fac2_txt, length: 255 )
• fac3_txt ( type: esriFieldTypeString, alias: fac3_txt, length: 255 )
• fac4_txt ( type: esriFieldTypeString, alias: fac4_txt, length: 255 )
• fac5_txt ( type: esriFieldTypeString, alias: fac5_txt, length: 255 )
• fac1_int ( type: esriFieldTypeInteger, alias: fac1_int )
• fac2_int ( type: esriFieldTypeInteger, alias: fac2_int )
• fac3_int ( type: esriFieldTypeInteger, alias: fac3_int )
• fac4_int ( type: esriFieldTypeInteger, alias: fac4_int )
• fac5_int ( type: esriFieldTypeInteger, alias: fac5_int )
• fac1_dt ( type: esriFieldTypeDate, alias: fac1_dt, length: 8 )
• fac2_dt ( type: esriFieldTypeDate, alias: fac2_dt, length: 8 )
• fac3_dt ( type: esriFieldTypeDate, alias: fac3_dt, length: 8 )
• fac4_dt ( type: esriFieldTypeDate, alias: fac4_dt, length: 8 )
• fac5_dt ( type: esriFieldTypeDate, alias: fac5_dt, length: 8 )
• disp_station_typ ( type: esriFieldTypeString, alias: Type of Dispensing Station, length: 255 )
• num_systems ( type: esriFieldTypeSmallInteger, alias: # Systems )
• x ( type: esriFieldTypeDouble, alias: x )
• y ( type: esriFieldTypeDouble, alias: y )
• record_ref_guid ( type: esriFieldTypeGUID, alias: Record To Update, length: 38 )
• stagingtype ( type: esriFieldTypeString, alias: Staging Type, length: 25 )
• submittedby ( type: esriFieldTypeString, alias: Submitted By, length: 128 )
• facility_type ( type: esriFieldTypeString, alias: facility_type, length: 255 )
• location_contact_id ( type: esriFieldTypeGUID, alias: Location Contact ID, length: 38 )
• ownerid ( type: esriFieldTypeGUID, alias: Owner ID, length: 38 )
• expirationdt ( type: esriFieldTypeDate, alias: Expiration Date, length: 8 )
• program_region ( type: esriFieldTypeString, alias: Program Region, length: 255 )
• assigned_to ( type: esriFieldTypeString, alias: Assigned To, length: 255 )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, length: 50 )
• fac_insp_ref_id ( type: esriFieldTypeString, alias: Facility Inspection Ref ID, length: 255 )
• parentglobalid ( type: esriFieldTypeGUID, alias: ActivityID, length: 38 )
• fac_compliance_status ( type: esriFieldTypeString, alias: Facility Compliance Status, length: 255 )
• fac_last_insp_dt ( type: esriFieldTypeDate, alias: Facility Inspection Date, length: 8 )
• fac_last_insp_typ ( type: esriFieldTypeString, alias: Facility Inspection Type, length: 255 )
• fac_last_insp_result ( type: esriFieldTypeString, alias: Facility Inspection Result, length: 255 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• fr_reporting_year ( type: esriFieldTypeSmallInteger, alias: FR Reporting Year )
• fr_expiration_dt ( type: esriFieldTypeDate, alias: FR Expiration Date, length: 8 )
• fr_exempt ( type: esriFieldTypeString, alias: FR Exempt, length: 255 )
• fr_type_of_insurance ( type: esriFieldTypeString, alias: FR Type of Insurance, length: 255 )
• fr_revoked ( type: esriFieldTypeString, alias: FR Revoked, length: 255 )
• fr_revoked_year ( type: esriFieldTypeSmallInteger, alias: FR Revoked Year )
• fr_revoked_egle_dt ( type: esriFieldTypeDate, alias: FR Revoked Date EGLE, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• hmsi_full_name ( type: esriFieldTypeString, alias: HMSI Full Name, length: 255 )
• accela_hist_billing_code ( type: esriFieldTypeString, alias: Accela Billing Code, length: 255 )
• accela_hist_region ( type: esriFieldTypeString, alias: Accela Region, length: 255 )
• insp_ref_tank_no ( type: esriFieldTypeString, alias: insp_ref_tank_no, length: 1000 )
• accela_hist_billable_owner ( type: esriFieldTypeString, alias: Accela Billable Owners, length: 255 )
• accela_hist_owner_type ( type: esriFieldTypeString, alias: Accela Owner Type, length: 255 )
• address1 ( type: esriFieldTypeString, alias: Address 1, length: 255 )
• address2 ( type: esriFieldTypeString, alias: Address 2, length: 255 )
• city ( type: esriFieldTypeString, alias: City, length: 255 )
• state ( type: esriFieldTypeString, alias: State, length: 255 )
• zipcode ( type: esriFieldTypeString, alias: ZIP Code, length: 255 )

Relationships:

• LARA_SDE.LARA_ADMIN.applications (9) -- Related To: Application (3)

Layer: Request (4)

Name: Request

Display Field: pocname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5077341.100051548

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: -9845617.074932491
YMin: 5.664923641290895E-9
XMax: 6.327780442533911E-9
YMax: 5980578.246555881
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [117, 65, 155, 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:
• request_id ( type: esriFieldTypeString, alias: Request No, length: 255 )
• subtype ( type: esriFieldTypeString, alias: Request Subtype, length: 50 )
• details ( type: esriFieldTypeString, alias: Details, length: 4000 )
• locdesc ( type: esriFieldTypeString, alias: Location, length: 255 )
• pocname ( type: esriFieldTypeString, alias: Name, length: 150 )
• pocemail ( type: esriFieldTypeString, alias: Email, length: 100 )
• pocphone ( type: esriFieldTypeString, alias: Phone Number, length: 15 )
• source ( type: esriFieldTypeString, alias: Source, length: 150 )
• status ( type: esriFieldTypeString, alias: Status, length: 35 )
• resolution ( type: esriFieldTypeString, alias: Resolution, length: 1000 )
• resolutiondt ( type: esriFieldTypeDate, alias: Resolved On, length: 8 )
• workerid ( type: esriFieldTypeGUID, alias: Worker ID, length: 38 )
• tankid ( type: esriFieldTypeGUID, alias: Tank ID, length: 38 )
• facilityid ( type: esriFieldTypeGUID, alias: Facility ID, 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• rpt3_txt ( type: esriFieldTypeString, alias: rpt3_txt, length: 255 )
• rpt4_txt ( type: esriFieldTypeString, alias: rpt4_txt, length: 255 )
• rpt5_txt ( type: esriFieldTypeString, alias: rpt5_txt, length: 255 )
• rpt1_int ( type: esriFieldTypeInteger, alias: rpt1_int )
• rpt2_int ( type: esriFieldTypeInteger, alias: rpt2_int )
• rpt3_int ( type: esriFieldTypeInteger, alias: rpt3_int )
• rpt4_int ( type: esriFieldTypeInteger, alias: rpt4_int )
• rpt5_int ( type: esriFieldTypeInteger, alias: rpt5_int )
• rpt1_dt ( type: esriFieldTypeDate, alias: rpt1_dt, length: 8 )
• rpt2_dt ( type: esriFieldTypeDate, alias: rpt2_dt, length: 8 )
• rpt3_dt ( type: esriFieldTypeDate, alias: rpt3_dt, length: 8 )
• rpt4_dt ( type: esriFieldTypeDate, alias: rpt4_dt, length: 8 )
• rpt5_dt ( type: esriFieldTypeDate, alias: rpt5_dt, length: 8 )
• siteid ( type: esriFieldTypeGUID, alias: Site ID, length: 38 )
• systemid ( type: esriFieldTypeGUID, alias: System ID, length: 38 )
• applicationid ( type: esriFieldTypeGUID, alias: Application ID, length: 38 )
• assign_userid ( type: esriFieldTypeString, alias: Assign User ID, length: 255 )
• x ( type: esriFieldTypeDouble, alias: x )
• y ( type: esriFieldTypeDouble, alias: y )
• a_operator_id ( type: esriFieldTypeString, alias: A Operator ID, length: 38 )
• b_operator_id ( type: esriFieldTypeString, alias: B Operator ID, length: 38 )
• owner_id ( type: esriFieldTypeString, alias: Owner ID, length: 38 )
• submittedby ( type: esriFieldTypeString, alias: Submitted By, length: 128 )
• location_address ( type: esriFieldTypeString, alias: Location Address, length: 255 )
• epoch_created ( type: esriFieldTypeDouble, alias: epoch_created )
• request_type ( type: esriFieldTypeString, alias: request_type, length: 255 )
• reportid ( type: esriFieldTypeGUID, alias: Report ID, length: 38 )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, length: 50 )
• revisionid ( type: esriFieldTypeGUID, alias: RevisionID, length: 38 )
• parentglobalid ( type: esriFieldTypeGUID, alias: Activity ID, length: 38 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• status_date ( type: esriFieldTypeDate, alias: Status Date, length: 8 )
• submitdate ( type: esriFieldTypeDate, alias: Submit Date, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspectionid ( type: esriFieldTypeGUID, alias: InspectionID, length: 38 )

Relationships:

• LARA_SDE.LARA_ADMIN.documents (12) -- Related To: Documents (24)
• LARA_SDE.LARA_ADMIN.variances (13) -- Related To: Variances (8)

Layer: Tank_Staging (41)

Name: Tank_Staging

Display Field: tcp_imp_curr_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 6.327780442533911E-9
YMin: 5.664923641290895E-9
XMax: 6.327780442533911E-9
YMax: 5.664923641290895E-9
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [163, 78, 170, 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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• app_ref_no ( type: esriFieldTypeString, alias: App Number Reference, length: 40 )
• tank_planreview_no ( type: esriFieldTypeString, alias: Plan Review #, length: 255 )
• facility_no ( type: esriFieldTypeString, alias: Facility No, length: 255 )
• tank_no ( type: esriFieldTypeString, alias: Tank No., length: 255 )
• tank_type ( type: esriFieldTypeString, alias: Tank Type, length: 2 )
• tank_status ( type: esriFieldTypeString, alias: Tank Status, length: 35 )
• federally_regulated ( type: esriFieldTypeString, alias: Federally Regulated, length: 5 )
• comp_qty ( type: esriFieldTypeSmallInteger, alias: Compartment Qty )
• substance_form ( type: esriFieldTypeString, alias: Stored Form, length: 25 )
• tank_capacity_uom ( type: esriFieldTypeString, alias: Tank Capacity UOM, length: 25 )
• length_feet ( type: esriFieldTypeSmallInteger, alias: Length (FT) )
• width_feet ( type: esriFieldTypeSmallInteger, alias: Width (FT) )
• material_comment ( type: esriFieldTypeString, alias: Material Comments, length: 1000 )
• material_description ( type: esriFieldTypeString, alias: Material Description, length: 1000 )
• tank_wall_type ( type: esriFieldTypeString, alias: Tank Wall Type, length: 255 )
• airport_hyd_sys ( type: esriFieldTypeString, alias: Airport Hydrant System, length: 5 )
• emer_gen_ops ( type: esriFieldTypeString, alias: Emergency Generator Operations, length: 5 )
• field_constructed ( type: esriFieldTypeString, alias: Field Constructed, length: 5 )
• lined_tank ( type: esriFieldTypeString, alias: Lined Tank, length: 5 )
• excavation_liner ( type: esriFieldTypeString, alias: Excavation Liner, length: 5 )
• cert_of_installation ( type: esriFieldTypeString, alias: Cert Of Installation, length: 50 )
• tcp_sacr_anode ( type: esriFieldTypeString, alias: Tank Corrosion Protection Sacrificial Anode, length: 5 )
• tcp_anode_inst_retro ( type: esriFieldTypeString, alias: Tank Corrosion Protection Anode Installed Or Retrofitted, length: 5 )
• tcp_imp_curr ( type: esriFieldTypeString, alias: Tank Corrosion Protection Impressed Current, length: 5 )
• tcp_imp_curr_inst_retro ( type: esriFieldTypeString, alias: Tank Corrosion Protection Impressed Current Installed Or Retrofitted, length: 5 )
• tcp_cath_req ( type: esriFieldTypeString, alias: Tank Corrosion Protection Cathodic Not Required, length: 5 )
• tcp_inter_lining ( type: esriFieldTypeString, alias: Tank Corrosion Protection Interior Lining, length: 5 )
• tcp_other ( type: esriFieldTypeString, alias: Tank Corrosion Protection Other, length: 5 )
• tcp_unknown ( type: esriFieldTypeString, alias: Tank Corrosion Protection Unknown, length: 5 )
• tcp_lined_post_inst ( type: esriFieldTypeString, alias: Tank Corrosion Protection Lined Post installation, length: 5 )
• tcp_imp_curr_name ( type: esriFieldTypeString, alias: Tank Corrosion Protection Impressed Current Contractor Name, length: 255 )
• tcp_imp_curr_dt ( type: esriFieldTypeDate, alias: Tank Corrosion Protection Impressed Current Install Date, length: 8 )
• tcp_imp_curr_nace ( type: esriFieldTypeString, alias: Tank Corrosion Protection Impressed Current Cert Number, length: 40 )
• ball_float_valve ( type: esriFieldTypeString, alias: Ball Float Valve, length: 5 )
• flow_shutoff_dev ( type: esriFieldTypeString, alias: Flow Shutoff Device, length: 500 )
• high_level_alarm ( type: esriFieldTypeString, alias: High Level Alarm, length: 5 )
• spill_bucket_install ( type: esriFieldTypeString, alias: Spill Bucket Installed, length: 5 )
• spill_bucket_type ( type: esriFieldTypeString, alias: Spill Bucket Wall Type, length: 255 )
• drain_present ( type: esriFieldTypeString, alias: Drain Present, length: 5 )
• pump_present ( type: esriFieldTypeString, alias: Pump Present, length: 5 )
• tank_spill_prot ( type: esriFieldTypeString, alias: Spill Protection Details, length: 1000 )
• over_prot ( type: esriFieldTypeString, alias: Overflow Protection Details, length: 1000 )
• phys_prot ( type: esriFieldTypeString, alias: Physical/Collision Protection Method, length: 255 )
• im_continual_electric ( type: esriFieldTypeString, alias: Interstitial Monitoring Continual Electric, length: 5 )
• im_manual ( type: esriFieldTypeString, alias: Interstitial Monitoring Manual, length: 5 )
• 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 )
• american_suction ( type: esriFieldTypeString, alias: American Suction, length: 5 )
• gas_vol ( type: esriFieldTypeInteger, alias: Gaseous Volume )
• liq_vol ( type: esriFieldTypeInteger, alias: Liquid volume )
• applicationid ( type: esriFieldTypeGUID, alias: Application ID, length: 38 )
• atg_cont_leak_detect ( type: esriFieldTypeString, alias: Automatic Tank Gauging Continuous Leak Detection, length: 5 )
• atg_release_detection ( type: esriFieldTypeString, alias: Automatic Tank Gauging Release Detection, length: 5 )
• auto_inter_mon ( type: esriFieldTypeString, alias: Automated Intersticial Monitoring, length: 5 )
• auto_tank_gauge ( type: esriFieldTypeString, alias: Automatic Tank Gauging, length: 5 )
• closed_by ( type: esriFieldTypeString, alias: Tank Closed By, length: 128 )
• not_removed_comment ( type: esriFieldTypeString, alias: Closing Additional Info, length: 1000 )
• closed_fill ( type: esriFieldTypeString, alias: Fill Material, length: 255 )
• closure_dt ( type: esriFieldTypeDate, alias: Closure Date, length: 8 )
• closure_removalid ( type: esriFieldTypeGUID, alias: Closure/Removal Report ID, length: 38 )
• tank_comments ( type: esriFieldTypeString, alias: Additional Information, length: 4000 )
• documentid ( type: esriFieldTypeGUID, alias: Document ID, length: 38 )
• elec_line_leak ( type: esriFieldTypeString, alias: Electronic Line Leak, length: 5 )
• expirationdt ( type: esriFieldTypeDate, alias: Expiration Date, length: 8 )
• facility_siteid ( type: esriFieldTypeGUID, alias: Site ID, length: 38 )
• facilityid ( type: esriFieldTypeGUID, alias: Facility ID, length: 38 )
• fire_prot ( type: esriFieldTypeString, alias: Fire Protection Details, length: 255 )
• grd_water_monitor ( type: esriFieldTypeString, alias: Ground Water Monitoring, length: 5 )
• high_pressure ( type: esriFieldTypeString, alias: High Pressure, length: 5 )
• indoor ( type: esriFieldTypeString, alias: Indoor Fueling System, length: 5 )
• last_cos_date ( type: esriFieldTypeDate, alias: Change of Service Date, length: 8 )
• last_insp_dt ( type: esriFieldTypeDate, alias: Last Inspection Date, length: 8 )
• last_use_dt ( type: esriFieldTypeDate, alias: Last date used prior to COS, length: 8 )
• lined_dt ( type: esriFieldTypeDate, alias: Lining Date, length: 8 )
• man_tank_gauge ( type: esriFieldTypeString, alias: Manual Tank Gauging, length: 5 )
• mech_line_leak ( type: esriFieldTypeString, alias: Mechanical Line Leak, length: 5 )
• piping_cp_sacr_anode ( type: esriFieldTypeString, alias: Piping Corrosion Protection Sacrificial Anode, length: 5 )
• piping_cp_unknown ( type: esriFieldTypeString, alias: Piping Corrosion Protection Unknown, length: 5 )
• piping_flex_conn ( type: esriFieldTypeString, alias: Piping Flex Connector, length: 5 )
• tank_piping_inst_dt ( type: esriFieldTypeDate, alias: Pipe Install Date, length: 8 )
• tank_piping_repair_date ( type: esriFieldTypeDate, alias: Piping Repair Date, length: 8 )
• piping_sec_cont ( type: esriFieldTypeString, alias: Pipe Secondary Containment, length: 255 )
• piping_style ( type: esriFieldTypeString, alias: Piping Style, length: 255 )
• piping_supt_mat_desc ( type: esriFieldTypeString, alias: Piping Supports Material, length: 1000 )
• piping_udc ( type: esriFieldTypeString, alias: Piping UDC, length: 5 )
• piping_wall_type ( type: esriFieldTypeString, alias: Piping Wall Type, length: 50 )
• tank_piping_mat ( type: esriFieldTypeString, alias: Piping Material, length: 255 )
• tank_piping_mat_comment ( type: esriFieldTypeString, alias: Comment, length: 1000 )
• tank_piping_rel_det_comment ( type: esriFieldTypeString, alias: Comment, length: 1000 )
• tank_piping_rel_det ( type: esriFieldTypeString, alias: Piping Release Detection, length: 255 )
• tank_piping_repaired ( type: esriFieldTypeString, alias: Piping Repaired, length: 5 )
• tank_piping_repaired_comment ( type: esriFieldTypeString, alias: Comment, length: 1000 )
• tank_piping_subpart_k ( type: esriFieldTypeString, alias: Piping Subpart K, length: 5 )
• tank_piping_type ( type: esriFieldTypeString, alias: Piping Type, length: 255 )
• tank_plan_approval_dt ( type: esriFieldTypeDate, alias: Plan Approved On, length: 8 )
• tank_planreviewid ( type: esriFieldTypeGUID, alias: Plan Review App ID, length: 38 )
• tank_pri_over_prot ( type: esriFieldTypeString, alias: Overfill Protection - Primary, length: 255 )
• tank_pri_over_prot_inst_dt ( type: esriFieldTypeDate, alias: Install Date: Overfill Protection - Primary, length: 8 )
• tank_pri_rel_det ( type: esriFieldTypeString, alias: Primary Release Detection Type, length: 255 )
• tank_pri_spill_prot ( type: esriFieldTypeString, alias: Spill Protection - Primary, length: 255 )
• tank_pri_spill_prot_inst_dt ( type: esriFieldTypeDate, alias: Install Date: Spill Protection - Primary, length: 8 )
• prox_spacing ( type: esriFieldTypeString, alias: Proximity & Spacing, length: 255 )
• tank_rel_det ( type: esriFieldTypeString, alias: Compartent Release Detection, length: 255 )
• tank_rel_det_comment ( type: esriFieldTypeString, alias: Comment, length: 1000 )
• safe_suction ( type: esriFieldTypeString, alias: Safe Suction, length: 5 )
• tank_sec_overfill_prot ( type: esriFieldTypeString, alias: Overfill Protection - Secondary, length: 255 )
• tank_sec_over_prot_inst_dt ( type: esriFieldTypeDate, alias: Install Date: Overfill Protection - Secondary, length: 8 )
• tank_sec_rel_det_type ( type: esriFieldTypeString, alias: Second Release Detection Type, length: 255 )
• tank_sec_spill_prot ( type: esriFieldTypeString, alias: Spill Protection - Secondary, length: 255 )
• tank_sec_spill_prot_inst_dt ( type: esriFieldTypeDate, alias: Install Date: Spill Protection - Secondary, length: 8 )
• stat_inv_reconciliation ( type: esriFieldTypeString, alias: Tank release detection: statistical inventory reconciliation, length: 5 )
• subpart_k ( type: esriFieldTypeString, alias: Tank release detection: Subpart K, length: 5 )
• tank_substance ( type: esriFieldTypeString, alias: Substance, length: 255 )
• tagged ( type: esriFieldTypeString, alias: Tagged?, length: 255 )
• tank_subtype ( type: esriFieldTypeString, alias: Content Type, length: 255 )
• reg_fee ( type: esriFieldTypeDouble, alias: Registration Fee )
• repair_dt ( type: esriFieldTypeDate, alias: Tank Repair Date, length: 8 )
• repaired ( type: esriFieldTypeString, alias: Repaired?, length: 5 )
• tank_tight_test ( type: esriFieldTypeString, alias: Tank release detection: tank tightness testing with inventory control, length: 5 )
• vapor_monitor ( type: esriFieldTypeString, alias: Tank release detection: vapor monitoring, length: 5 )
• tank_variances ( type: esriFieldTypeString, alias: Variances?, length: 5 )
• spill_prot_fill_pipe ( type: esriFieldTypeString, alias: Spill Protection around fill pipe, length: 500 )
• anchored ( type: esriFieldTypeString, alias: Tank Anchorage, length: 5 )
• filled_onsite ( type: esriFieldTypeString, alias: Filled Onsite, length: 5 )
• prod_flow_prot ( type: esriFieldTypeString, alias: Poduct Flow Protection, length: 500 )
• sec_cont ( type: esriFieldTypeString, alias: Secondary Containment , length: 255 )
• piping_cp_anode_ir ( type: esriFieldTypeString, alias: If sacrifical anode, was it installed with tank or retrofitted?, length: 5 )
• piping_cp_cath_nr ( type: esriFieldTypeString, alias: Piping: cathodic protection not required, length: 5 )
• piping_cp_ext_coat ( type: esriFieldTypeString, alias: Piping: external coating, length: 5 )
• piping_cp_imp_curr ( type: esriFieldTypeString, alias: Piping: impressed current, length: 5 )
• piping_cp_imp_curr_ir ( type: esriFieldTypeString, alias: If impressed current, was it installed with the tank or retrofitted?, length: 5 )
• piping_cp_other ( type: esriFieldTypeString, alias: Piping: corrosion protection is other, length: 5 )
• inst_date ( type: esriFieldTypeDate, alias: Installation Date, length: 8 )
• anchorage_type ( type: esriFieldTypeString, alias: Anchoring of Tank, length: 255 )
• backfill_material ( type: esriFieldTypeString, alias: Backfill Material Surrounding Tank, length: 500 )
• burial_depth_coverage ( type: esriFieldTypeString, alias: Burial Depth Coverage, length: 500 )
• design_const_std ( type: esriFieldTypeString, alias: ${label_tank_cont} Design/Construction Standard, length: 500 )
• design_const_std_other ( type: esriFieldTypeString, alias: Please specify, length: 255 )
• inlet_outlet_cxn_labeled ( type: esriFieldTypeString, alias: Labeling of Container Inlet and Outlet Connection, length: 500 )
• piping_supts ( type: esriFieldTypeString, alias: Piping Supports, length: 5 )
• piping_supt_prot ( type: esriFieldTypeString, alias: Piping Support/Protection, length: 255 )
• spill_prot_load_unload_pts ( type: esriFieldTypeString, alias: Spill Protection - Loading/Unloading Points, length: 255 )
• supts_fdns ( type: esriFieldTypeString, alias: ${label_tank_cont} Supports/Foundations, length: 500 )
• tcp ( type: esriFieldTypeString, alias: Corrosion Protection for Tank, length: 5 )
• systemid ( type: esriFieldTypeGUID, alias: System ID, length: 38 )
• tank_location ( type: esriFieldTypeString, alias: Tank Location, length: 2000 )
• t2_txt ( type: esriFieldTypeString, alias: t2_txt, length: 255 )
• t3_txt ( type: esriFieldTypeString, alias: t3_txt, length: 255 )
• t4_txt ( type: esriFieldTypeString, alias: t4_txt, length: 255 )
• t5_txt ( type: esriFieldTypeString, alias: t5_txt, length: 255 )
• t1_int ( type: esriFieldTypeInteger, alias: t1_int )
• t2_int ( type: esriFieldTypeInteger, alias: t2_int )
• t3_int ( type: esriFieldTypeInteger, alias: t3_int )
• t4_int ( type: esriFieldTypeInteger, alias: t4_int )
• t5_int ( type: esriFieldTypeInteger, alias: t5_int )
• t1_dt ( type: esriFieldTypeDate, alias: t1_dt, length: 8 )
• t2_dt ( type: esriFieldTypeDate, alias: t2_dt, length: 8 )
• t3_dt ( type: esriFieldTypeDate, alias: t3_dt, length: 8 )
• t4_dt ( type: esriFieldTypeDate, alias: t4_dt, length: 8 )
• t5_dt ( type: esriFieldTypeDate, alias: t5_dt, length: 8 )
• tank_piping_inst_loc ( type: esriFieldTypeString, alias: Piping Install Location, length: 2 )
• plan_approval_dt ( type: esriFieldTypeDate, alias: Plan Approved On, length: 8 )
• piping_cp_desc ( type: esriFieldTypeString, alias: Piping Corrosion Protection Details, length: 1000 )
• latitude ( type: esriFieldTypeDouble, alias: Latitude )
• longitude ( type: esriFieldTypeDouble, alias: Longitude )
• anchorage_other ( type: esriFieldTypeString, alias: Anchor Type - Other, length: 255 )
• cath_prot_mon ( type: esriFieldTypeString, alias: Monitoring of Cathodic Protection?, length: 5 )
• cath_prot_mon_typ ( type: esriFieldTypeString, alias: Please Specify, length: 255 )
• fr_status ( type: esriFieldTypeString, alias: Financial Responsibility Status, length: 50 )
• fr_type ( type: esriFieldTypeString, alias: Financial Responsibility Type, length: 50 )
• leak_det ( type: esriFieldTypeString, alias: Leak Detection, length: 5 )
• leak_det_typ ( type: esriFieldTypeString, alias: Leak Detection Method, length: 255 )
• leak_det_typ_other ( type: esriFieldTypeString, alias: Leak Detection Method - Other, length: 255 )
• line_tight_test ( type: esriFieldTypeString, alias: Line Tightness Testing, length: 5 )
• over_prot_typ ( type: esriFieldTypeString, alias: Overfill Protection Type, length: 255 )
• over_prot_typ_other ( type: esriFieldTypeString, alias: Overfill Protection Type - Other, length: 255 )
• pipe_leak_det_typ ( type: esriFieldTypeString, alias: Pipe Leak Detection Methods, length: 255 )
• pipe_leak_det_typ_other ( type: esriFieldTypeString, alias: Pipe Leak Detection Methods - Other, length: 255 )
• piping_cp_typ ( type: esriFieldTypeString, alias: Piping Corrosion Protion Method, length: 255 )
• piping_cp_typ_other ( type: esriFieldTypeString, alias: Piping Corrosion Protion Method - Other, length: 255 )
• piping_cp_typ_other_1 ( type: esriFieldTypeString, alias: Piping Corrosion Protion Method - Other, length: 255 )
• piping_elec_line_leak ( type: esriFieldTypeString, alias: Electronic Line Leak Detectors, length: 5 )
• piping_mech_line_leak ( type: esriFieldTypeString, alias: Mechanical Line Leak Detectors, length: 5 )
• sec_cont_other ( type: esriFieldTypeString, alias: Secondary Containment - Other, length: 255 )
• sump_sensors ( type: esriFieldTypeString, alias: Sump Sensors, length: 5 )
• tank_im_typ ( type: esriFieldTypeString, alias: Interstitial Monitoring Method, length: 255 )
• tank_im_typ_other ( type: esriFieldTypeString, alias: Interstitial Monitoring Method - Other, length: 255 )
• tank_pipe_inlet_mat ( type: esriFieldTypeString, alias: Pipe Inlet Materials, length: 255 )
• tank_piping_fab_test_std ( type: esriFieldTypeString, alias: Fabricated and tested in accordance with ANSI/ASME, length: 5 )
• tank_piping_perf_std ( type: esriFieldTypeString, alias: Piping Performance Standard, length: 255 )
• tank_piping_perf_std_1 ( type: esriFieldTypeString, alias: Piping Performance Standard, length: 255 )
• tank_piping_ug ( type: esriFieldTypeString, alias: Buried piping meets the cathodic protection requirement, burial requirement and spacing. , length: 5 )
• tank_piping_ug_threaded ( type: esriFieldTypeString, alias: Threaded pipe underground?, length: 5 )
• tank_piping_vent_riser_mat_ht ( type: esriFieldTypeString, alias: Vent Riser Material & Height, length: 255 )
• tank_ug_vent_piping ( type: esriFieldTypeString, alias: Underground Vent Piping, length: 255 )
• tcp_desc ( type: esriFieldTypeString, alias: Tank Corrosion Protection Details, length: 500 )
• tcp_other_desc ( type: esriFieldTypeString, alias: Please specify, length: 255 )
• fr_year ( type: esriFieldTypeSmallInteger, alias: FR Reporting Year )
• fin_res_type ( type: esriFieldTypeString, alias: fin_res_type, length: 1000 )
• x ( type: esriFieldTypeDouble, alias: x )
• y ( type: esriFieldTypeDouble, alias: y )
• registration_date ( type: esriFieldTypeDate, alias: registration_date, length: 8 )
• renewal_date ( type: esriFieldTypeDate, alias: renewal_date, length: 8 )
• inspectionid ( type: esriFieldTypeGUID, alias: inspectionid, length: 38 )
• record_ref_guid ( type: esriFieldTypeGUID, alias: Record To Update, length: 38 )
• stagingtype ( type: esriFieldTypeString, alias: Staging Type, length: 25 )
• submittedby ( type: esriFieldTypeString, alias: Submitted By, length: 128 )
• epoch_created ( type: esriFieldTypeDouble, alias: epoch_created )
• a_operator_id ( type: esriFieldTypeGUID, alias: Class A Operator ID, length: 38 )
• b_operator_id ( type: esriFieldTypeGUID, alias: Class B Operator ID, length: 38 )
• tank_owner_id ( type: esriFieldTypeGUID, alias: Owner ID, length: 38 )
• resp_party_id ( type: esriFieldTypeGUID, alias: Responsible Party ID, length: 38 )
• tank_substance_other ( type: esriFieldTypeString, alias: Tank Substance Other, length: 255 )
• public_act ( type: esriFieldTypeString, alias: Public Act, length: 255 )
• manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 255 )
• tank_capacity ( type: esriFieldTypeDouble, alias: Tank Capacity )
• coord_source ( type: esriFieldTypeString, alias: Tank Coordinate Source, length: 255 )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, length: 50 )
• tank_insp_ref_id ( type: esriFieldTypeString, alias: Tank Inspection Ref ID, length: 255 )
• parentglobalid ( type: esriFieldTypeGUID, alias: ActivityID, length: 38 )
• tank_compliance_status ( type: esriFieldTypeString, alias: Tank Compliance Status, length: 255 )
• last_insp_typ ( type: esriFieldTypeString, alias: Last Inspection Type, length: 255 )
• last_insp_result ( type: esriFieldTypeString, alias: Last Incpection Result, length: 255 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• serial_number ( type: esriFieldTypeString, alias: Serial Number, length: 255 )
• manufacture_year ( type: esriFieldTypeSmallInteger, alias: Manufacture Year )
• accela_hist_billable_tank ( type: esriFieldTypeString, alias: Accela Billable Tank, length: 255 )
• accela_hist_region ( type: esriFieldTypeString, alias: Accela Region, length: 255 )
• accela_hist_rpf_exempt ( type: esriFieldTypeString, alias: Accela RPF Exempt, length: 255 )
• accela_hist_flcl_req_met ( type: esriFieldTypeString, alias: Accela FLCL Requirements Met, length: 255 )
• accela_hist_billable_owner ( type: esriFieldTypeString, alias: Accela Billable Owner, length: 255 )
• accela_hist_first_tank ( type: esriFieldTypeString, alias: Accela First Tank, length: 255 )
• accela_hist_inspect_approve ( type: esriFieldTypeString, alias: Accela Inspected & Approved, length: 255 )
• accela_hist_engineer_inspect ( type: esriFieldTypeString, alias: Accela Engineer Inspected, length: 255 )
• accela_hist_new_chan_upg ( type: esriFieldTypeString, alias: Accela New/Upgrade/Change in Service, length: 255 )
• accela_hist_nrt ( type: esriFieldTypeString, alias: Accela NRT Tank, length: 255 )
• accela_hist_sump_test ( type: esriFieldTypeString, alias: Accela Sump Test, length: 255 )
• accela_hist_owner_type ( type: esriFieldTypeString, alias: Accela Owner Type, length: 255 )
• accela_hist_change_in_service ( type: esriFieldTypeString, alias: Accela Change Service, length: 255 )
• accela_hist_tank_removed ( type: esriFieldTypeString, alias: Accela Tank Removed From Ground, length: 255 )
• accela_hist_tribe_name ( type: esriFieldTypeString, alias: Accela Name of Tribe, length: 255 )
• accela_hist_owned_tribe ( type: esriFieldTypeString, alias: Accela Owned By NA Tribe, length: 255 )
• accela_hist_comm_facility ( type: esriFieldTypeString, alias: Accela Type of Commercial Facility, length: 255 )
• accela_hist_notification_date ( type: esriFieldTypeString, alias: Accela Notification Date, length: 255 )
• accela_hist_registration_date ( type: esriFieldTypeDate, alias: Accela Registration Date, length: 8 )
• accela_hist_action_on_tank ( type: esriFieldTypeString, alias: Accela Action on Tank, length: 255 )
• accela_hist_comment_clarif ( type: esriFieldTypeString, alias: Accela Comments Clarfication, length: 255 )
• accela_hist_inert_filled ( type: esriFieldTypeString, alias: Accela Tank Filled with Inert Material, length: 255 )
• accela_hist_pipe_rel_detect ( type: esriFieldTypeString, alias: Accela Piping Release Detection, length: 2000 )
• accela_hist_rel_detect ( type: esriFieldTypeString, alias: Accela Release Detection, length: 255 )
• tank_change_type ( type: esriFieldTypeString, alias: Tank Change Type, length: 255 )
• alt_tank_no ( type: esriFieldTypeInteger, alias: Facility Assigned Tank No )

Relationships:

• LARA_SDE.LARA_ADMIN.tankCompartmentStaging (14) -- Related To: Compartment_Staging (43)
• LARA_SDE.LARA_ADMIN.applications (6) -- Related To: Application (3)

Tables:

Table: System_Staging (42)

Name: System_Staging

Display Field: tank_nos

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• num_tanks ( type: esriFieldTypeSmallInteger, alias: # Tanks )
• tank_nos ( type: esriFieldTypeString, alias: Tank #s, length: 1000 )
• sys_subtype ( type: esriFieldTypeString, alias: Subtype, length: 255 )
• sys_type ( type: esriFieldTypeString, alias: Where will this system be installed?, length: 20 )
• sys_status ( type: esriFieldTypeString, alias: System Status, length: 35 )
• sys_attended ( type: esriFieldTypeString, alias: Will this system be attended at all times?, length: 5 )
• sys_public_act ( type: esriFieldTypeString, alias: Select applicable public act, length: 255 )
• sys_content_type ( type: esriFieldTypeString, alias: What type of content will be stored?, length: 50 )
• sys_substance_form ( type: esriFieldTypeString, alias: In what form will the substance be stored?, length: 25 )
• sys_commercial ( type: esriFieldTypeString, alias: Will this system be for commerical use?, length: 5 )
• sys_primary_use ( type: esriFieldTypeString, alias: What is the primary use of the system?, length: 255 )
• sys_indoor_system ( type: esriFieldTypeString, alias: System Located Indoors?, length: 5 )
• sys_indoor_const_desc ( type: esriFieldTypeString, alias: Room Construction, length: 1000 )
• sys_indoor_gas_det_sys ( type: esriFieldTypeString, alias: Gas Detection Systems, length: 255 )
• sys_indoor_ventillation_typ ( type: esriFieldTypeString, alias: Ventillation, length: 255 )
• sys_capacity ( type: esriFieldTypeSmallInteger, alias: Total System Capacity )
• sys_cp ( type: esriFieldTypeString, alias: Is the system protected against corrosion?, length: 500 )
• sys_emer_breakaway_dev ( type: esriFieldTypeString, alias: Emergency Breakaway Device, length: 5 )
• sys_bldg_shutoff ( type: esriFieldTypeString, alias: Building Shutoff, length: 500 )
• sys_disp_equip_loc ( type: esriFieldTypeString, alias: Location of Dispensing Equipment, length: 255 )
• sys_disp_loc ( type: esriFieldTypeString, alias: Location of Dispenser, length: 255 )
• sys_emer_resp_plan ( type: esriFieldTypeString, alias: Emergency Response Plan, length: 500 )
• sys_disp_area ( type: esriFieldTypeString, alias: Area around and beneath dispenser, length: 500 )
• sys_area_marking ( type: esriFieldTypeString, alias: Area Markings, length: 500 )
• sys_bulkhead_or_equiv_install ( type: esriFieldTypeString, alias: Bulkhead or Equivalent?, length: 500 )
• sys_raincaps ( type: esriFieldTypeString, alias: Raincaps?, length: 500 )
• sys_haz_anal ( type: esriFieldTypeString, alias: Hazard Analysis, length: 500 )
• sys_signs ( type: esriFieldTypeString, alias: Signage, length: 500 )
• sys_spacing_tanks ( type: esriFieldTypeString, alias: Spacing - other tanks, length: 500 )
• sys_warn_signs ( type: esriFieldTypeString, alias: Warning Signs, length: 500 )
• sys_cath_prot_mon ( type: esriFieldTypeString, alias: Cathodic Protection Monitoring, length: 500 )
• sys_fire_emer_disconnect ( type: esriFieldTypeString, alias: Fire Extinguisher and Emergency Disconnect, length: 255 )
• sys_fire_ext ( type: esriFieldTypeString, alias: Fire Extinguisher, length: 500 )
• sys_fire_prot_id ( type: esriFieldTypeString, alias: Fire Protection and Identification, length: 255 )
• sys_static_prot ( type: esriFieldTypeString, alias: Static Protection, length: 500 )
• sys_phys_prot ( type: esriFieldTypeString, alias: Will all tanks be protected against Physical Hazards/Collisions ?, length: 5 )
• sys_phys_prot_typ ( type: esriFieldTypeString, alias: Select protection method, length: 500 )
• sys_tamp_prot ( type: esriFieldTypeString, alias: Will all tanks be protected against Tampering?, length: 5 )
• sys_tamp_prot_typ ( type: esriFieldTypeString, alias: Select protection method, length: 255 )
• sys_rel_det ( type: esriFieldTypeString, alias: Will the system have release detection?, length: 5 )
• sys_rel_det_typ ( type: esriFieldTypeString, alias: Select detection method(s), length: 255 )
• sys_pipe_rel_det ( type: esriFieldTypeString, alias: Will the system piping have release detection?, length: 5 )
• sys_pipe_rel_det_typ ( type: esriFieldTypeString, alias: Select detection method(s), length: 255 )
• sys_over_prot ( type: esriFieldTypeString, alias: Will the system be protected against Overfill?, length: 5 )
• sys_over_prot_typ ( type: esriFieldTypeString, alias: Select protection method(s), length: 500 )
• sys_spill_prot ( type: esriFieldTypeString, alias: Will the system be protected against Spills?, length: 5 )
• 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 )
• sys_no ( type: esriFieldTypeString, alias: System #, length: 255 )
• plan_reviewid ( type: esriFieldTypeGUID, alias: Plan Review ID, length: 38 )
• siteid ( type: esriFieldTypeGUID, alias: Site ID, length: 38 )
• facilityid ( type: esriFieldTypeGUID, alias: Facility ID, length: 38 )
• applicationid ( type: esriFieldTypeGUID, alias: Application ID, length: 38 )
• sys1_txt ( type: esriFieldTypeString, alias: sys1_txt, length: 255 )
• sys2_txt ( type: esriFieldTypeString, alias: sys2_txt, length: 255 )
• sys3_txt ( type: esriFieldTypeString, alias: sys3_txt, length: 255 )
• sys4_txt ( type: esriFieldTypeString, alias: sys4_txt, length: 255 )
• sys5_txt ( type: esriFieldTypeString, alias: sys5_txt, length: 255 )
• sys1_int ( type: esriFieldTypeInteger, alias: sys1_int )
• sys2_int ( type: esriFieldTypeInteger, alias: sys2_int )
• sys3_int ( type: esriFieldTypeInteger, alias: sys3_int )
• sys4_int ( type: esriFieldTypeInteger, alias: sys4_int )
• sys5_int ( type: esriFieldTypeInteger, alias: sys5_int )
• sys1_dt ( type: esriFieldTypeDate, alias: sys1_dt, length: 8 )
• sys2_dt ( type: esriFieldTypeDate, alias: sys2_dt, length: 8 )
• sys3_dt ( type: esriFieldTypeDate, alias: sys3_dt, length: 8 )
• sys4_dt ( type: esriFieldTypeDate, alias: sys4_dt, length: 8 )
• sys5_dt ( type: esriFieldTypeDate, alias: sys5_dt, length: 8 )
• sys_anti_siph_dev ( type: esriFieldTypeString, alias: Anti-Siphon Device, length: 255 )
• sys_apvd_breakaway_coupling ( type: esriFieldTypeString, alias: Approved Breakaway Coupling, length: 255 )
• sys_apvd_hose ( type: esriFieldTypeString, alias: Approved Hose, length: 255 )
• sys_bldgs_canopies ( type: esriFieldTypeString, alias: Are weather protective Buildings or Canopies planned?, length: 255 )
• sys_bldgs_canopies_gas_disp ( type: esriFieldTypeString, alias: Are the structures designed to disperse gas?, length: 255 )
• sys_bldgs_canopies_ncbm ( type: esriFieldTypeString, alias: Are the building materials noncombustible?, length: 255 )
• sys_bonding ( type: esriFieldTypeString, alias: Bonding, length: 255 )
• sys_breakaway_prot ( type: esriFieldTypeString, alias: Breakaway Protection, length: 255 )
• sys_field_const ( type: esriFieldTypeString, alias: Field Constructed, length: 255 )
• sys_bypass_piping ( type: esriFieldTypeString, alias: Bypass Piping, length: 255 )
• sys_cert_of_installation ( type: esriFieldTypeString, alias: Cert Of Installation, length: 255 )
• sys_colsn_prot ( type: esriFieldTypeString, alias: Will all tanks be protected against Collision?, length: 255 )
• sys_colsn_prot_typ ( type: esriFieldTypeString, alias: Select collision protection method used by ALL TANKS, length: 500 )
• sys_emer_gen_ops ( type: esriFieldTypeString, alias: Emergency Generator Operations, length: 255 )
• sys_fire_safe_anal ( type: esriFieldTypeString, alias: Storage Type, length: 255 )
• sys_fueling_filling ( type: esriFieldTypeString, alias: Fueling/Filling, length: 255 )
• sys_gas_vol ( type: esriFieldTypeInteger, alias: Gaseous Volume )
• sys_high_pressure ( type: esriFieldTypeString, alias: High Pressure, length: 255 )
• sys_indoor ( type: esriFieldTypeString, alias: System located indoors?, length: 255 )
• sys_indoor_const_ext_wall ( type: esriFieldTypeString, alias: At least one wall is external, length: 255 )
• sys_indoor_const_ext_wall_cnt ( type: esriFieldTypeSmallInteger, alias: # External Walls )
• sys_indoor_ventillation_desc ( type: esriFieldTypeString, alias: Ventillation Description, length: 255 )
• sys_indoor_vol ( type: esriFieldTypeInteger, alias: Indoor Volume )
• sys_install_validation ( type: esriFieldTypeString, alias: Installation Validation, length: 255 )
• sys_liq_vol ( type: esriFieldTypeInteger, alias: Liquid volume )
• sys_liq_xfr_pipe ( type: esriFieldTypeString, alias: Is Liquid Transfer Pipe diameter greater than .5 inches? , length: 255 )
• sys_liq_xfr_pipe_1 ( type: esriFieldTypeString, alias: Is Liquid Transfer Pipe diameter greater than .5 inches? , length: 255 )
• sys_man_restart_post_emer_sd ( type: esriFieldTypeString, alias: Manual Restart Following Emergency Shutdown, length: 255 )
• sys_pipe_cp_anode_ir ( type: esriFieldTypeString, alias: Piping Corrosion Protection Anode Installed Or Retrofitted, length: 255 )
• sys_pipe_cp_cath_nr ( type: esriFieldTypeString, alias: Piping Corrosion Protection Cathodic Not Required, length: 255 )
• sys_variances ( type: esriFieldTypeString, alias: Variances?, length: 255 )
• sys_pipe_cp_ext_coat ( type: esriFieldTypeString, alias: Piping Corrosion Protection External Coating, length: 255 )
• sys_pipe_cp_imp_curr ( type: esriFieldTypeString, alias: Piping Corrosion Protection Impressed Current, length: 255 )
• sys_pipe_cp_imp_curr_ir ( type: esriFieldTypeString, alias: Piping Corrosion Protection Impressed Current Installed Or Retrofitted, length: 255 )
• sys_pipe_cp_other ( type: esriFieldTypeString, alias: Piping Corrosion Protection Other, length: 255 )
• sys_pipe_cp_sacr_anode ( type: esriFieldTypeString, alias: Piping Corrosion Protection Sacrificial Anode, length: 255 )
• sys_pipe_cp_desc ( type: esriFieldTypeString, alias: Piping Corrosion Protection Details, length: 255 )
• sys_pipe_cp_unknown ( type: esriFieldTypeString, alias: Piping Corrosion Protection Unknown, length: 255 )
• sys_pipe_flex_conn ( type: esriFieldTypeString, alias: Piping Flex Connector, length: 255 )
• sys_pipe_install_date ( type: esriFieldTypeDate, alias: Pipe Install Date, length: 8 )
• sys_pipe_mat_desc ( type: esriFieldTypeString, alias: Piping Material Description, length: 255 )
• sys_pipe_repair_date ( type: esriFieldTypeDate, alias: Piping Repair Date, length: 8 )
• sys_pipe_sec_cont ( type: esriFieldTypeString, alias: Pipe Secondary Containment, length: 255 )
• sys_pipe_style ( type: esriFieldTypeString, alias: Piping Style, length: 255 )
• sys_pipe_supt_mat_desc ( type: esriFieldTypeString, alias: Piping Supports Material, length: 255 )
• sys_pipe_supts ( type: esriFieldTypeString, alias: Will the ${sys_piping_label} rest on supports?, length: 255 )
• sys_pipe_supts_1 ( type: esriFieldTypeString, alias: Will the ${sys_piping_label_1} rest on supports?, length: 255 )
• sys_pipe_supts_material ( type: esriFieldTypeString, alias: Pipe Support Material, length: 255 )
• sys_pipe_supts_material_1 ( type: esriFieldTypeString, alias: Pipe Support Material, length: 255 )
• sys_pipe_supts_material_oth ( type: esriFieldTypeString, alias: Please specify, length: 255 )
• sys_pipe_supts_material_oth_1 ( type: esriFieldTypeString, alias: Please specify, length: 255 )
• sys_pipe_udc ( type: esriFieldTypeString, alias: Piping UDC, length: 255 )
• sys_pipe_wall_type ( type: esriFieldTypeString, alias: Piping Wall Type, length: 255 )
• sys_piping ( type: esriFieldTypeString, alias: Piping, length: 255 )
• sys_piping_cp ( type: esriFieldTypeString, alias: Pipe Corrosion Protection Method, length: 255 )
• sys_piping_cp_1 ( type: esriFieldTypeString, alias: Pipe Corrosion Protection Method, length: 255 )
• sys_piping_install_loc ( type: esriFieldTypeString, alias: Install Location: ${sys_piping_label}, length: 255 )
• sys_piping_install_loc_1 ( type: esriFieldTypeString, alias: Install Location: ${sys_piping_label_1}, length: 255 )
• sys_piping_material ( type: esriFieldTypeString, alias: Piping Material, length: 500 )
• sys_piping_material_1 ( type: esriFieldTypeString, alias: Piping Material, length: 255 )
• sys_piping_material_other ( type: esriFieldTypeString, alias: Please specify, length: 255 )
• sys_piping_material_other_1 ( type: esriFieldTypeString, alias: Please specify, length: 255 )
• sys_piping_material_subtyp ( type: esriFieldTypeString, alias: Piping type, length: 255 )
• sys_piping_material_subtyp_1 ( type: esriFieldTypeString, alias: Piping type, length: 255 )
• sys_piping_repairedt ( type: esriFieldTypeString, alias: Piping Repaired, length: 255 )
• sys_piping_subpart_k ( type: esriFieldTypeString, alias: Piping Subpart K, length: 255 )
• sys_piping_supt_prot ( type: esriFieldTypeString, alias: Piping Support/Protection, length: 255 )
• sys_pres_rtg ( type: esriFieldTypeString, alias: Will all tanks have the same Pressure Rating?, length: 255 )
• sys_pri_rel_det_typ ( type: esriFieldTypeString, alias: Primary Release Detection Type, length: 255 )
• sys_prod_id_or_riser ( type: esriFieldTypeString, alias: Product ID or Riser, length: 255 )
• sys_prox_spacing ( type: esriFieldTypeString, alias: Container Proximity & Spacing, length: 255 )
• sys_pump_install ( type: esriFieldTypeString, alias: Pump Installation, length: 255 )
• sys_safe_suction ( type: esriFieldTypeString, alias: Safe Suction, length: 255 )
• sys_sec_rel_det_typ ( type: esriFieldTypeString, alias: Second Release Detection Type, length: 255 )
• sys_temp_cor_fill ( type: esriFieldTypeString, alias: Temperature-Corrected Fill, length: 255 )
• sys_vac_liq_lvl_mon ( type: esriFieldTypeString, alias: Vacuum/Liquid Level Monitoring, length: 255 )
• sys_ventillation_typ ( type: esriFieldTypeString, alias: Ventilation System, length: 255 )
• sys_spill_prot_typ ( type: esriFieldTypeString, alias: Select protection method(s), length: 255 )
• sys_sec_cont ( type: esriFieldTypeString, alias: Select Secondary Containment method, length: 255 )
• inspectionid ( type: esriFieldTypeGUID, alias: Inspection ID, length: 38 )
• sys_colsn_prot_typ_other ( type: esriFieldTypeString, alias: Collision Protection Method - Other, length: 255 )
• sys_spill_prot_load_unload ( type: esriFieldTypeString, alias: Load/Unload Spill Protection Method, length: 255 )
• vaporizer_anchored ( type: esriFieldTypeString, alias: Is the vaporizer anchored?, length: 5 )
• cmpsr_rtg ( type: esriFieldTypeString, alias: Compressor Rating, length: 255 )
• cmpsr_flow_rate ( type: esriFieldTypeString, alias: Compressor Flow Rate (SCFM), length: 255 )
• cmpsr_size ( type: esriFieldTypeString, alias: Compressor Size (CFM), length: 255 )
• sys_indoor_signs ( type: esriFieldTypeString, alias: Access doors have Warning Signs?, length: 5 )
• sys_pres_rel_dev ( type: esriFieldTypeString, alias: Pressure relief device on storage system terminates outdoors, upward, in safe direction?, length: 500 )
• sys_rel_det_sir_provider ( type: esriFieldTypeString, alias: Please specify SIR Provider, length: 255 )
• sys_rel_det_other ( type: esriFieldTypeString, alias: Describe other method, length: 255 )
• sys_pipe_rel_det_other ( type: esriFieldTypeString, alias: Describe other method, length: 255 )
• sys_pipe_rel_det_sir_provider ( type: esriFieldTypeString, alias: Please specify SIR Provider, length: 255 )
• disp_colsn_prot ( type: esriFieldTypeString, alias: Dispenser Collision Protection, length: 255 )
• sys_prod_flow_prot_type_other ( type: esriFieldTypeString, alias: Product Flow Protection Method - Other, length: 255 )
• sys_prod_flow_prot_type ( type: esriFieldTypeString, alias: Product Flow Protection Method, length: 255 )
• sys_prod_flow_prot ( type: esriFieldTypeString, alias: System Product Flow Protection?, length: 5 )
• sys_over_prot_typ_other ( type: esriFieldTypeString, alias: sys_over_prot_typ_other, length: 255 )
• station_subtype ( type: esriFieldTypeString, alias: station_subtype, length: 255 )
• station_type ( type: esriFieldTypeString, alias: station_type, length: 255 )
• station_type_other ( type: esriFieldTypeString, alias: station_type_other, length: 255 )
• svc_station_type ( type: esriFieldTypeString, alias: svc_station_type, length: 255 )
• facility_type ( type: esriFieldTypeString, alias: facility_type, length: 255 )
• facility_subtype ( type: esriFieldTypeString, alias: facility_subtype, length: 255 )
• facility_subtype_other ( type: esriFieldTypeString, alias: facility_subtype_other, length: 255 )
• record_ref_guid ( type: esriFieldTypeGUID, alias: Record To Update, length: 38 )
• stagingtype ( type: esriFieldTypeString, alias: Staging Type, length: 25 )
• submittedby ( type: esriFieldTypeString, alias: Public Submitted UserID, length: 128 )
• epoch_created ( type: esriFieldTypeDouble, alias: Epoch Created Milliseconds )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, length: 50 )
• expiration_dt ( type: esriFieldTypeDate, alias: Expiration Date, length: 8 )
• parentglobalid ( type: esriFieldTypeGUID, alias: Activity ID, length: 38 )
• sys_subtype_other ( type: esriFieldTypeString, alias: System Subtype Other, length: 255 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• LARA_SDE.LARA_ADMIN.applications (10) -- Related To: Application (3)

Table: Compartment_Staging (43)

Name: Compartment_Staging

Display Field: substance

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• comp_num ( type: esriFieldTypeSmallInteger, alias: Compartment Number )
• substance ( type: esriFieldTypeString, alias: Substance, length: 255 )
• capacity_units ( type: esriFieldTypeString, alias: Capacity UoM, length: 25 )
• release_detection ( type: esriFieldTypeString, alias: Compartent Release Detection, length: 255 )
• release_detection_comment ( type: esriFieldTypeString, alias: Comment, length: 1000 )
• piping_material ( type: esriFieldTypeString, alias: Piping Material, length: 255 )
• piping_material_comment ( type: esriFieldTypeString, alias: Comment, length: 1000 )
• piping_type ( type: esriFieldTypeString, alias: Piping Type, length: 255 )
• piping_repaired ( type: esriFieldTypeString, alias: Piping Repaired, length: 5 )
• piping_repaired_comment ( type: esriFieldTypeString, alias: Comment, length: 1000 )
• piping_release_detection ( type: esriFieldTypeString, alias: Piping Release Detection, length: 255 )
• piping_release_det_comment ( type: esriFieldTypeString, alias: Comment, length: 1000 )
• pri_overfill_prot ( type: esriFieldTypeString, alias: Overfill Protection - Primary, length: 255 )
• pri_overfill_prot_install_dt ( type: esriFieldTypeDate, alias: Install Date: Overfill Protection - Primary, length: 8 )
• sec_overfill_prot ( type: esriFieldTypeString, alias: Overfill Protection - Secondary, length: 255 )
• sec_overfill_prot_install_dt ( type: esriFieldTypeDate, alias: Install Date: Overfill Protection - Secondary, length: 8 )
• pri_spill_prot ( type: esriFieldTypeString, alias: Spill Protection - Primary, length: 255 )
• pri_spill_prot_install_dt ( type: esriFieldTypeDate, alias: Install Date: Spill Protection - Primary, length: 8 )
• sec_spill_prot ( type: esriFieldTypeString, alias: Spill Protection - Secondary, length: 255 )
• sec_spill_prot_install_dt ( type: esriFieldTypeDate, alias: Install Date: Spill Protection - Secondary, length: 8 )
• comments ( type: esriFieldTypeString, alias: Additional Information, length: 4000 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• applicationid ( type: esriFieldTypeGUID, alias: Application ID, 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 )
• tankid ( type: esriFieldTypeGUID, alias: tankid, length: 38 )
• record_ref_guid ( type: esriFieldTypeGUID, alias: Record To Update, length: 38 )
• stagingtype ( type: esriFieldTypeString, alias: Staging Type, length: 25 )
• submittedby ( type: esriFieldTypeString, alias: Public Submitted User, length: 128 )
• compartment_id ( type: esriFieldTypeGUID, alias: compartment_id, length: 38 )
• capacity ( type: esriFieldTypeDouble, alias: Capacity )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• parentglobalid ( type: esriFieldTypeGUID, alias: Activity ID, length: 38 )

Relationships:

• LARA_SDE.LARA_ADMIN.tankStaging (14) -- Related To: Tank_Staging (41)

Table: Documents (24)

Name: Documents

Display Field: documenttype

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• documenttype ( type: esriFieldTypeString, alias: Document Type, length: 255 )
• doc_reviewed ( type: esriFieldTypeString, alias: Document Reviewed, length: 255 )
• doc_store ( type: esriFieldTypeString, alias: Store Document, length: 255 )
• varianceid ( type: esriFieldTypeGUID, alias: Variance ID, length: 38 )
• tankid ( type: esriFieldTypeGUID, alias: Tank ID, length: 38 )
• facilityid ( type: esriFieldTypeGUID, alias: Facility ID, length: 38 )
• reportid ( type: esriFieldTypeGUID, alias: Report ID, length: 38 )
• requestid ( type: esriFieldTypeGUID, alias: Request ID, length: 38 )
• operatorid ( type: esriFieldTypeGUID, alias: Owner/Operator ID, length: 38 )
• ownerid ( type: esriFieldTypeGUID, alias: Owner/Operator ID, length: 38 )
• financial_logid ( type: esriFieldTypeGUID, alias: Financial Log ID, 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• applicationid ( type: esriFieldTypeGUID, alias: applicationid, length: 38 )
• parentglobalid ( type: esriFieldTypeGUID, alias: Activity ID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, length: 100 )
• systemid ( type: esriFieldTypeGUID, alias: SystemID, length: 38 )
• inspectionid ( type: esriFieldTypeGUID, alias: InspectionID, length: 38 )

Relationships:

• LARA_SDE.LARA_ADMIN.applications (7) -- Related To: Application (3)
• LARA_SDE.LARA_ADMIN.requests (12) -- Related To: Request (4)
• LARA_SDE.LARA_ADMIN.reports (5) -- Related To: Report (5)

Table: document__ATTACH (9024)

Name: document__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )
• 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 )
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, length: 100 )

Table: Complaint_Reports (26)

Name: Complaint_Reports

Display Field: complaintfirstname

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• reporttype ( type: esriFieldTypeGUID, alias: Report Type, length: 38 )
• description ( type: esriFieldTypeString, alias: Description, length: 255 )
• tankid ( type: esriFieldTypeGUID, alias: Tank ID, length: 38 )
• facilityid ( type: esriFieldTypeGUID, alias: Facilitiy Id, length: 38 )
• workerid ( type: esriFieldTypeGUID, alias: Worker ID, 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• reportid ( type: esriFieldTypeGUID, alias: Report ID, length: 38 )
• report_no ( type: esriFieldTypeString, alias: Report No., length: 255 )
• comptype ( type: esriFieldTypeString, alias: Complaint Type, length: 255 )
• ongoing ( type: esriFieldTypeString, alias: On Going, length: 255 )
• issuedate ( type: esriFieldTypeDate, alias: Issue Date, length: 8 )
• similarcomplaint ( type: esriFieldTypeString, alias: Similar Complaint, length: 255 )
• hmsi ( type: esriFieldTypeString, alias: HMSI, length: 255 )
• scopeofcomplaint ( type: esriFieldTypeString, alias: Scope of Complaint, length: 255 )
• equipment ( type: esriFieldTypeString, alias: Equipment, length: 255 )
• purpose ( type: esriFieldTypeString, alias: Purpose, length: 255 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• ispublic ( type: esriFieldTypeString, alias: Is Public, length: 255 )
• complaintfirstname ( type: esriFieldTypeString, alias: Complaintant First Name, length: 255 )
• complaintlastname ( type: esriFieldTypeString, alias: Complaintant Last Name, length: 255 )
• complaintphone ( type: esriFieldTypeString, alias: Complaintant Phone, length: 255 )
• complaintemail ( type: esriFieldTypeString, alias: Complaintant Email, length: 255 )
• complaintaddress ( type: esriFieldTypeString, alias: Complaintant Address, length: 255 )
• certified ( type: esriFieldTypeString, alias: Certified, length: 255 )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, length: 50 )
• parentglobalid ( type: esriFieldTypeGUID, alias: Activity ID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• LARA_SDE.LARA_ADMIN.reports (2) -- Related To: Report (5)

Table: Release_Reports (20)

Name: Release_Reports

Display Field: release_no

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• release_no ( type: esriFieldTypeString, alias: Release No., length: 255 )
• tank_no ( type: esriFieldTypeString, alias: Tank No, length: 255 )
• release_status ( type: esriFieldTypeString, alias: Release Status, length: 255 )
• release_substance ( type: esriFieldTypeString, alias: Substance Released, length: 255 )
• release_source ( type: esriFieldTypeString, alias: Source of release, length: 255 )
• release_source_other ( type: esriFieldTypeString, alias: Release Source Other, length: 255 )
• release_cause ( type: esriFieldTypeString, alias: Cause of release, length: 255 )
• release_cause_other ( type: esriFieldTypeString, alias: Release cause other, length: 255 )
• release_det_mth ( type: esriFieldTypeString, alias: Method of detection, length: 255 )
• leak_detection ( type: esriFieldTypeString, alias: leak_detection, length: 255 )
• leak_detection_other ( type: esriFieldTypeString, alias: leak_detection_other, length: 255 )
• release_comments ( type: esriFieldTypeString, alias: release_comments, length: 255 )
• reportid ( type: esriFieldTypeGUID, alias: Report ID, length: 38 )
• workerid ( type: esriFieldTypeGUID, alias: Worker ID, length: 38 )
• tankid ( type: esriFieldTypeGUID, alias: Tank ID, length: 38 )
• facilityid ( type: esriFieldTypeGUID, alias: Facility ID, length: 38 )
• site_assessmentid ( type: esriFieldTypeGUID, alias: Site Assessment ID, length: 38 )
• closure_removalid ( type: esriFieldTypeGUID, alias: Closure/Removal Report ID, 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• release_type ( type: esriFieldTypeString, alias: Report Type, length: 255 )
• systemid ( type: esriFieldTypeGUID, alias: System ID, length: 38 )
• contractor_name ( type: esriFieldTypeString, alias: Contractor Name, length: 255 )
• contractor_contact ( type: esriFieldTypeString, alias: Contractor Contact, length: 255 )
• contractor_phone ( type: esriFieldTypeString, alias: Contractor Phone, length: 255 )
• equip_related ( type: esriFieldTypeString, alias: Equipment Related, length: 255 )
• release_status_dt ( type: esriFieldTypeDate, alias: release_status_dt, length: 8 )
• release_discovered_date ( type: esriFieldTypeDate, alias: release_discovered_date, length: 8 )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, length: 50 )
• parentglobalid ( type: esriFieldTypeGUID, alias: Activity ID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• LARA_SDE.LARA_ADMIN.reports (3) -- Related To: Report (5)

Table: Site_Assessment_Reports (15)

Name: Site_Assessment_Reports

Display Field: facility_no

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• facility_no ( type: esriFieldTypeString, alias: Facility No, length: 255 )
• tank_no ( type: esriFieldTypeString, alias: Tank No., length: 255 )
• sketchscale ( type: esriFieldTypeString, alias: Sketch Scale, length: 100 )
• sampleid ( type: esriFieldTypeString, alias: Sample ID, length: 255 )
• sampledepth ( type: esriFieldTypeString, alias: Sample Depth, length: 255 )
• sampledepthuom ( type: esriFieldTypeString, alias: Unit of measure, length: 20 )
• samplecollectiondt ( type: esriFieldTypeDate, alias: Sample Collected On, length: 8 )
• samplesubmitteddt ( type: esriFieldTypeDate, alias: Sample Submitted On, length: 8 )
• sampleholdingtime ( type: esriFieldTypeSmallInteger, alias: Holding Time )
• samplepreparationdt ( type: esriFieldTypeDate, alias: Sample Preparation Date, length: 8 )
• sampleanalyzeddt ( type: esriFieldTypeDate, alias: Sample Analyzed Date, length: 8 )
• methodology ( type: esriFieldTypeString, alias: Test Methodology, length: 255 )
• units ( type: esriFieldTypeString, alias: Units, length: 10 )
• exceedsmdls ( type: esriFieldTypeString, alias: > MDLs, length: 5 )
• preservationmthd ( type: esriFieldTypeString, alias: Preservation Method, length: 40 )
• sampleshippedonice ( type: esriFieldTypeString, alias: Samples Shipped on Ice, length: 5 )
• photosreviewed ( type: esriFieldTypeString, alias: Photos Reviewed, length: 5 )
• haulingmanifestreviewed ( type: esriFieldTypeString, alias: Hauling Manifests Reviewed, length: 5 )
• registrationreviewed ( type: esriFieldTypeString, alias: Registration Form Reviewed, length: 5 )
• reportreviewed ( type: esriFieldTypeString, alias: HMSI Report Reviewed, length: 5 )
• determination ( type: esriFieldTypeString, alias: Determination, length: 4000 )
• notes ( type: esriFieldTypeString, alias: Notes, length: 4000 )
• recieveddt ( type: esriFieldTypeDate, alias: Received On, length: 8 )
• workerid ( type: esriFieldTypeGUID, alias: Worker ID, length: 38 )
• releaseid ( type: esriFieldTypeGUID, alias: Release Report ID, length: 38 )
• tankid ( type: esriFieldTypeGUID, alias: Tank ID, length: 38 )
• facilityid ( type: esriFieldTypeGUID, alias: Facility ID, length: 38 )
• closure_removalid ( type: esriFieldTypeGUID, alias: Closure/Removal Report ID, 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• reporttype ( type: esriFieldTypeString, alias: Report Type, length: 255 )
• reportid ( type: esriFieldTypeGUID, alias: Report ID, length: 38 )
• report_no ( type: esriFieldTypeString, alias: Report No., length: 255 )
• systemid ( type: esriFieldTypeGUID, alias: System ID, length: 38 )
• last_use_date ( type: esriFieldTypeDate, alias: Last Date Used, length: 8 )
• close_fill ( type: esriFieldTypeString, alias: Closure Fill, length: 255 )
• change_service_date ( type: esriFieldTypeDate, alias: Date Service Changed, length: 8 )
• associated_reportid ( type: esriFieldTypeString, alias: Associated Report ID, length: 100 )
• removed_from_ground ( type: esriFieldTypeString, alias: Removed From Ground, length: 10 )
• date_closed ( type: esriFieldTypeDate, alias: Date Closed, length: 8 )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, length: 50 )
• parentglobalid ( type: esriFieldTypeGUID, alias: Activity ID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• LARA_SDE.LARA_ADMIN.reports (4) -- Related To: Report (5)

Table: report__ATTACH (905)

Name: report__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )
• 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 )
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )

Table: Variances (8)

Name: Variances

Display Field: var_status

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• var_status ( type: esriFieldTypeString, alias: Status, length: 35 )
• var_type ( type: esriFieldTypeString, alias: Type, length: 255 )
• var_rule ( type: esriFieldTypeString, alias: Rule, length: 255 )
• var_desc ( type: esriFieldTypeString, alias: Description, length: 4000 )
• justification ( type: esriFieldTypeString, alias: Justification, length: 4000 )
• requested_dt ( type: esriFieldTypeDate, alias: Requested On, length: 8 )
• approval_dt ( type: esriFieldTypeDate, alias: Approved On, length: 8 )
• documentid ( type: esriFieldTypeGUID, alias: DocumentID, length: 38 )
• tankid ( type: esriFieldTypeGUID, alias: TankID, length: 38 )
• facilityid ( type: esriFieldTypeGUID, alias: FacilityID, 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• systemid ( type: esriFieldTypeGUID, alias: SystemID, length: 38 )
• record_id ( type: esriFieldTypeString, alias: Record #, length: 1000 )
• var_type_other ( type: esriFieldTypeString, alias: Please Specify, length: 255 )
• requestid ( type: esriFieldTypeGUID, alias: Request ID, length: 38 )
• parentglobalid ( type: esriFieldTypeGUID, alias: Activity ID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• LARA_SDE.LARA_ADMIN.requests (13) -- Related To: Request (4)

Table: request__ATTACH (904)

Name: request__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )
• 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 )
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )

Table: application__ATTACH (903)

Name: application__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )
• 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 )
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )

Table: Tank_Parts (11)

Name: Tank_Parts

Display Field: item_name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• item_install_loc ( type: esriFieldTypeString, alias: Install Location, length: 50 )
• item_name ( type: esriFieldTypeString, alias: Part, length: 255 )
• item_no ( type: esriFieldTypeString, alias: Part/Serial No., length: 255 )
• item_mfr ( type: esriFieldTypeString, alias: Manufacturer, length: 255 )
• item_details ( type: esriFieldTypeString, alias: Details, length: 4000 )
• parentglobalid ( type: esriFieldTypeGUID, alias: ParentID, length: 38 )
• 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 )
• applicationid ( type: esriFieldTypeGUID, alias: ApplicationID, length: 38 )
• ref_tank_nos ( type: esriFieldTypeString, alias: Tank #s, length: 255 )
• facilityid ( type: esriFieldTypeGUID, alias: FacilityID, length: 38 )
• tankid ( type: esriFieldTypeGUID, alias: TankID, length: 38 )
• systemid ( type: esriFieldTypeGUID, alias: SystemID, length: 38 )
• item_type ( type: esriFieldTypeString, alias: Item Type, length: 255 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Table: Tank_Action_Reports (51)

Name: Tank_Action_Reports

Display Field: installer_name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• description ( type: esriFieldTypeString, alias: Description, length: 255 )
• tankid ( type: esriFieldTypeGUID, alias: Tank ID, length: 38 )
• facilityid ( type: esriFieldTypeGUID, alias: Facilitiy Id, length: 38 )
• site_assessmentid ( type: esriFieldTypeGUID, alias: Site Assessment ID, 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• reportid ( type: esriFieldTypeGUID, alias: Report ID, length: 38 )
• action_type ( type: esriFieldTypeString, alias: Action Type, length: 50 )
• installer_name ( type: esriFieldTypeString, alias: Name of Installer, length: 255 )
• installer_address ( type: esriFieldTypeString, alias: Installer Address, length: 255 )
• installer_contact ( type: esriFieldTypeString, alias: Installer Contact Person, length: 255 )
• installer_contact_phone ( type: esriFieldTypeString, alias: Installer Contact Phone, length: 50 )
• installer_contact_email ( type: esriFieldTypeString, alias: Insaller Contact Email, length: 255 )
• piping_type ( type: esriFieldTypeString, alias: Piping Type Installed, length: 255 )
• replacement_date ( type: esriFieldTypeDate, alias: Replacement Date, length: 8 )
• pressure_test_date ( type: esriFieldTypeDate, alias: Pressure Test Date, length: 8 )
• installer_comment ( type: esriFieldTypeString, alias: Installer Comment, length: 1024 )
• pipe_removed ( type: esriFieldTypeString, alias: Piping Removed, length: 50 )
• gov_funded ( type: esriFieldTypeString, alias: Goverment Funded, length: 50 )
• installer_contact_ext ( type: esriFieldTypeString, alias: Installer Contact Extension, length: 50 )
• action_comment ( type: esriFieldTypeString, alias: Action Comment, length: 1024 )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, length: 50 )
• parentglobalid ( type: esriFieldTypeGUID, alias: Activity ID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• effective_date ( type: esriFieldTypeDate, alias: Effective Date, length: 8 )
• systemid ( type: esriFieldTypeGUID, alias: SystemID, length: 38 )

Relationships:

• LARA_SDE.LARA_ADMIN.reports (0) -- Related To: Report (5)

Table: Request_Comments (17)

Name: Request_Comments

Display Field: name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• title ( type: esriFieldTypeString, alias: Title, length: 100 )
• name ( type: esriFieldTypeString, alias: Name, length: 150 )
• address ( type: esriFieldTypeString, alias: Address, length: 255 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 4000 )
• instructions ( type: esriFieldTypeString, alias: Any Instructions, length: 1000 )
• actiontaken ( type: esriFieldTypeString, alias: Action Taken, length: 35 )
• publicview ( type: esriFieldTypeString, alias: Visible to Public, length: 5 )
• submitdate ( type: esriFieldTypeDate, alias: Submission Date, length: 8 )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• json_data ( type: esriFieldTypeString, alias: Additional Data, length: 1000 )
• requestid ( type: esriFieldTypeGUID, alias: Request ID, length: 38 )
• request_type ( type: esriFieldTypeString, alias: Request Type, length: 30 )
• parentglobalid ( type: esriFieldTypeGUID, alias: Activity ID, length: 38 )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, length: 50 )

Table: Log (59)

Name: Log

Display Field: tablename

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• tablename ( type: esriFieldTypeString, alias: Table Name, length: 255 )
• method ( type: esriFieldTypeString, alias: Method, length: 255 )
• message ( type: esriFieldTypeString, alias: Message, length: 4000 )
• 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 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Table: InspectionComments (32)

Name: InspectionComments

Display Field: name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• title ( type: esriFieldTypeString, alias: Title, length: 100 )
• name ( type: esriFieldTypeString, alias: Name, length: 150 )
• address ( type: esriFieldTypeString, alias: Address, length: 255 )
• organization ( type: esriFieldTypeString, alias: Organization, length: 50 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 4000 )
• instructions ( type: esriFieldTypeString, alias: Any Instructions, length: 1000 )
• actiontaken ( type: esriFieldTypeString, alias: Action Taken, length: 35 )
• publicview ( type: esriFieldTypeString, alias: Visible to Public, length: 5 )
• submitdate ( type: esriFieldTypeDate, alias: Submission Date, length: 8 )
• json_data ( type: esriFieldTypeString, alias: Additional Data, length: 1000 )
• inspection_type ( type: esriFieldTypeString, alias: Report Type, length: 30 )
• parentglobalid ( type: esriFieldTypeGUID, alias: Inspection ID, length: 38 )
• accela_ref_id ( type: esriFieldTypeString, alias: Accela Ref ID, 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 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Table: componentAttributes (16)

Name: componentAttributes

Display Field: attr_key

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• component_id ( type: esriFieldTypeGUID, alias: component_id, length: 38 )
• attr_key ( type: esriFieldTypeString, alias: attr_key, length: 100 )
• attr_value_text ( type: esriFieldTypeString, alias: attr_value_text, length: 4000 )
• attr_value_num ( type: esriFieldTypeDouble, alias: attr_value_num )
• attr_value_date ( type: esriFieldTypeDate, alias: attr_value_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• attribute_id ( type: esriFieldTypeGUID, alias: Attribute ID, 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 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• belongs to (16) -- Related To: components (10)

Table: componentAttributesStaging (23)

Name: componentAttributesStaging

Display Field: attr_key

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• component_id ( type: esriFieldTypeGUID, alias: component_id, length: 38 )
• attr_key ( type: esriFieldTypeString, alias: attr_key, length: 100 )
• attr_value_text ( type: esriFieldTypeString, alias: attr_value_text, length: 4000 )
• attr_value_num ( type: esriFieldTypeDouble, alias: attr_value_num )
• attr_value_date ( type: esriFieldTypeDate, alias: attr_value_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• record_ref_guid ( type: esriFieldTypeGUID, alias: Record To Update, length: 38 )
• stagingtype ( type: esriFieldTypeString, alias: Staging Type, length: 255 )
• submittedby ( type: esriFieldTypeString, alias: Submitted By, length: 255 )
• attribute_id ( type: esriFieldTypeGUID, alias: Attribute ID, 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 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• belongs to (17) -- Related To: componentsStaging (18)

Table: components (10)

Name: components

Display Field: parent_type

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• parent_type ( type: esriFieldTypeString, alias: parent_type, length: 20 , Coded Values: [facility: Facility] , [system: System] , [tank: Tank] , ...1 more... )
• parent_id ( type: esriFieldTypeGUID, alias: parent_id, length: 38 )
• type_code ( type: esriFieldTypeString, alias: type_code, length: 40 , Coded Values: [pressureRelief: Pressure Relief Device] , [valve: Valve] , [pressureGauge: Pressure Gauge] , ...2 more... )
• status_code ( type: esriFieldTypeString, alias: status_code, length: 20 , Coded Values: [active: Installed & Operational] , [removed: Removed] , [repaired: Repaired] , ...1 more... )
• install_loc ( type: esriFieldTypeString, alias: install_loc, length: 50 )
• serial_number ( type: esriFieldTypeString, alias: serial_number, length: 255 )
• manufacturer ( type: esriFieldTypeString, alias: manufacturer, length: 255 )
• installed_on ( type: esriFieldTypeDate, alias: installed_on, length: 8 )
• comments ( type: esriFieldTypeString, alias: comments, length: 4000 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• component_id ( type: esriFieldTypeGUID, alias: Component ID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• has value (16) -- Related To: componentAttributes (16)

Table: componentsStaging (18)

Name: componentsStaging

Display Field: parent_type

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• parent_type ( type: esriFieldTypeString, alias: parent_type, length: 20 , Coded Values: [facility: Facility] , [system: System] , [tank: Tank] , ...1 more... )
• parent_id ( type: esriFieldTypeGUID, alias: parent_id, length: 38 )
• type_code ( type: esriFieldTypeString, alias: type_code, length: 40 , Coded Values: [pressureRelief: Pressure Relief Device] , [valve: Valve] , [pressureGauge: Pressure Gauge] , ...2 more... )
• status_code ( type: esriFieldTypeString, alias: status_code, length: 20 , Coded Values: [active: Installed & Operational] , [removed: Removed] , [repaired: Repaired] , ...1 more... )
• install_loc ( type: esriFieldTypeString, alias: install_loc, length: 50 )
• serial_number ( type: esriFieldTypeString, alias: serial_number, length: 255 )
• manufacturer ( type: esriFieldTypeString, alias: manufacturer, length: 255 )
• installed_on ( type: esriFieldTypeDate, alias: installed_on, length: 8 )
• comments ( type: esriFieldTypeString, alias: comments, length: 4000 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• record_ref_guid ( type: esriFieldTypeGUID, alias: Record To Update, length: 38 )
• stagingtype ( type: esriFieldTypeString, alias: Staging Type, length: 255 )
• submittedby ( type: esriFieldTypeString, alias: Submitted By, length: 255 )
• component_id ( type: esriFieldTypeGUID, alias: Component ID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• has value (17) -- Related To: componentAttributesStaging (23)