ArcGIS REST Services Directory
Login
Home
>
services
>
PublicWorks
>
Street_Lights (FeatureServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (PublicWorks/Street_Lights)
Layers:
Layer:
Street Lights
(2)
Name:
Street Lights
Display Field:
AccountNumber
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount:
5000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
100000
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: -1.3580112930932045E7
YMin: 4474717.4886739375
XMax: -1.3571784324055882E7
YMax: 4482018.944500946
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1:
LightSource
Field 2:
N/A
Field 3:
N/A
Field Delimiter:
,
Default Symbol:
N/A
Default Label:
N/A
UniqueValueInfos:
Value:
METAL HALIDE
Label:
Metal Halide
Description:
N/A
Symbol:
Value:
MERCURYVAPOR
Label:
Mercury Vapor
Description:
N/A
Symbol:
Value:
INDUCTION
Label:
Induction
Description:
N/A
Symbol:
Value:
LED
Label:
LED
Description:
N/A
Symbol:
Value:
LPS
Label:
LPS
Description:
N/A
Symbol:
Value:
HPS
Label:
HPS
Description:
N/A
Symbol:
Value:
No Data
Label:
No Data
Description:
N/A
Symbol:
Transparency:
0
Labeling Info:
Label Placement:
esriServerPointLabelPlacementAboveRight
Label Expression:
[BadgeNumber]
Use Coded Values:
true
Symbol:
Color:
[0, 0, 0, 255]
Background Color:
N/A
Outline Color:
N/A
Vertical Alignment:
bottom
Horizontal Alignment:
center
Right to Left:
false
Angle:
0
XOffset:
0
YOffset:
0
Size:
8
Font Family:
Arial
Font Style:
italic
Font Weight:
normal
Font Decoration:
none
Min. Scale:
2500.0
Max. Scale:
0.0
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
LightSource
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
AccountNumber
( type: esriFieldTypeString, alias: Account Number, editable: true, nullable: false, length: 11, defaultValue: null, modelName: ACCTNUM )
BadgeNumber
( type: esriFieldTypeDouble, alias: Badge Number, editable: true, nullable: false, defaultValue: null, modelName: BADGE_NU_3 )
BadgeNumberUnique
( type: esriFieldTypeString, alias: Badge Number Unique, editable: true, nullable: false, length: 7, defaultValue: null, modelName: Badge_Numb )
Location
( type: esriFieldTypeString, alias: Location, editable: true, nullable: false, length: 80, defaultValue: null, modelName: DESC_ADDR )
LightSource
( type: esriFieldTypeString, alias: Light Source, editable: true, nullable: false, length: 12, defaultValue: null, modelName: Light_Sour ,
Coded Values:
[HPS: HPS] , [INDUCTION: INDUCTION] , [LED: LED]
, ...4 more...
)
PresentWattage
( type: esriFieldTypeSmallInteger, alias: Present Wattage, editable: true, nullable: true, defaultValue: null, modelName: PresentWattage_838458 )
PoleType
( type: esriFieldTypeString, alias: Pole Type, editable: true, nullable: false, length: 14, defaultValue: null, modelName: POLE_TYP_1 ,
Coded Values:
[ALUMINUM: Aluminum] , [CAST IRON: Cast Iron] , [GALVANIZED: Galvanized]
, ...5 more...
)
PoleHeight
( type: esriFieldTypeString, alias: Pole Height, editable: true, nullable: true, length: 10, defaultValue: null, modelName: POLE_LGT_1 ,
Coded Values:
[10-12 FT: 10-12 FT] , [12-15 FT: 12-15 FT] , [16-19 FT: 16-19 FT]
, ...10 more...
)
LuminaireMounting
( type: esriFieldTypeString, alias: Luminaire Mounting, editable: true, nullable: true, length: 14, defaultValue: null, modelName: SUSPENSI_1 ,
Coded Values:
[30 INCHES: 30 INCHES] , [2 FT: 2 FT] , [4 FT: 4 FT]
, ...12 more...
)
LightPoleFunction
( type: esriFieldTypeString, alias: Light/Pole Function, editable: true, nullable: true, length: 16, defaultValue: null, modelName: LightPoleFunction ,
Coded Values:
[Decorative: Decorative] , [Parking Lot: Parking Lot] , [Pathway Lights: Pathway Lights]
, ...6 more...
)
PGEPoleFunction
( type: esriFieldTypeString, alias: PG&E Pole Function, editable: true, nullable: true, length: 14, defaultValue: null, modelName: PG_E_POLE_ ,
Coded Values:
[CUSTOMER OWNED: Customer Owned] , [DISTRIBUTION: Distribution] , [ST LIGHT ONLY: Street Light Only]
, ...1 more...
)
Owner
( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Owner ,
Coded Values:
[San Jose: San Jose] , [Caltrans: Caltrans] , [Campbell: Cambpell]
, ...1 more...
)
RateSchedule
( type: esriFieldTypeString, alias: Rate Schedule, editable: true, nullable: true, length: 6, defaultValue: null, modelName: RATE_SCH_1 ,
Coded Values:
[LS1-A: LS1-A] , [LS1-F: LS1-F] , [LS2-A: LS2-A] )
LmpCodeNew
( type: esriFieldTypeString, alias: Lamp Code New, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LmpCodeNew )
Lumens
( type: esriFieldTypeInteger, alias: Lumens, editable: true, nullable: true, defaultValue: null, modelName: Lumens )
CCT
( type: esriFieldTypeString, alias: CCT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CCT )
MaintenanceZone
( type: esriFieldTypeString, alias: Maintenance Zone, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Street_Lig ,
Coded Values:
[A: A] , [B: B] , [C: C]
, ...18 more...
)
LuminareCount
( type: esriFieldTypeDouble, alias: Luminare Count, editable: true, nullable: true, defaultValue: null, modelName: FX_CODE ,
Coded Values:
[1: 1] , [2: 2] , [0: 0] )
Voltage
( type: esriFieldTypeString, alias: Voltage, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Voltage ,
Coded Values:
[120v: 120v] , [240v: 240v] , [480v: 480v] )
Underground
( type: esriFieldTypeString, alias: Underground, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Undergroun ,
Coded Values:
[No: No] , [Solar: Solar] , [Yes: Yes] )
Metered
( type: esriFieldTypeString, alias: Metered, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Metered ,
Coded Values:
[Yes: Yes] , [No: No] )
TwinLight
( type: esriFieldTypeString, alias: Twin Light?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: TWINS_ ,
Coded Values:
[Yes: Yes] , [No: No] )
Pre2017Wattage
( type: esriFieldTypeSmallInteger, alias: Pre-2017 Wattage, editable: true, nullable: true, defaultValue: null, modelName: Pre2017Wattage )
iWorQ_ID_2
( type: esriFieldTypeString, alias: iWorQ ID 2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: iWorQ_ID_2 )
InstallDate
( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INS_DATE_D )
PhotocellType
( type: esriFieldTypeString, alias: Photocell Type, editable: true, nullable: true, length: 16, defaultValue: null, modelName: P_E_C_ ,
Coded Values:
[Photocell: Photocell] , [Shorting Cap: Shorting Cap] , [Other: Other] )
ProjectName
( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LED_Replac )
LEDProposed
( type: esriFieldTypeString, alias: Proposed LED Code, editable: true, nullable: true, length: 16, defaultValue: null, modelName: PROPOSED_1 )
SPID
( type: esriFieldTypeDouble, alias: SP ID, editable: true, nullable: true, defaultValue: null, modelName: SP_ID_1 )
SAID
( type: esriFieldTypeDouble, alias: SA ID, editable: true, nullable: true, defaultValue: null, modelName: SA_ID_1 )
NewLEDCode
( type: esriFieldTypeString, alias: New LED Code, editable: true, nullable: true, length: 40, defaultValue: null, modelName: NEW_LED_CA )
LEDConversionDate
( type: esriFieldTypeString, alias: LED Conversion Date, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LEDConversionDate )
StreetClass
( type: esriFieldTypeString, alias: Street Class, editable: true, nullable: false, length: 12, defaultValue: null, modelName: Street_Cla ,
Coded Values:
[Arterial: Arterial] , [Collector: Collector] , [Local: Local]
, ...4 more...
)
LLat
( type: esriFieldTypeDouble, alias: Lat, editable: true, nullable: true, defaultValue: null, modelName: Lat_1 )
LLong
( type: esriFieldTypeDouble, alias: Long, editable: true, nullable: true, defaultValue: null, modelName: Lon_1 )
HasNewEdits
( type: esriFieldTypeString, alias: Has New Edits, editable: true, nullable: true, length: 50, defaultValue: null, modelName: New_Edit_1 )
NewEditDate
( type: esriFieldTypeDate, alias: New Edit Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: New_Edit_D )
Status
( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 9, defaultValue: Active, modelName: Status ,
Coded Values:
[Active: Active] , [Retired: Retired] , [Proposed: Proposed] )
PGEBillingConfirmationDate
( type: esriFieldTypeDate, alias: PGEBillingConfirmationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PGEBillingConfirmationDate )
PGEBillingRequestDate
( type: esriFieldTypeDate, alias: PGEBillingRequestDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PGEBillingRequestDate )
Comments
( type: esriFieldTypeString, alias: Comments, editable: true, nullable: false, length: 254, defaultValue: null, modelName: COMMENT_1 )
UploadDate
( type: esriFieldTypeDate, alias: Upload Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UploadDate )
CreateDate
( type: esriFieldTypeDate, alias: Create Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
CreateBy
( type: esriFieldTypeString, alias: Create By, editable: false, nullable: true, length: 20, defaultValue: null, modelName: CreateBy )
RevDate
( type: esriFieldTypeDate, alias: Rev Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: RevDate )
RevBy
( type: esriFieldTypeString, alias: Rev By, editable: false, nullable: true, length: 20, defaultValue: null, modelName: RevBy )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Types:
ID: METAL HALIDE
Name: Metal Halide
Domains:
LightSource:
Inherited
PoleType:
Inherited
PoleHeight:
Inherited
LuminaireMounting:
Inherited
LightPoleFunction:
Inherited
PGEPoleFunction:
Inherited
Owner:
Inherited
RateSchedule:
Inherited
MaintenanceZone:
Inherited
LuminareCount:
Inherited
Voltage:
Inherited
Underground:
Inherited
Metered:
Inherited
TwinLight:
Inherited
PhotocellType:
Inherited
StreetClass:
Inherited
Status:
Inherited
Templates:
Name: Metal Halide
Description:
Prototype:
AccountNumber:
LightSource:
METAL HALIDE
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
UploadDate:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LmpCodeNew:
null
Lumens:
null
CCT:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQ_ID_2:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
Drawing Tool: esriFeatureEditToolPoint
ID: MERCURYVAPOR
Name: Mercury Vapor
Domains:
LightSource:
Inherited
PoleType:
Inherited
PoleHeight:
Inherited
LuminaireMounting:
Inherited
LightPoleFunction:
Inherited
PGEPoleFunction:
Inherited
Owner:
Inherited
RateSchedule:
Inherited
MaintenanceZone:
Inherited
LuminareCount:
Inherited
Voltage:
Inherited
Underground:
Inherited
Metered:
Inherited
TwinLight:
Inherited
PhotocellType:
Inherited
StreetClass:
Inherited
Status:
Inherited
Templates:
Name: Mercury Vapor
Description:
Prototype:
AccountNumber:
LightSource:
MERCURYVAPOR
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
UploadDate:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LmpCodeNew:
null
Lumens:
null
CCT:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQ_ID_2:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
Drawing Tool: esriFeatureEditToolPoint
ID: INDUCTION
Name: Induction
Domains:
LightSource:
Inherited
PoleType:
Inherited
PoleHeight:
Inherited
LuminaireMounting:
Inherited
LightPoleFunction:
Inherited
PGEPoleFunction:
Inherited
Owner:
Inherited
RateSchedule:
Inherited
MaintenanceZone:
Inherited
LuminareCount:
Inherited
Voltage:
Inherited
Underground:
Inherited
Metered:
Inherited
TwinLight:
Inherited
PhotocellType:
Inherited
StreetClass:
Inherited
Status:
Inherited
Templates:
Name: Induction
Description:
Prototype:
AccountNumber:
LightSource:
INDUCTION
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
UploadDate:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LmpCodeNew:
null
Lumens:
null
CCT:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQ_ID_2:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
Drawing Tool: esriFeatureEditToolPoint
ID: LED
Name: LED
Domains:
LightSource:
Inherited
PoleType:
Inherited
PoleHeight:
Inherited
LuminaireMounting:
Inherited
LightPoleFunction:
Inherited
PGEPoleFunction:
Inherited
Owner:
Inherited
RateSchedule:
Inherited
MaintenanceZone:
Inherited
LuminareCount:
Inherited
Voltage:
Inherited
Underground:
Inherited
Metered:
Inherited
TwinLight:
Inherited
PhotocellType:
Inherited
StreetClass:
Inherited
Status:
Inherited
Templates:
Name: LED
Description:
Prototype:
AccountNumber:
LightSource:
LED
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
UploadDate:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LmpCodeNew:
null
Lumens:
null
CCT:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQ_ID_2:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
Drawing Tool: esriFeatureEditToolPoint
ID: LPS
Name: LPS
Domains:
LightSource:
Inherited
PoleType:
Inherited
PoleHeight:
Inherited
LuminaireMounting:
Inherited
LightPoleFunction:
Inherited
PGEPoleFunction:
Inherited
Owner:
Inherited
RateSchedule:
Inherited
MaintenanceZone:
Inherited
LuminareCount:
Inherited
Voltage:
Inherited
Underground:
Inherited
Metered:
Inherited
TwinLight:
Inherited
PhotocellType:
Inherited
StreetClass:
Inherited
Status:
Inherited
Templates:
Name: LPS
Description:
Prototype:
AccountNumber:
LightSource:
LPS
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
UploadDate:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LmpCodeNew:
null
Lumens:
null
CCT:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQ_ID_2:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
Drawing Tool: esriFeatureEditToolPoint
ID: HPS
Name: HPS
Domains:
LightSource:
Inherited
PoleType:
Inherited
PoleHeight:
Inherited
LuminaireMounting:
Inherited
LightPoleFunction:
Inherited
PGEPoleFunction:
Inherited
Owner:
Inherited
RateSchedule:
Inherited
MaintenanceZone:
Inherited
LuminareCount:
Inherited
Voltage:
Inherited
Underground:
Inherited
Metered:
Inherited
TwinLight:
Inherited
PhotocellType:
Inherited
StreetClass:
Inherited
Status:
Inherited
Templates:
Name: HPS
Description:
Prototype:
AccountNumber:
LightSource:
HPS
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
UploadDate:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LmpCodeNew:
null
Lumens:
null
CCT:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQ_ID_2:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
Drawing Tool: esriFeatureEditToolPoint
ID: No Data
Name: No Data
Domains:
LightSource:
Inherited
PoleType:
Inherited
PoleHeight:
Inherited
LuminaireMounting:
Inherited
LightPoleFunction:
Inherited
PGEPoleFunction:
Inherited
Owner:
Inherited
RateSchedule:
Inherited
MaintenanceZone:
Inherited
LuminareCount:
Inherited
Voltage:
Inherited
Underground:
Inherited
Metered:
Inherited
TwinLight:
Inherited
PhotocellType:
Inherited
StreetClass:
Inherited
Status:
Inherited
Templates:
Name: No Data
Description:
Prototype:
AccountNumber:
LightSource:
No Data
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
UploadDate:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LmpCodeNew:
null
Lumens:
null
CCT:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQ_ID_2:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
Drawing Tool: esriFeatureEditToolPoint
Layer:
Retired Street Lights
(1)
Name:
Retired Street Lights
Display Field:
AccountNumber
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
Service Item Id:
25dc83eedcc5492d92b414e657557d04
Copyright Text:
Default Visibility: true
MaxRecordCount:
5000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
100000
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: -1.3580112930932045E7
YMin: 4474717.4886739375
XMax: -1.3571784324055882E7
YMax: 4482018.944500946
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
N/A
Description:
N/A
Transparency:
0
Labeling Info:
Label Placement:
esriServerPointLabelPlacementAboveRight
Label Expression:
[BadgeNumber]
Use Coded Values:
true
Symbol:
Color:
[0, 0, 0, 255]
Background Color:
N/A
Outline Color:
N/A
Vertical Alignment:
bottom
Horizontal Alignment:
center
Right to Left:
false
Angle:
0
XOffset:
0
YOffset:
0
Size:
8
Font Family:
Arial
Font Style:
italic
Font Weight:
normal
Font Decoration:
none
Min. Scale:
2500.0
Max. Scale:
0.0
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
AccountNumber
( type: esriFieldTypeString, alias: Account Number, editable: true, nullable: false, length: 11, defaultValue: null, modelName: ACCTNUM )
BadgeNumber
( type: esriFieldTypeDouble, alias: Badge Number, editable: true, nullable: false, defaultValue: null, modelName: BADGE_NU_3 )
BadgeNumberUnique
( type: esriFieldTypeString, alias: Badge Number Unique, editable: true, nullable: false, length: 7, defaultValue: null, modelName: Badge_Numb )
Location
( type: esriFieldTypeString, alias: Location, editable: true, nullable: false, length: 80, defaultValue: null, modelName: DESC_ADDR )
LightSource
( type: esriFieldTypeString, alias: Light Source, editable: true, nullable: false, length: 12, defaultValue: null, modelName: Light_Sour ,
Coded Values:
[HPS: HPS] , [INDUCTION: INDUCTION] , [LED: LED]
, ...4 more...
)
PresentWattage
( type: esriFieldTypeSmallInteger, alias: Present Wattage, editable: true, nullable: true, defaultValue: null, modelName: PresentWattage_838458 )
PoleType
( type: esriFieldTypeString, alias: Pole Type, editable: true, nullable: false, length: 14, defaultValue: null, modelName: POLE_TYP_1 ,
Coded Values:
[ALUMINUM: Aluminum] , [CAST IRON: Cast Iron] , [GALVANIZED: Galvanized]
, ...5 more...
)
PoleHeight
( type: esriFieldTypeString, alias: Pole Height, editable: true, nullable: true, length: 10, defaultValue: null, modelName: POLE_LGT_1 ,
Coded Values:
[10-12 FT: 10-12 FT] , [12-15 FT: 12-15 FT] , [16-19 FT: 16-19 FT]
, ...10 more...
)
LuminaireMounting
( type: esriFieldTypeString, alias: Luminaire Mounting, editable: true, nullable: true, length: 14, defaultValue: null, modelName: SUSPENSI_1 ,
Coded Values:
[30 INCHES: 30 INCHES] , [2 FT: 2 FT] , [4 FT: 4 FT]
, ...12 more...
)
LightPoleFunction
( type: esriFieldTypeString, alias: Light/Pole Function, editable: true, nullable: true, length: 16, defaultValue: null, modelName: LightPoleFunction ,
Coded Values:
[Decorative: Decorative] , [Parking Lot: Parking Lot] , [Pathway Lights: Pathway Lights]
, ...6 more...
)
PGEPoleFunction
( type: esriFieldTypeString, alias: PG&E Pole Function, editable: true, nullable: true, length: 14, defaultValue: null, modelName: PG_E_POLE_ ,
Coded Values:
[CUSTOMER OWNED: Customer Owned] , [DISTRIBUTION: Distribution] , [ST LIGHT ONLY: Street Light Only]
, ...1 more...
)
Owner
( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Owner ,
Coded Values:
[San Jose: San Jose] , [Caltrans: Caltrans] , [Campbell: Cambpell]
, ...1 more...
)
RateSchedule
( type: esriFieldTypeString, alias: Rate Schedule, editable: true, nullable: true, length: 6, defaultValue: null, modelName: RATE_SCH_1 ,
Coded Values:
[LS1-A: LS1-A] , [LS1-F: LS1-F] , [LS2-A: LS2-A] )
LampCode
( type: esriFieldTypeString, alias: Lamp Code, editable: true, nullable: true, length: 11, defaultValue: null, modelName: ITEM_COD_1 )
MaintenanceZone
( type: esriFieldTypeString, alias: Maintenance Zone, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Street_Lig ,
Coded Values:
[A: A] , [B: B] , [C: C]
, ...18 more...
)
LuminareCount
( type: esriFieldTypeDouble, alias: Luminare Count, editable: true, nullable: true, defaultValue: null, modelName: FX_CODE ,
Coded Values:
[1: 1] , [2: 2] , [0: 0] )
Voltage
( type: esriFieldTypeString, alias: Voltage, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Voltage ,
Coded Values:
[120v: 120v] , [240v: 240v] , [480v: 480v] )
Underground
( type: esriFieldTypeString, alias: Underground, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Undergroun ,
Coded Values:
[No: No] , [Solar: Solar] , [Yes: Yes] )
Metered
( type: esriFieldTypeString, alias: Metered, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Metered ,
Coded Values:
[Yes: Yes] , [No: No] )
TwinLight
( type: esriFieldTypeString, alias: Twin Light?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: TWINS_ ,
Coded Values:
[Yes: Yes] , [No: No] )
Pre2017Wattage
( type: esriFieldTypeSmallInteger, alias: Pre-2017 Wattage, editable: true, nullable: true, defaultValue: null, modelName: Pre2017Wattage )
iWorQID
( type: esriFieldTypeDouble, alias: Location ID, editable: true, nullable: true, defaultValue: null, modelName: iWorQ_Loca )
InstallDate
( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INS_DATE_D )
PhotocellType
( type: esriFieldTypeString, alias: Photocell Type, editable: true, nullable: true, length: 16, defaultValue: null, modelName: P_E_C_ ,
Coded Values:
[Photocell: Photocell] , [Shorting Cap: Shorting Cap] , [Other: Other] )
ProjectName
( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LED_Replac )
LEDProposed
( type: esriFieldTypeString, alias: Proposed LED Code, editable: true, nullable: true, length: 16, defaultValue: null, modelName: PROPOSED_1 )
SPID
( type: esriFieldTypeDouble, alias: SP ID, editable: true, nullable: true, defaultValue: null, modelName: SP_ID_1 )
SAID
( type: esriFieldTypeDouble, alias: SA ID, editable: true, nullable: true, defaultValue: null, modelName: SA_ID_1 )
NewLEDCode
( type: esriFieldTypeString, alias: New LED Code, editable: true, nullable: true, length: 40, defaultValue: null, modelName: NEW_LED_CA )
LEDConversionDate
( type: esriFieldTypeString, alias: LED Conversion Date, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LEDConversionDate )
StreetClass
( type: esriFieldTypeString, alias: Street Class, editable: true, nullable: false, length: 12, defaultValue: null, modelName: Street_Cla ,
Coded Values:
[Arterial: Arterial] , [Collector: Collector] , [Local: Local]
, ...4 more...
)
LLat
( type: esriFieldTypeDouble, alias: Lat, editable: true, nullable: true, defaultValue: null, modelName: Lat_1 )
LLong
( type: esriFieldTypeDouble, alias: Long, editable: true, nullable: true, defaultValue: null, modelName: Lon_1 )
HasNewEdits
( type: esriFieldTypeString, alias: Has New Edits, editable: true, nullable: true, length: 50, defaultValue: null, modelName: New_Edit_1 )
NewEditDate
( type: esriFieldTypeDate, alias: New Edit Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: New_Edit_D )
Status
( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 9, defaultValue: Active, modelName: Status ,
Coded Values:
[Active: Active] , [Retired: Retired] , [Proposed: Proposed] )
PGEBillingConfirmationDate
( type: esriFieldTypeDate, alias: PGEBillingConfirmationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PGEBillingConfirmationDate )
PGEBillingRequestDate
( type: esriFieldTypeDate, alias: PGEBillingRequestDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PGEBillingRequestDate )
Comments
( type: esriFieldTypeString, alias: Comments, editable: true, nullable: false, length: 254, defaultValue: null, modelName: COMMENT_1 )
UploadDate
( type: esriFieldTypeDate, alias: Upload Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UploadDate )
CreateDate
( type: esriFieldTypeDate, alias: Create Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
CreateBy
( type: esriFieldTypeString, alias: Create By, editable: false, nullable: true, length: 20, defaultValue: null, modelName: CreateBy )
RevDate
( type: esriFieldTypeDate, alias: Rev Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: RevDate )
RevBy
( type: esriFieldTypeString, alias: Rev By, editable: false, nullable: true, length: 20, defaultValue: null, modelName: RevBy )
iWorQ_ID_2
( type: esriFieldTypeString, alias: iWorQ_ID_2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: iWorQ_ID_2 )
LmpCodeNew
( type: esriFieldTypeString, alias: LmpCodeNew, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LmpCodeNew )
Lumens
( type: esriFieldTypeInteger, alias: Lumens, editable: true, nullable: true, defaultValue: null, modelName: Lumens )
CCT
( type: esriFieldTypeString, alias: CCT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CCT )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
Name: Metal Halide
Description:
Prototype:
AccountNumber:
LightSource:
METAL HALIDE
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
CCT:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LampCode:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQID:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
UploadDate:
null
Lumens:
null
LmpCodeNew:
null
iWorQ_ID_2:
null
Drawing Tool: esriFeatureEditToolPoint
Name: Mercury Vapor
Description:
Prototype:
AccountNumber:
LightSource:
MERCURYVAPOR
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
CCT:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LampCode:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQID:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
UploadDate:
null
Lumens:
null
LmpCodeNew:
null
iWorQ_ID_2:
null
Drawing Tool: esriFeatureEditToolPoint
Name: Induction
Description:
Prototype:
AccountNumber:
LightSource:
INDUCTION
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
CCT:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LampCode:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQID:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
UploadDate:
null
Lumens:
null
LmpCodeNew:
null
iWorQ_ID_2:
null
Drawing Tool: esriFeatureEditToolPoint
Name: LED
Description:
Prototype:
AccountNumber:
LightSource:
LED
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
CCT:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LampCode:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQID:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
UploadDate:
null
Lumens:
null
LmpCodeNew:
null
iWorQ_ID_2:
null
Drawing Tool: esriFeatureEditToolPoint
Name: LPS
Description:
Prototype:
AccountNumber:
LightSource:
LPS
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
CCT:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LampCode:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQID:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
UploadDate:
null
Lumens:
null
LmpCodeNew:
null
iWorQ_ID_2:
null
Drawing Tool: esriFeatureEditToolPoint
Name: HPS
Description:
Prototype:
AccountNumber:
LightSource:
HPS
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
CCT:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LampCode:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQID:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
UploadDate:
null
Lumens:
null
LmpCodeNew:
null
iWorQ_ID_2:
null
Drawing Tool: esriFeatureEditToolPoint
Name: No Data
Description:
Prototype:
AccountNumber:
LightSource:
No Data
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
CCT:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LampCode:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQID:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
UploadDate:
null
Lumens:
null
LmpCodeNew:
null
iWorQ_ID_2:
null
Drawing Tool: esriFeatureEditToolPoint
Layer:
Future Street Lights
(0)
Name:
Future Street Lights
Display Field:
AccountNumber
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
Service Item Id:
25dc83eedcc5492d92b414e657557d04
Copyright Text:
Default Visibility: true
MaxRecordCount:
5000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
100000
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: -1.3580112930932045E7
YMin: 4474717.4886739375
XMax: -1.3571784324055882E7
YMax: 4482018.944500946
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1:
LightSource
Field 2:
N/A
Field 3:
N/A
Field Delimiter:
,
Default Symbol:
N/A
Default Label:
N/A
UniqueValueInfos:
Value:
METAL HALIDE
Label:
Metal Halide
Description:
N/A
Symbol:
Value:
MERCURYVAPOR
Label:
Mercury Vapor
Description:
N/A
Symbol:
Value:
INDUCTION
Label:
Induction
Description:
N/A
Symbol:
Value:
LED
Label:
LED
Description:
N/A
Symbol:
Value:
LPS
Label:
LPS
Description:
N/A
Symbol:
Value:
HPS
Label:
HPS
Description:
N/A
Symbol:
Value:
No Data
Label:
No Data
Description:
N/A
Symbol:
Transparency:
0
Labeling Info:
Label Placement:
esriServerPointLabelPlacementAboveRight
Label Expression:
[BadgeNumber]
Use Coded Values:
true
Symbol:
Color:
[0, 0, 0, 255]
Background Color:
N/A
Outline Color:
N/A
Vertical Alignment:
bottom
Horizontal Alignment:
center
Right to Left:
false
Angle:
0
XOffset:
0
YOffset:
0
Size:
8
Font Family:
Arial
Font Style:
italic
Font Weight:
normal
Font Decoration:
none
Min. Scale:
2500.0
Max. Scale:
0.0
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
LightSource
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
AccountNumber
( type: esriFieldTypeString, alias: Account Number, editable: true, nullable: false, length: 11, defaultValue: null, modelName: ACCTNUM )
BadgeNumber
( type: esriFieldTypeDouble, alias: Badge Number, editable: true, nullable: false, defaultValue: null, modelName: BADGE_NU_3 )
BadgeNumberUnique
( type: esriFieldTypeString, alias: Badge Number Unique, editable: true, nullable: false, length: 7, defaultValue: null, modelName: Badge_Numb )
Location
( type: esriFieldTypeString, alias: Location, editable: true, nullable: false, length: 80, defaultValue: null, modelName: DESC_ADDR )
LightSource
( type: esriFieldTypeString, alias: Light Source, editable: true, nullable: false, length: 12, defaultValue: null, modelName: Light_Sour ,
Coded Values:
[HPS: HPS] , [INDUCTION: INDUCTION] , [LED: LED]
, ...4 more...
)
PresentWattage
( type: esriFieldTypeSmallInteger, alias: Present Wattage, editable: true, nullable: true, defaultValue: null, modelName: PresentWattage_838458 )
PoleType
( type: esriFieldTypeString, alias: Pole Type, editable: true, nullable: false, length: 14, defaultValue: null, modelName: POLE_TYP_1 ,
Coded Values:
[ALUMINUM: Aluminum] , [CAST IRON: Cast Iron] , [GALVANIZED: Galvanized]
, ...5 more...
)
PoleHeight
( type: esriFieldTypeString, alias: Pole Height, editable: true, nullable: true, length: 10, defaultValue: null, modelName: POLE_LGT_1 ,
Coded Values:
[10-12 FT: 10-12 FT] , [12-15 FT: 12-15 FT] , [16-19 FT: 16-19 FT]
, ...10 more...
)
LuminaireMounting
( type: esriFieldTypeString, alias: Luminaire Mounting, editable: true, nullable: true, length: 14, defaultValue: null, modelName: SUSPENSI_1 ,
Coded Values:
[30 INCHES: 30 INCHES] , [2 FT: 2 FT] , [4 FT: 4 FT]
, ...12 more...
)
LightPoleFunction
( type: esriFieldTypeString, alias: Light/Pole Function, editable: true, nullable: true, length: 16, defaultValue: null, modelName: LightPoleFunction ,
Coded Values:
[Decorative: Decorative] , [Parking Lot: Parking Lot] , [Pathway Lights: Pathway Lights]
, ...6 more...
)
PGEPoleFunction
( type: esriFieldTypeString, alias: PG&E Pole Function, editable: true, nullable: true, length: 14, defaultValue: null, modelName: PG_E_POLE_ ,
Coded Values:
[CUSTOMER OWNED: Customer Owned] , [DISTRIBUTION: Distribution] , [ST LIGHT ONLY: Street Light Only]
, ...1 more...
)
Owner
( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Owner ,
Coded Values:
[San Jose: San Jose] , [Caltrans: Caltrans] , [Campbell: Cambpell]
, ...1 more...
)
RateSchedule
( type: esriFieldTypeString, alias: Rate Schedule, editable: true, nullable: true, length: 6, defaultValue: null, modelName: RATE_SCH_1 ,
Coded Values:
[LS1-A: LS1-A] , [LS1-F: LS1-F] , [LS2-A: LS2-A] )
LmpCodeNew
( type: esriFieldTypeString, alias: Lamp Code New, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LmpCodeNew )
Lumens
( type: esriFieldTypeInteger, alias: Lumens, editable: true, nullable: true, defaultValue: null, modelName: Lumens )
CCT
( type: esriFieldTypeString, alias: CCT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CCT )
MaintenanceZone
( type: esriFieldTypeString, alias: Maintenance Zone, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Street_Lig ,
Coded Values:
[A: A] , [B: B] , [C: C]
, ...18 more...
)
LuminareCount
( type: esriFieldTypeDouble, alias: Luminare Count, editable: true, nullable: true, defaultValue: null, modelName: FX_CODE ,
Coded Values:
[1: 1] , [2: 2] , [0: 0] )
Voltage
( type: esriFieldTypeString, alias: Voltage, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Voltage ,
Coded Values:
[120v: 120v] , [240v: 240v] , [480v: 480v] )
Underground
( type: esriFieldTypeString, alias: Underground, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Undergroun ,
Coded Values:
[No: No] , [Solar: Solar] , [Yes: Yes] )
Metered
( type: esriFieldTypeString, alias: Metered, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Metered ,
Coded Values:
[Yes: Yes] , [No: No] )
TwinLight
( type: esriFieldTypeString, alias: Twin Light?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: TWINS_ ,
Coded Values:
[Yes: Yes] , [No: No] )
Pre2017Wattage
( type: esriFieldTypeSmallInteger, alias: Pre-2017 Wattage, editable: true, nullable: true, defaultValue: null, modelName: Pre2017Wattage )
iWorQ_ID_2
( type: esriFieldTypeString, alias: iWorQ ID 2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: iWorQ_ID_2 )
InstallDate
( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INS_DATE_D )
PhotocellType
( type: esriFieldTypeString, alias: Photocell Type, editable: true, nullable: true, length: 16, defaultValue: null, modelName: P_E_C_ ,
Coded Values:
[Photocell: Photocell] , [Shorting Cap: Shorting Cap] , [Other: Other] )
ProjectName
( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LED_Replac )
LEDProposed
( type: esriFieldTypeString, alias: Proposed LED Code, editable: true, nullable: true, length: 16, defaultValue: null, modelName: PROPOSED_1 )
SPID
( type: esriFieldTypeDouble, alias: SP ID, editable: true, nullable: true, defaultValue: null, modelName: SP_ID_1 )
SAID
( type: esriFieldTypeDouble, alias: SA ID, editable: true, nullable: true, defaultValue: null, modelName: SA_ID_1 )
NewLEDCode
( type: esriFieldTypeString, alias: New LED Code, editable: true, nullable: true, length: 40, defaultValue: null, modelName: NEW_LED_CA )
LEDConversionDate
( type: esriFieldTypeString, alias: LED Conversion Date, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LEDConversionDate )
StreetClass
( type: esriFieldTypeString, alias: Street Class, editable: true, nullable: false, length: 12, defaultValue: null, modelName: Street_Cla ,
Coded Values:
[Arterial: Arterial] , [Collector: Collector] , [Local: Local]
, ...4 more...
)
LLat
( type: esriFieldTypeDouble, alias: Lat, editable: true, nullable: true, defaultValue: null, modelName: Lat_1 )
LLong
( type: esriFieldTypeDouble, alias: Long, editable: true, nullable: true, defaultValue: null, modelName: Lon_1 )
HasNewEdits
( type: esriFieldTypeString, alias: Has New Edits, editable: true, nullable: true, length: 50, defaultValue: null, modelName: New_Edit_1 )
NewEditDate
( type: esriFieldTypeDate, alias: New Edit Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: New_Edit_D )
Status
( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 9, defaultValue: Active, modelName: Status ,
Coded Values:
[Active: Active] , [Retired: Retired] , [Proposed: Proposed] )
PGEBillingConfirmationDate
( type: esriFieldTypeDate, alias: PGEBillingConfirmationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PGEBillingConfirmationDate )
PGEBillingRequestDate
( type: esriFieldTypeDate, alias: PGEBillingRequestDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PGEBillingRequestDate )
Comments
( type: esriFieldTypeString, alias: Comments, editable: true, nullable: false, length: 254, defaultValue: null, modelName: COMMENT_1 )
UploadDate
( type: esriFieldTypeDate, alias: Upload Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UploadDate )
CreateDate
( type: esriFieldTypeDate, alias: Create Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
CreateBy
( type: esriFieldTypeString, alias: Create By, editable: false, nullable: true, length: 20, defaultValue: null, modelName: CreateBy )
RevDate
( type: esriFieldTypeDate, alias: Rev Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: RevDate )
RevBy
( type: esriFieldTypeString, alias: Rev By, editable: false, nullable: true, length: 20, defaultValue: null, modelName: RevBy )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Types:
ID: METAL HALIDE
Name: Metal Halide
Domains:
LightSource:
Inherited
PoleType:
Inherited
PoleHeight:
Inherited
LuminaireMounting:
Inherited
LightPoleFunction:
Inherited
PGEPoleFunction:
Inherited
Owner:
Inherited
RateSchedule:
Inherited
MaintenanceZone:
Inherited
LuminareCount:
Inherited
Voltage:
Inherited
Underground:
Inherited
Metered:
Inherited
TwinLight:
Inherited
PhotocellType:
Inherited
StreetClass:
Inherited
Status:
Inherited
Templates:
Name: Metal Halide
Description:
Prototype:
AccountNumber:
LightSource:
METAL HALIDE
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
UploadDate:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LmpCodeNew:
null
Lumens:
null
CCT:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQ_ID_2:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
Drawing Tool: esriFeatureEditToolPoint
ID: MERCURYVAPOR
Name: Mercury Vapor
Domains:
LightSource:
Inherited
PoleType:
Inherited
PoleHeight:
Inherited
LuminaireMounting:
Inherited
LightPoleFunction:
Inherited
PGEPoleFunction:
Inherited
Owner:
Inherited
RateSchedule:
Inherited
MaintenanceZone:
Inherited
LuminareCount:
Inherited
Voltage:
Inherited
Underground:
Inherited
Metered:
Inherited
TwinLight:
Inherited
PhotocellType:
Inherited
StreetClass:
Inherited
Status:
Inherited
Templates:
Name: Mercury Vapor
Description:
Prototype:
AccountNumber:
LightSource:
MERCURYVAPOR
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
UploadDate:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LmpCodeNew:
null
Lumens:
null
CCT:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQ_ID_2:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
Drawing Tool: esriFeatureEditToolPoint
ID: INDUCTION
Name: Induction
Domains:
LightSource:
Inherited
PoleType:
Inherited
PoleHeight:
Inherited
LuminaireMounting:
Inherited
LightPoleFunction:
Inherited
PGEPoleFunction:
Inherited
Owner:
Inherited
RateSchedule:
Inherited
MaintenanceZone:
Inherited
LuminareCount:
Inherited
Voltage:
Inherited
Underground:
Inherited
Metered:
Inherited
TwinLight:
Inherited
PhotocellType:
Inherited
StreetClass:
Inherited
Status:
Inherited
Templates:
Name: Induction
Description:
Prototype:
AccountNumber:
LightSource:
INDUCTION
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
UploadDate:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LmpCodeNew:
null
Lumens:
null
CCT:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQ_ID_2:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
Drawing Tool: esriFeatureEditToolPoint
ID: LED
Name: LED
Domains:
LightSource:
Inherited
PoleType:
Inherited
PoleHeight:
Inherited
LuminaireMounting:
Inherited
LightPoleFunction:
Inherited
PGEPoleFunction:
Inherited
Owner:
Inherited
RateSchedule:
Inherited
MaintenanceZone:
Inherited
LuminareCount:
Inherited
Voltage:
Inherited
Underground:
Inherited
Metered:
Inherited
TwinLight:
Inherited
PhotocellType:
Inherited
StreetClass:
Inherited
Status:
Inherited
Templates:
Name: LED
Description:
Prototype:
AccountNumber:
LightSource:
LED
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
UploadDate:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LmpCodeNew:
null
Lumens:
null
CCT:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQ_ID_2:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
Drawing Tool: esriFeatureEditToolPoint
ID: LPS
Name: LPS
Domains:
LightSource:
Inherited
PoleType:
Inherited
PoleHeight:
Inherited
LuminaireMounting:
Inherited
LightPoleFunction:
Inherited
PGEPoleFunction:
Inherited
Owner:
Inherited
RateSchedule:
Inherited
MaintenanceZone:
Inherited
LuminareCount:
Inherited
Voltage:
Inherited
Underground:
Inherited
Metered:
Inherited
TwinLight:
Inherited
PhotocellType:
Inherited
StreetClass:
Inherited
Status:
Inherited
Templates:
Name: LPS
Description:
Prototype:
AccountNumber:
LightSource:
LPS
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
UploadDate:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LmpCodeNew:
null
Lumens:
null
CCT:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQ_ID_2:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
Drawing Tool: esriFeatureEditToolPoint
ID: HPS
Name: HPS
Domains:
LightSource:
Inherited
PoleType:
Inherited
PoleHeight:
Inherited
LuminaireMounting:
Inherited
LightPoleFunction:
Inherited
PGEPoleFunction:
Inherited
Owner:
Inherited
RateSchedule:
Inherited
MaintenanceZone:
Inherited
LuminareCount:
Inherited
Voltage:
Inherited
Underground:
Inherited
Metered:
Inherited
TwinLight:
Inherited
PhotocellType:
Inherited
StreetClass:
Inherited
Status:
Inherited
Templates:
Name: HPS
Description:
Prototype:
AccountNumber:
LightSource:
HPS
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
UploadDate:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LmpCodeNew:
null
Lumens:
null
CCT:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQ_ID_2:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
Drawing Tool: esriFeatureEditToolPoint
ID: No Data
Name: No Data
Domains:
LightSource:
Inherited
PoleType:
Inherited
PoleHeight:
Inherited
LuminaireMounting:
Inherited
LightPoleFunction:
Inherited
PGEPoleFunction:
Inherited
Owner:
Inherited
RateSchedule:
Inherited
MaintenanceZone:
Inherited
LuminareCount:
Inherited
Voltage:
Inherited
Underground:
Inherited
Metered:
Inherited
TwinLight:
Inherited
PhotocellType:
Inherited
StreetClass:
Inherited
Status:
Inherited
Templates:
Name: No Data
Description:
Prototype:
AccountNumber:
LightSource:
No Data
PresentWattage:
BadgeNumber:
0
LEDConversionDate:
null
Location:
BadgeNumberUnique:
UploadDate:
null
PGEBillingRequestDate:
null
PoleType:
PoleHeight:
null
LuminaireMounting:
null
LightPoleFunction:
null
PGEPoleFunction:
null
Owner:
null
RateSchedule:
null
LmpCodeNew:
null
Lumens:
null
CCT:
null
MaintenanceZone:
null
LuminareCount:
null
Voltage:
null
Underground:
null
Metered:
null
TwinLight:
null
Pre2017Wattage:
null
iWorQ_ID_2:
null
InstallDate:
null
PhotocellType:
null
ProjectName:
null
LEDProposed:
null
SPID:
null
SAID:
null
NewLEDCode:
null
StreetClass:
LLat:
null
LLong:
null
HasNewEdits:
null
NewEditDate:
null
Status:
Active
PGEBillingConfirmationDate:
null
Comments:
Drawing Tool: esriFeatureEditToolPoint