Name: Street Light Bulb

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 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 geodatabasesBULBTYPE: Type of bulb used, e.g. fluorescent, incandesent, mercury vaporWATTAGE: Measure of electrical power; measured in wattsVOLTAGE: Measure of the amount of energy needed to transfer power; measured in voltsMANUFACTURER: The manufacturer of the equipmentDESCRIPTION: Statement illustrating the featureBULBNUMBER: Unique identifier for the light bulbINSTALLDATE: Date that the light bulb was installedPARTNUMBER: Manufacturer's unique identifier for the bulbLIFECYCLESTATUS: Current status of the real-world 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 feature classesFID_STREETLIGHT_FIXTURE_TABLE: Unique identifier that can be joined to the FEATUREID field of the StreetLight_Fixture_POINT feature class to provide a link between the two feature classesFID_STREETLIGHT_CONTROL_POINT: Unique identifier that can be joined to the FEATUREID field of the StreetLight_Control_POINT feature class to provide a link between the two feature classesGlobalID: System-generated unique identifier for each record that is required in replicated geodatabasesLUMENS: Measure of the amount of light emitted from the bulbSHAPE: System-generated geometry type of the featureOWNERSHIP: Organization with jurisdiction over the real-world feature represented in the feature class/tableMAINTENANCE: Organization responsible for the care of the real-world feature represented in the feature class/tableCIRCUIT: Identifier for the closed loop in which the line participatesBASETYPE: Type of bulb base used to latch the bulb to the socketBULBSTATUS: Denotes if the bulb is currently functioning or notGID_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 feature classesGID_STREETLIGHT_FIXTURE_TABLE: Unique identifier that can be joined to the GlobalID field of the StreetLight_Fixture_POINT feature class to provide a link between the two feature classesGID_STREETLIGHT_CONTROL_POINT: Unique identifier that can be joined to the GlobalID field of the StreetLight_Control_POINT feature class to provide a link between the two feature classes

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

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: 1193948.3594999984
YMax: 2119826.66725
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: false
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: N/A

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GEODBID ( type: esriFieldTypeString, alias: GEODBID, length: 3 )
• 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 )
• PRODUCTIONNOTES ( type: esriFieldTypeString, alias: PRODUCTIONNOTES, length: 100 )
• REPLICAFILTER ( type: esriFieldTypeString, alias: REPLICAFILTER, length: 255 )
• BULBTYPE ( type: esriFieldTypeString, alias: BULBTYPE, length: 50 )
• WATTAGE ( type: esriFieldTypeSmallInteger, alias: WATTAGE )
• VOLTAGE ( type: esriFieldTypeSmallInteger, alias: VOLTAGE )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, length: 255 )
• BULBNUMBER ( type: esriFieldTypeString, alias: BULBNUMBER, length: 50 )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LIFECYCLESTATUS, length: 20 )
• FID_STREETUTILITY_SUPPORT_POINT ( type: esriFieldTypeString, alias: FID_STREETUTILITY_SUPPORT_POINT, length: 15 )
• FID_STREETLIGHT_FIXTURE_TABLE ( type: esriFieldTypeString, alias: FID_STREETLIGHT_FIXTURE_TABLE, length: 15 )
• FID_STREETLIGHT_CONTROL_POINT ( type: esriFieldTypeString, alias: FID_STREETLIGHT_CONTROL_POINT, length: 15 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• LUMENS ( type: esriFieldTypeDouble, alias: LUMENS )
• CREATEDBY ( type: esriFieldTypeString, alias: CREATEDBY, length: 100 )
• MODIFIEDBY ( type: esriFieldTypeString, alias: MODIFIEDBY, length: 100 )
• CIRCUIT ( type: esriFieldTypeString, alias: CIRCUIT, length: 20 )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, length: 50 )
• MAINTENANCE ( type: esriFieldTypeString, alias: MAINTENANCE, length: 50 )
• GID_STREETUTILITY_SUPPORT_POINT ( type: esriFieldTypeGUID, alias: GID_STREETUTILITY_SUPPORT_POINT, length: 38 )
• GID_STREETLIGHT_FIXTURE_TABLE ( type: esriFieldTypeGUID, alias: GID_STREETLIGHT_FIXTURE_TABLE, length: 38 )
• GID_STREETLIGHT_CONTROL_POINT ( type: esriFieldTypeGUID, alias: GID_STREETLIGHT_CONTROL_POINT, length: 38 )
• OWNERSHIPDESCRIPTION ( type: esriFieldTypeString, alias: OWNERSHIPDESCRIPTION, length: 50 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• CORRELATEDCOLORTEMPERATURE ( type: esriFieldTypeSmallInteger, alias: CORRELATEDCOLORTEMPERATURE )
• LUMINAIREMANUFACTURER ( type: esriFieldTypeString, alias: LUMINAIREMANUFACTURER, length: 100 )
• LUMINAIREINSTALLDATE ( type: esriFieldTypeDate, alias: LUMINAIREINSTALLDATE, length: 8 )
• BULBPARTNUMBER ( type: esriFieldTypeString, alias: BULBPARTNUMBER, length: 50 )
• BULBBASETYPE ( type: esriFieldTypeString, alias: BULBBASETYPE, length: 50 )
• LUMINAIREMODEL ( type: esriFieldTypeString, alias: LUMINAIREMODEL, length: 50 )
• LUMINAIREHEIGHT ( type: esriFieldTypeDouble, alias: LUMINAIREHEIGHT )
• BULBMANUFACTURER ( type: esriFieldTypeString, alias: BULBMANUFACTURER, length: 100 )
• BULBINSTALLDATE ( type: esriFieldTypeDate, alias: BULBINSTALLDATE, length: 8 )
• BALLASTTYPE ( type: esriFieldTypeString, alias: BALLASTTYPE, length: 50 )
• CUTOFFTYPE ( type: esriFieldTypeString, alias: CUTOFFTYPE, length: 50 )
• DISTRIBUTIONTYPE ( type: esriFieldTypeString, alias: DISTRIBUTIONTYPE, length: 50 )
• MASTARMLENGTH ( type: esriFieldTypeDouble, alias: MASTARMLENGTH )
• PURPOSE ( type: esriFieldTypeString, alias: PURPOSE, length: 30 )
• LENSTYPE ( type: esriFieldTypeString, alias: LENSTYPE, length: 30 )
• WEBLINK ( type: esriFieldTypeString, alias: WEBLINK, length: 255 )
• COMMUNITYID ( type: esriFieldTypeString, alias: COMMUNITYID, length: 20 )
• FIXTURETYPE ( type: esriFieldTypeString, alias: FIXTURETYPE, length: 20 )
• NEARESTADDRESS ( type: esriFieldTypeString, alias: NEARESTADDRESS, length: 255 )
• DATEREMOVED ( type: esriFieldTypeDate, alias: DATEREMOVED, length: 8 )
• SYS_RELATEDRECORDJSON ( type: esriFieldTypeString, alias: SYS_RELATEDRECORDJSON, length: 1000 )
• FIELDVERIFICATIONSTATUS ( type: esriFieldTypeString, alias: FIELDVERIFICATIONSTATUS, length: 10 )
• FIELDVERIFICATIONNOTES ( type: esriFieldTypeString, alias: FIELDVERIFICATIONNOTES, length: 255 )
• QASTATUS ( type: esriFieldTypeString, alias: QASTATUS, length: 10 )
• QANOTES ( type: esriFieldTypeString, alias: QANOTES, length: 255 )
• ERP_CW_LastInspected ( type: esriFieldTypeDate, alias: CityWorks - Last Inspected Date, length: 8 )

Relationships:

• StreetUtility_Support_POINT (4) -- Related To: Support Post (58)

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

  Iteminfo   Thumbnail   Metadata