superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 150 sorted by map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Marin County Parks Department, County of · 14 ✖
ACCESS_TYP 1
- Open Access 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12553 | 12553 | 12552 | {"type": "Polygon", "coordinates": [[[-122.52992, 37.94943], [-122.52988, 37.94956], [-122.52939, 37.94972], [-122.5293, 37.94972], [-122.52954, 37.94934], [-122.52992, 37.94943]]]} | Open Access 1 | Corte Los Sombras Park | 31223 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 0.299 | Corte Los Sombras Park | ||
12321 | 12321 | 12320 | {"type": "Polygon", "coordinates": [[[-122.53548, 37.9535], [-122.53505, 37.95383], [-122.53417, 37.95393], [-122.53356, 37.95388], [-122.53324, 37.9538], [-122.5334, 37.95316], [-122.53492, 37.95354], [-122.53548, 37.9535]]]} | Open Access 1 | Greenbrae Redwoods County Park | 30879 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 2.343 | Greenbrae Redwoods County Park | ||
15539 | 15539 | 15538 | {"type": "Polygon", "coordinates": [[[-122.53671, 38.00113], [-122.53636, 38.00112], [-122.53598, 38.00094], [-122.53585, 38.00113], [-122.53575, 38.00113], [-122.53448, 38.00304], [-122.53437, 38.00314], [-122.53264, 38.00397], [-122.52966, 38.00525], [-122.52941, 38.00533], [-122.52915, 38.00539], [-122.52888, 38.00542], [-122.52862, 38.00541], [-122.52829, 38.00536], [-122.52663, 38.00495], [-122.5291, 38.00327], [-122.52684, 38.00151], [-122.52722, 38.00121], [-122.52735, 38.00129], [-122.52947, 37.99959], [-122.52899, 37.9992], [-122.52905, 37.99915], [-122.52905, 37.99913], [-122.52833, 37.99856], [-122.52883, 37.99815], [-122.52883, 37.99814], [-122.52788, 37.99739], [-122.52834, 37.99703], [-122.52839, 37.99701], [-122.52845, 37.99701], [-122.5285, 37.99704], [-122.52855, 37.99702], [-122.52882, 37.99679], [-122.52881, 37.9967], [-122.52883, 37.99666], [-122.52916, 37.9964], [-122.52958, 37.99605], [-122.52996, 37.99569], [-122.5305, 37.99536], [-122.53086, 37.99535], [-122.53126, 37.99554], [-122.53206, 37.99559], [-122.53224, 37.99562], [-122.53249, 37.99571], [-122.53264, 37.99579], [-122.53284, 37.99594], [-122.53309, 37.99622], [-122.53338, 37.99649], [-122.53575, 37.99984], [-122.53671, 38.00113]]]} | Open Access 1 | Civic Center Lagoon Park | 17350 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 137.024 | Civic Ctr. Lagoon Park | ||
13462 | 13462 | 13461 | {"type": "Polygon", "coordinates": [[[-122.54025, 38.03365], [-122.53987, 38.03375], [-122.53969, 38.03377], [-122.53924, 38.03375], [-122.53916, 38.03379], [-122.53855, 38.03418], [-122.53781, 38.03479], [-122.53764, 38.03494], [-122.53753, 38.03506], [-122.53742, 38.03526], [-122.53729, 38.03577], [-122.5373, 38.03598], [-122.5373, 38.03615], [-122.53713, 38.03656], [-122.5371, 38.03673], [-122.53706, 38.0376], [-122.53714, 38.03825], [-122.53741, 38.03953], [-122.5375, 38.03985], [-122.53751, 38.0401], [-122.53743, 38.04065], [-122.53725, 38.04116], [-122.53702, 38.04159], [-122.53662, 38.04223], [-122.53568, 38.04355], [-122.53555, 38.04389], [-122.53512, 38.04463], [-122.53338, 38.04702], [-122.53332, 38.04711], [-122.53324, 38.04736], [-122.53317, 38.04747], [-122.53298, 38.04762], [-122.53288, 38.0478], [-122.53288, 38.04783], [-122.53293, 38.04788], [-122.53349, 38.04817], [-122.53363, 38.04816], [-122.53357, 38.04824], [-122.53352, 38.04825], [-122.53347, 38.04824], [-122.53346, 38.04821], [-122.5329, 38.04791], [-122.53282, 38.04783], [-122.53283, 38.04779], [-122.53294, 38.0476], [-122.53313, 38.04744], [-122.53319, 38.04734], [-122.53327, 38.0471], [-122.53333, 38.047], [-122.53508, 38.04461], [-122.5355, 38.04387], [-122.53564, 38.04353], [-122.53657, 38.04222], [-122.53697, 38.04158], [-122.5372, 38.04115], [-122.53737, 38.04065], [-122.53745, 38.0401], [-122.53745, 38.03992], [-122.53742, 38.03976], [-122.53736, 38.03955], [-122.53708, 38.03827], [-122.53701, 38.0376], [-122.53701, 38.03728], [-122.53705, 38.03682], [-122.53705, 38.03674], [-122.53708, 38.03655], [-122.53725, 38.03615], [-122.53725, 38.03598], [-122.53723, 38.03577], [-122.53737, 38.03525], [-122.53744, 38.03511], [-122.5376, 38.03492], [-122.53895, 38.03378], [-122.53909, 38.03372], [-122.53927, 38.03369], [-122.53929, 38.03372], [-122.53968, 38.03373], [-122.53994, 38.03369], [-122.54018, 38.03362], [-122.54025, 38.03365]]]} | Open Access 1 | Pacheco Path | 30874 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 2.281 | Pacheco Path | ||
2614 | 2614 | 2613 | {"type": "Polygon", "coordinates": [[[-122.54231, 37.94808], [-122.54155, 37.94882], [-122.54046, 37.94983], [-122.53924, 37.95103], [-122.53771, 37.94999], [-122.538, 37.94977], [-122.53804, 37.94969], [-122.53802, 37.9496], [-122.53796, 37.94953], [-122.53722, 37.94901], [-122.53706, 37.94881], [-122.53707, 37.94876], [-122.53722, 37.94865], [-122.53744, 37.94845], [-122.53761, 37.94821], [-122.53773, 37.94796], [-122.5378, 37.94769], [-122.5378, 37.94741], [-122.53774, 37.94715], [-122.53748, 37.94649], [-122.53743, 37.94632], [-122.53741, 37.94612], [-122.53743, 37.94592], [-122.53746, 37.94582], [-122.53772, 37.94558], [-122.53775, 37.94561], [-122.53778, 37.94567], [-122.53792, 37.94586], [-122.53796, 37.94596], [-122.53802, 37.94601], [-122.53809, 37.94619], [-122.53816, 37.94631], [-122.53828, 37.94664], [-122.53836, 37.94679], [-122.53851, 37.94699], [-122.53869, 37.94718], [-122.53892, 37.94736], [-122.53921, 37.94753], [-122.53939, 37.94762], [-122.53978, 37.94775], [-122.54013, 37.94782], [-122.54231, 37.94808]]]} | Open Access 1 | Creekside Park | 17770 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 27.416 | Creekside Park | ||
13478 | 13478 | 13477 | {"type": "Polygon", "coordinates": [[[-122.54961, 38.11831], [-122.5496, 38.11871], [-122.54943, 38.11921], [-122.54894, 38.11951], [-122.54859, 38.11961], [-122.54879, 38.12026], [-122.54844, 38.12048], [-122.54828, 38.12061], [-122.54814, 38.12076], [-122.54783, 38.12115], [-122.54756, 38.12141], [-122.54723, 38.12164], [-122.5469, 38.12181], [-122.54641, 38.12126], [-122.54499, 38.12009], [-122.54574, 38.11957], [-122.54572, 38.11941], [-122.54628, 38.11917], [-122.54877, 38.11829], [-122.54961, 38.11831]]]} | Open Access 1 | Rush Creek Park | 30893 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 19.718 | Rush Creek Park | ||
13469 | 13469 | 13468 | {"type": "Polygon", "coordinates": [[[-122.57028, 38.00565], [-122.57023, 38.00585], [-122.5701, 38.00592], [-122.57018, 38.00616], [-122.57005, 38.00647], [-122.56991, 38.00659], [-122.5698, 38.00673], [-122.5697, 38.00695], [-122.56969, 38.00718], [-122.56964, 38.00742], [-122.56977, 38.0076], [-122.56977, 38.00771], [-122.56965, 38.00773], [-122.56934, 38.00762], [-122.56925, 38.00756], [-122.56921, 38.00748], [-122.56915, 38.00728], [-122.56908, 38.00722], [-122.56887, 38.00718], [-122.56872, 38.00718], [-122.56849, 38.00724], [-122.56849, 38.00723], [-122.56862, 38.00716], [-122.56884, 38.00709], [-122.56884, 38.00707], [-122.56882, 38.00704], [-122.56889, 38.00704], [-122.56915, 38.0071], [-122.56927, 38.00717], [-122.56931, 38.00724], [-122.56939, 38.00747], [-122.56944, 38.00751], [-122.56949, 38.00752], [-122.56947, 38.00739], [-122.56952, 38.00717], [-122.56952, 38.00699], [-122.56955, 38.00686], [-122.56964, 38.00667], [-122.56977, 38.0065], [-122.56989, 38.0064], [-122.57, 38.00615], [-122.56988, 38.00586], [-122.57028, 38.00565]]]} | Open Access 1 | Mission Pass Path | 30882 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 1.362 | Mission Pass Path | ||
10587 | 10587 | 10586 | {"type": "Polygon", "coordinates": [[[-122.65392, 37.90254], [-122.65342, 37.90305], [-122.65332, 37.90301], [-122.65344, 37.90278], [-122.64758, 37.90039], [-122.64764, 37.9003], [-122.64763, 37.90029], [-122.64748, 37.90022], [-122.6474, 37.9003], [-122.64694, 37.90007], [-122.647, 37.89999], [-122.64699, 37.89997], [-122.64689, 37.89992], [-122.64682, 37.90001], [-122.64635, 37.89977], [-122.64641, 37.89968], [-122.64632, 37.89962], [-122.64623, 37.89971], [-122.64576, 37.89947], [-122.64582, 37.89937], [-122.64507, 37.899], [-122.64443, 37.89867], [-122.64434, 37.89876], [-122.64411, 37.89864], [-122.64388, 37.89852], [-122.64394, 37.89844], [-122.64393, 37.89842], [-122.64383, 37.89837], [-122.64376, 37.89846], [-122.64352, 37.89834], [-122.64358, 37.89824], [-122.64336, 37.89813], [-122.64357, 37.89787], [-122.65392, 37.90254]]]} | Open Access 1 | Upton County Beach | 26739 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 14.089 | Upton County Beach | ||
13465 | 13465 | 13464 | {"type": "Polygon", "coordinates": [[[-122.68693, 37.90647], [-122.68631, 37.90679], [-122.68619, 37.90667], [-122.68607, 37.90645], [-122.68603, 37.90634], [-122.68601, 37.90621], [-122.68605, 37.90594], [-122.68612, 37.90585], [-122.68623, 37.90589], [-122.68637, 37.90596], [-122.68663, 37.90614], [-122.68674, 37.90624], [-122.68693, 37.90647]]]} | Open Access 1 | Bolinas Park | 30877 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 1.194 | Bolinas Park | ||
4308 | 4308 | 4307 | {"type": "Polygon", "coordinates": [[[-122.68946, 38.01406], [-122.68941, 38.01415], [-122.68914, 38.01432], [-122.68905, 38.01435], [-122.68897, 38.01436], [-122.6889, 38.01434], [-122.68874, 38.01421], [-122.68929, 38.01378], [-122.6893, 38.01384], [-122.68938, 38.01388], [-122.68944, 38.01394], [-122.68946, 38.01399], [-122.68946, 38.01406]]]} | Open Access 1 | Forest Knolls Park | 18995 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 0.526 | Forest Knolls Park | ||
13466 | 13466 | 13465 | {"type": "Polygon", "coordinates": [[[-122.69822, 38.00712], [-122.69764, 38.00738], [-122.69766, 38.00745], [-122.69675, 38.00778], [-122.69618, 38.00677], [-122.69672, 38.00671], [-122.69698, 38.00672], [-122.69724, 38.00658], [-122.69734, 38.00703], [-122.6977, 38.00711], [-122.6981, 38.00699], [-122.69811, 38.00705], [-122.69822, 38.00712]]]} | Open Access 1 | Lagunitas Village Mini-Park | 30880 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 2.699 | Lagunitas Village Mini-Park | ||
13480 | 13480 | 13479 | {"type": "Polygon", "coordinates": [[[-122.81142, 38.07188], [-122.81087, 38.07235], [-122.81113, 38.07284], [-122.81072, 38.07316], [-122.81097, 38.0735], [-122.81125, 38.07383], [-122.81075, 38.07423], [-122.81065, 38.07441], [-122.81006, 38.07484], [-122.80905, 38.07402], [-122.80904, 38.07347], [-122.80871, 38.07342], [-122.80872, 38.07329], [-122.80897, 38.07325], [-122.80891, 38.07238], [-122.80851, 38.0718], [-122.80804, 38.07167], [-122.80753, 38.07178], [-122.80745, 38.07198], [-122.80692, 38.07226], [-122.80682, 38.07235], [-122.80659, 38.07217], [-122.80848, 38.07075], [-122.80878, 38.07088], [-122.80914, 38.07097], [-122.80946, 38.07103], [-122.80984, 38.07109], [-122.81102, 38.07115], [-122.81142, 38.07188]]]} | Open Access 1 | Eldrid Preserve | 30899 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 20.627 | Eldrid Preserve | ||
2895 | 2895 | 2894 | {"type": "Polygon", "coordinates": [[[-122.86561, 38.11011], [-122.86537, 38.1102], [-122.8655, 38.11065], [-122.86521, 38.11023], [-122.86378, 38.10914], [-122.86257, 38.1082], [-122.86335, 38.10757], [-122.86353, 38.10773], [-122.86438, 38.10863], [-122.86484, 38.10905], [-122.8653, 38.1094], [-122.86545, 38.10948], [-122.8656, 38.10952], [-122.86549, 38.1097], [-122.86561, 38.11011]]]} | Open Access 1 | Chicken Ranch Beach | 17190 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 6.464 | Chicken Ranch Beach | ||
7006 | 7006 | 7005 | {"type": "Polygon", "coordinates": [[[-122.92217, 38.20098], [-122.92176, 38.20118], [-122.921, 38.20137], [-122.92095, 38.20128], [-122.92092, 38.2012], [-122.92095, 38.20094], [-122.92095, 38.20081], [-122.92091, 38.20059], [-122.92068, 38.19975], [-122.92049, 38.19943], [-122.92169, 38.1991], [-122.92204, 38.19964], [-122.92217, 38.20098]]]} | Open Access 1 | Miller Park Boat Launch | 22247 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 6.083 | Miller Park Boat Launch |
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]);