View In:   ArcGIS Online Map Viewer

Name: CoTrip Weather Stations

Display Field: ws_commonname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: TRAFFICOPS.DBO.CoTrip_WeatherStations

Service Item Id: 91a60c3c2b1f4c5d9eeafa044d641008

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -113.86199999999806
YMin: 36.697999999999375
XMax: -96.98699999999836
YMax: 41.140999999999295
Spatial Reference: 4326  (0)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [98, 63, 127, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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: 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: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, alias: OBJECTID, type: esriFieldTypeOID )
• ws_longitude ( nullable: true, editable: true, defaultValue: null, alias: ws_longitude, type: esriFieldTypeDouble )
• ws_latitude ( nullable: true, editable: true, defaultValue: null, alias: ws_latitude, type: esriFieldTypeDouble )
• ws_deviceid ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_deviceid, type: esriFieldTypeString )
• ws_commonname ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_commonname, type: esriFieldTypeString )
• ws_status ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_status, type: esriFieldTypeString )
• ws_entityid ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_entityid, type: esriFieldTypeString )
• ws_roadid ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_roadid, type: esriFieldTypeString )
• ws_roadname ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_roadname, type: esriFieldTypeString )
• ws_direction ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_direction, type: esriFieldTypeString )
• ws_milemarker ( nullable: true, editable: true, defaultValue: null, alias: ws_milemarker, type: esriFieldTypeDouble )
• ws_lastupdatedate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: ws_lastupdatedate, type: esriFieldTypeDate )
• ws_weatherstationid ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_weatherstationid, type: esriFieldTypeString )
• ws_configurationid ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_configurationid, type: esriFieldTypeString )
• ws_manufacturer ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_manufacturer, type: esriFieldTypeString )
• ws_devicecollectiondt ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: ws_devicecollectiondt, type: esriFieldTypeDate )
• ws_systemcollectiondt ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: ws_systemcollectiondt, type: esriFieldTypeDate )
• ws_essairtemp ( nullable: true, editable: true, defaultValue: null, alias: ws_essairtemp, type: esriFieldTypeInteger )
• ws_essrelhumidty ( nullable: true, editable: true, defaultValue: null, alias: ws_essrelhumidty, type: esriFieldTypeInteger )
• ws_essdewpointtemp ( nullable: true, editable: true, defaultValue: null, alias: ws_essdewpointtemp, type: esriFieldTypeInteger )
• ws_essmintemp ( nullable: true, editable: true, defaultValue: null, alias: ws_essmintemp, type: esriFieldTypeInteger )
• ws_essmaxtemp ( nullable: true, editable: true, defaultValue: null, alias: ws_essmaxtemp, type: esriFieldTypeInteger )
• ws_essavgwindspeed ( nullable: true, editable: true, defaultValue: null, alias: ws_essavgwindspeed, type: esriFieldTypeInteger )
• ws_essavgwinddir ( nullable: true, editable: true, defaultValue: null, alias: ws_essavgwinddir, type: esriFieldTypeInteger )
• ws_essvisibility ( nullable: true, editable: true, defaultValue: null, alias: ws_essvisibility, type: esriFieldTypeDouble )
• ws_esspreciprate ( nullable: true, editable: true, defaultValue: null, alias: ws_esspreciprate, type: esriFieldTypeDouble )
• ws_essprecipstartdt ( nullable: true, editable: true, defaultValue: null, alias: ws_essprecipstartdt, type: esriFieldTypeDouble )
• ws_essprecipenddt ( nullable: true, editable: true, defaultValue: null, alias: ws_essprecipenddt, type: esriFieldTypeDouble )
• ws_essprecip1hr ( nullable: true, editable: true, defaultValue: null, alias: ws_essprecip1hr, type: esriFieldTypeDouble )
• ws_essprecip3hr ( nullable: true, editable: true, defaultValue: null, alias: ws_essprecip3hr, type: esriFieldTypeDouble )
• ws_essprecip6hr ( nullable: true, editable: true, defaultValue: null, alias: ws_essprecip6hr, type: esriFieldTypeDouble )
• ws_essprecip12hr ( nullable: true, editable: true, defaultValue: null, alias: ws_essprecip12hr, type: esriFieldTypeDouble )
• ws_essprecip124hr ( nullable: true, editable: true, defaultValue: null, alias: ws_essprecip124hr, type: esriFieldTypeDouble )
• ws_winddir ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_winddir, type: esriFieldTypeString )
• ws_winddiricon ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_winddiricon, type: esriFieldTypeString )
• ws_windgustdir ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_windgustdir, type: esriFieldTypeString )
• ws_windgustdiricon ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_windgustdiricon, type: esriFieldTypeString )
• ws_essvisibilitytext ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_essvisibilitytext, type: esriFieldTypeString )
• ws_rwisprecipstatus ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_rwisprecipstatus, type: esriFieldTypeString )
• ws_rwisprecipintensity ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ws_rwisprecipintensity, type: esriFieldTypeString )
• surfacesensor_weatherstationsen ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: surfacesensor_weatherstationsen, type: esriFieldTypeString )
• surfacesensor_typeweathersensor ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: surfacesensor_typeweathersensor, type: esriFieldTypeString )
• surfacesensor_sensorid ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: surfacesensor_sensorid, type: esriFieldTypeString )
• surfacesensor_sensorname ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: surfacesensor_sensorname, type: esriFieldTypeString )
• surfacesensor_devicecollectiond ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: surfacesensor_devicecollectiond, type: esriFieldTypeString )
• surfacesensor_rwissurfacestatus ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: surfacesensor_rwissurfacestatus, type: esriFieldTypeString )
• surfacesensor_esssurfacetempera ( nullable: true, editable: true, defaultValue: null, alias: surfacesensor_esssurfacetempera, type: esriFieldTypeDouble )
• surfacesensor_esspvmtsensorerro ( nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: surfacesensor_esspvmtsensorerro, type: esriFieldTypeString )
• surfacesensor_frictionnum ( nullable: true, editable: true, defaultValue: null, alias: surfacesensor_frictionnum, type: esriFieldTypeDouble )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Templates:

• Name: CoTrip Weather Stations SQL
  Description:
  Prototype:
  ws_commonname: null
  ws_status: null
  ws_winddir: null
  ws_configurationid: null
  ws_essprecip12hr: null
  ws_rwisprecipstatus: null
  ws_essmaxtemp: null
  surfacesensor_esssurfacetempera: null
  ws_roadid: null
  ws_weatherstationid: null
  ws_manufacturer: null
  ws_longitude: null
  ws_essdewpointtemp: null
  surfacesensor_rwissurfacestatus: null
  ws_essavgwindspeed: null
  surfacesensor_devicecollectiond: null
  surfacesensor_typeweathersensor: null
  ws_milemarker: null
  ws_essavgwinddir: null
  ws_essprecipenddt: null
  ws_winddiricon: null
  surfacesensor_esspvmtsensorerro: null
  ws_lastupdatedate: null
  surfacesensor_sensorname: null
  ws_essairtemp: null
  ws_essvisibilitytext: null
  ws_entityid: null
  ws_esspreciprate: null
  ws_roadname: null
  ws_essvisibility: null
  ws_direction: null
  ws_essmintemp: null
  ws_essprecip6hr: null
  surfacesensor_sensorid: null
  ws_latitude: null
  ws_essrelhumidty: null
  ws_essprecip3hr: null
  ws_windgustdir: null
  ws_rwisprecipintensity: null
  ws_essprecip1hr: null
  ws_essprecip124hr: null
  ws_devicecollectiondt: null
  surfacesensor_frictionnum: null
  ws_windgustdiricon: null
  ws_deviceid: null
  ws_systemcollectiondt: null
  ws_essprecipstartdt: null
  surfacesensor_weatherstationsen: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

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   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata