Tables:

Table: transmisig2.dwh.lg_cns_matriz_distancia (0)

Name: transmisig2.dwh.lg_cns_matriz_distancia

Display Field: fecha

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 500000

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: esriFieldTypeInteger, alias: objectid, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• fecha ( type: esriFieldTypeDate, alias: fecha, editable: true, nullable: true, length: 8, defaultValue: null, modelName: fecha )
• ruta ( type: esriFieldTypeDouble, alias: ruta, editable: true, nullable: true, defaultValue: null, modelName: ruta )
• seccion_id ( type: esriFieldTypeDouble, alias: seccion_id, editable: true, nullable: true, defaultValue: null, modelName: seccion_id )
• direction ( type: esriFieldTypeString, alias: direction, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: direction )
• nombre_ruta ( type: esriFieldTypeString, alias: nombre_ruta, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: nombre_ruta )
• tipo_servicio ( type: esriFieldTypeString, alias: tipo_servicio, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: tipo_servicio )
• lineid ( type: esriFieldTypeDouble, alias: lineid, editable: true, nullable: true, defaultValue: null, modelName: lineid )
• line ( type: esriFieldTypeString, alias: line, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: line )
• activeconfig ( type: esriFieldTypeString, alias: activeconfig, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: activeconfig )
• ruta_extraida ( type: esriFieldTypeString, alias: ruta_extraida, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: ruta_extraida )
• destino_limpio ( type: esriFieldTypeString, alias: destino_limpio, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: destino_limpio )
• destino ( type: esriFieldTypeString, alias: destino, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: destino )
• posicion ( type: esriFieldTypeDouble, alias: posicion, editable: true, nullable: true, defaultValue: null, modelName: posicion )
• nodo ( type: esriFieldTypeDouble, alias: nodo, editable: true, nullable: true, defaultValue: null, modelName: nodo )
• nombre_nodo ( type: esriFieldTypeString, alias: nombre_nodo, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: nombre_nodo )
• estacion_parada ( type: esriFieldTypeString, alias: estacion_parada, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: estacion_parada )
• nombre_parada ( type: esriFieldTypeString, alias: nombre_parada, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: nombre_parada )
• longitud ( type: esriFieldTypeDouble, alias: longitud, editable: true, nullable: true, defaultValue: null, modelName: longitud )
• latitud ( type: esriFieldTypeDouble, alias: latitud, editable: true, nullable: true, defaultValue: null, modelName: latitud )
• punto_geofrafico ( type: esriFieldTypeString, alias: punto_geofrafico, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: punto_geofrafico )
• sistema ( type: esriFieldTypeDouble, alias: sistema, editable: true, nullable: true, defaultValue: null, modelName: sistema )
• nombre_sistema ( type: esriFieldTypeString, alias: nombre_sistema, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: nombre_sistema )
• nombre_zona ( type: esriFieldTypeString, alias: nombre_zona, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: nombre_zona )
• color_zona ( type: esriFieldTypeString, alias: color_zona, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: color_zona )
• color_ruta ( type: esriFieldTypeString, alias: color_ruta, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: color_ruta )
• color_texto ( type: esriFieldTypeString, alias: color_texto, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: color_texto )
• direccion ( type: esriFieldTypeString, alias: direccion, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: direccion )
• vagon ( type: esriFieldTypeString, alias: vagon, editable: true, nullable: true, length: 60000, defaultValue: null, modelName: vagon )
• nombre_portal ( type: esriFieldTypeDouble, alias: nombre_portal, editable: true, nullable: true, defaultValue: null, modelName: nombre_portal )
• nodo_padre ( type: esriFieldTypeDouble, alias: nodo_padre, editable: true, nullable: true, defaultValue: null, modelName: nodo_padre )
• section_node_seq ( type: esriFieldTypeDouble, alias: section_node_seq, editable: true, nullable: true, defaultValue: null, modelName: section_node_seq )
Templates:
• Name: transmisig2.dwh.lg_cns_matriz_distancia
  Description:
  Prototype:
  nodo_padre: null
  section_node_seq: null
  fecha: null
  ruta: null
  seccion_id: null
  direction: null
  nombre_ruta: null
  tipo_servicio: null
  lineid: null
  line: null
  activeconfig: null
  ruta_extraida: null
  destino_limpio: null
  destino: null
  posicion: null
  nodo: null
  nombre_nodo: null
  estacion_parada: null
  nombre_parada: null
  longitud: null
  latitud: null
  punto_geofrafico: null
  sistema: null
  nombre_sistema: null
  nombre_zona: null
  color_zona: null
  color_ruta: null
  color_texto: null
  direccion: null
  vagon: null
  nombre_portal: null
  
  Drawing Tool: esriFeatureEditToolNone

Table: transmisig2.dwh.lg_cns_planificacion_rutas (1)

Name: transmisig2.dwh.lg_cns_planificacion_rutas

Display Field: fecha

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 500000

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 )
• fecha ( type: esriFieldTypeDate, alias: fecha, editable: false, nullable: true, length: 8, defaultValue: null, modelName: fecha )
• ruta ( type: esriFieldTypeInteger, alias: ruta, editable: false, nullable: true, defaultValue: null, modelName: ruta )
• servicio ( type: esriFieldTypeInteger, alias: servicio, editable: false, nullable: true, defaultValue: null, modelName: servicio )
• viaje ( type: esriFieldTypeInteger, alias: viaje, editable: false, nullable: true, defaultValue: null, modelName: viaje )
• nodo ( type: esriFieldTypeInteger, alias: nodo, editable: false, nullable: true, defaultValue: null, modelName: nodo )
• hora_teor_segundos ( type: esriFieldTypeInteger, alias: hora_teor_segundos, editable: false, nullable: true, defaultValue: null, modelName: hora_teor_segundos )
• tipo_dia ( type: esriFieldTypeInteger, alias: tipo_dia, editable: false, nullable: true, defaultValue: null, modelName: tipo_dia )
• hora_teor ( type: esriFieldTypeString, alias: hora_teor, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: hora_teor )
• linea ( type: esriFieldTypeInteger, alias: linea, editable: false, nullable: true, defaultValue: null, modelName: linea )
• ruta_extraida ( type: esriFieldTypeString, alias: ruta_extraida, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: ruta_extraida )
• destino_limpio ( type: esriFieldTypeString, alias: destino_limpio, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: destino_limpio )
• estacion_parada ( type: esriFieldTypeString, alias: estacion_parada, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: estacion_parada )
• color_ruta ( type: esriFieldTypeString, alias: color_ruta, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: color_ruta )
• color_texto ( type: esriFieldTypeString, alias: color_texto, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: color_texto )
• nombre_parada ( type: esriFieldTypeString, alias: nombre_parada, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: nombre_parada )
• posicion ( type: esriFieldTypeInteger, alias: posicion, editable: false, nullable: true, defaultValue: null, modelName: posicion )
• direction ( type: esriFieldTypeString, alias: direction, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: direction )
• tipo_servicio ( type: esriFieldTypeString, alias: tipo_servicio, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: tipo_servicio )
Templates:
• Name: transmisig2.dwh.lg_cns_planificacion_rutas
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone

Table: transmisig2.dwh.lg_cns_vehiculo (2)

Name: transmisig2.dwh.lg_cns_vehiculo

Display Field: codigo_sae

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 500000

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 )
• codigo_sae ( type: esriFieldTypeString, alias: codigo_sae, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: codigo_sae )
• codigo ( type: esriFieldTypeString, alias: codigo, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: codigo )
• veh_id_lg ( type: esriFieldTypeDouble, alias: veh_id_lg, editable: false, nullable: true, defaultValue: null, modelName: veh_id_lg )
• codigo_cdeg ( type: esriFieldTypeString, alias: codigo_cdeg, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: codigo_cdeg )
• operador ( type: esriFieldTypeString, alias: operador, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: operador )
• nombre_operador ( type: esriFieldTypeString, alias: nombre_operador, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: nombre_operador )
• operador_provision ( type: esriFieldTypeString, alias: operador_provision, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: operador_provision )
• nombre_operador_provision ( type: esriFieldTypeString, alias: nombre_operador_provision, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: nombre_operador_provision )
• tipo_concesion ( type: esriFieldTypeDouble, alias: tipo_concesion, editable: false, nullable: true, defaultValue: null, modelName: tipo_concesion )
• nombre_tipo_concesion ( type: esriFieldTypeString, alias: nombre_tipo_concesion, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: nombre_tipo_concesion )
• concesion ( type: esriFieldTypeString, alias: concesion, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: concesion )
• nombre_concesion ( type: esriFieldTypeString, alias: nombre_concesion, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: nombre_concesion )
• tipo_servicio ( type: esriFieldTypeString, alias: tipo_servicio, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: tipo_servicio )
• nombre_tipo_servicio ( type: esriFieldTypeString, alias: nombre_tipo_servicio, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: nombre_tipo_servicio )
• estado_vinculacion ( type: esriFieldTypeString, alias: estado_vinculacion, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: estado_vinculacion )
• descripcion_estado_vinculacion ( type: esriFieldTypeString, alias: descripcion_estado_vinculacion, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: descripcion_estado_vinculacion )
• codigo_nivel_emision ( type: esriFieldTypeString, alias: codigo_nivel_emision, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: codigo_nivel_emision )
• nivel_emision ( type: esriFieldTypeString, alias: nivel_emision, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: nivel_emision )
• descripcion_nivel_emision ( type: esriFieldTypeString, alias: descripcion_nivel_emision, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: descripcion_nivel_emision )
• tipo ( type: esriFieldTypeDouble, alias: tipo, editable: false, nullable: true, defaultValue: null, modelName: tipo )
• descripcion_tipo ( type: esriFieldTypeString, alias: descripcion_tipo, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: descripcion_tipo )
• codigo_marca ( type: esriFieldTypeString, alias: codigo_marca, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: codigo_marca )
• marca ( type: esriFieldTypeString, alias: marca, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: marca )
• descripcion_marca ( type: esriFieldTypeString, alias: descripcion_marca, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: descripcion_marca )
• modelo ( type: esriFieldTypeString, alias: modelo, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: modelo )
• matricula ( type: esriFieldTypeString, alias: matricula, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: matricula )
• chasis ( type: esriFieldTypeString, alias: chasis, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: chasis )
• motor ( type: esriFieldTypeString, alias: motor, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: motor )
• vinculacion ( type: esriFieldTypeDate, alias: vinculacion, editable: false, nullable: true, length: 8, defaultValue: null, modelName: vinculacion )
• retiro ( type: esriFieldTypeDate, alias: retiro, editable: false, nullable: true, length: 8, defaultValue: null, modelName: retiro )
• tipo_motivo_retiro ( type: esriFieldTypeString, alias: tipo_motivo_retiro, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: tipo_motivo_retiro )
• descripcion_tipo_motivo_retiro ( type: esriFieldTypeString, alias: descripcion_tipo_motivo_retiro, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: descripcion_tipo_motivo_retiro )
• motivo_retiro ( type: esriFieldTypeString, alias: motivo_retiro, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: motivo_retiro )
• estado ( type: esriFieldTypeDouble, alias: estado, editable: false, nullable: true, defaultValue: null, modelName: estado )
• descripcion_estado ( type: esriFieldTypeString, alias: descripcion_estado, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: descripcion_estado )
• tipo_linea ( type: esriFieldTypeString, alias: tipo_linea, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: tipo_linea )
• descripcion_tipo_linea ( type: esriFieldTypeString, alias: descripcion_tipo_linea, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: descripcion_tipo_linea )
• tipo_combustible ( type: esriFieldTypeString, alias: tipo_combustible, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: tipo_combustible )
• descripcion_tipo_combustible ( type: esriFieldTypeString, alias: descripcion_tipo_combustible, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: descripcion_tipo_combustible )
• tipo_fabricante ( type: esriFieldTypeString, alias: tipo_fabricante, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: tipo_fabricante )
• descripcion_tipo_fabricante ( type: esriFieldTypeString, alias: descripcion_tipo_fabricante, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: descripcion_tipo_fabricante )
• tipo_carroseria ( type: esriFieldTypeString, alias: tipo_carroseria, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: tipo_carroseria )
• descripcion_tipo_carroseria ( type: esriFieldTypeString, alias: descripcion_tipo_carroseria, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: descripcion_tipo_carroseria )
• tipo_acceso ( type: esriFieldTypeString, alias: tipo_acceso, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: tipo_acceso )
• descripcion_tipo_acceso ( type: esriFieldTypeString, alias: descripcion_tipo_acceso, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: descripcion_tipo_acceso )
• tipo_mecanismo_accesibilidad ( type: esriFieldTypeString, alias: tipo_mecanismo_accesibilidad, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: tipo_mecanismo_accesibilidad )
• descripcion_tipo_mecanismo_accesibilidad ( type: esriFieldTypeString, alias: descripcion_tipo_mecanismo_accesibilidad, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: descripcion_tipo_mecanismo_accesibilidad )
• prefrl_seat_num ( type: esriFieldTypeDouble, alias: prefrl_seat_num, editable: false, nullable: true, defaultValue: null, modelName: prefrl_seat_num )
• prefrl_norm_seat_num ( type: esriFieldTypeDouble, alias: prefrl_norm_seat_num, editable: false, nullable: true, defaultValue: null, modelName: prefrl_norm_seat_num )
• tot_capa_num ( type: esriFieldTypeDouble, alias: tot_capa_num, editable: false, nullable: true, defaultValue: null, modelName: tot_capa_num )
• wght_snsr_yn ( type: esriFieldTypeString, alias: wght_snsr_yn, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: wght_snsr_yn )
• dintgrn_datetime ( type: esriFieldTypeDate, alias: dintgrn_datetime, editable: false, nullable: true, length: 8, defaultValue: null, modelName: dintgrn_datetime )
• license_cancel_datetime ( type: esriFieldTypeDate, alias: license_cancel_datetime, editable: false, nullable: true, length: 8, defaultValue: null, modelName: license_cancel_datetime )
• license_cancel_value ( type: esriFieldTypeString, alias: license_cancel_value, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: license_cancel_value )
• license_date ( type: esriFieldTypeDate, alias: license_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: license_date )
• oprtn_card_cancel_value ( type: esriFieldTypeString, alias: oprtn_card_cancel_value, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: oprtn_card_cancel_value )
• motive_sys_type_cd ( type: esriFieldTypeString, alias: motive_sys_type_cd, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: motive_sys_type_cd )
• veh_desc ( type: esriFieldTypeString, alias: veh_desc, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: veh_desc )
• use_yn ( type: esriFieldTypeString, alias: use_yn, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: use_yn )
• veh_immbil_yn ( type: esriFieldTypeString, alias: veh_immbil_yn, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: veh_immbil_yn )
• creat_user_id ( type: esriFieldTypeString, alias: creat_user_id, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: creat_user_id )
• creat_datetime ( type: esriFieldTypeDate, alias: creat_datetime, editable: false, nullable: true, length: 8, defaultValue: null, modelName: creat_datetime )
• upd_user_id ( type: esriFieldTypeString, alias: upd_user_id, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: upd_user_id )
• upd_datetime ( type: esriFieldTypeDate, alias: upd_datetime, editable: false, nullable: true, length: 8, defaultValue: null, modelName: upd_datetime )
• systypecd ( type: esriFieldTypeString, alias: systypecd, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: systypecd )
• oprtrid ( type: esriFieldTypeString, alias: oprtrid, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: oprtrid )
• sistema ( type: esriFieldTypeDouble, alias: sistema, editable: false, nullable: true, defaultValue: null, modelName: sistema )
• accesible ( type: esriFieldTypeString, alias: accesible, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: accesible )
Templates:
• Name: transmisig2.dwh.lg_cns_vehiculo
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone