units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 144 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 10
- Local Park 30
- Local Recreation Area 5
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 43
MNG_AGENCY 1
- Petaluma, City of · 43 ✖
Link | rowid | id | map ▲ | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1477 | 1477 | 1476 | {"type": "Polygon", "coordinates": [[[-122.65571, 38.24345], [-122.65543, 38.24366], [-122.65535, 38.24362], [-122.65517, 38.24361], [-122.65505, 38.24377], [-122.65504, 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.65533, 38.24319], [-122.6557, 38.24327], [-122.65571, 38.24345]]]} | Open Access 1 | 10116 | Cherry Valley Park | 17173 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 5.354 | Cherry Valley Park | 0 | Local Park 2 | 4 | |
13905 | 13905 | 13904 | {"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 | 36527 | City of Petaluma Holding | 28169 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 1.649 | City of Petaluma Holding | None 1189 | |||
1475 | 1475 | 1474 | {"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 | 10104 | Oak Hill Park | 22980 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 7.285 | Oak Hill Park | 0 | Local Park 2 | 4 | |
1464 | 1464 | 1463 | {"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 | 9921 | McDowell Meadows Park | 22025 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 0.978 | McDowell Meadows Park | 0 | Local Park 2 | 4 | |
5588 | 5588 | 5587 | {"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 | 48808 | Maria Pocket Park | 33530 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 0.325 | Maria PP | 0 | Local Park 2 | 4 | |
7878 | 7878 | 7877 | {"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 | 9909 | Meadow View | 22079 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 3.159 | Meadow View | None 658 | |||
7887 | 7887 | 7886 | {"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.64262, 38.26058], [-122.64333, 38.26017], [-122.64353, 38.26001], [-122.64398, 38.25953], [-122.64445, 38.25978]]]} | Open Access 1 | 9897 | Sunrise Park | 26025 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 7.366 | Sunrise Park | 0 | Local Park 2 | 4 | |
7897 | 7897 | 7896 | {"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 | 10092 | Richard Penry Park | 24323 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 1.339 | Richard Penry Park | 0 | Local Park 2 | 4 | |
7885 | 7885 | 7884 | {"type": "Polygon", "coordinates": [[[-122.64141, 38.26353], [-122.6408, 38.26421], [-122.64049, 38.26459], [-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.63853, 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.63833, 38.26613], [-122.63855, 38.26595], [-122.63872, 38.26577], [-122.63896, 38.26542], [-122.6392, 38.26518], [-122.63976, 38.26453], [-122.64045, 38.26385], [-122.64042, 38.26376], [-122.64087, 38.26328], [-122.64141, 38.26353]]]} | Open Access 1 | 9887 | Glennbrook Park | 19333 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 7.849 | Glennbrook Park | 0 | Local Park 2 | 4 | |
3219 | 3219 | 3218 | {"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 | 28210 | Putnam Plaza | 24037 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 0.122 | Putnam Plaza | 0 | Local Park 2 | 4 | |
11564 | 11564 | 11563 | {"type": "Polygon", "coordinates": [[[-122.63916, 38.26806], [-122.63779, 38.26959], [-122.63739, 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 | 23646 | Leghorns Park | 21140 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 7.207 | Leghorns Park | 0 | Local Park 2 | 4 | |
1474 | 1474 | 1473 | {"type": "Polygon", "coordinates": [[[-122.63904, 38.22399], [-122.63784, 38.22593], [-122.63747, 38.22579], [-122.63737, 38.22594], [-122.63689, 38.22572], [-122.63666, 38.22609], [-122.63629, 38.22594], [-122.63779, 38.2235], [-122.63904, 38.22399]]]} | Open Access 1 | 10057 | McNear Park | 22061 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 8.003 | McNear Park | 2000 | Local Park 2 | 4 | |
11494 | 11494 | 11493 | {"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 | 23637 | Cavanaugh Pool | 16981 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 0.205 | Cavanaugh Pool | 0 | Local Recreation Area 3 | 4 | |
361 | 361 | 360 | {"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 | 10069 | Walnut Park | 27241 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 1.484 | Walnut Park | 0 | Local Park 2 | 4 | |
7755 | 7755 | 7754 | {"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 | 9933 | Bond Park | 16255 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 6.347 | Bond Park | 0 | Local Park 2 | 4 | |
16201 | 16201 | 16200 | {"type": "Polygon", "coordinates": [[[-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.63407, 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.63435, 38.20955], [-122.6344, 38.20955], [-122.63532, 38.20982], [-122.63555, 38.20996], [-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]]]} | Open Access 1 | 29792 | Westridge Open Space | 27418 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 6.718 | Westridge OS | 0 | Local Recreation Area 3 | 4 | |
5636 | 5636 | 5635 | {"type": "Polygon", "coordinates": [[[-122.63444, 38.23534], [-122.63418, 38.23571], [-122.63379, 38.23586], [-122.63372, 38.23586], [-122.63364, 38.23585], [-122.63289, 38.23545], [-122.63285, 38.23545], [-122.63279, 38.23547], [-122.63252, 38.23569], [-122.63254, 38.23561], [-122.63232, 38.23551], [-122.63121, 38.23488], [-122.63129, 38.23468], [-122.63126, 38.23465], [-122.63166, 38.23421], [-122.63111, 38.23393], [-122.63152, 38.23326], [-122.63195, 38.23347], [-122.63287, 38.23386], [-122.63321, 38.23397], [-122.63283, 38.23465], [-122.6335, 38.23491], [-122.6336, 38.23489], [-122.63374, 38.23473], [-122.63384, 38.23468], [-122.63395, 38.23468], [-122.6342, 38.23476], [-122.63429, 38.23482], [-122.63433, 38.2349], [-122.63429, 38.23523], [-122.63444, 38.23534]]]} | Open Access 1 | 29793 | McNear Peninsula Waterfront Park | 22062 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 10.139 | McNear Peninsula Waterfront Park | 0 | Local Park 2 | 4 | |
5984 | 5984 | 5983 | {"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 | 10080 | Wickersham Park | 27484 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 2.305 | Wickersham Park | 0 | Local Park 2 | 4 | |
10095 | 10095 | 10094 | {"type": "Polygon", "coordinates": [[[-122.63263, 38.25312], [-122.6326, 38.25321], [-122.63194, 38.25398], [-122.63125, 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 | 17498 | Lucchesi Park | 21575 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 37.554 | Lucchesi Park | 0 | Local Park 2 | 4 | |
1283 | 1283 | 1282 | {"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 | 9981 | Kenilworth Park | 20597 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 3.259 | Kenilworth Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);