units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
113 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 13 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 113 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
759 | 759 | 758 | {"type": "Polygon", "coordinates": [[[-122.5442, 37.91301], [-122.54403, 37.91312], [-122.54383, 37.91293], [-122.54399, 37.91283], [-122.54405, 37.91288], [-122.54417, 37.91281], [-122.5442, 37.91301]]]} | Open Access 1 | 4954 | Watershed Lands | 27306 | 2071 | Marin Municipal Water District 254 | Special District 4 | Water District 13 | http://www.marinwater.org/ | Special District 4 | 2071 | Marin Municipal Water District 250 | Special District 4 | Water District 13 | Marin 23 | 0.152 | Watershed Lands | None 71 | |||
3178 | 3178 | 3177 | {"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 | 1913 | Willowbrook Park - Soquel Creek Water District | 27591 | 2157 | Soquel Creek Water District 592 | Special District 4 | Water District 13 | http://www.soquelcreekwater.org/ | Special District 4 | 2157 | Soquel Creek Water District 582 | Special District 4 | Water District 13 | Santa Cruz 5 | 0.197 | Willowbrook Park - Soquel Creek Water District | 0 | Local Other or Unknown 14 | 4 | |
6682 | 6682 | 6681 | {"type": "Polygon", "coordinates": [[[-122.54068, 37.913], [-122.5406, 37.91314], [-122.54045, 37.91323], [-122.54028, 37.91318], [-122.54014, 37.91304], [-122.54018, 37.91291], [-122.54046, 37.91284], [-122.54066, 37.91288], [-122.54068, 37.913]]]} | Open Access 1 | 4958 | Watershed Lands | 27306 | 2071 | Marin Municipal Water District 254 | Special District 4 | Water District 13 | http://www.marinwater.org/ | Special District 4 | 2071 | Marin Municipal Water District 250 | Special District 4 | Water District 13 | Marin 23 | 0.366 | Watershed Lands | None 541 | |||
11260 | 11260 | 11259 | {"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 | 21693 | Summerfield Detention Basin | 25956 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 0.369 | Summerfield Detention Basin | None 983 | |||
14671 | 14671 | 14670 | {"type": "Polygon", "coordinates": [[[-120.048, 39.2394], [-120.0475, 39.23937], [-120.04744, 39.2393], [-120.04741, 39.23912], [-120.04743, 39.23907], [-120.04793, 39.23907], [-120.04799, 39.23915], [-120.048, 39.2394]]]} | Open Access 1 | 45001 | Tahoe Vista Recreation Area | 30867 | 2246 | North Tahoe Public Utilities District 625 | Special District 4 | Water District 13 | http://www.ntpud.org/ | Special District 4 | 2246 | North Tahoe Public Utilities District 614 | Special District 4 | Water District 13 | http://northtahoeparks.com/beaches | Placer 35 | 0.408 | Tahoe Vista Rec. Area | 0 | Local Recreation Area 3 | 4 |
12960 | 12960 | 12959 | {"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 | 30424 | Heber Children Park | 19788 | 2278 | Heber Public Utility District 661 | Special District 4 | Water District 13 | http://heber.ca.gov/index.php | Special District 4 | 2278 | Heber Public Utility District 648 | Special District 4 | Water District 13 | Imperial 20 | 0.422 | Heber Children Park | 0 | Local Park 2 | 4 | |
3149 | 3149 | 3148 | {"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 | 21674 | Chestnut Park | 17183 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 0.52 | Chestnut Park | 0 | Local Park 2 | 4 | |
4296 | 4296 | 4295 | {"type": "Polygon", "coordinates": [[[-122.05637, 37.07384], [-122.0561, 37.07397], [-122.056, 37.07404], [-122.05592, 37.07413], [-122.05577, 37.07436], [-122.05552, 37.07423], [-122.05574, 37.07384], [-122.05592, 37.07367], [-122.05637, 37.07384]]]} | Open Access 1 | 45336 | San Lorenzo Valley Water District | 11349 | 2277 | San Lorenzo Valley Water District 598 | Special District 4 | Water District 13 | http://www.slvwd.com/ | Special District 4 | 2277 | San Lorenzo Valley Water District 588 | Special District 4 | Water District 13 | Santa Cruz 5 | 0.582 | San Lorenzo Valley Water District | 0 | Local Other or Unknown 14 | 4 | |
11236 | 11236 | 11235 | {"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 | 21690 | Prairie Trails Park | 23977 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 0.658 | Prairie Trails Park | 0 | Local Park 2 | 4 | |
12472 | 12472 | 12471 | {"type": "Polygon", "coordinates": [[[-122.047, 37.0913], [-122.04687, 37.09163], [-122.04695, 37.09167], [-122.04668, 37.09206], [-122.04633, 37.09191], [-122.04667, 37.09124], [-122.04691, 37.09124], [-122.04694, 37.09128], [-122.047, 37.0913]]]} | Open Access 1 | 28266 | San Lorenzo Valley Water District | 11349 | 2277 | San Lorenzo Valley Water District 598 | Special District 4 | Water District 13 | http://www.slvwd.com/ | Special District 4 | 2277 | San Lorenzo Valley Water District 588 | Special District 4 | Water District 13 | Santa Cruz 5 | 0.757 | San Lorenzo Valley Water District | 0 | Local Other or Unknown 14 | 4 | |
11262 | 11262 | 11261 | {"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.53669, 39.07826], [-121.53692, 39.07823], [-121.53733, 39.07823]]]} | Open Access 1 | 21695 | Johnson Park | 20479 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 0.76 | Johnson Park | 0 | Local Park 2 | 4 | |
16470 | 16470 | 16469 | {"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 | 17541 | Manresa State Beach - SCWD | 21759 | 2157 | Soquel Creek Water District 592 | Special District 4 | Water District 13 | http://www.soquelcreekwater.org/ | Special District 4 | 2157 | Soquel Creek Water District 582 | Special District 4 | Water District 13 | http://www.parks.ca.gov/?page_id=545 | Santa Cruz 5 | 0.932 | Manresa SB - SCWD | None 1408 | ||
12490 | 12490 | 12489 | {"type": "Polygon", "coordinates": [[[-122.04261, 37.09647], [-122.04222, 37.09703], [-122.04178, 37.09661], [-122.04199, 37.09639], [-122.04198, 37.09622], [-122.04186, 37.09592], [-122.04261, 37.09647]]]} | Open Access 1 | 28265 | San Lorenzo Valley Water District | 11349 | 2277 | San Lorenzo Valley Water District 598 | Special District 4 | Water District 13 | http://www.slvwd.com/ | Special District 4 | 2277 | San Lorenzo Valley Water District 588 | Special District 4 | Water District 13 | Santa Cruz 5 | 1.006 | San Lorenzo Valley Water District | 0 | Local Other or Unknown 14 | 4 | |
11244 | 11244 | 11243 | {"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 | 21688 | River Park | 24420 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 1.022 | River Park | 0 | Local Park 2 | 4 | |
11263 | 11263 | 11262 | {"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 | 21696 | Kartikeya Avenue Park | 20555 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 1.182 | Kartikeya Avenue Park | 0 | Local Park 2 | 4 | |
11257 | 11257 | 11256 | {"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 | 21686 | Orchard Glen Park | 23188 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 1.263 | Orchard Glen Park | 0 | Local Park 2 | 4 | |
7373 | 7373 | 7372 | {"type": "Polygon", "coordinates": [[[-118.11443, 34.10438], [-118.1143, 34.10445], [-118.11408, 34.10404], [-118.11378, 34.10418], [-118.11341, 34.10321], [-118.1138, 34.10302], [-118.11397, 34.10334], [-118.11419, 34.10387], [-118.11414, 34.10389], [-118.11421, 34.10408], [-118.11434, 34.10429], [-118.11439, 34.10429], [-118.11443, 34.10438]]]} | Open Access 1 | 6757 | Alhambra Wash | 15358 | 2136 | San Gabriel County Water District 858 | Special District 4 | Water District 13 | http://www.sgcwd.com/ | Special District 4 | 2136 | San Gabriel County Water District 836 | Special District 4 | Water District 13 | Los Angeles 6 | 1.369 | Alhambra Wash | None 612 | |||
3292 | 3292 | 3291 | {"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 | 48725 | Burney Civic Park | 33449 | 2434 | Burney Co Water District 614 | Special District 4 | Water District 13 | https://www.burneywater.org/ | Special District 4 | 2434 | Burney Co Water District 603 | Special District 4 | Water District 13 | Shasta 27 | 1.411 | Burney Civic Park | 0 | Local Park 2 | 4 | |
3220 | 3220 | 3219 | {"type": "MultiPolygon", "coordinates": [[[[-122.09018, 37.13776], [-122.09013, 37.13822], [-122.0897, 37.13823], [-122.08931, 37.13812], [-122.08919, 37.1378], [-122.08975, 37.13776], [-122.09018, 37.13776]]], [[[-122.09064, 37.14203], [-122.09063, 37.14221], [-122.09047, 37.14215], [-122.09043, 37.1422], [-122.09035, 37.14208], [-122.09022, 37.14195], [-122.09006, 37.14184], [-122.08989, 37.14175], [-122.08984, 37.14171], [-122.08991, 37.14163], [-122.08994, 37.14164], [-122.09008, 37.14142], [-122.09036, 37.14158], [-122.09032, 37.14163], [-122.09055, 37.14187], [-122.09064, 37.14203]]]]} | Open Access 1 | 28259 | San Lorenzo Valley Water District | 11349 | 2277 | San Lorenzo Valley Water District 598 | Special District 4 | Water District 13 | http://www.slvwd.com/ | Special District 4 | 2277 | San Lorenzo Valley Water District 588 | Special District 4 | Water District 13 | Santa Cruz 5 | 1.606 | San Lorenzo Valley Water District | 0 | Local Other or Unknown 14 | 4 | |
11248 | 11248 | 11247 | {"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 | 21679 | Lot D Park River Oaks South | 21543 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 2.016 | Lot D Park River Oaks South | 0 | Local Other or Unknown 14 | 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]);