View In:   ArcGIS Online Map Viewer

Name: DATA_ADMIN.CDOT_Controllers

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1111292.90321759
YMin: 1814219.40374161
XMax: 1204970.23095443
YMax: 1951469.85200919
Spatial Reference: 102671  (3435)

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 )
• CONTROLLER_ID ( type: esriFieldTypeInteger, alias: controller_id, editable: true, nullable: false, defaultValue: null, modelName: controller_id )
• SERVICE_ID ( type: esriFieldTypeInteger, alias: service_id, editable: true, nullable: true, defaultValue: null, modelName: service_id )
• ATLAS_PAGE ( type: esriFieldTypeString, alias: atlas_page, editable: true, nullable: false, length: 10, defaultValue: null, modelName: atlas_page )
• ATLAS_PAGE_GROUP ( type: esriFieldTypeSmallInteger, alias: atlas_page_group, editable: true, nullable: false, defaultValue: null, modelName: atlas_page_group )
• VOLTAGE ( type: esriFieldTypeSmallInteger, alias: voltage, editable: true, nullable: false, defaultValue: null, modelName: voltage )
• CDOT_PROJECT_ID ( type: esriFieldTypeInteger, alias: cdot_project_id, editable: true, nullable: true, defaultValue: null, modelName: cdot_project_id )
• METERED_FLAG ( type: esriFieldTypeString, alias: metered_flag, editable: true, nullable: true, length: 50, defaultValue: null, modelName: metered_flag )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: install_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: install_date )
• REMOVE_DATE ( type: esriFieldTypeDate, alias: remove_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: remove_date )
• LOCATION_COMMENTS ( type: esriFieldTypeString, alias: location_comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: location_comments )
• COMMENTS ( type: esriFieldTypeString, alias: comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: comments )
• NEW_GROUP_FLAG ( type: esriFieldTypeSmallInteger, alias: new_group_flag, editable: true, nullable: true, defaultValue: null, modelName: new_group_flag )
• ADDR_NUM ( type: esriFieldTypeInteger, alias: addr_num, editable: true, nullable: true, defaultValue: null, modelName: addr_num )
• STREET_DIR ( type: esriFieldTypeString, alias: street_dir, editable: true, nullable: true, length: 1, defaultValue: null, modelName: street_dir )
• STREET_NAME ( type: esriFieldTypeString, alias: street_name, editable: true, nullable: true, length: 80, defaultValue: null, modelName: street_name , Coded Values: )
• STREET_TYPE ( type: esriFieldTypeString, alias: street_type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: street_type , Coded Values: )
• ZIPCODE ( type: esriFieldTypeString, alias: zipcode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: zipcode )
• WARD ( type: esriFieldTypeString, alias: ward, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ward )
• CONTROLLER_TYPE ( type: esriFieldTypeInteger, alias: controller_type, editable: true, nullable: false, defaultValue: null, modelName: controller_type , Coded Values: [0: Residential Controller] , [1: Street Controller Pole Mounted] , [2: Residential Clock Housing] , ...4 more... )
• 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 )

Templates:

• Name: DATA_ADMIN.CDOT_Controllers
  Description:
  Prototype:
  CONTROLLER_TYPE: 0
  WARD: null
  CONTROLLER_ID: 0
  SERVICE_ID: null
  ATLAS_PAGE:
  ATLAS_PAGE_GROUP: 0
  VOLTAGE: 0
  CDOT_PROJECT_ID: null
  METERED_FLAG: null
  INSTALL_DATE: null
  REMOVE_DATE: null
  LOCATION_COMMENTS: null
  COMMENTS: null
  NEW_GROUP_FLAG: null
  ADDR_NUM: null
  STREET_DIR: null
  STREET_NAME: null
  STREET_TYPE: null
  ZIPCODE: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

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