Layers:

Layer: Boletín de Verificación Alcantarillado Z2 (0)

Name: Boletín de Verificación Alcantarillado Z2

Display Field: AVISO

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -81.369458579
YMin: -27.358457906
XMax: 12.624413973000001
YMax: 45.847440192
Spatial Reference: 4686  (4686)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
Transparency: 0
Labeling Info:
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: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• AVISO ( type: esriFieldTypeString, alias: No. Aviso:, length: 10 )
• ZONA ( type: esriFieldTypeString, alias: Zona:, length: 5 , Coded Values: [ZN01: Zona 1] , [ZN02: Zona 2] , [ZN03: Zona 3] , ...3 more... )
• SECTOR ( type: esriFieldTypeString, alias: Sector:, length: 50 )
• F_INI ( type: esriFieldTypeDate, alias: Fecha/Hora de inicio:, length: 8 )
• DIRECC ( type: esriFieldTypeString, alias: Direccion:, length: 80 )
• BARRIO ( type: esriFieldTypeString, alias: Barrio:, length: 100 )
• LOCALIDAD ( type: esriFieldTypeString, alias: Localidad:, length: 3 , Coded Values: [01: USAQUEN] , [02: CHAPINERO] , [03: SANTA FE] , ...7 more... )
• MUNICIPIO ( type: esriFieldTypeString, alias: Municipio:, length: 6 , Coded Values: [11001: BOGOTÁ, D.C.] , [25754: SOACHA] , [25175: CHÍA] , ...3 more... )
• VERIFICADOR ( type: esriFieldTypeString, alias: Verificador:, length: 12 , Coded Values: [79888471: Juan P Cuellar Chavez] , [1030523015: Jose D Ducuara Alvarado] , [79829193: Samir Ruiz Romero] , ...25 more... )
• TRABAJO ( type: esriFieldTypeString, alias: Trabajo:, length: 2 , Coded Values: [D1: Preventivo] , [D2: Correctivo] , [NO: Ninguno] )
• SISTEMA ( type: esriFieldTypeString, alias: Sistema:, length: 2 , Coded Values: [0: Sanitario] , [1: Pluvial] , [2: Combinado] , ...1 more... )
• TIPOLOGIA_LS ( type: esriFieldTypeString, alias: Tipología Limp/Sondeo:, length: 15 , Coded Values: [ALCASOND-AS01: Domiciliaria para sondear] , [ALCASOND-AR06: Tubería PLUVIAL sondear] , [ALCASOND-AS04: Tubería SANITARIO sondear] , ...17 more... )
• TIPOLOGIA_RR ( type: esriFieldTypeString, alias: Tipología Recon/Repo:, length: 15 , Coded Values: [ALCARECO-AR01: Domiciliaria para reconstruir] , [ALCARECO-AR06: Tubería SANITARIO para reconstruir] , [ALCARECO-AR07: Tubería COMBINADO para reconstruir] , ...9 more... )
• TIPOLOGIA_OT ( type: esriFieldTypeString, alias: Tipología Otros:, length: 15 , Coded Values: [ALCOTROS-0010: Inspeccionar sistema alcantarillado] , [ALCOTROS-0015: Filtracion aguas residuales por atender] , [ALCOTROS-0025: Inundación por atender] , ...6 more... )
• VERFICACION ( type: esriFieldTypeString, alias: Verificación:, length: 10 , Coded Values: [SGO-EFEC: Efectivo] , [SGO-INEF: Inefectivo] )
• F_FIN ( type: esriFieldTypeDate, alias: Fecha/Hora Fin:, length: 8 )
• CAUSA ( type: esriFieldTypeString, alias: Causa Inefect:, length: 15 , Coded Values: [ALCINEFE-0010: Dirección errada] , [ALCINEFE-0015: Daño interno] , [ALCINEFE-0020: Repetido] , ...11 more... )
• EST_COLM ( type: esriFieldTypeString, alias: Est. Colmatación:, length: 8 , Coded Values: [SGO-A: Alta] , [SGO-M: Media] , [SGO-B: Baja] )
• ACC_SITIO ( type: esriFieldTypeString, alias: Acceso Sitio:, length: 10 , Coded Values: [SGO-PEAT: Peatonal] , [SGO-VEHI: Vehicular] , [SGO-ESCA: Escaleras] )
• OBSTAC ( type: esriFieldTypeString, alias: Obstaculo Vía:, length: 12 , Coded Values: [SGO-BOLARDO: Bolardo] , [SGO-CADENA: Cadena] , [SGO-ROCA: Rocas] , ...1 more... )
• LIMP_1 ( type: esriFieldTypeString, alias: Limpieza 1:, length: 15 , Coded Values: [ALCALIMP-AL00: Tubería SANITARIO para limpiar] , [ALCALIMP-AL01: Tubería COMBINADO para limpiar] , [ALCALIMP-AL02: Tubería PLUVIAL para limpiar] , ...11 more... )
• LIMP_2 ( type: esriFieldTypeString, alias: Limpieza 2:, length: 15 , Coded Values: [ALCALIMP-AL00: Tubería SANITARIO para limpiar] , [ALCALIMP-AL01: Tubería COMBINADO para limpiar] , [ALCALIMP-AL02: Tubería PLUVIAL para limpiar] , ...11 more... )
• SON_1 ( type: esriFieldTypeString, alias: Sondeo 1:, length: 15 , Coded Values: [ALCASOND-AS01: Domiciliaria para sondear] , [ALCASOND-AR06: Tubería PLUVIAL sondear] , [ALCASOND-AS04: Tubería SANITARIO sondear] , ...3 more... )
• SON_2 ( type: esriFieldTypeString, alias: Sondeo 2:, length: 15 , Coded Values: [ALCASOND-AS01: Domiciliaria para sondear] , [ALCASOND-AR06: Tubería PLUVIAL sondear] , [ALCASOND-AS04: Tubería SANITARIO sondear] , ...3 more... )
• REP_1 ( type: esriFieldTypeString, alias: Reposición 1:, length: 15 , Coded Values: [ALCAREPO-AR01: Tapa rectangular sumidero Instalar] , [ALCAREPO-AR02: Rejilla sumidero instalar] , [ALCAREPO-AR03: Tapa convencional pozo instalar] , ...3 more... )
• REP_2 ( type: esriFieldTypeString, alias: Reposición 2:, length: 15 , Coded Values: [ALCAREPO-AR01: Tapa rectangular sumidero Instalar] , [ALCAREPO-AR02: Rejilla sumidero instalar] , [ALCAREPO-AR03: Tapa convencional pozo instalar] , ...3 more... )
• RECONS_1 ( type: esriFieldTypeString, alias: Reconstrucción 1:, length: 15 , Coded Values: [ALCARECO-AR01: Domiciliaria para reconstruir] , [ALCARECO-AR06: Tubería SANITARIO para reconstruir] , [ALCARECO-AR07: Tubería COMBINADO para reconstruir] , ...9 more... )
• RECONS_2 ( type: esriFieldTypeString, alias: Reconstrucción 2:, length: 15 , Coded Values: [ALCARECO-AR01: Domiciliaria para reconstruir] , [ALCARECO-AR06: Tubería SANITARIO para reconstruir] , [ALCARECO-AR07: Tubería COMBINADO para reconstruir] , ...9 more... )
• EP_1 ( type: esriFieldTypeString, alias: Espacio Publico 1:, length: 20 , Coded Values: [ALCAPUBL-0010: Anden concreto para reconstruir] , [ALCAPUBL-0040: Andén tableta para reconstruir] , [ALCAPUBL-0020: Vía concreto reconstruir] , ...5 more... )
• EP_2 ( type: esriFieldTypeString, alias: Espacio Publico 2:, length: 20 , Coded Values: [ALCAPUBL-0010: Anden concreto para reconstruir] , [ALCAPUBL-0040: Andén tableta para reconstruir] , [ALCAPUBL-0020: Vía concreto reconstruir] , ...5 more... )
• TAPAS ( type: esriFieldTypeString, alias: Tapas:, length: 10 , Coded Values: [SGO-TIDU: Tapa IDU] , [SGO-CONV: Tapa Convencional] , [SGO-RECTA: Tapa Rectangular] )
• DIAM_CM ( type: esriFieldTypeDouble, alias: Diam. cm: )
• MATERIAL ( type: esriFieldTypeString, alias: Material Tapa:, length: 15 , Coded Values: [SGO-CONCRE: Concreto] , [SGO-NO_RECI: No Reciclable] , [SGO-9999: Otro Material] )
• OTR_1 ( type: esriFieldTypeString, alias: Otros 1:, length: 15 , Coded Values: [ALCOTROS-0010: Inspeccionar sistema alcantarillado] , [ALCOTROS-0015: Filtracion aguas residuales por atender] , [ALCOTROS-0025: Inundación por atender] , ...6 more... )
• OTR_2 ( type: esriFieldTypeString, alias: Otros 2:, length: 15 , Coded Values: [ALCOTROS-0010: Inspeccionar sistema alcantarillado] , [ALCOTROS-0015: Filtracion aguas residuales por atender] , [ALCOTROS-0025: Inundación por atender] , ...6 more... )
• CUAL ( type: esriFieldTypeString, alias: ¿Cual?:, length: 50 )
• INGENIERO ( type: esriFieldTypeString, alias: Ingeniero(a):, length: 50 )
• USR_NOM ( type: esriFieldTypeString, alias: Nom. Usuario:, length: 80 )
• CC ( type: esriFieldTypeInteger, alias: Cédula/NIT: )
• TEL ( type: esriFieldTypeInteger, alias: Tel.: )
• OBSERV ( type: esriFieldTypeString, alias: Observ., length: 400 )
• SIS_STATUS ( type: esriFieldTypeString, alias: Estatus Sistema:, length: 4 , Coded Values: [MEAB: Mensaje Abierto] , [METR: Mensaje en Tratamiento] , [MECE: Mensaje Cerrado] , ...1 more... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SGO_STATUS ( type: esriFieldTypeString, alias: Estado Envio SAP:, length: 5 , Coded Values: [MESGO: Pendiente Enviar a SAP] , [MESAP: Enviado a SAP] )
Relationships:
• Z2_ALC_CT_APYMAQ (0) -- Related To: SGO.Z2_ALC_CT_APYMAQ (3)
• Z2_ALC_CT_RECREP (1) -- Related To: SGO.Z2_ALC_CT_RECREP (1)
• Z2_ALC_CT_LIMSON (2) -- Related To: SGO.Z2_ALC_CT_LIMSON (2)

Tables:

Table: SGO.Z2_ALC_CT_RECREP (1)

Name: SGO.Z2_ALC_CT_RECREP

Display Field: ORDEN

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ORDEN ( type: esriFieldTypeString, alias: No. Orden:, length: 25 )
• SIMBOLO ( type: esriFieldTypeString, alias: Simbolo:, length: 10 , Coded Values: [DZ2-C106: C106] , [DZ2-Q72: Q72] , [DZ2-Q99: Q99] , ...10 more... )
• AVISO ( type: esriFieldTypeString, alias: No. Aviso:, length: 10 )
• F_INI ( type: esriFieldTypeDate, alias: Fecha/Hora de Inicio:, length: 8 )
• AV_HIST ( type: esriFieldTypeString, alias: Avis. con Historia:, length: 6 , Coded Values: [SGO-S: SI] , [SGO-N: NO] )
• TRAB_SOL_REC ( type: esriFieldTypeString, alias: Trab. Solicitado Reconst:, length: 15 , Coded Values: [ALCARECO-AR01: Domiciliaria para reconstruir] , [ALCARECO-AR06: Tubería SANITARIO para reconstruir] , [ALCARECO-AR07: Tubería COMBINADO para reconstruir] , ...9 more... )
• TRAB_SOL_REP ( type: esriFieldTypeString, alias: Trab. Solicitado Reposic:, length: 15 , Coded Values: [ALCAREPO-AR01: Tapa rectangular sumidero Instalar] , [ALCAREPO-AR02: Rejilla sumidero instalar] , [ALCAREPO-AR03: Tapa convencional pozo instalar] , ...3 more... )
• TRAB_SOL_OTR ( type: esriFieldTypeString, alias: Trab. Solicitado Otro:, length: 15 , Coded Values: [ALCOTROS-0010: Inspeccionar sistema alcantarillado] , [ALCOTROS-0015: Filtracion aguas residuales por atender] , [ALCOTROS-0025: Inundación por atender] , ...6 more... )
• TIPO_TRAB ( type: esriFieldTypeString, alias: Tipo:, length: 3 , Coded Values: [D1: Preventivo] , [D2: Correctivo] , [NO: Ninguno] )
• PRIORIDAD ( type: esriFieldTypeString, alias: Prioridad:, length: 6 , Coded Values: [SGO-A: Alta] , [SGO-M: Media] , [SGO-B: Baja] )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector:, length: 10 , Coded Values: [37001663: Juan Fernando Moreno Riveros] , [37002564: Oscar Enrique Fajardo Rodriguez] , [37000487: Carlos Guillermo Gonzalez Rivera] )
• OTR_INSPEC ( type: esriFieldTypeString, alias: Otro Inspector ¿Cuál?:, length: 50 )
• OPERADOR ( type: esriFieldTypeString, alias: Operador:, length: 10 , Coded Values: [37035861: Aristides Hernandez] , [37035687: Camilo Moncada] , [37003464: Carlos Adelmo Garzon] , ...12 more... )
• OTR_OPER ( type: esriFieldTypeString, alias: Otro Operador ¿Cuál?:, length: 100 )
• AYUDANTE_1 ( type: esriFieldTypeString, alias: Ayudante 01:, length: 10 , Coded Values: [37035297: Brian Riaño] , [37035687: Camilo Moncada] , [38000620: Carlos Caro] , ...49 more... )
• AYUDANTE_2 ( type: esriFieldTypeString, alias: Ayudante 02:, length: 10 , Coded Values: [37035297: Brian Riaño] , [37035687: Camilo Moncada] , [38000620: Carlos Caro] , ...49 more... )
• AYUDANTE_3 ( type: esriFieldTypeString, alias: Ayudante 03:, length: 10 , Coded Values: [37035297: Brian Riaño] , [37035687: Camilo Moncada] , [38000620: Carlos Caro] , ...49 more... )
• AYUDANTE_4 ( type: esriFieldTypeString, alias: Ayudante 04:, length: 10 , Coded Values: [37035297: Brian Riaño] , [37035687: Camilo Moncada] , [38000620: Carlos Caro] , ...49 more... )
• OTR_AYUD ( type: esriFieldTypeString, alias: Otro Ayudante ¿Cuál?:, length: 100 )
• KM_INI ( type: esriFieldTypeDouble, alias: KM Inicio: )
• KM_FIN ( type: esriFieldTypeDouble, alias: KM Fin: )
• EQUIPO_1 ( type: esriFieldTypeString, alias: Equipo 1:, length: 10 , Coded Values: [32310E25: Bulldozer] , [32310E12-1: Retro Llanta] , [32310E14: Paladraga] , ...10 more... )
• EQUIPO_2 ( type: esriFieldTypeString, alias: Equipo 2:, length: 10 , Coded Values: [32310E25: Bulldozer] , [32310E12-1: Retro Llanta] , [32310E14: Paladraga] , ...10 more... )
• EQUIPO_3 ( type: esriFieldTypeString, alias: Equipo 3:, length: 10 , Coded Values: [32310E25: Bulldozer] , [32310E12-1: Retro Llanta] , [32310E14: Paladraga] , ...10 more... )
• EQUIPO_4 ( type: esriFieldTypeString, alias: Equipo 4:, length: 10 , Coded Values: [32310E25: Bulldozer] , [32310E12-1: Retro Llanta] , [32310E14: Paladraga] , ...10 more... )
• EQUIPO_5 ( type: esriFieldTypeString, alias: Otro, ¿Cuál?:, length: 50 )
• RECONST_1 ( type: esriFieldTypeString, alias: Reconst. 01:, length: 15 , Coded Values: [ALCARECO-AR06: Tubería SANITARIO Reconstruida] , [ALCARECO-AR08: Tubería PLUVIAL Reconstruida] , [ALCARECO-AR07: Tubería COMBINADO Reconstruida] , ...9 more... )
• LONG_UNID_1 ( type: esriFieldTypeDouble, alias: Un. o Long. (m): )
• DIAM_RC_1 ( type: esriFieldTypeDouble, alias: Diametro: )
• MAT_RC_1 ( type: esriFieldTypeString, alias: Material:, length: 2 , Coded Values: [0: Concreto] , [1: Gres] , [2: Ladrillo] , ...9 more... )
• RECONST_2 ( type: esriFieldTypeString, alias: Reconst. 02:, length: 15 , Coded Values: [ALCARECO-AR06: Tubería SANITARIO Reconstruida] , [ALCARECO-AR08: Tubería PLUVIAL Reconstruida] , [ALCARECO-AR07: Tubería COMBINADO Reconstruida] , ...9 more... )
• LONG_UNID_2 ( type: esriFieldTypeDouble, alias: Un. o Long. (m): )
• DIAM_RC_2 ( type: esriFieldTypeDouble, alias: Diametro: )
• MAT_RC_2 ( type: esriFieldTypeString, alias: Material:, length: 2 , Coded Values: [0: Concreto] , [1: Gres] , [2: Ladrillo] , ...9 more... )
• RECONST_3 ( type: esriFieldTypeString, alias: Otra, ¿Cuál Reconst.?:, length: 100 )
• LONG_UNID_3 ( type: esriFieldTypeDouble, alias: Un. o Long. (m): )
• DIAM_RC_3 ( type: esriFieldTypeDouble, alias: Diametro: )
• MAT_RC_3 ( type: esriFieldTypeString, alias: Material:, length: 2 , Coded Values: [0: Concreto] , [1: Gres] , [2: Ladrillo] , ...9 more... )
• REPOS_1 ( type: esriFieldTypeString, alias: Reposic. 01:, length: 15 , Coded Values: [ALCAREPO-AR03: Tapa convencional pozo instalada] , [ALCAREPO-AR01: Tapa rectangular sumidero instalada] , [ALCAREPO-AR02: Rejilla sumidero instalada] , ...3 more... )
• CANT_RP_1 ( type: esriFieldTypeDouble, alias: Unidad.: )
• DIMEN_RP_1 ( type: esriFieldTypeString, alias: Dimension (m):, length: 20 , Coded Values: [SGO-0.7: 0.7 m] , [SGO-0.65: 0.65 m] , [SGO-0.66: 0.66 m] , ...8 more... )
• REPOS_2 ( type: esriFieldTypeString, alias: Reposic. 02:, length: 15 , Coded Values: [ALCAREPO-AR03: Tapa convencional pozo instalada] , [ALCAREPO-AR01: Tapa rectangular sumidero instalada] , [ALCAREPO-AR02: Rejilla sumidero instalada] , ...3 more... )
• CANT_RP_2 ( type: esriFieldTypeDouble, alias: Unidad.: )
• DIMEN_RP_2 ( type: esriFieldTypeString, alias: Dimension (m):, length: 20 , Coded Values: [SGO-0.7: 0.7 m] , [SGO-0.65: 0.65 m] , [SGO-0.66: 0.66 m] , ...8 more... )
• REPOS_3 ( type: esriFieldTypeString, alias: Otra, ¿Cuál Reposic?:, length: 100 )
• CANT_RP_3 ( type: esriFieldTypeDouble, alias: Unidad.: )
• DIMEN_RP_3 ( type: esriFieldTypeString, alias: Dimension (m):, length: 20 , Coded Values: [SGO-0.7: 0.7 m] , [SGO-0.65: 0.65 m] , [SGO-0.66: 0.66 m] , ...8 more... )
• ESP_PUB_1 ( type: esriFieldTypeString, alias: Espacio Pub. 01:, length: 20 , Coded Values: [ALCAPUBL-0010: Anden concreto reconstruido] , [ALCAPUBL-0040: Andén tableta reconstruído] , [ALCAPUBL-0015: Vía asfalto reparchada] , ...7 more... )
• CANT_EP_1 ( type: esriFieldTypeDouble, alias: Cant. (m2): )
• ESP_PUB_2 ( type: esriFieldTypeString, alias: Espacio Pub. 02:, length: 20 , Coded Values: [ALCAPUBL-0010: Anden concreto reconstruido] , [ALCAPUBL-0040: Andén tableta reconstruído] , [ALCAPUBL-0015: Vía asfalto reparchada] , ...7 more... )
• CANT_EP_2 ( type: esriFieldTypeDouble, alias: Cant. (m2): )
• CUAL_1 ( type: esriFieldTypeString, alias: Otro, ¿Cuál Espacio Púb.?:, length: 50 )
• CANT_EP_3 ( type: esriFieldTypeDouble, alias: Cant. (m2): )
• OTROS_1 ( type: esriFieldTypeString, alias: Otros 01:, length: 15 , Coded Values: [ALCOTROS-0010: Inundación atendida] , [ALCOTROS-0020: Filtracion aguas residuales atendida] , [ALCOTROS-0035: Rebose Alcant. con afectación Predio] , ...5 more... )
• OTROS_2 ( type: esriFieldTypeString, alias: Otros 02:, length: 15 , Coded Values: [ALCOTROS-0010: Inundación atendida] , [ALCOTROS-0020: Filtracion aguas residuales atendida] , [ALCOTROS-0035: Rebose Alcant. con afectación Predio] , ...5 more... )
• CUAL_OT ( type: esriFieldTypeString, alias: Otro, ¿Cuál?:, length: 50 )
• POR_LA ( type: esriFieldTypeString, alias: Por la:, length: 50 )
• HASTA_LA ( type: esriFieldTypeString, alias: Hasta la:, length: 50 )
• DE_LA ( type: esriFieldTypeString, alias: De la:, length: 50 )
• A_LA ( type: esriFieldTypeString, alias: A la:, length: 50 )
• N_TRAMOS ( type: esriFieldTypeInteger, alias: # Tramos: )
• MAT_TUB ( type: esriFieldTypeString, alias: ¿Tubería?:, length: 8 , Coded Values: [SGO-S: SI] , [SGO-N: NO] )
• LONG_1 ( type: esriFieldTypeDouble, alias: Long. (m): )
• DIAM_3 ( type: esriFieldTypeDouble, alias: Diametro: )
• MATE_2 ( type: esriFieldTypeString, alias: Material Tuberia:, length: 15 , Coded Values: [0: Concreto] , [1: Gres] , [2: Ladrillo] , ...9 more... )
• CANT_5 ( type: esriFieldTypeDouble, alias: Cantidad: )
• UNIDAD_1 ( type: esriFieldTypeString, alias: Unidad:, length: 8 , Coded Values: [SGO-Un: un.] , [SGO-m: m.] , [SGO-Pg: Pulg.] , ...6 more... )
• MATE_3 ( type: esriFieldTypeString, alias: Material 03:, length: 15 , Coded Values: [SGO-0001: Cemento] , [SGO-0002: Arena de Peña] , [SGO-0003: Arena de Rio] , ...11 more... )
• CANT_6 ( type: esriFieldTypeDouble, alias: Cantidad: )
• UNIDAD_2 ( type: esriFieldTypeString, alias: Unidad:, length: 8 , Coded Values: [SGO-Un: un.] , [SGO-m: m.] , [SGO-Pg: Pulg.] , ...6 more... )
• MATE_4 ( type: esriFieldTypeString, alias: Material 04:, length: 15 , Coded Values: [SGO-0001: Cemento] , [SGO-0002: Arena de Peña] , [SGO-0003: Arena de Rio] , ...11 more... )
• CANT_7 ( type: esriFieldTypeDouble, alias: Cantidad: )
• UNIDAD_3 ( type: esriFieldTypeString, alias: Unidad:, length: 8 , Coded Values: [SGO-Un: un.] , [SGO-m: m.] , [SGO-Pg: Pulg.] , ...6 more... )
• MATE_5 ( type: esriFieldTypeString, alias: Material 05:, length: 15 , Coded Values: [SGO-0001: Cemento] , [SGO-0002: Arena de Peña] , [SGO-0003: Arena de Rio] , ...11 more... )
• CANT_8 ( type: esriFieldTypeDouble, alias: Cantidad: )
• UNIDAD_4 ( type: esriFieldTypeString, alias: Unidad:, length: 8 , Coded Values: [SGO-Un: un.] , [SGO-m: m.] , [SGO-Pg: Pulg.] , ...6 more... )
• MATE_6 ( type: esriFieldTypeString, alias: Material 06:, length: 15 , Coded Values: [SGO-0001: Cemento] , [SGO-0002: Arena de Peña] , [SGO-0003: Arena de Rio] , ...11 more... )
• CANT_9 ( type: esriFieldTypeDouble, alias: Cantidad: )
• UNIDAD_5 ( type: esriFieldTypeString, alias: Unidad:, length: 8 , Coded Values: [SGO-Un: un.] , [SGO-m: m.] , [SGO-Pg: Pulg.] , ...6 more... )
• MATE_7 ( type: esriFieldTypeString, alias: Material 07:, length: 15 , Coded Values: [SGO-0001: Cemento] , [SGO-0002: Arena de Peña] , [SGO-0003: Arena de Rio] , ...11 more... )
• UNIDAD_6 ( type: esriFieldTypeString, alias: Unidad:, length: 8 , Coded Values: [SGO-Un: un.] , [SGO-m: m.] , [SGO-Pg: Pulg.] , ...6 more... )
• CANT_10 ( type: esriFieldTypeDouble, alias: Cantidad: )
• TR_PEND ( type: esriFieldTypeString, alias: ¿Trab. Pendiente?:, length: 8 , Coded Values: [SGO-S: SI] , [SGO-N: NO] )
• PENDIENT_1 ( type: esriFieldTypeString, alias: T. Pendiente 01:, length: 15 , Coded Values: [ALCOTROS-0010: Inspección] , [SGO-0001: Atención Otro Equipo] , [SGO-9999: Otro, ¿Cuál?] , ...1 more... )
• OTR_PEND ( type: esriFieldTypeString, alias: Otra, ¿Cuál?:, length: 50 )
• CAUSA_1 ( type: esriFieldTypeString, alias: Causa 01:, length: 15 , Coded Values: [ALCAUSA-0005: Obstrucción por grasas] , [ALCAUSA-0010: Obstrucción por raíces] , [ALCAUSA-0015: Obstrucción por arenas - rocas] , ...17 more... )
• CAUSA_2 ( type: esriFieldTypeString, alias: Causa 02:, length: 15 , Coded Values: [ALCAUSA-0005: Obstrucción por grasas] , [ALCAUSA-0010: Obstrucción por raíces] , [ALCAUSA-0015: Obstrucción por arenas - rocas] , ...17 more... )
• CAUSA_3 ( type: esriFieldTypeString, alias: Causa 03:, length: 15 , Coded Values: [ALCAUSA-0005: Obstrucción por grasas] , [ALCAUSA-0010: Obstrucción por raíces] , [ALCAUSA-0015: Obstrucción por arenas - rocas] , ...17 more... )
• CAUSA_4 ( type: esriFieldTypeString, alias: Causa 04:, length: 15 , Coded Values: [ALCAUSA-0005: Obstrucción por grasas] , [ALCAUSA-0010: Obstrucción por raíces] , [ALCAUSA-0015: Obstrucción por arenas - rocas] , ...17 more... )
• OTR_CAU ( type: esriFieldTypeString, alias: Otra, ¿Cuál?:, length: 50 )
• CONSE_1 ( type: esriFieldTypeString, alias: Consecuencia 01:, length: 15 , Coded Values: [ALCSINTO-0005: Inundaciones en la vía] , [ALCSINTO-0010: Devolución de aguas - Reflujo] , [ALCSINTO-0015: Filtraciones a predios] , ...8 more... )
• CONSE_2 ( type: esriFieldTypeString, alias: Consecuencia 02:, length: 15 , Coded Values: [ALCSINTO-0005: Inundaciones en la vía] , [ALCSINTO-0010: Devolución de aguas - Reflujo] , [ALCSINTO-0015: Filtraciones a predios] , ...8 more... )
• CONSE_3 ( type: esriFieldTypeString, alias: Consecuencia 03:, length: 15 , Coded Values: [ALCSINTO-0005: Inundaciones en la vía] , [ALCSINTO-0010: Devolución de aguas - Reflujo] , [ALCSINTO-0015: Filtraciones a predios] , ...8 more... )
• OTR_CON ( type: esriFieldTypeString, alias: Otra, ¿Cuál?:, length: 50 )
• F_FIN ( type: esriFieldTypeDate, alias: Fecha/Hora Fin:, length: 8 )
• OBSERV_REC_1 ( type: esriFieldTypeString, alias: Observaciones:, length: 400 )
• OBSERV_REC_2 ( type: esriFieldTypeString, alias: Observaciones:, length: 400 )
• VBO_INSPEC ( type: esriFieldTypeString, alias: Vbo. Inspector:, length: 8 , Coded Values: [SGO-S: SI] , [SGO-N: NO] )
• OBSERV_INSPEC ( type: esriFieldTypeString, alias: Observaciones Inspector:, length: 400 )
• NOM_ING ( type: esriFieldTypeString, alias: Nombre del Ingeniero:, length: 10 , Coded Values: [37000837: Joaquin Vasquez Rubiano] , [37000990: Juan Edilberto Diaz Martinez] )
• VBO_ING ( type: esriFieldTypeString, alias: Vbo. Ingeniero, length: 50 , Coded Values: [SGO-S: SI] , [SGO-N: NO] )
• OBSERV_ING ( type: esriFieldTypeString, alias: Observaciones del Ingeniero:, length: 400 )
• FIRMA_USUARIO ( type: esriFieldTypeString, alias: Usuario/Testigo:, length: 10 , Coded Values: [USR-FIRMA: El Usuario Firma] , [USR-NFIRM: El Usuario No Firma] , [USR-NDISP: No Disponible] , ...1 more... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• PLACA_VEHI ( type: esriFieldTypeString, alias: Placa vehículo:, length: 10 , Coded Values: [ODT073: ODT073] , [OKZ985: OKZ985] , [OBG367: OBG367] , ...22 more... )
• COM_STATUS ( type: esriFieldTypeString, alias: Estado Aviso Comisión:, length: 5 , Coded Values: [METRA: Aviso en tratamiento Comision] , [MECON: Aviso Concluido Comisión] )
• SGO_STATUS ( type: esriFieldTypeString, alias: Estado Envío SAP:, length: 5 , Coded Values: [MESGO: Pendiente Enviar a SAP] , [MESAP: Enviado a SAP] )
Relationships:
• C_Z2_ALC_VERIF (1) -- Related To: Boletín de Verificación Alcantarillado Z2 (0)

Table: SGO.Z2_ALC_CT_LIMSON (2)

Name: SGO.Z2_ALC_CT_LIMSON

Display Field: ORDEN

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ORDEN ( type: esriFieldTypeString, alias: No. Orden:, length: 25 )
• SIMBOLO ( type: esriFieldTypeString, alias: Simbolo:, length: 8 , Coded Values: [DZ2-L25: L025] , [DZ2-L29: L029] , [DZ2-L34: L034] , ...9 more... )
• AVISO ( type: esriFieldTypeString, alias: No. Aviso:, length: 10 )
• F_INI ( type: esriFieldTypeDate, alias: Fecha/Hora Inico:, length: 8 )
• AV_HIST ( type: esriFieldTypeString, alias: Avis. con Historia:, length: 6 , Coded Values: [SGO-S: SI] , [SGO-N: NO] )
• TRAB_SOL_LIM ( type: esriFieldTypeString, alias: Trab. Solicitado Limpieza:, length: 15 , Coded Values: [ALCALIMP-AL00: Tubería SANITARIO para limpiar] , [ALCALIMP-AL01: Tubería COMBINADO para limpiar] , [ALCALIMP-AL02: Tubería PLUVIAL para limpiar] , ...11 more... )
• TRAB_SOL_SON ( type: esriFieldTypeString, alias: Trab. Solicitado Sondeo:, length: 15 , Coded Values: [ALCASOND-AS01: Domiciliaria para sondear] , [ALCASOND-AR06: Tubería PLUVIAL sondear] , [ALCASOND-AS04: Tubería SANITARIO sondear] , ...3 more... )
• TRAB_SOL_OTR ( type: esriFieldTypeString, alias: Trab. Solicitado Otros:, length: 15 , Coded Values: [ALCOTROS-0010: Inspeccionar sistema alcantarillado] , [ALCOTROS-0015: Filtracion aguas residuales por atender] , [ALCOTROS-0025: Inundación por atender] , ...6 more... )
• TIPO_TRAB ( type: esriFieldTypeString, alias: Tipo:, length: 3 , Coded Values: [D1: Preventivo] , [D2: Correctivo] , [NO: Ninguno] )
• PRIORIDAD ( type: esriFieldTypeString, alias: Prioridad:, length: 6 , Coded Values: [SGO-A: Alta] , [SGO-M: Media] , [SGO-B: Baja] )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector:, length: 10 , Coded Values: [37001663: Juan Fernando Moreno Riveros] , [37002564: Oscar Enrique Fajardo Rodriguez] , [37000487: Carlos Guillermo Gonzalez Rivera] )
• OTR_INSPEC ( type: esriFieldTypeString, alias: Otro Inspector ¿Cuál?:, length: 100 )
• OPERADOR ( type: esriFieldTypeString, alias: Operador:, length: 10 , Coded Values: [37001668: Alvaro Rueda] , [37035861: Aristides Hernandez] , [37002561: Carlos A Reinozo] , ...13 more... )
• OTR_OPER ( type: esriFieldTypeString, alias: Otro Operador ¿Cuál?:, length: 100 )
• AYUDANTE_1 ( type: esriFieldTypeString, alias: Ayudante 01:, length: 10 , Coded Values: [37035297: Brian Riaño] , [37035687: Camilo Moncada] , [38000620: Carlos Caro] , ...49 more... )
• AYUDANTE_2 ( type: esriFieldTypeString, alias: Ayudante 02:, length: 10 , Coded Values: [37035297: Brian Riaño] , [37035687: Camilo Moncada] , [38000620: Carlos Caro] , ...49 more... )
• AYUDANTE_3 ( type: esriFieldTypeString, alias: Ayudante 03:, length: 10 , Coded Values: [37035297: Brian Riaño] , [37035687: Camilo Moncada] , [38000620: Carlos Caro] , ...49 more... )
• AYUDANTE_4 ( type: esriFieldTypeString, alias: Ayudante 04:, length: 10 , Coded Values: [37035297: Brian Riaño] , [37035687: Camilo Moncada] , [38000620: Carlos Caro] , ...49 more... )
• OTR_AYUD ( type: esriFieldTypeString, alias: Otro Ayudante ¿Cuál?:, length: 100 )
• KM_INI ( type: esriFieldTypeDouble, alias: KM Inicio: )
• KM_FIN ( type: esriFieldTypeDouble, alias: KM Fin: )
• EQUIPO_1 ( type: esriFieldTypeString, alias: Equipo 1:, length: 10 , Coded Values: [32310E29: Presión] , [32310E27: Varilla] , [32310E24: Cabrestante] , ...4 more... )
• EQUIPO_2 ( type: esriFieldTypeString, alias: Equipo 2:, length: 10 , Coded Values: [32310E29: Presión] , [32310E27: Varilla] , [32310E24: Cabrestante] , ...4 more... )
• EQUIPO_3 ( type: esriFieldTypeString, alias: Equipo 3:, length: 10 , Coded Values: [32310E29: Presión] , [32310E27: Varilla] , [32310E24: Cabrestante] , ...4 more... )
• EQUIPO_4 ( type: esriFieldTypeString, alias: Equipo 4:, length: 10 , Coded Values: [32310E29: Presión] , [32310E27: Varilla] , [32310E24: Cabrestante] , ...4 more... )
• SONDEO_1 ( type: esriFieldTypeString, alias: Sondeo 01:, length: 15 , Coded Values: [ALCASOND-AS04: Tubería SANITARIO Sondeada] , [ALCASOND-AS06: Tubería PLUVIAL Sandeada] , [ALCASOND-AS05: Tubería COMBINADO Sondeada] , ...3 more... )
• LONG_1 ( type: esriFieldTypeDouble, alias: Long. m: )
• DIAM_1D ( type: esriFieldTypeDouble, alias: Diametro Pulg.: )
• MATERIAL_1 ( type: esriFieldTypeString, alias: Material:, length: 2 , Coded Values: [0: Concreto] , [1: Gres] , [2: Ladrillo] , ...9 more... )
• SONDEO_2 ( type: esriFieldTypeString, alias: Sondeo 02:, length: 15 , Coded Values: [ALCASOND-AS04: Tubería SANITARIO Sondeada] , [ALCASOND-AS06: Tubería PLUVIAL Sandeada] , [ALCASOND-AS05: Tubería COMBINADO Sondeada] , ...3 more... )
• LONG_2 ( type: esriFieldTypeDouble, alias: Long. m: )
• DIAM_2 ( type: esriFieldTypeDouble, alias: Diametro Pulg.: )
• MATERIAL_M2 ( type: esriFieldTypeString, alias: Material:, length: 2 , Coded Values: [0: Concreto] , [1: Gres] , [2: Ladrillo] , ...9 more... )
• SONDEO_3 ( type: esriFieldTypeString, alias: Sondeo 03:, length: 15 , Coded Values: [ALCASOND-AS04: Tubería SANITARIO Sondeada] , [ALCASOND-AS06: Tubería PLUVIAL Sandeada] , [ALCASOND-AS05: Tubería COMBINADO Sondeada] , ...3 more... )
• LONG_3 ( type: esriFieldTypeDouble, alias: Long. m: )
• DAIM_3 ( type: esriFieldTypeDouble, alias: Diametro Pulg.: )
• MATERIAL_M_3 ( type: esriFieldTypeString, alias: Material:, length: 2 , Coded Values: [0: Concreto] , [1: Gres] , [2: Ladrillo] , ...9 more... )
• LIMP_TUB ( type: esriFieldTypeString, alias: Limp. Tuberia:, length: 8 , Coded Values: [SGO-S: SI] , [SGO-N: NO] )
• LONG_M_4 ( type: esriFieldTypeDouble, alias: Long. m: )
• DIAM_4 ( type: esriFieldTypeDouble, alias: Diametro Pulg.: )
• MATERIAL_4 ( type: esriFieldTypeString, alias: Material:, length: 2 , Coded Values: [0: Concreto] , [1: Gres] , [2: Ladrillo] , ...9 more... )
• LIMP_2 ( type: esriFieldTypeString, alias: Limpieza 02:, length: 15 , Coded Values: [ALCALIMP-AL00: Tubería SANITARIO limpiada] , [ALCALIMP-AL02: Tubería PLUVIAL limpiada] , [ALCALIMP-AL01: Tubería COMBINADO limpiada] , ...14 more... )
• UNIDAD_1 ( type: esriFieldTypeInteger, alias: Un.: )
• LIMP_3 ( type: esriFieldTypeString, alias: Limpieza 03:, length: 15 , Coded Values: [ALCALIMP-AL00: Tubería SANITARIO limpiada] , [ALCALIMP-AL02: Tubería PLUVIAL limpiada] , [ALCALIMP-AL01: Tubería COMBINADO limpiada] , ...14 more... )
• UNIDAD_2 ( type: esriFieldTypeInteger, alias: Un.: )
• LIMP_4 ( type: esriFieldTypeString, alias: Limpieza 04:, length: 615 , Coded Values: [ALCALIMP-AL00: Tubería SANITARIO limpiada] , [ALCALIMP-AL02: Tubería PLUVIAL limpiada] , [ALCALIMP-AL01: Tubería COMBINADO limpiada] , ...14 more... )
• UNIDAD_3 ( type: esriFieldTypeInteger, alias: Un.: )
• CUAL ( type: esriFieldTypeString, alias: Otra, ¿Cuál Limpieza?:, length: 50 )
• UNIDAD_4 ( type: esriFieldTypeInteger, alias: Un.: )
• OTRO_1 ( type: esriFieldTypeString, alias: Otro 01:, length: 15 , Coded Values: [ALCOTROS-0010: Inundación atendida] , [ALCOTROS-0020: Filtracion aguas residuales atendida] , [ALCOTROS-0035: Rebose Alcant. con afectación Predio] , ...5 more... )
• OTRO_2 ( type: esriFieldTypeString, alias: Otro 02:, length: 15 , Coded Values: [ALCOTROS-0010: Inundación atendida] , [ALCOTROS-0020: Filtracion aguas residuales atendida] , [ALCOTROS-0035: Rebose Alcant. con afectación Predio] , ...5 more... )
• CUAL_OTR ( type: esriFieldTypeString, alias: Otra, ¿Cuál?:, length: 100 )
• VOL_EXT ( type: esriFieldTypeDouble, alias: Vol. Extraido m3: )
• N_VIAJE ( type: esriFieldTypeInteger, alias: No. Viajes Volque: )
• POR_LA ( type: esriFieldTypeString, alias: Por la:, length: 50 )
• HASTA_LA ( type: esriFieldTypeString, alias: Hasta la:, length: 50 )
• DE_LA ( type: esriFieldTypeString, alias: De la:, length: 50 )
• A_LA ( type: esriFieldTypeString, alias: A la:, length: 50 )
• N_TRAMOS ( type: esriFieldTypeInteger, alias: No. Tramos: )
• TRA_PEN ( type: esriFieldTypeString, alias: ¿Trab. Pendiente?:, length: 8 , Coded Values: [SGO-S: SI] , [SGO-N: NO] )
• PEN_ESPUB ( type: esriFieldTypeString, alias: Espacio Publico., length: 20 , Coded Values: [ALCAPUBL-0010: Anden concreto para reconstruir] , [ALCAPUBL-0040: Andén tableta para reconstruir] , [ALCAPUBL-0020: Vía concreto reconstruir] , ...5 more... )
• CAN_EPS ( type: esriFieldTypeDouble, alias: Cantidad m2: )
• OTR_PEN ( type: esriFieldTypeString, alias: Otro Pendiente:, length: 15 , Coded Values: [ALCOTROS-0010: Inspección] , [SGO-0001: Atención Otro Equipo] , [SGO-9999: Otro, ¿Cuál?] , ...1 more... )
• CUAL_P ( type: esriFieldTypeString, alias: Otro, ¿Cuál Pendiente?:, length: 50 )
• CAUSA_1 ( type: esriFieldTypeString, alias: Causa 01:, length: 15 , Coded Values: [ALCAUSA-0005: Obstrucción por grasas] , [ALCAUSA-0010: Obstrucción por raíces] , [ALCAUSA-0015: Obstrucción por arenas - rocas] , ...17 more... )
• CAUSA_2 ( type: esriFieldTypeString, alias: Causa 02:, length: 15 , Coded Values: [ALCAUSA-0005: Obstrucción por grasas] , [ALCAUSA-0010: Obstrucción por raíces] , [ALCAUSA-0015: Obstrucción por arenas - rocas] , ...17 more... )
• CAUSA_3 ( type: esriFieldTypeString, alias: Causa 03:, length: 15 , Coded Values: [ALCAUSA-0005: Obstrucción por grasas] , [ALCAUSA-0010: Obstrucción por raíces] , [ALCAUSA-0015: Obstrucción por arenas - rocas] , ...17 more... )
• CAUSA_4 ( type: esriFieldTypeString, alias: Causa 04:, length: 15 , Coded Values: [ALCAUSA-0005: Obstrucción por grasas] , [ALCAUSA-0010: Obstrucción por raíces] , [ALCAUSA-0015: Obstrucción por arenas - rocas] , ...17 more... )
• CAUSA_5 ( type: esriFieldTypeString, alias: Causa 05:, length: 15 , Coded Values: [ALCAUSA-0005: Obstrucción por grasas] , [ALCAUSA-0010: Obstrucción por raíces] , [ALCAUSA-0015: Obstrucción por arenas - rocas] , ...17 more... )
• CAUSA_6 ( type: esriFieldTypeString, alias: Causa 06:, length: 15 , Coded Values: [ALCAUSA-0005: Obstrucción por grasas] , [ALCAUSA-0010: Obstrucción por raíces] , [ALCAUSA-0015: Obstrucción por arenas - rocas] , ...17 more... )
• CUAL_CA ( type: esriFieldTypeString, alias: Otra, ¿Cuál Causa?:, length: 50 )
• CONSEC_1 ( type: esriFieldTypeString, alias: Consecuencia 01:, length: 15 , Coded Values: [ALCSINTO-0005: Inundaciones en la vía] , [ALCSINTO-0010: Devolución de aguas - Reflujo] , [ALCSINTO-0015: Filtraciones a predios] , ...8 more... )
• CONSEC_2 ( type: esriFieldTypeString, alias: Consecuencia 02:, length: 15 , Coded Values: [ALCSINTO-0005: Inundaciones en la vía] , [ALCSINTO-0010: Devolución de aguas - Reflujo] , [ALCSINTO-0015: Filtraciones a predios] , ...8 more... )
• CONSEC_3 ( type: esriFieldTypeString, alias: Consecuencia 03:, length: 15 , Coded Values: [ALCSINTO-0005: Inundaciones en la vía] , [ALCSINTO-0010: Devolución de aguas - Reflujo] , [ALCSINTO-0015: Filtraciones a predios] , ...8 more... )
• CUAL_CO ( type: esriFieldTypeString, alias: Otra, ¿Cuál Consecuencia?:, length: 50 )
• F_FIN ( type: esriFieldTypeDate, alias: Fecha/Hora Fin:, length: 8 )
• OBSERV_LIM_1 ( type: esriFieldTypeString, alias: Observaciones:, length: 400 )
• OBSERV_LIM_2 ( type: esriFieldTypeString, alias: Observaciones:, length: 400 )
• VBO_INSPEC ( type: esriFieldTypeString, alias: Vbo. Inspector:, length: 8 , Coded Values: [SGO-S: SI] , [SGO-N: NO] )
• OBSER_INSPEC ( type: esriFieldTypeString, alias: Observaciones Inspector:, length: 400 )
• NOM_ING ( type: esriFieldTypeString, alias: Nombre del Ingeniero:, length: 250 , Coded Values: [37000837: Joaquin Vasquez Rubiano] , [37000990: Juan Edilberto Diaz Martinez] )
• VBO_ING ( type: esriFieldTypeString, alias: Vbo. Ingeniero:, length: 8 , Coded Values: [SGO-S: SI] , [SGO-N: NO] )
• OBSER_ING ( type: esriFieldTypeString, alias: Observaciones Ingeniero:, length: 400 )
• FIRMA_USUARIO ( type: esriFieldTypeString, alias: Usuario/Testigo:, length: 10 , Coded Values: [USR-FIRMA: El Usuario Firma] , [USR-NFIRM: El Usuario No Firma] , [USR-NDISP: No Disponible] , ...1 more... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• PLACA_VEHI ( type: esriFieldTypeString, alias: Placa vehículo:, length: 10 , Coded Values: [ODT073: ODT073] , [OKZ985: OKZ985] , [OBG367: OBG367] , ...22 more... )
• COM_STATUS ( type: esriFieldTypeString, alias: Estado Aviso Comisión:, length: 5 , Coded Values: [METRA: Aviso en tratamiento Comision] , [MECON: Aviso Concluido Comisión] )
• SGO_STATUS ( type: esriFieldTypeString, alias: Estado Envío SAP:, length: 5 , Coded Values: [MESGO: Pendiente Enviar a SAP] , [MESAP: Enviado a SAP] )
Relationships:
• C_Z2_ALC_VERIF (2) -- Related To: Boletín de Verificación Alcantarillado Z2 (0)

Table: SGO.Z2_ALC_CT_APYMAQ (3)

Name: SGO.Z2_ALC_CT_APYMAQ

Display Field: AVISO

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• AVISO ( type: esriFieldTypeString, alias: N° Aviso:, length: 10 )
• ORDEN ( type: esriFieldTypeString, alias: Orden:, length: 12 )
• FECHA ( type: esriFieldTypeDate, alias: Fecha:, length: 8 )
• SIMBOLO ( type: esriFieldTypeString, alias: Simbolo:, length: 10 , Coded Values: [DZ2-C95: C95] , [DZ2-F26: F26] , [DZ2-MC24: MC24] , ...13 more... )
• PLACA ( type: esriFieldTypeString, alias: Pláca vehículo:, length: 7 , Coded Values: [ODT073: ODT073] , [OKZ985: OKZ985] , [OBG367: OBG367] , ...22 more... )
• HORA_INI ( type: esriFieldTypeDate, alias: Tiempo inicial:, length: 8 )
• KM_INI ( type: esriFieldTypeInteger, alias: Km inicio: )
• T_MAQ_EQUI ( type: esriFieldTypeString, alias: Tipo maquinaria y equipo de apoy:, length: 10 , Coded Values: [32310E25: Bulldozer] , [32310E12-1: Retro Llanta] , [32310E14: Paladraga] , ...10 more... )
• DIRECC ( type: esriFieldTypeString, alias: Dirección:, length: 80 )
• BARRIO ( type: esriFieldTypeString, alias: Barrio:, length: 50 )
• LOCALIDAD ( type: esriFieldTypeString, alias: Localidad:, length: 3 , Coded Values: [01: USAQUEN] , [02: CHAPINERO] , [03: SANTA FE] , ...7 more... )
• MUNICIPIO ( type: esriFieldTypeString, alias: Municipio:, length: 6 , Coded Values: [11001: BOGOTÁ, D.C.] , [25754: SOACHA] , [25175: CHÍA] , ...3 more... )
• MATERIAL ( type: esriFieldTypeString, alias: Material transportado:, length: 15 , Coded Values: [SGO-0001: Cemento] , [SGO-0002: Arena de Peña] , [SGO-0003: Arena de Rio] , ...11 more... )
• VOL_TTAL ( type: esriFieldTypeDouble, alias: Volumen Total (m³): )
• ACTIVIDAD_1 ( type: esriFieldTypeString, alias: Actividad desarrollada 1:, length: 8 , Coded Values: [APY-01-1: Apoyo a otra zona (Operador)] , [APY-01-2: Apoyo a otra zona (Maquinaria)] , [APY-02: Transporte de material] , ...6 more... )
• OTR_ACTIVIDA ( type: esriFieldTypeString, alias: Otra Actividad:, length: 50 , Coded Values: [APYO-01: Escolta maquinaria] , [APYO-02: Visita a plantas] , [APYO-03: Tanqueos] , ...9 more... )
• OBSERV ( type: esriFieldTypeString, alias: Observaciones:, length: 800 )
• HORA_FIN ( type: esriFieldTypeDate, alias: Hora fin:, length: 8 )
• T_TTAL ( type: esriFieldTypeDouble, alias: Tiempo total: )
• KM_FIN ( type: esriFieldTypeInteger, alias: Km fin: )
• OPERADOR ( type: esriFieldTypeString, alias: Operador/Conductor:, length: 10 , Coded Values: [37002561: Carlos Arturo Reinozo] , [37003464: Carlos A Garzon Diaz] , [37001468: Carlos A Robayo E] , ...14 more... )
• AYUDANTE_1 ( type: esriFieldTypeString, alias: Ayudante 1:, length: 10 , Coded Values: [37035297: Brian Riaño] , [37035687: Camilo Moncada] , [38000620: Carlos Caro] , ...49 more... )
• AYUDANTE_2 ( type: esriFieldTypeString, alias: Ayudante 2:, length: 10 , Coded Values: [37035297: Brian Riaño] , [37035687: Camilo Moncada] , [38000620: Carlos Caro] , ...49 more... )
• AYUDANTE_3 ( type: esriFieldTypeString, alias: Ayudante 3:, length: 10 , Coded Values: [37035297: Brian Riaño] , [37035687: Camilo Moncada] , [38000620: Carlos Caro] , ...49 more... )
• OTR_AYUD ( type: esriFieldTypeString, alias: OTR_AYUD, length: 50 )
• INSPEC ( type: esriFieldTypeString, alias: Inspector:, length: 10 , Coded Values: [37001663: Juan Fernando Moreno Riveros] , [37002564: Oscar Enrique Fajardo Rodriguez] , [37000487: Carlos Guillermo Gonzalez Rivera] )
• INGEN ( type: esriFieldTypeString, alias: Ingeniero:, length: 10 , Coded Values: [37000837: Joaquin Vasquez Rubiano] , [37000990: Juan Edilberto Diaz Martinez] )
• ACTIVIDAD_2 ( type: esriFieldTypeString, alias: Actividad desarrollada 2:, length: 8 , Coded Values: [APY-01-1: Apoyo a otra zona (Operador)] , [APY-01-2: Apoyo a otra zona (Maquinaria)] , [APY-02: Transporte de material] , ...6 more... )
• ACTIVIDAD_3 ( type: esriFieldTypeString, alias: Actividad desarrollada 3:, length: 8 , Coded Values: [APY-01-1: Apoyo a otra zona (Operador)] , [APY-01-2: Apoyo a otra zona (Maquinaria)] , [APY-02: Transporte de material] , ...6 more... )
• T_MAQ_EQUI_2 ( type: esriFieldTypeString, alias: Tipo maquinaria y equipo de apoy 2:, length: 10 , Coded Values: [32310E25: Bulldozer] , [32310E12-1: Retro Llanta] , [32310E14: Paladraga] , ...10 more... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• VBO_INSPEC ( type: esriFieldTypeString, alias: Vbo. Inspector:, length: 8 , Coded Values: [SGO-S: SI] , [SGO-N: NO] )
• COM_STATUS ( type: esriFieldTypeString, alias: Estado Aviso Comisión:, length: 5 , Coded Values: [METRA: Aviso en tratamiento Comision] , [MECON: Aviso Concluido Comisión] )
• SGO_STATUS ( type: esriFieldTypeString, alias: Estado Envío SAP:, length: 5 , Coded Values: [MESGO: Pendiente Enviar a SAP] , [MESAP: Enviado a SAP] )
Relationships:
• C_Z2_ALC_VERIF (0) -- Related To: Boletín de Verificación Alcantarillado Z2 (0)