Name: bdgc.sdp.registro_social

Display Field: id_hogar

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 952b3a84ea72457586a75d6d410807c3

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: 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 )
• id_hogar ( type: esriFieldTypeString, alias: ID Hogar, editable: true, nullable: true, length: 50, defaultValue: null, modelName: id_hogar )
• pnombre ( type: esriFieldTypeString, alias: Primer nombre, editable: true, nullable: true, length: 100, defaultValue: null, modelName: pnombre )
• snombre ( type: esriFieldTypeString, alias: Segundo nombre, editable: true, nullable: true, length: 100, defaultValue: null, modelName: snombre )
• papellido ( type: esriFieldTypeString, alias: Primer apellido, editable: true, nullable: true, length: 100, defaultValue: null, modelName: papellido )
• sapellido ( type: esriFieldTypeString, alias: Segundo apellido, editable: true, nullable: true, length: 100, defaultValue: null, modelName: sapellido )
• sexo ( type: esriFieldTypeSmallInteger, alias: Sexo, editable: true, nullable: true, defaultValue: null, modelName: sexo , Coded Values: [1: Hombre] , [2: Mujer] , [3: No responde] )
• tipo_documento ( type: esriFieldTypeSmallInteger, alias: Tipo de documento, editable: true, nullable: true, defaultValue: null, modelName: tipo_documento , Coded Values: [1: Cedula de ciudadania] , [2: Tarjeta de identidad] , [3: Cedula de extranjeria] , ...7 more... )
• id_beneficiario ( type: esriFieldTypeString, alias: Identificación del beneficiario, editable: true, nullable: true, length: 50, defaultValue: null, modelName: id_beneficiario )
• fnacimiento ( type: esriFieldTypeDate, alias: Fecha de nacimiento, editable: true, nullable: true, length: 8, defaultValue: null, modelName: fnacimiento )
• direccion ( type: esriFieldTypeString, alias: Dirección de la vivienda, editable: true, nullable: true, length: 150, defaultValue: null, modelName: direccion )
• resolucion_asignacion ( type: esriFieldTypeString, alias: Resolución de asignación, editable: true, nullable: true, length: 50, defaultValue: null, modelName: resolucion_asignacion )
• año_resolucion ( type: esriFieldTypeString, alias: Año de la resolución, editable: true, nullable: true, length: 4, defaultValue: null, modelName: año_resolucion )
• fecha_resolucion ( type: esriFieldTypeDate, alias: Fecha de la resolución, editable: true, nullable: true, length: 8, defaultValue: null, modelName: fecha_resolucion )
• estado_proceso ( type: esriFieldTypeSmallInteger, alias: Estado del proceso, editable: true, nullable: true, defaultValue: null, modelName: estado_proceso , Coded Values: [1: Asignacion - Asignado] , [2: Asignacion – Renuncia] , [3: Asignacion – Perdida] , ...10 more... )
• valor_subsidio ( type: esriFieldTypeDouble, alias: Valor del subsidio, editable: true, nullable: true, defaultValue: null, modelName: valor_subsidio )
• parentesco ( type: esriFieldTypeString, alias: Parentesco con el jefe de hogar, editable: true, nullable: true, length: 50, defaultValue: null, modelName: parentesco )
• tipo_solucion ( type: esriFieldTypeSmallInteger, alias: Tipo de solución, editable: true, nullable: true, defaultValue: null, modelName: tipo_solucion , Coded Values: [1: VIS] , [2: VIP] , [3: No aplica] )
• loc_destino ( type: esriFieldTypeString, alias: Localidad destino, editable: true, nullable: true, length: 2, defaultValue: null, modelName: loc_destino , Coded Values: [01: Usaquén] , [02: Chapinero] , [03: Santa Fe] , ...17 more... )
• loc_origen ( type: esriFieldTypeString, alias: Localidad origen, editable: true, nullable: true, length: 2, defaultValue: null, modelName: loc_origen , Coded Values: [01: Usaquén] , [02: Chapinero] , [03: Santa Fe] , ...17 more... )
• programa ( type: esriFieldTypeSmallInteger, alias: Programa, editable: true, nullable: true, defaultValue: null, modelName: programa , Coded Values: [1: Reactiva Tu Compra, Reactiva Tu Hogar] , [2: Mi Casa Ya] , [3: Oferta Preferente] , ...5 more... )
• responsable ( type: esriFieldTypeInteger, alias: Responsable SDHT, editable: true, nullable: true, defaultValue: null, modelName: reponsable , Coded Values: [100000: Subdirección de Información Sectorial] , [100010: Subdirección de Gestión del Suelo] , [100020: Subdirección de Servicios Públicos] , ...7 more... )
• chip ( type: esriFieldTypeString, alias: chip, editable: true, nullable: true, length: 50, defaultValue: null, modelName: chip )

Templates:

• Name: bdgc.sdp.registro_social
  Description:
  Prototype:
  responsable: null
  chip: null
  id_hogar: null
  pnombre: null
  snombre: null
  papellido: null
  sapellido: null
  sexo: null
  tipo_documento: null
  id_beneficiario: null
  fnacimiento: null
  direccion: null
  resolucion_asignacion: null
  año_resolucion: null
  fecha_resolucion: null
  estado_proceso: null
  valor_subsidio: null
  parentesco: null
  tipo_solucion: null
  loc_destino: null
  loc_origen: null
  programa: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,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

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata