units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
75 rows where AGNCY_LEV = 2, COUNTY = 5, DES_TP = 2 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14 | 14 | 13 | {"type": "Polygon", "coordinates": [[[-122.03122, 36.97381], [-122.03122, 36.97381], [-122.03111, 36.97409], [-122.03105, 36.97384], [-122.03122, 36.97381]]]} | Open Access 1 | 42 | Rincon Park | 24369 | 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.055 | Rincon Park | 0 | Local Park 2 | 4 | |
20 | 20 | 19 | {"type": "Polygon", "coordinates": [[[-121.7511, 36.90667], [-121.74954, 36.9078], [-121.74933, 36.90761], [-121.75087, 36.90647], [-121.7511, 36.90667]]]} | Open Access 1 | 76 | River Park | 24419 | 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 | 1.349 | River Park | 0 | Local Park 2 | 4 | |
75 | 75 | 74 | {"type": "Polygon", "coordinates": [[[-122.05137, 36.97047], [-122.05103, 36.97055], [-122.05096, 36.97049], [-122.05087, 36.97031], [-122.05129, 36.97021], [-122.05137, 36.97047]]]} | Open Access 1 | 182 | Round Tree Park | 24704 | 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.27 | Round Tree Park | 0 | Local Park 2 | 4 | |
87 | 87 | 86 | {"type": "Polygon", "coordinates": [[[-121.74459, 36.92013], [-121.74445, 36.92037], [-121.74431, 36.92032], [-121.74415, 36.92034], [-121.744, 36.92028], [-121.74398, 36.92024], [-121.74411, 36.92], [-121.74416, 36.91997], [-121.7442, 36.91998], [-121.74459, 36.92013]]]} | Open Access 1 | 247 | Brentwood Park | 16362 | 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.377 | Brentwood Park | 0 | Local Park 2 | 4 | |
155 | 155 | 154 | {"type": "Polygon", "coordinates": [[[-121.7428, 36.9182], [-121.74279, 36.91824], [-121.7426, 36.9185], [-121.74256, 36.91853], [-121.7425, 36.91852], [-121.74237, 36.91846], [-121.74233, 36.91842], [-121.74234, 36.91838], [-121.74253, 36.91813], [-121.74258, 36.9181], [-121.74265, 36.9181], [-121.74277, 36.91816], [-121.7428, 36.9182]]]} | Open Access 1 | 417 | Bronte Park | 16417 | 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.287 | Bronte Park | 0 | Local Park 2 | 4 | |
271 | 271 | 270 | {"type": "MultiPolygon", "coordinates": [[[[-121.95373, 36.97272], [-121.95357, 36.973], [-121.95313, 36.97262], [-121.95289, 36.97279], [-121.95277, 36.97267], [-121.95323, 36.97241], [-121.9534, 36.97233], [-121.95349, 36.97232], [-121.95355, 36.97237], [-121.95362, 36.97253], [-121.95373, 36.97272]]], [[[-121.95514, 36.97464], [-121.95484, 36.97468], [-121.95482, 36.97466], [-121.95468, 36.97473], [-121.95455, 36.97457], [-121.95473, 36.97446], [-121.95467, 36.97434], [-121.95418, 36.97457], [-121.95416, 36.97455], [-121.95466, 36.9743], [-121.95458, 36.97412], [-121.95379, 36.97318], [-121.95387, 36.97304], [-121.95418, 36.97332], [-121.95431, 36.97348], [-121.95434, 36.97354], [-121.95474, 36.97406], [-121.95493, 36.97432], [-121.95502, 36.97451], [-121.95505, 36.97451], [-121.95514, 36.97464]]], [[[-121.95491, 36.97485], [-121.95485, 36.9749], [-121.95478, 36.97481], [-121.95487, 36.97475], [-121.95491, 36.97485]]], [[[-121.95588, 36.97452], [-121.9558, 36.97455], [-121.95563, 36.97424], [-121.95526, 36.97383], [-121.9551, 36.97373], [-121.95525, 36.97374], [-121.95532, 36.97379], [-121.95571, 36.97421], [-121.95588, 36.97452]]]]} | Open Access 1 | 917 | Soquel Creek Park | 25621 | 1044 | Capitola, City of 112 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | Santa Cruz 5 | 2.021 | Soquel Creek Park | 0 | Local Park 2 | 4 | |
281 | 281 | 280 | {"type": "Polygon", "coordinates": [[[-121.77782, 36.90425], [-121.77774, 36.90416], [-121.77761, 36.90412], [-121.77715, 36.90423], [-121.77705, 36.90428], [-121.77614, 36.9049], [-121.77607, 36.90497], [-121.77603, 36.90505], [-121.77603, 36.90513], [-121.77637, 36.90605], [-121.77639, 36.90628], [-121.77634, 36.9065], [-121.77621, 36.90671], [-121.77602, 36.90687], [-121.77579, 36.90699], [-121.77611, 36.90644], [-121.7747, 36.90471], [-121.77763, 36.90374], [-121.77782, 36.90425]]]} | Open Access 1 | 754 | Seaview Park | 25273 | 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 | 6.282 | Seaview Park | 0 | Local Park 2 | 4 | |
464 | 464 | 463 | {"type": "Polygon", "coordinates": [[[-122.05625, 36.97294], [-122.05609, 36.97322], [-122.05543, 36.97488], [-122.05427, 36.97499], [-122.05421, 36.97452], [-122.05452, 36.97346], [-122.05412, 36.97347], [-122.05414, 36.97323], [-122.05445, 36.97322], [-122.05529, 36.97301], [-122.05527, 36.9731], [-122.05528, 36.97311], [-122.05561, 36.97298], [-122.05625, 36.97294]]]} | Open Access 1 | 1592 | University Terrace Park | 26690 | 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 | 6.775 | University Terrace Park | 0 | Local Park 2 | 4 | |
475 | 475 | 474 | {"type": "Polygon", "coordinates": [[[-122.00999, 36.96529], [-122.00949, 36.96531], [-122.00956, 36.96505], [-122.00915, 36.96464], [-122.00891, 36.96456], [-122.00917, 36.96442], [-122.00936, 36.96436], [-122.00956, 36.96434], [-122.00976, 36.96435], [-122.00999, 36.96529]]]} | Open Access 1 | 1534 | Tyrell Park | 26631 | 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 | 1.3 | Tyrell Park | 0 | Local Park 2 | 4 | |
529 | 529 | 528 | {"type": "Polygon", "coordinates": [[[-121.74601, 36.9207], [-121.74537, 36.92053], [-121.74531, 36.92051], [-121.74535, 36.92045], [-121.74541, 36.92044], [-121.74598, 36.92066], [-121.74601, 36.9207]]]} | Open Access 1 | 1747 | Victorian Park | 27085 | 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.111 | Victorian Park | 0 | Local Park 2 | 4 | |
553 | 553 | 552 | {"type": "Polygon", "coordinates": [[[-122.0466, 36.97717], [-122.04659, 36.97722], [-122.04655, 36.97724], [-122.04624, 36.97731], [-122.04595, 36.97733], [-122.04567, 36.97725], [-122.04545, 36.9771], [-122.04455, 36.97619], [-122.04499, 36.97557], [-122.04589, 36.97533], [-122.04606, 36.97566], [-122.0462, 36.976], [-122.0466, 36.97717]]]} | Open Access 1 | 1839 | Westlake Park | 27403 | 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 | 6.008 | Westlake Park | 0 | Local Park 2 | 4 | |
610 | 610 | 609 | {"type": "Polygon", "coordinates": [[[-122.01752, 37.02001], [-122.01724, 37.02045], [-122.01717, 37.02042], [-122.01712, 37.02034], [-122.01683, 37.0203], [-122.01655, 37.02012], [-122.01641, 37.02009], [-122.01665, 37.0197], [-122.01675, 37.01958], [-122.01686, 37.01955], [-122.01698, 37.01966], [-122.01727, 37.01988], [-122.01752, 37.02001]]]} | Open Access 1 | 2139 | Camp Evers Fishing Park | 16774 | 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 | 1.271 | Camp Evers Fishing Park | 0 | Local Park 2 | 4 | |
709 | 709 | 708 | {"type": "Polygon", "coordinates": [[[-122.01909, 36.97734], [-122.01892, 36.97736], [-122.01872, 36.97737], [-122.01879, 36.97715], [-122.01894, 36.97709], [-122.01909, 36.97734]]]} | Open Access 1 | 5334 | Central Park | 17062 | 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.156 | Central Park | 0 | Local Park 2 | 4 | |
1436 | 1436 | 1435 | {"type": "Polygon", "coordinates": [[[-122.01137, 36.9919], [-122.01132, 36.9921], [-122.0113, 36.99239], [-122.01115, 36.99208], [-122.01115, 36.99183], [-122.01137, 36.9919]]]} | Open Access 1 | 47745 | Branciforte Dog Park | 31554 | 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.175 | Branciforte Dog Park | 0 | Local Park 2 | 4 | |
1520 | 1520 | 1519 | {"type": "Polygon", "coordinates": [[[-122.00809, 36.98128], [-122.00809, 36.98128], [-122.00733, 36.98127], [-122.00796, 36.98109], [-122.00807, 36.98104], [-122.00809, 36.98128]]]} | Open Access 1 | 47747 | El Portal Park | 31556 | 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.212 | El Portal Park | 0 | Local Park 2 | 4 | |
1946 | 1946 | 1945 | {"type": "Polygon", "coordinates": [[[-121.76093, 36.91723], [-121.76076, 36.91733], [-121.76072, 36.91757], [-121.7608, 36.91771], [-121.76083, 36.91787], [-121.76082, 36.91797], [-121.76078, 36.91807], [-121.76066, 36.91822], [-121.76067, 36.91867], [-121.76061, 36.91868], [-121.76059, 36.91821], [-121.76052, 36.91809], [-121.7605, 36.91802], [-121.76049, 36.91789], [-121.7605, 36.91782], [-121.76055, 36.9177], [-121.76065, 36.91757], [-121.7607, 36.91729], [-121.76089, 36.91719], [-121.76093, 36.91723]]]} | Open Access 1 | 16647 | Gonzalez Pocket Park | 19401 | 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.54 | Gonzalez PP | 0 | Local Park 2 | 4 | |
2058 | 2058 | 2057 | {"type": "Polygon", "coordinates": [[[-121.95043, 36.97188], [-121.95042, 36.97215], [-121.95028, 36.97215], [-121.95027, 36.9722], [-121.95018, 36.9722], [-121.95017, 36.97226], [-121.95012, 36.97226], [-121.95011, 36.97223], [-121.94981, 36.97222], [-121.94978, 36.97206], [-121.9495, 36.97211], [-121.94917, 36.97222], [-121.94911, 36.97208], [-121.94946, 36.97193], [-121.94966, 36.9719], [-121.94988, 36.97181], [-121.94992, 36.97193], [-121.95024, 36.97188], [-121.95043, 36.97188]]]} | Open Access 1 | 15694 | Esplanade Park | 18715 | 1044 | Capitola, City of 112 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | Santa Cruz 5 | 0.795 | Esplanade Park | 0 | Local Park 2 | 4 | |
2247 | 2247 | 2246 | {"type": "Polygon", "coordinates": [[[-122.02181, 36.98457], [-122.02176, 36.98553], [-122.02056, 36.9854], [-122.0206, 36.98468], [-122.02121, 36.98477], [-122.02119, 36.98463], [-122.02181, 36.98457]]]} | Open Access 1 | 16660 | Grant Park | 19441 | 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 | 2.364 | Grant Park | 0 | Local Park 2 | 4 | |
2270 | 2270 | 2269 | {"type": "Polygon", "coordinates": [[[-122.04268, 36.9851], [-122.04216, 36.98525], [-122.04214, 36.98529], [-122.04058, 36.98487], [-122.03975, 36.9848], [-122.03804, 36.98451], [-122.0374, 36.98438], [-122.03603, 36.98405], [-122.03515, 36.98388], [-122.0354, 36.98291], [-122.03401, 36.98267], [-122.0342, 36.98195], [-122.03441, 36.98116], [-122.03466, 36.9813], [-122.03663, 36.98229], [-122.03688, 36.98236], [-122.03717, 36.98236], [-122.03744, 36.98229], [-122.03785, 36.98207], [-122.03808, 36.98199], [-122.03804, 36.98187], [-122.03777, 36.98195], [-122.0375, 36.9821], [-122.03722, 36.98221], [-122.03691, 36.98222], [-122.03662, 36.98214], [-122.0362, 36.98191], [-122.0367, 36.98134], [-122.03689, 36.98145], [-122.0377, 36.98124], [-122.03766, 36.98111], [-122.03824, 36.98098], [-122.03817, 36.98078], [-122.03928, 36.98077], [-122.03967, 36.98112], [-122.03942, 36.98144], [-122.03976, 36.98163], [-122.04033, 36.98174], [-122.04042, 36.98198], [-122.04035, 36.98198], [-122.03991, 36.98222], [-122.0394, 36.98218], [-122.03898, 36.98231], [-122.03898, 36.98233], [-122.03905, 36.98236], [-122.0393, 36.98253], [-122.03959, 36.98268], [-122.03993, 36.98291], [-122.03978, 36.98305], [-122.04102, 36.9839], [-122.04181, 36.98436], [-122.04268, 36.9851]]]} | Open Access 1 | 16778 | Harvey West Park | 19729 | 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 | 44.086 | Harvey West Park | 0 | Local Park 2 | 4 | |
2323 | 2323 | 2322 | {"type": "Polygon", "coordinates": [[[-122.00075, 36.98632], [-122.00054, 36.98677], [-122.00016, 36.98666], [-122.00036, 36.9862], [-122.00075, 36.98632]]]} | Open Access 1 | 17039 | John Franks Park | 20441 | 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.48 | John Franks Park | 0 | Local Park 2 | 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]);