{ "tables": [ { "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": false, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": false, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" } ], "infoInEstimates": [ "extent", "count" ], "type": "Table", "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "parentglobalid", "role": "esriRelRoleDestination", "composite": true, "name": "Vistoria_Tecnica_regfotos", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "regfotos", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latitude", "alias": "latitude", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longitude", "alias": "longitude", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "horaccmeters", "alias": "horaccmeters", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "picture_direction", "alias": "picture_direction", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "picdatetime", "length": 29, "alias": "picdatetime", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "concatdados", "length": 255, "alias": "concatdados", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentglobalid", "length": 38, "alias": "ParentGlobalID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "r996_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAcsending": true }, { "name": "uuid_996", "isUnique": true, "description": "", "fields": "globalid", "isAcsending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": true, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "serviceItemId": "14133468ce404defa2ac6c436ab3daba", "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Uploads,Query,Update,Delete,Sync,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "" } ], "layers": [ { "extent": { "ymin": -90, "xmin": -180, "ymax": 90, "xmax": 180, "spatialReference": {"wkid": 4326}, "type": "extent" }, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "hasStaticData": false, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": true, "name": "Vistoria_Tecnica_regfotos", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "currentVersion": 10.91, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Vistoria_Tecnica", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datalevantamento", "length": 29, "alias": "Data do Levantamento", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_a4ddcc4304674d37aab437cca6fbeedd_cvd_status", "type": "codedValue", "codedValues": [ { "code": "Projetado", "name": "Projetado" }, { "code": "Programado", "name": "Programado" }, { "code": "Em execução", "name": "Em execução" }, { "code": "Executado", "name": "Executado" }, { "code": "Paralisado", "name": "Paralisado" }, { "code": "Cancelado", "name": "Cancelado" }, { "code": "Aceite de obra", "name": "Aceite de obra" }, { "code": "Entrega de Obra", "name": "Entrega de Obra" }, { "code": "Qualidade", "name": "Aceite Qualidade" } ] }, "name": "status", "length": 255, "alias": "Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matricula", "length": 255, "alias": "Matrícula", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "data_de_solicitacao", "length": 29, "alias": "data_de_solicitacao", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numero_da_os", "alias": "Número da OS", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "endereco", "length": 255, "alias": "Endereço", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bairro", "length": 255, "alias": "bairro", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hidrometro", "length": 255, "alias": "Hidrômetro", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "situacao_ligacao_agua", "length": 255, "alias": "situacao_ligacao_agua", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "servico", "length": 255, "alias": "servico", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "setor_execucao", "length": 255, "alias": "setor_execucao", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "funcionario_equipe", "length": 255, "alias": "funcionario_equipe", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "localizacao", "length": 255, "alias": "Localização", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "grupo", "length": 255, "alias": "grupo", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nome_do_proprietario", "length": 255, "alias": "Nome do Proprietário", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "data_limite_de_execucao", "length": 29, "alias": "data_limite_de_execucao", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lote", "length": 255, "alias": "lote", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tarefa", "length": 255, "alias": "tarefa", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "Vistoria_Tecnica_possui_cap_cop_22c88900-21bc-4b05-8790-1f8936561da0", "type": "codedValue", "codedValues": [ { "code": "Sim", "name": "Sim" }, { "code": "Nao", "name": "Nao" } ] }, "name": "possui_cap_cop", "length": 255, "alias": "Ligação Especial?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_a4ddcc4304674d37aab437cca6fbeedd_cvd_cadastrador", "type": "codedValue", "codedValues": [ { "code": "C01", "name": "C01" }, { "code": "C02", "name": "C02" }, { "code": "C03", "name": "C03" }, { "code": "C04", "name": "C04" }, { "code": "C05", "name": "C05" }, { "code": "C06", "name": "C06" }, { "code": "C07", "name": "C07" }, { "code": "C08", "name": "C08" }, { "code": "C09", "name": "C09" }, { "code": "C10", "name": "C10" } ] }, "name": "cadastrador", "length": 255, "alias": "Cadastrador", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_a4ddcc4304674d37aab437cca6fbeedd_cvd_possui_ligacao", "type": "codedValue", "codedValues": [ { "code": "Sim", "name": "Sim" }, { "code": "Nao", "name": "Não" } ] }, "name": "possui_ligacao", "length": 255, "alias": "Possui Ligação?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_a4ddcc4304674d37aab437cca6fbeedd_cvd_tipo_ligacao", "type": "codedValue", "codedValues": [ { "code": "Caixa de Inspeção", "name": "Caixa de Inspeção" }, { "code": "TIL", "name": "TIL" }, { "code": "CAP COP", "name": "CAP COP" } ] }, "name": "tipo_ligacao", "length": 255, "alias": "Tipo de ligação", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_a4ddcc4304674d37aab437cca6fbeedd_cvd_tres_gotas", "type": "codedValue", "codedValues": [ { "code": "Sim", "name": "Sim" }, { "code": "Nao", "name": "Não" } ] }, "name": "tres_gotas", "length": 255, "alias": "Conformidade", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_a4ddcc4304674d37aab437cca6fbeedd_cvd_motivo", "type": "codedValue", "codedValues": [ { "code": "Sem HD", "name": "Sem HD" }, { "code": "Soleira Baixa", "name": "Soleira Baixa" }, { "code": "Sem Rede Coletora na Rua", "name": "Sem Rede Coletora na Rua" }, { "code": "Lote Vago", "name": "Lote Vago" }, { "code": "CAP COP - Nao localizado INSTALAR", "name": "CAP COP - Não localizado INSTALAR" }, { "code": "Calcada", "name": "Calçada" }, { "code": "Cliente nao autorizou instalacao", "name": "Cliente não autorizou instalação" }, { "code": "Outro", "name": "Outro" } ] }, "name": "motivo", "length": 255, "alias": "Motivo", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "motivo_outro", "length": 255, "alias": "Outro", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "obs", "length": 1000, "alias": "Obs", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "empresa", "length": 255, "alias": "Empresa", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_a4ddcc4304674d37aab437cca6fbeedd_cvd_equipe", "type": "codedValue", "codedValues": [ { "code": "E01", "name": "E01" }, { "code": "E02", "name": "E02" }, { "code": "E03", "name": "E03" }, { "code": "E04", "name": "E04" }, { "code": "E05", "name": "E05" }, { "code": "E06", "name": "E06" }, { "code": "E07", "name": "E07" }, { "code": "E08", "name": "E08" }, { "code": "E09", "name": "E09" }, { "code": "E10", "name": "E10" }, { "code": "E11", "name": "E11" }, { "code": "E12", "name": "E12" }, { "code": "E13", "name": "E13" }, { "code": "E14", "name": "E14" }, { "code": "E15", "name": "E15" }, { "code": "E16", "name": "E16" }, { "code": "E17", "name": "E17" }, { "code": "E18", "name": "E18" }, { "code": "E19", "name": "E19" }, { "code": "E20", "name": "E20" }, { "code": "E21", "name": "E21" }, { "code": "E22", "name": "E22" }, { "code": "E23", "name": "E23" }, { "code": "E24", "name": "E24" }, { "code": "E25", "name": "E25" }, { "code": "E26", "name": "E26" }, { "code": "E27", "name": "E27" }, { "code": "E28", "name": "E28" }, { "code": "E29", "name": "E29" }, { "code": "E30", "name": "E30" }, { "code": "E31", "name": "E31" }, { "code": "E32", "name": "E32" }, { "code": "E33", "name": "E33" }, { "code": "E34", "name": "E34" }, { "code": "E35", "name": "E35" }, { "code": "E36", "name": "E36" }, { "code": "E37", "name": "E37" }, { "code": "E38", "name": "E38" }, { "code": "E39", "name": "E39" }, { "code": "E40", "name": "E40" }, { "code": "E41", "name": "E41" }, { "code": "E42", "name": "E42" }, { "code": "E43", "name": "E43" }, { "code": "E44", "name": "E44" }, { "code": "E45", "name": "E45" }, { "code": "E46", "name": "E46" }, { "code": "E47", "name": "E47" }, { "code": "E48", "name": "E48" }, { "code": "E49", "name": "E49" }, { "code": "E50", "name": "E50" }, { "code": "E51", "name": "E51" }, { "code": "E52", "name": "E52" }, { "code": "E53", "name": "E53" }, { "code": "E54", "name": "E54" }, { "code": "E55", "name": "E55" }, { "code": "E56", "name": "E56" }, { "code": "E57", "name": "E57" }, { "code": "E58", "name": "E58" }, { "code": "E59", "name": "E59" }, { "code": "E60", "name": "E60" }, { "code": "E61", "name": "E61" }, { "code": "E62", "name": "E62" }, { "code": "E63", "name": "E63" }, { "code": "E64", "name": "E64" }, { "code": "E65", "name": "E65" }, { "code": "E66", "name": "E66" }, { "code": "E67", "name": "E67" }, { "code": "E68", "name": "E68" }, { "code": "E69", "name": "E69" }, { "code": "E70", "name": "E70" }, { "code": "E71", "name": "E71" }, { "code": "E72", "name": "E72" }, { "code": "E73", "name": "E73" }, { "code": "E74", "name": "E74" }, { "code": "E75", "name": "E75" }, { "code": "E76", "name": "E76" }, { "code": "E77", "name": "E77" }, { "code": "E78", "name": "E78" }, { "code": "E79", "name": "E79" }, { "code": "E80", "name": "E80" }, { "code": "E81", "name": "E81" }, { "code": "E82", "name": "E82" }, { "code": "E83", "name": "E83" }, { "code": "E84", "name": "E84" }, { "code": "E85", "name": "E85" }, { "code": "E86", "name": "E86" }, { "code": "E87", "name": "E87" }, { "code": "E88", "name": "E88" }, { "code": "E89", "name": "E89" }, { "code": "E90", "name": "E90" }, { "code": "E91", "name": "E91" }, { "code": "E92", "name": "E92" }, { "code": "E93", "name": "E93" }, { "code": "E94", "name": "E94" }, { "code": "E95", "name": "E95" }, { "code": "E96", "name": "E96" }, { "code": "E97", "name": "E97" }, { "code": "E98", "name": "E98" }, { "code": "E99", "name": "E99" }, { "code": "E100", "name": "E100" } ] }, "name": "equipe", "length": 255, "alias": "Equipe", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "extensao_ligacao", "alias": "Extensão da Ligação", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_a4ddcc4304674d37aab437cca6fbeedd_cvd_possui_ligacao_comunitaria", "type": "codedValue", "codedValues": [ { "code": "Sim", "name": "Sim" }, { "code": "Nao", "name": "Não" } ] }, "name": "possui_ligacao_comunitaria", "length": 255, "alias": "Possui Ligação Comunitária?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "distancia_do_hidrometro", "alias": "Distância do Hidrômetro", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "obra", "length": 255, "alias": "Obra", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_qtd_economias", "alias": "p_qtd_economias", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "os_obra", "length": 256, "alias": "OS Obra", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "r995_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAcsending": true }, { "name": "uuid_995", "isUnique": true, "description": "", "fields": "globalid", "isAcsending": true }, { "name": "a743_ix1", "isUnique": false, "description": "", "fields": "shape", "isAcsending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "serviceItemId": "14133468ce404defa2ac6c436ab3daba", "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "types": [ { "templates": [ { "name": "Executado", "description": "", "prototype": { "attributes": { "obs": null, "motivo": null, "possui_ligacao_comunitaria": null, "os_obra": null, "lote": null, "numero_da_os": null, "data_de_solicitacao": null, "situacao_ligacao_agua": null, "grupo": null, "nome_do_proprietario": null, "p_qtd_economias": null, "cadastrador": null, "data_limite_de_execucao": null, "setor_execucao": null, "tipo_ligacao": null, "distancia_do_hidrometro": null, "localizacao": null, "endereco": null, "hidrometro": null, "datalevantamento": null, "tarefa": null, "bairro": null, "tres_gotas": null, "extensao_ligacao": null, "motivo_outro": null, "obra": null, "possui_cap_cop": null, "possui_ligacao": null, "funcionario_equipe": null, "matricula": null, "servico": null, "empresa": null, "equipe": null, "status": "Executado" } } } ], "name": "Executado", "domains": {}, "id": "Executado" }, { "templates": [ { "name": "Projetado", "description": "", "prototype": { "attributes": { "obs": null, "motivo": null, "possui_ligacao_comunitaria": null, "os_obra": null, "lote": null, "numero_da_os": null, "data_de_solicitacao": null, "situacao_ligacao_agua": null, "grupo": null, "nome_do_proprietario": null, "p_qtd_economias": null, "cadastrador": null, "data_limite_de_execucao": null, "setor_execucao": null, "tipo_ligacao": null, "distancia_do_hidrometro": null, "localizacao": null, "endereco": null, "hidrometro": null, "datalevantamento": null, "tarefa": null, "bairro": null, "tres_gotas": null, "extensao_ligacao": null, "motivo_outro": null, "obra": null, "possui_cap_cop": null, "possui_ligacao": null, "funcionario_equipe": null, "matricula": null, "servico": null, "empresa": null, "equipe": null, "status": "Projetado" } } } ], "name": "Projetado", "domains": {}, "id": "Projetado" }, { "templates": [ { "name": "Programado", "description": "", "prototype": { "attributes": { "obs": null, "motivo": null, "possui_ligacao_comunitaria": null, "os_obra": null, "lote": null, "numero_da_os": null, "data_de_solicitacao": null, "situacao_ligacao_agua": null, "grupo": null, "nome_do_proprietario": null, "p_qtd_economias": null, "cadastrador": null, "data_limite_de_execucao": null, "setor_execucao": null, "tipo_ligacao": null, "distancia_do_hidrometro": null, "localizacao": null, "endereco": null, "hidrometro": null, "datalevantamento": null, "tarefa": null, "bairro": null, "tres_gotas": null, "extensao_ligacao": null, "motivo_outro": null, "obra": null, "possui_cap_cop": null, "possui_ligacao": null, "funcionario_equipe": null, "matricula": null, "servico": null, "empresa": null, "equipe": null, "status": "Programado" } } } ], "name": "Programado", "domains": {}, "id": "Programado" }, { "templates": [ { "name": "Cancelado", "description": "", "prototype": { "attributes": { "obs": null, "motivo": null, "possui_ligacao_comunitaria": null, "os_obra": null, "lote": null, "numero_da_os": null, "data_de_solicitacao": null, "situacao_ligacao_agua": null, "grupo": null, "nome_do_proprietario": null, "p_qtd_economias": null, "cadastrador": null, "data_limite_de_execucao": null, "setor_execucao": null, "tipo_ligacao": null, "distancia_do_hidrometro": null, "localizacao": null, "endereco": null, "hidrometro": null, "datalevantamento": null, "tarefa": null, "bairro": null, "tres_gotas": null, "extensao_ligacao": null, "motivo_outro": null, "obra": null, "possui_cap_cop": null, "possui_ligacao": null, "funcionario_equipe": null, "matricula": null, "servico": null, "empresa": null, "equipe": null, "status": "Cancelado" } } } ], "name": "Cancelado", "domains": {}, "id": "Cancelado" }, { "templates": [ { "name": "Paralisado", "description": "", "prototype": { "attributes": { "obs": null, "motivo": null, "possui_ligacao_comunitaria": null, "os_obra": null, "lote": null, "numero_da_os": null, "data_de_solicitacao": null, "situacao_ligacao_agua": null, "grupo": null, "nome_do_proprietario": null, "p_qtd_economias": null, "cadastrador": null, "data_limite_de_execucao": null, "setor_execucao": null, "tipo_ligacao": null, "distancia_do_hidrometro": null, "localizacao": null, "endereco": null, "hidrometro": null, "datalevantamento": null, "tarefa": null, "bairro": null, "tres_gotas": null, "extensao_ligacao": null, "motivo_outro": null, "obra": null, "possui_cap_cop": null, "possui_ligacao": null, "funcionario_equipe": null, "matricula": null, "servico": null, "empresa": null, "equipe": null, "status": "Paralisado" } } } ], "name": "Paralisado", "domains": {}, "id": "Paralisado" }, { "templates": [ { "name": "Entrega de Obra", "description": "", "prototype": { "attributes": { "obs": null, "motivo": null, "possui_ligacao_comunitaria": null, "os_obra": null, "lote": null, "numero_da_os": null, "data_de_solicitacao": null, "situacao_ligacao_agua": null, "grupo": null, "nome_do_proprietario": null, "p_qtd_economias": null, "cadastrador": null, "data_limite_de_execucao": null, "setor_execucao": null, "tipo_ligacao": null, "distancia_do_hidrometro": null, "localizacao": null, "endereco": null, "hidrometro": null, "datalevantamento": null, "tarefa": null, "bairro": null, "tres_gotas": null, "extensao_ligacao": null, "motivo_outro": null, "obra": null, "possui_cap_cop": null, "possui_ligacao": null, "funcionario_equipe": null, "matricula": null, "servico": null, "empresa": null, "equipe": null, "status": "Entrega de Obra" } } } ], "name": "Entrega de Obra", "domains": {}, "id": "Entrega de Obra" }, { "templates": [ { "name": "Em execução", "description": "", "prototype": { "attributes": { "obs": null, "motivo": null, "possui_ligacao_comunitaria": null, "os_obra": null, "lote": null, "numero_da_os": null, "data_de_solicitacao": null, "situacao_ligacao_agua": null, "grupo": null, "nome_do_proprietario": null, "p_qtd_economias": null, "cadastrador": null, "data_limite_de_execucao": null, "setor_execucao": null, "tipo_ligacao": null, "distancia_do_hidrometro": null, "localizacao": null, "endereco": null, "hidrometro": null, "datalevantamento": null, "tarefa": null, "bairro": null, "tres_gotas": null, "extensao_ligacao": null, "motivo_outro": null, "obra": null, "possui_cap_cop": null, "possui_ligacao": null, "funcionario_equipe": null, "matricula": null, "servico": null, "empresa": null, "equipe": null, "status": "Em execução" } } } ], "name": "Em execução", "domains": {}, "id": "Em execução" }, { "templates": [ { "name": "Aceite de obra", "description": "", "prototype": { "attributes": { "obs": null, "motivo": null, "possui_ligacao_comunitaria": null, "os_obra": null, "lote": null, "numero_da_os": null, "data_de_solicitacao": null, "situacao_ligacao_agua": null, "grupo": null, "nome_do_proprietario": null, "p_qtd_economias": null, "cadastrador": null, "data_limite_de_execucao": null, "setor_execucao": null, "tipo_ligacao": null, "distancia_do_hidrometro": null, "localizacao": null, "endereco": null, "hidrometro": null, "datalevantamento": null, "tarefa": null, "bairro": null, "tres_gotas": null, "extensao_ligacao": null, "motivo_outro": null, "obra": null, "possui_cap_cop": null, "possui_ligacao": null, "funcionario_equipe": null, "matricula": null, "servico": null, "empresa": null, "equipe": null, "status": "Aceite de obra" } } } ], "name": "Aceite de obra", "domains": {}, "id": "Aceite de obra" } ], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Uploads,Query,Update,Delete,Sync,Extract", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "status", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "field1": "status", "defaultSymbol": null, "uniqueValueInfos": [ { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 85, 255, 0, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Executado", "value": "Executado" }, { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 255, 127, 127, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Projetado", "value": "Projetado" }, { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 0, 112, 255, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Programado", "value": "Programado" }, { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 194, 194, 194, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Cancelado", "value": "Cancelado" }, { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 230, 0, 169, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Paralisado", "value": "Paralisado" }, { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 255, 255, 0, 255 ], "size": 7.5, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Entrega de Obra", "value": "Entrega de Obra" }, { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 255, 0, 0, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Em execução", "value": "Em execução" }, { "symbol": { "yoffset": 0, "imageData": "iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAZdEVYdFNvZnR3YXJlAEFkb2JlIEltYWdlUmVhZHlxyWU8AAADImlUWHRYTUw6Y29tLmFkb2JlLnhtcAAAAAAAPD94cGFja2V0IGJlZ2luPSLvu78iIGlkPSJXNU0wTXBDZWhpSHpyZVN6TlRjemtjOWQiPz4gPHg6eG1wbWV0YSB4bWxuczp4PSJhZG9iZTpuczptZXRhLyIgeDp4bXB0az0iQWRvYmUgWE1QIENvcmUgNS4wLWMwNjAgNjEuMTM0Nzc3LCAyMDEwLzAyLzEyLTE3OjMyOjAwICAgICAgICAiPiA8cmRmOlJERiB4bWxuczpyZGY9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkvMDIvMjItcmRmLXN5bnRheC1ucyMiPiA8cmRmOkRlc2NyaXB0aW9uIHJkZjphYm91dD0iIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtbG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1wOkNyZWF0b3JUb29sPSJBZG9iZSBQaG90b3Nob3AgQ1M1IE1hY2ludG9zaCIgeG1wTU06SW5zdGFuY2VJRD0ieG1wLmlpZDowNzc0N0NCNEQzMjExMUUwQUU5NUVFMEYwMTY0NzUwNSIgeG1wTU06RG9jdW1lbnRJRD0ieG1wLmRpZDowNzc0N0NCNUQzMjExMUUwQUU5NUVFMEYwMTY0NzUwNSI+IDx4bXBNTTpEZXJpdmVkRnJvbSBzdFJlZjppbnN0YW5jZUlEPSJ4bXAuaWlkOjA3NzQ3Q0IyRDMyMTExRTBBRTk1RUUwRjAxNjQ3NTA1IiBzdFJlZjpkb2N1bWVudElEPSJ4bXAuZGlkOjA3NzQ3Q0IzRDMyMTExRTBBRTk1RUUwRjAxNjQ3NTA1Ii8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+TMb00wAAC5FJREFUeF7tWw10jtcdv4lgPptg8/1NKGqoj61bz+qEdKtTZTpas+BoHZyz9Ww7M7V1MmelapqpHK1WzVoztbCk0YYwDSIh8RFCxfKhCeojiEPQ4+vu97vP/cfjkTSv7n0jI885v/O875P73Of+fv+ve+/zRmmt1YOMB5o8DV8jwIPs/jUeUBMCNTmgJgnWVIGaKlDJTFDdJ0dFhq40BO4T/hXy/J8FCAoKUkRwcLBBSEiIql27tqpTp46qV6+eatiwoQoNDVVNmjRRTZs2Vc2aNTPg52vXrg2GwEFu8H7pi/366wiYB7jJ16pVywhA8vXr11eNGjVSYWFhhnDz5s1VixYtVMuWLQ2uXLnSEYPSp0+f7gyStYEQIJhisB+K8H8hAAcqxMXyJN+4cWNjdRIn4datW6s2bdoYkOT169f/RgEgxAp8fwhoCHzDChEkAnhFEI+Ts68eEjAP8JJv0KCBIU8Xp8VJvF27dqpDhw6qY8eOBufPn+9E8guL5/Ok586d+ziIUJmmQH16gjsMvKTlbzz7egRMALF63bp1y+KdLk+r09ok3rlzZ9WlSxcDsf6uS+laHVQ6s3S7Liws/BjXHwU6AU1sSBgvqAz3XAASF6uLy7dq1Uq1b99ederUSYWHh6tu3bqp7t27G4j1nyp8xgjw+JFI4wUjR458AWQGAW29XiAi0Nu8uOcCMNExy4vL0+p0c1qbhHv06KF69uypevXqVWb9PZd2avWZMgIQGaWpevfu3elo8DTAhgwFJkaTECXMmGC9uOcCuK3OWBerkzhJ9+7duwxi/VGFz94S4IDS/QoGGy+IiIj4LQgxH7QTLxDCDDUv+Ddfj4DlAEl0Eut0d1qcxPv27av69etnILG/91KGVodgefEACKCyld5Ruk3v2LFjF9qN8HqB5BmWVzd43dcjYAJ4XZ5W79OnjyHdv3//Mhw7dqzJzZs3z48peq5cAboXfF9fvnz5Swj5C68XkDRzjUBEqBYCuOPdS37AgAGKoPUx65u971KmVjmweDke4HjBVh0fH78J7Z8BetqKQD8PInnOLHmuVgKwxHndnpYn8YEDB5ozYj+M1h9b9Pwt8p4QUPuVDs9/TLzg5yD9PYBzA84LjABe8tUiB0i2l4Qnrn+31qcARDq8ICEhYaOtCD1wDgOMF9DydHtJjNViIuT2ACSaUC5wMM2deOPGjT/C6vH4vIUZ/rbYL8f6IkDz/EGmIhQVFeWcOHFiK3LHX7BemHru3LmhKJXNIEQtikHczVrBr0mwIpJm5DjyvszR+5Dt3zkbqxecmgPyYyp2fcS+kFf78BlomP+o/tXxl/Srp6J1+sUt+uDlLOnanK9evboNa4jECxcuvAphXiwuLh5ivaRMHG918IcAQegkRkZy+Eo2prFp+s3iBXrOyWj9dOEIrfIecYiWB1rda/lyyIsIKgvt3diL7yyZOV31lM8n65eLpuvNxUk682y6Li0tNYCnLAZxLqrqSthYb/HLfgDdLgTqv08RVF5PZ0B2NmfOQrK8s7SzdZ9Z32v5cknvQbvdQCawE9gBpAGpFrheUlKic3JyEjC+cJs4uZ6o5xLBbwLUQacPweWWXrx+XqvccDOJMUJ4xXALw8/Shu2FvHV5Y3WxNi1NkPQuIMNDeiu+p1ikK11wMlcnJSWtx7h+DEQAfQDOJLnE5njNropfQsC6FhPRw4mJia87InRwCLkhZL2kK3J5N3kSJ7zEt+Dap8C/gU3ANqUPH83RM2bMIPnZwK+Bn1kRHsaZ42Qo+F0ALlS6A0OWLl26jOEQdTTqljuznHkFcRPn38Xy3hh3uzqsa9xciJN0MrBe6SHpT7FK6GnTpmViHB8AscAsYBLHZcfHcfpdANbjxkB74DvAmIULF66mCGOLxt0iRoK2rt8R517ydHdvnEuM09Vp8Y0OcfWJ0pGpP9IFBQV60qRJB/H8dcA/gDeB6RyPHRfHx3Ga+QPgtxDgFgy3raguE84TQFRMTMwap9ZjpkerumO7vDh3u7yQF5ff7ri3iXOxehI+r4Pltzypc3Nz9cSJEz/Dc5OAfwJvAb/nOOx4OC6Oj+M0e4z+EoD9sDN2StfiQ7oCXL6OExFGF6Lme0uY19XdVmeik+zuJb/BsTrJR6Y8yUyvJ0yYUB75cXYcHI+4fhl5fwrgFYHTVO7qUoSfigij3CJIVneTdmd4kpd4lwzvsXyEJT9+/Hgv+d/xufb5HAfHQ+PcRt7fArA/EYIPCwW4l3ebCL2xyWHKmbi4kJZ6LsRpdUl25bh91839jeUrIc/ncxxlSU8GKWd/lEFvnxWKkJeXV/CHkzOdcua1NicytLgQF6tvtjFPt7cxrz5SemrqZB0XF3cOD2O5iwMk5sXylZIPlAdU6Almpni4a8UzOCY5ljdaXIi7Mj1jXiUC8RSjrT5w4AB+yYBvSr0HRANMePQ4n8gHVAC7ImNypPuFzZo1azBWgc5cQNxdyppY2z2hsbXdWP1jJ+HR8ob8WiBB6ezsbI2Nl0T0/wYwFRgKMNtLzFf6Di1QIVC2b4/BGBEyMjJGllw9eyd594SG1qar29puSIvVQbiMfBw+A2lZ23VkZOQG9M8Z33MA3yE0/6qYr6oc4H2RWQsLk9e2lmx0ShstLzXdPaFxW5uuLhYXq69xiKPKa7Va6eXp7+rZs2fvBSnW+xEAt8tofS5/fToC7gE2FIIvXrz49z8fn+skOveExp3cvoq0izjJqw+Vnp7yS71kyZJcMH3FJUAoPvv8bizgAlgzhECA1Cl5LzilTcqauDqJWxeP2DRUr8hcpgdvGOJYm2QtYZJWq25h9IZReu3atSdtCPwE594AJzw+vxgIqACurana2KnBVLiLk+Xp9jKbc2X1DzLe4zuAa1hHnEhLS7u2fPsShEHb20i7BVCJbfX+/ftZCV4DWAH62xzg84uBgAng3pfDIMO5M2NqPMsbMzynsiSf3E6v2PVXk9GxhD2CLe5PQWI9XqUnz5w58z979uzRy7a9jQTYRmN540C8AB5CAbD7vBT3vAg8BrS2SfDe5gDX04OOHj065nhJ0e2uDxFWZb2vDx06pBctWnQCL1JScQ8XMv8CuJJbDixDmYvD3wuw8ekIwbAQARAS6fvSdFRU1Cdoyy3zJwCu+MyWuS8KBMwD3AJgT27O+uMfOdZHrY/ZN0/n5+frxYsXf4H3hiTO2Vw8sBJYAswHogFmd57n493iytjY2Hx6xJ9SXnHmAsgNDBv8joCvzn4D/BDgu/ZG1UmAYGyVrVt5ZLmOPfyGxna2Tk5O/gIvSVKsxblnR4u/A8wDuH7nK/HRwEh75ndenzdo0KA1mAKfouvPTY3Wi3fG6NWrV39uxeKbI+76hAI+VYKq8IAQCJB95swZnZWVdXDs2LHLMTjG7IfAKuBdWhh42RInCU5n+wCs6zzzO69TCLabP2zYsHV4UXKKC6KUlJQzuBZtxfo2zj5XgqoQoA5CIBvuOxkDe95aaiHOXLwsAGYC/ButTaIkzc3LbwLcxeWZ33mdf2c7tud9C4YPH56Qmpp62vbL/mU2yI3PSo+qEIBrgRZAX+BZ4CWA63VacgowCvgB8IglKr8Hkl+I8cykxusUgu3YnvfxfvbD/tgv++dz+Dw+t9KjqgT4FkZCC0YC3J/jkpXb1fw9IF2WmZsEGwAk7N64kN0mXuff2Y7teR/vZz/sj/2yfz6Hz6s2AtAVQ+2gaZ3vAvzNDwl0BOjifGvDdnfs2OCaHCIE27E97+P97If9sV/2T3H4vGoTApyW0oUZz3ytTTfmmQRYrjhQeXfn4lvhRwrB9ryP97Mfd798Dp/n03S4KkKAA+ZguBtLyxEcIF30boh7FREh2A/7k77LflTpi5pVJYC4LwmLm/s0U/OBBPv52v1XhQA+cLh3Tb62ABXdeL9cr/Tn8vcL0RoPqOA/Y2o84H538cr4PfAe8F9BNMsRpUBQNgAAAABJRU5ErkJggg==", "xoffset": 0, "width": 11.25, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "http://gis.iguasa.com.br/portal/portalimages/Symbols/Shapes/GreenStarLargeB.png", "height": 11.25 }, "label": "Aceite de obra", "value": "Aceite de obra" } ], "type": "uniqueValue" }, "transparency": 0 }, "copyrightText": "", "geometryType": "esriGeometryPoint" } ] }