units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
72 rows where MNG_AGENCY = 9 sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST, GAP_STS
DES_TP 14
- Local Park 34
- Local Recreation Area 14
- Local Other or Unknown 12
- Local Conservation Area 2
- None 1
- None 1
- 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 72
MNG_AGENCY 1
- Santa Cruz, City of · 72 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16532 | 16532 | 16531 | {"type": "Polygon", "coordinates": [[[-122.12131, 36.99905], [-122.12095, 36.99935], [-122.12072, 36.99916], [-122.12107, 36.99886], [-122.12131, 36.99905]]]} | Open Access 1 | 1870 | Wilder Ranch State Park | 27506 | 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 | http://www.parks.ca.gov/?page_id=549 | Santa Cruz 5 | 0.336 | Wilder Ranch SP | 1974 | None 1411 | |
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 | |
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 | |
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 | |||
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 | |
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 | |
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 | |
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 | |
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 | |
13334 | 13334 | 13333 | {"type": "Polygon", "coordinates": [[[-122.03292, 36.98026], [-122.03259, 36.98011], [-122.0326, 36.97995], [-122.03254, 36.97982], [-122.03278, 36.97971], [-122.03286, 36.97973], [-122.03292, 36.98026]]]} | Open Access 1 | 35410 | Santa Cruz holding 9 | 25079 | 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.326 | Santa Cruz holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13207 | 13207 | 13206 | {"type": "Polygon", "coordinates": [[[-121.97361, 36.96111], [-121.97328, 36.96111], [-121.97328, 36.96082], [-121.97361, 36.96083], [-121.97361, 36.96111]]]} | Open Access 1 | 35236 | Santa Cruz holding 8 | 25078 | 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.232 | Santa Cruz holding 8 | 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 | |
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 | |
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 | |
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 | |
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 | |
13942 | 13942 | 13941 | {"type": "Polygon", "coordinates": [[[-121.97198, 36.96602], [-121.97144, 36.96602], [-121.97144, 36.96579], [-121.97198, 36.96579], [-121.97198, 36.96602]]]} | Open Access 1 | 36563 | Santa Cruz holding 15 | 25070 | 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.306 | Santa Cruz holding 15 | 0 | Local Other or Unknown 14 | 4 | |
13277 | 13277 | 13276 | {"type": "Polygon", "coordinates": [[[-122.0466, 36.97904], [-122.04636, 36.97912], [-122.04618, 36.97894], [-122.0463, 36.97884], [-122.0458, 36.97834], [-122.04591, 36.97836], [-122.0466, 36.97904]]]} | Open Access 1 | 35330 | Santa Cruz holding 14 | 28172 | 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.279 | Santa Cruz holding 14 | 0 | Local Other or Unknown 14 | 4 | |
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]);