Name: _qry_GIS_FACS_ExcelToTable

Display Field: FAC_Name

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FAC_Number (type: esriFieldTypeString, alias: FAC Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FAC_Type (type: esriFieldTypeString, alias: FAC Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FAC_Name (type: esriFieldTypeString, alias: FAC Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Rest_Facility (type: esriFieldTypeSmallInteger, alias: Rest Facility, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FAC_L_F (type: esriFieldTypeString, alias: FAC L&F, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Direction (type: esriFieldTypeString, alias: Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Road (type: esriFieldTypeString, alias: Road, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MM (type: esriFieldTypeString, alias: MM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Prior_Exit (type: esriFieldTypeString, alias: Prior Exit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LAT (type: esriFieldTypeDouble, alias: LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONG (type: esriFieldTypeDouble, alias: LONG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Contract (type: esriFieldTypeString, alias: Contract, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tblCONTRACT_contractorID (type: esriFieldTypeString, alias: tblCONTRACT_contractorID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FDOT_PM (type: esriFieldTypeString, alias: FDOT PM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FDOT_PM_Phone1 (type: esriFieldTypeString, alias: FDOT PM Phone1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FDOT_PM_Email (type: esriFieldTypeString, alias: FDOT PM Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEND_PM (type: esriFieldTypeString, alias: VEND PM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEND_PM_Phone1 (type: esriFieldTypeString, alias: VEND PM Phone1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEND_PM_EMAIL (type: esriFieldTypeString, alias: VEND PM EMAIL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FDOT_CM_Name (type: esriFieldTypeString, alias: FDOT CM Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FDOT_CM_Phone1 (type: esriFieldTypeString, alias: FDOT CM Phone1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FDOT_CM_Email (type: esriFieldTypeString, alias: FDOT CM Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEND_CM_Name (type: esriFieldTypeString, alias: VEND CM Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEND_CM_Phone1 (type: esriFieldTypeString, alias: VEND CM Phone1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEND_CM_Email (type: esriFieldTypeString, alias: VEND CM Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image_URL (type: esriFieldTypeString, alias: Image URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Full_Facility (type: esriFieldTypeSmallInteger, alias: Full Facility, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Nighttime_Security (type: esriFieldTypeSmallInteger, alias: Nighttime Security, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Family_Restroom (type: esriFieldTypeSmallInteger, alias: Family Restroom, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Adult_Changing_Table (type: esriFieldTypeSmallInteger, alias: Adult Changing Table, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Fenced_Dog_Area (type: esriFieldTypeSmallInteger, alias: Fenced Dog Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sun_Pass_Kiosk (type: esriFieldTypeSmallInteger, alias: Sun Pass Kiosk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vending_Machines (type: esriFieldTypeSmallInteger, alias: Vending Machines, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ATM (type: esriFieldTypeSmallInteger, alias: ATM, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: _qry_GIS_FACS_ExcelToTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/13/2024 3:20:51 PM

Schema Last Edit Date: 3/13/2024 3:20:51 PM

Data Last Edit Date: 3/13/2024 3:20:51 PM

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