Layer: Streetlights (ID: 0)

View In: ArcGIS Online map viewer

Name: Streetlights

Display Field: LOC_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><TABLE STYLE="margin:0 0 0 0;"><TBODY><TR><TD STYLE="padding:0 0 0 0;">Field Name</TD><TD STYLE="padding:0 0 0 0;">Alias</TD><TD STYLE="padding:0 0 0 0;">Description</TD></TR><TR><TD STYLE="padding:0 0 0 0;">MUNI_PN</TD><TD STYLE="padding:0 0 0 0;">Municipal Pole Number</TD><TD STYLE="padding:0 0 0 0;">Municipally owned and installed pole number</TD></TR><TR><TD STYLE="padding:0 0 0 0;">FIELD_PN</TD><TD STYLE="padding:0 0 0 0;">Audited Pole Number</TD><TD STYLE="padding:0 0 0 0;">Primary pole number found during field audit</TD></TR><TR><TD STYLE="padding:0 0 0 0;">ADDTNL_PN</TD><TD STYLE="padding:0 0 0 0;">Additional Pole Numbers</TD><TD STYLE="padding:0 0 0 0;">Additional pole numbers found during field audit</TD></TR><TR><TD STYLE="padding:0 0 0 0;">FIXTURTYPE</TD><TD STYLE="padding:0 0 0 0;">Fixture Type</TD><TD STYLE="padding:0 0 0 0;">Current fixture type</TD></TR><TR><TD STYLE="padding:0 0 0 0;">DECO</TD><TD STYLE="padding:0 0 0 0;">Decorative Classification</TD><TD STYLE="padding:0 0 0 0;">Decorative type (e.g. post top, pendant, wall-mount)</TD></TR><TR><TD STYLE="padding:0 0 0 0;">SB_POLE_SH</TD><TD STYLE="padding:0 0 0 0;">Shoebox Pole Shape</TD><TD STYLE="padding:0 0 0 0;">If fixture is a shoebox, the shape of the pole it is mounted to</TD></TR><TR><TD STYLE="padding:0 0 0 0;">CONTROL</TD><TD STYLE="padding:0 0 0 0;">Control Device</TD><TD STYLE="padding:0 0 0 0;">Indicates control device present on the fixture (e.g. photocell, control node, etc.)</TD></TR><TR><TD STYLE="padding:0 0 0 0;">HEADS</TD><TD STYLE="padding:0 0 0 0;">Number of Heads on Pole</TD><TD STYLE="padding:0 0 0 0;">Number of fixture heads mounted to a single pole</TD></TR><TR><TD STYLE="padding:0 0 0 0;">CURNT_LAMP</TD><TD STYLE="padding:0 0 0 0;">Current Lamp Type</TD><TD STYLE="padding:0 0 0 0;">Current lamp type</TD></TR><TR><TD STYLE="padding:0 0 0 0;">CURNT_WATT</TD><TD STYLE="padding:0 0 0 0;">Current Wattage</TD><TD STYLE="padding:0 0 0 0;">Current wattage</TD></TR><TR><TD STYLE="padding:0 0 0 0;">OLD_LAMP</TD><TD STYLE="padding:0 0 0 0;">Old Lamp Type</TD><TD STYLE="padding:0 0 0 0;">Old lamp type prior to LED conversionHPS = High Pressure Sodium, MV = Mercury Vapor, MH = Metal Halide, IND = Induction, LPS = Low Pressure Sodium</TD></TR><TR><TD STYLE="padding:0 0 0 0;">OLD_WATT</TD><TD STYLE="padding:0 0 0 0;">Old Wattage</TD><TD STYLE="padding:0 0 0 0;">Old wattage prior to LED conversion</TD></TR><TR><TD STYLE="padding:0 0 0 0;">ALONEVDIST</TD><TD STYLE="padding:0 0 0 0;">Standalone or Distribution</TD><TD STYLE="padding:0 0 0 0;">Indicates whether the fixture is on a standalone pole or a distribution pole</TD></TR><TR><TD STYLE="padding:0 0 0 0;">FEED</TD><TD STYLE="padding:0 0 0 0;">Feed Type</TD><TD STYLE="padding:0 0 0 0;">Indicates whether fixture is powered with an overhead or underground electrical feed</TD></TR><TR><TD STYLE="padding:0 0 0 0;">POLEMAT</TD><TD STYLE="padding:0 0 0 0;">Pole Material</TD><TD STYLE="padding:0 0 0 0;">Pole material</TD></TR><TR><TD STYLE="padding:0 0 0 0;">HANDHOLE</TD><TD STYLE="padding:0 0 0 0;">Handhole Present</TD><TD STYLE="padding:0 0 0 0;">Indicates whether a handhole is present on the pole</TD></TR><TR><TD STYLE="padding:0 0 0 0;">ARM_LENGTH</TD><TD STYLE="padding:0 0 0 0;">Arm Length</TD><TD STYLE="padding:0 0 0 0;">Approximate length of arm in feet</TD></TR><TR><TD STYLE="padding:0 0 0 0;">ARM_ANGLE</TD><TD STYLE="padding:0 0 0 0;">Arm Angle</TD><TD STYLE="padding:0 0 0 0;">Arm angle in relation to the street</TD></TR><TR><TD STYLE="padding:0 0 0 0;">LIGHT_DIR</TD><TD STYLE="padding:0 0 0 0;">Light Directed At</TD><TD STYLE="padding:0 0 0 0;">If fixture is not lighting the right of way, indicates what the fixture is lighting</TD></TR><TR><TD STYLE="padding:0 0 0 0;">DIST_TO_ST</TD><TD STYLE="padding:0 0 0 0;">Pole Distance to Street</TD><TD STYLE="padding:0 0 0 0;">Approximate distance from pole to street in feet</TD></TR><TR><TD STYLE="padding:0 0 0 0;">ST_WIDTH</TD><TD STYLE="padding:0 0 0 0;">Street Width</TD><TD STYLE="padding:0 0 0 0;">Approximate width of the street in feet</TD></TR><TR><TD STYLE="padding:0 0 0 0;">MOUNT_HT</TD><TD STYLE="padding:0 0 0 0;">Mounting Height</TD><TD STYLE="padding:0 0 0 0;">Approximate mounting height of fixture in feet</TD></TR><TR><TD STYLE="padding:0 0 0 0;">STREETDESN</TD><TD STYLE="padding:0 0 0 0;">Specialized Street Design</TD><TD STYLE="padding:0 0 0 0;">Indicates whether fixture location has a specialized street design (e.g. intersection, cul-de-sac, safety light, etc.)</TD></TR><TR><TD STYLE="padding:0 0 0 0;">CROSSWALK</TD><TD STYLE="padding:0 0 0 0;">Crosswalk</TD><TD STYLE="padding:0 0 0 0;">Indicates whether the fixture is located near a crosswalk</TD></TR><TR><TD STYLE="padding:0 0 0 0;">ATTACHMNTS</TD><TD STYLE="padding:0 0 0 0;">Device Attachments</TD><TD STYLE="padding:0 0 0 0;">Indicates the presence of other devices on the fixture, arm, or pole</TD></TR><TR><TD STYLE="padding:0 0 0 0;">VOLTAGE</TD><TD STYLE="padding:0 0 0 0;">Voltage</TD><TD STYLE="padding:0 0 0 0;">Voltage recorded at installation</TD></TR><TR><TD STYLE="padding:0 0 0 0;">TRANSFORMR</TD><TD STYLE="padding:0 0 0 0;">Transformer</TD><TD STYLE="padding:0 0 0 0;">Step up or step down transformer used</TD></TR><TR><TD STYLE="padding:0 0 0 0;">ISSUES</TD><TD STYLE="padding:0 0 0 0;">Field Issues</TD><TD STYLE="padding:0 0 0 0;">Issues found at time of field audit and installation</TD></TR><TR><TD STYLE="padding:0 0 0 0;">OWNERSHIP</TD><TD STYLE="padding:0 0 0 0;">Ownership</TD><TD STYLE="padding:0 0 0 0;">Indicates who owns the fixture</TD></TR><TR><TD STYLE="padding:0 0 0 0;">RATE_CODE</TD><TD STYLE="padding:0 0 0 0;">Rate Code</TD><TD STYLE="padding:0 0 0 0;">Current utility billing rate code for the fixture</TD></TR><TR><TD STYLE="padding:0 0 0 0;">LED_STATUS</TD><TD STYLE="padding:0 0 0 0;">LED Conversion Status</TD><TD STYLE="padding:0 0 0 0;">Indicates whether fixture was converted to LED by Tanko Lighting</TD></TR><TR><TD STYLE="padding:0 0 0 0;">MANUFCTR</TD><TD STYLE="padding:0 0 0 0;">Manufacturer</TD><TD STYLE="padding:0 0 0 0;">Manufacturer of new LED fixture</TD></TR><TR><TD STYLE="padding:0 0 0 0;">DESFIXT</TD><TD STYLE="padding:0 0 0 0;">LED Fixture - Part Number</TD><TD STYLE="padding:0 0 0 0;">New LED fixture wattage, distribution type, and part number</TD></TR><TR><TD STYLE="padding:0 0 0 0;">UTIL_PN</TD><TD STYLE="padding:0 0 0 0;">Utility Pole Number</TD><TD STYLE="padding:0 0 0 0;">Pole number listed in corresponding utility record</TD></TR><TR><TD STYLE="padding:0 0 0 0;">UTIL_ADDR</TD><TD STYLE="padding:0 0 0 0;">Utility Address</TD><TD STYLE="padding:0 0 0 0;">Address listed in corresponding utility record</TD></TR><TR><TD STYLE="padding:0 0 0 0;">LOC_NAME</TD><TD STYLE="padding:0 0 0 0;">Location Name</TD><TD STYLE="padding:0 0 0 0;">If fixture is not in the right of way, name of location</TD></TR><TR><TD STYLE="padding:0 0 0 0;">LOC_TYPE</TD><TD STYLE="padding:0 0 0 0;">Location Type</TD><TD STYLE="padding:0 0 0 0;">If fixture is not in the right of way, type of location (e.g. school, park, parking lot)</TD></TR><TR><TD STYLE="padding:0 0 0 0;">RATE_SUB</TD><TD STYLE="padding:0 0 0 0;">Rate Change Submission Date</TD><TD STYLE="padding:0 0 0 0;">Date of rate change submission to utility</TD></TR><TR><TD STYLE="padding:0 0 0 0;">AUDIT_DATE</TD><TD STYLE="padding:0 0 0 0;">Audit Date</TD><TD STYLE="padding:0 0 0 0;">Date fixture was visited in Tanko Lighting's field audit</TD></TR><TR><TD STYLE="padding:0 0 0 0;">INSDATE</TD><TD STYLE="padding:0 0 0 0;">Installation Date</TD><TD STYLE="padding:0 0 0 0;">Date new LED fixture was installed</TD></TR><TR><TD STYLE="padding:0 0 0 0;">APPRX_ADDR</TD><TD STYLE="padding:0 0 0 0;">Approximate Address</TD><TD STYLE="padding:0 0 0 0;">Approximate street address generated with ESRI reverse geocoding tool</TD></TR><TR><TD STYLE="padding:0 0 0 0;">LATITUDE</TD><TD STYLE="padding:0 0 0 0;">Latitude</TD><TD STYLE="padding:0 0 0 0;">Latitude in WGS 84</TD></TR><TR><TD STYLE="padding:0 0 0 0;">LONGITUDE</TD><TD STYLE="padding:0 0 0 0;">Longitude</TD><TD STYLE="padding:0 0 0 0;">Longitude in WGS 84</TD></TR><TR><TD STYLE="padding:0 0 0 0;">LAT_LONG</TD><TD STYLE="padding:0 0 0 0;">Latitude, Longitude</TD><TD STYLE="padding:0 0 0 0;">Latitude, Longitude in WGS 84</TD></TR><TR><TD STYLE="padding:0 0 0 0;">TANKO_ID</TD><TD STYLE="padding:0 0 0 0;">Tanko ID</TD><TD STYLE="padding:0 0 0 0;">Unique identifier created by Tanko Lighting for each record</TD></TR></TBODY></TABLE><DIV></DIV></DIV>

Copyright Text: Maeve Hanafin Project Manager [email protected] Paolo Salvoni Lead Analyst [email protected]

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

Renderer:

Unique Value Renderer:

Field 1:

Field 2:

Field 3:

Field Delimiter:

Default Symbol:

N/A

Default Label:

UniqueValueInfos:

Value: Redlands
Label: Redlands
Description: N/A
Symbol:
Value: Caltrans
Label: Caltrans
Description: N/A
Symbol:
Value: SCE
Label: SCE
Description: N/A
Symbol:
Value: Loma Linda
Label: Loma Linda
Description: N/A
Symbol:
Value: San Bernardino
Label: San Bernardino
Description: N/A
Symbol:
Value: San Bernardino County
Label: San Bernardino County
Description: N/A
Symbol:
Value: Not City Owned
Label: Private
Description: N/A
Symbol:
Value: Private
Label: Private
Description: N/A
Symbol:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: OWNERSHIP

Fields:

OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
MUNI_PN ( type: esriFieldTypeString, alias: Municipal Pole Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MUNI_PN )
FIELD_PN ( type: esriFieldTypeString, alias: Audited Pole Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FIELD_PN )
ADDTNL_PN ( type: esriFieldTypeString, alias: Additional Pole Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ADDTNL_PN )
FIXTURTYPE ( type: esriFieldTypeString, alias: Fixture Type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FIXTURTYPE )
DECO ( type: esriFieldTypeString, alias: Decorative Classification, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DECO )
SB_POLE_SH ( type: esriFieldTypeString, alias: Shoebox Pole Shape, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SB_POLE_SH )
CONTROL ( type: esriFieldTypeString, alias: Control Device, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CONTROL )
HEADS ( type: esriFieldTypeString, alias: Number of Heads on Pole, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: HEADS )
CURNT_LAMP ( type: esriFieldTypeString, alias: Current Lamp Type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CURNT_LAMP )
CURNT_WATT ( type: esriFieldTypeString, alias: Current Wattage, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CURNT_WATT )
OLD_LAMP ( type: esriFieldTypeString, alias: Old Lamp Type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: OLD_LAMP )
OLD_WATT ( type: esriFieldTypeString, alias: Old Wattage, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: OLD_WATT )
ALONEVDIST ( type: esriFieldTypeString, alias: Standalone or Distribution, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ALONEVDIST )
FEED ( type: esriFieldTypeString, alias: Feed Type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FEED )
POLEMAT ( type: esriFieldTypeString, alias: Pole Material, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: POLEMAT )
HANDHOLE ( type: esriFieldTypeString, alias: Handhole Present, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: HANDHOLE )
ARM_LENGTH ( type: esriFieldTypeString, alias: Arm Length, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ARM_LENGTH )
ARM_ANGLE ( type: esriFieldTypeString, alias: Arm Angle, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ARM_ANGLE )
LIGHT_DIR ( type: esriFieldTypeString, alias: Light Directed At, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LIGHT_DIR )
DIST_TO_ST ( type: esriFieldTypeString, alias: Pole Distance to Street, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DIST_TO_ST )
ST_WIDTH ( type: esriFieldTypeString, alias: Street Width, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ST_WIDTH )
MOUNT_HT ( type: esriFieldTypeString, alias: Mounting Height, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MOUNT_HT )
STREETDESN ( type: esriFieldTypeString, alias: Specialized Street Design, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: STREETDESN )
CROSSWALK ( type: esriFieldTypeString, alias: Crosswalk, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CROSSWALK )
ATTACHMNTS ( type: esriFieldTypeString, alias: Device Attachments, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ATTACHMNTS )
VOLTAGE ( type: esriFieldTypeString, alias: Voltage, editable: true, nullable: true, length: 150, defaultValue: null, modelName: VOLTAGE )
TRANSFORMR ( type: esriFieldTypeString, alias: Transformer, editable: true, nullable: true, length: 150, defaultValue: null, modelName: TRANSFORMR )
ISSUES ( type: esriFieldTypeString, alias: Field Issues, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ISSUES )
OWNERSHIP ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: OWNERSHIP )
RATE_CODE ( type: esriFieldTypeString, alias: Rate Code, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: RATE_CODE )
LED_STATUS ( type: esriFieldTypeString, alias: LED Conversion Status, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LED_STATUS )
MANUFCTR ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MANUFCTR )
DESFIXT ( type: esriFieldTypeString, alias: LED Fixture - Part Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DESFIXT )
UTIL_PN ( type: esriFieldTypeString, alias: Utility Pole Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: UTIL_PN )
UTIL_ADDR ( type: esriFieldTypeString, alias: Utility Address, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: UTIL_ADDR )
LOC_NAME ( type: esriFieldTypeString, alias: Location Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LOC_NAME )
LOC_TYPE ( type: esriFieldTypeString, alias: Location Type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LOC_TYPE )
RATE_SUB ( type: esriFieldTypeString, alias: Rate Change Submission Date, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: RATE_SUB )
AUDIT_DATE ( type: esriFieldTypeString, alias: Audit Date, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AUDIT_DATE )
INSDATE ( type: esriFieldTypeString, alias: Installation Date, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: INSDATE )
APPRX_ADDR ( type: esriFieldTypeString, alias: Approximate Address, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: APPRX_ADDR )
LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
LAT_LONG ( type: esriFieldTypeString, alias: Latitude, Longitude, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LAT_LONG )
TANKO_ID ( type: esriFieldTypeInteger, alias: Tanko ID, editable: true, nullable: true, defaultValue: null, modelName: TANKO_ID )
Update_Loc ( type: esriFieldTypeString, alias: Update_Loc, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Update_Loc )
created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
As_Built ( type: esriFieldTypeString, alias: As_Built, editable: true, nullable: true, length: 255, defaultValue: null, modelName: As_Built )

Types:

Name: Redlands
Description:
Prototype:
Drawing Tool: esriFeatureEditToolPoint

Name: Caltrans
Description:
Prototype:
Drawing Tool: esriFeatureEditToolPoint

Name: SCE
Description:
Prototype:
Drawing Tool: esriFeatureEditToolPoint

Name: Loma Linda
Description:
Prototype:
Drawing Tool: esriFeatureEditToolPoint

Name: San Bernardino
Description:
Prototype:
Drawing Tool: esriFeatureEditToolPoint

Name: San Bernardino County
Description:
Prototype:
Drawing Tool: esriFeatureEditToolPoint

Name: Private
Description:
Prototype:
Drawing Tool: esriFeatureEditToolPoint

Name: Private
Description:
Prototype:
Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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