superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
93 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 13 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Olivehurst Public Utility District 23
- Marin Municipal Water District 6
- East Bay Municipal Utility District 6
- Tahoe City Public Utilities District 6
- Heber Public Utility District 4
- Soquel Creek Water District 3
- North Tahoe Public Utilities District 3
- Helix Water District 3
- Santa Clara Valley Water District 3
- Metropolitan Water District of Southern California 2
- Yuba County Water Agency 2
- San Lorenzo Valley Water District 2
- Burney Co Water District 2
- Valley Center Water District 2
- North Marin Water District 2
- Ramona Municipal Water District 2
- San Gabriel River Water Committee 1
- Sacramento Municipal Utility District 1
- Scotts Valley Water District 1
- Yuima Municipal Water District 1
- Orange County Water District 1
- South Sutter Water District 1
- San Gabriel County Water District 1
- Olivenhain Municipal Water District 1
- Fallbrook Public Utility District 1
- Marina County Water District 1
- Mariposa Public Utility District 1
- Contra Costa Water District 1
- Monterey County Water Resources Agency 1
- United Water Conservation District 1
- …
MNG_AG_TYP 1
- Water District · 93 ✖
ACCESS_TYP 1
- Open Access · 93 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11289 | 11289 | 11288 | {"type": "Polygon", "coordinates": [[[-121.93307, 36.98817], [-121.93305, 36.9883], [-121.93244, 36.98822], [-121.93247, 36.98809], [-121.93307, 36.98817]]]} | Open Access 1 | Willowbrook Park - Soquel Creek Water District | 27591 | 2157 | Soquel Creek Water District 582 | Special District 4 | Water District 13 | http://www.soquelcreekwater.org/ | Special District 4 | 0.197 | Willowbrook Park - Soquel Creek Water District | ||
10051 | 10051 | 10050 | {"type": "Polygon", "coordinates": [[[-121.53871, 39.07389], [-121.5384, 39.07389], [-121.53837, 39.07383], [-121.53834, 39.0738], [-121.53824, 39.07377], [-121.53827, 39.07352], [-121.5387, 39.07352], [-121.53871, 39.07389]]]} | Open Access 1 | Summerfield Detention Basin | 25956 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 0.369 | Summerfield Detention Basin | ||
15436 | 15436 | 15435 | {"type": "Polygon", "coordinates": [[[-120.048, 39.2394], [-120.0475, 39.23937], [-120.04744, 39.2393], [-120.04741, 39.23912], [-120.04744, 39.23907], [-120.04793, 39.23907], [-120.04799, 39.23915], [-120.048, 39.2394]]]} | Open Access 1 | Tahoe Vista Recreation Area | http://northtahoeparks.com/beaches | 30867 | 2246 | North Tahoe Public Utilities District 614 | Special District 4 | Water District 13 | http://www.ntpud.org/ | Special District 4 | 0.408 | Tahoe Vista Rec. Area | |
5008 | 5008 | 5007 | {"type": "Polygon", "coordinates": [[[-115.53155, 32.73148], [-115.53126, 32.73148], [-115.53109, 32.73143], [-115.53101, 32.73145], [-115.53086, 32.73122], [-115.53155, 32.73119], [-115.53155, 32.73148]]]} | Open Access 1 | Heber Children Park | 19788 | 2278 | Heber Public Utility District 648 | Special District 4 | Water District 13 | http://heber.ca.gov/index.php | Special District 4 | 0.421 | Heber Children Park | ||
2888 | 2888 | 2887 | {"type": "Polygon", "coordinates": [[[-121.55129, 39.10154], [-121.55129, 39.10208], [-121.55128, 39.10252], [-121.55114, 39.1024], [-121.55101, 39.10223], [-121.55098, 39.10215], [-121.55097, 39.10202], [-121.55102, 39.10186], [-121.5512, 39.1015], [-121.55129, 39.10154]]]} | Open Access 1 | Chestnut Park | 17183 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 0.52 | Chestnut Park | ||
8388 | 8388 | 8387 | {"type": "Polygon", "coordinates": [[[-121.56747, 39.0595], [-121.56741, 39.05964], [-121.56737, 39.05981], [-121.5668, 39.05982], [-121.56678, 39.05978], [-121.56673, 39.05974], [-121.56662, 39.05971], [-121.56675, 39.05938], [-121.56747, 39.0595]]]} | Open Access 1 | Prairie Trails Park | 23977 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 0.658 | Prairie Trails Park | ||
5590 | 5590 | 5589 | {"type": "Polygon", "coordinates": [[[-121.53733, 39.07823], [-121.53719, 39.07869], [-121.537, 39.07865], [-121.53637, 39.07861], [-121.53637, 39.07855], [-121.53649, 39.07851], [-121.53653, 39.07843], [-121.53649, 39.07833], [-121.53646, 39.07831], [-121.53646, 39.07826], [-121.53692, 39.07823], [-121.53733, 39.07823]]]} | Open Access 1 | Johnson Park | 20479 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 0.766 | Johnson Park | ||
6588 | 6588 | 6587 | {"type": "Polygon", "coordinates": [[[-121.84919, 36.922], [-121.84892, 36.9225], [-121.84829, 36.92229], [-121.84857, 36.92178], [-121.84919, 36.922]]]} | Open Access 1 | Manresa State Beach - SCWD | http://www.parks.ca.gov/?page_id=545 | 21759 | 2157 | Soquel Creek Water District 582 | Special District 4 | Water District 13 | http://www.soquelcreekwater.org/ | Special District 4 | 0.931 | Manresa SB - SCWD | |
8763 | 8763 | 8762 | {"type": "Polygon", "coordinates": [[[-121.55377, 39.0223], [-121.55374, 39.02233], [-121.55363, 39.02233], [-121.55302, 39.02231], [-121.55288, 39.02229], [-121.55285, 39.02225], [-121.55286, 39.02204], [-121.55284, 39.02189], [-121.55376, 39.02182], [-121.55378, 39.02219], [-121.55377, 39.0223]]]} | Open Access 1 | River Park | 24420 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 1.022 | River Park | ||
5657 | 5657 | 5656 | {"type": "Polygon", "coordinates": [[[-121.55363, 39.08252], [-121.55312, 39.08256], [-121.55308, 39.08148], [-121.55359, 39.08164], [-121.55363, 39.08252]]]} | Open Access 1 | Kartikeya Avenue Park | 20555 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 1.181 | Kartikeya Avenue Park | ||
7737 | 7737 | 7736 | {"type": "Polygon", "coordinates": [[[-121.54882, 39.01498], [-121.54877, 39.01546], [-121.54875, 39.01551], [-121.54872, 39.01555], [-121.54865, 39.01556], [-121.54793, 39.01552], [-121.54787, 39.0155], [-121.54784, 39.01547], [-121.54789, 39.01494], [-121.54882, 39.01498]]]} | Open Access 1 | Orchard Glen Park | 23188 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 1.263 | Orchard Glen Park | ||
1090 | 1090 | 1089 | {"type": "Polygon", "coordinates": [[[-118.11443, 34.10438], [-118.1143, 34.10445], [-118.11408, 34.10405], [-118.11378, 34.10418], [-118.11341, 34.10321], [-118.1138, 34.10302], [-118.11397, 34.10334], [-118.11419, 34.10387], [-118.11414, 34.1039], [-118.11421, 34.10408], [-118.11434, 34.10429], [-118.11439, 34.10429], [-118.11443, 34.10438]]]} | Open Access 1 | Alhambra Wash | 15358 | 2136 | San Gabriel County Water District 836 | Special District 4 | Water District 13 | http://www.sgcwd.com/ | Special District 4 | 1.372 | Alhambra Wash | ||
13588 | 13588 | 13587 | {"type": "Polygon", "coordinates": [[[-121.6748, 40.88058], [-121.67428, 40.88107], [-121.67355, 40.88056], [-121.67413, 40.8801], [-121.6748, 40.88058]]]} | Open Access 1 | Burney Civic Park | 33449 | 2434 | Burney Co Water District 603 | Special District 4 | Water District 13 | https://www.burneywater.org/ | Special District 4 | 1.411 | Burney Civic Park | ||
5388 | 5388 | 5387 | {"type": "Polygon", "coordinates": [[[-121.53769, 38.97852], [-121.5373, 38.97871], [-121.53713, 38.97885], [-121.53694, 38.97905], [-121.5368, 38.97941], [-121.53681, 38.97995], [-121.53646, 38.97822], [-121.53744, 38.97812], [-121.53759, 38.97831], [-121.53769, 38.97852]]]} | Open Access 1 | Lot D Park River Oaks South | 21543 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2.017 | Lot D Park River Oaks South | ||
3587 | 3587 | 3586 | {"type": "Polygon", "coordinates": [[[-121.52367, 39.13749], [-121.52367, 39.13795], [-121.52365, 39.13801], [-121.52359, 39.13809], [-121.52354, 39.13812], [-121.52265, 39.13843], [-121.52249, 39.13814], [-121.5225, 39.13755], [-121.52367, 39.13749]]]} | Open Access 1 | Detention Pond | 18119 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2.04 | Detention Pond | ||
8258 | 8258 | 8257 | {"type": "Polygon", "coordinates": [[[-121.54721, 38.97635], [-121.54716, 38.9765], [-121.54705, 38.97668], [-121.54687, 38.97683], [-121.54666, 38.97693], [-121.54647, 38.97699], [-121.54626, 38.977], [-121.54611, 38.977], [-121.54583, 38.97695], [-121.54563, 38.97695], [-121.54565, 38.97633], [-121.54609, 38.97634], [-121.5462, 38.97636], [-121.54628, 38.97632], [-121.54632, 38.97625], [-121.54721, 38.97635]]]} | Open Access 1 | Plumas Ranch Park | 23815 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2.154 | Plumas Ranch Park | ||
8718 | 8718 | 8717 | {"type": "Polygon", "coordinates": [[[-121.55763, 39.00793], [-121.55708, 39.00803], [-121.55677, 39.00805], [-121.55631, 39.00803], [-121.5561, 39.00799], [-121.55606, 39.00796], [-121.55607, 39.00791], [-121.55614, 39.00777], [-121.55625, 39.00764], [-121.55651, 39.0074], [-121.55665, 39.00732], [-121.557, 39.00718], [-121.5572, 39.00712], [-121.55741, 39.00709], [-121.55763, 39.00793]]]} | Open Access 1 | Rio Del Oro Park 2 | 24377 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2.404 | Rio Del Oro Park 2 | ||
7681 | 7681 | 7680 | {"type": "Polygon", "coordinates": [[[-121.55399, 39.06615], [-121.55401, 39.06659], [-121.55396, 39.06684], [-121.5538, 39.06714], [-121.55374, 39.06733], [-121.55317, 39.06735], [-121.55295, 39.06618], [-121.55399, 39.06615]]]} | Open Access 1 | Olivehurst Park | 23131 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2.433 | Olivehurst Park | ||
8918 | 8918 | 8917 | {"type": "Polygon", "coordinates": [[[-121.55374, 39.01738], [-121.55332, 39.01752], [-121.55262, 39.01726], [-121.55207, 39.01735], [-121.55172, 39.01736], [-121.55175, 39.01683], [-121.55177, 39.01677], [-121.55181, 39.01675], [-121.55212, 39.01674], [-121.55251, 39.01663], [-121.5527, 39.01678], [-121.5528, 39.01685], [-121.55293, 39.01691], [-121.55321, 39.01699], [-121.55331, 39.017], [-121.5535, 39.01697], [-121.55354, 39.01698], [-121.55358, 39.01703], [-121.55374, 39.01738]]]} | Open Access 1 | Rolling Hills Park | 24581 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2.471 | Rolling Hills Park | ||
6229 | 6229 | 6228 | {"type": "Polygon", "coordinates": [[[-121.55442, 39.07704], [-121.55299, 39.07701], [-121.55298, 39.07619], [-121.55424, 39.07619], [-121.55442, 39.07704]]]} | Open Access 1 | Lindhurst Memorial Park | 21298 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2.66 | Lindhurst Memorial 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]);