units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
72 rows where MNG_AGENCY = 9 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 12
- Local Park 23
- Local Recreation Area 14
- Local Other or Unknown 5
- Local Conservation Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 52
MNG_AGENCY 1
- Santa Cruz, City of · 52 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
456 | 456 | 455 | {"type": "MultiPolygon", "coordinates": [[[[-122.00177, 36.96808], [-122.00152, 36.9681], [-122.0015, 36.96795], [-122.00161, 36.96797], [-122.00162, 36.96796], [-122.00175, 36.96793], [-122.00177, 36.96808]]], [[[-122.00288, 36.96971], [-122.00236, 36.97013], [-122.00204, 36.97012], [-122.00244, 36.9697], [-122.00288, 36.96971]]]]} | Open Access 1 | 1471 | Twin Lakes | 26614 | 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.484 | Twin Lakes | None 47 | |||
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 | |
7994 | 7994 | 7993 | {"type": "Polygon", "coordinates": [[[-122.02588, 36.95769], [-122.02579, 36.95769], [-122.02572, 36.95759], [-122.02545, 36.95751], [-122.02541, 36.95747], [-122.02521, 36.95717], [-122.02521, 36.95714], [-122.02527, 36.95711], [-122.02526, 36.95706], [-122.02516, 36.95695], [-122.02507, 36.95677], [-122.02502, 36.95673], [-122.02487, 36.95665], [-122.02474, 36.95651], [-122.0246, 36.95643], [-122.02461, 36.9564], [-122.02466, 36.95632], [-122.02474, 36.95631], [-122.02507, 36.95669], [-122.02552, 36.95727], [-122.02588, 36.95769]]]} | Open Access 1 | 10990 | Cowell's Cove | 17730 | 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.556 | Cowell's Cove | None 665 | |||
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 | |
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 | |
4891 | 4891 | 4890 | {"type": "Polygon", "coordinates": [[[-122.05012, 36.9742], [-122.04978, 36.9744], [-122.04888, 36.97348], [-122.04933, 36.97374], [-122.04979, 36.97397], [-122.04986, 36.97393], [-122.05012, 36.9742]]]} | Open Access 1 | 35360 | Santa Cruz holding 2 | 25072 | 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.681 | Santa Cruz holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13206 | 13206 | 13205 | {"type": "Polygon", "coordinates": [[[-122.07216, 37.00872], [-122.07141, 37.00885], [-122.07125, 37.00838], [-122.07203, 37.00825], [-122.07216, 37.00872]]]} | Open Access 1 | 35234 | Santa Cruz holding 7 | 28173 | 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.932 | Santa Cruz holding 7 | 0 | Local Other or Unknown 14 | 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 | |
13197 | 13197 | 13196 | {"type": "Polygon", "coordinates": [[[-122.00596, 37.00462], [-122.00509, 37.00463], [-122.00509, 37.00415], [-122.00596, 37.00415], [-122.00596, 37.00462]]]} | Open Access 1 | 35209 | Santa Cruz holding 5 | 28176 | 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.015 | Santa Cruz holding 5 | 0 | Local Other or Unknown 14 | 4 | |
7362 | 7362 | 7361 | {"type": "MultiPolygon", "coordinates": [[[[-122.03538, 36.95212], [-122.0353, 36.9523], [-122.03511, 36.95225], [-122.03518, 36.95204], [-122.03522, 36.95204], [-122.03538, 36.95212]]], [[[-122.03616, 36.95249], [-122.03607, 36.9526], [-122.0358, 36.95246], [-122.03587, 36.95235], [-122.03616, 36.95249]]], [[[-122.03706, 36.95292], [-122.03667, 36.95284], [-122.03627, 36.95268], [-122.03635, 36.95258], [-122.03706, 36.95292]]], [[[-122.04335, 36.95119], [-122.04321, 36.95125], [-122.04297, 36.9513], [-122.04287, 36.95135], [-122.04265, 36.95153], [-122.04235, 36.95186], [-122.04223, 36.95178], [-122.04223, 36.95171], [-122.04231, 36.9516], [-122.04243, 36.95156], [-122.04264, 36.95152], [-122.04267, 36.95147], [-122.04272, 36.95142], [-122.04272, 36.95138], [-122.04268, 36.95131], [-122.04269, 36.95129], [-122.04282, 36.95131], [-122.0429, 36.9513], [-122.04301, 36.95127], [-122.04334, 36.95113], [-122.04335, 36.95119]]], [[[-122.04432, 36.95078], [-122.04383, 36.95099], [-122.04383, 36.95099], [-122.04381, 36.9509], [-122.04385, 36.95088], [-122.04395, 36.95083], [-122.04403, 36.95082], [-122.0442, 36.95071], [-122.0443, 36.95067], [-122.04432, 36.95078]]], [[[-122.04653, 36.94982], [-122.04617, 36.95006], [-122.04599, 36.95014], [-122.04589, 36.95017], [-122.04568, 36.95017], [-122.0455, 36.95021], [-122.04547, 36.95006], [-122.04562, 36.95006], [-122.04575, 36.95009], [-122.04581, 36.95012], [-122.04591, 36.95012], [-122.04602, 36.95005], [-122.04606, 36.94995], [-122.04619, 36.94984], [-122.0465, 36.94968], [-122.04653, 36.94982]]]]} | Open Access 1 | 7318 | Cliff Drive Open Space | 17423 | 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.086 | Cliff Drive OS | 0 | Local Recreation Area 3 | 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 | |
8035 | 8035 | 8034 | {"type": "Polygon", "coordinates": [[[-122.04156, 36.95295], [-122.04144, 36.95305], [-122.04134, 36.95309], [-122.04096, 36.95317], [-122.04078, 36.95315], [-122.04052, 36.95317], [-122.03981, 36.95319], [-122.03973, 36.95322], [-122.03978, 36.953], [-122.03992, 36.95298], [-122.04, 36.95295], [-122.04016, 36.95299], [-122.04027, 36.95288], [-122.04041, 36.95283], [-122.04049, 36.95288], [-122.04055, 36.95289], [-122.04069, 36.9528], [-122.04101, 36.95277], [-122.04127, 36.95271], [-122.04134, 36.95267], [-122.04155, 36.95282], [-122.04156, 36.95295]]]} | Open Access 1 | 47749 | Mitchell's Cove | 31558 | 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.359 | Mitchell's Cove | None 669 | |||
13235 | 13235 | 13234 | {"type": "Polygon", "coordinates": [[[-122.04834, 36.97092], [-122.04803, 36.971], [-122.04792, 36.97081], [-122.04775, 36.97056], [-122.04759, 36.97036], [-122.04739, 36.97016], [-122.04722, 36.97001], [-122.04691, 36.96978], [-122.04632, 36.96946], [-122.04639, 36.96937], [-122.04751, 36.96975], [-122.04776, 36.9702], [-122.04834, 36.97092]]]} | Open Access 1 | 35279 | Santa Cruz holding 12 | 25067 | 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.496 | Santa Cruz holding 12 | 0 | Local Other or Unknown 14 | 4 | |
10192 | 10192 | 10191 | {"type": "MultiPolygon", "coordinates": [[[[-122.01868, 36.96877], [-122.01776, 36.96884], [-122.01776, 36.96884], [-122.01777, 36.96872], [-122.01868, 36.96877]]], [[[-122.02196, 36.9699], [-122.02157, 36.9693], [-122.02145, 36.96919], [-122.0213, 36.9691], [-122.02102, 36.96902], [-122.01961, 36.96879], [-122.01961, 36.96875], [-122.01964, 36.96871], [-122.01975, 36.96866], [-122.01999, 36.96861], [-122.02034, 36.96862], [-122.02092, 36.96876], [-122.02124, 36.96888], [-122.02152, 36.96905], [-122.02174, 36.96928], [-122.02185, 36.96951], [-122.02196, 36.9699]]], [[[-122.02199, 36.97037], [-122.02192, 36.97061], [-122.02192, 36.9711], [-122.02181, 36.97136], [-122.02165, 36.97155], [-122.02162, 36.97156], [-122.02157, 36.97153], [-122.0216, 36.97154], [-122.02165, 36.97153], [-122.02178, 36.97134], [-122.02185, 36.97105], [-122.02181, 36.97064], [-122.0219, 36.97038], [-122.02199, 36.97037]]]]} | Open Access 1 | 17823 | Mike Fox Park | 22212 | 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.596 | Mike Fox Park | 0 | Local Park 2 | 4 | |
5145 | 5145 | 5144 | {"type": "Polygon", "coordinates": [[[-122.02849, 36.9697], [-122.02756, 36.9698], [-122.02735, 36.96901], [-122.0282, 36.96891], [-122.02849, 36.9697]]]} | Open Access 1 | 17304 | Laurel Park | 21102 | 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.769 | Laurel 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]);