units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where DES_TP = 512, LABEL_NAME = "Great Shasta Rail Trail" and MNG_AGENCY = 733

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • McCloud River Railroad Company · 1 ✖

DES_TP 1

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
6348 6348 6347 {"type": "Polygon", "coordinates": [[[-121.64234, 40.90249], [-121.64234, 40.90302], [-121.64222, 40.9032], [-121.64211, 40.90343], [-121.64205, 40.90359], [-121.642, 40.90384], [-121.6419, 40.90495], [-121.64126, 40.91384], [-121.64039, 40.92841], [-121.63919, 40.94285], [-121.63818, 40.95738], [-121.63789, 40.9619], [-121.63785, 40.96211], [-121.63777, 40.96232], [-121.63766, 40.96253], [-121.63751, 40.96271], [-121.63734, 40.96289], [-121.63713, 40.96304], [-121.6369, 40.96317], [-121.63665, 40.96328], [-121.63639, 40.96336], [-121.63126, 40.96458], [-121.62637, 40.96562], [-121.62295, 40.96631], [-121.62263, 40.9664], [-121.62232, 40.96651], [-121.62203, 40.96665], [-121.62176, 40.96681], [-121.62151, 40.96699], [-121.62119, 40.96729], [-121.62101, 40.96751], [-121.62087, 40.96775], [-121.62075, 40.96799], [-121.62062, 40.9684], [-121.62048, 40.96866], [-121.62031, 40.9689], [-121.62, 40.96925], [-121.61975, 40.96945], [-121.61948, 40.96964], [-121.61908, 40.96985], [-121.61037, 40.9739], [-121.61011, 40.97404], [-121.60977, 40.9743], [-121.60958, 40.9745], [-121.60934, 40.97482], [-121.60918, 40.97517], [-121.60911, 40.97541], [-121.60908, 40.97565], [-121.6091, 40.97602], [-121.6092, 40.97638], [-121.60931, 40.97661], [-121.61156, 40.97944], [-121.61184, 40.97985], [-121.61204, 40.98028], [-121.61217, 40.98073], [-121.61222, 40.98119], [-121.61219, 40.98166], [-121.61208, 40.98211], [-121.61188, 40.98257], [-121.61081, 40.98616], [-121.60833, 40.99341], [-121.60466, 41.00428], [-121.60456, 41.00452], [-121.60452, 41.00472], [-121.60451, 41.00493], [-121.60454, 41.00514], [-121.60461, 41.00534], [-121.60471, 41.00553], [-121.60484, 41.00571], [-121.605, 41.00587], [-121.6052, 41.00602], [-121.60541, 41.00615], [-121.60565, 41.00625], [-121.60603, 41.00636], [-121.60644, 41.0064], [-121.60668, 41.00638], [-121.60718, 41.00628], [-121.60748, 41.00623], [-121.60778, 41.00622], [-121.60808, 41.00624], [-121.60837, 41.00628], [-121.60866, 41.00635], [-121.60893, 41.00644], [-121.60931, 41.00663], [-121.60953, 41.00679], [-121.60981, 41.00705], [-121.60996, 41.00725], [-121.61012, 41.00757], [-121.61018, 41.00779], [-121.61021, 41.00802], [-121.60983, 41.00801], [-121.6098, 41.0078], [-121.60974, 41.00759], [-121.60964, 41.0074], [-121.6095, 41.00722], [-121.60934, 41.00705], [-121.60914, 41.0069], [-121.60892, 41.00677], [-121.60868, 41.00667], [-121.60829, 41.00657], [-121.60788, 41.00652], [-121.60747, 41.00655], [-121.60695, 41.00665], [-121.60669, 41.00668], [-121.60614, 41.00667], [-121.60585, 41.00662], [-121.60558, 41.00655], [-121.60532, 41.00646], [-121.60507, 41.00634], [-121.60485, 41.0062], [-121.60465, 41.00604], [-121.6044, 41.00576], [-121.60428, 41.00557], [-121.60418, 41.00536], [-121.60413, 41.00514], [-121.6041, 41.00492], [-121.60412, 41.0047], [-121.60417, 41.00448], [-121.60425, 41.00427], [-121.60545, 41.0007], [-121.61034, 40.98615], [-121.61144, 40.98256], [-121.61163, 40.98211], [-121.61172, 40.98166], [-121.61175, 40.9812], [-121.61169, 40.98074], [-121.61156, 40.98029], [-121.61137, 40.97988], [-121.61121, 40.97961], [-121.60896, 40.97672], [-121.60883, 40.97647], [-121.60875, 40.97622], [-121.60869, 40.97597], [-121.60868, 40.97558], [-121.60872, 40.97532], [-121.60879, 40.97506], [-121.60896, 40.9747], [-121.60921, 40.97435], [-121.60952, 40.97404], [-121.60976, 40.97386], [-121.61017, 40.97362], [-121.61884, 40.9696], [-121.61909, 40.96947], [-121.61933, 40.96932], [-121.61968, 40.96905], [-121.61988, 40.96885], [-121.62006, 40.96863], [-121.62026, 40.96828], [-121.62039, 40.96792], [-121.62051, 40.96766], [-121.62067, 40.96741], [-121.62086, 40.96718], [-121.62108, 40.96696], [-121.62145, 40.96666], [-121.62173, 40.96649], [-121.62204, 40.96634], [-121.62252, 40.96616], [-121.62286, 40.96607], [-121.63126, 40.96431], [-121.63632, 40.96311], [-121.63667, 40.96297], [-121.63688, 40.96285], [-121.63707, 40.96271], [-121.63729, 40.96247], [-121.6374, 40.96229], [-121.63748, 40.9621], [-121.63752, 40.9619], [-121.63883, 40.94286], [-121.64003, 40.92841], [-121.6409, 40.91383], [-121.64155, 40.9053], [-121.64163, 40.90404], [-121.64165, 40.90381], [-121.6417, 40.90356], [-121.6418, 40.90327], [-121.64193, 40.90302], [-121.64204, 40.90286], [-121.64234, 40.90249]]]} Open Access 1 48358 Great Shasta Rail Trail 32924 7027 McCloud River Railroad Company 747 Private 7 Commercial 20   Private 14 7027 McCloud River Railroad Company 733 Private 7 Commercial 18 https://www.greatshastarailtrail.org/ Shasta 27 107.596 Great Shasta Rail Trail 2015 None 512  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]),
   FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]),
   FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]),
   FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]),
   FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);