{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "vw_consulta_pedidos_informacao_encerrados", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "supportsASyncCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "id", "globalIdField": "", "displayField": "orgao_origem", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "id", "type": "esriFieldTypeOID", "alias": "id", "domain": null, "editable": false, "nullable": false, "length": 8, "defaultValue": null, "modelName": "id" }, { "name": "pedido_ano", "type": "esriFieldTypeInteger", "alias": "pedido_ano", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pedido_ano" }, { "name": "pedido_sequencial", "type": "esriFieldTypeInteger", "alias": "pedido_sequencial", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pedido_sequencial" }, { "name": "numero", "type": "esriFieldTypeString", "alias": "numero", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "numero" }, { "name": "replicado_origem", "type": "esriFieldTypeString", "alias": "replicado_origem", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "replicado_origem" }, { "name": "is_replicado", "type": "esriFieldTypeSmallInteger", "alias": "is_replicado", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "is_replicado" }, { "name": "orgao_origem", "type": "esriFieldTypeString", "alias": "orgao_origem", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "orgao_origem" }, { "name": "orgao_atual", "type": "esriFieldTypeString", "alias": "orgao_atual", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "orgao_atual" }, { "name": "orgao_atual_sigla", "type": "esriFieldTypeString", "alias": "orgao_atual_sigla", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "orgao_atual_sigla" }, { "name": "assunto", "type": "esriFieldTypeString", "alias": "assunto", "domain": null, "editable": true, "nullable": true, "length": 55, "defaultValue": null, "modelName": "assunto" }, { "name": "data_criacao", "type": "esriFieldTypeDate", "alias": "data_criacao", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "data_criacao" }, { "name": "data_ultimo_movimento", "type": "esriFieldTypeDate", "alias": "data_ultimo_movimento", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "data_ultimo_movimento" }, { "name": "data_encaminhamento", "type": "esriFieldTypeDate", "alias": "data_encaminhamento", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "data_encaminhamento" }, { "name": "data_1o_recurso", "type": "esriFieldTypeDate", "alias": "data_1o_recurso", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "data_1o_recurso" }, { "name": "data_2o_recurso", "type": "esriFieldTypeDate", "alias": "data_2o_recurso", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "data_2o_recurso" }, { "name": "data_limite", "type": "esriFieldTypeDate", "alias": "data_limite", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "data_limite" }, { "name": "data_resposta", "type": "esriFieldTypeDate", "alias": "data_resposta", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "data_resposta" }, { "name": "situacao_resposta", "type": "esriFieldTypeString", "alias": "situacao_resposta", "domain": null, "editable": true, "nullable": true, "length": 55, "defaultValue": null, "modelName": "situacao_resposta" }, { "name": "orgao_resposta", "type": "esriFieldTypeString", "alias": "orgao_resposta", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "orgao_resposta" }, { "name": "data_resposta_1o_recurso", "type": "esriFieldTypeDate", "alias": "data_resposta_1o_recurso", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "data_resposta_1o_recurso" }, { "name": "situacao_1o_recurso", "type": "esriFieldTypeString", "alias": "situacao_1o_recurso", "domain": null, "editable": true, "nullable": true, "length": 55, "defaultValue": null, "modelName": "situacao_1o_recurso" }, { "name": "orgao_1o_recurso", "type": "esriFieldTypeString", "alias": "orgao_1o_recurso", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "orgao_1o_recurso" }, { "name": "data_resposta_2o_recurso", "type": "esriFieldTypeDate", "alias": "data_resposta_2o_recurso", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "data_resposta_2o_recurso" }, { "name": "situacao_2o_recurso", "type": "esriFieldTypeString", "alias": "situacao_2o_recurso", "domain": null, "editable": true, "nullable": true, "length": 55, "defaultValue": null, "modelName": "situacao_2o_recurso" }, { "name": "orgao_2o_recurso", "type": "esriFieldTypeString", "alias": "orgao_2o_recurso", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "orgao_2o_recurso" }, { "name": "dias_ate_resposta", "type": "esriFieldTypeInteger", "alias": "dias_ate_resposta", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "dias_ate_resposta" }, { "name": "situacao", "type": "esriFieldTypeString", "alias": "situacao", "domain": null, "editable": true, "nullable": true, "length": 55, "defaultValue": null, "modelName": "situacao" }, { "name": "tramitacao_desc", "type": "esriFieldTypeString", "alias": "tramitacao_desc", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "tramitacao_desc" }, { "name": "recurso_desc", "type": "esriFieldTypeString", "alias": "recurso_desc", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "recurso_desc" }, { "name": "is_prorrogado", "type": "esriFieldTypeSmallInteger", "alias": "is_prorrogado", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "is_prorrogado" }, { "name": "is_sigiloso", "type": "esriFieldTypeSmallInteger", "alias": "is_sigiloso", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "is_sigiloso" }, { "name": "descricao", "type": "esriFieldTypeString", "alias": "descricao", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "descricao" }, { "name": "descricao_1o_recurso", "type": "esriFieldTypeString", "alias": "descricao_1o_recurso", "domain": null, "editable": true, "nullable": true, "length": 10000, "defaultValue": null, "modelName": "descricao_1o_recurso" }, { "name": "descricao_2o_recurso", "type": "esriFieldTypeString", "alias": "descricao_2o_recurso", "domain": null, "editable": true, "nullable": true, "length": 5000, "defaultValue": null, "modelName": "descricao_2o_recurso" }, { "name": "motivo_mascaramento", "type": "esriFieldTypeString", "alias": "motivo_mascaramento", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "motivo_mascaramento" }, { "name": "motivo_pedido", "type": "esriFieldTypeString", "alias": "motivo_pedido", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "motivo_pedido" }, { "name": "arquivo_pedido", "type": "esriFieldTypeString", "alias": "arquivo_pedido", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "arquivo_pedido" }, { "name": "arquivo_1o_recurso", "type": "esriFieldTypeString", "alias": "arquivo_1o_recurso", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "arquivo_1o_recurso" }, { "name": "arquivo_2o_recurso", "type": "esriFieldTypeString", "alias": "arquivo_2o_recurso", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "arquivo_2o_recurso" }, { "name": "solicitante_publico", "type": "esriFieldTypeString", "alias": "solicitante_publico", "domain": null, "editable": true, "nullable": true, "length": 55, "defaultValue": null, "modelName": "solicitante_publico" }, { "name": "is_pessoa_juridica", "type": "esriFieldTypeSmallInteger", "alias": "is_pessoa_juridica", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "is_pessoa_juridica" }, { "name": "sexo_solicitante", "type": "esriFieldTypeString", "alias": "sexo_solicitante", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "sexo_solicitante" }, { "name": "genero_computavel", "type": "esriFieldTypeSmallInteger", "alias": "genero_computavel", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "genero_computavel" }, { "name": "faixa_etaria_solicitante", "type": "esriFieldTypeString", "alias": "faixa_etaria_solicitante", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "faixa_etaria_solicitante" }, { "name": "profissao_solicitante", "type": "esriFieldTypeString", "alias": "profissao_solicitante", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "profissao_solicitante" }, { "name": "escolaridade_solicitante", "type": "esriFieldTypeString", "alias": "escolaridade_solicitante", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "escolaridade_solicitante" }, { "name": "bairro_solicitante", "type": "esriFieldTypeString", "alias": "bairro_solicitante", "domain": null, "editable": true, "nullable": true, "length": 55, "defaultValue": null, "modelName": "bairro_solicitante" }, { "name": "cidade_solicitante", "type": "esriFieldTypeString", "alias": "cidade_solicitante", "domain": null, "editable": true, "nullable": true, "length": 55, "defaultValue": null, "modelName": "cidade_solicitante" }, { "name": "uf_solicitante", "type": "esriFieldTypeString", "alias": "uf_solicitante", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "uf_solicitante" }, { "name": "pais_solicitante", "type": "esriFieldTypeString", "alias": "pais_solicitante", "domain": null, "editable": true, "nullable": true, "length": 55, "defaultValue": null, "modelName": "pais_solicitante" }, { "name": "qtde_movimentos", "type": "esriFieldTypeInteger", "alias": "qtde_movimentos", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "qtde_movimentos" }, { "name": "etl_loaded_at", "type": "esriFieldTypeDate", "alias": "etl_loaded_at", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "etl_loaded_at" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "vw_consulta_pedidos_informacao_encerrados", "description": "", "prototype": { "attributes": { "qtde_movimentos": null, "etl_loaded_at": null, "pedido_ano": null, "pedido_sequencial": null, "numero": null, "replicado_origem": null, "is_replicado": null, "orgao_origem": null, "orgao_atual": null, "orgao_atual_sigla": null, "assunto": null, "data_criacao": null, "data_ultimo_movimento": null, "data_encaminhamento": null, "data_1o_recurso": null, "data_2o_recurso": null, "data_limite": null, "data_resposta": null, "situacao_resposta": null, "orgao_resposta": null, "data_resposta_1o_recurso": null, "situacao_1o_recurso": null, "orgao_1o_recurso": null, "data_resposta_2o_recurso": null, "situacao_2o_recurso": null, "orgao_2o_recurso": null, "dias_ate_resposta": null, "situacao": null, "tramitacao_desc": null, "recurso_desc": null, "is_prorrogado": null, "is_sigiloso": null, "descricao": null, "descricao_1o_recurso": null, "descricao_2o_recurso": null, "motivo_mascaramento": null, "motivo_pedido": null, "arquivo_pedido": null, "arquivo_1o_recurso": null, "arquivo_2o_recurso": null, "solicitante_publico": null, "is_pessoa_juridica": null, "sexo_solicitante": null, "genero_computavel": null, "faixa_etaria_solicitante": null, "profissao_solicitante": null, "escolaridade_solicitante": null, "bairro_solicitante": null, "cidade_solicitante": null, "uf_solicitante": null, "pais_solicitante": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "c33e6b72446545d59e93b220d8745556" }