superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
69 rows where MNG_AGENCY = 9 sorted by rowid descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
11610 | 11610 | 11609 | {"type": "Polygon", "coordinates": [[[-121.98909, 36.98933], [-121.98884, 36.98949], [-121.98898, 36.99029], [-121.98882, 36.99033], [-121.98886, 36.99057], [-121.98896, 36.99057], [-121.989, 36.99078], [-121.98861, 36.99092], [-121.98844, 36.99039], [-121.98852, 36.9899], [-121.98821, 36.98938], [-121.9881, 36.98934], [-121.98786, 36.98932], [-121.98809, 36.98905], [-121.98873, 36.98887], [-121.98909, 36.98933]]]} | Open Access 1 | Arana Gulch Creek / Brookwood Drive | 28156 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 2.641 | Arana Gulch Creek / Brookwood Drive | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
9309 | 9309 | 9308 | {"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.04692, 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 | 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 | 1.496 | Santa Cruz holding 12 | ||
9308 | 9308 | 9307 | {"type": "Polygon", "coordinates": [[[-122.05824, 36.96592], [-122.05801, 36.96601], [-122.05789, 36.96585], [-122.05811, 36.96573], [-122.05824, 36.96592]]]} | Open Access 1 | Santa Cruz holding 1 | 25064 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 0.127 | Santa Cruz holding 1 | ||
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 | ||
9211 | 9211 | 9210 | {"type": "Polygon", "coordinates": [[[-122.02272, 36.97699], [-122.02204, 36.97717], [-122.02161, 36.97614], [-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 | San Lorenzo Park | 24926 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 4.283 | San Lorenzo Park | ||
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 |
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]);