View In:   ArcGIS Online Map Viewer

Name: Street Lights

Display Field: FACILITYID

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:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 6000

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: 6460779.843083948
YMin: 1855553.5043083131
XMax: 6488181.589871552
YMax: 1889580.0061370656
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: false

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: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• POLENUMBER ( type: esriFieldTypeString, alias: PoleNumber, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PoleNumber )
• STREETNUM ( type: esriFieldTypeString, alias: Street num, editable: true, nullable: true, length: 5, defaultValue: null, modelName: STREETNUM )
• STREET ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Street )
• TYPEANDWATTAGE ( type: esriFieldTypeString, alias: TypeAndWattage, editable: true, nullable: true, length: 15, defaultValue: null, modelName: TypeAndWattage , Coded Values: [HPS 70: HPS 70] , [HPS 100: HPS 100] , [HPS UNKNOWN: HPS UNKNOWN] , ...20 more... )
• SPID ( type: esriFieldTypeString, alias: SPID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SPID )
• ARMLENGTH ( type: esriFieldTypeSmallInteger, alias: ArmLength, editable: true, nullable: true, defaultValue: null, modelName: ARMLENGTH_SI , Coded Values: [0: Long] , [1: N/A] , [2: Short] , ...3 more... )
• CATEGORY ( type: esriFieldTypeString, alias: Category, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Category , Coded Values: [1: SAFTEY LIGHT] , [2: STANDARD] )
• FIXTURETYPE ( type: esriFieldTypeSmallInteger, alias: FixtureType, 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] )
• INSTALLDATE ( type: esriFieldTypeDate, alias: InstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• LAMPTYPE ( type: esriFieldTypeString, alias: LampType, editable: true, nullable: true, length: 12, defaultValue: null, modelName: LAMPTYPE_TXT , Coded Values: [HPS: High Pressure] , [LED: Light Emitting Diode] , [MH: Metal Halide] )
• LOCDESC ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Address )
• METERED ( type: esriFieldTypeSmallInteger, alias: Metered, editable: true, nullable: true, defaultValue: null, modelName: METERED_SI , Coded Values: [0: False] , [1: True] )
• ORIGINALLAMPTYPE ( type: esriFieldTypeString, alias: OriginalLampType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ORIGINALLAMPTYPE )
• ORIGINALWATTAGE ( type: esriFieldTypeString, alias: OriginalWattage, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OriginalWattage , Coded Values: [24: 24] , [29: 29] , [35: 35] , ...17 more... )
• 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] )
• PHOTOCELL ( type: esriFieldTypeSmallInteger, alias: Photocell, editable: true, nullable: true, defaultValue: null, modelName: PHOTOCELL_SI , Coded Values: [0: False] , [1: True] )
• POLEHEIGHT ( type: esriFieldTypeSmallInteger, alias: PoleHeight, 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: PoleMaterial, editable: true, nullable: true, defaultValue: null, modelName: POLEMATERIAL_SI , Coded Values: [0: Concrete] , [1: Fiberglass] , [2: Metal] , ...5 more... )
• PRODUCT ( type: esriFieldTypeString, alias: Product, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Product , Coded Values: [1: CREE BETA LEDWAY] , [2: CREE XSP1] , [3: 8020 POST TOP] , ...2 more... )
• TWINSPID ( type: esriFieldTypeString, alias: TwinSPID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TwinPN )
• 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... )
• WATTAGE ( type: esriFieldTypeSmallInteger, alias: Wattage, editable: true, nullable: true, defaultValue: null, modelName: WATTAGE_SI , Coded Values: [0: 24] , [1: 29] , [2: 35] , ...17 more... )
• ACCURACY ( type: esriFieldTypeString, alias: Accuracy, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Accuracy )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Maint 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... )
• ALT_LOCATION ( type: esriFieldTypeString, alias: Alt Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION )
• MAINT_ZONE ( type: esriFieldTypeString, alias: Maint Zone, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LucMaintZone )
• ALT_MAINT_ZONE ( type: esriFieldTypeString, alias: Alt Maint Zone, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LucAltZone )
• INMAP ( type: esriFieldTypeSmallInteger, alias: In Map, editable: true, nullable: true, defaultValue: 1, modelName: INMAP )
• INLUCITY ( type: esriFieldTypeSmallInteger, alias: In Lucity, editable: true, nullable: true, defaultValue: null, modelName: INLUCITY , Coded Values: [0: False] , [1: True] )
• OPERATIONAL_FLAG ( type: esriFieldTypeSmallInteger, alias: Operational Flag, editable: true, nullable: true, defaultValue: 1, modelName: OPERATIONAL_FLAG , Coded Values: [0: False] , [1: True] )
• LUCITYLINKID ( type: esriFieldTypeInteger, alias: Lucity Link ID, editable: true, nullable: true, defaultValue: null, modelName: LUCITYLINKID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Street Lights
  Description:
  Prototype:
  LUCITYLINKID: null
  FACILITYID: null
  POLENUMBER: null
  STREETNUM: null
  STREET: null
  TYPEANDWATTAGE: null
  SPID: null
  ARMLENGTH: null
  CATEGORY: null
  FIXTURETYPE: null
  HEADS: null
  INSTALLDATE: null
  LAMPTYPE: null
  LOCDESC: null
  METERED: null
  ORIGINALLAMPTYPE: null
  ORIGINALWATTAGE: null
  OWNEDBY: null
  PHOTOCELL: null
  POLEHEIGHT: null
  POLEMATERIAL: null
  PRODUCT: null
  TWINSPID: null
  VOLTAGE: null
  WATTAGE: null
  ACCURACY: null
  OPERATIONAL_FLAG: null
  INLUCITY: null
  INMAP: null
  ALT_MAINT_ZONE: null
  MAINTBY: null
  ALT_LOCATION: null
  MAINT_ZONE: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

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   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata