View In:   ArcGIS Online Map Viewer

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: 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... )
• 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 )
• BULBTYPE ( type: esriFieldTypeString, alias: BULBTYPE, editable: true, nullable: true, length: 50, defaultValue: UNKNOWN, modelName: BULBTYPE , Coded Values: [FLUORESCENT: Fluorescent] , [FLUORESCENTBIAX: Fluorescent Biax] , [FLUORESCENTBIAXD: Fluorescent BiaxD] , ...11 more... )
• WATTAGE ( type: esriFieldTypeSmallInteger, alias: WATTAGE, editable: true, nullable: true, defaultValue: null, modelName: WATTAGE , Range: [3, 400] )
• VOLTAGE ( type: esriFieldTypeSmallInteger, alias: VOLTAGE, editable: true, nullable: true, defaultValue: null, modelName: VOLTAGE , Coded Values: [120: 120] , [208: 208] , [240: 240] , ...3 more... )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DESCRIPTION )
• BULBNUMBER ( type: esriFieldTypeString, alias: BULBNUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BULBNUMBER )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LIFECYCLESTATUS, editable: true, nullable: true, length: 20, defaultValue: ACTIVE, modelName: BULBSTATUS , Coded Values: [ABANDONED: Abandoned] , [ACTIVE: Active] , [PROPOSED: Proposed] , ...2 more... )
• FID_STREETUTILITY_SUPPORT_POINT ( type: esriFieldTypeString, alias: FID_STREETUTILITY_SUPPORT_POINT, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FID_STREETUTILITY_SUPPORT_POINT )
• FID_STREETLIGHT_FIXTURE_TABLE ( type: esriFieldTypeString, alias: FID_STREETLIGHT_FIXTURE_TABLE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FID_STREETLIGHT_FIXTURE_TABLE )
• FID_STREETLIGHT_CONTROL_POINT ( type: esriFieldTypeString, alias: FID_STREETLIGHT_CONTROL_POINT, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FID_STREETLIGHT_CONTROL_POINT )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• LUMENS ( type: esriFieldTypeDouble, alias: LUMENS, editable: true, nullable: true, defaultValue: null, modelName: LUMENS )
• 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 )
• CIRCUIT ( type: esriFieldTypeString, alias: CIRCUIT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CIRCUIT , Coded Values: [A: A] , [AB: AB] , [AC: AC] , ...6 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... )
• MAINTENANCE ( type: esriFieldTypeString, alias: MAINTENANCE, editable: true, nullable: true, length: 50, defaultValue: UNK, modelName: MAINTENANCE , Coded Values: [ADT: Addison Township] , [ATP: Antioch Township] , [AIL: Aqua Illinois] , ...212 more... )
• GID_STREETUTILITY_SUPPORT_POINT ( type: esriFieldTypeGUID, alias: GID_STREETUTILITY_SUPPORT_POINT, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GID_STREETUTILITY_SUPPORT_POINT )
• GID_STREETLIGHT_FIXTURE_TABLE ( type: esriFieldTypeGUID, alias: GID_STREETLIGHT_FIXTURE_TABLE, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GID_STREETLIGHT_FIXTURE_TABLE )
• GID_STREETLIGHT_CONTROL_POINT ( type: esriFieldTypeGUID, alias: GID_STREETLIGHT_CONTROL_POINT, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GID_STREETLIGHT_CONTROL_POINT )
• OWNERSHIPDESCRIPTION ( type: esriFieldTypeString, alias: OWNERSHIPDESCRIPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNERSHIPDESCRIPTION )
• CORRELATEDCOLORTEMPERATURE ( type: esriFieldTypeSmallInteger, alias: CORRELATEDCOLORTEMPERATURE, editable: true, nullable: true, defaultValue: null, modelName: CORRELATEDCOLORTEMPERATURE , Range: [1000, 10000] )
• LUMINAIREMANUFACTURER ( type: esriFieldTypeString, alias: LUMINAIREMANUFACTURER, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MANUFACTURER )
• LUMINAIREINSTALLDATE ( type: esriFieldTypeDate, alias: LUMINAIREINSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• BULBPARTNUMBER ( type: esriFieldTypeString, alias: BULBPARTNUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PARTNUMBER )
• BULBBASETYPE ( type: esriFieldTypeString, alias: BULBBASETYPE, editable: true, nullable: true, length: 50, defaultValue: UNKNOWN, modelName: BASETYPE , Coded Values: [INTERMEDIATE: Intermediate] , [MEDIUM: Medium] , [UNKNOWN: Unknown] , ...6 more... )
• LUMINAIREMODEL ( type: esriFieldTypeString, alias: LUMINAIREMODEL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LUMINAIREMODEL )
• LUMINAIREHEIGHT ( type: esriFieldTypeDouble, alias: LUMINAIREHEIGHT, editable: true, nullable: true, defaultValue: null, modelName: LUMINAIREHEIGHT )
• BULBMANUFACTURER ( type: esriFieldTypeString, alias: BULBMANUFACTURER, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BULBMANUFACTURER )
• BULBINSTALLDATE ( type: esriFieldTypeDate, alias: BULBINSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BULBINSTALLDATE )
• BALLASTTYPE ( type: esriFieldTypeString, alias: BALLASTTYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BALLASTTYPE , Coded Values: [HIGHPOWERFACTOR: High Power Factor] , [NORMALPOWERFACTOR: Normal Power Factor] , [OTHER: Other] , ...3 more... )
• CUTOFFTYPE ( type: esriFieldTypeString, alias: CUTOFFTYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CUTOFFTYPE , Coded Values: [NON: Non-Cutoff] , [FULL: Full-Cutoff] , [SEMI: Semi-Cutoff] , ...1 more... )
• DISTRIBUTIONTYPE ( type: esriFieldTypeString, alias: DISTRIBUTIONTYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DISTRIBUTIONTYPE , Coded Values: [TYPEI: Type I] , [TYPEII: Type II] , [TYPEIII: Type III] , ...2 more... )
• MASTARMLENGTH ( type: esriFieldTypeDouble, alias: MASTARMLENGTH, editable: true, nullable: true, defaultValue: null, modelName: MASTARMLENGTH )
• PURPOSE ( type: esriFieldTypeString, alias: PURPOSE, editable: true, nullable: true, length: 30, defaultValue: UNKNOWN, modelName: FIXTUREPURPOSE , Coded Values: [AREA: Area] , [COMMERCIALPEDESTRIAN: Commercial Pedestrian] , [INDOORPARKINGLOT: Indoor Parking Lot] , ...11 more... )
• LENSTYPE ( type: esriFieldTypeString, alias: LENSTYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LENSTYPE )
• WEBLINK ( type: esriFieldTypeString, alias: WEBLINK, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WEBLINK )
• COMMUNITYID ( type: esriFieldTypeString, alias: COMMUNITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: COMMUNITYID )
• FIXTURETYPE ( type: esriFieldTypeString, alias: FIXTURETYPE, editable: true, nullable: true, length: 20, defaultValue: UNKNOWN, modelName: FIXTURETYPE , Coded Values: [ACORN: Acorn] , [ANTIQUESTREETLAMP: Antique Street Lamp] , [COBRAHEAD: Cobra Head] , ...9 more... )
• 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 )
• FIELDVERIFICATIONSTATUS ( type: esriFieldTypeString, alias: FIELDVERIFICATIONSTATUS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FIELDVERIFICATIONSTATUS , Coded Values: [CNL: Cannot Locate] , [CAN: Cannot Access] , [TODO: To Do] , ...2 more... )
• FIELDVERIFICATIONNOTES ( type: esriFieldTypeString, alias: FIELDVERIFICATIONNOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FIELDVERIFICATIONNOTES )
• QASTATUS ( type: esriFieldTypeString, alias: QASTATUS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: QASTATUS , Coded Values: [RAW: Raw] , [CCN: Community Check Needed] , [COMPLETE: Complete] , ...1 more... )
• QANOTES ( type: esriFieldTypeString, alias: QANOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: QANOTES )
• ERP_CW_LastInspected ( type: esriFieldTypeDate, alias: CityWorks - Last Inspected Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ERP_CW_LastInspected )

Templates:

• Name: StreetLight_Bulb_POINT
  Description:
  Prototype:
  QANOTES: null
  REPLICAFILTER: VAH
  BULBNUMBER: null
  PRODUCTIONNOTES: null
  SOURCE: null
  GEODBID: 034
  FEATUREID: null
  QASTATUS: null
  FIELDVERIFICATIONNOTES: null
  SOURCETYPE: UNKNOWN
  BULBTYPE: UNKNOWN
  WATTAGE: null
  VOLTAGE: null
  DESCRIPTION: null
  LIFECYCLESTATUS: ACTIVE
  FID_STREETUTILITY_SUPPORT_POINT: null
  FID_STREETLIGHT_FIXTURE_TABLE: null
  FID_STREETLIGHT_CONTROL_POINT: null
  ERP_CW_LastInspected: null
  LUMENS: null
  FIELDVERIFICATIONSTATUS: null
  SYS_RELATEDRECORDJSON: null
  CIRCUIT: null
  OWNERSHIP: UNK
  MAINTENANCE: UNK
  GID_STREETUTILITY_SUPPORT_POINT: null
  GID_STREETLIGHT_FIXTURE_TABLE: null
  GID_STREETLIGHT_CONTROL_POINT: null
  OWNERSHIPDESCRIPTION: null
  CORRELATEDCOLORTEMPERATURE: null
  LUMINAIREMANUFACTURER: null
  LUMINAIREINSTALLDATE: null
  BULBPARTNUMBER: null
  BULBBASETYPE: UNKNOWN
  LUMINAIREMODEL: null
  LUMINAIREHEIGHT: null
  BULBMANUFACTURER: null
  BULBINSTALLDATE: null
  BALLASTTYPE: null
  CUTOFFTYPE: null
  DISTRIBUTIONTYPE: null
  MASTARMLENGTH: null
  PURPOSE: UNKNOWN
  LENSTYPE: null
  WEBLINK: null
  COMMUNITYID: null
  FIXTURETYPE: UNKNOWN
  NEARESTADDRESS: null
  DATEREMOVED: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

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

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