Name: GISC_PUBLISH.DBO.StreetUtility_Sign_POINT

Display Field: GEODBID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: OBJECTID: System-generated unique identifier for each record within the tableGEODBID: Three-digit code that assigns editing responsibility to a community in the GIS ConsortiumFEATUREID: GIS-Consortium-generated unique identifier for each record within the table. All FEATUREIDs start with the GEODBID of the community that owns the record.DATECREATED: Date/time stamp from the moment the GIS record was created DATEMODIFIED: Date/time stamp from the last moment the GIS record was changed SOURCE: 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 recordPRODUCTIONNOTES: Technical notes from GIS personnelREPLICAFILTER: Code used to filter data for the creation of custom geodatabasesSIGNCODE: Code of the sign that can be joined to the SIGNTYPE: Type of signINSTALLDATE: INSTALLDATE: Date of installation for the real-world featureCONDITION: Assessment of the quality of the real-world featureCONDITIONDATE: Date the real-world feature's condition was assessedOWNERSHIP: Organization with jurisdiction over the real-world feature represented in the feature classMAINTENANCE: Organization responsible for the care of the real-world feature represented in the feature classSIGNSTATUS: State of the real-world featureFACINGDIRECTION: Direction in which the sign is facingAUTHORITY: Regulation stating the need for the real-world featureAUTHORITYDATE: Date the regulation was establishedSIGNMATERIAL: Matter composition of the real-world featureASTMREFLECTIVITYTYPE: Roman numberal classification of the reflectivity of the real-world featureREFLECTIVITYPRODUCT: Material used to create reflectivitySIGNWIDTH: Width of the real-world feature; measured in inchesSIGNHEIGHT: Height of the real-world feature; measured in inchesBACKGROUNDCOLOR: Background color of the real-world featureSIGNSHAPE: Shape of the real-world featureFOREGROUNDCOLOR: Foreground color of the real-world featureSIGNTEXT: Wording on the real-world featureFOLDING: Boolean field indicating the presence of hinges for folding the signBLINDERS: Boolean field indicating the presence of blindersFULLHEIGHT: Elevation of the real-world feature; measured in feet from the ground to the top of the signEXPIREDATE: Date by which the real-world feature should be replacedLIGHTED: Boolean field indicating the presence of lightingSIGNPOSITION: Integer describing the position of the real-world feature in reference to other features on the same support structureDESCRIPTION: Statement illustrating the featureFID_STREETUTILITY_SUPPORT_POINT: Unique identifier that can be joined to the FEATUREID field of the StreetUtility_Support_POINT feature class to provide a link between the two tablesGlobalID: System-generated unique identifier for each record that is required in replicated geodatabasesMOUNTING: Description of how the real-world feature is connected to its supporting structureCOMMUNITYID: Unique identifying code selected by the communityRETROREFLECTIVITYCOMPLIANCE: Boolean indicating if the real-world feature meets reflectivity standardsMAINTENANCEDISTRICT: Value indicating the district of maintenance the real-world feature is withinWEBLINK1: URL for a website related to the recordWEBLINK2: URL for a website related to the recordENFORCEMENTDIRECTION: The direction in which the sign restrictions apply to. (Example: The arrow direction on the sign designating where parking is not allowed)GID_STREETUTILITY_SUPPORT_POINT: Unique identifier that can be joined to the GlobalID field of the StreetUtility_Support_POINT feature class to provide a link between the two tables

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: 60000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -17463800
YMin: -46132600
XMax: 1166281.0957500003
YMax: 2591232.122749999
Spatial Reference: 102671  (3435)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [94, 51, 140, 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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GEODBID ( type: esriFieldTypeString, alias: GEODBID, length: 3 , Coded Values: [001: CHP] , [003: CPR] , [005: CDP] , ...83 more... )
• FEATUREID ( type: esriFieldTypeString, alias: FEATUREID, length: 15 )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, length: 8 )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, length: 8 )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 20 )
• SOURCETYPE ( type: esriFieldTypeString, alias: SOURCETYPE, length: 20 , Coded Values: [ASBUILT: As-built] , [DATABASE: Database] , [ESTIMATED: Estimated] , ...12 more... )
• PRODUCTIONNOTES ( type: esriFieldTypeString, alias: PRODUCTIONNOTES, length: 100 )
• REPLICAFILTER ( type: esriFieldTypeString, alias: REPLICAFILTER, length: 255 )
• SIGNCODE ( type: esriFieldTypeString, alias: SIGNCODE, length: 20 , Coded Values: [BL-ON-WH: BL-ON-WH: Black On White] , [BL-ON-WH-Guide: BL-ON-WH-Guide: Black On White (Guide)] , [BL-ON-YE: BL-ON-YE: Black On Yellow (Yellow)] , ...1197 more... )
• SIGNTYPE ( type: esriFieldTypeString, alias: SIGNTYPE, length: 20 , Coded Values: [REGULATORY: Regulatory] , [WARNING: Warning] , [GUIDE: Guide] , ...7 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, length: 8 )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, length: 20 , Coded Values: [BAD: Bad] , [EXCELLENT: Excellent] , [FAIR: Fair] , ...4 more... )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: CONDITIONDATE, length: 8 )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, length: 50 , Coded Values: [ADT: Addison Township] , [ATP: Antioch Township] , [AIL: Aqua Illinois] , ...212 more... )
• MAINTENANCE ( type: esriFieldTypeString, alias: MAINTENANCE, length: 50 , Coded Values: [ADT: Addison Township] , [ATP: Antioch Township] , [AIL: Aqua Illinois] , ...212 more... )
• SIGNSTATUS ( type: esriFieldTypeString, alias: SIGNSTATUS, length: 20 , Coded Values: [ABANDONED: Abandoned] , [ACTIVE: Active] , [PROPOSED: Proposed] , ...2 more... )
• FACINGDIRECTION ( type: esriFieldTypeString, alias: FACINGDIRECTION, length: 20 , Coded Values: [BT: BOTH] , [E: EAST] , [LT: LEFT] , ...9 more... )
• AUTHORITY ( type: esriFieldTypeString, alias: AUTHORITY, length: 20 , Coded Values: [ORDINANCE: Ordinance] , [OTHER: Other] , [PUBLICSAFETY: Public Safety] )
• AUTHORITYDATE ( type: esriFieldTypeDate, alias: AUTHORITYDATE, length: 8 )
• SIGNMATERIAL ( type: esriFieldTypeString, alias: SIGNMATERIAL, length: 30 , Coded Values: [ALUMINUM: Aluminum] , [CORRUGATEDPLASTIC: Corrugated Plastic] , [OTHER: Other] , ...3 more... )
• ASTMREFLECTIVITYTYPE ( type: esriFieldTypeString, alias: ASTMREFLECTIVITYTYPE, length: 10 , Coded Values: [C: C] , [D: D] , [I: I] , ...21 more... )
• REFLECTIVITYPRODUCT ( type: esriFieldTypeString, alias: REFLECTIVITYPRODUCT, length: 50 , Coded Values: [3MDIAMONDGRADEDG3: 3M Diamond Grade DG3] , [3MDIAMONDGRADELDP: 3M Diamond Grade LDP] , [3MDIAMONDGRADEVIP: 3M Diamond Grade VIP] , ...9 more... )
• SIGNWIDTH ( type: esriFieldTypeDouble, alias: SIGNWIDTH )
• SIGNHEIGHT ( type: esriFieldTypeDouble, alias: SIGNHEIGHT )
• BACKGROUNDCOLOR ( type: esriFieldTypeString, alias: BACKGROUNDCOLOR, length: 30 , Coded Values: [BLACK: Black] , [BLACKBROWN: Black/Brown] , [BLACKORANGE: Black/Orange] , ...22 more... )
• SIGNSHAPE ( type: esriFieldTypeString, alias: SIGNSHAPE, length: 20 , Coded Values: [CIRCLE: Circle] , [CROSSBUCK: Crossbuck] , [DIAMOND: Diamond] , ...8 more... )
• FOREGROUNDCOLOR ( type: esriFieldTypeString, alias: FOREGROUNDCOLOR, length: 50 , Coded Values: [BLACK: Black] , [BLACKBROWN: Black/Brown] , [BLACKORANGE: Black/Orange] , ...22 more... )
• SIGNTEXT ( type: esriFieldTypeString, alias: SIGNTEXT, length: 255 )
• FOLDING ( type: esriFieldTypeSmallInteger, alias: FOLDING , Coded Values: [0: No] , [1: Yes] )
• BLINDERS ( type: esriFieldTypeSmallInteger, alias: BLINDERS , Coded Values: [0: No] , [1: Yes] )
• FULLHEIGHT ( type: esriFieldTypeDouble, alias: FULLHEIGHT )
• EXPIREDATE ( type: esriFieldTypeDate, alias: EXPIREDATE, length: 8 )
• LIGHTED ( type: esriFieldTypeString, alias: LIGHTED, length: 20 , Coded Values: [CONVENTIONAL: Conventional] , [LED: LED] , [NO: No] , ...2 more... )
• SIGNPOSITION ( type: esriFieldTypeSmallInteger, alias: SIGNPOSITION )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, length: 255 )
• FID_STREETUTILITY_SUPPORT_POINT ( type: esriFieldTypeString, alias: FID_STREETUTILITY_SUPPORT_POINT, length: 15 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• MOUNTING ( type: esriFieldTypeString, alias: MOUNTING, length: 50 )
• COMMUNITYID ( type: esriFieldTypeString, alias: COMMUNITYID, length: 20 )
• RETROREFLECTIVITYCOMPLIANCE ( type: esriFieldTypeString, alias: RETROREFLECTIVITYCOMPLIANCE, length: 20 , Coded Values: [EXEMPT: Exempt] , [INCOMPLIANCE: In Compliance] , [NOTINCOMPLIANCE: Not In Compliance] , ...1 more... )
• MAINTENANCEDISTRICT ( type: esriFieldTypeString, alias: MAINTENANCEDISTRICT, length: 50 )
• WEBLINK1 ( type: esriFieldTypeString, alias: WEBLINK1, length: 255 )
• WEBLINK2 ( type: esriFieldTypeString, alias: WEBLINK2, length: 255 )
• CREATEDBY ( type: esriFieldTypeString, alias: CREATEDBY, length: 100 )
• MODIFIEDBY ( type: esriFieldTypeString, alias: MODIFIEDBY, length: 100 )
• ENFORCEMENTDIRECTION ( type: esriFieldTypeString, alias: ENFORCEMENTDIRECTION, length: 10 , Coded Values: [BT: BOTH] , [E: EAST] , [LT: LEFT] , ...9 more... )
• GID_STREETUTILITY_SUPPORT_POINT ( type: esriFieldTypeGUID, alias: GID_STREETUTILITY_SUPPORT_POINT, length: 38 )
• OWNERSHIPDESCRIPTION ( type: esriFieldTypeString, alias: OWNERSHIPDESCRIPTION, length: 50 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• CUSTOMCODE ( type: esriFieldTypeString, alias: CUSTOMCODE, length: 20 )
• DOCUMENTNUM ( type: esriFieldTypeString, alias: DOCUMENTNUM, length: 50 )
• NEEDSREPLACEMENT ( type: esriFieldTypeString, alias: NEEDSREPLACEMENT, length: 10 , Coded Values: [NO: No] , [YES: Yes] )
• DATEREMOVED ( type: esriFieldTypeDate, alias: DATEREMOVED, length: 8 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata