superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
22 rows where MNG_AGENCY = 663 and MNG_AG_TYP = 10 sorted by LAYER
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- Non Profit - Land Trust · 2 ✖
MNG_AGENCY 1
- Truckee Donner Land Trust · 2 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER ▼ | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12543 | 12543 | 12542 | {"type": "Polygon", "coordinates": [[[-120.28244, 39.40266], [-120.28231, 39.40269], [-120.28233, 39.40632], [-120.27294, 39.40633], [-120.27289, 39.40267], [-120.26831, 39.40265], [-120.26824, 39.3989], [-120.2589, 39.39888], [-120.25876, 39.39522], [-120.25396, 39.39525], [-120.25388, 39.3879], [-120.25851, 39.38786], [-120.25867, 39.39153], [-120.26351, 39.3915], [-120.26339, 39.38783], [-120.27272, 39.38778], [-120.27276, 39.39143], [-120.27129, 39.39145], [-120.27079, 39.39143], [-120.26353, 39.3915], [-120.26365, 39.39516], [-120.27278, 39.39517], [-120.2728, 39.39515], [-120.27279, 39.39492], [-120.27492, 39.39514], [-120.27539, 39.39516], [-120.28214, 39.39514], [-120.28228, 39.40185], [-120.28244, 39.40266]]]} | Open Access 1 | Lower Carpenter Valley | http://tdlandtrust.org/carpenter-valley-0 | 32437 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 617.366 | Lower Carpenter Valley | |
14613 | 14613 | 14612 | {"type": "Polygon", "coordinates": [[[-120.15979, 39.35605], [-120.15917, 39.35687], [-120.15867, 39.35761], [-120.15837, 39.35812], [-120.15809, 39.35864], [-120.15766, 39.35956], [-120.15084, 39.35953], [-120.14169, 39.35945], [-120.1417, 39.35904], [-120.14249, 39.35866], [-120.1432, 39.35835], [-120.14388, 39.35799], [-120.14467, 39.3575], [-120.14541, 39.35696], [-120.14578, 39.35665], [-120.1489, 39.35367], [-120.15846, 39.34589], [-120.15694, 39.3498], [-120.15755, 39.3498], [-120.15794, 39.34996], [-120.15825, 39.35026], [-120.15839, 39.35056], [-120.15794, 39.35469], [-120.15803, 39.35493], [-120.15833, 39.3553], [-120.15979, 39.35605]]]} | Restricted Access 2 | Old Greenwood Golf Course | 33108 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 258.414 | Old Greenwood GC |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);