View In:
ArcGIS Online Map Viewer
Name: Park Lighting
Display Field: ParkName
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: Field data collected from third party company (Tanko) in April 2014. Data field verfied by Steve Crego by request. Pole IDs of N5000 and up are Tanko created IDs. Pole IDs with a prefix N are from prior to 1984 and with prefix E are from 1984 and after. M prefix IDs are metered and are billed differently than non meteterd.
Copyright Text: City of Napa GIS Department
Default Visibility: true
MaxRecordCount: 1000
Supported Query Formats: JSON, geoJSON
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: false
Supports Datum Transformation: true
Extent:
XMin: 6477463.912980139
YMin: 1856469.5140850544
XMax: 6480650.838036716
YMax: 1871913.5635774732
Spatial Reference: 102642
(2226)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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
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
)
-
FacilityID
(
type: esriFieldTypeString, alias: Lucity ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID
)
-
OperationalFlag
(
type: esriFieldTypeSmallInteger, alias: Operational Flag, editable: true, nullable: true, defaultValue: 1, modelName: OPERATIONAL_FLAG
,
Coded Values:
[0: False]
,
[1: True]
)
-
ParkName
(
type: esriFieldTypeString, alias: ParkName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ParkName
,
Coded Values:
[PKMP01: 9-11 Memorial Park]
,
[PKMP02: Abruzzini Park]
,
[PKMP03: Alston Park]
, ...60 more...
)
-
LocDesc
(
type: esriFieldTypeString, alias: LocDesc, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Address
)
-
OwnedBY
(
type: esriFieldTypeSmallInteger, alias: Ownedby, editable: true, nullable: true, defaultValue: null, modelName: Ownedby
,
Coded Values:
[1: City of Napa]
,
[2: County of Napa]
,
[3: State of California]
)
-
MaintBy
(
type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: null, modelName: Mainby
,
Coded Values:
[1: City of Napa]
,
[2: Parks Dpt - City of Napa]
,
[3: Streets Dpt - City of Napa]
, ...1 more...
)
-
LampType
(
type: esriFieldTypeString, alias: Lamp Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAMPTYPE_TXT
,
Coded Values:
[HPS: High Pressure]
,
[LED: Light Emitting Diode]
,
[MH: Metal Halide]
)
-
Metered
(
type: esriFieldTypeSmallInteger, alias: Metered, editable: true, nullable: true, defaultValue: null, modelName: METERED_SI
,
Coded Values:
[0: False]
,
[1: True]
)
-
PhotoCell
(
type: esriFieldTypeSmallInteger, alias: Photo cell, editable: true, nullable: true, defaultValue: null, modelName: PHOTOCELL_SI
,
Coded Values:
[0: False]
,
[1: True]
)
-
PoleHeight
(
type: esriFieldTypeSmallInteger, alias: Pole Height, editable: true, nullable: true, defaultValue: null, modelName: POLEHEIGHT_SI
,
Coded Values:
[1: 10 FT]
,
[2: 15 FT]
,
[3: 20 FT]
, ...7 more...
)
-
PoleMaterial
(
type: esriFieldTypeSmallInteger, alias: Pole Material, editable: true, nullable: true, defaultValue: null, modelName: POLEMATERIAL_SI
,
Coded Values:
[0: Concrete]
,
[1: Fiberglass]
,
[2: Metal]
, ...5 more...
)
-
Voltage
(
type: esriFieldTypeSmallInteger, alias: Voltage, editable: true, nullable: true, defaultValue: null, modelName: VOLTAGE_SI
,
Coded Values:
[1: 120 V]
,
[2: 240 V]
,
[49: No Reading]
, ...2 more...
)
-
ArmLength
(
type: esriFieldTypeSmallInteger, alias: Arm Length, editable: true, nullable: true, defaultValue: null, modelName: ARMLENGTH_SI
,
Coded Values:
[0: Long]
,
[1: N/A]
,
[2: Short]
, ...3 more...
)
-
FixtureType
(
type: esriFieldTypeSmallInteger, alias: Fixture Type, editable: true, nullable: true, defaultValue: null, modelName: FIXTURETYPE_SI
,
Coded Values:
[1: Cobra Head]
,
[2: Cree]
,
[3: Decorative]
, ...2 more...
)
-
Heads
(
type: esriFieldTypeSmallInteger, alias: Heads, editable: true, nullable: true, defaultValue: null, modelName: HEADS_SI
,
Coded Values:
[1: Single]
,
[2: Double]
,
[3: Triple]
)
-
LucityMaintZone
(
type: esriFieldTypeString, alias: Supervisor Area, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LucMaintZone
)
-
InLucity
(
type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: null, modelName: INLUCITY
,
Coded Values:
[0: False]
,
[1: True]
)
-
LucityLinkID
(
type: esriFieldTypeInteger, alias: Lucity Link ID, editable: true, nullable: true, defaultValue: null, modelName: LUCITYLINKID
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID
)
-
Condition
(
type: esriFieldTypeSmallInteger, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: Condition
)
-
ReplacementUnitCost
(
type: esriFieldTypeDouble, alias: Replacement/Unit cost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementUnitCost
)
-
ParkID
(
type: esriFieldTypeInteger, alias: Lucity Park ID, editable: true, nullable: true, defaultValue: null, modelName: ParkID
)
-
ServiceLife
(
type: esriFieldTypeDouble, alias: Service Life Yrs, editable: true, nullable: true, defaultValue: null, modelName: ServiceLife
)
-
PurchaseDate
(
type: esriFieldTypeDate, alias: Purchase Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PurchaseDate
)
-
InspectionDate
(
type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate
)
-
UnitCost
(
type: esriFieldTypeDouble, alias: UnitCost, editable: true, nullable: true, defaultValue: null, modelName: UnitCost
)
-
CapitalReplacementDate
(
type: esriFieldTypeDate, alias: CapitalReplacementDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CapitalReplacementDate
)
Templates:
-
Name: Park Lighting
Description:
Prototype:
UnitCost: null
FacilityID: null
OperationalFlag: null
ParkName: null
LocDesc: null
OwnedBY: null
MaintBy: null
LampType: null
Metered: null
PhotoCell: null
PoleHeight: null
PoleMaterial: null
Voltage: null
ArmLength: null
FixtureType: null
Heads: null
LucityMaintZone: null
InLucity: null
LucityLinkID: null
InspectionDate: null
CapitalReplacementDate: null
Condition: null
ReplacementUnitCost: null
ParkID: null
ServiceLife: null
PurchaseDate: null
Drawing Tool: esriFeatureEditToolPoint
Capabilities: Query,Create,Update,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: created_date
- Creator Field: created_user
- Edit Date Field: last_edited_date
- Editor Field: last_edited_user
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Supported Operations:
Query
Query Attachments
Apply Edits
Add Features
Update Features
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata