View In:   ArcGIS Online Map Viewer

Name: Streetlight

Display Field: creation_user

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 1e985200e16545c397c1ff4585474561

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 2105328.5431518555
YMin: 222214.03399658203
XMax: 2166661.1920776367
YMax: 264440.8276977539
Spatial Reference: 102724  (2267)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true
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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• ancillaryrole ( modelName: ANCILLARYROLE, nullable: true, editable: true, defaultValue: null, alias: ANCILLARYROLE, type: esriFieldTypeSmallInteger )
• enabled ( modelName: Enabled, nullable: true, editable: true, defaultValue: 1, alias: Enabled, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• creation_user ( modelName: CREATION_USER, nullable: true, editable: true, defaultValue: null, length: 50, alias: Created By, type: esriFieldTypeString )
• last_user ( modelName: LAST_USER, nullable: true, editable: true, defaultValue: null, length: 50, alias: Updated By, type: esriFieldTypeString )
• subtype_cd ( modelName: SUBTYPE_CD, nullable: false, editable: true, defaultValue: 2, alias: SubtypeCD, type: esriFieldTypeInteger )
• facilityid ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Facility ID, type: esriFieldTypeString )
• feeder_id ( modelName: FEEDER_ID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Feeder ID, type: esriFieldTypeString )
• feeder_id2 ( modelName: FEEDER_ID2, nullable: true, editable: true, defaultValue: null, length: 20, alias: Feeder ID 2, type: esriFieldTypeString )
• operating_voltage ( modelName: OPERATING_VOLTAGE, nullable: false, editable: true, defaultValue: null, alias: Operating Voltage, type: esriFieldTypeInteger )
• construction_status ( modelName: CONSTRUCTION_STATUS, nullable: true, editable: true, defaultValue: null, alias: Construction Status, type: esriFieldTypeInteger , Coded Values: [0: Proposed] , [5: Existing] , [10: Waiting For Staking] , ...6 more... )
• work_order_id ( modelName: WORK_ORDER_ID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Work Order Number, type: esriFieldTypeString )
• comments ( modelName: COMMENTS, nullable: true, editable: true, defaultValue: null, length: 100, alias: Comments, type: esriFieldTypeString )
• electrictraceweight ( modelName: ELECTRICTRACEWEIGHT, nullable: true, editable: true, defaultValue: null, alias: Electric Trace Weight, type: esriFieldTypeInteger )
• feederinfo ( modelName: FEEDERINFO, nullable: true, editable: true, defaultValue: null, alias: Feeder Information, type: esriFieldTypeInteger )
• symbol_rotation ( modelName: SYMBOL_ROTATION, nullable: false, editable: true, defaultValue: 0, alias: Symbol Rotation, type: esriFieldTypeDouble )
• phase_designation ( modelName: PHASE_DESIGNATION, nullable: false, editable: true, defaultValue: null, alias: Phase Designation, type: esriFieldTypeInteger )
• nominal_voltage ( modelName: NOMINAL_VOLTAGE, nullable: false, editable: true, defaultValue: null, alias: Nominal Voltage, type: esriFieldTypeInteger )
• location ( modelName: LOCATION, nullable: true, editable: true, defaultValue: null, length: 100, alias: Location, type: esriFieldTypeString )
• ballast_type ( modelName: BALLAST_TYPE, nullable: true, editable: true, defaultValue: null, length: 5, alias: Ballast Type, type: esriFieldTypeString , Coded Values: [HPF: High Power Factor] , [NPF: Normal Power Factor] )
• fixture_support ( modelName: FIXTURE_SUPPORT, nullable: true, editable: true, defaultValue: null, length: 5, alias: Fixture Support, type: esriFieldTypeString , Coded Values: [COB: Cobra] , [SEC: Security] , [OTH: Other] )
• lamp_type ( modelName: LAMP_TYPE, nullable: true, editable: true, defaultValue: null, length: 5, alias: Lamp Type, type: esriFieldTypeString , Coded Values: [HPS: High Pressure Sodium] , [MV: Mercury Vapor] , [MH: Metal Halide] , ...1 more... )
• lens_type ( modelName: LENS_TYPE, nullable: true, editable: true, defaultValue: null, length: 5, alias: Lens Type, type: esriFieldTypeString , Coded Values: [DIF: Diffuser] , [RFL: Reflector] , [RFR: Refractor] )
• light_count ( modelName: LIGHT_COUNT, nullable: true, editable: true, defaultValue: null, alias: Light Count, type: esriFieldTypeSmallInteger , Range: [1, 4] )
• light_style ( modelName: LIGHT_STYLE, nullable: true, editable: true, defaultValue: null, length: 5, alias: Light Style, type: esriFieldTypeString , Coded Values: [DECOR: Decorative] , [2H: 2 Heads] , [4H: 4 Heads] , ...1 more... )
• mount_height ( modelName: MOUNT_HEIGHT, nullable: true, editable: true, defaultValue: null, alias: Mounting Height, type: esriFieldTypeSmallInteger )
• owner ( modelName: OWNER, nullable: true, editable: true, defaultValue: null, length: 5, alias: Ownership, type: esriFieldTypeString , Coded Values: [CUST: Customer] , [COE: City of Edmond] , [OTH: Other] , ...1 more... )
• photocell_type ( modelName: PHOTOCELL_TYPE, nullable: true, editable: true, defaultValue: null, length: 5, alias: Photocell Type, type: esriFieldTypeString , Coded Values: [BUT: Button] , [NTL: Nema Twist Lock] , [NONE: None] , ...1 more... )
• shielding ( modelName: SHIELDING, nullable: true, editable: true, defaultValue: null, length: 3, alias: Shielding?, type: esriFieldTypeString , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• streetlight_role ( modelName: STREETLIGHT_ROLE, nullable: true, editable: true, defaultValue: null, length: 5, alias: Streetlight Role, type: esriFieldTypeString , Coded Values: [AL: Area Light] , [COM: Commercial Area Lighting] , [FPL: Family Protective Light] , ...5 more... )
• time_control ( modelName: TIME_CONTROL, nullable: true, editable: true, defaultValue: null, length: 3, alias: Time Control?, type: esriFieldTypeString , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• wattage ( modelName: WATTAGE, nullable: true, editable: true, defaultValue: null, alias: Wattage, type: esriFieldTypeSmallInteger , Coded Values: [100: 100 W] , [150: 150 W] , [175: 175 W] , ...3 more... )
• rel_pole_facid ( modelName: REL_POLE_FACID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Related Pole Facility ID, type: esriFieldTypeString )
• gis_id ( modelName: GIS_ID, nullable: true, editable: true, defaultValue: null, alias: GIS ID, type: esriFieldTypeInteger )
• pole_material ( modelName: POLE_MATERIAL, nullable: true, editable: true, defaultValue: null, length: 5, alias: Pole Material, type: esriFieldTypeString , Coded Values: [WOOD: Wood] , [METAL: Metal] , [UNK: Unknown] )
• light_pole_id ( modelName: LIGHT_POLE_ID, nullable: true, editable: true, defaultValue: null, length: 7, alias: Light Pole ID, type: esriFieldTypeString )
• layer ( modelName: LAYER, nullable: true, editable: true, defaultValue: null, length: 20, alias: LAYER, type: esriFieldTypeString )
• image ( modelName: IMAGE, nullable: true, editable: true, defaultValue: null, length: 50, alias: IMAGE, type: esriFieldTypeString )
• inspcondition ( modelName: InspCondition, nullable: true, editable: true, defaultValue: null, alias: InspCondition, type: esriFieldTypeSmallInteger )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• installcost ( modelName: installcost, nullable: true, editable: true, defaultValue: null, alias: INSTALLCOST, type: esriFieldTypeDouble )
• replacecost ( modelName: replacecost, nullable: true, editable: true, defaultValue: null, alias: REPLACECOST, type: esriFieldTypeDouble )
• ipof ( modelName: ipof, nullable: true, editable: true, defaultValue: null, alias: iPOF, type: esriFieldTypeDouble )
• icof ( modelName: icof, nullable: true, editable: true, defaultValue: null, alias: iCOF, type: esriFieldTypeDouble )
• ibre ( modelName: ibre, nullable: true, editable: true, defaultValue: null, alias: iBRE, type: esriFieldTypeDouble )
• imspu ( modelName: imspu, nullable: true, editable: true, defaultValue: null, alias: iMSPU, type: esriFieldTypeDouble )
• imspo ( modelName: imspo, nullable: true, editable: true, defaultValue: null, alias: iMSPO, type: esriFieldTypeDouble )
• serno ( modelName: serno, nullable: true, editable: true, defaultValue: null, length: 255, alias: Serial Number, type: esriFieldTypeString )
• serialno ( modelName: serialno, nullable: true, editable: true, defaultValue: null, length: 255, alias: Serial Number, type: esriFieldTypeString )
• date_modified ( modelName: date_modified, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Updated, type: esriFieldTypeDate )
• installation_date ( modelName: installation_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Installation Date, type: esriFieldTypeDate )
• icalcdate ( modelName: icalcdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: iCalcDate, type: esriFieldTypeDate )
• warrantydate ( modelName: warrantydate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Warranty Date, type: esriFieldTypeDate )
• workdone ( modelName: workdone, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: WorkDone, type: esriFieldTypeDate )
• date_created ( modelName: date_created, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Creation Date, type: esriFieldTypeDate )
• expdate ( modelName: expdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Expiration Date, type: esriFieldTypeDate )
• expirationdate ( modelName: expirationdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Expiration Date, type: esriFieldTypeDate )
• expreplacedate ( modelName: expreplacedate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: EXPREPLACEDATE, type: esriFieldTypeDate )
• conditiondate ( modelName: conditiondate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: ConditionDate, type: esriFieldTypeDate )

Templates:

• Name: Streetlight
  Description:
  Prototype:
  inspcondition: null
  facilityid: null
  creation_user: null
  lamp_type: null
  gis_id: null
  workdone: null
  lens_type: null
  rel_pole_facid: null
  light_pole_id: null
  ipof: null
  electrictraceweight: null
  light_count: null
  fixture_support: null
  symbol_rotation: 0
  conditiondate: null
  image: null
  installcost: null
  feederinfo: null
  icalcdate: null
  serno: null
  nominal_voltage: 0
  replacecost: null
  time_control: null
  installation_date: null
  ibre: null
  expdate: null
  icof: null
  pole_material: null
  enabled: 1
  layer: null
  serialno: null
  light_style: null
  wattage: null
  last_user: null
  feeder_id: null
  feeder_id2: null
  subtype_cd: 2
  warrantydate: null
  owner: null
  comments: null
  date_created: null
  ancillaryrole: null
  photocell_type: null
  expreplacedate: null
  expirationdate: null
  imspu: null
  phase_designation: 0
  streetlight_role: null
  ballast_type: null
  imspo: null
  date_modified: null
  work_order_id: null
  operating_voltage: 0
  construction_status: null
  shielding: null
  location: null
  mount_height: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Editing,Uploads

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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