ArcGIS REST Services Directory
Login
Home
>
services
>
Controle_social
>
Controle_Social (MapServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (Controle_social/Controle_Social)
Tables:
Table:
consulta_controle_social_transp_passiva
(0)
Name:
consulta_controle_social_transp_passiva
Display Field:
numero
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
1b4613209250429ca2b9a59ed726676f
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
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: false
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: true
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:
null
Fields:
id
( type: esriFieldTypeOID, alias: id, length: 8 )
ano
( type: esriFieldTypeBigInteger, alias: ano )
numero
( type: esriFieldTypeString, alias: numero, length: 40 )
solicitante
( type: esriFieldTypeString, alias: solicitante, length: 150 )
data_criacao
( type: esriFieldTypeDate, alias: data_criacao, length: 8 )
situacao_pedido
( type: esriFieldTypeString, alias: situacao_pedido, length: 50 )
descricao
( type: esriFieldTypeString, alias: descricao, length: 15000 )
orgao_encaminhado
( type: esriFieldTypeString, alias: orgao_encaminhado, length: 150 )
prorrogado
( type: esriFieldTypeString, alias: prorrogado, length: 20 )
prorrogado_descricao
( type: esriFieldTypeString, alias: prorrogado_descricao, length: 50 )
data_banco_pedido
( type: esriFieldTypeDate, alias: data_banco_pedido, length: 8 )
arquivo_pedido
( type: esriFieldTypeString, alias: arquivo_pedido, length: 5000 )
orgao_resposta
( type: esriFieldTypeString, alias: orgao_resposta, length: 150 )
resposta
( type: esriFieldTypeString, alias: resposta, length: 15000 )
assunto
( type: esriFieldTypeString, alias: assunto, length: 150 )
area_tematica
( type: esriFieldTypeString, alias: area_tematica, length: 100 )
orgao_resposta_sigla
( type: esriFieldTypeString, alias: orgao_resposta_sigla, length: 50 )
situacao_resposta
( type: esriFieldTypeString, alias: situacao_resposta, length: 50 )
data_resposta
( type: esriFieldTypeDate, alias: data_resposta, length: 8 )
data_banco_1o_recurso
( type: esriFieldTypeDate, alias: data_banco_1o_recurso, length: 8 )
data_banco_2o_recurso
( type: esriFieldTypeDate, alias: data_banco_2o_recurso, length: 8 )
arquivo_1o_recurso
( type: esriFieldTypeString, alias: arquivo_1o_recurso, length: 5000 )
descricao_1o_recurso
( type: esriFieldTypeString, alias: descricao_1o_recurso, length: 15000 )
resposta_1o_recurso
( type: esriFieldTypeString, alias: resposta_1o_recurso, length: 15000 )
orgao_1o_recurso
( type: esriFieldTypeString, alias: orgao_1o_recurso, length: 150 )
situacao_1o_recurso
( type: esriFieldTypeString, alias: situacao_1o_recurso, length: 100 )
data_resp_1o_recurso
( type: esriFieldTypeDate, alias: data_resp_1o_recurso, length: 8 )
arquivo_2o_recurso
( type: esriFieldTypeString, alias: arquivo_2o_recurso, length: 5000 )
descricao_2o_recurso
( type: esriFieldTypeString, alias: descricao_2o_recurso, length: 15000 )
recurso
( type: esriFieldTypeString, alias: recurso, length: 20 )
resposta_2o_recurso
( type: esriFieldTypeString, alias: resposta_2o_recurso, length: 15000 )
orgao_2o_recurso
( type: esriFieldTypeString, alias: orgao_2o_recurso, length: 150 )
situacao_2o_recurso
( type: esriFieldTypeString, alias: situacao_2o_recurso, length: 100 )
data_resp_2o_recurso
( type: esriFieldTypeDate, alias: data_resp_2o_recurso, length: 8 )
motivo_pedido
( type: esriFieldTypeString, alias: motivo_pedido, length: 100 )
sexo_solicitante
( type: esriFieldTypeString, alias: sexo_solicitante, length: 30 )
escolaridade_solicitante
( type: esriFieldTypeString, alias: escolaridade_solicitante, length: 100 )
profissao_solicitante
( type: esriFieldTypeString, alias: profissao_solicitante, length: 100 )
bairro_solicitante
( type: esriFieldTypeString, alias: bairro_solicitante, length: 150 )
cidade_solicitante
( type: esriFieldTypeString, alias: cidade_solicitante, length: 100 )
uf_solicitante
( type: esriFieldTypeString, alias: uf_solicitante, length: 10 )
pais_solicitante
( type: esriFieldTypeString, alias: pais_solicitante, length: 100 )
anexo_resposta
( type: esriFieldTypeString, alias: anexo_resposta, length: 5000 )
anexo_resposta_1o_recurso
( type: esriFieldTypeString, alias: anexo_resposta_1o_recurso, length: 5000 )
anexo_resposta_2o_recurso
( type: esriFieldTypeString, alias: anexo_resposta_2o_recurso, length: 5000 )
sigiloso
( type: esriFieldTypeSmallInteger, alias: sigiloso )
particular
( type: esriFieldTypeSmallInteger, alias: particular )
sigiloso_descricao
( type: esriFieldTypeString, alias: sigiloso_descricao, length: 50 )
particular_descricao
( type: esriFieldTypeString, alias: particular_descricao, length: 50 )
etl_loaded_at
( type: esriFieldTypeDate, alias: etl_loaded_at, length: 8 )
Table:
vw_consulta_pedidos_informacao_encerrados
(1)
Name:
vw_consulta_pedidos_informacao_encerrados
Display Field:
orgao_origem
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
1b4613209250429ca2b9a59ed726676f
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
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: false
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: true
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:
null
Fields:
id
( type: esriFieldTypeOID, alias: id, length: 8 )
pedido_ano
( type: esriFieldTypeInteger, alias: pedido_ano )
pedido_sequencial
( type: esriFieldTypeInteger, alias: pedido_sequencial )
numero
( type: esriFieldTypeString, alias: numero, length: 50 )
replicado_origem
( type: esriFieldTypeString, alias: replicado_origem, length: 50 )
is_replicado
( type: esriFieldTypeSmallInteger, alias: is_replicado )
orgao_origem
( type: esriFieldTypeString, alias: orgao_origem, length: 70 )
orgao_atual
( type: esriFieldTypeString, alias: orgao_atual, length: 70 )
orgao_atual_sigla
( type: esriFieldTypeString, alias: orgao_atual_sigla, length: 10 )
assunto
( type: esriFieldTypeString, alias: assunto, length: 55 )
data_criacao
( type: esriFieldTypeDate, alias: data_criacao, length: 8 )
data_ultimo_movimento
( type: esriFieldTypeDate, alias: data_ultimo_movimento, length: 8 )
data_encaminhamento
( type: esriFieldTypeDate, alias: data_encaminhamento, length: 8 )
data_1o_recurso
( type: esriFieldTypeDate, alias: data_1o_recurso, length: 8 )
data_2o_recurso
( type: esriFieldTypeDate, alias: data_2o_recurso, length: 8 )
data_limite
( type: esriFieldTypeDate, alias: data_limite, length: 8 )
data_resposta
( type: esriFieldTypeDate, alias: data_resposta, length: 8 )
situacao_resposta
( type: esriFieldTypeString, alias: situacao_resposta, length: 55 )
orgao_resposta
( type: esriFieldTypeString, alias: orgao_resposta, length: 70 )
data_resposta_1o_recurso
( type: esriFieldTypeDate, alias: data_resposta_1o_recurso, length: 8 )
situacao_1o_recurso
( type: esriFieldTypeString, alias: situacao_1o_recurso, length: 55 )
orgao_1o_recurso
( type: esriFieldTypeString, alias: orgao_1o_recurso, length: 70 )
data_resposta_2o_recurso
( type: esriFieldTypeDate, alias: data_resposta_2o_recurso, length: 8 )
situacao_2o_recurso
( type: esriFieldTypeString, alias: situacao_2o_recurso, length: 55 )
orgao_2o_recurso
( type: esriFieldTypeString, alias: orgao_2o_recurso, length: 70 )
dias_ate_resposta
( type: esriFieldTypeInteger, alias: dias_ate_resposta )
situacao
( type: esriFieldTypeString, alias: situacao, length: 55 )
tramitacao_desc
( type: esriFieldTypeString, alias: tramitacao_desc, length: 20 )
recurso_desc
( type: esriFieldTypeString, alias: recurso_desc, length: 20 )
is_prorrogado
( type: esriFieldTypeSmallInteger, alias: is_prorrogado )
is_sigiloso
( type: esriFieldTypeSmallInteger, alias: is_sigiloso )
descricao
( type: esriFieldTypeString, alias: descricao, length: 8000 )
descricao_1o_recurso
( type: esriFieldTypeString, alias: descricao_1o_recurso, length: 10000 )
descricao_2o_recurso
( type: esriFieldTypeString, alias: descricao_2o_recurso, length: 5000 )
motivo_mascaramento
( type: esriFieldTypeString, alias: motivo_mascaramento, length: 30 )
motivo_pedido
( type: esriFieldTypeString, alias: motivo_pedido, length: 30 )
arquivo_pedido
( type: esriFieldTypeString, alias: arquivo_pedido, length: 200 )
arquivo_1o_recurso
( type: esriFieldTypeString, alias: arquivo_1o_recurso, length: 200 )
arquivo_2o_recurso
( type: esriFieldTypeString, alias: arquivo_2o_recurso, length: 200 )
solicitante_publico
( type: esriFieldTypeString, alias: solicitante_publico, length: 55 )
is_pessoa_juridica
( type: esriFieldTypeSmallInteger, alias: is_pessoa_juridica )
sexo_solicitante
( type: esriFieldTypeString, alias: sexo_solicitante, length: 20 )
genero_computavel
( type: esriFieldTypeSmallInteger, alias: genero_computavel )
faixa_etaria_solicitante
( type: esriFieldTypeString, alias: faixa_etaria_solicitante, length: 20 )
profissao_solicitante
( type: esriFieldTypeString, alias: profissao_solicitante, length: 30 )
escolaridade_solicitante
( type: esriFieldTypeString, alias: escolaridade_solicitante, length: 30 )
bairro_solicitante
( type: esriFieldTypeString, alias: bairro_solicitante, length: 55 )
cidade_solicitante
( type: esriFieldTypeString, alias: cidade_solicitante, length: 55 )
uf_solicitante
( type: esriFieldTypeString, alias: uf_solicitante, length: 10 )
pais_solicitante
( type: esriFieldTypeString, alias: pais_solicitante, length: 55 )
qtde_movimentos
( type: esriFieldTypeInteger, alias: qtde_movimentos )
etl_loaded_at
( type: esriFieldTypeDate, alias: etl_loaded_at, length: 8 )
Table:
vw_consulta_controle_social_ouvidoria_kpis
(2)
Name:
vw_consulta_controle_social_ouvidoria_kpis
Display Field:
quantidade_manifestacoes_total
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
1b4613209250429ca2b9a59ed726676f
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Unique Id Infos:
Type: simple
Fields: ["id"]
OID Field Contains Hash Value: false
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: false
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: true
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:
null
Fields:
id
( type: esriFieldTypeOID, alias: id )
quantidade_manifestacoes_total
( type: esriFieldTypeInteger, alias: quantidade_manifestacoes_total )
tempo_medio_resposta
( type: esriFieldTypeDouble, alias: tempo_medio_resposta )
pct_respondidos
( type: esriFieldTypeDouble, alias: pct_respondidos )
pct_em_atendimento
( type: esriFieldTypeDouble, alias: pct_em_atendimento )
pct_fora_ambito_municipal
( type: esriFieldTypeDouble, alias: pct_fora_ambito_municipal )
Table:
consulta_controle_social_info_atualiza
(3)
Name:
consulta_controle_social_info_atualiza
Display Field:
data_atualizacao
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
1b4613209250429ca2b9a59ed726676f
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
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: false
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: true
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:
null
Fields:
seq
( type: esriFieldTypeOID, alias: seq )
data_atualizacao
( type: esriFieldTypeDate, alias: data_atualizacao, length: 8 )
Table:
vw_consulta_controle_social_ouvidoria
(4)
Name:
vw_consulta_controle_social_ouvidoria
Display Field:
genero
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
1b4613209250429ca2b9a59ed726676f
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
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: false
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: true
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:
null
Fields:
mes_referencia
( type: esriFieldTypeDateOnly, alias: mes_referencia )
ano
( type: esriFieldTypeInteger, alias: ano )
mes
( type: esriFieldTypeInteger, alias: mes )
genero
( type: esriFieldTypeString, alias: genero, length: 1073741822 )
natureza
( type: esriFieldTypeString, alias: natureza, length: 1073741822 )
assunto
( type: esriFieldTypeString, alias: assunto, length: 1073741822 )
area_tematica
( type: esriFieldTypeString, alias: area_tematica, length: 1073741822 )
municipio
( type: esriFieldTypeString, alias: municipio, length: 1073741822 )
bairro
( type: esriFieldTypeString, alias: bairro, length: 1073741822 )
bairro_encontrado
( type: esriFieldTypeString, alias: bairro_encontrado, length: 1073741822 )
latitude
( type: esriFieldTypeDouble, alias: latitude )
longitude
( type: esriFieldTypeDouble, alias: longitude )
quantidade_manifestacoes
( type: esriFieldTypeInteger, alias: quantidade_manifestacoes )
id
( type: esriFieldTypeOID, alias: id, length: 8 )
quantidade_respondidas
( type: esriFieldTypeInteger, alias: quantidade_respondidas )
quantidade_em_atendimento
( type: esriFieldTypeInteger, alias: quantidade_em_atendimento )
soma_dias_resposta
( type: esriFieldTypeInteger, alias: soma_dias_resposta )
area_tematica_geral
( type: esriFieldTypeString, alias: area_tematica_geral, length: 1073741822 )
Table:
vw_consulta_controle_social_transp_ativa
(5)
Name:
vw_consulta_controle_social_transp_ativa
Display Field:
page_path
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
1b4613209250429ca2b9a59ed726676f
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
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: false
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: true
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:
null
Fields:
mes_referencia
( type: esriFieldTypeDateOnly, alias: mes_referencia )
ano
( type: esriFieldTypeInteger, alias: ano )
mes
( type: esriFieldTypeInteger, alias: mes )
page_path
( type: esriFieldTypeString, alias: page_path, length: 500 )
pagina
( type: esriFieldTypeString, alias: pagina, length: 1073741822 )
city
( type: esriFieldTypeString, alias: city, length: 1073741822 )
city_id
( type: esriFieldTypeString, alias: city_id, length: 1073741822 )
country
( type: esriFieldTypeString, alias: country, length: 1073741822 )
country_id
( type: esriFieldTypeString, alias: country_id, length: 1073741822 )
pais_pt
( type: esriFieldTypeString, alias: pais_pt, length: 1073741822 )
screen_page_views
( type: esriFieldTypeDouble, alias: screen_page_views )
sessions
( type: esriFieldTypeDouble, alias: sessions )
event_count
( type: esriFieldTypeDouble, alias: event_count )
engaged_sessions
( type: esriFieldTypeDouble, alias: engaged_sessions )
total_users_soma_diaria
( type: esriFieldTypeDouble, alias: total_users_soma_diaria )
user_engagement_duration
( type: esriFieldTypeDouble, alias: user_engagement_duration )
engagement_rate
( type: esriFieldTypeDouble, alias: engagement_rate )
bounce_rate
( type: esriFieldTypeDouble, alias: bounce_rate )
id
( type: esriFieldTypeOID, alias: id, length: 8 )
Table:
vw_consulta_controle_social_visao_geral
(6)
Name:
vw_consulta_controle_social_visao_geral
Display Field:
area_tematica
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
1b4613209250429ca2b9a59ed726676f
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
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: false
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: true
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:
null
Fields:
mes_referencia
( type: esriFieldTypeDate, alias: mes_referencia, length: 8, precision: 1 )
ano
( type: esriFieldTypeInteger, alias: ano )
mes
( type: esriFieldTypeInteger, alias: mes )
area_tematica
( type: esriFieldTypeString, alias: area_tematica, length: 1073741822 )
dominio
( type: esriFieldTypeString, alias: dominio, length: 1073741822 )
quantidade_total
( type: esriFieldTypeInteger, alias: quantidade_total )
quantidade_respondidos
( type: esriFieldTypeInteger, alias: quantidade_respondidos )
quantidade_em_analise
( type: esriFieldTypeInteger, alias: quantidade_em_analise )
quantidade_indeferidos
( type: esriFieldTypeInteger, alias: quantidade_indeferidos )
id
( type: esriFieldTypeOID, alias: id, length: 8 )