{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "Imovel Relation", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayFieldExpressionInfo": { "expression": "'ID lote: ' + $feature.lote_idlote", "title": "" }, "displayField": "lote_idlote", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "ltid", "type": "esriFieldTypeInteger", "alias": "ltid", "domain": null }, { "name": "aut_codigo_imovel", "type": "esriFieldTypeInteger", "alias": "aut_codigo_imovel", "domain": null }, { "name": "lote_idlote", "type": "esriFieldTypeInteger", "alias": "lote_idlote", "domain": null }, { "name": "aut_numero_autonoma", "type": "esriFieldTypeInteger", "alias": "aut_numero_autonoma", "domain": null }, { "name": "aut_sub_unidade", "type": "esriFieldTypeInteger", "alias": "aut_sub_unidade", "domain": null }, { "name": "aut_inscricao", "type": "esriFieldTypeString", "alias": "aut_inscricao", "length": 1073741822, "domain": null }, { "name": "aut_ano_cancelamento", "type": "esriFieldTypeInteger", "alias": "aut_ano_cancelamento", "domain": null }, { "name": "aut_area_tributavel", "type": "esriFieldTypeDouble", "alias": "aut_area_tributavel", "domain": null }, { "name": "aut_acumulo_metrico", "type": "esriFieldTypeDouble", "alias": "aut_acumulo_metrico", "domain": null }, { "name": "aut_area_terreno_privativo_ch", "type": "esriFieldTypeDouble", "alias": "aut_area_terreno_privativo_ch", "domain": null }, { "name": "aut_fracao_informada", "type": "esriFieldTypeDouble", "alias": "aut_fracao_informada", "domain": null }, { "name": "aut_area_tributavel_terreno", "type": "esriFieldTypeDouble", "alias": "aut_area_tributavel_terreno", "domain": null }, { "name": "aut_ct_art25_territorial", "type": "esriFieldTypeDouble", "alias": "aut_ct_art25_territorial", "domain": null }, { "name": "aut_fracao_ideal_sistema", "type": "esriFieldTypeDouble", "alias": "aut_fracao_ideal_sistema", "domain": null }, { "name": "aut_ano_construcao", "type": "esriFieldTypeInteger", "alias": "aut_ano_construcao", "domain": null }, { "name": "aut_numero_projeto", "type": "esriFieldTypeDouble", "alias": "aut_numero_projeto", "domain": null }, { "name": "aut_data_habitese", "type": "esriFieldTypeDate", "alias": "aut_data_habitese", "length": 8, "domain": null }, { "name": "aut_taxacao", "type": "esriFieldTypeString", "alias": "aut_taxacao", "length": 1073741822, "domain": null }, { "name": "aut_numero_matricula", "type": "esriFieldTypeString", "alias": "aut_numero_matricula", "length": 1073741822, "domain": null }, { "name": "aut_cartorio", "type": "esriFieldTypeString", "alias": "aut_cartorio", "length": 1073741822, "domain": null }, { "name": "aut_end_idcep", "type": "esriFieldTypeDouble", "alias": "aut_end_idcep", "domain": null }, { "name": "aut_end_cep", "type": "esriFieldTypeString", "alias": "aut_end_cep", "length": 1073741822, "domain": null }, { "name": "aut_end_bairro", "type": "esriFieldTypeString", "alias": "aut_end_bairro", "length": 1073741822, "domain": null }, { "name": "aut_end_complemento", "type": "esriFieldTypeString", "alias": "aut_end_complemento", "length": 1073741822, "domain": null }, { "name": "aut_end_logradouro", "type": "esriFieldTypeString", "alias": "aut_end_logradouro", "length": 1073741822, "domain": null }, { "name": "aut_end_numero", "type": "esriFieldTypeString", "alias": "aut_end_numero", "length": 1073741822, "domain": null }, { "name": "aut_end_corresp_idcep", "type": "esriFieldTypeDouble", "alias": "aut_end_corresp_idcep", "domain": null }, { "name": "aut_end_corresp_cep", "type": "esriFieldTypeString", "alias": "aut_end_corresp_cep", "length": 1073741822, "domain": null }, { "name": "aut_end_corresp_bairro", "type": "esriFieldTypeString", "alias": "aut_end_corresp_bairro", "length": 1073741822, "domain": null }, { "name": "aut_end_corresp_complemento", "type": "esriFieldTypeString", "alias": "aut_end_corresp_complemento", "length": 1073741822, "domain": null }, { "name": "aut_end_corresp_logradouro", "type": "esriFieldTypeString", "alias": "aut_end_corresp_logradouro", "length": 1073741822, "domain": null }, { "name": "aut_end_corresp_numero", "type": "esriFieldTypeString", "alias": "aut_end_corresp_numero", "length": 1073741822, "domain": null }, { "name": "aut_end_corresp_cidade", "type": "esriFieldTypeString", "alias": "aut_end_corresp_cidade", "length": 1073741822, "domain": null }, { "name": "aut_end_corresp_uf", "type": "esriFieldTypeString", "alias": "aut_end_corresp_uf", "length": 1073741822, "domain": null }, { "name": "ava_unidade", "type": "esriFieldTypeDouble", "alias": "ava_unidade", "domain": null }, { "name": "ava_tipologia", "type": "esriFieldTypeString", "alias": "ava_tipologia", "length": 1073741822, "domain": null }, { "name": "ava_area_construida", "type": "esriFieldTypeDouble", "alias": "ava_area_construida", "domain": null }, { "name": "ava_ano_construcao", "type": "esriFieldTypeDouble", "alias": "ava_ano_construcao", "domain": null }, { "name": "ava_ano_cancelamento", "type": "esriFieldTypeDouble", "alias": "ava_ano_cancelamento", "domain": null }, { "name": "ava_pav_numero_total", "type": "esriFieldTypeDouble", "alias": "ava_pav_numero_total", "domain": null }, { "name": "ava_pav_numero_unidade", "type": "esriFieldTypeDouble", "alias": "ava_pav_numero_unidade", "domain": null }, { "name": "ava_especie", "type": "esriFieldTypeString", "alias": "ava_especie", "length": 1073741822, "domain": null }, { "name": "ava_tipo_uso", "type": "esriFieldTypeString", "alias": "ava_tipo_uso", "length": 1073741822, "domain": null }, { "name": "ava_utilizacao", "type": "esriFieldTypeString", "alias": "ava_utilizacao", "length": 1073741822, "domain": null }, { "name": "ava_situacao_edificacao", "type": "esriFieldTypeString", "alias": "ava_situacao_edificacao", "length": 1073741822, "domain": null }, { "name": "ava_conservacao", "type": "esriFieldTypeString", "alias": "ava_conservacao", "length": 1073741822, "domain": null }, { "name": "ava_acabamento", "type": "esriFieldTypeString", "alias": "ava_acabamento", "length": 1073741822, "domain": null }, { "name": "ava_disposicao_lote", "type": "esriFieldTypeString", "alias": "ava_disposicao_lote", "length": 1073741822, "domain": null }, { "name": "ava_ct_art25_predial", "type": "esriFieldTypeDouble", "alias": "ava_ct_art25_predial", "domain": null }, { "name": "ava_numero_hidrometro", "type": "esriFieldTypeDouble", "alias": "ava_numero_hidrometro", "domain": null }, { "name": "ava_numero_medidor_energia_elet", "type": "esriFieldTypeDouble", "alias": "ava_numero_medidor_energia_eletrica", "domain": null }, { "name": "ava_quartos", "type": "esriFieldTypeString", "alias": "ava_quartos", "length": 1073741822, "domain": null }, { "name": "ava_banheiros", "type": "esriFieldTypeString", "alias": "ava_banheiros", "length": 1073741822, "domain": null }, { "name": "vlr_venal_territorial", "type": "esriFieldTypeDouble", "alias": "vlr_venal_territorial", "domain": null }, { "name": "vlr_venal_predial", "type": "esriFieldTypeDouble", "alias": "vlr_venal_predial", "domain": null }, { "name": "vlr_venal_total", "type": "esriFieldTypeDouble", "alias": "vlr_venal_total", "domain": null }, { "name": "aliquota", "type": "esriFieldTypeDouble", "alias": "aliquota", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "gdb_1776_aut_cod", "fields": "aut_codigo_imovel", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_1776_lote_id", "fields": "lote_idlote", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r208_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "gisdb.itajai.novabase_tributario", "relatedTableId": 0, "role": "esriRelRoleOrigin", "keyField": "lote_idlote", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 1, "name": "gisdb.itajai.proprietario_relation", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "aut_codigo_imovel", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1658841686000 }, "serviceItemId": "d2508d0ad8f9420bbfa3e9bd8d418203" }