units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
72 rows where MNG_AGENCY = 9 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
3214 | 3214 | 3213 | {"type": "Polygon", "coordinates": [[[-122.039, 37.00381], [-122.03783, 37.00449], [-122.03729, 37.00412], [-122.03759, 37.00374], [-122.03715, 37.00342], [-122.03683, 37.00294], [-122.03674, 37.00261], [-122.03807, 37.00344], [-122.039, 37.00381]]]} | Restricted Access 2 | 367 | San Lorenzo River Open Space | 28168 | 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.51 | San Lorenzo River OS | 0 | Local Recreation Area 3 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
6292 | 6292 | 6291 | {"type": "Polygon", "coordinates": [[[-122.0426, 36.96846], [-122.04258, 36.96848], [-122.04217, 36.96826], [-122.04196, 36.96848], [-122.04196, 36.96849], [-122.04174, 36.96872], [-122.04082, 36.96825], [-122.04098, 36.96806], [-122.04084, 36.96797], [-122.04115, 36.96767], [-122.04131, 36.96775], [-122.04128, 36.96779], [-122.04145, 36.96788], [-122.04149, 36.96785], [-122.04163, 36.96792], [-122.04192, 36.96763], [-122.04206, 36.96771], [-122.04178, 36.96801], [-122.0426, 36.96846]]]} | Open Access 1 | 1406 | Trescony Park | 26523 | 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.009 | Trescony 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 | |
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 | |
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 | |
8025 | 8025 | 8024 | {"type": "Polygon", "coordinates": [[[-122.05273, 36.95394], [-122.05056, 36.95417], [-122.05049, 36.95375], [-122.05054, 36.95373], [-122.05046, 36.95325], [-122.05095, 36.95326], [-122.05092, 36.95302], [-122.05097, 36.95299], [-122.05102, 36.95327], [-122.05137, 36.95332], [-122.05138, 36.9533], [-122.05155, 36.95333], [-122.05156, 36.95335], [-122.05229, 36.95353], [-122.05264, 36.95365], [-122.05262, 36.95338], [-122.05269, 36.95341], [-122.05273, 36.95394]]]} | Open Access 1 | 47739 | Sgt. Charles Derby and Skate Park | 31548 | 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.649 | Sgt. Charles Derby and Skate Park | 0 | Local Recreation Area 3 | 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]);