units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where DES_TP = 65 and MNG_AG_TYP = 10 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY 3
ACCESS_TYP 2
MNG_AG_TYP 1
- Non Profit - Land Trust · 5 ✖
DES_TP 1
- Private Recreation or Education · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15724 | 15724 | 15723 | {"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.15693, 39.3498], [-120.15755, 39.3498], [-120.15794, 39.34996], [-120.15825, 39.35026], [-120.15839, 39.35056], [-120.15794, 39.3547], [-120.15803, 39.35493], [-120.15833, 39.3553], [-120.15979, 39.35605]]]} | Restricted Access 2 | 44736 | Old Greenwood Golf Course | 33108 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 258.402 | Old Greenwood GC | 0 | Private Recreation or Education 65 | 4 | |
15725 | 15725 | 15724 | {"type": "MultiPolygon", "coordinates": [[[[-120.16777, 39.32371], [-120.16732, 39.32424], [-120.16563, 39.32376], [-120.16561, 39.32386], [-120.16581, 39.3241], [-120.16572, 39.32418], [-120.1656, 39.32411], [-120.16508, 39.32443], [-120.16493, 39.32458], [-120.16286, 39.32477], [-120.16153, 39.32476], [-120.16136, 39.32504], [-120.16135, 39.32548], [-120.16125, 39.32555], [-120.16113, 39.32561], [-120.161, 39.32564], [-120.16081, 39.32566], [-120.16081, 39.32247], [-120.16499, 39.32236], [-120.16777, 39.32371]]], [[[-120.17072, 39.32608], [-120.17051, 39.32637], [-120.17011, 39.32617], [-120.1701, 39.32604], [-120.16081, 39.32611], [-120.16081, 39.32583], [-120.1611, 39.3258], [-120.16131, 39.32572], [-120.16138, 39.32581], [-120.16245, 39.32571], [-120.16317, 39.32559], [-120.1645, 39.32524], [-120.16475, 39.32561], [-120.16713, 39.325], [-120.16742, 39.32482], [-120.16718, 39.32458], [-120.16732, 39.32449], [-120.16745, 39.32437], [-120.16794, 39.32379], [-120.17013, 39.32486], [-120.17072, 39.32608]]]]} | Restricted Access 2 | 44739 | Ponderosa Golf Course | 33109 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 52.893 | Ponderosa GC | 0 | Private Recreation or Education 65 | 4 | |
4311 | 4311 | 4310 | {"type": "Polygon", "coordinates": [[[-124.14215, 41.06163], [-124.14216, 41.06222], [-124.14214, 41.06229], [-124.14209, 41.0624], [-124.14204, 41.06246], [-124.14198, 41.06251], [-124.14186, 41.06258], [-124.14184, 41.06248], [-124.14083, 41.06253], [-124.14052, 41.06219], [-124.14117, 41.06192], [-124.14071, 41.06151], [-124.14108, 41.06136], [-124.14118, 41.06161], [-124.14194, 41.0615], [-124.14195, 41.0613], [-124.14192, 41.06121], [-124.14212, 41.06118], [-124.14215, 41.06163]]]} | Open Access 1 | 45379 | Saunders Park | 27897 | 3203 | Trinidad Coastal Land Trust 690 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/holdings/index.html | Humboldt 45 | 3.134 | Saunders Park | 0 | Private Recreation or Education 65 | 4 |
7541 | 7541 | 7540 | {"type": "Polygon", "coordinates": [[[-124.11965, 41.03876], [-124.11891, 41.0388], [-124.11852, 41.0388], [-124.11838, 41.03832], [-124.11834, 41.03786], [-124.11845, 41.03761], [-124.1185, 41.0374], [-124.11848, 41.03711], [-124.11845, 41.03703], [-124.11803, 41.03637], [-124.11803, 41.03607], [-124.11812, 41.03579], [-124.11835, 41.03581], [-124.11849, 41.03571], [-124.1189, 41.0358], [-124.11916, 41.03613], [-124.11919, 41.03682], [-124.11911, 41.0371], [-124.11907, 41.03794], [-124.11913, 41.03827], [-124.11933, 41.03852], [-124.11965, 41.03876]]]} | Open Access 1 | 47608 | Houda Point/Camel Rock Beach Park | 31339 | 3203 | Trinidad Coastal Land Trust 690 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | http://trinidadcoastallandtrust.org/holdings/houdapoint/ | Humboldt 45 | 5.877 | Houda Point/Camel Rock Beach Park | 0 | Private Recreation or Education 65 | 4 |
3808 | 3808 | 3807 | {"type": "Polygon", "coordinates": [[[-121.77003, 37.62324], [-121.77003, 37.62946], [-121.76542, 37.62945], [-121.76621, 37.62868], [-121.76783, 37.62822], [-121.76803, 37.62682], [-121.76808, 37.62681], [-121.76802, 37.62328], [-121.76102, 37.62522], [-121.76017, 37.6241], [-121.75799, 37.62352], [-121.75806, 37.62347], [-121.75914, 37.62234], [-121.76547, 37.62237], [-121.76549, 37.62329], [-121.76734, 37.62327], [-121.76735, 37.62313], [-121.76821, 37.62312], [-121.76822, 37.62326], [-121.77003, 37.62324]]]} | Open Access 1 | 35127 | Sycamore Grove Park | 26129 | 3083 | Tri-Valley Conservancy 687 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trivalleyconservancy.org/ | Non Governmental Organization 10 | 3083 | Tri-Valley Conservancy 678 | Non Profit 6 | Non Profit - Land Trust 10 | Alameda 17 | 73.084 | Sycamore Grove Park | 0 | Private Recreation or Education 65 | 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]);