View In:   ArcGIS Online Map Viewer

Name: Park Lighting

Display Field: ParkName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: ea38e58f76bf46b995f3c5f1829e41ed

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000

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: 6477463.912980139
YMin: 1856469.5140850544
XMax: 6480650.838036716
YMax: 1871913.5635774732
Spatial Reference: 102642  (2226)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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
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: 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 )
• ParkName ( type: esriFieldTypeString, alias: Park Name, 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: Location Desc, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Address )
• StreetNum ( type: esriFieldTypeString, alias: Street Number, 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 , Coded Values: [A ST: A ST] , [ABBEY CT: ABBEY CT] , [ABRUZZINI CT: ABRUZZINI CT] , ...1418 more... )
• PoleNumber ( type: esriFieldTypeString, alias: Pole Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PoleNumber )
• OwnedBY ( type: esriFieldTypeSmallInteger, alias: Owner, 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: 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... )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• TypeAndWattage ( type: esriFieldTypeString, alias: Type And Wattage, 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... )
• Category ( type: esriFieldTypeString, alias: Category, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Category , Coded Values: [1: SAFTEY LIGHT] , [2: STANDARD] )
• OriginalLampType ( type: esriFieldTypeString, alias: Original Lamp Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ORIGINALLAMPTYPE )
• OriginalWattage ( type: esriFieldTypeString, alias: Original Wattage, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OriginalWattage , Coded Values: [24: 24] , [29: 29] , [35: 35] , ...17 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 )
• 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: Photocell, 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... )
• Wattage ( type: esriFieldTypeSmallInteger, alias: Wattage, editable: true, nullable: true, defaultValue: null, modelName: WATTAGE_SI , Coded Values: [0: 24] , [1: 29] , [2: 35] , ...17 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: In Lucity, editable: true, nullable: true, defaultValue: null, modelName: INLUCITY , Coded Values: [0: False] , [1: True] )
• Condition ( type: esriFieldTypeSmallInteger, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: Condition )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: null, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• 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 )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Comments )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ReplacementUnitCost ( type: esriFieldTypeDouble, alias: Replacement/Unit cost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementUnitCost )
• 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:
  InspectionDate: null
  UnitCost: null
  FacilityID: null
  ParkName: null
  LocDesc: null
  StreetNum: null
  Street: null
  PoleNumber: null
  OwnedBY: null
  MaintBy: null
  InstallDate: null
  TypeAndWattage: null
  Category: null
  OriginalLampType: null
  OriginalWattage: null
  Product: null
  TwinSPID: null
  LampType: null
  Metered: null
  PhotoCell: null
  PoleHeight: null
  PoleMaterial: null
  Voltage: null
  ArmLength: null
  Wattage: null
  FixtureType: null
  Heads: null
  LucityMaintZone: null
  InLucity: null
  Condition: null
  Enabled: null
  PurchaseDate: null
  ServiceLife: null
  ReplacementUnitCost: null
  CapitalReplacementDate: null
  Comments: 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

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

Child Resources:   Field Groups   Contingent Values

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