superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 144 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
4764 | 4764 | 4763 | {"type": "Polygon", "coordinates": [[[-122.58991, 38.30992], [-122.57891, 38.32201], [-122.57277, 38.31852], [-122.58368, 38.30636], [-122.58991, 38.30992]]]} | No Public Access 3 | Lafferty Ranch | 20837 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 272.485 | Lafferty Ranch | ||
2680 | 2680 | 2679 | {"type": "Polygon", "coordinates": [[[-122.59778, 38.23707], [-122.59771, 38.23722], [-122.59758, 38.23746], [-122.59738, 38.23787], [-122.59702, 38.23833], [-122.59676, 38.23857], [-122.59633, 38.23834], [-122.59654, 38.23789], [-122.59716, 38.23673], [-122.59778, 38.23707]]]} | Open Access 1 | Case Del Oro Park | 16941 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 2.947 | Case Del Oro Park | ||
1597 | 1597 | 1596 | {"type": "Polygon", "coordinates": [[[-122.60189, 38.24842], [-122.60042, 38.25008], [-122.59944, 38.2494], [-122.59941, 38.24942], [-122.59918, 38.24928], [-122.59886, 38.24905], [-122.59856, 38.24873], [-122.59857, 38.24867], [-122.59885, 38.24853], [-122.59953, 38.24827], [-122.59985, 38.24814], [-122.60036, 38.24785], [-122.60066, 38.2481], [-122.6009, 38.24786], [-122.60189, 38.24842]]]} | Open Access 1 | Arroyo Park | 15616 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 9.343 | Arroyo Park | ||
1506 | 1506 | 1505 | {"type": "Polygon", "coordinates": [[[-122.60249, 38.23759], [-122.6023, 38.23782], [-122.60201, 38.23804], [-122.60184, 38.23794], [-122.60183, 38.2379], [-122.6019, 38.23778], [-122.6022, 38.23745], [-122.60226, 38.23746], [-122.60249, 38.23759]]]} | Open Access 1 | Anna's Meadows | 15501 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 0.457 | Anna's Meadows | ||
3332 | 3332 | 3331 | {"type": "Polygon", "coordinates": [[[-122.60411, 38.24256], [-122.60085, 38.24618], [-122.5962, 38.24357], [-122.59614, 38.24353], [-122.59611, 38.24345], [-122.59612, 38.2434], [-122.59614, 38.24335], [-122.59829, 38.24098], [-122.59893, 38.24133], [-122.59953, 38.24068], [-122.59952, 38.24066], [-122.5989, 38.2403], [-122.59979, 38.23932], [-122.60141, 38.24023], [-122.60169, 38.24044], [-122.60193, 38.24069], [-122.60218, 38.24107], [-122.60196, 38.24135], [-122.60411, 38.24256]]]} | Open Access 1 | Crinella Park | 17820 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 66.222 | Crinella Park | ||
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 | ||
836 | 836 | 835 | {"type": "Polygon", "coordinates": [[[-122.60829, 38.227], [-122.60689, 38.2283], [-122.60534, 38.22861], [-122.60511, 38.22845], [-122.60348, 38.22942], [-122.60099, 38.2291], [-122.59955, 38.22806], [-122.59813, 38.22962], [-122.59712, 38.22934], [-122.59572, 38.22889], [-122.58668, 38.22545], [-122.58472, 38.22752], [-122.58065, 38.22602], [-122.58089, 38.22576], [-122.58082, 38.22535], [-122.57915, 38.22443], [-122.57979, 38.22381], [-122.58026, 38.22347], [-122.58051, 38.22326], [-122.58068, 38.22298], [-122.58182, 38.2234], [-122.58545, 38.21911], [-122.58592, 38.21923], [-122.58644, 38.21924], [-122.58741, 38.2193], [-122.58767, 38.21927], [-122.58832, 38.21912], [-122.58881, 38.21891], [-122.58985, 38.21833], [-122.59071, 38.218], [-122.5915, 38.21787], [-122.59165, 38.21787], [-122.59273, 38.21894], [-122.59312, 38.21949], [-122.59357, 38.22006], [-122.59404, 38.22053], [-122.59456, 38.22086], [-122.59507, 38.22105], [-122.59564, 38.22119], [-122.59639, 38.22125], [-122.59841, 38.22082], [-122.59919, 38.22081], [-122.60016, 38.22118], [-122.60112, 38.22129], [-122.60174, 38.22118], [-122.60284, 38.22117], [-122.60389, 38.22166], [-122.60493, 38.22272], [-122.60556, 38.22413], [-122.60673, 38.22506], [-122.60825, 38.22572], [-122.6084, 38.22616], [-122.60841, 38.22662], [-122.60829, 38.227]]]} | Open Access 1 | Shollenberger Park | http://cityofpetaluma.net/parksnrec/parks-pages/shollenberger.html | 8553 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 455.515 | Shollenberger Park | |
5845 | 5845 | 5844 | {"type": "Polygon", "coordinates": [[[-122.60948, 38.2456], [-122.6092, 38.24587], [-122.60889, 38.24599], [-122.60878, 38.24592], [-122.60856, 38.24598], [-122.60844, 38.24612], [-122.60844, 38.24628], [-122.60854, 38.24633], [-122.60853, 38.24655], [-122.6086, 38.24661], [-122.6086, 38.24671], [-122.60869, 38.24675], [-122.60846, 38.24702], [-122.60698, 38.24617], [-122.60753, 38.24552], [-122.60733, 38.24538], [-122.60735, 38.24527], [-122.60725, 38.2452], [-122.6071, 38.2452], [-122.607, 38.24523], [-122.60684, 38.24511], [-122.60679, 38.24501], [-122.60661, 38.24488], [-122.60672, 38.24475], [-122.60676, 38.24464], [-122.60651, 38.24433], [-122.60662, 38.24421], [-122.60682, 38.24404], [-122.60693, 38.24417], [-122.6071, 38.24427], [-122.60718, 38.24428], [-122.60733, 38.24435], [-122.60748, 38.2444], [-122.60783, 38.24459], [-122.60791, 38.24472], [-122.60808, 38.2448], [-122.60822, 38.24491], [-122.60901, 38.24536], [-122.60948, 38.2456]]]} | Open Access 1 | La Tercera Park | 20810 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 8.751 | La Tercera 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 | ||
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 |
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 | ||
266 | 266 | 265 | {"type": "Polygon", "coordinates": [[[-122.61292, 38.22825], [-122.61179, 38.22899], [-122.61147, 38.22909], [-122.61106, 38.22933], [-122.61102, 38.22968], [-122.61177, 38.23], [-122.61184, 38.23035], [-122.61151, 38.23186], [-122.60961, 38.23153], [-122.60965, 38.23137], [-122.6092, 38.2308], [-122.6087, 38.23061], [-122.61067, 38.22837], [-122.60854, 38.22718], [-122.60936, 38.22628], [-122.60989, 38.22655], [-122.6104, 38.22678], [-122.61292, 38.22825]]]} | No Public Access 3 | Alman | 15392 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 26.616 | Alman | 1995 | |
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 | ||
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 | ||
6827 | 6827 | 6826 | {"type": "Polygon", "coordinates": [[[-122.62227, 38.24735], [-122.62075, 38.24903], [-122.6198, 38.24853], [-122.61879, 38.24776], [-122.61909, 38.24734], [-122.61923, 38.24732], [-122.61941, 38.24744], [-122.61948, 38.24742], [-122.61993, 38.24764], [-122.62064, 38.24695], [-122.62085, 38.24703], [-122.62099, 38.24687], [-122.62164, 38.2472], [-122.62181, 38.24718], [-122.62187, 38.2471], [-122.62227, 38.24735]]]} | Open Access 1 | McDowell Park | 22027 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 9.056 | McDowell Park | ||
6853 | 6853 | 6852 | {"type": "Polygon", "coordinates": [[[-122.62482, 38.22923], [-122.62481, 38.22929], [-122.62342, 38.22908], [-122.62223, 38.22891], [-122.62175, 38.22881], [-122.62087, 38.2285], [-122.62089, 38.22842], [-122.62177, 38.22873], [-122.62218, 38.22881], [-122.62233, 38.22877], [-122.62254, 38.22851], [-122.62255, 38.22848], [-122.62263, 38.22846], [-122.62285, 38.22854], [-122.6229, 38.2286], [-122.62284, 38.2288], [-122.6229, 38.22889], [-122.62296, 38.22894], [-122.62363, 38.22902], [-122.62482, 38.22923]]]} | Open Access 1 | Mcnear Landing | 22060 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1.221 | Mcnear Landing | ||
5701 | 5701 | 5700 | {"type": "Polygon", "coordinates": [[[-122.62727, 38.24423], [-122.62614, 38.24561], [-122.62614, 38.24564], [-122.62491, 38.24476], [-122.62415, 38.24407], [-122.6233, 38.24296], [-122.62246, 38.24147], [-122.62271, 38.24132], [-122.62324, 38.24158], [-122.62375, 38.24186], [-122.62435, 38.24203], [-122.62705, 38.24364], [-122.62685, 38.24396], [-122.62727, 38.24423]]]} | Open Access 1 | Kenilworth Athletic Fields | 20596 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 20.132 | Kenilworth Athletic Fields |
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]);