{
 "currentVersion": 10.61,
 "id": 57,
 "name": "Alvará",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": null,
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": true,
 "relationships": [
  {
   "id": 7,
   "name": "CDI_HISTORICO_PROC_LOTE",
   "relatedTableId": 55,
   "cardinality": "esriRelCardinalityOneToOne",
   "role": "esriRelRoleDestination",
   "keyField": "num_protocolo",
   "composite": false
  }
 ],
 "isDataVersioned": true,
 "supportsRollbackOnFailureParameter": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": false,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsCountDistinct": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true
 },
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "objectid",
 "globalIdField": "globalid",
 "displayField": "nm_requerente",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "objectid",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false
  },
  {
   "name": "nm_requerente",
   "type": "esriFieldTypeString",
   "alias": "Nome do Requerente",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 250
  },
  {
   "name": "telefone",
   "type": "esriFieldTypeString",
   "alias": "Telefone para Contato",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50
  },
  {
   "name": "email",
   "type": "esriFieldTypeString",
   "alias": "e-mail",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 150
  },
  {
   "name": "tipo_solicitacao",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Tipo de Solicitação",
   "domain": {
    "type": "codedValue",
    "name": "TIPO_SOLICITACAO",
    "description": "Tipo de solicitação de alvará",
    "codedValues": [
     {
      "name": "Aprovação de projeto",
      "code": 1
     },
     {
      "name": "Aprovação de projeto e emissão de alvará",
      "code": 2
     },
     {
      "name": "Emissão de alvará",
      "code": 3
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true
  },
  {
   "name": "tipo_projeto",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Tipo de Projeto",
   "domain": {
    "type": "codedValue",
    "name": "TIPO_PROCESSO",
    "description": "Tipos de Processos de um lote",
    "codedValues": [
     {
      "name": "Aprovação de projeto",
      "code": 1
     },
     {
      "name": "Alvará",
      "code": 2
     },
     {
      "name": "Aprovação de projeto e Alvará",
      "code": 3
     },
     {
      "name": "Habite-se",
      "code": 4
     },
     {
      "name": "Informações para Edificação",
      "code": 5
     },
     {
      "name": "Fiscalização",
      "code": 6
     },
     {
      "name": "Vistoria",
      "code": 7
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true
  },
  {
   "name": "num_processo_aprovacao",
   "type": "esriFieldTypeInteger",
   "alias": "Número do Processo de Aprovação",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "insc_tecnica",
   "type": "esriFieldTypeString",
   "alias": "Inscrição Imboliária (carnê do IPTU)",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20
  },
  {
   "name": "art_rrt",
   "type": "esriFieldTypeString",
   "alias": "ART / RRT",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50
  },
  {
   "name": "registro_profissional",
   "type": "esriFieldTypeString",
   "alias": "Registro Profissional",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50
  },
  {
   "name": "responsavel_tecnico",
   "type": "esriFieldTypeString",
   "alias": "Responsável Técnico",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 250
  },
  {
   "name": "dt_estimada_conclusao",
   "type": "esriFieldTypeDate",
   "alias": "Data Estimada para Conclusão",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8
  },
  {
   "name": "area_terreno",
   "type": "esriFieldTypeDouble",
   "alias": "Área do Terreno",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "area_existente",
   "type": "esriFieldTypeDouble",
   "alias": "Área Existente",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "area_regularizar",
   "type": "esriFieldTypeDouble",
   "alias": "Área a Regularizar",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "area_construir",
   "type": "esriFieldTypeDouble",
   "alias": "Área a Construir",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "area_demolir",
   "type": "esriFieldTypeDouble",
   "alias": "Área a Demolir",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "area_reformar",
   "type": "esriFieldTypeDouble",
   "alias": "Área a Reformar",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "area_total",
   "type": "esriFieldTypeDouble",
   "alias": "Área Total",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "tipo_obra",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Tipo de Obra",
   "domain": {
    "type": "codedValue",
    "name": "TIPO_OBRA",
    "description": "Tipo de obra para aprovação",
    "codedValues": [
     {
      "name": "Residencial unifamiliar",
      "code": 1
     },
     {
      "name": "Residencial multifamiliar",
      "code": 2
     },
     {
      "name": "Comercial / Serviços",
      "code": 3
     },
     {
      "name": "Industrial",
      "code": 4
     },
     {
      "name": "Mista",
      "code": 5
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true
  },
  {
   "name": "tipo_construcao",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Tipo de Construção",
   "domain": {
    "type": "codedValue",
    "name": "TIPO_CONSTRUCAO",
    "description": "Tipo de construção para aprovação",
    "codedValues": [
     {
      "name": "Alvenaria",
      "code": 1
     },
     {
      "name": "Mista",
      "code": 2
     },
     {
      "name": "Madeira",
      "code": 3
     },
     {
      "name": "Outro",
      "code": 4
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true
  },
  {
   "name": "num_unidades",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Número de Unidades",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "qtd_salas_comerciais",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Qtd de Salas Comerciais",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "qtd_vagas_garagem",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Qtd Vagas Garagem",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "num_pavimentos",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Número de Pavimentos",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "altura_total",
   "type": "esriFieldTypeDouble",
   "alias": "Altura Total",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "area_total_subsolo",
   "type": "esriFieldTypeDouble",
   "alias": "Área Total de Subsolos",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "area_total_terreo",
   "type": "esriFieldTypeDouble",
   "alias": "Área Total do Térreo",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "area_total_pavimentos",
   "type": "esriFieldTypeDouble",
   "alias": "Área Total dos Pavimentos",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "to_efetiva",
   "type": "esriFieldTypeDouble",
   "alias": "Taxa de Ocupação Efetiva",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "ca_efetivo",
   "type": "esriFieldTypeDouble",
   "alias": "Coeficiente de Aproveitamento Efetivo",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "rfr_informado",
   "type": "esriFieldTypeDouble",
   "alias": "Recúo Frente Informado",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "rla_informado",
   "type": "esriFieldTypeDouble",
   "alias": "Recúo Lateral Informado",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "rfn_informado",
   "type": "esriFieldTypeDouble",
   "alias": "Recúo Frontal Informado",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "altura_bombeiros",
   "type": "esriFieldTypeDouble",
   "alias": "Altura (para Corpo de Bombeiros)",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "area_bombeiros",
   "type": "esriFieldTypeDouble",
   "alias": "Área (para Corpo de Bombeiros)",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "ocupacao_uso_bombeiros",
   "type": "esriFieldTypeString",
   "alias": "Ocupação e Uso (para Corpo de Bombeiros)",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 150
  },
  {
   "name": "capacidade_bombeiros",
   "type": "esriFieldTypeString",
   "alias": "Capacidade de Lotação (para Corpo de Bombeiros)",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 150
  },
  {
   "name": "carga_incendio_bombeiros",
   "type": "esriFieldTypeString",
   "alias": "Carga de Incêndio (para Corpo de Bombeiros)",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 150
  },
  {
   "name": "necessita_supressao",
   "type": "esriFieldTypeInteger",
   "alias": "Necessita de supressão/corte de vegetação",
   "domain": {
    "type": "codedValue",
    "name": "BIT",
    "description": "Sim/Não",
    "codedValues": [
     {
      "name": "Sim",
      "code": 1
     },
     {
      "name": "Não",
      "code": 2
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true
  },
  {
   "name": "cortes_maior_3m",
   "type": "esriFieldTypeInteger",
   "alias": "Cortes, aterros, muro de contenção com altura maior ou superior a 3m",
   "domain": {
    "type": "codedValue",
    "name": "BIT",
    "description": "Sim/Não",
    "codedValues": [
     {
      "name": "Sim",
      "code": 1
     },
     {
      "name": "Não",
      "code": 2
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true
  },
  {
   "name": "canalizacao_esgoto",
   "type": "esriFieldTypeInteger",
   "alias": "Apresenta canalização pluvial ou esgoto cloacal dentro do lote",
   "domain": {
    "type": "codedValue",
    "name": "BIT",
    "description": "Sim/Não",
    "codedValues": [
     {
      "name": "Sim",
      "code": 1
     },
     {
      "name": "Não",
      "code": 2
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true
  },
  {
   "name": "curso_dagua_menos_30m",
   "type": "esriFieldTypeInteger",
   "alias": "Apresenta curso de água natural a menos de 30 m (APP)",
   "domain": {
    "type": "codedValue",
    "name": "BIT",
    "description": "Sim/Não",
    "codedValues": [
     {
      "name": "Sim",
      "code": 1
     },
     {
      "name": "Não",
      "code": 2
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true
  },
  {
   "name": "nascente",
   "type": "esriFieldTypeInteger",
   "alias": "Apresenta nascente/vertente/olho de água ou banhado (APP)",
   "domain": {
    "type": "codedValue",
    "name": "BIT",
    "description": "Sim/Não",
    "codedValues": [
     {
      "name": "Sim",
      "code": 1
     },
     {
      "name": "Não",
      "code": 2
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true
  },
  {
   "name": "hidrante_postes",
   "type": "esriFieldTypeInteger",
   "alias": "Existência de hidrante, postes, etc, no passeio frontal",
   "domain": {
    "type": "codedValue",
    "name": "BIT",
    "description": "Sim/Não",
    "codedValues": [
     {
      "name": "Sim",
      "code": 1
     },
     {
      "name": "Não",
      "code": 2
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true
  },
  {
   "name": "linha_transmissao",
   "type": "esriFieldTypeInteger",
   "alias": "Existência de linha de transmissão de energia elétrica",
   "domain": {
    "type": "codedValue",
    "name": "BIT",
    "description": "Sim/Não",
    "codedValues": [
     {
      "name": "Sim",
      "code": 1
     },
     {
      "name": "Não",
      "code": 2
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true
  },
  {
   "name": "aterro_nocivo",
   "type": "esriFieldTypeInteger",
   "alias": "Existência de aterro com material nocivo à saúde",
   "domain": {
    "type": "codedValue",
    "name": "BIT",
    "description": "Sim/Não",
    "codedValues": [
     {
      "name": "Sim",
      "code": 1
     },
     {
      "name": "Não",
      "code": 2
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true
  },
  {
   "name": "declividade_maior_45",
   "type": "esriFieldTypeInteger",
   "alias": "Declividade igual ou superior a 45% (APP)",
   "domain": {
    "type": "codedValue",
    "name": "BIT",
    "description": "Sim/Não",
    "codedValues": [
     {
      "name": "Sim",
      "code": 1
     },
     {
      "name": "Não",
      "code": 2
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true
  },
  {
   "name": "num_protocolo",
   "type": "esriFieldTypeInteger",
   "alias": "Número do Protocolo (Processo)",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "logradouro_req",
   "type": "esriFieldTypeString",
   "alias": "Logradouro para Correspondência",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 150
  },
  {
   "name": "num_req",
   "type": "esriFieldTypeInteger",
   "alias": "Número para Correspondência",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "complemento_req",
   "type": "esriFieldTypeString",
   "alias": "Complemento para Correspondência",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50
  },
  {
   "name": "bairro_req",
   "type": "esriFieldTypeString",
   "alias": "Bairro para Correspondência",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100
  },
  {
   "name": "cidade_req",
   "type": "esriFieldTypeString",
   "alias": "Cidade para Correspondência",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100
  },
  {
   "name": "cep_req",
   "type": "esriFieldTypeString",
   "alias": "CEP para Correspondência",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50
  },
  {
   "name": "num_alvara",
   "type": "esriFieldTypeInteger",
   "alias": "Número do Alvará",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "resp_aprovacao_alvara",
   "type": "esriFieldTypeString",
   "alias": "Responsável pela Aprovação do Alvará",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 150
  },
  {
   "name": "dt_aprovacao_alvara",
   "type": "esriFieldTypeDate",
   "alias": "Data de Aprovação do Alvará",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8
  },
  {
   "name": "globalid",
   "type": "esriFieldTypeGlobalID",
   "alias": "globalid",
   "domain": null,
   "editable": false,
   "nullable": false,
   "length": 38
  },
  {
   "name": "qtd_apto",
   "type": "esriFieldTypeInteger",
   "alias": "Quantidade de Apartamentos",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "createdon",
   "type": "esriFieldTypeDate",
   "alias": "createdon",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8
  },
  {
   "name": "modifiedon",
   "type": "esriFieldTypeDate",
   "alias": "modifiedon",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8
  },
  {
   "name": "createdby",
   "type": "esriFieldTypeString",
   "alias": "createdby",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 200
  },
  {
   "name": "modifiedby",
   "type": "esriFieldTypeString",
   "alias": "modifiedby",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 200
  },
  {
   "name": "modifiedbyhost",
   "type": "esriFieldTypeString",
   "alias": "modifiedbyhost",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255
  },
  {
   "name": "sessionid",
   "type": "esriFieldTypeString",
   "alias": "sessionid",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255
  }
 ],
 "indexes": [
  {
   "name": "i54num_protocolo",
   "fields": "num_protocolo",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "r27_sde_rowid_uk",
   "fields": "objectid",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "uuid_27",
   "fields": "globalid",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "uuid_oid_27",
   "fields": "globalid,objectid",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "respectsDaylightSaving": false
 },
 "types": [],
 "templates": [
  {
   "name": "Alvará",
   "description": "",
   "prototype": {
    "attributes": {
     "modifiedbyhost": null,
     "sessionid": null,
     "nm_requerente": null,
     "telefone": null,
     "email": null,
     "tipo_solicitacao": null,
     "tipo_projeto": null,
     "num_processo_aprovacao": null,
     "insc_tecnica": null,
     "art_rrt": null,
     "registro_profissional": null,
     "responsavel_tecnico": null,
     "dt_estimada_conclusao": null,
     "area_terreno": null,
     "area_existente": null,
     "area_regularizar": null,
     "area_construir": null,
     "area_demolir": null,
     "area_reformar": null,
     "area_total": null,
     "tipo_obra": null,
     "tipo_construcao": null,
     "num_unidades": null,
     "qtd_salas_comerciais": null,
     "qtd_vagas_garagem": null,
     "num_pavimentos": null,
     "altura_total": null,
     "area_total_subsolo": null,
     "area_total_terreo": null,
     "area_total_pavimentos": null,
     "to_efetiva": null,
     "ca_efetivo": null,
     "rfr_informado": null,
     "rla_informado": null,
     "rfn_informado": null,
     "altura_bombeiros": null,
     "area_bombeiros": null,
     "ocupacao_uso_bombeiros": null,
     "capacidade_bombeiros": null,
     "carga_incendio_bombeiros": null,
     "necessita_supressao": null,
     "cortes_maior_3m": null,
     "canalizacao_esgoto": null,
     "curso_dagua_menos_30m": null,
     "nascente": null,
     "hidrante_postes": null,
     "linha_transmissao": null,
     "aterro_nocivo": null,
     "declividade_maior_45": null,
     "num_protocolo": null,
     "logradouro_req": null,
     "num_req": null,
     "complemento_req": null,
     "bairro_req": null,
     "cidade_req": null,
     "cep_req": null,
     "num_alvara": null,
     "resp_aprovacao_alvara": null,
     "dt_aprovacao_alvara": null,
     "modifiedby": null,
     "qtd_apto": null,
     "createdon": null,
     "modifiedon": null,
     "createdby": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 10000,
 "supportedQueryFormats": "JSON, AMF, geoJSON",
 "capabilities": "Create,Query,Update,Delete,Uploads,Editing",
 "useStandardizedQueries": true,
 "standardMaxRecordCount": 10000,
 "tileMaxRecordCount": 10000,
 "maxRecordCountFactor": 1
}