Name: Street Light
Display Field: SAPID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: This dataset identifies street light poles within the City of San Diego. Features are represented as points indicating the mapped location of street light poles maintained by the City of San Diego Transportation Department. Attribute information supports identification and management of the pole and associated street lighting equipment. The geographic extent is limited to the City of San Diego.
Service Item Id: dcee747168fa4fdf9001a9f653e39535
Copyright Text: This dataset was created and is maintained by the City of San Diego's Transportation Department. Data sources include SanGIS, city records, aerial imagery, and field surveys. The data was processed and managed using ArcGIS software from Esri.
Default Visibility: false
MaxRecordCount: 2000
MaxSelectionCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 20000.0
Max Scale: 0.0
Supports Advanced Queries: true
Supports Statistics: true
Has Labels: false
Can Modify Layer: true
Can Scale Symbols: true
Use Standardized Queries: true
Supports Datum Transformation: true
Extent:
XMin: 6244818.000069797
YMin: 1777818.6169197261
XMax: 6352839.020903975
YMax: 1985242.6610603184
Spatial Reference: 102646
(2230)
LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Feature Draw Order:
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true
HasZ: true
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
SAPID
(
type: esriFieldTypeString, alias: SAP ID, length: 13
)
-
STATUS
(
type: esriFieldTypeString, alias: Status, length: 1
, Coded Values:
[A: Active]
, [I: Inactive]
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
-
CDCODE
(
type: esriFieldTypeInteger, alias: CDCODE
, Coded Values:
[1: 1]
, [2: 2]
, [3: 3]
, ...7 more...
)
-
CODE
(
type: esriFieldTypeSmallInteger, alias: CODE
, Coded Values:
[1: NORTHERN]
, [3: SOUTHERN]
)
-
CPCODE
(
type: esriFieldTypeInteger, alias: CPCODE
, Coded Values:
[1: Balboa Park]
, [2: Barrio Logan]
, [13: Black Mountain Ranch]
, ...55 more...
)
-
WHERE_INSTALLED
(
type: esriFieldTypeString, alias: WHERE_INSTALLED, length: 30
)
-
SAPOBJNR
(
type: esriFieldTypeString, alias: SAPOBJNR, length: 22
)
-
IAMFLOC
(
type: esriFieldTypeString, alias: IAMFLOC, length: 30
)
-
MAPNG_STAT_CD
(
type: esriFieldTypeString, alias: MAPNG_STAT_CD, length: 2
, Coded Values:
[AB: AS BUILT]
, [AN: ABANDONED]
, [OP: OPERATIONAL]
, ...3 more...
)
-
LOC_DESC
(
type: esriFieldTypeString, alias: LOC_DESC, length: 40
)
-
INST_YR
(
type: esriFieldTypeDate, alias: INST_YR, length: 8
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, length: 255
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, length: 8
)
-
MAINT
(
type: esriFieldTypeString, alias: Maintained By, length: 1
, Coded Values:
[1: CITY OF SAN DIEGO, STREET DIV]
, [2: CITY OF SAN DIEGO, PARK & REC]
, [3: CITY OF SAN DIEGO, METRO WASTEWATER]
, ...18 more...
)
-
SG_FLOC
(
type: esriFieldTypeString, alias: Signal Pole FLOC, length: 30
)
-
SG_INT_FLOC
(
type: esriFieldTypeString, alias: Signalized Intersection FLOC, length: 30
)
-
SVC_PT_LOC
(
type: esriFieldTypeString, alias: Service Point Location, length: 40
)
-
LIT_SVC_TYPE
(
type: esriFieldTypeString, alias: Lighting Service Type, length: 3
, Coded Values:
[AP: Airport]
, [SA: Alley]
, [BP: Ballpark]
, ...20 more...
)
-
POLE_TYPE
(
type: esriFieldTypeString, alias: Pole Type, length: 3
, Coded Values:
[CDB: Concrete DB]
, [CD: Concrete Decorative]
, [MSP: Multi-Section Pole]
, ...6 more...
)
-
POLE_HEAD_TYPE
(
type: esriFieldTypeString, alias: Pole Head Type, length: 3
, Coded Values:
[C: Cobra]
, [PT: Post-top]
, [OTH: Other]
, ...1 more...
)
-
MAST_ARM
(
type: esriFieldTypeString, alias: Mast Arm, length: 3
, Coded Values:
[S: Single]
, [S4: Single - 4]
, [S6: Single - 6]
, ...9 more...
)
-
POLE_MATERIAL
(
type: esriFieldTypeString, alias: Pole Material, length: 3
, Coded Values:
[C: Concrete]
, [F: Fiberglass]
, [S: Steel]
, ...3 more...
)
-
POLE_COLOR
(
type: esriFieldTypeString, alias: Pole Color, length: 3
, Coded Values:
[BK: Black, Gloss]
, [CG: Chard Green]
, [DB: Dark Bronze]
, ...7 more...
)
-
POLE_HEIGHT_FT
(
type: esriFieldTypeInteger, alias: Pole Height (ft)
, Coded Values:
[10: 10]
, [12: 12]
, [15: 15]
, ...3 more...
)
-
SERIES_CIRCUIT
(
type: esriFieldTypeString, alias: Series Circuit, length: 3
, Coded Values:
[Y: Yes]
, [N: No]
, [NA: Not Applicable]
, ...1 more...
)
-
SERIES_CIRCUIT_NAME
(
type: esriFieldTypeString, alias: Series Circuit Name, length: 255
)
-
WIRE_GAUGE
(
type: esriFieldTypeString, alias: Wire Gauge, length: 3
, Coded Values:
[6: 6AWG]
, [8: 8AWG]
, [10: 10AWG]
, ...4 more...
)
-
STRING_LIGHT
(
type: esriFieldTypeString, alias: String Light, length: 3
, Coded Values:
[Y: Yes]
, [N: No]
, [NA: Not Applicable]
, ...1 more...
)
-
SDGE_WORK_ORDER_NO
(
type: esriFieldTypeString, alias: SDGE Work Order Number, length: 40
)
-
DRAWING_NO
(
type: esriFieldTypeString, alias: As-Built Drawing Number, length: 30
)
-
BANNER_DISTRICT
(
type: esriFieldTypeString, alias: Banner District, length: 3
, Coded Values:
[Y: Yes]
, [N: No]
, [NA: Not Applicable]
, ...1 more...
)
-
MAD
(
type: esriFieldTypeString, alias: Maintenance Assessment District, length: 50
)
-
NOTES
(
type: esriFieldTypeString, alias: Notes, length: 255
)
-
EQUIPMENT_ID
(
type: esriFieldTypeString, alias: Equipment ID, length: 10
)
-
POLE_NUMBER
(
type: esriFieldTypeDouble, alias: Pole Number
)
-
EVARI_POLE_NO
(
type: esriFieldTypeInteger, alias: Evari Pole Number
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata