units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 533 and UNIT_NAME = "Miner's Ravine Trail"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3638 | 3638 | 3637 | {"type": "Polygon", "coordinates": [[[-121.26288, 38.75472], [-121.26165, 38.75576], [-121.26024, 38.75636], [-121.2599, 38.75658], [-121.25957, 38.75693], [-121.25942, 38.7572], [-121.25928, 38.75719], [-121.25913, 38.75715], [-121.25811, 38.75675], [-121.2583, 38.75636], [-121.25846, 38.75613], [-121.25865, 38.75607], [-121.25897, 38.75611], [-121.25927, 38.75602], [-121.25879, 38.75582], [-121.25853, 38.75577], [-121.25864, 38.75568], [-121.25905, 38.75576], [-121.2594, 38.75588], [-121.25963, 38.7556], [-121.2597, 38.75563], [-121.25996, 38.75532], [-121.26004, 38.75535], [-121.2604, 38.75492], [-121.26036, 38.75477], [-121.26023, 38.7547], [-121.26041, 38.75449], [-121.26063, 38.75445], [-121.26067, 38.75462], [-121.26083, 38.75481], [-121.2612, 38.75475], [-121.26116, 38.75458], [-121.26112, 38.75458], [-121.26108, 38.75438], [-121.26112, 38.75435], [-121.26136, 38.75427], [-121.26158, 38.75423], [-121.26148, 38.75381], [-121.26193, 38.75408], [-121.2621, 38.75415], [-121.26238, 38.75435], [-121.2627, 38.75464], [-121.26288, 38.75472]], [[-121.26236, 38.75516], [-121.26236, 38.75514], [-121.26206, 38.75493], [-121.26189, 38.75488], [-121.26133, 38.75524], [-121.26147, 38.75549], [-121.26154, 38.75545], [-121.26208, 38.75534], [-121.26236, 38.75516]]]} | Open Access 1 | 29478 | Miner's Ravine Trail | 22260 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 12.44 | Miner's Ravine Trail | 0 | Local Recreation Area 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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]);