View In:   ArcGIS Online Map Viewer

Name: Support Post

Display Field: GEODBID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: OBJECTID: System-generated unique identifier for each record within the feature classGEODBID: Three-digit code that assigns editing responsibility to a community in the GIS ConsortiumFEATUREID: GIS-Consortium-generated unique identifier for each record within the feature class. All FEATUREIDs start with the GEODBID of the community that owns the record.DATECREATED: Date/time stamp from the moment the GIS record was createdDATEMODIFIED: Date/time stamp from the last moment the GIS record was changedSOURCE: Organization that provided the data. The GIS Consortium standard is to preface the source with the three-letter municipal code of the community providing the data, followed by a dash. Example: VGV-Public WorksSOURCETYPE: Accuracy context for the recordGlobalID: System-generated unique identifier for each record that is required in replicated geodatabasesPRODUCTIONNOTES: Technical notes from GIS personnelREPLICAFILTER: Code used to filter data for the creation of custom geodatabasesSTRUCTURETYPE:The type of support structureSTRUCTUREMATERIAL: Material the support structure is made out ofHEIGHT: Total measurement from base to top, including any ornaments, signs, or other attachments; measured in feetLENGTH: Length of the support; measured in inchesWIDTH: Measurement of the support from side to side; measured in inchesCONDITION: Current state of the real-world feature, e.g. good, fair, poorOWNERSHIP: Organization with jurisdiction over the real-world feature represented in the feature classMAINTAINED: Organization responsible for the care of the real-world feature represented in the feature classINSTALLDATE: Date of installation for the real-world feature represented in the feature classLOCATION: Statement illustrating the whereabouts of a featureSTRUCTURESTATUS: The current status of the support pointLIGHTED: Whether or not the structure is lightedREFLECTIVE: Whether or not the support point has reflective featuresCOLOR: The color of the supportNUMBEROFSUPPORTS: Total number of supportsFOUNDATIONTYPE: Material type of the foundationCOMMUNITYID: Unique identifying code selected by the communityUTILITYID: Unique identifier for the utility system in which the feature participatesSTRUCTURESTYLE: Whether the structure is plain or ornamentedDESCRIPTION: Statement illustrating the featureMANUFACTURER: The manufacturer of the equipmentMANUFACTUREDATE: Date the support was physically createdTREATMENTTYPE: The type of treatment used on the support pointHASELECTRICALMETER: Designates if the support feature has a mounted electrical meter.NUMBEROFARMS: Total number of arms supported by the feature.SHAPE: System-generated geometry type of the feature

Copyright Text: Created by the GIS Consortium's members with ongoing updates.

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 12000

Max Scale: 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: -17463800
YMin: -46132600
XMax: 1190876.0637499988
YMax: 2149725.0759999976
Spatial Reference: 102671  (3435)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GEODBID ( type: esriFieldTypeString, alias: GEODBID, editable: true, nullable: true, length: 3, defaultValue: 999, modelName: GEODBID , Coded Values: [001: CHP] , [002: VGC] , [003: CPR] , ...82 more... )
• FEATUREID ( type: esriFieldTypeString, alias: FEATUREID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FEATUREID )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATEMODIFIED )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SOURCE )
• SOURCETYPE ( type: esriFieldTypeString, alias: SOURCETYPE, editable: true, nullable: true, length: 20, defaultValue: UNKNOWN, modelName: SOURCETYPE , Coded Values: [ASBUILT: As-built] , [DATABASE: Database] , [ESTIMATED: Estimated] , ...12 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• PRODUCTIONNOTES ( type: esriFieldTypeString, alias: PRODUCTIONNOTES, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PRODUCTIONNOTES )
• REPLICAFILTER ( type: esriFieldTypeString, alias: REPLICAFILTER, editable: true, nullable: true, length: 255, defaultValue: UNSET, modelName: REPLICAFILTER )
• STRUCTURETYPE ( type: esriFieldTypeString, alias: STRUCTURETYPE, editable: true, nullable: true, length: 20, defaultValue: UNKNOWN, modelName: STRUCTURETYPE , Coded Values: [ANCHOR: Anchor] , [BOLLARD: Bollard] , [BRIDGE: Bridge] , ...17 more... )
• STRUCTUREMATERIAL ( type: esriFieldTypeString, alias: STRUCTUREMATERIAL, editable: true, nullable: true, length: 20, defaultValue: UNKNOWN, modelName: STRUCTUREMATERIAL , Coded Values: [ALUMINUM: Aluminum] , [CONCRETE: Concrete] , [OTHER: Other] , ...6 more... )
• HEIGHT ( type: esriFieldTypeDouble, alias: HEIGHT, editable: true, nullable: true, defaultValue: 0, modelName: HEIGHT )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH, editable: true, nullable: true, defaultValue: 0, modelName: LENGTH )
• WIDTH ( type: esriFieldTypeDouble, alias: WIDTH, editable: true, nullable: true, defaultValue: 0, modelName: WIDTH )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, editable: true, nullable: true, length: 20, defaultValue: UNKNOWN, modelName: CONDITION , Coded Values: [BAD: Bad] , [EXCELLENT: Excellent] , [FAIR: Fair] , ...4 more... )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, editable: true, nullable: true, length: 50, defaultValue: UNK, modelName: OWNERSHIP , Coded Values: [ADT: Addison Township] , [ATP: Antioch Township] , [AIL: Aqua Illinois] , ...212 more... )
• MAINTAINED ( type: esriFieldTypeString, alias: MAINTAINED, editable: true, nullable: true, length: 50, defaultValue: UNK, modelName: MAINTAINED , Coded Values: [ADT: Addison Township] , [ATP: Antioch Township] , [AIL: Aqua Illinois] , ...212 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATION )
• LIGHTED ( type: esriFieldTypeSmallInteger, alias: LIGHTED, editable: true, nullable: true, defaultValue: 0, modelName: LIGHTED , Coded Values: [0: No] , [1: Yes] )
• REFLECTIVE ( type: esriFieldTypeSmallInteger, alias: REFLECTIVE, editable: true, nullable: true, defaultValue: 0, modelName: REFLECTIVE , Coded Values: [0: No] , [1: Yes] )
• COLOR ( type: esriFieldTypeString, alias: COLOR, editable: true, nullable: true, length: 20, defaultValue: UNKNOWN, modelName: COLOR , Coded Values: [BLACK: Black] , [BLACKBROWN: Black/Brown] , [BLACKORANGE: Black/Orange] , ...22 more... )
• NUMBEROFSUPPORTS ( type: esriFieldTypeSmallInteger, alias: NUMBEROFSUPPORTS, editable: true, nullable: true, defaultValue: null, modelName: NUMBEROFSUPPORTS )
• FOUNDATIONTYPE ( type: esriFieldTypeString, alias: FOUNDATIONTYPE, editable: true, nullable: true, length: 30, defaultValue: UNKNOWN, modelName: FOUNDATIONTYPE , Coded Values: [BREAKAWAYANCHOR: Breakaway Anchor] , [CONCRETE: Concrete] , [CONCRETEBACKFILL: Concrete Backfill] , ...6 more... )
• COMMUNITYID ( type: esriFieldTypeString, alias: COMMUNITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: COMMUNITYID )
• UTILITYID ( type: esriFieldTypeString, alias: UTILITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UTILITYID )
• STRUCTURESTYLE ( type: esriFieldTypeString, alias: STRUCTURESTYLE, editable: true, nullable: true, length: 20, defaultValue: UNKNOWN, modelName: STRUCTURESTYLE , Coded Values: [ORNAMENTAL: Ornamental] , [STANDARD: Standard] , [UNKNOWN: Unknown] )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DESCRIPTION )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MANUFACTURER )
• MANUFACTUREDATE ( type: esriFieldTypeDate, alias: MANUFACTUREDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MANUFACTUREDATE )
• TREATMENTTYPE ( type: esriFieldTypeString, alias: TREATMENTTYPE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TREATMENTTYPE )
• CREATEDBY ( type: esriFieldTypeString, alias: CREATEDBY, editable: false, nullable: true, length: 100, defaultValue: null, modelName: CREATEDBY )
• MODIFIEDBY ( type: esriFieldTypeString, alias: MODIFIEDBY, editable: false, nullable: true, length: 100, defaultValue: null, modelName: MODIFIEDBY )
• OWNERSHIPDESCRIPTION ( type: esriFieldTypeString, alias: OWNERSHIPDESCRIPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNERSHIPDESCRIPTION )
• MAINTAINEDDESCRIPTION ( type: esriFieldTypeString, alias: MAINTAINEDDESCRIPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINTAINEDDESCRIPTION )
• NUMBEROFARMS ( type: esriFieldTypeSmallInteger, alias: NUMBEROFARMS, editable: true, nullable: true, defaultValue: null, modelName: NUMBEROFARMS )
• MODEL ( type: esriFieldTypeString, alias: MODEL, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MODEL )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LIFECYCLESTATUS, editable: true, nullable: true, length: 20, defaultValue: UNKNOWN, modelName: LIFECYCLESTATUS , Coded Values: [ABANDONED: Abandoned] , [ACTIVE: Active] , [PROPOSED: Proposed] , ...2 more... )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATIONDESCRIPTION )
• MOUNTTYPE ( type: esriFieldTypeString, alias: MOUNTTYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MOUNTTYPE , Coded Values: [BUTT: Butt] , [SURFACE: Surface] , [FOUNDATION: Foundation] )
• WEBLINK ( type: esriFieldTypeString, alias: WEBLINK, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WEBLINK )
• HASBASECOVER ( type: esriFieldTypeString, alias: HASBASECOVER, editable: true, nullable: true, length: 10, defaultValue: NO, modelName: HASBASECOVER , Coded Values: [NO: No] , [YES: Yes] )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: CONDITIONDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITIONDATE )
• HASELECTRICALOUTLET ( type: esriFieldTypeString, alias: HASELECTRICALOUTLET, editable: true, nullable: true, length: 10, defaultValue: NO, modelName: HASELECTRICALOUTLET , Coded Values: [NO: No] , [YES: Yes] )
• NEARESTADDRESS ( type: esriFieldTypeString, alias: NEARESTADDRESS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NEARESTADDRESS )
• DATEREMOVED ( type: esriFieldTypeDate, alias: DATEREMOVED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEREMOVED )
• SYS_RELATEDRECORDJSON ( type: esriFieldTypeString, alias: SYS_RELATEDRECORDJSON, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: SYS_RELATEDRECORDJSON )
• NEEDSREPLACEMENT ( type: esriFieldTypeString, alias: NEEDSREPLACEMENT, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDSREPLACEMENT , Coded Values: [NO: No] , [YES: Yes] )
• NUMBEROFOUTLETS ( type: esriFieldTypeSmallInteger, alias: NUMBEROFOUTLETS, editable: true, nullable: true, defaultValue: null, modelName: NUMBEROFOUTLETS )
• ERP_CW_LastInspected ( type: esriFieldTypeDate, alias: CityWorks - Last Inspected Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ERP_CW_LastInspected )

Templates:

• Name: Support Post
  Description:
  Prototype:
  NUMBEROFOUTLETS: null
  LENGTH: 0
  WIDTH: 0
  STRUCTUREMATERIAL: UNKNOWN
  LIGHTED: 0
  UTILITYID: null
  HEIGHT: 0
  PRODUCTIONNOTES: null
  STRUCTURETYPE: UNKNOWN
  REPLICAFILTER: VAH
  NUMBEROFSUPPORTS: null
  LOCATION: null
  SOURCE: null
  STRUCTURESTATUS: UNKNOWN
  REFLECTIVE: 0
  GEODBID: 034
  FEATUREID: null
  NEEDSREPLACEMENT: null
  SYS_RELATEDRECORDJSON: null
  SOURCETYPE: UNKNOWN
  ERP_CW_LastInspected: null
  CONDITION: UNKNOWN
  OWNERSHIP: UNK
  MAINTAINED: UNK
  INSTALLDATE: null
  COLOR: UNKNOWN
  FOUNDATIONTYPE: UNKNOWN
  COMMUNITYID: null
  STRUCTURESTYLE: UNKNOWN
  DESCRIPTION: null
  MANUFACTURER: null
  MANUFACTUREDATE: null
  TREATMENTTYPE: null
  DATEREMOVED: null
  NEARESTADDRESS: null
  OWNERSHIPDESCRIPTION: null
  MAINTAINEDDESCRIPTION: null
  NUMBEROFARMS: null
  MODEL: null
  LIFECYCLESTATUS: UNKNOWN
  LOCATIONDESCRIPTION: null
  MOUNTTYPE: null
  WEBLINK: null
  HASBASECOVER: NO
  CONDITIONDATE: null
  HASELECTRICALOUTLET: NO
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• StreetLight_Luminaire_POINT (4) -- Related To: Street Light Bulb (59)
• StreetUtility_Sign_POINT (5) -- Related To: Signs (69)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: DATECREATED
• Creator Field: CREATEDBY
• Edit Date Field: DATEMODIFIED
• Editor Field: MODIFIEDBY

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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