Name: tb_consulta_obras_painel_obras

Display Field: nr_contrato

Type: Table

Geometry Type: N/A

Description:

Service Item Id: c3437c11f50c4ec18aca7b56893eec21

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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

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: false
Supports Query With LOD Spatial Reference: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• id ( type: esriFieldTypeOID, alias: id, editable: false, nullable: false, length: 8, defaultValue: null, modelName: id )
• nr_contrato ( type: esriFieldTypeString, alias: nr_contrato, editable: true, nullable: true, length: 50, defaultValue: null, modelName: nr_contrato )
• nr_convenio ( type: esriFieldTypeString, alias: nr_convenio, editable: true, nullable: true, length: 20, defaultValue: null, modelName: nr_convenio )
• objeto_contrato ( type: esriFieldTypeString, alias: objeto_contrato, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: objeto_contrato )
• fornecedor ( type: esriFieldTypeString, alias: fornecedor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: fornecedor )
• data_fim_vigencia_contrato ( type: esriFieldTypeDate, alias: data_fim_vigencia_contrato, editable: true, nullable: true, length: 8, defaultValue: null, modelName: data_fim_vigencia_contrato )
• data_inicio_contrato_acompanhamento_obra ( type: esriFieldTypeDate, alias: data_inicio_contrato_acompanhamento_obra, editable: true, nullable: true, length: 8, defaultValue: null, modelName: data_inicio_contrato_acompanhamento_obra )
• valor_global_contrato ( type: esriFieldTypeDouble, alias: valor_global_contrato, editable: true, nullable: true, defaultValue: null, modelName: valor_global_contrato )
• objeto_desc_obj_obras ( type: esriFieldTypeString, alias: objeto_desc_obj_obras, editable: true, nullable: true, length: 100, defaultValue: null, modelName: objeto_desc_obj_obras )
• situacao_atual ( type: esriFieldTypeString, alias: situacao_atual, editable: true, nullable: true, length: 30, defaultValue: null, modelName: situacao_atual )
• data_de_inicio ( type: esriFieldTypeDate, alias: data_de_inicio, editable: true, nullable: true, length: 8, defaultValue: null, modelName: data_de_inicio )
• data_de_conclusao ( type: esriFieldTypeDate, alias: data_de_conclusao, editable: true, nullable: true, length: 8, defaultValue: null, modelName: data_de_conclusao )
• empresa_contratada ( type: esriFieldTypeString, alias: empresa_contratada, editable: true, nullable: true, length: 255, defaultValue: null, modelName: empresa_contratada )
• percentual_concluido ( type: esriFieldTypeDouble, alias: percentual_concluido, editable: true, nullable: true, defaultValue: null, modelName: percentual_concluido )
• descricao_item ( type: esriFieldTypeString, alias: descricao_item, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: descricao_item )
• quantitativo ( type: esriFieldTypeDouble, alias: quantitativo, editable: true, nullable: true, defaultValue: null, modelName: quantitativo )
• preco_unitario ( type: esriFieldTypeDouble, alias: preco_unitario, editable: true, nullable: true, defaultValue: null, modelName: preco_unitario )
• totais_contratados ( type: esriFieldTypeDouble, alias: totais_contratados, editable: true, nullable: true, defaultValue: null, modelName: totais_contratados )
• quantitativo_executados ( type: esriFieldTypeDouble, alias: quantitativo_executados, editable: true, nullable: true, defaultValue: null, modelName: quantitativo_executados )
• precos_efetivamente_pagos ( type: esriFieldTypeDouble, alias: precos_efetivamente_pagos, editable: true, nullable: true, defaultValue: null, modelName: precos_efetivamente_pagos )
• controle_ug_cnpj ( type: esriFieldTypeString, alias: controle_ug_cnpj, editable: true, nullable: true, length: 14, defaultValue: null, modelName: controle_ug_cnpj )
• controle_id_proposta ( type: esriFieldTypeString, alias: controle_id_proposta, editable: true, nullable: true, length: 20, defaultValue: null, modelName: controle_id_proposta )
• controle_id_item_pad ( type: esriFieldTypeString, alias: controle_id_item_pad, editable: true, nullable: true, length: 50, defaultValue: null, modelName: controle_id_item_pad )
• data_carga ( type: esriFieldTypeDate, alias: data_carga, editable: true, nullable: false, length: 8, defaultValue: null, modelName: data_carga )

Templates:

• Name: tb_consulta_obras_painel_obras
  Description:
  Prototype:
  controle_id_item_pad: null
  data_carga: -2209161600000
  nr_contrato: null
  nr_convenio: null
  objeto_contrato: null
  fornecedor: null
  data_fim_vigencia_contrato: null
  data_inicio_contrato_acompanhamento_obra: null
  valor_global_contrato: null
  objeto_desc_obj_obras: null
  situacao_atual: null
  data_de_inicio: null
  data_de_conclusao: null
  empresa_contratada: null
  percentual_concluido: null
  descricao_item: null
  quantitativo: null
  preco_unitario: null
  totais_contratados: null
  quantitativo_executados: null
  precos_efetivamente_pagos: null
  controle_ug_cnpj: null
  controle_id_proposta: null
  
  Drawing Tool: esriFeatureEditToolNone

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

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

Child Resources:

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