superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
65 rows where ACCESS_TYP = 1 and MNG_AGENCY = 9
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7300 | 7300 | 7299 | {"type": "Polygon", "coordinates": [[[-122.06068, 36.95436], [-122.06068, 36.9544], [-122.06006, 36.95439], [-122.05945, 36.95444], [-122.05875, 36.95451], [-122.05874, 36.95447], [-122.0599, 36.95436], [-122.06068, 36.95436]]]} | Open Access 1 | Natural Bridges State Beach | http://www.parks.ca.gov/?page_id=541 | 22670 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 0.17 | Natural Bridges SB | 1933 |
7330 | 7330 | 7329 | {"type": "MultiPolygon", "coordinates": [[[[-122.03528, 36.96378], [-122.03526, 36.96405], [-122.03416, 36.96371], [-122.03415, 36.96372], [-122.03417, 36.96386], [-122.03416, 36.96407], [-122.03419, 36.96417], [-122.03422, 36.96421], [-122.03422, 36.96434], [-122.03426, 36.96446], [-122.03425, 36.96451], [-122.03421, 36.96456], [-122.03428, 36.9646], [-122.03438, 36.96459], [-122.03441, 36.96463], [-122.0344, 36.9647], [-122.03431, 36.96482], [-122.03426, 36.96494], [-122.03425, 36.96502], [-122.03427, 36.96513], [-122.03431, 36.96521], [-122.03437, 36.96529], [-122.03457, 36.96543], [-122.03465, 36.96552], [-122.03477, 36.9657], [-122.03481, 36.96589], [-122.03478, 36.96601], [-122.03474, 36.96604], [-122.03469, 36.96605], [-122.03463, 36.96602], [-122.03449, 36.96592], [-122.0344, 36.96581], [-122.03433, 36.96577], [-122.0342, 36.96577], [-122.03414, 36.9658], [-122.03409, 36.96584], [-122.03406, 36.96596], [-122.03405, 36.96616], [-122.0341, 36.9662], [-122.03419, 36.96622], [-122.03421, 36.96624], [-122.03418, 36.96634], [-122.03411, 36.9664], [-122.03411, 36.96647], [-122.03414, 36.96653], [-122.03423, 36.96664], [-122.03429, 36.96674], [-122.03433, 36.96686], [-122.03434, 36.96695], [-122.03431, 36.96706], [-122.03423, 36.96716], [-122.03411, 36.96722], [-122.034, 36.96723], [-122.03386, 36.96721], [-122.03385, 36.96717], [-122.03369, 36.96714], [-122.03373, 36.96697], [-122.03367, 36.96648], [-122.03363, 36.96629], [-122.03361, 36.96599], [-122.03355, 36.9659], [-122.03355, 36.96563], [-122.03353, 36.96552], [-122.03358, 36.96539], [-122.03357, 36.96511], [-122.03364, 36.96505], [-122.03362, 36.96472], [-122.03311, 36.96443], [-122.03305, 36.96431], [-122.03252, 36.96408], [-122.0324, 36.96411], [-122.03209, 36.96395], [-122.03195, 36.96405], [-122.03157, 36.96414], [-122.03118, 36.96414], [-122.03073, 36.9655], [-122.03044, 36.96557], [-122.03041, 36.96549], [-122.03047, 36.96536], [-122.03046, 36.96523], [-122.03044, 36.96514], [-122.03034, 36.96505], [-122.03018, 36.96498], [-122.03003, 36.96497], [-122.02984, 36.96489], [-122.02967, 36.9648], [-122.0295, 36.96479], [-122.02935, 36.96475], [-122.02923, 36.96466], [-122.0291, 36.9645], [-122.0289, 36.96431], [-122.02876, 36.96423], [-122.02841, 36.96395], [-122.02805, 36.96355], [-122.02796, 36.96353], [-122.02789, 36.96354], [-122.02784, 36.96358], [-122.0278, 36.96366], [-122.02773, 36.9637], [-122.02767, 36.96348], [-122.0275, 36.96347], [-122.02762, 36.96289], [-122.02767, 36.96274], [-122.02812, 36.96176], [-122.02833, 36.96151], [-122.02862, 36.96125], [-122.02883, 36.96111], [-122.02911, 36.96098], [-122.02918, 36.96105], [-122.02904, 36.96118], [-122.02909, 36.96131], [-122.02909, 36.96137], [-122.02895, 36.96157], [-122.02899, 36.96168], [-122.02918, 36.96176], [-122.02938, 36.96165], [-122.02944, 36.96165], [-122.02947, 36.9617], [-122.02948, 36.9618], [-122.02954, 36.96186], [-122.02967, 36.9619], [-122.02986, 36.96204], [-122.03047, 36.96219], [-122.03076, 36.96231], [-122.03087, 36.96232], [-122.03126, 36.96248], [-122.03143, 36.96249], [-122.03162, 36.96237], [-122.03173, 36.96236], [-122.03183, 36.96238], [-122.03201, 36.96254], [-122.03213, 36.96258], [-122.03229, 36.96255], [-122.03245, 36.96243], [-122.03265, 36.96242], [-122.03279, 36.96252], [-122.03275, 36.96258], [-122.03275, 36.96259], [-122.03309, 36.96272], [-122.03319, 36.9628], [-122.03359, 36.96279], [-122.03375, 36.9628], [-122.03528, 36.96378]]], [[[-122.03531, 36.96338], [-122.03531, 36.96359], [-122.03313, 36.96215], [-122.03324, 36.962], [-122.03531, 36.96338]]]]} | Open Access 1 | Neary Lagoon Park | 22680 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 41.958 | Neary Lagoon Park | ||
7627 | 7627 | 7626 | {"type": "Polygon", "coordinates": [[[-122.01418, 36.96968], [-122.01347, 36.96989], [-122.01357, 36.97013], [-122.0129, 36.97037], [-122.01274, 36.97007], [-122.01263, 36.97002], [-122.01222, 36.9703], [-122.01215, 36.97025], [-122.01214, 36.97016], [-122.01227, 36.96991], [-122.01342, 36.96964], [-122.01338, 36.96879], [-122.01362, 36.96851], [-122.01376, 36.96857], [-122.01418, 36.96968]]]} | Open Access 1 | Ocean View Park | 23061 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 3.077 | Ocean View Park | ||
8710 | 8710 | 8709 | {"type": "Polygon", "coordinates": [[[-122.03122, 36.97381], [-122.03122, 36.97381], [-122.03111, 36.97409], [-122.03105, 36.97384], [-122.03122, 36.97381]]]} | Open Access 1 | Rincon Park | 24369 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 0.055 | Rincon Park | ||
8759 | 8759 | 8758 | {"type": "Polygon", "coordinates": [[[-122.02155, 36.96974], [-122.02111, 36.96979], [-122.02079, 36.96995], [-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 | Riverside Gardens Park | 24449 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 0.522 | Riverside Gardens Park | ||
9030 | 9030 | 9029 | {"type": "Polygon", "coordinates": [[[-122.05137, 36.97047], [-122.05103, 36.97055], [-122.05096, 36.97049], [-122.05087, 36.97031], [-122.05129, 36.97021], [-122.05137, 36.97047]]]} | Open Access 1 | Round Tree Park | 24704 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 0.27 | Round Tree 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);