units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
212 rows where ACCESS_TYP = 1 and DES_TP = 16 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13028 | 13028 | 13027 | {"type": "Polygon", "coordinates": [[[-122.47784, 37.51093], [-122.47784, 37.51093], [-122.4775, 37.51077], [-122.4778, 37.51075], [-122.47784, 37.51093]]]} | Open Access 1 | 34870 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.069 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
296 | 296 | 295 | {"type": "Polygon", "coordinates": [[[-122.08006, 37.03997], [-122.08006, 37.04024], [-122.07996, 37.04025], [-122.07993, 37.04002], [-122.08006, 37.03997]]]} | Open Access 1 | 795 | Shinglemill Creek | 28175 | 3036 | Land Trust of Santa Cruz County 121 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landtrustsantacruz.org/ | Non Governmental Organization 10 | 3036 | Land Trust of Santa Cruz County 118 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 0.071 | Shinglemill Creek | 0 | Private Conservation 16 | 2 | |
13027 | 13027 | 13026 | {"type": "Polygon", "coordinates": [[[-122.47788, 37.51058], [-122.47771, 37.51062], [-122.47766, 37.51034], [-122.47781, 37.51035], [-122.47788, 37.51058]]]} | Open Access 1 | 34869 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.104 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
3751 | 3751 | 3750 | {"type": "Polygon", "coordinates": [[[-122.43183, 37.44426], [-122.43175, 37.44427], [-122.43168, 37.44373], [-122.43176, 37.44372], [-122.43183, 37.44426]]]} | Open Access 1 | 34834 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.114 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
9788 | 9788 | 9787 | {"type": "Polygon", "coordinates": [[[-121.94606, 36.98814], [-121.94612, 36.98821], [-121.94625, 36.9883], [-121.94626, 36.98834], [-121.94624, 36.98837], [-121.94619, 36.98839], [-121.94597, 36.9884], [-121.94596, 36.98815], [-121.94606, 36.98814]]]} | Open Access 1 | 16684 | Greenspace Gardens | 30453 | 3036 | Land Trust of Santa Cruz County 121 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landtrustsantacruz.org/ | Non Governmental Organization 10 | 3036 | Land Trust of Santa Cruz County 118 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 0.128 | Greenspace Gardens | 0 | Private Conservation 16 | 2 | |
2004 | 2004 | 2003 | {"type": "Polygon", "coordinates": [[[-120.83864, 35.3316], [-120.83864, 35.33176], [-120.83843, 35.33176], [-120.83823, 35.33167], [-120.83823, 35.33139], [-120.83864, 35.3316]]]} | Open Access 1 | 16907 | Audubon Overlook | 15703 | 3043 | Morro Coast Audubon Society 468 | Non Profit 6 | Non Profit - Conservation 12 | http://www.morrocoastaudubon.org/ | Non Governmental Organization 10 | 3043 | Morro Coast Audubon Society 461 | Non Profit 6 | Non Profit - Conservation 12 | San Luis Obispo 1 | 0.256 | Audubon Overlook | 0 | Private Conservation 16 | 2 | |
14625 | 14625 | 14624 | {"type": "Polygon", "coordinates": [[[-117.26035, 32.96792], [-117.26005, 32.96812], [-117.25973, 32.9678], [-117.2599, 32.96778], [-117.2601, 32.96779], [-117.26023, 32.96784], [-117.26035, 32.96792]]]} | Open Access 1 | 44860 | San Dieguito Lagoon | 24865 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | http://sandieguitorivervalleyconservancy.org/sdrvc1_projects_acquisitions1.html | San Diego 4 | 0.286 | San Dieguito Lagoon | 0 | Private Conservation 16 | 2 |
13025 | 13025 | 13024 | {"type": "MultiPolygon", "coordinates": [[[[-122.44722, 37.47993], [-122.44714, 37.47996], [-122.44695, 37.47974], [-122.44702, 37.4797], [-122.44722, 37.47993]]], [[[-122.44891, 37.47986], [-122.44862, 37.48002], [-122.44843, 37.47979], [-122.44871, 37.47964], [-122.44891, 37.47986]]]]} | Open Access 1 | 34864 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.287 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
13026 | 13026 | 13025 | {"type": "MultiPolygon", "coordinates": [[[[-122.44993, 37.48751], [-122.4495, 37.48768], [-122.44944, 37.4876], [-122.44975, 37.48747], [-122.44965, 37.4873], [-122.44975, 37.48725], [-122.44993, 37.48751]]], [[[-122.45031, 37.48826], [-122.44999, 37.48839], [-122.44987, 37.48822], [-122.45019, 37.48809], [-122.45031, 37.48826]]]]} | Open Access 1 | 34867 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.34 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
8068 | 8068 | 8067 | {"type": "Polygon", "coordinates": [[[-120.1983, 39.31826], [-120.19732, 39.31893], [-120.19724, 39.31898], [-120.19794, 39.3181], [-120.1983, 39.31826]]]} | Open Access 1 | 48988 | Hoseit | 33682 | 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 | https://www.truckeedonnerlandtrust.org/ | Nevada 30 | 0.508 | Hoseit | 0 | Private Conservation 16 | 2 |
11226 | 11226 | 11225 | {"type": "Polygon", "coordinates": [[[-121.20019, 38.71522], [-121.20005, 38.71565], [-121.19981, 38.71561], [-121.19954, 38.7156], [-121.19959, 38.71518], [-121.20019, 38.71522]]]} | Open Access 1 | 21564 | Elsami | 18603 | 3056 | Placer Legacy 969 | Non Profit 6 | Non Profit - Conservation 12 | http://www.placer.ca.gov/departments/communitydevelopment/planning/placerlegacy | Non Governmental Organization 10 | 3056 | Placer Legacy 935 | Non Profit 6 | Non Profit - Conservation 12 | Placer 35 | 0.573 | Elsami | 0 | Private Conservation 16 | 2 | |
222 | 222 | 221 | {"type": "MultiPolygon", "coordinates": [[[[-121.8673, 36.95006], [-121.86712, 36.95048], [-121.86682, 36.95042], [-121.86651, 36.95041], [-121.8673, 36.95006]], [[-121.86709, 36.95029], [-121.86695, 36.95026], [-121.86691, 36.95037], [-121.8671, 36.95041], [-121.86715, 36.95031], [-121.86709, 36.95029]]], [[[-121.86797, 36.95053], [-121.8677, 36.95077], [-121.86751, 36.95064], [-121.86733, 36.95055], [-121.86756, 36.95019], [-121.86775, 36.95036], [-121.86797, 36.95053]]], [[[-121.86937, 36.95145], [-121.86934, 36.95153], [-121.86929, 36.95158], [-121.86921, 36.95159], [-121.86891, 36.95152], [-121.86896, 36.95137], [-121.86937, 36.95145]]]]} | Open Access 1 | 732 | Seascape Uplands Preserve | 25249 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 0.859 | Seascape Uplands Preserve | 0 | Private Conservation 16 | 2 | |
11427 | 11427 | 11426 | {"type": "Polygon", "coordinates": [[[-123.35819, 39.40016], [-123.35815, 39.40029], [-123.35808, 39.40029], [-123.35808, 39.40035], [-123.35769, 39.40035], [-123.35769, 39.40074], [-123.35748, 39.40075], [-123.35748, 39.40086], [-123.35711, 39.40086], [-123.35709, 39.40016], [-123.35819, 39.40016]]]} | Open Access 1 | 48094 | Willits Kids Club Discovery Park and Playground | 32597 | 3383 | Willits Kids Club 977 | Non Profit 6 | Non Profit - Other 22 | http://www.willitskidsclub.org/about | Non Governmental Organization 10 | 3383 | Willits Kids Club 941 | Non Profit 6 | Non Profit - Other 20 | Mendocino 24 | 1.119 | Willits Kids Club Discovery Park and Playground | 0 | Private Conservation 16 | 2 | |
1282 | 1282 | 1281 | {"type": "Polygon", "coordinates": [[[-117.23197, 33.35767], [-117.23195, 33.35817], [-117.23163, 33.35818], [-117.2314, 33.35817], [-117.23119, 33.35811], [-117.23111, 33.35808], [-117.23108, 33.35804], [-117.2311, 33.358], [-117.23133, 33.35781], [-117.23146, 33.35767], [-117.2318, 33.35723], [-117.2319, 33.35729], [-117.23197, 33.35767]]]} | Open Access 1 | 7247 | Palomares House | 23367 | 3022 | Fallbrook Land Conservancy 339 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/ | Non Governmental Organization 10 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/palomares-house-and-park.html | San Diego 4 | 1.248 | Palomares House | 0 | Private Conservation 16 | 2 |
13192 | 13192 | 13191 | {"type": "Polygon", "coordinates": [[[-121.97264, 36.58026], [-121.97194, 36.58041], [-121.97168, 36.58018], [-121.97156, 36.57995], [-121.97243, 36.57965], [-121.97257, 36.57999], [-121.97264, 36.58026]]]} | Open Access 1 | 35189 | S.F.B. Morse Memorial Lot | 28537 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 1.252 | S.F.B. Morse Memorial Lot | 0 | Private Conservation 16 | 2 | |
3278 | 3278 | 3277 | {"type": "Polygon", "coordinates": [[[-121.03318, 39.14691], [-121.03318, 39.14723], [-121.03271, 39.14793], [-121.03234, 39.1476], [-121.0324, 39.14717], [-121.03268, 39.14678], [-121.03318, 39.14691]]]} | Open Access 1 | 23175 | Mathis Pond Preserve | 31039 | 3223 | Bear Yuba Land Trust 100 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bylt.org/ | Non Governmental Organization 10 | 3223 | Bear Yuba Land Trust 98 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bylt.org/land/mathis-pond-preserve/ | Nevada 30 | 1.459 | Mathis Pond Preserve | 0 | Private Conservation 16 | 2 |
13186 | 13186 | 13185 | {"type": "Polygon", "coordinates": [[[-121.95578, 36.56241], [-121.95541, 36.5627], [-121.95521, 36.56252], [-121.9544, 36.56194], [-121.95423, 36.56185], [-121.95402, 36.56181], [-121.95408, 36.56142], [-121.95494, 36.56186], [-121.95578, 36.56241]]]} | Open Access 1 | 35176 | Pescadero Point and Hill Preserve | 28527 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 1.664 | Pescadero Point and Hill Preserve | 0 | Private Conservation 16 | 2 | |
13024 | 13024 | 13023 | {"type": "MultiPolygon", "coordinates": [[[[-122.44521, 37.47132], [-122.44505, 37.47233], [-122.44454, 37.47219], [-122.44468, 37.47127], [-122.44521, 37.47132]]], [[[-122.44527, 37.47091], [-122.44525, 37.47104], [-122.44472, 37.47099], [-122.44474, 37.47086], [-122.44527, 37.47091]]], [[[-122.44533, 37.4705], [-122.44529, 37.47077], [-122.44476, 37.47072], [-122.4448, 37.47045], [-122.44533, 37.4705]]], [[[-122.44524, 37.47005], [-122.445, 37.47003], [-122.44508, 37.46956], [-122.44524, 37.47005], [-122.44524, 37.47005]]]]} | Open Access 1 | 34859 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 1.932 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
7895 | 7895 | 7894 | {"type": "Polygon", "coordinates": [[[-120.29922, 39.32203], [-120.29646, 39.32199], [-120.29619, 39.32189], [-120.29604, 39.32171], [-120.29531, 39.32159], [-120.29539, 39.32128], [-120.29584, 39.32142], [-120.2959, 39.32131], [-120.29584, 39.32107], [-120.29593, 39.32107], [-120.296, 39.32135], [-120.29622, 39.32136], [-120.29622, 39.32149], [-120.2965, 39.32167], [-120.29679, 39.32181], [-120.29709, 39.32187], [-120.29719, 39.32187], [-120.29746, 39.32194], [-120.29812, 39.32159], [-120.29922, 39.32203]]]} | Open Access 1 | 48985 | Creekside Woods | 33680 | 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 | https://www.truckeedonnerlandtrust.org/ | Nevada 30 | 2.295 | Creekside Woods | 0 | Private Conservation 16 | 2 |
7542 | 7542 | 7541 | {"type": "Polygon", "coordinates": [[[-124.13929, 41.06003], [-124.13917, 41.06023], [-124.1392, 41.0603], [-124.1392, 41.06036], [-124.13919, 41.06045], [-124.13914, 41.06056], [-124.13914, 41.06105], [-124.139, 41.06087], [-124.13894, 41.06077], [-124.13889, 41.06064], [-124.13881, 41.06034], [-124.13872, 41.06014], [-124.13853, 41.0599], [-124.13853, 41.05847], [-124.13916, 41.05822], [-124.13886, 41.05927], [-124.13888, 41.05935], [-124.13894, 41.05944], [-124.139, 41.05949], [-124.13903, 41.0595], [-124.13912, 41.0596], [-124.13912, 41.05966], [-124.13903, 41.0597], [-124.13903, 41.05972], [-124.13918, 41.05981], [-124.13927, 41.05989], [-124.13929, 41.06003]]]} | Open Access 1 | 47609 | Bruno Groth Grove | 31341 | 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 | Humboldt 45 | 2.651 | Bruno Groth Grove | 0 | Private Conservation 16 | 2 |
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]);