units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where DES_TP = 2, LAYER = 2 and MNG_AGENCY = 144
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 30
MNG_AGENCY 1
- Petaluma, City of · 30 ✖
DES_TP 1
- Local Park · 30 ✖
ACCESS_TYP 1
- Open Access 30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
1225 | 1225 | 1224 | {"type": "Polygon", "coordinates": [[[-122.60828, 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.22805], [-122.59813, 38.22962], [-122.59712, 38.22934], [-122.59572, 38.22889], [-122.58667, 38.22545], [-122.58472, 38.22752], [-122.58065, 38.22602], [-122.58089, 38.22576], [-122.58083, 38.22535], [-122.57915, 38.22443], [-122.57979, 38.22381], [-122.58026, 38.22347], [-122.58051, 38.22326], [-122.58068, 38.22298], [-122.58181, 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.5964, 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.60828, 38.227]]]} | Open Access 1 | 7020 | Shollenberger Park | 8553 | 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 | http://cityofpetaluma.net/parksnrec/parks-pages/shollenberger.html | Sonoma 16 | 455.472 | Shollenberger 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 | |
1459 | 1459 | 1458 | {"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.24067], [-122.59953, 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.60195, 38.24135], [-122.60411, 38.24256]]]} | Open Access 1 | 9831 | Crinella Park | 17820 | 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 | 66.215 | Crinella Park | 0 | Local Park 2 | 4 | |
1461 | 1461 | 1460 | {"type": "Polygon", "coordinates": [[[-122.61278, 38.23578], [-122.61245, 38.23612], [-122.6117, 38.23568], [-122.61154, 38.23563], [-122.61117, 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.2351], [-122.60968, 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 | 9843 | Miwok Park | 22330 | 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.479 | Miwok 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 | |
1467 | 1467 | 1466 | {"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 | 10033 | Sunset Park | 26058 | 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.319 | Sunset Park | 0 | Local Park 2 | 4 | |
1473 | 1473 | 1472 | {"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 | 10021 | Case Del Oro Park | 16941 | 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.947 | Case Del Oro 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 | |
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 | |
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 | |
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 | |
3810 | 3810 | 3809 | {"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.21982], [-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 | 10133 | Grant Park | 19440 | 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 | 4.258 | Grant Park | 0 | Local Park 2 | 4 | |
5586 | 5586 | 5585 | {"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 | 48806 | Southgate Park | 33528 | 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.079 | Southgate Park | 0 | Local Park 2 | 4 | |
5587 | 5587 | 5586 | {"type": "Polygon", "coordinates": [[[-122.62098, 38.22346], [-122.62096, 38.22431], [-122.62061, 38.22421], [-122.62066, 38.22397], [-122.62047, 38.22393], [-122.62007, 38.22387], [-122.61965, 38.22384], [-122.61933, 38.22378], [-122.61924, 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 | 48807 | Riverview Park | 33529 | 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.473 | Riverview 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 | |
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 | |
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 | |
7818 | 7818 | 7817 | {"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.24745], [-122.61948, 38.24742], [-122.61993, 38.24764], [-122.62064, 38.24695], [-122.62085, 38.24703], [-122.62099, 38.24687], [-122.62165, 38.2472], [-122.62181, 38.24718], [-122.62187, 38.2471], [-122.62227, 38.24735]]]} | Open Access 1 | 9945 | McDowell Park | 22027 | 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 | 9.052 | McDowell 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]);