View In:   ArcGIS Online Map Viewer

Name: LucityGIS.DBO.Streetlights

Display Field: BALLASTTYP

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 10000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

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: 999534.1117973924
YMin: 293310.784232229
XMax: 1028971.8301528096
YMax: 318094.86622564495
Spatial Reference: 2927  (2927)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [153, 0, 77, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID_1 ( type: esriFieldTypeOID, alias: FID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID_1 )
• OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: SUBTYPECD, editable: true, nullable: true, defaultValue: null, modelName: SUBTYPECD )
• BALLASTTYP ( type: esriFieldTypeString, alias: BALLASTTYP, editable: true, nullable: true, length: 5, defaultValue: null, modelName: BALLASTTYP , Coded Values: [NPF: NPF] )
• FIXTURESUP ( type: esriFieldTypeString, alias: FIXTURESUP, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FIXTURESUP , Coded Values: [SEC: SEC] )
• LAMPTYPE ( type: esriFieldTypeString, alias: LAMPTYPE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LAMPTYPE , Coded Values: [SV: SV] , [MV: MV] , [LED: LED] , ...2 more... )
• LENSTYPE ( type: esriFieldTypeString, alias: LENSTYPE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LENSTYPE , Coded Values: [7: Lexan] , [6: Non-Yellowing Drop Acryl] , [5: Clear Tempered Flat Glass] , ...4 more... )
• LIGHTCOUNT ( type: esriFieldTypeString, alias: LIGHTCOUNT, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LIGHTCOUNT )
• LIGHTSTYLE ( type: esriFieldTypeString, alias: LIGHTSTYLE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LIGHTSTYLE , Coded Values: [OTHER: OTHER] , [NEMA: NEMA] , [COBRA: COBRA] )
• MOUNTHEIGH ( type: esriFieldTypeSmallInteger, alias: MOUNTHEIGH, editable: true, nullable: true, defaultValue: null, modelName: MOUNTHEIGH )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OWNERSHIP , Coded Values: [STAT: STATE] , [PUD: PUD] , [LVC: LONGVIEW] , ...3 more... )
• PHOTOCELLT ( type: esriFieldTypeString, alias: PHOTOCELLT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PHOTOCELLT )
• SHIELDING ( type: esriFieldTypeString, alias: SHIELDING, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SHIELDING , Coded Values: [N: NO] , [Y: YES] )
• STREETLIGH ( type: esriFieldTypeString, alias: STREETLIGH, editable: true, nullable: true, length: 5, defaultValue: null, modelName: STREETLIGH , Coded Values: [AL: AL] )
• WATTAGE ( type: esriFieldTypeString, alias: WATTAGE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: WATTAGE )
• LITE_ ( type: esriFieldTypeString, alias: LITE_, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LITE_ )
• LT_OWN ( type: esriFieldTypeString, alias: LT_OWN, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LT_OWN )
• WATT ( type: esriFieldTypeString, alias: WATT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATT )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• LucityAutoID ( type: esriFieldTypeInteger, alias: Link to Lucity, editable: true, nullable: true, defaultValue: null, modelName: LucityAutoID )
• NEIGHBORHOOD ( type: esriFieldTypeString, alias: NEIGHBORHOOD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEIGHBORHOOD , Coded Values: [1: 1 - INDUSTRIAL] , [10: 10 - MINT FARM] , [11: 11 - LOWER OLYMPICS] , ...11 more... )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NOTES )

Templates:

• Name: LucityGIS.DBO.Streetlights
  Description:
  Prototype:
  NEIGHBORHOOD: null
  LucityAutoID: null
  OBJECTID: null
  SUBTYPECD: null
  BALLASTTYP: null
  FIXTURESUP: null
  LAMPTYPE: null
  LENSTYPE: null
  LIGHTCOUNT: null
  LIGHTSTYLE: null
  MOUNTHEIGH: null
  OWNERSHIP: null
  PHOTOCELLT: null
  SHIELDING: null
  STREETLIGH: null
  WATTAGE: null
  LITE_: null
  LT_OWN: null
  WATT: null
  NOTES: 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