Name: FM_GIS.sde.Facility_v
Display Field: FacilityName
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: ESRI_OID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- FacilityNumber (type: esriFieldTypeString, alias: FacilityNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- FacilityName (type: esriFieldTypeString, alias: FacilityName, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Owned (type: esriFieldTypeString, alias: Owned, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- FIPS (type: esriFieldTypeString, alias: FIPS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Hisoric (type: esriFieldTypeString, alias: Hisoric, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- YearBuilt (type: esriFieldTypeString, alias: YearBuilt, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- YearDemolished (type: esriFieldTypeInteger, alias: YearDemolished, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Institution (type: esriFieldTypeString, alias: Institution, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- GrossSF (type: esriFieldTypeString, alias: GrossSF, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- NetSF (type: esriFieldTypeString, alias: NetSF, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- NumberOfFloors (type: esriFieldTypeString, alias: NumberOfFloors, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ConstructionType (type: esriFieldTypeString, alias: ConstructionType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- StreetNumber (type: esriFieldTypeString, alias: StreetNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- DirectionPrefix (type: esriFieldTypeString, alias: DirectionPrefix, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- StreetName (type: esriFieldTypeString, alias: StreetName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- Designator (type: esriFieldTypeString, alias: Designator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- DirectionSuffix (type: esriFieldTypeString, alias: DirectionSuffix, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Ownership (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Agency (type: esriFieldTypeString, alias: Agency, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- OrigArch (type: esriFieldTypeString, alias: OrigArch, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- YearLastCapReno (type: esriFieldTypeString, alias: YearLastCapReno, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- PreservationPriority (type: esriFieldTypeString, alias: PreservationPriority, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- AcquisitionYear (type: esriFieldTypeInteger, alias: AcquisitionYear, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SchevDrawingName (type: esriFieldTypeInteger, alias: SchevDrawingName, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Latitude (type: esriFieldTypeString, alias: Latitude, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Longitude (type: esriFieldTypeString, alias: Longitude, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Northing (type: esriFieldTypeString, alias: Northing, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Easting (type: esriFieldTypeString, alias: Easting, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Alias (type: esriFieldTypeString, alias: Alias, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- LEEDStatus (type: esriFieldTypeString, alias: LEEDStatus, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ZipCode (type: esriFieldTypeString, alias: ZipCode, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Addr1 (type: esriFieldTypeString, alias: Addr1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Addr2 (type: esriFieldTypeString, alias: Addr2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Bldg_city (type: esriFieldTypeString, alias: Bldg_city, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Bldg_state_code (type: esriFieldTypeString, alias: Bldg_state_code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- DateUpdated (type: esriFieldTypeDate, alias: DateUpdated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- EditClerk (type: esriFieldTypeString, alias: EditClerk, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ESRI_OID (type: esriFieldTypeOID, alias: ESRI_OID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
Templates:
Name: FM_GIS.sde.Facility_v
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 2/6/2024 9:40:35 PM
Schema Last Edit Date: 2/6/2024 9:40:35 PM
Data Last Edit Date: 2/6/2024 9:40:35 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat