units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
52 rows where COUNTY = 5 and DES_TP = 14 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13303 | 13303 | 13302 | {"type": "Polygon", "coordinates": [[[-121.75571, 36.90633], [-121.75551, 36.90647], [-121.75541, 36.90638], [-121.75541, 36.90638], [-121.75571, 36.90633]]]} | Open Access 1 | 35365 | Watsonville holding 1 | 27309 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.04 | Watsonville holding 1 | 0 | Local Other or Unknown 14 | 4 | |
4926 | 4926 | 4925 | {"type": "Polygon", "coordinates": [[[-122.05814, 36.96663], [-122.05806, 36.96669], [-122.05789, 36.96636], [-122.05797, 36.9663], [-122.05814, 36.96663]]]} | Open Access 1 | 35361 | Santa Cruz holding 4 | 25074 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.09 | Santa Cruz holding 4 | 0 | Local Other or Unknown 14 | 4 | |
4673 | 4673 | 4672 | {"type": "Polygon", "coordinates": [[[-121.86411, 36.93794], [-121.86404, 36.93797], [-121.86384, 36.93798], [-121.86379, 36.93797], [-121.86377, 36.93793], [-121.86383, 36.93779], [-121.86393, 36.93787], [-121.86398, 36.93783], [-121.86411, 36.93794]]]} | Open Access 1 | 36646 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.092 | 0 | Local Other or Unknown 14 | 4 | ||
13230 | 13230 | 13229 | {"type": "Polygon", "coordinates": [[[-122.01894, 36.98092], [-122.01894, 36.98092], [-122.01864, 36.98102], [-122.01878, 36.98082], [-122.01886, 36.98067], [-122.01892, 36.98061], [-122.01894, 36.98092]]]} | Open Access 1 | 35358 | Santa Cruz holding 3 | 25073 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.121 | Santa Cruz holding 3 | 0 | Local Other or Unknown 14 | 4 | |
12986 | 12986 | 12985 | {"type": "Polygon", "coordinates": [[[-122.05824, 36.96592], [-122.05801, 36.96601], [-122.05789, 36.96585], [-122.05811, 36.96573], [-122.05824, 36.96592]]]} | Open Access 1 | 35359 | Santa Cruz holding 1 | 25064 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.127 | Santa Cruz holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13342 | 13342 | 13341 | {"type": "Polygon", "coordinates": [[[-122.00556, 37.06268], [-122.0055, 37.06275], [-122.00535, 37.06284], [-122.00528, 37.06254], [-122.00532, 37.06251], [-122.00537, 37.06251], [-122.00552, 37.0626], [-122.00556, 37.06268]]]} | Open Access 1 | 35420 | Scotts Valley holding 3 | 25209 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 0.132 | Scotts Valley holding 3 | 0 | Local Other or Unknown 14 | 4 | |
15485 | 15485 | 15484 | {"type": "Polygon", "coordinates": [[[-121.8621, 36.93337], [-121.86183, 36.93378], [-121.86183, 36.93423], [-121.86175, 36.93427], [-121.86176, 36.93376], [-121.86206, 36.93332], [-121.8621, 36.93337]]]} | Open Access 1 | 43087 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.166 | 0 | Local Other or Unknown 14 | 4 | ||
3178 | 3178 | 3177 | {"type": "Polygon", "coordinates": [[[-121.93307, 36.98817], [-121.93305, 36.9883], [-121.93244, 36.98822], [-121.93247, 36.98809], [-121.93307, 36.98817]]]} | Open Access 1 | 1913 | Willowbrook Park - Soquel Creek Water District | 27591 | 2157 | Soquel Creek Water District 592 | Special District 4 | Water District 13 | http://www.soquelcreekwater.org/ | Special District 4 | 2157 | Soquel Creek Water District 582 | Special District 4 | Water District 13 | Santa Cruz 5 | 0.197 | Willowbrook Park - Soquel Creek Water District | 0 | Local Other or Unknown 14 | 4 | |
15482 | 15482 | 15481 | {"type": "Polygon", "coordinates": [[[-121.85976, 36.9403], [-121.85956, 36.94034], [-121.85939, 36.94045], [-121.85932, 36.94046], [-121.85927, 36.94041], [-121.85927, 36.94028], [-121.85951, 36.94009], [-121.85976, 36.9403]]]} | Open Access 1 | 43081 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.222 | 0 | Local Other or Unknown 14 | 4 | ||
13207 | 13207 | 13206 | {"type": "Polygon", "coordinates": [[[-121.97361, 36.96111], [-121.97328, 36.96111], [-121.97328, 36.96082], [-121.97361, 36.96083], [-121.97361, 36.96111]]]} | Open Access 1 | 35236 | Santa Cruz holding 8 | 25078 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.232 | Santa Cruz holding 8 | 0 | Local Other or Unknown 14 | 4 | |
4618 | 4618 | 4617 | {"type": "Polygon", "coordinates": [[[-121.86433, 36.93568], [-121.86428, 36.93572], [-121.8632, 36.9346], [-121.86325, 36.93456], [-121.86433, 36.93568]]]} | Open Access 1 | 36130 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.256 | 0 | Local Other or Unknown 14 | 4 | ||
4619 | 4619 | 4618 | {"type": "Polygon", "coordinates": [[[-121.86, 36.94078], [-121.85982, 36.94067], [-121.85962, 36.94058], [-121.85956, 36.94051], [-121.8596, 36.94044], [-121.85969, 36.9404], [-121.86, 36.94039], [-121.86, 36.94078]]]} | Open Access 1 | 36131 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.265 | 0 | Local Other or Unknown 14 | 4 | ||
4683 | 4683 | 4682 | {"type": "Polygon", "coordinates": [[[-121.8613, 36.93786], [-121.86128, 36.9379], [-121.86099, 36.93813], [-121.86095, 36.93813], [-121.86093, 36.9381], [-121.86095, 36.93798], [-121.86093, 36.93765], [-121.86096, 36.93761], [-121.86102, 36.93762], [-121.86128, 36.93782], [-121.8613, 36.93786]]]} | Open Access 1 | 43074 | Unknown park - La Selva Beach Recreation District | 28639 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.278 | 0 | Local Other or Unknown 14 | 4 | ||
13277 | 13277 | 13276 | {"type": "Polygon", "coordinates": [[[-122.0466, 36.97904], [-122.04636, 36.97912], [-122.04618, 36.97894], [-122.0463, 36.97884], [-122.0458, 36.97834], [-122.04591, 36.97836], [-122.0466, 36.97904]]]} | Open Access 1 | 35330 | Santa Cruz holding 14 | 28172 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.279 | Santa Cruz holding 14 | 0 | Local Other or Unknown 14 | 4 | |
13281 | 13281 | 13280 | {"type": "Polygon", "coordinates": [[[-121.99859, 37.06655], [-121.99847, 37.06705], [-121.99811, 37.06695], [-121.99814, 37.06685], [-121.99824, 37.06674], [-121.99859, 37.06655]]]} | Open Access 1 | 35335 | Scotts Valley holding 7 | 25213 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 0.3 | Scotts Valley holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13942 | 13942 | 13941 | {"type": "Polygon", "coordinates": [[[-121.97198, 36.96602], [-121.97144, 36.96602], [-121.97144, 36.96579], [-121.97198, 36.96579], [-121.97198, 36.96602]]]} | Open Access 1 | 36563 | Santa Cruz holding 15 | 25070 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.306 | Santa Cruz holding 15 | 0 | Local Other or Unknown 14 | 4 | |
13340 | 13340 | 13339 | {"type": "Polygon", "coordinates": [[[-121.99514, 37.05375], [-121.99504, 37.05378], [-121.99487, 37.05355], [-121.99458, 37.05324], [-121.99485, 37.05316], [-121.99499, 37.05319], [-121.99502, 37.05361], [-121.99514, 37.05375]]]} | Open Access 1 | 35418 | Scotts Valley holding 2 | 25208 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 0.324 | Scotts Valley holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13334 | 13334 | 13333 | {"type": "Polygon", "coordinates": [[[-122.03292, 36.98026], [-122.03259, 36.98011], [-122.0326, 36.97995], [-122.03254, 36.97982], [-122.03278, 36.97971], [-122.03286, 36.97973], [-122.03292, 36.98026]]]} | Open Access 1 | 35410 | Santa Cruz holding 9 | 25079 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.326 | Santa Cruz holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13199 | 13199 | 13198 | {"type": "Polygon", "coordinates": [[[-122.02701, 37.01206], [-122.02689, 37.01231], [-122.02679, 37.01235], [-122.02626, 37.01189], [-122.02641, 37.01177], [-122.02654, 37.01175], [-122.02663, 37.01179], [-122.02701, 37.01206]]]} | Open Access 1 | 35226 | Santa Cruz holding 13 | 28177 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.557 | Santa Cruz holding 13 | 0 | Local Other or Unknown 14 | 4 | |
4296 | 4296 | 4295 | {"type": "Polygon", "coordinates": [[[-122.05637, 37.07384], [-122.0561, 37.07397], [-122.056, 37.07404], [-122.05592, 37.07413], [-122.05577, 37.07436], [-122.05552, 37.07423], [-122.05574, 37.07384], [-122.05592, 37.07367], [-122.05637, 37.07384]]]} | Open Access 1 | 45336 | San Lorenzo Valley Water District | 11349 | 2277 | San Lorenzo Valley Water District 598 | Special District 4 | Water District 13 | http://www.slvwd.com/ | Special District 4 | 2277 | San Lorenzo Valley Water District 588 | Special District 4 | Water District 13 | Santa Cruz 5 | 0.582 | San Lorenzo Valley Water District | 0 | Local Other or Unknown 14 | 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]);