units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where DES_TP = 2 and MNG_AGENCY = 9 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 34
MNG_AGENCY 1
- Santa Cruz, City of · 34 ✖
DES_TP 1
- Local Park · 34 ✖
ACCESS_TYP 1
- Open Access 34
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 | |
5002 | 5002 | 5001 | {"type": "Polygon", "coordinates": [[[-122.02746, 36.97721], [-122.02743, 36.9773], [-122.02725, 36.9773], [-122.02726, 36.97711], [-122.02728, 36.97708], [-122.02743, 36.97707], [-122.02743, 36.9772], [-122.02746, 36.97721]]]} | Open Access 1 | 659 | Scope Park | 25201 | 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.1 | Scope Park | 0 | Local Park 2 | 4 | |
8031 | 8031 | 8030 | {"type": "Polygon", "coordinates": [[[-122.01756, 36.96672], [-122.0173, 36.96663], [-122.01733, 36.96659], [-122.01729, 36.96651], [-122.01744, 36.96629], [-122.01756, 36.96672]]]} | Open Access 1 | 47740 | Poets Park | 31549 | 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.144 | Poets 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 | |
5070 | 5070 | 5069 | {"type": "Polygon", "coordinates": [[[-122.02709, 36.97727], [-122.02707, 36.9773], [-122.02703, 36.97731], [-122.02661, 36.97724], [-122.02658, 36.97721], [-122.0266, 36.97718], [-122.02675, 36.97712], [-122.02696, 36.97707], [-122.02699, 36.97709], [-122.02705, 36.97717], [-122.02709, 36.97727]]]} | Open Access 1 | 1396 | Town Clock Park | 26487 | 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.187 | Town Clock 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 | |
10045 | 10045 | 10044 | {"type": "Polygon", "coordinates": [[[-122.01725, 36.96579], [-122.01685, 36.96565], [-122.0168, 36.9655], [-122.01713, 36.96543], [-122.01725, 36.96579]]]} | Open Access 1 | 17442 | Beach Flats Park | 15906 | 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.216 | Beach Flats Park | 0 | Local Park 2 | 4 | |
7107 | 7107 | 7106 | {"type": "Polygon", "coordinates": [[[-122.02773, 36.9637], [-122.0276, 36.96381], [-122.02751, 36.96396], [-122.02747, 36.9641], [-122.02747, 36.96425], [-122.02745, 36.96402], [-122.0275, 36.96347], [-122.02767, 36.96347], [-122.02773, 36.9637]]]} | Open Access 1 | 47746 | Chestnut Park | 31555 | 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.218 | Chestnut Park | 0 | Local Park 2 | 4 | |
3717 | 3717 | 3716 | {"type": "Polygon", "coordinates": [[[-122.0257, 36.96018], [-122.02534, 36.95989], [-122.02539, 36.95983], [-122.0254, 36.95974], [-122.02549, 36.95968], [-122.02549, 36.95962], [-122.02565, 36.95962], [-122.02563, 36.95976], [-122.0257, 36.96018]]]} | Open Access 1 | 14027 | Dutra Overlook Park | 18324 | 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.26 | Dutra Overlook 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 | |
2438 | 2438 | 2437 | {"type": "Polygon", "coordinates": [[[-122.02863, 36.95593], [-122.02861, 36.95596], [-122.02851, 36.956], [-122.02848, 36.95631], [-122.02793, 36.95627], [-122.02794, 36.95613], [-122.02828, 36.95611], [-122.0283, 36.95594], [-122.02856, 36.95592], [-122.02855, 36.95583], [-122.02858, 36.95589], [-122.02863, 36.95593]]]} | Open Access 1 | 17339 | Lighthouse Avenue Park | 21230 | 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.353 | Lighthouse Avenue Park | 0 | Local Park 2 | 4 | |
5014 | 5014 | 5013 | {"type": "Polygon", "coordinates": [[[-122.00633, 36.97691], [-122.00584, 36.97704], [-122.00573, 36.97677], [-122.00622, 36.97664], [-122.00633, 36.97691]]]} | Open Access 1 | 1067 | Star of the Sea Park | 25799 | 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.362 | Star of the Sea Park | 0 | Local Park 2 | 4 | |
8032 | 8032 | 8031 | {"type": "Polygon", "coordinates": [[[-122.00315, 36.99207], [-122.00298, 36.99208], [-122.00296, 36.99196], [-122.00293, 36.99189], [-122.00287, 36.99179], [-122.0028, 36.99172], [-122.00261, 36.9916], [-122.00237, 36.99154], [-122.00238, 36.99124], [-122.00266, 36.99124], [-122.00275, 36.99151], [-122.00287, 36.99159], [-122.00294, 36.99177], [-122.00306, 36.99194], [-122.00312, 36.99194], [-122.00315, 36.99207]]]} | Open Access 1 | 47742 | Pacheco Dog Park | 31551 | 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.466 | Pacheco Dog 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 | |
4208 | 4208 | 4207 | {"type": "Polygon", "coordinates": [[[-122.02155, 36.96974], [-122.02111, 36.96979], [-122.02079, 36.96995], [-122.02073, 36.96988], [-122.02065, 36.96982], [-122.02097, 36.96956], [-122.02107, 36.96963], [-122.02141, 36.96939], [-122.02149, 36.96952], [-122.02155, 36.96974]]]} | Open Access 1 | 44946 | Riverside Gardens Park | 24449 | 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.519 | Riverside Gardens Park | 0 | Local Park 2 | 4 | |
8033 | 8033 | 8032 | {"type": "Polygon", "coordinates": [[[-122.02249, 36.97118], [-122.02245, 36.97129], [-122.02235, 36.97138], [-122.02232, 36.97139], [-122.02224, 36.97135], [-122.02216, 36.97136], [-122.02212, 36.97139], [-122.0221, 36.97143], [-122.02209, 36.97151], [-122.02204, 36.97153], [-122.02199, 36.97152], [-122.0221, 36.9713], [-122.02215, 36.97116], [-122.02217, 36.97098], [-122.02217, 36.97074], [-122.02221, 36.97055], [-122.02225, 36.97048], [-122.02233, 36.97054], [-122.02248, 36.971], [-122.02249, 36.97118]]]} | Open Access 1 | 47743 | Mimi De Marta Dog Park | 31552 | 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.582 | Mimi De Marta Dog Park | 0 | Local Park 2 | 4 | |
7522 | 7522 | 7521 | {"type": "Polygon", "coordinates": [[[-122.02546, 36.95999], [-122.02535, 36.96016], [-122.02541, 36.96029], [-122.02538, 36.96047], [-122.02509, 36.96091], [-122.02489, 36.96096], [-122.0251, 36.96127], [-122.02479, 36.96101], [-122.02537, 36.95992], [-122.02546, 36.95999]]]} | Open Access 1 | 10873 | Cowell's Beach | 17729 | 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.596 | Cowell's Beach | 0 | Local Park 2 | 4 | |
10214 | 10214 | 10213 | {"type": "Polygon", "coordinates": [[[-122.03044, 36.97831], [-122.02973, 36.97823], [-122.02988, 36.97749], [-122.03014, 36.97746], [-122.03044, 36.97831]]]} | Open Access 1 | 17863 | Mission Plaza Park | 22309 | 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.937 | Mission Plaza 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 |
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]);