View In:   ArcGIS Online Map Viewer

Name: GISDev.DBO.StreetLights

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: 3066834.433625385
YMin: 1.013591275430964E7
XMax: 3109862.257346466
YMax: 1.0174802226727396E7
Spatial Reference: 102739  (2277)  VCSWkid(115702)  LatestVCSWkid(115702)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 168, 115, 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

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 )
• StreetLight_ID ( type: esriFieldTypeString, alias: StreetLight_ID, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StreetLight_ID )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Notes )
• Date_Colle ( type: esriFieldTypeDate, alias: Date_Colle, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_Colle )
• SUBDIVISION ( type: esriFieldTypeString, alias: SUBDIVISION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBDIVISION )
• SUBDIV_PHASE ( type: esriFieldTypeString, alias: SUBDIV_PHASE, editable: true, nullable: true, length: 60, defaultValue: null, modelName: SUBDIV_PHASE )
• PARCEL_ID ( type: esriFieldTypeString, alias: PARCEL_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PARCEL_ID )
• ADDRESS_NUM ( type: esriFieldTypeString, alias: ADDRESS_NUM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ADDRESS_NUM )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, editable: true, nullable: true, length: 45, defaultValue: null, modelName: STREET_NAME )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• LucityID ( type: esriFieldTypeInteger, alias: LucityID, editable: true, nullable: true, defaultValue: null, modelName: LucityID )
• PEC_Number ( type: esriFieldTypeString, alias: PEC_Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PEC_Number )
• Fixture_Type ( type: esriFieldTypeString, alias: Fixture_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Fixture_Type , Coded Values: [S: Single] , [D: Double] )
• Pole_Material ( type: esriFieldTypeSmallInteger, alias: Pole_Material, editable: true, nullable: true, defaultValue: null, modelName: Pole_Material , Coded Values: [1: Brushed Aluminum] , [2: Painted Aluminum] , [3: Galvanized] , ...5 more... )
• Maintained_By ( type: esriFieldTypeSmallInteger, alias: Maintained_By, editable: true, nullable: true, defaultValue: null, modelName: Maintained_By , Coded Values: [1: Cedar Park] , [3: CTRMA - 183A] , [4: ETJ or MUD] , ...7 more... )
• Date_Inspected ( type: esriFieldTypeDate, alias: Date_Inspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_Inspected )
• Status ( type: esriFieldTypeSmallInteger, alias: Status, editable: true, nullable: true, defaultValue: null, modelName: Status , Coded Values: [1: Out] , [2: Dim] , [3: Flicker] )
• Retagged ( type: esriFieldTypeSmallInteger, alias: Retagged, editable: true, nullable: true, defaultValue: null, modelName: Retagged , Coded Values: [1: Yes] , [2: No] )
• Test ( type: esriFieldTypeString, alias: Test, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Test )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CreatedBy )
• CreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
• LastEditUser ( type: esriFieldTypeString, alias: LastEditUser, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LastEditUser )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Fixture_Quantity ( type: esriFieldTypeSmallInteger, alias: Fixture_Quantity, editable: true, nullable: true, defaultValue: null, modelName: Fixture_Quantity )
• Light1_Type ( type: esriFieldTypeSmallInteger, alias: Light1_Type, editable: true, nullable: true, defaultValue: null, modelName: Light1_Type , Coded Values: [1: LED] , [2: High Pressure Sodium] , [3: Mercury Vapor] , ...4 more... )
• Light2_Type ( type: esriFieldTypeSmallInteger, alias: Light2_Type, editable: true, nullable: true, defaultValue: null, modelName: Light2_Type , Coded Values: [1: LED] , [2: High Pressure Sodium] , [3: Mercury Vapor] , ...4 more... )
• Light1_Orientation ( type: esriFieldTypeSmallInteger, alias: Light1_Orientation, editable: true, nullable: true, defaultValue: null, modelName: Light1_Orientation , Coded Values: [1: Over Street] , [2: Over Private Property] , [3: Other] )
• Light2_Orientation ( type: esriFieldTypeSmallInteger, alias: Light2_Orientation, editable: true, nullable: true, defaultValue: null, modelName: Light2_Orientation , Coded Values: [1: Over Street] , [2: Over Private Property] , [3: Other] )
• Light_Maintained_By ( type: esriFieldTypeSmallInteger, alias: Light_Maintained_By, editable: true, nullable: true, defaultValue: null, modelName: Light_Maintained_By , Coded Values: [1: Cedar Park] , [3: CTRMA - 183A] , [4: ETJ or MUD] , ...7 more... )

Templates:

• Name: GISDev.DBO.StreetLights
  Description:
  Prototype:
  Light2_Orientation: null
  StreetLight_ID: null
  Longitude: null
  Latitude: null
  Notes: null
  Date_Colle: null
  SUBDIVISION: null
  SUBDIV_PHASE: null
  PARCEL_ID: null
  ADDRESS_NUM: null
  STREET_NAME: null
  Light_Maintained_By: null
  LucityID: null
  PEC_Number: null
  Fixture_Type: null
  Pole_Material: null
  Maintained_By: null
  Date_Inspected: null
  Status: null
  Retagged: null
  Test: null
  Light1_Orientation: null
  Light2_Type: null
  Light1_Type: null
  Fixture_Quantity: 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: CreatedDate
• Creator Field: CreatedBy
• Edit Date Field: EditDate
• Editor Field: LastEditUser

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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