units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by GAP_STS
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6630 | 6630 | 6629 | {"type": "Polygon", "coordinates": [[[-122.82444, 38.42965], [-122.82442, 38.43055], [-122.8217, 38.43054], [-122.82214, 38.4304], [-122.82226, 38.43033], [-122.8223, 38.43029], [-122.8224, 38.43024], [-122.82275, 38.42998], [-122.82309, 38.42985], [-122.82395, 38.42972], [-122.82411, 38.42971], [-122.82444, 38.42965]]]} | No Public Access 3 | 4490 | Stone Farm | 25869 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 3.658 | Stone Farm | None 536 | |||
6641 | 6641 | 6640 | {"type": "Polygon", "coordinates": [[[-122.30898, 38.21963], [-122.30854, 38.22266], [-122.30777, 38.22425], [-122.30621, 38.22585], [-122.30316, 38.22649], [-122.30295, 38.22545], [-122.30208, 38.22003], [-122.29915, 38.22007], [-122.29928, 38.2196], [-122.30072, 38.21846], [-122.3028, 38.21904], [-122.30898, 38.21963]]]} | Open Access 1 | 4492 | Bull Island | 16501 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Napa 11 | 100.348 | Bull Island | None 537 | |||
6649 | 6649 | 6648 | {"type": "MultiPolygon", "coordinates": [[[[-118.29844, 34.44508], [-118.29404, 34.44509], [-118.29401, 34.44186], [-118.29504, 34.44221], [-118.2953, 34.44234], [-118.29557, 34.44244], [-118.2959, 34.44251], [-118.29627, 34.44254], [-118.29669, 34.44251], [-118.29719, 34.44244], [-118.29749, 34.44236], [-118.29796, 34.44218], [-118.29818, 34.44207], [-118.2984, 34.44193], [-118.29841, 34.44299], [-118.29831, 34.4431], [-118.29828, 34.44322], [-118.2983, 34.44331], [-118.29842, 34.44357], [-118.29842, 34.44367], [-118.29836, 34.44368], [-118.29816, 34.44362], [-118.29804, 34.44363], [-118.29796, 34.44367], [-118.29791, 34.44371], [-118.29788, 34.44377], [-118.29786, 34.44384], [-118.29788, 34.4444], [-118.29792, 34.44455], [-118.29799, 34.44466], [-118.29827, 34.44495], [-118.29835, 34.445], [-118.29844, 34.44502], [-118.29844, 34.44508]]], [[[-118.29807, 34.44144], [-118.29789, 34.44157], [-118.29769, 34.44168], [-118.29739, 34.44177], [-118.29685, 34.44187], [-118.29629, 34.4419], [-118.29592, 34.44188], [-118.29555, 34.44183], [-118.29557, 34.44176], [-118.29537, 34.44172], [-118.29486, 34.44142], [-118.29807, 34.44144]]], [[[-118.29843, 34.44485], [-118.29815, 34.44456], [-118.29809, 34.44445], [-118.29806, 34.44383], [-118.29808, 34.4438], [-118.29811, 34.44378], [-118.29815, 34.44378], [-118.29831, 34.44384], [-118.29842, 34.44384], [-118.29843, 34.44485]]]]} | Unknown Access 4 | 4665 | Long-Nellus Canyon | 21446 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 32.557 | Long-Nellus Canyon | None 538 | |||
6651 | 6651 | 6650 | {"type": "Polygon", "coordinates": [[[-117.87837, 33.59536], [-117.87829, 33.59549], [-117.87823, 33.59548], [-117.87796, 33.59574], [-117.87786, 33.59557], [-117.87787, 33.59553], [-117.87785, 33.5955], [-117.87783, 33.59546], [-117.87777, 33.59543], [-117.87717, 33.5953], [-117.87709, 33.59527], [-117.87713, 33.59521], [-117.87725, 33.59517], [-117.87731, 33.59512], [-117.87751, 33.5951], [-117.87769, 33.59511], [-117.87775, 33.59511], [-117.87787, 33.59515], [-117.87794, 33.5952], [-117.87806, 33.59524], [-117.87806, 33.59527], [-117.87812, 33.59531], [-117.87813, 33.59538], [-117.87817, 33.59535], [-117.87831, 33.59533], [-117.87837, 33.59536]]]} | Open Access 1 | 4684 | Lookout Point | 21462 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.842 | Lookout Point | None 539 | |||
6679 | 6679 | 6678 | {"type": "MultiPolygon", "coordinates": [[[[-122.52193, 37.91437], [-122.52122, 37.91441], [-122.52077, 37.91497], [-122.52075, 37.91564], [-122.52094, 37.91597], [-122.52066, 37.91613], [-122.5205, 37.91553], [-122.52063, 37.91523], [-122.52061, 37.91501], [-122.52074, 37.9147], [-122.52095, 37.91441], [-122.52118, 37.91393], [-122.52152, 37.91416], [-122.52193, 37.91437]]], [[[-122.52358, 37.91236], [-122.52323, 37.91296], [-122.52327, 37.91357], [-122.52336, 37.91366], [-122.52233, 37.91333], [-122.52169, 37.91355], [-122.5213, 37.91382], [-122.52128, 37.9138], [-122.52167, 37.91353], [-122.52216, 37.91336], [-122.52269, 37.91291], [-122.52332, 37.91232], [-122.52358, 37.91236]]], [[[-122.52406, 37.91453], [-122.52381, 37.91458], [-122.52354, 37.9146], [-122.52357, 37.91411], [-122.52384, 37.91412], [-122.52406, 37.91453]]], [[[-122.52567, 37.90731], [-122.52557, 37.90816], [-122.52545, 37.90865], [-122.52522, 37.90935], [-122.52466, 37.91037], [-122.52379, 37.90976], [-122.52386, 37.90971], [-122.5239, 37.90973], [-122.52417, 37.90979], [-122.52466, 37.91006], [-122.52512, 37.90909], [-122.52528, 37.90861], [-122.52539, 37.90811], [-122.52542, 37.90757], [-122.52541, 37.90754], [-122.52536, 37.90752], [-122.52477, 37.90751], [-122.52477, 37.9073], [-122.52567, 37.90731]]], [[[-122.52459, 37.91048], [-122.52445, 37.91076], [-122.52412, 37.91078], [-122.52412, 37.91024], [-122.52404, 37.91009], [-122.52459, 37.91048]]], [[[-122.52465, 37.91552], [-122.52427, 37.91542], [-122.5242, 37.91493], [-122.52409, 37.91468], [-122.52415, 37.91465], [-122.52465, 37.91552]]], [[[-122.52679, 37.91515], [-122.52674, 37.91529], [-122.52666, 37.91541], [-122.52561, 37.91629], [-122.52552, 37.91641], [-122.52547, 37.91655], [-122.52497, 37.91573], [-122.52533, 37.91554], [-122.52556, 37.91527], [-122.52587, 37.91521], [-122.52601, 37.91517], [-122.52615, 37.91479], [-122.52596, 37.91458], [-122.52542, 37.91423], [-122.52544, 37.91404], [-122.526, 37.91406], [-122.52604, 37.91421], [-122.52611, 37.91432], [-122.52661, 37.91472], [-122.52671, 37.91483], [-122.52677, 37.91496], [-122.52679, 37.91506], [-122.52679, 37.91515]]], [[[-122.52622, 37.90858], [-122.52616, 37.90867], [-122.52607, 37.90873], [-122.52567, 37.90861], [-122.52582, 37.90784], [-122.52606, 37.90792], [-122.52616, 37.90786], [-122.52601, 37.90813], [-122.52599, 37.90825], [-122.52601, 37.90834], [-122.52604, 37.90841], [-122.52611, 37.90848], [-122.5262, 37.90854], [-122.52622, 37.90858]]]]} | Open Access 1 | 4936 | Mill Valley Lands 001 | 22233 | 1204 | Mill Valley, City of 227 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | Marin 23 | 11.735 | Mill Valley Lands 001 | None 540 | |||
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 | |||
6688 | 6688 | 6687 | {"type": "Polygon", "coordinates": [[[-118.20763, 34.09293], [-118.20707, 34.09362], [-118.20668, 34.09339], [-118.20664, 34.09278], [-118.20667, 34.09239], [-118.20763, 34.09293]]]} | Open Access 1 | 4895 | Charles F. Lummis Home | 28729 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/dos/historic/lummis.htm | Los Angeles 6 | 1.743 | Charles F. Lummis Home | None 542 | ||
6704 | 6704 | 6703 | {"type": "Polygon", "coordinates": [[[-118.73648, 34.07426], [-118.73436, 34.0741], [-118.73435, 34.07234], [-118.73648, 34.07246], [-118.73648, 34.07426]]]} | Open Access 1 | 5002 | Malibu Bowl | 21702 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 9.556 | Malibu Bowl | None 543 | |||
6706 | 6706 | 6705 | {"type": "MultiPolygon", "coordinates": [[[[-122.56686, 37.90399], [-122.56556, 37.90444], [-122.5654, 37.90423], [-122.56514, 37.90416], [-122.56506, 37.904], [-122.56488, 37.90418], [-122.56472, 37.90425], [-122.56439, 37.90432], [-122.56421, 37.90434], [-122.56391, 37.90432], [-122.56353, 37.90438], [-122.56348, 37.90436], [-122.56345, 37.90429], [-122.56346, 37.90397], [-122.56358, 37.90378], [-122.56364, 37.90363], [-122.56371, 37.9036], [-122.56394, 37.90327], [-122.56393, 37.90326], [-122.56377, 37.90332], [-122.56382, 37.90306], [-122.56437, 37.90265], [-122.56482, 37.90304], [-122.56427, 37.90353], [-122.56477, 37.9039], [-122.56559, 37.90318], [-122.56559, 37.90387], [-122.56606, 37.90381], [-122.56638, 37.90383], [-122.56686, 37.90399]]], [[[-122.56496, 37.90436], [-122.56493, 37.90444], [-122.56474, 37.9048], [-122.56452, 37.90505], [-122.56412, 37.9049], [-122.56412, 37.90486], [-122.56496, 37.90436]]]]} | Open Access 1 | 5009 | Mill Valley Lands 003 | 22234 | 1204 | Mill Valley, City of 227 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | Marin 23 | 6.369 | Mill Valley Lands 003 | None 544 | |||
6732 | 6732 | 6731 | {"type": "Polygon", "coordinates": [[[-121.88549, 36.5946], [-121.88475, 36.59709], [-121.88351, 36.597], [-121.8834, 36.59675], [-121.88338, 36.59643], [-121.88343, 36.59604], [-121.88338, 36.59542], [-121.88332, 36.59527], [-121.88304, 36.59496], [-121.88291, 36.59479], [-121.88284, 36.59456], [-121.88276, 36.59438], [-121.88338, 36.59412], [-121.88549, 36.5946]]]} | Open Access 1 | 5146 | Cementerio El Encinal | 17006 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 12.673 | Cementerio El Encinal | None 545 | |||
6734 | 6734 | 6733 | {"type": "Polygon", "coordinates": [[[-121.94697, 37.73689], [-121.94504, 37.73765], [-121.94449, 37.73676], [-121.94458, 37.73673], [-121.94465, 37.73663], [-121.9447, 37.7366], [-121.94629, 37.73598], [-121.94635, 37.73601], [-121.94661, 37.73631], [-121.94697, 37.73689]]]} | Open Access 1 | 5066 | Boone Acres | 31281 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 5.452 | Boone Acres | None 546 | |||
6748 | 6748 | 6747 | {"type": "Polygon", "coordinates": [[[-122.70495, 38.54002], [-122.69591, 38.53995], [-122.69585, 38.53722], [-122.69581, 38.54015], [-122.69108, 38.54018], [-122.69113, 38.54204], [-122.69183, 38.54277], [-122.69244, 38.5437], [-122.69284, 38.54396], [-122.69307, 38.54474], [-122.69338, 38.54514], [-122.69313, 38.54524], [-122.69313, 38.54525], [-122.69393, 38.5458], [-122.69471, 38.54586], [-122.69553, 38.54629], [-122.69585, 38.54631], [-122.69602, 38.54627], [-122.6961, 38.55067], [-122.69333, 38.55066], [-122.69332, 38.5508], [-122.68703, 38.55091], [-122.68702, 38.54893], [-122.6868, 38.54892], [-122.6867, 38.54889], [-122.68631, 38.54853], [-122.68614, 38.54826], [-122.68595, 38.54804], [-122.68554, 38.54749], [-122.68546, 38.54725], [-122.68013, 38.54639], [-122.68015, 38.54353], [-122.67559, 38.54342], [-122.67577, 38.53648], [-122.6851, 38.5365], [-122.6852, 38.53294], [-122.69814, 38.53302], [-122.70492, 38.5362], [-122.70495, 38.54002]]]} | No Public Access 3 | 5106 | McCoullough | 22009 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 718.017 | McCoullough | None 547 | |||
6750 | 6750 | 6749 | {"type": "Polygon", "coordinates": [[[-122.20351, 38.39474], [-122.20319, 38.39454], [-122.20286, 38.39422], [-122.20272, 38.39405], [-122.20259, 38.39383], [-122.20236, 38.3935], [-122.20227, 38.39332], [-122.20224, 38.39304], [-122.20227, 38.39292], [-122.20234, 38.39283], [-122.20237, 38.39269], [-122.20236, 38.39256], [-122.2023, 38.39242], [-122.20223, 38.3923], [-122.20209, 38.39217], [-122.20207, 38.3921], [-122.20208, 38.392], [-122.20213, 38.39192], [-122.20226, 38.3916], [-122.20266, 38.39133], [-122.20249, 38.39094], [-122.20223, 38.39075], [-122.20181, 38.39006], [-122.20176, 38.38991], [-122.20181, 38.38973], [-122.20189, 38.38957], [-122.20196, 38.38931], [-122.20185, 38.38897], [-122.20163, 38.38873], [-122.20152, 38.38847], [-122.20151, 38.38838], [-122.20155, 38.38829], [-122.20162, 38.38801], [-122.20178, 38.38753], [-122.20178, 38.38737], [-122.20176, 38.38726], [-122.20165, 38.38706], [-122.20158, 38.38698], [-122.20153, 38.38687], [-122.20158, 38.38645], [-122.20157, 38.38591], [-122.20153, 38.38561], [-122.20147, 38.38547], [-122.20134, 38.38522], [-122.20117, 38.38497], [-122.2033, 38.38496], [-122.20351, 38.39474]]]} | Open Access 1 | 5115 | Department Of Transportation | 18098 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 32.678 | Department Of Transportation | None 548 | |||
6759 | 6759 | 6758 | {"type": "Polygon", "coordinates": [[[-122.22476, 38.22438], [-122.22475, 38.22525], [-122.2237, 38.22526], [-122.2237, 38.22472], [-122.22307, 38.22433], [-122.2222, 38.22245], [-122.22221, 38.22188], [-122.22324, 38.22127], [-122.22322, 38.22152], [-122.22316, 38.22152], [-122.22316, 38.22161], [-122.22261, 38.22185], [-122.22242, 38.22209], [-122.22241, 38.22244], [-122.22307, 38.22385], [-122.22384, 38.22431], [-122.22415, 38.22431], [-122.22452, 38.22437], [-122.22476, 38.22438]]]} | No Public Access 3 | 5145 | Department Of Water Resourses | 18099 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Napa 11 | 4.793 | Department Of Water Resourses | None 549 | |||
6771 | 6771 | 6770 | {"type": "Polygon", "coordinates": [[[-122.41405, 37.6856], [-122.41385, 37.68597], [-122.41335, 37.6858], [-122.41311, 37.68574], [-122.4128, 37.68572], [-122.41253, 37.68575], [-122.41221, 37.68585], [-122.41195, 37.68598], [-122.41174, 37.68617], [-122.41156, 37.6864], [-122.41138, 37.68639], [-122.41125, 37.68641], [-122.41108, 37.68647], [-122.41095, 37.68655], [-122.41057, 37.68658], [-122.409, 37.6869], [-122.40866, 37.68693], [-122.40836, 37.68692], [-122.4079, 37.68686], [-122.40301, 37.68482], [-122.40459, 37.68481], [-122.40461, 37.68524], [-122.40773, 37.68643], [-122.40809, 37.68653], [-122.40843, 37.68657], [-122.4087, 37.68658], [-122.40909, 37.68654], [-122.40928, 37.6865], [-122.41017, 37.68624], [-122.4102, 37.68629], [-122.41125, 37.68592], [-122.41151, 37.68581], [-122.41208, 37.6855], [-122.41232, 37.68542], [-122.41254, 37.68536], [-122.41288, 37.68533], [-122.41318, 37.68535], [-122.41357, 37.68543], [-122.41405, 37.6856]]]} | Open Access 1 | 5235 | Old Quarry Rd. | 23099 | 1035 | Brisbane, City of 686 | City 2 | City Agency 2 | http://www.ci.brisbane.ca.us/about-parks-and-recreation | City 2 | 1035 | Brisbane, City of 677 | City 2 | City Agency 2 | San Mateo 15 | 9.686 | Old Quarry Rd. | 2000 | None 550 | ||
6778 | 6778 | 6777 | {"type": "Polygon", "coordinates": [[[-122.25654, 38.2078], [-122.25633, 38.20788], [-122.2563, 38.20749], [-122.2564, 38.20753], [-122.25652, 38.20754], [-122.25654, 38.2078]]]} | No Public Access 3 | 5258 | Dept Of Transportation/Paul Kenny | 18103 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | Napa 11 | 0.163 | Dept Of Transportation/Paul Kenny | None 551 | |||
6788 | 6788 | 6787 | {"type": "MultiPolygon", "coordinates": [[[[-122.63946, 38.46568], [-122.63954, 38.46598], [-122.63951, 38.46603], [-122.63858, 38.46611], [-122.63834, 38.46616], [-122.63805, 38.46624], [-122.6376, 38.46642], [-122.63681, 38.46685], [-122.63661, 38.46692], [-122.63643, 38.46696], [-122.63643, 38.46686], [-122.63665, 38.46672], [-122.63668, 38.46645], [-122.63634, 38.46638], [-122.6362, 38.46615], [-122.63593, 38.46593], [-122.63559, 38.46578], [-122.63463, 38.46566], [-122.63425, 38.46523], [-122.63429, 38.46511], [-122.63442, 38.46493], [-122.6345, 38.46476], [-122.63493, 38.46478], [-122.63594, 38.46493], [-122.63706, 38.465], [-122.63703, 38.46523], [-122.63786, 38.46587], [-122.63806, 38.46577], [-122.63854, 38.46578], [-122.63878, 38.4657], [-122.63925, 38.46571], [-122.63946, 38.46568]]], [[[-122.64276, 38.46243], [-122.64271, 38.46272], [-122.64274, 38.46295], [-122.6428, 38.46311], [-122.64314, 38.46368], [-122.64318, 38.46382], [-122.64319, 38.46396], [-122.64315, 38.46412], [-122.64293, 38.4645], [-122.64276, 38.46484], [-122.64272, 38.46497], [-122.64266, 38.46521], [-122.6426, 38.46533], [-122.64254, 38.46542], [-122.64243, 38.46553], [-122.64231, 38.46561], [-122.64217, 38.46568], [-122.64201, 38.46573], [-122.64172, 38.46575], [-122.64129, 38.4657], [-122.64097, 38.46571], [-122.64075, 38.46574], [-122.63988, 38.46596], [-122.63981, 38.46598], [-122.63975, 38.46596], [-122.63965, 38.46563], [-122.63995, 38.46556], [-122.64013, 38.46537], [-122.64026, 38.46537], [-122.64042, 38.46524], [-122.64067, 38.46524], [-122.64089, 38.46516], [-122.64121, 38.46519], [-122.64139, 38.46506], [-122.64174, 38.46493], [-122.64199, 38.46474], [-122.64222, 38.46476], [-122.64235, 38.46468], [-122.64246, 38.46458], [-122.64245, 38.46452], [-122.64251, 38.46452], [-122.64257, 38.46239], [-122.64276, 38.46243]]], [[[-122.64526, 38.46328], [-122.64495, 38.46371], [-122.6449, 38.46375], [-122.64459, 38.4638], [-122.64455, 38.46376], [-122.64435, 38.46376], [-122.64434, 38.46378], [-122.64374, 38.46374], [-122.64361, 38.46405], [-122.64352, 38.46402], [-122.64352, 38.46382], [-122.64349, 38.46368], [-122.64344, 38.46355], [-122.64335, 38.4634], [-122.64376, 38.46324], [-122.64409, 38.46328], [-122.64436, 38.46334], [-122.64439, 38.463], [-122.64526, 38.46328]]]]} | Open Access 1 | 5290 | Skyhawk Parks | 25535 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 19.996 | Skyhawk Parks | None 552 | |||
6803 | 6803 | 6802 | {"type": "Polygon", "coordinates": [[[-118.57899, 34.14891], [-118.57845, 34.14895], [-118.57849, 34.14866], [-118.57892, 34.14859], [-118.57899, 34.14891]]]} | Unknown Access 4 | 5319 | MGP Entrance | 22194 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.379 | MGP Entrance | None 553 | |||
6818 | 6818 | 6817 | {"type": "MultiPolygon", "coordinates": [[[[-123.02044, 38.30739], [-123.02032, 38.30759], [-123.01898, 38.30678], [-123.01775, 38.30775], [-123.01734, 38.30784], [-123.01842, 38.30689], [-123.01802, 38.30655], [-123.01746, 38.30633], [-123.01739, 38.30606], [-123.01702, 38.30591], [-123.0167, 38.30553], [-123.01626, 38.30557], [-123.01569, 38.30569], [-123.01531, 38.30565], [-123.01508, 38.30559], [-123.01512, 38.30537], [-123.01498, 38.30531], [-123.01487, 38.3052], [-123.0148, 38.30502], [-123.01479, 38.30481], [-123.01452, 38.30454], [-123.0139, 38.30439], [-123.01392, 38.30419], [-123.01392, 38.30401], [-123.01383, 38.30389], [-123.01358, 38.30383], [-123.01338, 38.30382], [-123.01323, 38.30374], [-123.01305, 38.30358], [-123.01339, 38.30321], [-123.01434, 38.30362], [-123.01488, 38.30407], [-123.01517, 38.30465], [-123.01575, 38.30478], [-123.01764, 38.3054], [-123.01844, 38.3063], [-123.01939, 38.30691], [-123.02044, 38.30739]]], [[[-123.01475, 38.31344], [-123.01439, 38.3134], [-123.01424, 38.31289], [-123.01432, 38.31273], [-123.01441, 38.31278], [-123.01465, 38.31281], [-123.01475, 38.31344]]]]} | Open Access 1 | 5390 | Pinnacle Gulch | 23699 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 12.038 | Pinnacle Gulch | None 554 | |||
6844 | 6844 | 6843 | {"type": "Polygon", "coordinates": [[[-118.65109, 34.03761], [-118.65102, 34.03789], [-118.65008, 34.03771], [-118.6496, 34.03764], [-118.64921, 34.03765], [-118.64889, 34.0377], [-118.64882, 34.03758], [-118.64861, 34.03759], [-118.64839, 34.0377], [-118.64783, 34.03813], [-118.64748, 34.03823], [-118.64702, 34.03832], [-118.64694, 34.0382], [-118.64591, 34.03819], [-118.64439, 34.03805], [-118.64366, 34.03796], [-118.64298, 34.03782], [-118.64224, 34.03772], [-118.63951, 34.03714], [-118.6382, 34.03681], [-118.63828, 34.0365], [-118.63964, 34.03684], [-118.64039, 34.03708], [-118.64171, 34.03736], [-118.64261, 34.03748], [-118.64325, 34.03763], [-118.64555, 34.03791], [-118.64655, 34.03796], [-118.64744, 34.03791], [-118.64803, 34.03772], [-118.64845, 34.03742], [-118.64907, 34.0373], [-118.64975, 34.03736], [-118.65109, 34.03761]]]} | Open Access 1 | 5473 | La Costa Beach | 29045 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Los Angeles 6 | 9.122 | La Costa Beach | None 555 |
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]);