units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, DES_TP = 4 and YR_EST = 1980
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6169 | 6169 | 6168 | {"type": "Polygon", "coordinates": [[[-122.06812, 37.42979], [-122.06774, 37.43158], [-122.06766, 37.43158], [-122.06728, 37.43333], [-122.06727, 37.43397], [-122.06741, 37.43482], [-122.06167, 37.43332], [-122.06406, 37.4325], [-122.0641, 37.42743], [-122.06424, 37.42739], [-122.06438, 37.4274], [-122.06668, 37.42783], [-122.06606, 37.4294], [-122.06812, 37.42979]]]} | Open Access 1 | 1190 | Stevens Creek Nature Study Area | 25841 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_stevens_creek.asp | Santa Clara 19 | 56.61 | Stevens Creek Nature Study Area | 1980 | Local Conservation Area 4 | 2 |
13178 | 13178 | 13177 | {"type": "Polygon", "coordinates": [[[-122.19253, 37.31896], [-122.19057, 37.32014], [-122.19052, 37.31994], [-122.19015, 37.31974], [-122.19005, 37.31951], [-122.18928, 37.31962], [-122.189, 37.31959], [-122.18931, 37.31936], [-122.18935, 37.31929], [-122.18936, 37.31922], [-122.18933, 37.31911], [-122.18914, 37.31885], [-122.18913, 37.31879], [-122.18915, 37.31872], [-122.18914, 37.31857], [-122.18911, 37.3185], [-122.18902, 37.31838], [-122.18888, 37.31828], [-122.18871, 37.31823], [-122.18853, 37.31823], [-122.1883, 37.31829], [-122.18819, 37.31827], [-122.18812, 37.31824], [-122.18808, 37.31819], [-122.18783, 37.31784], [-122.18775, 37.31755], [-122.18766, 37.31746], [-122.18754, 37.31732], [-122.18745, 37.31724], [-122.18742, 37.31708], [-122.18737, 37.317], [-122.18694, 37.31656], [-122.18682, 37.31646], [-122.18669, 37.31638], [-122.18646, 37.31631], [-122.18618, 37.31628], [-122.18596, 37.31617], [-122.18571, 37.31592], [-122.18554, 37.31568], [-122.18551, 37.31557], [-122.18553, 37.31551], [-122.18557, 37.31544], [-122.18567, 37.31536], [-122.18608, 37.31508], [-122.18621, 37.31502], [-122.18594, 37.31469], [-122.186, 37.31429], [-122.18622, 37.3144], [-122.18645, 37.31455], [-122.18671, 37.31474], [-122.18694, 37.31496], [-122.18701, 37.31497], [-122.18927, 37.31721], [-122.18959, 37.31751], [-122.18994, 37.31778], [-122.19031, 37.31803], [-122.1907, 37.31826], [-122.19112, 37.31846], [-122.19156, 37.31864], [-122.19253, 37.31896]]]} | Open Access 1 | 35156 | Coal Creek Open Space Preserve | 31501 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_coal_creek.asp | Santa Clara 19 | 25.376 | Coal Creek OSP | 1980 | Local Conservation Area 4 | 2 |
15881 | 15881 | 15880 | {"type": "MultiPolygon", "coordinates": [[[[-122.24752, 37.36739], [-122.24655, 37.36924], [-122.24658, 37.36972], [-122.24653, 37.37], [-122.24647, 37.37008], [-122.24635, 37.37037], [-122.24568, 37.3708], [-122.24498, 37.37104], [-122.24458, 37.3714], [-122.24369, 37.37162], [-122.2429, 37.36945], [-122.24148, 37.36728], [-122.24144, 37.36727], [-122.24028, 37.36526], [-122.23943, 37.36495], [-122.23854, 37.36312], [-122.23881, 37.36224], [-122.23874, 37.36223], [-122.23849, 37.36209], [-122.23816, 37.36206], [-122.23782, 37.3621], [-122.23743, 37.3622], [-122.23723, 37.36231], [-122.23644, 37.36249], [-122.23619, 37.36249], [-122.23525, 37.36278], [-122.23477, 37.36298], [-122.23432, 37.36295], [-122.23413, 37.36305], [-122.23384, 37.36307], [-122.23366, 37.36324], [-122.23317, 37.3635], [-122.23274, 37.36356], [-122.23251, 37.36363], [-122.23236, 37.36382], [-122.23205, 37.364], [-122.23195, 37.36408], [-122.2317, 37.36407], [-122.23151, 37.36411], [-122.23138, 37.36409], [-122.23128, 37.36405], [-122.23117, 37.36408], [-122.23112, 37.36407], [-122.2307, 37.36415], [-122.23059, 37.36431], [-122.2303, 37.36439], [-122.22983, 37.36475], [-122.22926, 37.36498], [-122.2279, 37.36471], [-122.22745, 37.3645], [-122.22702, 37.36435], [-122.22657, 37.36433], [-122.22614, 37.36421], [-122.22567, 37.36403], [-122.22539, 37.36402], [-122.22501, 37.36404], [-122.22445, 37.36401], [-122.22409, 37.36359], [-122.22378, 37.36358], [-122.2233, 37.36342], [-122.22288, 37.36344], [-122.22228, 37.36338], [-122.22228, 37.36307], [-122.22204, 37.36246], [-122.22203, 37.36231], [-122.22212, 37.36226], [-122.22216, 37.36211], [-122.22208, 37.36179], [-122.22211, 37.36162], [-122.22199, 37.36144], [-122.22188, 37.36137], [-122.22177, 37.36124], [-122.22173, 37.36102], [-122.22157, 37.36087], [-122.22156, 37.36068], [-122.22134, 37.36054], [-122.22126, 37.36044], [-122.22119, 37.36031], [-122.22109, 37.36005], [-122.221, 37.35992], [-122.22103, 37.35987], [-122.22109, 37.35958], [-122.22092, 37.35936], [-122.22073, 37.35929], [-122.2201, 37.3593], [-122.22008, 37.35915], [-122.22002, 37.359], [-122.21989, 37.35899], [-122.21963, 37.35904], [-122.21943, 37.35902], [-122.21937, 37.35895], [-122.21932, 37.35877], [-122.21906, 37.35821], [-122.21867, 37.35794], [-122.21863, 37.35787], [-122.21856, 37.35782], [-122.21864, 37.35745], [-122.21858, 37.35744], [-122.22022, 37.35664], [-122.21945, 37.35576], [-122.21773, 37.35675], [-122.21776, 37.35697], [-122.21768, 37.3569], [-122.21717, 37.35626], [-122.21708, 37.35599], [-122.21673, 37.35589], [-122.21666, 37.35579], [-122.21668, 37.35571], [-122.21663, 37.35557], [-122.21651, 37.35548], [-122.21643, 37.35539], [-122.21631, 37.3553], [-122.21626, 37.35519], [-122.21598, 37.35511], [-122.21592, 37.355], [-122.21585, 37.35492], [-122.21575, 37.35492], [-122.21573, 37.3549], [-122.21562, 37.35487], [-122.21555, 37.35483], [-122.2154, 37.3547], [-122.21523, 37.35453], [-122.21517, 37.35449], [-122.215, 37.35446], [-122.21482, 37.35447], [-122.21465, 37.35443], [-122.21456, 37.35437], [-122.21444, 37.35424], [-122.21434, 37.3542], [-122.21425, 37.3542], [-122.21383, 37.35401], [-122.21377, 37.35393], [-122.21363, 37.35382], [-122.21341, 37.35379], [-122.21321, 37.35382], [-122.21296, 37.35382], [-122.21283, 37.35383], [-122.21271, 37.35382], [-122.21261, 37.35373], [-122.21281, 37.35336], [-122.2132, 37.35312], [-122.21391, 37.35233], [-122.21423, 37.3521], [-122.2143, 37.35201], [-122.21435, 37.35197], [-122.21442, 37.35196], [-122.21446, 37.35198], [-122.21445, 37.352], [-122.21475, 37.35238], [-122.21478, 37.35262], [-122.21498, 37.35272], [-122.215, 37.35284], [-122.21569, 37.35314], [-122.2158, 37.35351], [-122.21594, 37.35359], [-122.21621, 37.3536], [-122.21652, 37.35354], [-122.21659, 37.35378], [-122.21678, 37.3538], [-122.21705, 37.35401], [-122.21756, 37.35421], [-122.21796, 37.35456], [-122.21759, 37.35459], [-122.21735, 37.35441], [-122.2165, 37.35441], [-122.2165, 37.35442], [-122.21664, 37.35468], [-122.21638, 37.3548], [-122.21681, 37.35519], [-122.21707, 37.35574], [-122.21768, 37.35574], [-122.21775, 37.35584], [-122.21829, 37.35551], [-122.21848, 37.35534], [-122.21873, 37.35507], [-122.2189, 37.35482], [-122.21911, 37.3546], [-122.2194, 37.3542], [-122.21962, 37.35398], [-122.22045, 37.35325], [-122.22076, 37.353], [-122.22128, 37.35263], [-122.22137, 37.35254], [-122.22176, 37.35229], [-122.22212, 37.35193], [-122.22268, 37.35156], [-122.2229, 37.3514], [-122.22304, 37.35127], [-122.22336, 37.3509], [-122.22387, 37.35058], [-122.22417, 37.35034], [-122.2245, 37.35013], [-122.2248, 37.34988], [-122.22521, 37.34965], [-122.22576, 37.34919], [-122.22619, 37.34889], [-122.22665, 37.34852], [-122.227, 37.34824], [-122.2274, 37.34782], [-122.2275, 37.34774], [-122.22768, 37.34765], [-122.22773, 37.34761], [-122.22791, 37.34743], [-122.22805, 37.34724], [-122.22841, 37.34691], [-122.22841, 37.34689], [-122.22797, 37.34671], [-122.2279, 37.3448], [-122.22809, 37.3449], [-122.22834, 37.34506], [-122.22859, 37.34526], [-122.22878, 37.34547], [-122.22892, 37.34566], [-122.22981, 37.34713], [-122.23002, 37.34741], [-122.2302, 37.34762], [-122.23042, 37.34784], [-122.23072, 37.34811], [-122.23105, 37.34835], [-122.23142, 37.34859], [-122.23182, 37.3488], [-122.23224, 37.34898], [-122.23268, 37.34913], [-122.23304, 37.34923], [-122.23363, 37.34935], [-122.23425, 37.34945], [-122.23552, 37.34959], [-122.23591, 37.34967], [-122.2363, 37.34979], [-122.23656, 37.3499], [-122.2368, 37.35003], [-122.23914, 37.35134], [-122.23965, 37.35168], [-122.23992, 37.35188], [-122.24026, 37.35218], [-122.24171, 37.35386], [-122.24376, 37.35608], [-122.24416, 37.35641], [-122.24459, 37.35671], [-122.24583, 37.35741], [-122.2461, 37.35759], [-122.24651, 37.3579], [-122.24681, 37.35822], [-122.2471, 37.35861], [-122.24731, 37.35903], [-122.24744, 37.35941], [-122.24749, 37.35964], [-122.24751, 37.35986], [-122.24751, 37.36026], [-122.24745, 37.36065], [-122.24679, 37.36269], [-122.24674, 37.36289], [-122.24673, 37.36312], [-122.24677, 37.36346], [-122.24688, 37.36378], [-122.24696, 37.36394], [-122.24708, 37.36411], [-122.24733, 37.36439], [-122.2475, 37.36463], [-122.24764, 37.36493], [-122.24772, 37.36523], [-122.24774, 37.36554], [-122.24771, 37.36578], [-122.24767, 37.36595], [-122.24747, 37.36657], [-122.24743, 37.3668], [-122.24744, 37.36712], [-122.24752, 37.36739]], [[-122.22616, 37.35966], [-122.2261, 37.35967], [-122.22575, 37.35982], [-122.22558, 37.35994], [-122.2255, 37.35996], [-122.2254, 37.35994], [-122.22531, 37.35986], [-122.22518, 37.35973], [-122.22505, 37.35944], [-122.22507, 37.35919], [-122.22506, 37.35901], [-122.22433, 37.35893], [-122.22289, 37.35896], [-122.22219, 37.35909], [-122.22184, 37.35932], [-122.22173, 37.35963], [-122.22215, 37.36033], [-122.22227, 37.36063], [-122.22247, 37.36149], [-122.22275, 37.36167], [-122.22312, 37.36177], [-122.22363, 37.36179], [-122.22412, 37.36176], [-122.22476, 37.36168], [-122.22529, 37.36156], [-122.22565, 37.36126], [-122.22609, 37.36055], [-122.22642, 37.36012], [-122.22654, 37.35992], [-122.22625, 37.35968], [-122.22616, 37.35966]], [[-122.23546, 37.35815], [-122.2353, 37.35888], [-122.23545, 37.35894], [-122.23751, 37.35665], [-122.23759, 37.35609], [-122.2376, 37.35559], [-122.23759, 37.35552], [-122.23729, 37.35482], [-122.23608, 37.35435], [-122.2354, 37.3544], [-122.23383, 37.35358], [-122.23378, 37.35285], [-122.2331, 37.35325], [-122.23239, 37.35338], [-122.23202, 37.35312], [-122.23137, 37.35377], [-122.23087, 37.35392], [-122.23204, 37.35641], [-122.23212, 37.35646], [-122.23449, 37.3571], [-122.23474, 37.3578], [-122.23546, 37.35815]]], [[[-122.2255, 37.37388], [-122.22506, 37.3739], [-122.22475, 37.37397], [-122.22461, 37.37407], [-122.22416, 37.37419], [-122.22398, 37.37399], [-122.22407, 37.37385], [-122.22399, 37.37368], [-122.22376, 37.37369], [-122.22335, 37.37324], [-122.2232, 37.37298], [-122.22316, 37.37275], [-122.22285, 37.37221], [-122.22267, 37.37177], [-122.22385, 37.37132], [-122.22414, 37.37133], [-122.22438, 37.3714], [-122.22459, 37.37157], [-122.2245, 37.37183], [-122.22445, 37.37208], [-122.22413, 37.37238], [-122.22398, 37.37268], [-122.22416, 37.373], [-122.22437, 37.37322], [-122.22476, 37.37349], [-122.22495, 37.37376], [-122.22522, 37.37383], [-122.2255, 37.37388]]]]} | Open Access 1 | 2221 | Windy Hill Open Space Preserve | 31499 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_windy_hill.asp | San Mateo 15 | 870.121 | Windy Hill OSP | 1980 | Local Conservation Area 4 | 2 |
15907 | 15907 | 15906 | {"type": "MultiPolygon", "coordinates": [[[[-122.20162, 37.34117], [-122.20145, 37.3412], [-122.20132, 37.34124], [-122.20127, 37.34121], [-122.20119, 37.34125], [-122.20133, 37.34095], [-122.20031, 37.34032], [-122.20019, 37.34029], [-122.1995, 37.33999], [-122.19945, 37.33991], [-122.19933, 37.33989], [-122.19929, 37.33989], [-122.19923, 37.33968], [-122.19909, 37.33965], [-122.19905, 37.33925], [-122.19883, 37.33904], [-122.19884, 37.33866], [-122.19875, 37.3386], [-122.19862, 37.33816], [-122.19858, 37.33785], [-122.19841, 37.33732], [-122.19815, 37.33713], [-122.19808, 37.3367], [-122.19788, 37.33646], [-122.19792, 37.33614], [-122.19817, 37.33597], [-122.19833, 37.33506], [-122.19818, 37.33498], [-122.19826, 37.33481], [-122.19817, 37.33454], [-122.19793, 37.33421], [-122.1977, 37.33415], [-122.1977, 37.33413], [-122.19767, 37.33412], [-122.19774, 37.33399], [-122.19751, 37.33391], [-122.19755, 37.33379], [-122.19741, 37.3336], [-122.19741, 37.33333], [-122.19726, 37.33331], [-122.19721, 37.33313], [-122.19692, 37.33308], [-122.19678, 37.33292], [-122.19828, 37.33355], [-122.19843, 37.33408], [-122.19862, 37.33422], [-122.1986, 37.33456], [-122.19864, 37.33463], [-122.19892, 37.33497], [-122.19893, 37.33536], [-122.19882, 37.33569], [-122.19883, 37.33578], [-122.19899, 37.33609], [-122.1989, 37.33619], [-122.19885, 37.33627], [-122.19884, 37.33635], [-122.19886, 37.33646], [-122.19891, 37.33653], [-122.19902, 37.33662], [-122.19911, 37.33668], [-122.19943, 37.33682], [-122.19945, 37.3373], [-122.1997, 37.33771], [-122.19977, 37.33777], [-122.1999, 37.33783], [-122.19998, 37.33789], [-122.20009, 37.3381], [-122.20012, 37.33814], [-122.2002, 37.33833], [-122.20018, 37.33836], [-122.20005, 37.33837], [-122.19983, 37.33798], [-122.19976, 37.33793], [-122.1995, 37.3378], [-122.19929, 37.3374], [-122.19922, 37.33737], [-122.19909, 37.33739], [-122.19903, 37.33743], [-122.19901, 37.33747], [-122.19912, 37.33807], [-122.19909, 37.33826], [-122.19918, 37.33844], [-122.19919, 37.3386], [-122.19922, 37.33867], [-122.19937, 37.33887], [-122.1995, 37.3392], [-122.19986, 37.33938], [-122.19994, 37.33943], [-122.20007, 37.33964], [-122.20023, 37.33979], [-122.2004, 37.33999], [-122.20052, 37.34009], [-122.20071, 37.34033], [-122.20084, 37.34042], [-122.20106, 37.3405], [-122.20114, 37.34056], [-122.20123, 37.34077], [-122.20129, 37.34085], [-122.20135, 37.34088], [-122.20142, 37.3409], [-122.20159, 37.34086], [-122.20168, 37.34087], [-122.20207, 37.34108], [-122.20213, 37.34119], [-122.20208, 37.34125], [-122.20203, 37.34127], [-122.20185, 37.3412], [-122.20162, 37.34117]]], [[[-122.21703, 37.33596], [-122.21681, 37.33843], [-122.21455, 37.33843], [-122.21454, 37.33776], [-122.20997, 37.33775], [-122.20996, 37.33883], [-122.20676, 37.33739], [-122.2035, 37.34209], [-122.20284, 37.34204], [-122.20261, 37.34184], [-122.20232, 37.34191], [-122.20188, 37.34161], [-122.20152, 37.34141], [-122.20141, 37.34132], [-122.20155, 37.34126], [-122.20169, 37.34126], [-122.20184, 37.34129], [-122.20198, 37.34136], [-122.2021, 37.34136], [-122.20215, 37.34134], [-122.20226, 37.34121], [-122.20227, 37.34117], [-122.20226, 37.34113], [-122.20208, 37.341], [-122.20174, 37.3408], [-122.20163, 37.34078], [-122.20143, 37.34084], [-122.20139, 37.34083], [-122.20131, 37.34065], [-122.20119, 37.34048], [-122.2011, 37.34042], [-122.20089, 37.34036], [-122.2008, 37.3403], [-122.20064, 37.34007], [-122.2005, 37.33993], [-122.20039, 37.33975], [-122.20019, 37.33955], [-122.20007, 37.33936], [-122.19995, 37.33927], [-122.19969, 37.33916], [-122.19964, 37.33912], [-122.19952, 37.33882], [-122.19937, 37.33862], [-122.19935, 37.33855], [-122.19934, 37.33842], [-122.19925, 37.33824], [-122.19928, 37.33803], [-122.19917, 37.3375], [-122.19936, 37.33788], [-122.19943, 37.33793], [-122.1997, 37.33806], [-122.19989, 37.33841], [-122.19994, 37.33846], [-122.20006, 37.3385], [-122.20029, 37.33846], [-122.20035, 37.33841], [-122.20037, 37.33835], [-122.20021, 37.33791], [-122.20017, 37.33783], [-122.20004, 37.3377], [-122.19983, 37.3376], [-122.19962, 37.33727], [-122.1996, 37.33684], [-122.19957, 37.33677], [-122.19951, 37.33671], [-122.19908, 37.33652], [-122.19902, 37.33644], [-122.199, 37.33638], [-122.19902, 37.3363], [-122.19912, 37.33617], [-122.19915, 37.33608], [-122.19913, 37.33599], [-122.19899, 37.33578], [-122.19898, 37.33571], [-122.19899, 37.33565], [-122.19909, 37.33535], [-122.19907, 37.33493], [-122.19876, 37.33456], [-122.19878, 37.33422], [-122.19872, 37.33413], [-122.19858, 37.33405], [-122.19847, 37.33365], [-122.19852, 37.33366], [-122.1985, 37.33355], [-122.19817, 37.33325], [-122.19827, 37.33286], [-122.19822, 37.33267], [-122.19848, 37.33288], [-122.19916, 37.33326], [-122.19941, 37.33312], [-122.19916, 37.33292], [-122.19889, 37.33232], [-122.19868, 37.33209], [-122.19859, 37.33195], [-122.19862, 37.33194], [-122.19906, 37.33215], [-122.19934, 37.33194], [-122.19881, 37.33156], [-122.19829, 37.33084], [-122.19803, 37.33065], [-122.19788, 37.33042], [-122.19764, 37.33017], [-122.19748, 37.32965], [-122.19716, 37.32961], [-122.197, 37.32934], [-122.19666, 37.32931], [-122.19621, 37.32898], [-122.19601, 37.32851], [-122.19612, 37.32825], [-122.19585, 37.3281], [-122.1957, 37.32783], [-122.19575, 37.3278], [-122.19531, 37.32673], [-122.19551, 37.32664], [-122.19532, 37.32643], [-122.19509, 37.32651], [-122.19399, 37.32595], [-122.19394, 37.32599], [-122.19371, 37.32595], [-122.19339, 37.32608], [-122.19313, 37.32605], [-122.19287, 37.32612], [-122.19249, 37.32575], [-122.1924, 37.32501], [-122.19254, 37.32483], [-122.19244, 37.32453], [-122.19272, 37.32431], [-122.19286, 37.32384], [-122.19265, 37.32374], [-122.19258, 37.32379], [-122.19221, 37.32392], [-122.19203, 37.32388], [-122.19171, 37.32351], [-122.19126, 37.32347], [-122.19092, 37.32322], [-122.19107, 37.32269], [-122.19066, 37.32232], [-122.19036, 37.32231], [-122.1901, 37.32074], [-122.18973, 37.32096], [-122.18923, 37.32091], [-122.18899, 37.32087], [-122.1887, 37.32105], [-122.18873, 37.321], [-122.18874, 37.32094], [-122.18897, 37.32079], [-122.18924, 37.32084], [-122.18971, 37.32088], [-122.19004, 37.32068], [-122.19021, 37.32051], [-122.19038, 37.32039], [-122.19055, 37.32034], [-122.19053, 37.32024], [-122.19162, 37.31968], [-122.19383, 37.32049], [-122.19451, 37.32151], [-122.19472, 37.32157], [-122.19607, 37.32092], [-122.19688, 37.32094], [-122.1971, 37.32111], [-122.19735, 37.32069], [-122.19765, 37.32087], [-122.19797, 37.3211], [-122.19855, 37.32163], [-122.19883, 37.32185], [-122.20026, 37.32285], [-122.20043, 37.32296], [-122.20095, 37.32326], [-122.20167, 37.32361], [-122.20242, 37.32393], [-122.20295, 37.32413], [-122.20321, 37.32435], [-122.2044, 37.3248], [-122.20457, 37.32478], [-122.20487, 37.32497], [-122.20508, 37.32513], [-122.20533, 37.32533], [-122.20551, 37.32552], [-122.20509, 37.32527], [-122.2048, 37.32522], [-122.20397, 37.32544], [-122.20168, 37.32504], [-122.20066, 37.32505], [-122.20023, 37.32521], [-122.19942, 37.32502], [-122.19943, 37.32863], [-122.20089, 37.32864], [-122.20089, 37.33045], [-122.20452, 37.33043], [-122.20432, 37.33283], [-122.20594, 37.33284], [-122.20636, 37.33421], [-122.20831, 37.33389], [-122.20811, 37.33256], [-122.21127, 37.33123], [-122.21439, 37.33295], [-122.21459, 37.33308], [-122.21486, 37.33327], [-122.21516, 37.33356], [-122.21542, 37.33388], [-122.21562, 37.33422], [-122.21577, 37.33459], [-122.2159, 37.33478], [-122.21613, 37.33501], [-122.21636, 37.33518], [-122.21703, 37.33596]], [[-122.21029, 37.33465], [-122.20943, 37.33451], [-122.20853, 37.33408], [-122.20832, 37.33391], [-122.20756, 37.33569], [-122.21007, 37.33665], [-122.21029, 37.33465]]]]} | Open Access 1 | 13259 | Coal Creek Open Space Preserve | 31501 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_coal_creek.asp | San Mateo 15 | 461.928 | Coal Creek OSP | 1980 | Local Conservation Area 4 | 2 |
15929 | 15929 | 15928 | {"type": "MultiPolygon", "coordinates": [[[[-122.09236, 37.29412], [-122.0922, 37.29481], [-122.09205, 37.29517], [-122.09202, 37.29545], [-122.09195, 37.29554], [-122.09186, 37.29557], [-122.09174, 37.29555], [-122.09096, 37.29504], [-122.09083, 37.29497], [-122.09076, 37.29495], [-122.09061, 37.29494], [-122.09015, 37.29494], [-122.08978, 37.29492], [-122.0897, 37.29493], [-122.08954, 37.29498], [-122.08942, 37.29507], [-122.08925, 37.29531], [-122.08921, 37.29544], [-122.08919, 37.29557], [-122.08922, 37.29596], [-122.0892, 37.29599], [-122.08914, 37.29602], [-122.08868, 37.29592], [-122.08802, 37.29585], [-122.08755, 37.29574], [-122.08644, 37.29559], [-122.08633, 37.29553], [-122.08606, 37.29516], [-122.08597, 37.29512], [-122.08585, 37.29514], [-122.08576, 37.29521], [-122.08575, 37.29529], [-122.08591, 37.29585], [-122.08603, 37.29602], [-122.08633, 37.29627], [-122.08534, 37.29585], [-122.08517, 37.29576], [-122.08465, 37.29543], [-122.0844, 37.29534], [-122.08432, 37.29533], [-122.08419, 37.29536], [-122.08324, 37.29492], [-122.08295, 37.29483], [-122.08232, 37.29469], [-122.08221, 37.29464], [-122.08209, 37.29455], [-122.08196, 37.29437], [-122.08192, 37.29428], [-122.08191, 37.2941], [-122.08201, 37.2935], [-122.08229, 37.29307], [-122.08232, 37.29298], [-122.08233, 37.2929], [-122.08231, 37.29273], [-122.08189, 37.29128], [-122.08176, 37.29073], [-122.08138, 37.29001], [-122.08108, 37.28922], [-122.08086, 37.28844], [-122.08079, 37.2883], [-122.08063, 37.28809], [-122.08025, 37.2878], [-122.08027, 37.28748], [-122.08047, 37.28686], [-122.08072, 37.28654], [-122.08099, 37.28635], [-122.08332, 37.28635], [-122.08436, 37.28458], [-122.07757, 37.2818], [-122.07756, 37.27969], [-122.08644, 37.27949], [-122.08647, 37.28636], [-122.08823, 37.28637], [-122.088, 37.28662], [-122.08798, 37.28715], [-122.08828, 37.28759], [-122.08865, 37.28802], [-122.08902, 37.289], [-122.08912, 37.2895], [-122.08924, 37.28998], [-122.09087, 37.29064], [-122.09092, 37.29087], [-122.09087, 37.29107], [-122.09054, 37.29124], [-122.09035, 37.29142], [-122.09024, 37.29164], [-122.09024, 37.29187], [-122.09014, 37.2921], [-122.09015, 37.29226], [-122.09046, 37.29259], [-122.09066, 37.29269], [-122.09101, 37.29272], [-122.09145, 37.29312], [-122.09169, 37.29327], [-122.09228, 37.29387], [-122.09236, 37.29412]]], [[[-122.08312, 37.295], [-122.08195, 37.29498], [-122.08197, 37.29463], [-122.08214, 37.29475], [-122.08227, 37.2948], [-122.0829, 37.29493], [-122.08312, 37.295]]], [[[-122.09259, 37.29525], [-122.09242, 37.29534], [-122.09223, 37.29571], [-122.09185, 37.29582], [-122.0917, 37.2959], [-122.09161, 37.29584], [-122.09135, 37.29576], [-122.09111, 37.29559], [-122.09097, 37.29551], [-122.09096, 37.29709], [-122.0893, 37.29614], [-122.08927, 37.29613], [-122.08934, 37.29607], [-122.08937, 37.29599], [-122.08933, 37.29557], [-122.08934, 37.29546], [-122.08938, 37.29535], [-122.08952, 37.29514], [-122.0896, 37.29508], [-122.08969, 37.29505], [-122.08979, 37.29503], [-122.09015, 37.29505], [-122.09061, 37.29505], [-122.09073, 37.29506], [-122.09084, 37.29511], [-122.09163, 37.29563], [-122.09179, 37.29568], [-122.09196, 37.29566], [-122.09206, 37.29561], [-122.09213, 37.29554], [-122.09216, 37.29545], [-122.09218, 37.2952], [-122.09229, 37.29496], [-122.09254, 37.29499], [-122.09259, 37.29525]]]]} | Open Access 1 | 18676 | Picchetti Ranch Open Space Preserve | 31449 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_picchetti.asp | Santa Clara 19 | 293.496 | Picchetti Ranch OSP | 1980 | Local Conservation Area 4 | 2 |
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]);