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
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Olivehurst Public Utility District 23
- Tahoe City Public Utilities District 5
- Heber Public Utility District 4
- Marin Municipal Water District 3
- East Bay Municipal Utility District 3
- Soquel Creek Water District 3
- North Tahoe Public Utilities District 3
- Metropolitan Water District of Southern California 2
- Burney Co Water District 2
- Valley Center Water District 2
- Helix Water District 2
- San Gabriel River Water Committee 1
- Sacramento Municipal Utility District 1
- San Lorenzo Valley Water District 1
- Scotts Valley Water District 1
- Yuima Municipal Water District 1
- Orange County Water District 1
- Santa Clara Valley Water District 1
- North Marin Water District 1
- Olivenhain Municipal Water District 1
- Ramona Municipal Water District 1
- Fallbrook Public Utility District 1
- Marina County Water District 1
- Mariposa Public Utility District 1
- Monterey County Water Resources Agency 1
- Santa Margarita Water District 1
- Georgetown Divide Public Utility District 1
- Malaga County Water District 1
- Napa County Flood Control and Water Conservation District 1
- Padre Dam Municipal Water District 1
- …
MNG_AG_TYP 1
- Water District · 73 ✖
ACCESS_TYP 1
- Open Access · 73 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1699 | 1699 | 1698 | {"type": "Polygon", "coordinates": [[[-117.40597, 34.07031], [-117.40479, 34.07031], [-117.40478, 34.06832], [-117.40534, 34.06832], [-117.40596, 34.06828], [-117.40597, 34.07031]]]} | Open Access 1 | Ayala Park | 15735 | 2321 | Valley Center Water District 672 | Special District 4 | Water District 13 | http://www.vcmwd.org/ | Special District 4 | 6.001 | Ayala 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 | ||
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 | ||
3724 | 3724 | 3723 | {"type": "Polygon", "coordinates": [[[-121.81028, 36.69978], [-121.81011, 36.70086], [-121.80621, 36.69923], [-121.80668, 36.69888], [-121.80692, 36.69836], [-121.81028, 36.69978]]]} | Open Access 1 | Dunes State Park - Marina County Water District | 18301 | 2073 | Marina County Water District 871 | Special District 4 | Water District 13 | http://www.mcwd.org/ | Special District 4 | 10.132 | Dunes SP - Marina County Water District | ||
4060 | 4060 | 4059 | {"type": "Polygon", "coordinates": [[[-115.54303, 32.74155], [-115.54223, 32.74155], [-115.54222, 32.73903], [-115.54219, 32.73886], [-115.54205, 32.73852], [-115.54202, 32.73835], [-115.54234, 32.73834], [-115.54235, 32.73805], [-115.54297, 32.73805], [-115.54303, 32.74155]]]} | Open Access 1 | Estancia Park | 18721 | 2278 | Heber Public Utility District 648 | Special District 4 | Water District 13 | http://heber.ca.gov/index.php | Special District 4 | 7.049 | Estancia Park | ||
4933 | 4933 | 4932 | {"type": "Polygon", "coordinates": [[[-116.99133, 32.78393], [-116.99033, 32.78407], [-116.9903, 32.78611], [-116.9902, 32.78658], [-116.99031, 32.78666], [-116.98969, 32.78726], [-116.98908, 32.7869], [-116.98894, 32.78687], [-116.98882, 32.78688], [-116.98873, 32.78691], [-116.98865, 32.78696], [-116.9883, 32.78737], [-116.98484, 32.78841], [-116.98451, 32.78765], [-116.98457, 32.78745], [-116.98513, 32.78701], [-116.98551, 32.78636], [-116.9855, 32.78634], [-116.98504, 32.78641], [-116.98498, 32.78634], [-116.98558, 32.78624], [-116.98632, 32.78621], [-116.9863, 32.78564], [-116.98609, 32.78543], [-116.98482, 32.78557], [-116.9848, 32.78547], [-116.98471, 32.78547], [-116.98442, 32.78522], [-116.98459, 32.78505], [-116.98456, 32.78493], [-116.98762, 32.78417], [-116.98785, 32.78409], [-116.98887, 32.78392], [-116.99128, 32.78386], [-116.99133, 32.78393]]]} | Open Access 1 | Harry Griffen Park | http://www.cityoflamesa.com/391/Harry-Griffen-Regional-Park | 19707 | 2046 | Helix Water District 757 | Special District 4 | Water District 13 | http://www.hwd.com | Special District 4 | 44.269 | Harry Griffen Park | |
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 | ||
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 | ||
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 | ||
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 | ||
5729 | 5729 | 5728 | {"type": "Polygon", "coordinates": [[[-117.40315, 34.04849], [-117.40144, 34.0485], [-117.40142, 34.04844], [-117.40084, 34.04844], [-117.40084, 34.04673], [-117.40086, 34.0467], [-117.4009, 34.04669], [-117.40131, 34.04669], [-117.40133, 34.04661], [-117.40143, 34.04658], [-117.40143, 34.04463], [-117.40146, 34.04463], [-117.40147, 34.04666], [-117.40226, 34.04667], [-117.40227, 34.04671], [-117.40315, 34.04671], [-117.40315, 34.04849]]]} | Open Access 1 | Kessler Park | 20635 | 2321 | Valley Center Water District 672 | Special District 4 | Water District 13 | http://www.vcmwd.org/ | Special District 4 | 10.685 | Kessler Park | ||
5792 | 5792 | 5791 | {"type": "Polygon", "coordinates": [[[-122.58663, 38.10653], [-122.58616, 38.10726], [-122.58423, 38.10642], [-122.58469, 38.10574], [-122.58663, 38.10653]]]} | Open Access 1 | L U Sutton Recreation Area | 20738 | 2071 | Marin Municipal Water District 250 | Special District 4 | Water District 13 | http://www.marinwater.org/ | Special District 4 | 4.201 | L U Sutton Rec. Area | 2000 | |
5908 | 5908 | 5907 | {"type": "Polygon", "coordinates": [[[-120.11571, 39.1806], [-120.11568, 39.18066], [-120.11555, 39.18075], [-120.11511, 39.18076], [-120.11498, 39.18084], [-120.11442, 39.18138], [-120.11424, 39.18139], [-120.11419, 39.1813], [-120.11437, 39.18121], [-120.11442, 39.18108], [-120.11455, 39.18091], [-120.11474, 39.18052], [-120.11432, 39.18023], [-120.11388, 39.17996], [-120.11386, 39.1799], [-120.11374, 39.17984], [-120.11375, 39.17968], [-120.11395, 39.17941], [-120.11435, 39.17916], [-120.11455, 39.17905], [-120.11478, 39.17905], [-120.11469, 39.17913], [-120.11465, 39.1793], [-120.11467, 39.17939], [-120.1146, 39.17983], [-120.11474, 39.18003], [-120.11493, 39.18017], [-120.11517, 39.18021], [-120.11555, 39.18034], [-120.11569, 39.18033], [-120.11571, 39.1806]]]} | Open Access 1 | Lake Forest Beach Park | 20886 | 2260 | Tahoe City Public Utilities District 658 | Special District 4 | Water District 13 | http://www.tahoecitypud.com/parksrec.shtml | Special District 4 | 3.695 | Lake Forest Beach 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 | ||
6299 | 6299 | 6298 | {"type": "MultiPolygon", "coordinates": [[[[-117.75752, 34.1341], [-117.75671, 34.13628], [-117.75616, 34.13502], [-117.75433, 34.13264], [-117.75496, 34.13229], [-117.75515, 34.13228], [-117.75538, 34.13231], [-117.75558, 34.13237], [-117.75577, 34.13247], [-117.7559, 34.13258], [-117.756, 34.1327], [-117.75602, 34.1327], [-117.75598, 34.13278], [-117.75599, 34.13287], [-117.75608, 34.13297], [-117.75617, 34.13316], [-117.75627, 34.13334], [-117.75649, 34.13358], [-117.75668, 34.13374], [-117.75692, 34.13388], [-117.75719, 34.134], [-117.75749, 34.13408], [-117.75752, 34.1341]]], [[[-117.75871, 34.13267], [-117.75854, 34.13285], [-117.75791, 34.13332], [-117.75789, 34.1334], [-117.7577, 34.13366], [-117.75762, 34.13385], [-117.75758, 34.13387], [-117.75731, 34.1338], [-117.75708, 34.1337], [-117.75687, 34.13358], [-117.75668, 34.13343], [-117.75651, 34.13324], [-117.75639, 34.13303], [-117.75634, 34.13292], [-117.75637, 34.13283], [-117.75637, 34.13278], [-117.75632, 34.1327], [-117.75737, 34.13269], [-117.75791, 34.13213], [-117.75871, 34.13267]]]]} | Open Access 1 | Live Oak Park | 21373 | 2078 | Metropolitan Water District of Southern California 407 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 16.966 | Live Oak 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 | |
6629 | 6629 | 6628 | {"type": "Polygon", "coordinates": [[[-115.5415, 32.73581], [-115.53914, 32.73583], [-115.53914, 32.73493], [-115.53916, 32.7349], [-115.5392, 32.73489], [-115.54145, 32.73486], [-115.54148, 32.73488], [-115.54149, 32.73491], [-115.5415, 32.73581]]]} | Open Access 1 | Margarito "Tito" Huerta Jr. Park | 21805 | 2278 | Heber Public Utility District 648 | Special District 4 | Water District 13 | http://heber.ca.gov/index.php | Special District 4 | 5.724 | Margarito "Tito" Huerta Jr. Park | ||
7099 | 7099 | 7098 | {"type": "MultiPolygon", "coordinates": [[[[-121.72319, 37.95393], [-121.72319, 37.95429], [-121.71709, 37.95429], [-121.71684, 37.95402], [-121.72238, 37.95401], [-121.72319, 37.95393]]], [[[-121.74157, 37.95436], [-121.72891, 37.9543], [-121.72334, 37.95429], [-121.72334, 37.95393], [-121.73271, 37.95396], [-121.73358, 37.95405], [-121.74157, 37.95409], [-121.74157, 37.95436]]], [[[-121.75526, 37.95876], [-121.75511, 37.959], [-121.75087, 37.95721], [-121.75086, 37.9569], [-121.75526, 37.95876]]], [[[-121.75973, 37.96095], [-121.75912, 37.96069], [-121.75529, 37.95908], [-121.75546, 37.95884], [-121.75967, 37.96062], [-121.75973, 37.96095]]], [[[-121.78005, 37.96603], [-121.77993, 37.96623], [-121.77859, 37.96572], [-121.76918, 37.96356], [-121.76557, 37.96268], [-121.762, 37.96191], [-121.76189, 37.96186], [-121.76264, 37.96186], [-121.76317, 37.96189], [-121.76341, 37.96191], [-121.76411, 37.96204], [-121.76918, 37.96327], [-121.7779, 37.96525], [-121.77849, 37.96541], [-121.77931, 37.96568], [-121.77999, 37.96595], [-121.78004, 37.96599], [-121.78005, 37.96603]]], [[[-121.78567, 37.96827], [-121.78552, 37.96854], [-121.7852, 37.96829], [-121.78027, 37.96636], [-121.7804, 37.96617], [-121.78044, 37.96615], [-121.78051, 37.96616], [-121.78507, 37.96793], [-121.78541, 37.96805], [-121.78567, 37.96827]]], [[[-121.78823, 37.97022], [-121.78813, 37.97034], [-121.78807, 37.97047], [-121.7857, 37.96867], [-121.78585, 37.96841], [-121.78823, 37.97022]]], [[[-121.79282, 37.9737], [-121.79258, 37.9739], [-121.78823, 37.97059], [-121.78825, 37.97052], [-121.78833, 37.97038], [-121.78838, 37.97032], [-121.79282, 37.9737]]], [[[-121.80043, 37.97808], [-121.80022, 37.97834], [-121.79905, 37.97671], [-121.79894, 37.97665], [-121.79732, 37.9758], [-121.7968, 37.9758], [-121.79679, 37.97553], [-121.79568, 37.97495], [-121.79374, 37.97477], [-121.79273, 37.97401], [-121.79297, 37.97381], [-121.7939, 37.97451], [-121.7958, 37.97468], [-121.79931, 37.97651], [-121.80043, 37.97808]]], [[[-121.80353, 37.98089], [-121.8035, 37.98091], [-121.80316, 37.98092], [-121.80119, 37.97969], [-121.80034, 37.9785], [-121.80055, 37.97824], [-121.80146, 37.9795], [-121.80353, 37.98079], [-121.80353, 37.98089]]], [[[-121.80543, 37.98233], [-121.80391, 37.98138], [-121.80352, 37.98114], [-121.80408, 37.98113], [-121.80541, 37.98196], [-121.80543, 37.98233]]], [[[-121.80773, 37.98341], [-121.80759, 37.98349], [-121.80747, 37.9836], [-121.80586, 37.9826], [-121.80584, 37.9826], [-121.80581, 37.98223], [-121.80773, 37.98341]]], [[[-121.81051, 37.98513], [-121.81029, 37.98535], [-121.80763, 37.9837], [-121.80776, 37.9836], [-121.80791, 37.98352], [-121.81051, 37.98513]]], [[[-121.81741, 37.98943], [-121.8173, 37.98953], [-121.81715, 37.98962], [-121.81043, 37.98544], [-121.81064, 37.98522], [-121.81741, 37.98943]]], [[[-121.82223, 37.99262], [-121.82219, 37.99266], [-121.82205, 37.99268], [-121.81732, 37.98973], [-121.81745, 37.98965], [-121.81757, 37.98953], [-121.82222, 37.99242], [-121.82223, 37.99262]]], [[[-121.82676, 37.99526], [-121.82655, 37.99547], [-121.82263, 37.99303], [-121.82258, 37.99281], [-121.82264, 37.99277], [-121.82275, 37.99276], [-121.82676, 37.99526]]], [[[-121.83178, 37.99794], [-121.83051, 37.99794], [-121.82671, 37.99557], [-121.82692, 37.99536], [-121.83063, 37.99767], [-121.83167, 37.99767], [-121.83173, 37.99779], [-121.83178, 37.99794]]], [[[-121.83458, 37.99767], [-121.83457, 37.99795], [-121.83199, 37.99794], [-121.83195, 37.99779], [-121.8319, 37.99767], [-121.83458, 37.99767]]], [[[-121.83789, 37.99768], [-121.83789, 37.99795], [-121.83479, 37.99795], [-121.83479, 37.99767], [-121.83789, 37.99768]]], [[[-121.84196, 37.99803], [-121.84136, 37.99817], [-121.84044, 37.99795], [-121.83811, 37.99795], [-121.8381, 37.99768], [-121.84051, 37.99768], [-121.84196, 37.99803]]], [[[-121.84351, 37.9984], [-121.84325, 37.99862], [-121.84188, 37.99829], [-121.84266, 37.99819], [-121.84351, 37.9984]]]]} | Open Access 1 | Mokelumne Trail | 22359 | 2031 | East Bay Municipal Utility District 427 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 86.253 | Mokelumne Trail | ||
7397 | 7397 | 7396 | {"type": "Polygon", "coordinates": [[[-122.55959, 38.10376], [-122.55841, 38.10467], [-122.55842, 38.10468], [-122.55871, 38.10477], [-122.55847, 38.10547], [-122.55713, 38.10508], [-122.55859, 38.10336], [-122.55885, 38.10358], [-122.55947, 38.10311], [-122.55959, 38.10376]]]} | Open Access 1 | NMWD-Reservoir Hill | 22772 | 2095 | North Marin Water District 807 | Special District 4 | Water District 13 | http://www.nmwd.com | Special District 4 | 5.527 | NMWD-Reservoir Hill | ||
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 |
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]);