Name: tb_estabelecimento

Display Field: co_unidade

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 89bd594cdd224d85ba28fc9d1299b975

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
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: false
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:

Fields:

• seq ( type: esriFieldTypeOID, alias: seq, editable: false, nullable: false, length: 8, defaultValue: null, modelName: seq )
• co_unidade ( type: esriFieldTypeString, alias: co_unidade, editable: true, nullable: true, length: 31, defaultValue: null, modelName: co_unidade )
• co_cnes ( type: esriFieldTypeInteger, alias: co_cnes, editable: true, nullable: true, defaultValue: null, modelName: co_cnes )
• nu_cnpj_mantenedora ( type: esriFieldTypeString, alias: nu_cnpj_mantenedora, editable: true, nullable: true, length: 14, defaultValue: null, modelName: nu_cnpj_mantenedora )
• tp_pfpj ( type: esriFieldTypeString, alias: tp_pfpj, editable: true, nullable: true, length: 1, defaultValue: null, modelName: tp_pfpj )
• nivel_dep ( type: esriFieldTypeString, alias: nivel_dep, editable: true, nullable: true, length: 1, defaultValue: null, modelName: nivel_dep )
• no_razao_social ( type: esriFieldTypeString, alias: no_razao_social, editable: true, nullable: true, length: 60, defaultValue: null, modelName: no_razao_social )
• no_fantasia ( type: esriFieldTypeString, alias: no_fantasia, editable: true, nullable: true, length: 60, defaultValue: null, modelName: no_fantasia )
• no_logradouro ( type: esriFieldTypeString, alias: no_logradouro, editable: true, nullable: true, length: 60, defaultValue: null, modelName: no_logradouro )
• nu_endereco ( type: esriFieldTypeString, alias: nu_endereco, editable: true, nullable: true, length: 10, defaultValue: null, modelName: nu_endereco )
• no_complemento ( type: esriFieldTypeString, alias: no_complemento, editable: true, nullable: true, length: 20, defaultValue: null, modelName: no_complemento )
• no_bairro ( type: esriFieldTypeString, alias: no_bairro, editable: true, nullable: true, length: 40, defaultValue: null, modelName: no_bairro )
• co_cep ( type: esriFieldTypeString, alias: co_cep, editable: true, nullable: true, length: 8, defaultValue: null, modelName: co_cep )
• co_regiao_saude ( type: esriFieldTypeString, alias: co_regiao_saude, editable: true, nullable: true, length: 4, defaultValue: null, modelName: co_regiao_saude )
• co_micro_regiao ( type: esriFieldTypeString, alias: co_micro_regiao, editable: true, nullable: true, length: 6, defaultValue: null, modelName: co_micro_regiao )
• co_distrito_sanitario ( type: esriFieldTypeString, alias: co_distrito_sanitario, editable: true, nullable: true, length: 4, defaultValue: null, modelName: co_distrito_sanitario )
• co_distrito_administrativo ( type: esriFieldTypeString, alias: co_distrito_administrativo, editable: true, nullable: true, length: 4, defaultValue: null, modelName: co_distrito_administrativo )
• nu_telefone ( type: esriFieldTypeString, alias: nu_telefone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: nu_telefone )
• nu_fax ( type: esriFieldTypeString, alias: nu_fax, editable: true, nullable: true, length: 13, defaultValue: null, modelName: nu_fax )
• no_email ( type: esriFieldTypeString, alias: no_email, editable: true, nullable: true, length: 60, defaultValue: null, modelName: no_email )
• nu_cpf ( type: esriFieldTypeString, alias: nu_cpf, editable: true, nullable: true, length: 11, defaultValue: null, modelName: nu_cpf )
• nu_cnpj ( type: esriFieldTypeString, alias: nu_cnpj, editable: true, nullable: true, length: 14, defaultValue: null, modelName: nu_cnpj )
• co_atividade ( type: esriFieldTypeString, alias: co_atividade, editable: true, nullable: true, length: 2, defaultValue: null, modelName: co_atividade )
• co_clientela ( type: esriFieldTypeString, alias: co_clientela, editable: true, nullable: true, length: 2, defaultValue: null, modelName: co_clientela )
• nu_alvara ( type: esriFieldTypeString, alias: nu_alvara, editable: true, nullable: true, length: 25, defaultValue: null, modelName: nu_alvara )
• dt_expedicao ( type: esriFieldTypeString, alias: dt_expedicao, editable: true, nullable: true, length: 25, defaultValue: null, modelName: dt_expedicao )
• tp_orgao_expedidor ( type: esriFieldTypeString, alias: tp_orgao_expedidor, editable: true, nullable: true, length: 2, defaultValue: null, modelName: tp_orgao_expedidor )
• dt_val_lic_sani ( type: esriFieldTypeString, alias: dt_val_lic_sani, editable: true, nullable: true, length: 25, defaultValue: null, modelName: dt_val_lic_sani )
• tp_lic_sani ( type: esriFieldTypeString, alias: tp_lic_sani, editable: true, nullable: true, length: 1, defaultValue: null, modelName: tp_lic_sani )
• tp_unidade ( type: esriFieldTypeString, alias: tp_unidade, editable: true, nullable: true, length: 2, defaultValue: null, modelName: tp_unidade )
• co_turno_atendimento ( type: esriFieldTypeString, alias: co_turno_atendimento, editable: true, nullable: true, length: 2, defaultValue: null, modelName: co_turno_atendimento )
• ds_turno_atendimento ( type: esriFieldTypeString, alias: ds_turno_atendimento, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ds_turno_atendimento )
• descr_turno_consulta ( type: esriFieldTypeString, alias: descr_turno_consulta, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: descr_turno_consulta )
• co_estado_gestor ( type: esriFieldTypeString, alias: co_estado_gestor, editable: true, nullable: true, length: 2, defaultValue: null, modelName: co_estado_gestor )
• co_municipio_gestor ( type: esriFieldTypeString, alias: co_municipio_gestor, editable: true, nullable: true, length: 7, defaultValue: null, modelName: co_municipio_gestor )
• dt_atualizacao ( type: esriFieldTypeString, alias: dt_atualizacao, editable: true, nullable: true, length: 25, defaultValue: null, modelName: dt_atualizacao )
• co_usuario ( type: esriFieldTypeString, alias: co_usuario, editable: true, nullable: true, length: 12, defaultValue: null, modelName: co_usuario )
• co_cpfdiretorcln ( type: esriFieldTypeString, alias: co_cpfdiretorcln, editable: true, nullable: true, length: 11, defaultValue: null, modelName: co_cpfdiretorcln )
• reg_diretorcln ( type: esriFieldTypeString, alias: reg_diretorcln, editable: true, nullable: true, length: 60, defaultValue: null, modelName: reg_diretorcln )
• st_adesao_filantrop ( type: esriFieldTypeString, alias: st_adesao_filantrop, editable: true, nullable: true, length: 1, defaultValue: null, modelName: st_adesao_filantrop )
• co_motivo_desab ( type: esriFieldTypeString, alias: co_motivo_desab, editable: true, nullable: true, length: 2, defaultValue: null, modelName: co_motivo_desab )
• no_url ( type: esriFieldTypeString, alias: no_url, editable: true, nullable: true, length: 60, defaultValue: null, modelName: no_url )
• nu_latitude ( type: esriFieldTypeString, alias: nu_latitude, editable: true, nullable: true, length: 30, defaultValue: null, modelName: nu_latitude )
• nu_longitude ( type: esriFieldTypeString, alias: nu_longitude, editable: true, nullable: true, length: 30, defaultValue: null, modelName: nu_longitude )
• dt_atu_geo ( type: esriFieldTypeString, alias: dt_atu_geo, editable: true, nullable: true, length: 25, defaultValue: null, modelName: dt_atu_geo )
• no_usuario_geo ( type: esriFieldTypeString, alias: no_usuario_geo, editable: true, nullable: true, length: 60, defaultValue: null, modelName: no_usuario_geo )
• co_natureza_jur ( type: esriFieldTypeString, alias: co_natureza_jur, editable: true, nullable: true, length: 4, defaultValue: null, modelName: co_natureza_jur )
• tp_estab_sempre_aberto ( type: esriFieldTypeString, alias: tp_estab_sempre_aberto, editable: true, nullable: true, length: 1, defaultValue: null, modelName: tp_estab_sempre_aberto )
• st_geracredito_gerente_sgif ( type: esriFieldTypeString, alias: st_geracredito_gerente_sgif, editable: true, nullable: true, length: 1, defaultValue: null, modelName: st_geracredito_gerente_sgif )
• st_conexao_internet ( type: esriFieldTypeString, alias: st_conexao_internet, editable: true, nullable: true, length: 1, defaultValue: null, modelName: st_conexao_internet )
• co_tipo_unidade ( type: esriFieldTypeString, alias: co_tipo_unidade, editable: true, nullable: true, length: 2, defaultValue: null, modelName: co_tipo_unidade )
• no_fantasia_abrev ( type: esriFieldTypeString, alias: no_fantasia_abrev, editable: true, nullable: true, length: 21, defaultValue: null, modelName: no_fantasia_abrev )
• tp_gestao ( type: esriFieldTypeString, alias: tp_gestao, editable: true, nullable: true, length: 1, defaultValue: null, modelName: tp_gestao )
• dt_atualizacao_origem ( type: esriFieldTypeString, alias: dt_atualizacao_origem, editable: true, nullable: true, length: 25, defaultValue: null, modelName: dt_atualizacao_origem )
• co_tipo_estabelecimento ( type: esriFieldTypeString, alias: co_tipo_estabelecimento, editable: true, nullable: true, length: 3, defaultValue: null, modelName: co_tipo_estabelecimento )
• co_atividade_principal ( type: esriFieldTypeString, alias: co_atividade_principal, editable: true, nullable: true, length: 3, defaultValue: null, modelName: co_atividade_principal )
• st_contrato_formalizado ( type: esriFieldTypeString, alias: st_contrato_formalizado, editable: true, nullable: true, length: 1, defaultValue: null, modelName: st_contrato_formalizado )
• co_tipo_abrangencia ( type: esriFieldTypeString, alias: co_tipo_abrangencia, editable: true, nullable: true, length: 2, defaultValue: null, modelName: co_tipo_abrangencia )
• endereco_completo ( type: esriFieldTypeString, alias: endereco_completo, editable: true, nullable: true, length: 200, defaultValue: null, modelName: endereco_completo )

Templates:

• Name: tb_estabelecimento
  Description:
  Prototype:
  co_tipo_abrangencia: null
  endereco_completo: null
  co_unidade: null
  co_cnes: null
  nu_cnpj_mantenedora: null
  tp_pfpj: null
  nivel_dep: null
  no_razao_social: null
  no_fantasia: null
  no_logradouro: null
  nu_endereco: null
  no_complemento: null
  no_bairro: null
  co_cep: null
  co_regiao_saude: null
  co_micro_regiao: null
  co_distrito_sanitario: null
  co_distrito_administrativo: null
  nu_telefone: null
  nu_fax: null
  no_email: null
  nu_cpf: null
  nu_cnpj: null
  co_atividade: null
  co_clientela: null
  nu_alvara: null
  dt_expedicao: null
  tp_orgao_expedidor: null
  dt_val_lic_sani: null
  tp_lic_sani: null
  tp_unidade: null
  co_turno_atendimento: null
  ds_turno_atendimento: null
  descr_turno_consulta: null
  co_estado_gestor: null
  co_municipio_gestor: null
  dt_atualizacao: null
  co_usuario: null
  co_cpfdiretorcln: null
  reg_diretorcln: null
  st_adesao_filantrop: null
  co_motivo_desab: null
  no_url: null
  nu_latitude: null
  nu_longitude: null
  dt_atu_geo: null
  no_usuario_geo: null
  co_natureza_jur: null
  tp_estab_sempre_aberto: null
  st_geracredito_gerente_sgif: null
  st_conexao_internet: null
  co_tipo_unidade: null
  no_fantasia_abrev: null
  tp_gestao: null
  dt_atualizacao_origem: null
  co_tipo_estabelecimento: null
  co_atividade_principal: null
  st_contrato_formalizado: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata