← All datasets
# curated.transit_rail_line
METRORail lines (16 rows; category: Transit & bikes; geometry column `geom` (MultiLineString, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 16/16 | e.g.: 13; 2; 4
- attrs->>'CFCC' | string | 16/1 | values: A08
- attrs->>'created_date' | number | 16/1 | values: 1680258717000
- attrs->>'created_user' | string | 16/1 | values: rg96_METRO_Houston
- attrs->>'EDIT_DATE' | number | 16/4 | values: 1351468800000; 1365897600000; 1367366400000; 1345420800000
- attrs->>'EditType' | string | 16/2 | values: NEW; MERGE
- attrs->>'last_edited_date' | number | 16/1 | values: 1680258717000
- attrs->>'last_edited_user' | string | 16/1 | values: rg96_METRO_Houston
- attrs->>'LineColor' | string | 16/3 | values: Red; Purple; Green
- attrs->>'NAME' | string | 16/4 | values: Southeast; Main - Fannin; East End; North
- attrs->>'Override' | string | 16/5 | values: ; AQAAABAAAAAAAAAAGAAAAAAAAAAAAAAAEHJwMNVS0BGo8gBgjIXt5QIA8AIA; AQAAABAAAAAAAAAAGAAAAAAAAAAAAAAAEHJwMNVS0BGo8gBgjIXt5QIAEAEA; AQAAABAAAAAAAAAAGAAAAAAAAAAAAAAAEHJwMNVS0BGo8gBgjIXt5QIAYAAA; AQAAABAAAAAAAAAAGAAAAAAAAAAAAAAAEHJwMNVS0BGo8gBgjIXt5QIAIAMA
- attrs->>'RuleID' | number | 16/4 | values: 1; 3; 4; 2
- attrs->>'Status' | string | 16/2 | values: Construction; Operational
- attrs->>'TYPE' | string | 16/1 | values: RAIL
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.