units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where ACCESS_TYP = 1 and YR_EST = 2018
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, YR_EST
MNG_AG_TYP 5
DES_TP 5
- Local Park 16
- Local Recreation Area 6
- Private Conservation 2
- None 1
- None 1
ACCESS_TYP 1
- Open Access · 26 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
409 | 409 | 408 | {"type": "Polygon", "coordinates": [[[-121.84613, 37.71921], [-121.8461, 37.71922], [-121.84608, 37.71928], [-121.84603, 37.71931], [-121.84534, 37.71946], [-121.84486, 37.71953], [-121.84439, 37.71957], [-121.84435, 37.71956], [-121.84433, 37.71954], [-121.8443, 37.71954], [-121.84428, 37.71905], [-121.84432, 37.71882], [-121.84438, 37.7186], [-121.84448, 37.71838], [-121.84461, 37.71818], [-121.84485, 37.7179], [-121.84492, 37.71786], [-121.84498, 37.71786], [-121.84503, 37.71789], [-121.84529, 37.7181], [-121.84554, 37.71833], [-121.84584, 37.71871], [-121.84599, 37.71894], [-121.84613, 37.71921]]]} | Open Access 1 | 48353 | Sean Diamond Park | 32917 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Sean-Diamond-Park-33 | Alameda 17 | 4.986 | Sean Diamond Park | 2018 | Local Park 2 | 4 |
497 | 497 | 496 | {"type": "Polygon", "coordinates": [[[-117.31082, 33.65409], [-117.31079, 33.65427], [-117.30502, 33.65344], [-117.30504, 33.65336], [-117.30568, 33.65345], [-117.30583, 33.65264], [-117.30709, 33.65186], [-117.30779, 33.65154], [-117.30788, 33.65166], [-117.30804, 33.65157], [-117.30845, 33.65132], [-117.30899, 33.65089], [-117.31082, 33.65409]]]} | Open Access 1 | 48360 | Summerly Community Park | 32925 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/city-hall/community-services/parks-and-facilities/parks/summerly-park-2232#ad-image-3 | Riverside 10 | 24.134 | Summerly Community Park | 2018 | Local Park 2 | 4 |
1691 | 1691 | 1690 | {"type": "Polygon", "coordinates": [[[-118.80576, 34.14426], [-118.8047, 34.14528], [-118.80453, 34.14521], [-118.80449, 34.14517], [-118.80449, 34.14512], [-118.80453, 34.14505], [-118.80458, 34.14491], [-118.8046, 34.14475], [-118.80459, 34.14458], [-118.80453, 34.14442], [-118.80447, 34.14433], [-118.80433, 34.14417], [-118.80363, 34.14356], [-118.80351, 34.14348], [-118.80339, 34.14343], [-118.8035, 34.1432], [-118.80331, 34.14264], [-118.80264, 34.14255], [-118.80005, 34.14275], [-118.79893, 34.14304], [-118.79865, 34.14331], [-118.7987, 34.14355], [-118.7982, 34.14363], [-118.79819, 34.14374], [-118.79827, 34.14399], [-118.79828, 34.1443], [-118.79819, 34.14431], [-118.7982, 34.14496], [-118.79803, 34.14496], [-118.79803, 34.14247], [-118.7992, 34.14145], [-118.80462, 34.14143], [-118.8045, 34.14253], [-118.8046, 34.14314], [-118.80376, 34.14324], [-118.80375, 34.14354], [-118.80397, 34.14383], [-118.80444, 34.14425], [-118.80498, 34.14465], [-118.80511, 34.14463], [-118.80562, 34.14413], [-118.80567, 34.14419], [-118.80576, 34.14426]]]} | Open Access 1 | 12745 | Westlake Village City Parkland | 27404 | 1377 | Westlake Village, City of 321 | City 2 | City Agency 2 | http://www.wlv.org/index.aspx?nid=194 | City 2 | 1377 | Westlake Village, City of 318 | City 2 | City Agency 2 | Los Angeles 6 | 24.679 | Westlake Village City Parkland | 2018 | Local Park 2 | 4 | |
2818 | 2818 | 2817 | {"type": "Polygon", "coordinates": [[[-122.11574, 38.47849], [-122.11574, 38.47849], [-122.11078, 38.47847], [-122.1109, 38.47791], [-122.11112, 38.47745], [-122.11138, 38.47716], [-122.11159, 38.47699], [-122.11178, 38.47681], [-122.11211, 38.47637], [-122.11245, 38.47602], [-122.11269, 38.47575], [-122.11301, 38.4753], [-122.1131, 38.47522], [-122.11313, 38.47502], [-122.11317, 38.47487], [-122.1155, 38.47489], [-122.11574, 38.47849]]]} | Open Access 1 | 48612 | Huber Ranch | 33327 | 3095 | Tuleyome 558 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tuleyome.org/ | Non Governmental Organization 10 | 3095 | Tuleyome 551 | Non Profit 6 | Non Profit - Land Trust 10 | http://tuleyome.org/properties/ | Napa 11 | 32.139 | Huber Ranch | 2018 | Private Conservation 16 | 2 |
2819 | 2819 | 2818 | {"type": "Polygon", "coordinates": [[[-122.113, 38.47524], [-122.1129, 38.47543], [-122.11277, 38.47564], [-122.11254, 38.47593], [-122.11209, 38.4764], [-122.11176, 38.47685], [-122.11121, 38.47734], [-122.11105, 38.47756], [-122.11094, 38.47777], [-122.11086, 38.47808], [-122.11081, 38.4784], [-122.11074, 38.47867], [-122.09694, 38.47855], [-122.09695, 38.47505], [-122.113, 38.47524]]]} | Open Access 1 | 48613 | Huber Ranch | 33327 | 3095 | Tuleyome 558 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tuleyome.org/ | Non Governmental Organization 10 | 3095 | Tuleyome 551 | Non Profit 6 | Non Profit - Land Trust 10 | http://tuleyome.org/properties/ | Solano 26 | 122.632 | Huber Ranch | 2018 | Private Conservation 16 | 2 |
3100 | 3100 | 3099 | {"type": "Polygon", "coordinates": [[[-121.7493, 38.65674], [-121.7482, 38.65674], [-121.74816, 38.65671], [-121.74818, 38.65582], [-121.74873, 38.65584], [-121.7493, 38.65631], [-121.7493, 38.65674]]]} | Open Access 1 | 48688 | Spring Lake Park | 33427 | 1383 | Woodlake, City of 175 | City 2 | City Agency 2 | http://www.cityofwoodlake.com/ | City 2 | 1383 | Woodlake, City of 171 | City 2 | City Agency 2 | https://www.cityofwoodland.org/Facilities/Facility/Details/Spring-Lake-Park-23 | Yolo 33 | 2.116 | Spring Lake Park | 2018 | Local Park 2 | 4 |
4303 | 4303 | 4302 | {"type": "Polygon", "coordinates": [[[-117.74684, 34.02858], [-117.74645, 34.02859], [-117.74644, 34.02843], [-117.74684, 34.02842], [-117.74684, 34.02858]]]} | Open Access 1 | 48156 | Esperanza y Alegria Park | 32693 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 0.165 | Esperanza y Alegria Park | 2018 | Local Park 2 | 4 | |
4982 | 4982 | 4981 | {"type": "Polygon", "coordinates": [[[-118.69531, 34.53365], [-118.68395, 34.54742], [-118.66213, 34.52116], [-118.67143, 34.51291], [-118.67786, 34.51284], [-118.67792, 34.52747], [-118.69514, 34.52747], [-118.69531, 34.53365]]]} | Open Access 1 | 48529 | Temescal Ranch Open Space | 33243 | 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 | 1228.189 | Temescal Ranch OS | 2018 | Local Recreation Area 3 | 4 | |
5476 | 5476 | 5475 | {"type": "MultiPolygon", "coordinates": [[[[-121.20025, 38.80451], [-121.20011, 38.80463], [-121.19978, 38.80457], [-121.19988, 38.80436], [-121.19994, 38.80433], [-121.19999, 38.80435], [-121.20025, 38.80451]]], [[[-121.20098, 38.80218], [-121.20095, 38.80387], [-121.20031, 38.80445], [-121.20003, 38.80428], [-121.20002, 38.80423], [-121.2001, 38.80415], [-121.20041, 38.80395], [-121.20055, 38.80383], [-121.20068, 38.80368], [-121.20079, 38.80349], [-121.20086, 38.8033], [-121.2009, 38.8031], [-121.20093, 38.80218], [-121.20098, 38.80218]]]]} | Open Access 1 | 49032 | Christine Anderson Park | 33734 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.247 | Christine Anderson Park | 2018 | Local Park 2 | 4 | |
6186 | 6186 | 6185 | {"type": "Polygon", "coordinates": [[[-121.85783, 37.71464], [-121.85783, 37.71473], [-121.85752, 37.71497], [-121.85728, 37.71519], [-121.85684, 37.71563], [-121.85657, 37.71602], [-121.85649, 37.71603], [-121.85605, 37.71585], [-121.85602, 37.71588], [-121.85346, 37.71482], [-121.85305, 37.71458], [-121.8528, 37.71439], [-121.85265, 37.71425], [-121.85239, 37.71397], [-121.85226, 37.71378], [-121.85214, 37.71356], [-121.85206, 37.71337], [-121.85199, 37.71316], [-121.85194, 37.71283], [-121.85194, 37.71254], [-121.85207, 37.71144], [-121.85213, 37.71121], [-121.85217, 37.71065], [-121.85226, 37.71059], [-121.8536, 37.71047], [-121.85423, 37.71036], [-121.85473, 37.71025], [-121.85511, 37.71013], [-121.85563, 37.70992], [-121.85597, 37.70976], [-121.85643, 37.7095], [-121.85715, 37.70914], [-121.85726, 37.70917], [-121.85745, 37.70949], [-121.85759, 37.70985], [-121.85766, 37.71022], [-121.85766, 37.71057], [-121.85762, 37.71079], [-121.85756, 37.71101], [-121.85703, 37.71255], [-121.85698, 37.7128], [-121.85697, 37.71317], [-121.85701, 37.71341], [-121.85708, 37.71364], [-121.85725, 37.71398], [-121.85748, 37.71429], [-121.85783, 37.71464]]]} | Open Access 1 | 48347 | Fallon Sports Park | 32911 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Fallon-Sports-Park-22 | Alameda 17 | 65.297 | Fallon Sports Park | 2018 | Local Recreation Area 3 | 4 |
6187 | 6187 | 6186 | {"type": "Polygon", "coordinates": [[[-121.84712, 37.7135], [-121.84714, 37.71357], [-121.8472, 37.71362], [-121.84726, 37.71372], [-121.84732, 37.71388], [-121.84734, 37.71403], [-121.84733, 37.71419], [-121.84728, 37.71435], [-121.8472, 37.71449], [-121.84701, 37.71468], [-121.84686, 37.71478], [-121.84668, 37.71486], [-121.84649, 37.71491], [-121.84569, 37.71507], [-121.84554, 37.71508], [-121.84533, 37.71505], [-121.8452, 37.71499], [-121.84505, 37.71487], [-121.84496, 37.71472], [-121.84487, 37.71469], [-121.84546, 37.71433], [-121.84589, 37.71411], [-121.84639, 37.7139], [-121.8468, 37.71366], [-121.84707, 37.71355], [-121.84712, 37.7135]]]} | Open Access 1 | 48348 | Jordan Ranch Park | 32912 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://ca-dublin2.civicplus.com/Facilities/Facility/Details/Jordan-Ranch-Park-31 | Alameda 17 | 4.982 | Jordan Ranch Park | 2018 | Local Park 2 | 4 |
7173 | 7173 | 7172 | {"type": "Polygon", "coordinates": [[[-121.68319, 37.99308], [-121.68317, 37.99514], [-121.6831, 37.99517], [-121.68169, 37.99516], [-121.68154, 37.99513], [-121.68139, 37.99508], [-121.68127, 37.99501], [-121.68116, 37.99491], [-121.68105, 37.99475], [-121.68102, 37.99462], [-121.68104, 37.99363], [-121.68108, 37.99345], [-121.68114, 37.99333], [-121.68123, 37.99324], [-121.68141, 37.99312], [-121.68156, 37.99307], [-121.68171, 37.99305], [-121.68312, 37.99305], [-121.68319, 37.99308]]]} | Open Access 1 | 48432 | Emerson Ranch Park | 33133 | 1229 | Oakley, City of 255 | City 2 | City Agency 2 | http://www.ci.oakley.ca.us/subpage.cfm?id=441408 | City 2 | 1229 | Oakley, City of 251 | City 2 | City Agency 2 | https://www.ci.oakley.ca.us/parks-and-landscape/park-and-landscape-capital-projects/ | Contra Costa 12 | 10.497 | Emerson Ranch Park | 2018 | Local Park 2 | 4 |
7300 | 7300 | 7299 | {"type": "Polygon", "coordinates": [[[-118.19815, 33.85938], [-118.19488, 33.86461], [-118.19471, 33.86483], [-118.19365, 33.86651], [-118.19195, 33.86924], [-118.1908, 33.86927], [-118.19254, 33.86619], [-118.19511, 33.86194], [-118.19574, 33.86094], [-118.19576, 33.86083], [-118.19594, 33.86053], [-118.1961, 33.86064], [-118.19622, 33.86063], [-118.19765, 33.85861], [-118.19767, 33.85857], [-118.19766, 33.85851], [-118.19785, 33.85833], [-118.19815, 33.85938]]]} | Open Access 1 | 6600 | DeForest Park | 18015 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 34.12 | DeForest Park | 2018 | Local Park 2 | 4 | |
7402 | 7402 | 7401 | {"type": "Polygon", "coordinates": [[[-120.86774, 37.60385], [-120.86552, 37.60384], [-120.86554, 37.60217], [-120.8656, 37.60212], [-120.8669, 37.60212], [-120.86691, 37.60254], [-120.86681, 37.60254], [-120.86682, 37.60268], [-120.867, 37.60268], [-120.86701, 37.60262], [-120.86773, 37.60261], [-120.86774, 37.60385]]]} | Open Access 1 | 48438 | Lebright Fields | 33140 | 1140 | Hughson, City of 863 | City 2 | City Agency 2 | http://hughson.org/government/city-departments/parks-and-recreations/ | City 2 | 1140 | Hughson, City of 841 | City 2 | City Agency 2 | Stanislaus 2 | 8.156 | Lebright Fields | 2018 | Local Recreation Area 3 | 4 | |
7555 | 7555 | 7554 | {"type": "Polygon", "coordinates": [[[-117.02716, 32.57161], [-117.02625, 32.5719], [-117.02589, 32.5711], [-117.02577, 32.57094], [-117.02564, 32.57082], [-117.02547, 32.57071], [-117.02522, 32.5706], [-117.02501, 32.57054], [-117.02477, 32.57052], [-117.02459, 32.57053], [-117.02427, 32.5706], [-117.02399, 32.57074], [-117.02375, 32.57093], [-117.02269, 32.57021], [-117.02263, 32.56916], [-117.02312, 32.56929], [-117.0232, 32.5694], [-117.02325, 32.56944], [-117.02381, 32.56969], [-117.02395, 32.56992], [-117.02418, 32.56988], [-117.02471, 32.56986], [-117.02489, 32.56983], [-117.02503, 32.56978], [-117.02526, 32.56966], [-117.0254, 32.56956], [-117.02554, 32.56942], [-117.02626, 32.56929], [-117.02631, 32.56932], [-117.02656, 32.56937], [-117.02697, 32.56951], [-117.02698, 32.57062], [-117.02715, 32.57064], [-117.02716, 32.57161]]]} | Open Access 1 | 47618 | Cesar Solis Park | 31542 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 15.465 | Cesar Solis Park | 2018 | Local Park 2 | 4 | |
8386 | 8386 | 8385 | {"type": "Polygon", "coordinates": [[[-122.41835, 37.78009], [-122.41831, 37.78014], [-122.41724, 37.78028], [-122.41712, 37.78022], [-122.41685, 37.77889], [-122.41694, 37.77881], [-122.41802, 37.77868], [-122.41807, 37.77871], [-122.41835, 37.78009]]]} | Open Access 1 | 12974 | Helen Diller Civic Center Playgrounds | 31697 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 4.432 | Helen Diller Civic Ctr. Playgrounds | 2018 | None 703 | ||
9417 | 9417 | 9416 | {"type": "Polygon", "coordinates": [[[-118.18057, 33.81348], [-118.18057, 33.81362], [-118.18053, 33.8138], [-118.18, 33.81378], [-118.17999, 33.81348], [-118.18057, 33.81348]]]} | Open Access 1 | 47825 | Signal Hill Dog Park | 31767 | 1334 | Signal Hill, City of 371 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/Facilities/Facility/Details/Signal-Hill-Dog-Park-27 | Los Angeles 6 | 0.441 | Signal Hill Dog Park | 2018 | Local Park 2 | 4 |
9625 | 9625 | 9624 | {"type": "MultiPolygon", "coordinates": [[[[-122.7194, 38.39457], [-122.71939, 38.39494], [-122.71929, 38.39502], [-122.7191, 38.39504], [-122.71903, 38.39508], [-122.719, 38.39512], [-122.71863, 38.39513], [-122.71863, 38.39457], [-122.71871, 38.3945], [-122.71931, 38.3945], [-122.7194, 38.39457]]], [[[-122.72084, 38.39557], [-122.72046, 38.39557], [-122.72045, 38.39548], [-122.7203, 38.39548], [-122.72019, 38.39556], [-122.71965, 38.39556], [-122.71958, 38.39553], [-122.71956, 38.39549], [-122.71957, 38.39456], [-122.71966, 38.39449], [-122.72027, 38.39449], [-122.72028, 38.39452], [-122.72083, 38.39452], [-122.72084, 38.39557]]]]} | Open Access 1 | 47845 | Andy's Unity Park | 31788 | 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 | https://parks.sonomacounty.ca.gov/Visit/Andys-Unity-Park/ | Sonoma 16 | 4.213 | Andy's Unity Park | 2018 | Local Park 2 | 4 |
9634 | 9634 | 9633 | {"type": "Polygon", "coordinates": [[[-117.85212, 33.98947], [-117.85196, 33.98955], [-117.85182, 33.9896], [-117.85171, 33.98973], [-117.8516, 33.9899], [-117.85166, 33.99], [-117.85177, 33.99025], [-117.85212, 33.99036], [-117.85201, 33.99068], [-117.85197, 33.99071], [-117.85185, 33.99073], [-117.8518, 33.99078], [-117.85179, 33.99085], [-117.85186, 33.99093], [-117.85186, 33.99097], [-117.85184, 33.99102], [-117.8518, 33.99105], [-117.85106, 33.99068], [-117.85088, 33.99061], [-117.8507, 33.99056], [-117.85041, 33.99053], [-117.8496, 33.99057], [-117.84933, 33.99061], [-117.84932, 33.99034], [-117.84955, 33.99025], [-117.8496, 33.99], [-117.84997, 33.98961], [-117.85022, 33.98963], [-117.85052, 33.98959], [-117.85071, 33.9896], [-117.85108, 33.98948], [-117.85119, 33.98952], [-117.85127, 33.98953], [-117.85144, 33.98945], [-117.85182, 33.98949], [-117.85208, 33.98939], [-117.85212, 33.98947]]]} | Open Access 1 | 47852 | Larkstone Park | 31798 | 1085 | Diamond Bar, City of 315 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | https://www.diamondbarca.gov/Facilities/Facility/Details/Larkstone-Park-38 | Los Angeles 6 | 6.431 | Larkstone Park | 2018 | Local Park 2 | 4 |
10267 | 10267 | 10266 | {"type": "MultiPolygon", "coordinates": [[[[-118.27963, 34.43891], [-118.27942, 34.44], [-118.27919, 34.43986], [-118.27895, 34.43975], [-118.27854, 34.4396], [-118.27563, 34.4389], [-118.27527, 34.43884], [-118.27503, 34.43882], [-118.27478, 34.43883], [-118.27453, 34.43886], [-118.27415, 34.43895], [-118.2739, 34.43904], [-118.27307, 34.43944], [-118.27278, 34.43957], [-118.27249, 34.43966], [-118.27218, 34.43973], [-118.27214, 34.43775], [-118.27694, 34.43776], [-118.27882, 34.43867], [-118.2793, 34.43883], [-118.27963, 34.43891]]], [[[-118.27986, 34.44135], [-118.27222, 34.44131], [-118.2722, 34.44029], [-118.2726, 34.44021], [-118.27309, 34.44005], [-118.2734, 34.43992], [-118.27412, 34.43956], [-118.27445, 34.43944], [-118.2748, 34.43938], [-118.27503, 34.43937], [-118.27527, 34.43939], [-118.27822, 34.44009], [-118.27858, 34.4402], [-118.27891, 34.44037], [-118.27921, 34.44059], [-118.27947, 34.44086], [-118.27986, 34.44135]]]]} | Open Access 1 | 48531 | Bird's Nest | 33245 | 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 | 51.384 | Bird's Nest | 2018 | None 894 |
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]);