Name: GISDB.DBO.TB_FISCAMBIENTAL_18_19

Display Field: tx_codproc

Type: Table

Geometry Type: N/A

Description:

Service Item Id: null

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• tx_codproc ( type: esriFieldTypeString, alias: Código do Processo, editable: true, nullable: true, length: 90, defaultValue: null, modelName: tx_codproc )
• dt_entrpro ( type: esriFieldTypeDate, alias: Data de Entrada do Processo, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dt_entrpro )
• li_mtvproc ( type: esriFieldTypeInteger, alias: Motivação do Processso, editable: true, nullable: true, defaultValue: null, modelName: li_mtvproc , Coded Values: [1: Denúncia] , [2: Solicitação do Ministério Público] , [3: Outros] , ...1 more... )
• li_tplogia ( type: esriFieldTypeInteger, alias: Tipo de Fiscalização, editable: true, nullable: true, defaultValue: null, modelName: li_tplogia , Coded Values: [1: Água de Poço] , [2: Contrução Irregular] , [3: Danos Ambientais] , ...24 more... )
• tx_categfisc ( type: esriFieldTypeString, alias: Categoria de Fiscalização, editable: true, nullable: true, length: 100, defaultValue: null, modelName: tx_categfisc )
• tx_comenta ( type: esriFieldTypeString, alias: Comentários, editable: true, nullable: true, length: 250, defaultValue: null, modelName: tx_comenta )
• tx_fscresp ( type: esriFieldTypeString, alias: Fiscais Responsáveis, editable: true, nullable: true, length: 90, defaultValue: null, modelName: tx_fscresp )
• dt_vistoria ( type: esriFieldTypeDate, alias: Data de Vistoria, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dt_vistoria )
• tx_nmautua ( type: esriFieldTypeString, alias: Nome do Autuado, editable: true, nullable: true, length: 90, defaultValue: null, modelName: tx_nmautua )
• li_tpdocau ( type: esriFieldTypeInteger, alias: Tipo do Doc. do Autuado, editable: true, nullable: true, defaultValue: null, modelName: li_tpdocau , Coded Values: [1: Carteira de identidade] , [2: Carteira de Trabalho] , [3: Certificado de Reservista] , ...10 more... )
• dt_prazo ( type: esriFieldTypeDate, alias: Prazo, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dt_prazo )
• n_contat ( type: esriFieldTypeString, alias: Num. Constatação, editable: true, nullable: true, length: 50, defaultValue: null, modelName: n_contat )
• n_notific ( type: esriFieldTypeString, alias: Num. Notificação, editable: true, nullable: true, length: 50, defaultValue: null, modelName: n_notific )
• n_Infracao ( type: esriFieldTypeString, alias: Num. Infração, editable: true, nullable: true, length: 50, defaultValue: null, modelName: n_Infracao )
• li_condvist ( type: esriFieldTypeInteger, alias: Condição de Vistoria, editable: true, nullable: true, defaultValue: null, modelName: li_condvist , Coded Values: [1: Vistoriado] , [2: Em curso] , [3: Pendente] )
• tx_requerent ( type: esriFieldTypeString, alias: Requerente, editable: true, nullable: true, length: 100, defaultValue: null, modelName: tx_requerent )
• CreatedOn ( type: esriFieldTypeDate, alias: CreatedOn, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreatedOn )
• ModifiedOn ( type: esriFieldTypeDate, alias: ModifiedOn, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ModifiedOn )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, editable: true, nullable: true, length: 200, defaultValue: null, modelName: CreatedBy )
• ModifiedBy ( type: esriFieldTypeString, alias: ModifiedBy, editable: true, nullable: true, length: 200, defaultValue: null, modelName: ModifiedBy )
• ModifiedByHost ( type: esriFieldTypeString, alias: ModifiedByHost, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ModifiedByHost )
• SessionId ( type: esriFieldTypeString, alias: SessionId, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SessionId )
• num_docaut ( type: esriFieldTypeString, alias: Número do Doc. do Autuado, editable: true, nullable: true, length: 50, defaultValue: null, modelName: num_docaut )

Templates:

• Name: GISDB.DBO.TB_FISCAMBIENTAL_18_19
  Description:
  Prototype:
  SessionId: null
  num_docaut: null
  tx_codproc: null
  dt_entrpro: null
  li_mtvproc: null
  li_tplogia: null
  tx_categfisc: null
  tx_comenta: null
  tx_fscresp: null
  dt_vistoria: null
  tx_nmautua: null
  li_tpdocau: null
  dt_prazo: null
  n_contat: null
  n_notific: null
  n_Infracao: null
  li_condvist: null
  tx_requerent: null
  CreatedOn: null
  ModifiedOn: null
  CreatedBy: null
  ModifiedBy: null
  ModifiedByHost: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• P_FISCAMBIENTAL_18_19 (1) -- Related To: Pontos da Fiscalização Ambiental 18/19 (210)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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