Name: SAFE_Charger_Table

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• siteID_ref (type: esriFieldTypeString, alias: Reference - Agency Site ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• autogenID_ref (type: esriFieldTypeString, alias: Reference - Site ID GUID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• agency_chosen_ref (type: esriFieldTypeString, alias: Reference - Agency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ufi_ref (type: esriFieldTypeString, alias: Reference - UFI, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• type_charger (type: esriFieldTypeString, alias: Charger Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [L2: L2 (240 V)], [DCFC: DCFC (480 V)])
• num_charger (type: esriFieldTypeInteger, alias: Number of Chargers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• num_l2 (type: esriFieldTypeInteger, alias: Number L2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• num_dcfc (type: esriFieldTypeInteger, alias: Number DCFC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• make (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ABB: ABB], [Blink: Blink (SemaConnect)], [BTC: BTC Power], ... 14 more ...)
• make_other (type: esriFieldTypeString, alias: Manufacturer (Other), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• model (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CT4021: CT 4021], [CPE250: CPE250], [EV2020: EV Arc 2020 Base], ... 8 more ...)
• model_other (type: esriFieldTypeString, alias: Model (Other), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• serial (type: esriFieldTypeString, alias: Serial Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vendor (type: esriFieldTypeString, alias: Vendor Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vendor_phone (type: esriFieldTypeString, alias: Vendor Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vendor_email (type: esriFieldTypeString, alias: Vendor Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vendor_website (type: esriFieldTypeString, alias: Vendor Website, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• is_workplace (type: esriFieldTypeString, alias: Workplace, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• charging_capacity (type: esriFieldTypeDouble, alias: Charging Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• is_wireless (type: esriFieldTypeString, alias: Wireless Inductive Charger, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])
• energy_used (type: esriFieldTypeString, alias: Renewable Energy Used, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Geothermal: Geothermal], [Hydro: Hydropower], [Landfill: Landfill], ... 5 more ...)
• ev_network (type: esriFieldTypeString, alias: EV Network, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ABB: ABB], [BN: Blink (SemaConnect)], [BTC: BTC Power], ... 8 more ...)
• network_other (type: esriFieldTypeString, alias: EV Network (Other), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• network_phone (type: esriFieldTypeString, alias: Network Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• network_email (type: esriFieldTypeString, alias: Network Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• network_website (type: esriFieldTypeString, alias: Network Website, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• available_time (type: esriFieldTypeString, alias: Network Contact Availability, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• warranty_yes (type: esriFieldTypeString, alias: Warranty or Service Contract, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes], [Unk: Unknown])
• warranty_expiration_date (type: esriFieldTypeDate, alias: Warranty Expiration Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• warranty_org (type: esriFieldTypeString, alias: Warranty Organization, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• warranty_phone (type: esriFieldTypeString, alias: Warranty Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• warranty_email (type: esriFieldTypeString, alias: Warranty Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• warranty_coverage_detail (type: esriFieldTypeString, alias: Other Warranty Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• funding_source (type: esriFieldTypeString, alias: Funding Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• service_date (type: esriFieldTypeDate, alias: In Service or Commissioned Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• max_vehicle (type: esriFieldTypeString, alias: Heaviest Vehicle Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [LD: LD - Class 1-2 vehicles, <1000, passenger car, utility van, minivan, full size pickup], [MD: MD - Class 3-6 trucks, 10001-26000 GVWR, large walk-in, city delivery truck, beverage truck], [HD: HD - Class 7-8 trucks, >26000])
• choose_port (type: esriFieldTypeString, alias: Port Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Single: Single], [Dual: Dual])
• num_ports_single (type: esriFieldTypeInteger, alias: Number Single Ports, SQL Type: sqlTypeOther, nullable: true, editable: true)
• num_ports_dual (type: esriFieldTypeInteger, alias: Number Dual Ports, SQL Type: sqlTypeOther, nullable: true, editable: true)
• connector_type (type: esriFieldTypeString, alias: Connector Types, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [J1772: J1772], [CHA: CHAdeMO], [NACS: NACS (Tesla)], ... 3 more ...)
• status (type: esriFieldTypeString, alias: Port Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Existing: Existing (In-Operation)/Available], [Planned: Planned], [Construction: Under-Construction], ... 5 more ...)
• outofservice_status (type: esriFieldTypeString, alias: Out of Service Duration, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• outofservice_fix (type: esriFieldTypeString, alias: Back in Service Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• power_calculated (type: esriFieldTypeString, alias: Power Calculated, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])
• power_calc_j1772 (type: esriFieldTypeString, alias: Power Calculated J1772, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])
• power_calc_ccs (type: esriFieldTypeString, alias: Power Calculated CCS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])
• power_calc_cha (type: esriFieldTypeString, alias: Power Calculated CHAdeMO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])
• access_days_time (type: esriFieldTypeString, alias: Access 24 Hours a Day, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• access_whenopen (type: esriFieldTypeString, alias: Port Open Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• access_whenclose (type: esriFieldTypeString, alias: Port Close Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• who_can_use (type: esriFieldTypeString, alias: Who Can Use Port, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Any_State_Agency_Fleet_Only: Any State Agency (Fleet Only)], [Any_State_Agency_Fleet_and_Employee: Any State Agency (Fleet & Employee)], [Listed_Agency_Fleet_Only: Listed Agency (Fleet Only)], ... 2 more ...)
• multiple_agency (type: esriFieldTypeString, alias: Agencies with Access to Port, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• multiple_agency_other (type: esriFieldTypeString, alias: Agencies with Access to Port (Other), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• restrict_access (type: esriFieldTypeString, alias: Restricted Access, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• type_restrict_access (type: esriFieldTypeString, alias: Restricted Access Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Call_Ahead: Call ahead], [Key_After: Card key after hours], [Key_Always: Card key at all times], ... 6 more ...)
• restrict_access_other (type: esriFieldTypeString, alias: Restricted Access Type (Other), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fleet_allowed (type: esriFieldTypeString, alias: Which Fleets Can Refuel, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• charging_cost (type: esriFieldTypeDouble, alias: Electric charging price, SQL Type: sqlTypeOther, nullable: true, editable: true)
• accepted_payment (type: esriFieldTypeString, alias: Payment Methods, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Amex: American Express], [Android_Pay: Android Pay], [Apple_Pay: Apple Pay], ... 8 more ...)
• payment_other (type: esriFieldTypeString, alias: Payment Methods (Other), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dual_match (type: esriFieldTypeString, alias: Is the information the same for both ports?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• connector_type_dual (type: esriFieldTypeString, alias: Connector Types (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [J1772: J1772], [CHA: CHAdeMO], [NACS: NACS (Tesla)], ... 3 more ...)
• status_dual (type: esriFieldTypeString, alias: Port Status (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Existing: Existing (In-Operation)/Available], [Planned: Planned], [Construction: Under-Construction], ... 5 more ...)
• outofservice_status_dual (type: esriFieldTypeString, alias: Out of Service Duration (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• outofservice_fix_dual (type: esriFieldTypeString, alias: Back in Service Date (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• power_calculated_dual (type: esriFieldTypeString, alias: Power Calculated (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])
• power_calc_j1772_dual (type: esriFieldTypeString, alias: Power Calculated J1772 (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])
• power_calc_ccs_dual (type: esriFieldTypeString, alias: Power Calculated CCS (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])
• power_calc_cha_dual (type: esriFieldTypeString, alias: Power Calculated CHAdeMO (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown])
• access_days_time_dual (type: esriFieldTypeString, alias: Access 24 Hours a Day (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• access_whenopen_dual (type: esriFieldTypeString, alias: Port Open Time (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• access_whenclose_dual (type: esriFieldTypeString, alias: Port Close Time (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• who_can_use_dual (type: esriFieldTypeString, alias: Who Can Use Port (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Any_State_Agency_Fleet_Only: Any State Agency (Fleet Only)], [Any_State_Agency_Fleet_and_Employee: Any State Agency (Fleet & Employee)], [Listed_Agency_Fleet_Only: Listed Agency (Fleet Only)], ... 2 more ...)
• multiple_agency_dual (type: esriFieldTypeString, alias: Agencies with Access to Port (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• multiple_agency_dual_other (type: esriFieldTypeString, alias: Agencies with Access to Port (Other) (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• restrict_access_dual (type: esriFieldTypeString, alias: Restricted Access (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• type_restrict_access_dual (type: esriFieldTypeString, alias: Restricted Access Type (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Call_Ahead: Call ahead], [Key_After: Card key after hours], [Key_Always: Card key at all times], ... 6 more ...)
• restrict_access_other_dual (type: esriFieldTypeString, alias: Restricted Access Type (Other) (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fleet_allowed_dual (type: esriFieldTypeString, alias: Which Fleets Can Refuel (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• charging_cost_dual (type: esriFieldTypeDouble, alias: Electric charging price (Dual), SQL Type: sqlTypeOther, nullable: true, editable: true)
• accepted_payment_dual (type: esriFieldTypeString, alias: Payment Methods (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Amex: American Express], [Android_Pay: Android Pay], [Apple_Pay: Apple Pay], ... 8 more ...)
• payment_other_dual (type: esriFieldTypeString, alias: Payment Methods (Other) (Dual), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• comment_charger (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)

Relationships:

• State_Agency_Fleet_EVSE_XSAFEX_Tool_XUATX_SAFE_Charger_Table (1) -- Related To: State Agency Fleet EVSE (SAFE) Tool (UAT) (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/2/2025 3:18:54 PM

Schema Last Edit Date: 7/2/2025 3:18:54 PM

Data Last Edit Date: 7/2/2025 3:18:54 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat