superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
69 rows where MNG_AGENCY = 9 sorted by PARK_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: ACRES
Link | rowid | id | map | ACCESS_TYP | PARK_NAME ▲ | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11210 | 11210 | 11209 | {"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 | Wilder Ranch State Park | http://www.parks.ca.gov/?page_id=549 | 27506 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 0.336 | Wilder Ranch SP | 1974 |
11137 | 11137 | 11136 | {"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 | Westlake Park | 27403 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 6.007 | Westlake Park | ||
10575 | 10575 | 10574 | {"type": "Polygon", "coordinates": [[[-122.05625, 36.97294], [-122.05609, 36.97323], [-122.05543, 36.97488], [-122.05427, 36.97499], [-122.05421, 36.97452], [-122.05451, 36.97347], [-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 | University Terrace Park | 26690 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 6.781 | University Terrace Park | ||
10535 | 10535 | 10534 | {"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 | Tyrell Park | 26631 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1.302 | Tyrell Park | ||
9059 | 9059 | 9058 | {"type": "MultiPolygon", "coordinates": [[[[-122.00177, 36.96808], [-122.00152, 36.9681], [-122.0015, 36.96795], [-122.0016, 36.96797], [-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 | Twin Lakes | 26614 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 0.482 | Twin Lakes | ||
10454 | 10454 | 10453 | {"type": "Polygon", "coordinates": [[[-122.0426, 36.96846], [-122.04258, 36.96848], [-122.04217, 36.96826], [-122.04196, 36.96847], [-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.04129, 36.96779], [-122.04144, 36.96788], [-122.04149, 36.96785], [-122.04163, 36.96792], [-122.04192, 36.96763], [-122.04206, 36.96771], [-122.04179, 36.96801], [-122.0426, 36.96846]]]} | Open Access 1 | Trescony Park | 26523 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 2.02 | Trescony Park | ||
10419 | 10419 | 10418 | {"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 | Town Clock Park | 26487 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 0.187 | Town Clock Park | ||
9917 | 9917 | 9916 | {"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 | 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 | 0.362 | Star of the Sea Park | ||
13015 | 13015 | 13014 | {"type": "Polygon", "coordinates": [[[-122.05273, 36.95394], [-122.05056, 36.95417], [-122.05049, 36.95375], [-122.05053, 36.95373], [-122.05046, 36.95325], [-122.05095, 36.95326], [-122.05092, 36.95302], [-122.05097, 36.95299], [-122.05102, 36.95327], [-122.05136, 36.95332], [-122.05138, 36.9533], [-122.05155, 36.95333], [-122.05156, 36.95335], [-122.05229, 36.95353], [-122.05263, 36.95365], [-122.05262, 36.95338], [-122.05269, 36.95341], [-122.05273, 36.95394]]]} | Open Access 1 | 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 | 3.656 | Sgt. Charles Derby and Skate Park | ||
9405 | 9405 | 9404 | {"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.97719], [-122.02746, 36.97721]]]} | Open Access 1 | Scope Park | 25201 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 0.1 | Scope Park | ||
9297 | 9297 | 9296 | {"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 | 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 | 0.326 | Santa Cruz holding 9 | ||
9296 | 9296 | 9295 | {"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 | 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 | 0.232 | Santa Cruz holding 8 | ||
11629 | 11629 | 11628 | {"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 | 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 | 0.932 | Santa Cruz holding 7 | ||
11604 | 11604 | 11603 | {"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 | 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 | 1.014 | Santa Cruz holding 5 | ||
9182 | 9182 | 9181 | {"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 | 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 | 0.09 | Santa Cruz holding 4 | ||
9106 | 9106 | 9105 | {"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 | 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 | 0.121 | Santa Cruz holding 3 | ||
9311 | 9311 | 9310 | {"type": "Polygon", "coordinates": [[[-122.05012, 36.9742], [-122.04978, 36.9744], [-122.04888, 36.97348], [-122.04933, 36.97374], [-122.04978, 36.97396], [-122.04986, 36.97393], [-122.05012, 36.9742]]]} | Open Access 1 | 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 | 0.681 | Santa Cruz holding 2 | ||
9310 | 9310 | 9309 | {"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 | 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 | 0.306 | Santa Cruz holding 15 | ||
11628 | 11628 | 11627 | {"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 | 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 | 0.28 | Santa Cruz holding 14 | ||
11520 | 11520 | 11519 | {"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 | 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 | 0.556 | Santa Cruz holding 13 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);