Name: sbc_db.public.sensores_sensor

Display Field: name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 3487efb502ea482d9ea090e4f2cb4930

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• id ( type: esriFieldTypeOID, alias: id, editable: false, nullable: false, defaultValue: null, modelName: id )
• date_created ( type: esriFieldTypeDate, alias: date_created, editable: true, nullable: false, length: 8, defaultValue: null, modelName: date_created )
• date_updated ( type: esriFieldTypeDate, alias: date_updated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: date_updated )
• code ( type: esriFieldTypeString, alias: code, editable: true, nullable: false, length: 250, defaultValue: null, modelName: code )
• location ( type: esriFieldTypeString, alias: location, editable: true, nullable: false, length: 250, defaultValue: null, modelName: location )
• purchase_date ( type: esriFieldTypeDate, alias: purchase_date, editable: true, nullable: false, length: 8, defaultValue: null, modelName: purchase_date )
• start_date ( type: esriFieldTypeDate, alias: start_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: start_date )
• connection_type ( type: esriFieldTypeString, alias: connection_type, editable: true, nullable: false, length: 250, defaultValue: null, modelName: connection_type )
• token ( type: esriFieldTypeString, alias: token, editable: true, nullable: true, length: 250, defaultValue: null, modelName: token )
• api ( type: esriFieldTypeString, alias: api, editable: true, nullable: true, length: 250, defaultValue: null, modelName: api )
• sensor_status ( type: esriFieldTypeString, alias: sensor_status, editable: true, nullable: false, length: 250, defaultValue: null, modelName: sensor_status )
• brand_id ( type: esriFieldTypeInteger, alias: brand_id, editable: true, nullable: false, defaultValue: null, modelName: brand_id )
• status ( type: esriFieldTypeSmallInteger, alias: status, editable: true, nullable: false, defaultValue: null, modelName: status )
• latitude ( type: esriFieldTypeDouble, alias: latitude, editable: true, nullable: true, defaultValue: null, modelName: latitude )
• longitude ( type: esriFieldTypeDouble, alias: longitude, editable: true, nullable: true, defaultValue: null, modelName: longitude )
• owner_id ( type: esriFieldTypeInteger, alias: owner_id, editable: true, nullable: true, defaultValue: null, modelName: owner_id )
• name ( type: esriFieldTypeString, alias: name, editable: true, nullable: true, length: 250, defaultValue: null, modelName: name )
• address ( type: esriFieldTypeString, alias: address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: address )
• last_code ( type: esriFieldTypeString, alias: last_code, editable: true, nullable: true, length: 250, defaultValue: null, modelName: last_code )
• neighborhood_id ( type: esriFieldTypeInteger, alias: neighborhood_id, editable: true, nullable: true, defaultValue: null, modelName: neighborhood_id )
• project ( type: esriFieldTypeString, alias: project, editable: true, nullable: true, length: 250, defaultValue: null, modelName: project )
• platform_id ( type: esriFieldTypeInteger, alias: platform_id, editable: true, nullable: true, defaultValue: null, modelName: platform_id )
• sensor_image ( type: esriFieldTypeString, alias: sensor_image, editable: true, nullable: true, length: 100, defaultValue: null, modelName: sensor_image )
• avg_12hour ( type: esriFieldTypeDouble, alias: avg_12hour, editable: true, nullable: true, defaultValue: null, modelName: avg_12hour )
• avg_day ( type: esriFieldTypeDouble, alias: avg_day, editable: true, nullable: true, defaultValue: null, modelName: avg_day )
• avg_hour ( type: esriFieldTypeDouble, alias: avg_hour, editable: true, nullable: true, defaultValue: null, modelName: avg_hour )
• avg_week ( type: esriFieldTypeDouble, alias: avg_week, editable: true, nullable: true, defaultValue: null, modelName: avg_week )
• avg_6hour ( type: esriFieldTypeDouble, alias: avg_6hour, editable: true, nullable: true, defaultValue: null, modelName: avg_6hour )
• graph_24h ( type: esriFieldTypeString, alias: graph_24h, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: graph_24h )
• graph_7d ( type: esriFieldTypeString, alias: graph_7d, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: graph_7d )
• avg_hour_utc ( type: esriFieldTypeString, alias: avg_hour_utc, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: avg_hour_utc )
• out_range ( type: esriFieldTypeInteger, alias: out_range, editable: true, nullable: true, defaultValue: null, modelName: out_range )

Templates:

• Name: sbc_db.public.sensores_sensor
  Description:
  Prototype:
  avg_hour_utc: null
  out_range: null
  date_created: -2209161600000
  date_updated: null
  code:
  location:
  purchase_date: -2209161600000
  start_date: null
  connection_type:
  token: null
  api: null
  sensor_status:
  brand_id: 0
  status: 0
  latitude: null
  longitude: null
  owner_id: null
  name: null
  address: null
  last_code: null
  neighborhood_id: null
  project: null
  platform_id: null
  sensor_image: null
  avg_12hour: null
  avg_day: null
  avg_hour: null
  avg_week: null
  avg_6hour: null
  graph_24h: null
  graph_7d: null
  
  Drawing Tool: esriFeatureEditToolNone

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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