View In:   ArcGIS Online Map Viewer

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

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

Templates:

• Name: Facility_Staging
  Description:
  Prototype:
  state: null
  facility_no: null
  facility_name: null
  facility_phone: null
  county: null
  epa_region: null
  tribal_site: null
  tribe: null
  facility_status: null
  plan_review_no: null
  plan_review_dt: null
  last_final_insp_dt: null
  cont_info_public: null
  siteid: null
  address2: null
  address1: null
  accela_hist_owner_type: null
  accela_hist_billable_owner: null
  zipcode: null
  applicationid: null
  num_tanks: null
  fac1_txt: null
  fac2_txt: null
  fac3_txt: null
  fac4_txt: null
  fac5_txt: null
  fac1_int: null
  fac2_int: null
  fac3_int: null
  fac4_int: null
  fac5_int: null
  fac1_dt: null
  fac2_dt: null
  fac3_dt: null
  fac4_dt: null
  fac5_dt: null
  disp_station_typ: null
  num_systems: null
  x: 0
  y: 0
  record_ref_guid: null
  stagingtype: null
  submittedby: null
  facility_type: null
  location_contact_id: null
  ownerid: null
  expirationdt: null
  program_region: null
  assigned_to: null
  accela_ref_id: null
  fac_insp_ref_id: null
  parentglobalid: null
  fac_compliance_status: null
  fac_last_insp_dt: null
  fac_last_insp_typ: null
  fac_last_insp_result: null
  fr_reporting_year: null
  fr_expiration_dt: null
  fr_exempt: null
  fr_type_of_insurance: null
  fr_revoked: null
  fr_revoked_year: null
  fr_revoked_egle_dt: null
  city: null
  hmsi_full_name: null
  accela_hist_billing_code: null
  accela_hist_region: null
  insp_ref_tank_no: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

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

Capabilities: Create,Update,Uploads,Editing,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

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

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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