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)

Supported Operations:   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata