units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
72 rows where MNG_AGENCY = 9 and MNG_AG_TYP = 2 sorted by map
This data as json, copyable, CSV (advanced)
DES_TP 9
- Local Park 29
- Local Other or Unknown 10
- Local Recreation Area 7
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8651 | 8651 | 8650 | {"type": "Polygon", "coordinates": [[[-122.00352, 36.97672], [-122.00349, 36.9767], [-122.00345, 36.97669], [-122.00143, 36.97676], [-122.00143, 36.9768], [-122.00135, 36.97681], [-122.00097, 36.97674], [-122.00083, 36.9766], [-122.00067, 36.9764], [-122.00068, 36.97634], [-122.00061, 36.97633], [-122.0002, 36.97608], [-122.00016, 36.97607], [-121.99929, 36.97705], [-121.99976, 36.97735], [-121.99928, 36.97796], [-121.99894, 36.97942], [-121.99876, 36.97914], [-121.99716, 36.97975], [-121.99786, 36.98139], [-121.99756, 36.98151], [-121.99766, 36.98175], [-121.99729, 36.98179], [-121.9969, 36.98173], [-121.99653, 36.98186], [-121.99634, 36.98152], [-121.99609, 36.9815], [-121.99594, 36.98168], [-121.99572, 36.98215], [-121.995, 36.98232], [-121.99482, 36.98217], [-121.99446, 36.98273], [-121.99437, 36.98294], [-121.99454, 36.98314], [-121.99414, 36.98273], [-121.99435, 36.98244], [-121.99461, 36.98219], [-121.99485, 36.98202], [-121.99526, 36.98179], [-121.99541, 36.98169], [-121.99554, 36.98158], [-121.99567, 36.98143], [-121.99581, 36.98119], [-121.99588, 36.98095], [-121.99589, 36.98083], [-121.99588, 36.98076], [-121.9958, 36.98054], [-121.99575, 36.98045], [-121.99562, 36.98029], [-121.99545, 36.98015], [-121.99532, 36.98008], [-121.99512, 36.97999], [-121.9948, 36.9798], [-121.99456, 36.97969], [-121.9943, 36.97961], [-121.99396, 36.97954], [-121.99372, 36.97951], [-121.99341, 36.97951], [-121.99254, 36.97942], [-121.99245, 36.97924], [-121.99244, 36.97915], [-121.99244, 36.97905], [-121.99248, 36.97895], [-121.99253, 36.97885], [-121.9926, 36.97877], [-121.99284, 36.97871], [-121.99317, 36.97867], [-121.99356, 36.97869], [-121.9939, 36.97876], [-121.99433, 36.97892], [-121.99453, 36.97895], [-121.99471, 36.97894], [-121.99488, 36.97889], [-121.99502, 36.97883], [-121.99513, 36.97876], [-121.99517, 36.97859], [-121.99517, 36.97837], [-121.99524, 36.97812], [-121.99501, 36.97802], [-121.99523, 36.97759], [-121.9951, 36.97763], [-121.99496, 36.97764], [-121.99484, 36.97763], [-121.99466, 36.97759], [-121.99457, 36.97754], [-121.99452, 36.97748], [-121.9945, 36.97741], [-121.99452, 36.97733], [-121.99458, 36.97725], [-121.99468, 36.9772], [-121.99506, 36.97719], [-121.99535, 36.97715], [-121.99545, 36.9771], [-121.99554, 36.97702], [-121.9956, 36.97693], [-121.99562, 36.97685], [-121.99564, 36.97649], [-121.99572, 36.9762], [-121.99567, 36.97596], [-121.99566, 36.97575], [-121.9957, 36.97557], [-121.99579, 36.9754], [-121.99589, 36.97527], [-121.996, 36.97515], [-121.99617, 36.97503], [-121.99634, 36.97494], [-121.99652, 36.97476], [-121.99661, 36.97458], [-121.99668, 36.97432], [-121.99673, 36.97418], [-121.9968, 36.97407], [-121.99692, 36.97392], [-121.99708, 36.97378], [-121.99722, 36.97369], [-121.99739, 36.97361], [-121.99761, 36.97354], [-121.99775, 36.97351], [-121.99776, 36.97363], [-121.9978, 36.97379], [-121.99782, 36.97379], [-121.99803, 36.97424], [-121.99828, 36.9747], [-121.99862, 36.97512], [-121.99869, 36.97518], [-121.99941, 36.97431], [-121.99953, 36.97382], [-121.99994, 36.97321], [-122.00014, 36.9732], [-122.00076, 36.97355], [-122.00098, 36.97327], [-122.00129, 36.97349], [-122.00162, 36.97518], [-122.00141, 36.97631], [-122.00152, 36.97632], [-122.00164, 36.97635], [-122.00176, 36.97644], [-122.00139, 36.97647], [-122.00137, 36.97654], [-122.00139, 36.97662], [-122.00246, 36.97659], [-122.00256, 36.97654], [-122.00259, 36.97645], [-122.00291, 36.97641], [-122.00295, 36.97657], [-122.00347, 36.97655], [-122.00352, 36.97672]]]} | Open Access 1 | 13862 | Arana Gulch | 15553 | 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 | 81.713 | Arana Gulch | 0 | None 724 | ||
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 | |
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 | |
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 | |
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 | |
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 | |
2688 | 2688 | 2687 | {"type": "Polygon", "coordinates": [[[-122.01418, 36.96968], [-122.01346, 36.9699], [-122.01357, 36.97013], [-122.01289, 36.97037], [-122.01274, 36.97007], [-122.01262, 36.97002], [-122.01222, 36.9703], [-122.01215, 36.97025], [-122.01214, 36.97016], [-122.01227, 36.96991], [-122.01343, 36.96964], [-122.01338, 36.96879], [-122.01362, 36.96851], [-122.01376, 36.96857], [-122.01418, 36.96968]]]} | Open Access 1 | 18246 | Ocean View Park | 23061 | 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 | 3.067 | Ocean View Park | 0 | Local Park 2 | 4 | |
12861 | 12861 | 12860 | {"type": "Polygon", "coordinates": [[[-122.0162, 36.97129], [-122.01574, 36.97142], [-122.01471, 36.97002], [-122.01446, 36.9696], [-122.01418, 36.96968], [-122.01376, 36.96857], [-122.01402, 36.96864], [-122.01411, 36.96865], [-122.01417, 36.96863], [-122.01476, 36.96958], [-122.01477, 36.96999], [-122.01484, 36.9701], [-122.01515, 36.97001], [-122.01531, 36.97035], [-122.01569, 36.97024], [-122.01601, 36.97096], [-122.01576, 36.97104], [-122.01584, 36.97124], [-122.0161, 36.97117], [-122.0162, 36.97129]]]} | Open Access 1 | 44542 | Jessie Street Marsh | 20407 | 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 | 3.231 | Jessie Street Marsh | None 1123 | |||
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
5903 | 5903 | 5902 | {"type": "Polygon", "coordinates": [[[-122.02272, 36.97699], [-122.02204, 36.97717], [-122.02161, 36.97613], [-122.02147, 36.97605], [-122.02163, 36.97583], [-122.02172, 36.97558], [-122.02173, 36.97533], [-122.02168, 36.9747], [-122.02184, 36.97468], [-122.02205, 36.97473], [-122.0222, 36.97481], [-122.02227, 36.97488], [-122.02232, 36.97495], [-122.02235, 36.97504], [-122.02243, 36.97588], [-122.02248, 36.9762], [-122.02256, 36.97652], [-122.02272, 36.97699]]]} | Open Access 1 | 354 | San Lorenzo Park | 24926 | 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 | 4.282 | San Lorenzo 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 | |
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 | |
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 |
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]);