superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 144
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | ||
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 | |
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 | ||
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 | ||
2139 | 2139 | 2138 | {"type": "Polygon", "coordinates": [[[-122.63693, 38.25894], [-122.63629, 38.25967], [-122.63631, 38.25981], [-122.63635, 38.2599], [-122.63671, 38.2601], [-122.63685, 38.26022], [-122.6369, 38.26039], [-122.63688, 38.26053], [-122.63669, 38.26077], [-122.63599, 38.26036], [-122.63577, 38.26014], [-122.63561, 38.26009], [-122.63523, 38.25972], [-122.63493, 38.25877], [-122.63657, 38.25845], [-122.63665, 38.25847], [-122.63693, 38.25887], [-122.63693, 38.25894]]]} | Open Access 1 | Bond Park | 16255 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 6.349 | Bond Park | ||
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 | ||
2713 | 2713 | 2712 | {"type": "Polygon", "coordinates": [[[-122.63742, 38.22602], [-122.63723, 38.22633], [-122.63703, 38.22625], [-122.63725, 38.22589], [-122.63737, 38.22594], [-122.63735, 38.22599], [-122.63742, 38.22602]]]} | Open Access 1 | Cavanaugh Pool | 16981 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 0.206 | Cavanaugh Pool | ||
2879 | 2879 | 2878 | {"type": "Polygon", "coordinates": [[[-122.65571, 38.24345], [-122.65543, 38.24366], [-122.65535, 38.24362], [-122.65517, 38.24361], [-122.65505, 38.24377], [-122.65505, 38.24386], [-122.65516, 38.24392], [-122.65466, 38.24428], [-122.65343, 38.24401], [-122.65391, 38.2427], [-122.6541, 38.24267], [-122.65493, 38.24288], [-122.65496, 38.24293], [-122.65532, 38.24313], [-122.65534, 38.24319], [-122.6557, 38.24327], [-122.65571, 38.24345]]]} | Open Access 1 | Cherry Valley Park | 17173 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 5.355 | Cherry Valley Park | ||
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 | ||
3769 | 3769 | 3768 | {"type": "Polygon", "coordinates": [[[-122.6317, 38.26648], [-122.63117, 38.26655], [-122.63082, 38.26669], [-122.63064, 38.26647], [-122.62985, 38.26606], [-122.62973, 38.26596], [-122.62979, 38.26585], [-122.62992, 38.2657], [-122.63035, 38.26546], [-122.63149, 38.26613], [-122.63166, 38.26632], [-122.6317, 38.26648]]]} | Open Access 1 | Eagle Park | 18341 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 2.897 | Eagle Park | ||
4601 | 4601 | 4600 | {"type": "Polygon", "coordinates": [[[-122.64141, 38.26353], [-122.6408, 38.26421], [-122.6405, 38.26458], [-122.64055, 38.26486], [-122.64043, 38.26493], [-122.64027, 38.26506], [-122.64003, 38.26532], [-122.63981, 38.26563], [-122.63979, 38.26585], [-122.63964, 38.26588], [-122.63946, 38.26594], [-122.63922, 38.26609], [-122.63904, 38.26628], [-122.6388, 38.2667], [-122.6387, 38.2667], [-122.63854, 38.26681], [-122.63852, 38.26684], [-122.63853, 38.26687], [-122.6382, 38.26728], [-122.63762, 38.26695], [-122.63796, 38.26654], [-122.63801, 38.26646], [-122.63804, 38.26634], [-122.63804, 38.26626], [-122.63832, 38.26613], [-122.63855, 38.26595], [-122.63872, 38.26577], [-122.63896, 38.26542], [-122.6392, 38.26518], [-122.63976, 38.26453], [-122.64044, 38.26386], [-122.64042, 38.26376], [-122.64087, 38.26328], [-122.64141, 38.26353]]]} | Open Access 1 | Glennbrook Park | 19333 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 7.852 | Glennbrook Park | ||
4701 | 4701 | 4700 | {"type": "Polygon", "coordinates": [[[-122.6307, 38.21993], [-122.63068, 38.22035], [-122.62958, 38.22036], [-122.62935, 38.22045], [-122.6293, 38.22056], [-122.62924, 38.22066], [-122.62902, 38.22065], [-122.62899, 38.22063], [-122.62886, 38.22061], [-122.62878, 38.22063], [-122.62846, 38.22063], [-122.62846, 38.21987], [-122.62849, 38.21981], [-122.62844, 38.21951], [-122.6285, 38.21947], [-122.62939, 38.21947], [-122.62953, 38.21953], [-122.62967, 38.21953], [-122.62973, 38.21975], [-122.62987, 38.21992], [-122.6307, 38.21993]]]} | Open Access 1 | Grant Park | 19440 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 4.26 | Grant 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 | ||
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 | ||
5702 | 5702 | 5701 | {"type": "Polygon", "coordinates": [[[-122.63231, 38.24197], [-122.63157, 38.24277], [-122.63066, 38.24226], [-122.63059, 38.24198], [-122.63119, 38.24133], [-122.63231, 38.24197]]]} | Open Access 1 | Kenilworth Park | 20597 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 3.258 | Kenilworth 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 | ||
6083 | 6083 | 6082 | {"type": "Polygon", "coordinates": [[[-122.63916, 38.26806], [-122.63779, 38.26959], [-122.6374, 38.26937], [-122.63732, 38.26941], [-122.63645, 38.26893], [-122.63786, 38.26737], [-122.63811, 38.26751], [-122.63814, 38.26749], [-122.63916, 38.26806]]]} | Open Access 1 | Leghorns Park | 21140 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 7.207 | Leghorns Park | ||
6452 | 6452 | 6451 | {"type": "Polygon", "coordinates": [[[-122.63263, 38.25312], [-122.6326, 38.25321], [-122.63194, 38.25398], [-122.63124, 38.25406], [-122.62897, 38.25607], [-122.62605, 38.25441], [-122.62749, 38.2528], [-122.62783, 38.25276], [-122.62938, 38.2513], [-122.63263, 38.25312]]]} | Open Access 1 | Lucchesi Park | 21575 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 37.555 | Lucchesi Park | ||
6825 | 6825 | 6824 | {"type": "Polygon", "coordinates": [[[-122.65082, 38.26559], [-122.6502, 38.26627], [-122.64983, 38.26609], [-122.64991, 38.26593], [-122.64994, 38.26571], [-122.65012, 38.26568], [-122.65023, 38.26564], [-122.65032, 38.26558], [-122.65048, 38.26541], [-122.65082, 38.26559]]]} | Open Access 1 | McDowell Meadows Park | 22025 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 0.978 | McDowell Meadows 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]);