units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
16 rows where ACCESS_TYP = 1, COUNTY = 16, DES_TP = 3 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 16 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1472 | 1472 | 1471 | {"type": "Polygon", "coordinates": [[[-122.62727, 38.24423], [-122.62614, 38.24562], [-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.24187], [-122.62435, 38.24203], [-122.62705, 38.24364], [-122.62685, 38.24396], [-122.62727, 38.24423]]]} | Open Access 1 | 10010 | Kenilworth Athletic Fields | 20596 | 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 | 20.13 | Kenilworth Athletic Fields | 0 | Local Recreation Area 3 | 4 | |
3216 | 3216 | 3215 | {"type": "Polygon", "coordinates": [[[-122.69706, 38.34239], [-122.69676, 38.3424], [-122.69675, 38.34203], [-122.69679, 38.34203], [-122.69684, 38.34205], [-122.69706, 38.34239]]]} | Open Access 1 | 28195 | Carlita Circle Tot Lot | 16858 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.163 | Carlita Circle Tot Lot | 0 | Local Recreation Area 3 | 4 | |
3217 | 3217 | 3216 | {"type": "Polygon", "coordinates": [[[-122.69549, 38.34679], [-122.69543, 38.34722], [-122.69517, 38.34718], [-122.69523, 38.34676], [-122.69549, 38.34679]]]} | Open Access 1 | 28197 | Civic Center Tot Lot | 17370 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.273 | Civic Ctr. Tot Lot | 0 | Local Recreation Area 3 | 4 | |
4336 | 4336 | 4335 | {"type": "Polygon", "coordinates": [[[-122.71107, 38.3234], [-122.71084, 38.32403], [-122.71063, 38.32398], [-122.71059, 38.3241], [-122.7104, 38.32405], [-122.71029, 38.32437], [-122.70936, 38.32406], [-122.7094, 38.32375], [-122.7102, 38.32358], [-122.70955, 38.32271], [-122.71002, 38.32241], [-122.71082, 38.32344], [-122.71107, 38.3234]]]} | Open Access 1 | 45501 | Civic Center | 28334 | 1072 | Cotati, City of 356 | City 2 | City Agency 2 | http://www.ci.cotati.ca.us/ | City 2 | 1072 | Cotati, City of 353 | City 2 | City Agency 2 | Sonoma 16 | 3.743 | Civic Ctr. | 0 | Local Recreation Area 3 | 4 | |
7752 | 7752 | 7751 | {"type": "Polygon", "coordinates": [[[-122.80614, 38.53533], [-122.80383, 38.53537], [-122.80381, 38.53476], [-122.80379, 38.53466], [-122.80367, 38.53444], [-122.80294, 38.53361], [-122.80285, 38.53341], [-122.80282, 38.53316], [-122.80287, 38.5331], [-122.80298, 38.53308], [-122.80418, 38.53305], [-122.80593, 38.53511], [-122.80614, 38.53533]]]} | Open Access 1 | 8327 | Wilson Ranch Soccer Park | 27614 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 9.673 | Wilson Ranch Soccer Park | 0 | Local Recreation Area 3 | 4 | |
9576 | 9576 | 9575 | {"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.26232], [-122.60952, 38.26339], [-122.61136, 38.26423], [-122.61166, 38.265]]]} | Open Access 1 | 47844 | Petaluma Community Sports Fields | 31786 | 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/petaluma-comm-sport-fields.html | Sonoma 16 | 24.892 | Petaluma Community Sports Fields | 2015 | Local Recreation Area 3 | 4 |
11108 | 11108 | 11107 | {"type": "Polygon", "coordinates": [[[-122.6879, 38.32193], [-122.6879, 38.32224], [-122.6877, 38.32225], [-122.6877, 38.32193], [-122.6879, 38.32193]]]} | Open Access 1 | 28203 | Lilac Way Tot Lot | 21233 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.156 | Lilac Way Tot Lot | 0 | Local Recreation Area 3 | 4 | |
11252 | 11252 | 11251 | {"type": "Polygon", "coordinates": [[[-122.86822, 38.62425], [-122.86384, 38.62426], [-122.86382, 38.62265], [-122.86822, 38.62269], [-122.86822, 38.62425]]]} | Open Access 1 | 23635 | Healdsburg Municipal Pool | 19771 | 1131 | Healdsburg, City of 374 | City 2 | City Agency 2 | http://www.ci.healdsburg.ca.us/index.aspx?page=94 | City 2 | 1131 | Healdsburg, City of 369 | City 2 | City Agency 2 | Sonoma 16 | 16.657 | Healdsburg Municipal Pool | 0 | Local Recreation Area 3 | 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 | |
12468 | 12468 | 12467 | {"type": "Polygon", "coordinates": [[[-122.68291, 38.34386], [-122.68267, 38.34386], [-122.68266, 38.34356], [-122.6829, 38.34357], [-122.68291, 38.34386]]]} | Open Access 1 | 28196 | Foot Hills Mini Park / Jasmine Tot Lot | 18974 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.171 | Foot Hills MP / Jasmine Tot Lot | 0 | Local Recreation Area 3 | 4 | |
12478 | 12478 | 12477 | {"type": "Polygon", "coordinates": [[[-122.70081, 38.32988], [-122.70061, 38.32996], [-122.70041, 38.32967], [-122.7006, 38.32959], [-122.70081, 38.32988]]]} | Open Access 1 | 28199 | Burton Avenue Tot Lot | 16528 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.17 | Burton Avenue Tot Lot | 0 | Local Recreation Area 3 | 4 | |
12756 | 12756 | 12755 | {"type": "Polygon", "coordinates": [[[-122.71297, 38.43721], [-122.7128, 38.43723], [-122.71289, 38.43736], [-122.71246, 38.4374], [-122.71245, 38.43726], [-122.71248, 38.43725], [-122.71247, 38.43715], [-122.71295, 38.43713], [-122.71297, 38.43721]]]} | Open Access 1 | 29787 | Prince Memorial Greenway | 24005 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 0.243 | Prince Memorial Greenway | 0 | Local Recreation Area 3 | 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 | |
16831 | 16831 | 16830 | {"type": "Polygon", "coordinates": [[[-122.86318, 38.61423], [-122.86317, 38.61543], [-122.86181, 38.61542], [-122.86189, 38.61422], [-122.86318, 38.61423]]]} | Open Access 1 | 47196 | Recreation Park | 30892 | 1131 | Healdsburg, City of 374 | City 2 | City Agency 2 | http://www.ci.healdsburg.ca.us/index.aspx?page=94 | City 2 | 1131 | Healdsburg, City of 369 | City 2 | City Agency 2 | http://ci.healdsburg.ca.us/Facilities/Facility/Details/Recreation-Park-14 | Sonoma 16 | 3.816 | Rec. Park | 0 | Local Recreation Area 3 | 4 |
17032 | 17032 | 17031 | {"type": "Polygon", "coordinates": [[[-123.01796, 38.80475], [-123.01776, 38.80483], [-123.01761, 38.80461], [-123.01763, 38.80459], [-123.01759, 38.80453], [-123.01776, 38.80445], [-123.01796, 38.80475]]]} | Open Access 1 | 23631 | Veterans Memorial Center | 27022 | 1059 | Cloverdale, City of 410 | City 2 | City Agency 2 | http://www.cloverdale.net/index.aspx?nid=152 | City 2 | 1059 | Cloverdale, City of 404 | City 2 | City Agency 2 | Sonoma 16 | 0.172 | Veterans Memorial Ctr. | 0 | Local Recreation Area 3 | 4 | |
17033 | 17033 | 17032 | {"type": "Polygon", "coordinates": [[[-122.85063, 38.62187], [-122.85033, 38.62203], [-122.85026, 38.62196], [-122.85036, 38.62188], [-122.85022, 38.62174], [-122.85, 38.62187], [-122.85036, 38.62223], [-122.84998, 38.62226], [-122.8494, 38.62223], [-122.84941, 38.62281], [-122.84722, 38.62334], [-122.8473, 38.62058], [-122.85008, 38.62055], [-122.85049, 38.62114], [-122.85063, 38.62187]]]} | Open Access 1 | 23634 | Villag Chanticleer Conference Center | 27108 | 1131 | Healdsburg, City of 374 | City 2 | City Agency 2 | http://www.ci.healdsburg.ca.us/index.aspx?page=94 | City 2 | 1131 | Healdsburg, City of 369 | City 2 | City Agency 2 | Sonoma 16 | 16.784 | Villag Chanticleer Conference Ctr. | 0 | Local Recreation Area 3 | 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]);