superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 144 sorted by SUID_NMA 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13382 | 13382 | 13381 | {"type": "Polygon", "coordinates": [[[-122.64921, 38.26791], [-122.64874, 38.26797], [-122.64866, 38.26796], [-122.64862, 38.26791], [-122.64852, 38.26752], [-122.64921, 38.26791]]]} | Open Access 1 | Maria Pocket Park | 33530 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 0.325 | Maria PP | ||
544 | 544 | 543 | {"type": "Polygon", "coordinates": [[[-122.62098, 38.22346], [-122.62096, 38.22431], [-122.62061, 38.22421], [-122.62065, 38.22397], [-122.62047, 38.22393], [-122.62007, 38.22387], [-122.61965, 38.22384], [-122.61933, 38.22378], [-122.61923, 38.22346], [-122.61889, 38.22338], [-122.61885, 38.22347], [-122.61883, 38.22363], [-122.61874, 38.22359], [-122.61874, 38.2235], [-122.61879, 38.22337], [-122.61861, 38.22326], [-122.62098, 38.22346]]]} | Open Access 1 | Riverview Park | 33529 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 2.479 | Riverview Park | ||
14063 | 14063 | 14062 | {"type": "Polygon", "coordinates": [[[-122.5889, 38.23692], [-122.58862, 38.23722], [-122.58856, 38.23723], [-122.58789, 38.23684], [-122.58781, 38.23683], [-122.58773, 38.23685], [-122.58813, 38.2364], [-122.58837, 38.23654], [-122.58839, 38.23659], [-122.58843, 38.23663], [-122.58889, 38.23687], [-122.5889, 38.23692]]]} | Open Access 1 | Southgate Park | 33528 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1.079 | Southgate Park | ||
13130 | 13130 | 13129 | {"type": "Polygon", "coordinates": [[[-122.61166, 38.265], [-122.61098, 38.26576], [-122.60488, 38.26235], [-122.6057, 38.26144], [-122.60662, 38.26161], [-122.60843, 38.26231], [-122.60952, 38.26339], [-122.61136, 38.26423], [-122.61166, 38.265]]]} | Open Access 1 | Petaluma Community Sports Fields | http://cityofpetaluma.net/parksnrec/parks-pages/petaluma-comm-sport-fields.html | 31786 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 24.891 | Petaluma Community Sports Fields | 2015 |
11625 | 11625 | 11624 | {"type": "Polygon", "coordinates": [[[-122.6552, 38.2257], [-122.65292, 38.22757], [-122.65284, 38.22751], [-122.65413, 38.22646], [-122.65413, 38.22558], [-122.6552, 38.2257]]]} | No Public Access 3 | City of Petaluma Holding | 28169 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1.652 | City of Petaluma Holding | ||
11611 | 11611 | 11610 | {"type": "MultiPolygon", "coordinates": [[[[-122.58307, 38.22933], [-122.58238, 38.23007], [-122.57621, 38.22666], [-122.57633, 38.22647], [-122.57659, 38.22629], [-122.57685, 38.22617], [-122.5772, 38.22588], [-122.57777, 38.22573], [-122.57799, 38.2256], [-122.57872, 38.22483], [-122.57915, 38.22443], [-122.58083, 38.22535], [-122.58089, 38.22576], [-122.58041, 38.22629], [-122.58131, 38.22682], [-122.58105, 38.22709], [-122.58105, 38.22711], [-122.5828, 38.22811], [-122.58307, 38.22933]]], [[[-122.59172, 38.21766], [-122.59033, 38.21764], [-122.58878, 38.21814], [-122.58712, 38.21833], [-122.58596, 38.21827], [-122.58479, 38.21783], [-122.58391, 38.21714], [-122.58327, 38.21602], [-122.58331, 38.21486], [-122.58381, 38.21407], [-122.58571, 38.21271], [-122.58639, 38.21185], [-122.58784, 38.2134], [-122.59172, 38.21766]]]]} | No Public Access 3 | Petaluma Marsh Acquisition, Enhancement and Access | 28158 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 112.945 | Petaluma Marsh Acquisition, Enhancement and Access | ||
11350 | 11350 | 11349 | {"type": "Polygon", "coordinates": [[[-122.60701, 38.25607], [-122.60694, 38.25617], [-122.60509, 38.25511], [-122.60382, 38.25436], [-122.60364, 38.25435], [-122.60308, 38.25411], [-122.60224, 38.25394], [-122.6015, 38.25388], [-122.59933, 38.25266], [-122.59815, 38.2521], [-122.5976, 38.25189], [-122.59728, 38.25161], [-122.5979, 38.25094], [-122.59977, 38.25207], [-122.6004, 38.25233], [-122.60232, 38.25335], [-122.60273, 38.25336], [-122.6031, 38.25331], [-122.60329, 38.25354], [-122.60364, 38.25375], [-122.60397, 38.25382], [-122.60395, 38.25404], [-122.60415, 38.25442], [-122.60701, 38.25607]]]} | Open Access 1 | Wiseman Airport Park | 27661 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 14.075 | Wiseman Airport Park | ||
11176 | 11176 | 11175 | {"type": "Polygon", "coordinates": [[[-122.63385, 38.22946], [-122.63338, 38.23023], [-122.63235, 38.22984], [-122.63286, 38.22908], [-122.63385, 38.22946]]]} | Open Access 1 | Wickersham Park | 27484 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 2.304 | Wickersham Park | ||
14793 | 14793 | 14792 | {"type": "Polygon", "coordinates": [[[-122.63563, 38.21005], [-122.63562, 38.21013], [-122.63559, 38.21018], [-122.63506, 38.21055], [-122.63479, 38.21079], [-122.63463, 38.211], [-122.63457, 38.21113], [-122.63449, 38.21118], [-122.63444, 38.21125], [-122.63444, 38.21131], [-122.63448, 38.21139], [-122.63438, 38.21156], [-122.63433, 38.2118], [-122.63408, 38.21197], [-122.63406, 38.21196], [-122.63379, 38.21207], [-122.63266, 38.21208], [-122.63256, 38.21216], [-122.63245, 38.21218], [-122.63236, 38.21224], [-122.63233, 38.21234], [-122.63231, 38.21254], [-122.63193, 38.21255], [-122.63201, 38.2123], [-122.63218, 38.21214], [-122.63234, 38.21206], [-122.63231, 38.21177], [-122.63339, 38.21173], [-122.63364, 38.21166], [-122.6338, 38.21155], [-122.6339, 38.21141], [-122.63393, 38.21131], [-122.63393, 38.21051], [-122.63395, 38.21038], [-122.63418, 38.20984], [-122.63431, 38.20957], [-122.6344, 38.20955], [-122.63532, 38.20982], [-122.63555, 38.20996], [-122.63563, 38.21005]]]} | Open Access 1 | Westridge Open Space | 27418 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 6.72 | Westridge OS | ||
9425 | 9425 | 9424 | {"type": "Polygon", "coordinates": [[[-122.63718, 38.23184], [-122.63689, 38.23236], [-122.6359, 38.23199], [-122.63619, 38.23148], [-122.63718, 38.23184]]]} | Open Access 1 | Walnut Park | 27241 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1.484 | Walnut Park | ||
10131 | 10131 | 10130 | {"type": "Polygon", "coordinates": [[[-122.63156, 38.23591], [-122.63154, 38.23595], [-122.6314, 38.2361], [-122.63078, 38.23576], [-122.63084, 38.23571], [-122.63152, 38.23585], [-122.63156, 38.23591]]]} | Open Access 1 | Sunset Park | 26058 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 0.319 | Sunset Park | ||
10108 | 10108 | 10107 | {"type": "Polygon", "coordinates": [[[-122.64445, 38.25978], [-122.64387, 38.26035], [-122.64379, 38.26048], [-122.64183, 38.2626], [-122.64164, 38.26284], [-122.64161, 38.26295], [-122.64129, 38.26331], [-122.64083, 38.26304], [-122.64127, 38.26254], [-122.64142, 38.26233], [-122.64148, 38.26222], [-122.64164, 38.26174], [-122.64182, 38.26139], [-122.64206, 38.26106], [-122.64226, 38.26086], [-122.64263, 38.26058], [-122.64333, 38.26017], [-122.64353, 38.26001], [-122.64398, 38.25953], [-122.64445, 38.25978]]]} | Open Access 1 | Sunrise Park | 26025 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 7.366 | Sunrise Park | ||
8880 | 8880 | 8879 | {"type": "Polygon", "coordinates": [[[-122.61069, 38.22836], [-122.6083, 38.23106], [-122.60738, 38.23091], [-122.6072, 38.2311], [-122.60692, 38.23105], [-122.60708, 38.23086], [-122.60645, 38.2302], [-122.60684, 38.22947], [-122.60659, 38.22931], [-122.60854, 38.22718], [-122.61069, 38.22836]]]} | Open Access 1 | Rocky Memorial Dog | 24541 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 21.622 | Rocky Memorial Dog | ||
8665 | 8665 | 8664 | {"type": "Polygon", "coordinates": [[[-122.64276, 38.2367], [-122.64203, 38.23691], [-122.6416, 38.23628], [-122.64234, 38.23606], [-122.64276, 38.2367]]]} | Open Access 1 | Richard Penry Park | 24323 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1.338 | Richard Penry Park | ||
7173 | 7173 | 7172 | {"type": "Polygon", "coordinates": [[[-122.64114, 38.23479], [-122.64083, 38.23488], [-122.64076, 38.23474], [-122.64106, 38.23464], [-122.64114, 38.23479]]]} | Open Access 1 | Putnam Plaza | 24037 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 0.122 | Putnam Plaza | ||
8415 | 8415 | 8414 | {"type": "Polygon", "coordinates": [[[-122.61979, 38.26413], [-122.6189, 38.26519], [-122.61508, 38.26305], [-122.61608, 38.26197], [-122.61979, 38.26413]]]} | Open Access 1 | Prince Park | 24008 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 14.561 | Prince Park | ||
8110 | 8110 | 8109 | {"type": "MultiPolygon", "coordinates": [[[[-122.63176, 38.26966], [-122.63117, 38.27031], [-122.62234, 38.26535], [-122.62274, 38.2649], [-122.62292, 38.26507], [-122.62305, 38.26515], [-122.62318, 38.26519], [-122.62345, 38.26523], [-122.62384, 38.2652], [-122.62397, 38.26522], [-122.62406, 38.26525], [-122.62443, 38.26546], [-122.62452, 38.26553], [-122.62464, 38.26555], [-122.62466, 38.26564], [-122.62535, 38.26603], [-122.62566, 38.26601], [-122.62568, 38.2661], [-122.62572, 38.2662], [-122.62579, 38.26629], [-122.62588, 38.26637], [-122.62608, 38.26647], [-122.62644, 38.26655], [-122.62667, 38.26665], [-122.62681, 38.26676], [-122.627, 38.26699], [-122.62715, 38.26713], [-122.62741, 38.26731], [-122.62761, 38.26742], [-122.62787, 38.26751], [-122.62811, 38.26753], [-122.62825, 38.26752], [-122.62838, 38.26747], [-122.62849, 38.26742], [-122.62859, 38.26735], [-122.6283, 38.26767], [-122.6283, 38.26769], [-122.62985, 38.26856], [-122.62991, 38.26861], [-122.62999, 38.26864], [-122.63129, 38.26937], [-122.63135, 38.26942], [-122.63147, 38.26945], [-122.63151, 38.26952], [-122.63176, 38.26966]]], [[[-122.63916, 38.27377], [-122.63855, 38.27445], [-122.63365, 38.2717], [-122.63425, 38.27103], [-122.63916, 38.27377]]], [[[-122.64797, 38.27641], [-122.64737, 38.27708], [-122.64371, 38.27506], [-122.64235, 38.27656], [-122.63864, 38.27449], [-122.63924, 38.27382], [-122.64131, 38.27497], [-122.64192, 38.27478], [-122.64294, 38.27478], [-122.64359, 38.27407], [-122.64429, 38.27441], [-122.64477, 38.27461], [-122.64497, 38.2747], [-122.6455, 38.27504], [-122.64664, 38.27567], [-122.64674, 38.27576], [-122.64685, 38.27579], [-122.64797, 38.27641]]]]} | Open Access 1 | Petaluma Urban Separator | 23625 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 55.729 | Petaluma Urban Separator | ||
7562 | 7562 | 7561 | {"type": "Polygon", "coordinates": [[[-122.65291, 38.23673], [-122.65273, 38.23676], [-122.65189, 38.23692], [-122.65155, 38.23704], [-122.65136, 38.23727], [-122.65093, 38.23771], [-122.64945, 38.23663], [-122.64994, 38.23625], [-122.65004, 38.23632], [-122.65025, 38.23633], [-122.65288, 38.23598], [-122.65291, 38.23673]]]} | Open Access 1 | Oak Hill Park | 22980 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 7.285 | Oak Hill Park | ||
7077 | 7077 | 7076 | {"type": "Polygon", "coordinates": [[[-122.61278, 38.23578], [-122.61245, 38.23612], [-122.6117, 38.23568], [-122.61154, 38.23564], [-122.61116, 38.23564], [-122.61068, 38.23584], [-122.6104, 38.23602], [-122.61028, 38.23596], [-122.61032, 38.23587], [-122.61023, 38.23582], [-122.61004, 38.23605], [-122.60976, 38.23592], [-122.60964, 38.23594], [-122.60959, 38.23598], [-122.60918, 38.23576], [-122.60926, 38.2357], [-122.60938, 38.23568], [-122.60941, 38.23558], [-122.60947, 38.23551], [-122.60951, 38.23535], [-122.60958, 38.23532], [-122.60958, 38.23524], [-122.60955, 38.23516], [-122.60957, 38.23511], [-122.60966, 38.23509], [-122.60967, 38.23494], [-122.60955, 38.23492], [-122.6095, 38.23484], [-122.60964, 38.23476], [-122.61007, 38.23474], [-122.61085, 38.23474], [-122.61185, 38.23525], [-122.61278, 38.23578]]]} | Open Access 1 | Miwok Park | 22330 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 6.483 | Miwok Park | ||
6870 | 6870 | 6869 | {"type": "Polygon", "coordinates": [[[-122.64737, 38.26448], [-122.64735, 38.26461], [-122.64727, 38.26477], [-122.64616, 38.26602], [-122.64547, 38.26568], [-122.64597, 38.26509], [-122.6463, 38.26476], [-122.6466, 38.2646], [-122.64689, 38.26449], [-122.64719, 38.26443], [-122.64734, 38.26443], [-122.64737, 38.26448]]]} | Open Access 1 | Meadow View | 22079 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 3.158 | Meadow View |
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]);