Name: tb_consulta_obras_ext_painel_portal_serpro

Display Field: id_obra

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 61410345eb2f464a993fba4d417aaed7

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:

• seq ( type: esriFieldTypeOID, alias: seq, editable: false, nullable: false, defaultValue: null, modelName: seq )
• id_obra ( type: esriFieldTypeString, alias: id_obra, editable: true, nullable: true, length: 6, defaultValue: null, modelName: id_obra )
• codigo_transacao_obra ( type: esriFieldTypeString, alias: codigo_transacao_obra, editable: true, nullable: true, length: 17, defaultValue: null, modelName: codigo_transacao_obra )
• origem ( type: esriFieldTypeString, alias: origem, editable: true, nullable: true, length: 66, defaultValue: null, modelName: origem )
• numero_instrumento ( type: esriFieldTypeString, alias: numero_instrumento, editable: true, nullable: true, length: 8, defaultValue: null, modelName: numero_instrumento )
• orgao_superior ( type: esriFieldTypeString, alias: orgao_superior, editable: true, nullable: true, length: 38, defaultValue: null, modelName: orgao_superior )
• orgao ( type: esriFieldTypeString, alias: orgao, editable: true, nullable: true, length: 46, defaultValue: null, modelName: orgao )
• objeto ( type: esriFieldTypeString, alias: objeto, editable: true, nullable: true, length: 57, defaultValue: null, modelName: objeto )
• titulo ( type: esriFieldTypeString, alias: titulo, editable: true, nullable: true, length: 90, defaultValue: null, modelName: titulo )
• situacao_atual ( type: esriFieldTypeString, alias: situacao_atual, editable: true, nullable: true, length: 11, defaultValue: null, modelName: situacao_atual )
• ano_inicio_obra ( type: esriFieldTypeSmallInteger, alias: ano_inicio_obra, editable: true, nullable: true, defaultValue: null, modelName: ano_inicio_obra )
• data_inicio ( type: esriFieldTypeDate, alias: data_inicio, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: data_inicio )
• ano_fim_obra ( type: esriFieldTypeString, alias: ano_fim_obra, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ano_fim_obra )
• data_fim ( type: esriFieldTypeDate, alias: data_fim, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: data_fim )
• uf ( type: esriFieldTypeString, alias: uf, editable: true, nullable: true, length: 2, defaultValue: null, modelName: uf )
• municipio ( type: esriFieldTypeString, alias: municipio, editable: true, nullable: true, length: 9, defaultValue: null, modelName: municipio )
• endereco ( type: esriFieldTypeString, alias: endereco, editable: true, nullable: true, length: 144, defaultValue: null, modelName: endereco )
• latitude ( type: esriFieldTypeString, alias: latitude, editable: true, nullable: true, length: 18, defaultValue: null, modelName: latitude )
• longitude ( type: esriFieldTypeString, alias: longitude, editable: true, nullable: true, length: 19, defaultValue: null, modelName: longitude )
• link ( type: esriFieldTypeString, alias: link, editable: true, nullable: true, length: 59, defaultValue: null, modelName: link )
• execucao_fisica ( type: esriFieldTypeString, alias: execucao_fisica, editable: true, nullable: true, length: 4, defaultValue: null, modelName: execucao_fisica )
• execucao_financeira ( type: esriFieldTypeString, alias: execucao_financeira, editable: true, nullable: true, length: 1, defaultValue: null, modelName: execucao_financeira )
• investimento_total ( type: esriFieldTypeDouble, alias: investimento_total, editable: true, nullable: true, defaultValue: null, modelName: investimento_total )
• modalidade ( type: esriFieldTypeString, alias: modalidade, editable: true, nullable: true, length: 43, defaultValue: null, modelName: modalidade )
• tipo_instrumento ( type: esriFieldTypeString, alias: tipo_instrumento, editable: true, nullable: true, length: 6, defaultValue: null, modelName: tipo_instrumento )
• tipo ( type: esriFieldTypeString, alias: tipo, editable: true, nullable: true, length: 34, defaultValue: null, modelName: tipo )
• subtipo ( type: esriFieldTypeString, alias: subtipo, editable: true, nullable: true, length: 29, defaultValue: null, modelName: subtipo )
• cnpj_executor ( type: esriFieldTypeString, alias: cnpj_executor, editable: true, nullable: true, length: 14, defaultValue: null, modelName: cnpj_executor )
• funcional_programatica ( type: esriFieldTypeString, alias: funcional_programatica, editable: true, nullable: true, length: 21, defaultValue: null, modelName: funcional_programatica )
• emenda ( type: esriFieldTypeString, alias: emenda, editable: true, nullable: true, length: 10, defaultValue: null, modelName: emenda )
• plurianual_prioritario ( type: esriFieldTypeString, alias: plurianual_prioritario, editable: true, nullable: true, length: 1, defaultValue: null, modelName: plurianual_prioritario )
• probrasil ( type: esriFieldTypeString, alias: probrasil, editable: true, nullable: true, length: 3, defaultValue: null, modelName: probrasil )
• restos_pagar ( type: esriFieldTypeString, alias: restos_pagar, editable: true, nullable: true, length: 3, defaultValue: null, modelName: restos_pagar )
• valor_conclusao ( type: esriFieldTypeDouble, alias: valor_conclusao, editable: true, nullable: true, defaultValue: null, modelName: valor_conclusao )
• valor_empenhado ( type: esriFieldTypeDouble, alias: valor_empenhado, editable: true, nullable: true, defaultValue: null, modelName: valor_empenhado )
• valor_repasse ( type: esriFieldTypeDouble, alias: valor_repasse, editable: true, nullable: true, defaultValue: null, modelName: valor_repasse )
• valor_desembolsado ( type: esriFieldTypeDouble, alias: valor_desembolsado, editable: true, nullable: true, defaultValue: null, modelName: valor_desembolsado )
• motivo_paralisacao ( type: esriFieldTypeString, alias: motivo_paralisacao, editable: true, nullable: true, length: 1, defaultValue: null, modelName: motivo_paralisacao )
• causa_paralisacao ( type: esriFieldTypeString, alias: causa_paralisacao, editable: true, nullable: true, length: 1, defaultValue: null, modelName: causa_paralisacao )
• justificativa_tratativa ( type: esriFieldTypeString, alias: justificativa_tratativa, editable: true, nullable: true, length: 1, defaultValue: null, modelName: justificativa_tratativa )
• data_previsao_retomada ( type: esriFieldTypeString, alias: data_previsao_retomada, editable: true, nullable: true, length: 1, defaultValue: null, modelName: data_previsao_retomada )
• data_criacao ( type: esriFieldTypeString, alias: data_criacao, editable: true, nullable: true, length: 10, defaultValue: null, modelName: data_criacao )
• data_atualizacao ( type: esriFieldTypeString, alias: data_atualizacao, editable: true, nullable: true, length: 10, defaultValue: null, modelName: data_atualizacao )
• data_carga ( type: esriFieldTypeDate, alias: data_carga, editable: true, nullable: false, length: 8, defaultValue: null, precision: 1, modelName: data_carga )

Templates:

• Name: tb_consulta_obras_ext_painel_portal_serpro
  Description:
  Prototype:
  data_atualizacao: null
  data_carga: -2209161600000
  id_obra: null
  codigo_transacao_obra: null
  origem: null
  numero_instrumento: null
  orgao_superior: null
  orgao: null
  objeto: null
  titulo: null
  situacao_atual: null
  ano_inicio_obra: null
  data_inicio: null
  ano_fim_obra: null
  data_fim: null
  uf: null
  municipio: null
  endereco: null
  latitude: null
  longitude: null
  link: null
  execucao_fisica: null
  execucao_financeira: null
  investimento_total: null
  modalidade: null
  tipo_instrumento: null
  tipo: null
  subtipo: null
  cnpj_executor: null
  funcional_programatica: null
  emenda: null
  plurianual_prioritario: null
  probrasil: null
  restos_pagar: null
  valor_conclusao: null
  valor_empenhado: null
  valor_repasse: null
  valor_desembolsado: null
  motivo_paralisacao: null
  causa_paralisacao: null
  justificativa_tratativa: null
  data_previsao_retomada: null
  data_criacao: 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