units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where COUNTY = 6 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4492 | 4492 | 4491 | {"type": "Polygon", "coordinates": [[[-118.35128, 33.78024], [-118.35122, 33.78036], [-118.35108, 33.78051], [-118.35086, 33.78065], [-118.35069, 33.7807], [-118.35057, 33.78035], [-118.35093, 33.78032], [-118.35092, 33.78], [-118.35108, 33.78], [-118.35119, 33.78003], [-118.35127, 33.78011], [-118.35128, 33.78024]]]} | Open Access 1 | 5914 | Unnamed site - Westfield Recreation and Park District | 28676 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.653 | 0 | Local Other or Unknown 14 | 4 | |||
4493 | 4493 | 4492 | {"type": "Polygon", "coordinates": [[[-118.36086, 33.76832], [-118.3608, 33.76862], [-118.36056, 33.76861], [-118.36041, 33.76865], [-118.36031, 33.76842], [-118.36043, 33.76817], [-118.36086, 33.76832]]]} | Open Access 1 | 5915 | Unknown park - Westfield Recreation and Park District | 28677 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.462 | 0 | Local Other or Unknown 14 | 4 | |||
9412 | 9412 | 9411 | {"type": "MultiPolygon", "coordinates": [[[[-118.325, 33.74497], [-118.32496, 33.74508], [-118.32486, 33.74519], [-118.32456, 33.74533], [-118.32442, 33.74537], [-118.32395, 33.74544], [-118.32322, 33.74543], [-118.3231, 33.74545], [-118.32306, 33.74525], [-118.32227, 33.74479], [-118.32072, 33.74441], [-118.32074, 33.74435], [-118.32074, 33.74405], [-118.32121, 33.74405], [-118.32221, 33.74426], [-118.32253, 33.74419], [-118.32309, 33.74458], [-118.32347, 33.74443], [-118.32349, 33.74426], [-118.32378, 33.74428], [-118.32388, 33.74432], [-118.32395, 33.74437], [-118.32399, 33.74443], [-118.32399, 33.74446], [-118.32372, 33.74453], [-118.32355, 33.7448], [-118.32364, 33.745], [-118.32437, 33.7452], [-118.3247, 33.74515], [-118.3249, 33.74496], [-118.32482, 33.74477], [-118.32486, 33.74475], [-118.32491, 33.74475], [-118.32498, 33.74479], [-118.325, 33.74486], [-118.325, 33.74497]]], [[[-118.32439, 33.74432], [-118.32422, 33.74439], [-118.3242, 33.7443], [-118.32416, 33.74425], [-118.32407, 33.74417], [-118.32392, 33.74413], [-118.32376, 33.74413], [-118.3239, 33.74396], [-118.32439, 33.74432]]]]} | Open Access 1 | 47834 | Frascati Trail | 31776 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 5.92 | Frascati Trail | 0 | Local Recreation Area 3 | 4 | |
9506 | 9506 | 9505 | {"type": "Polygon", "coordinates": [[[-118.32587, 33.74382], [-118.32587, 33.74461], [-118.32566, 33.74466], [-118.32561, 33.74453], [-118.3255, 33.74455], [-118.32553, 33.74468], [-118.32546, 33.7447], [-118.32526, 33.74439], [-118.3258, 33.74434], [-118.32581, 33.74381], [-118.32587, 33.74382]]]} | Open Access 1 | 47829 | Frog Pond Park | 31771 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.434 | Frog Pond Park | 0 | Local Park 2 | 4 | |
9521 | 9521 | 9520 | {"type": "Polygon", "coordinates": [[[-118.32587, 33.74145], [-118.32586, 33.74173], [-118.32563, 33.74185], [-118.32541, 33.7416], [-118.32474, 33.74161], [-118.32422, 33.74153], [-118.32393, 33.74164], [-118.32391, 33.74158], [-118.32401, 33.74154], [-118.32401, 33.74153], [-118.32329, 33.74095], [-118.32212, 33.74084], [-118.3217, 33.74095], [-118.32093, 33.74221], [-118.32075, 33.74221], [-118.32176, 33.74053], [-118.32318, 33.74066], [-118.32402, 33.74133], [-118.32477, 33.74147], [-118.32587, 33.74145]]]} | Open Access 1 | 47832 | Colinita Trail | 31775 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 3.136 | Colinita Trail | 0 | Local Recreation Area 3 | 4 | |
9528 | 9528 | 9527 | {"type": "Polygon", "coordinates": [[[-118.32092, 33.74221], [-118.32011, 33.74357], [-118.32016, 33.74372], [-118.32001, 33.74376], [-118.31987, 33.74401], [-118.31997, 33.74414], [-118.32048, 33.74413], [-118.32055, 33.74404], [-118.32057, 33.74405], [-118.32058, 33.74434], [-118.32056, 33.7444], [-118.32044, 33.74452], [-118.32027, 33.74456], [-118.32011, 33.74436], [-118.31968, 33.74442], [-118.3195, 33.74476], [-118.31965, 33.74515], [-118.31998, 33.74517], [-118.32002, 33.74548], [-118.31996, 33.74555], [-118.31991, 33.74557], [-118.31983, 33.74557], [-118.31939, 33.74542], [-118.31919, 33.74477], [-118.3197, 33.74396], [-118.32074, 33.74221], [-118.32092, 33.74221]]]} | Open Access 1 | 47833 | Harter Park | 31774 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 2.945 | Harter Park | 0 | Local Park 2 | 4 | |
9534 | 9534 | 9533 | {"type": "MultiPolygon", "coordinates": [[[[-118.32508, 33.74836], [-118.32478, 33.74839], [-118.32442, 33.74859], [-118.3242, 33.74879], [-118.32384, 33.74839], [-118.32179, 33.74742], [-118.32161, 33.74723], [-118.32105, 33.74759], [-118.32094, 33.74748], [-118.3215, 33.74711], [-118.32094, 33.7465], [-118.32031, 33.74623], [-118.3199, 33.74579], [-118.31989, 33.7457], [-118.32, 33.74568], [-118.3201, 33.74562], [-118.32024, 33.74572], [-118.32031, 33.74572], [-118.32037, 33.74575], [-118.32054, 33.74589], [-118.32066, 33.74602], [-118.32075, 33.74605], [-118.32085, 33.74605], [-118.32097, 33.74599], [-118.32102, 33.7459], [-118.32101, 33.74581], [-118.32091, 33.74564], [-118.32093, 33.74564], [-118.32142, 33.74604], [-118.32229, 33.74651], [-118.32269, 33.74631], [-118.32274, 33.74637], [-118.32235, 33.74655], [-118.32235, 33.74656], [-118.32345, 33.74762], [-118.32367, 33.74772], [-118.32395, 33.74742], [-118.32419, 33.74758], [-118.32394, 33.74788], [-118.32439, 33.74816], [-118.32474, 33.74814], [-118.32486, 33.74801], [-118.32498, 33.74812], [-118.32504, 33.74824], [-118.32508, 33.74836]]], [[[-118.32085, 33.74589], [-118.32081, 33.74592], [-118.32078, 33.74592], [-118.32066, 33.74579], [-118.32054, 33.74569], [-118.32074, 33.74566], [-118.32085, 33.74585], [-118.32085, 33.74589]]]]} | Open Access 1 | 47835 | Sienna Loop Trail | 31777 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 9.915 | Sienna Loop Trail | 0 | Local Recreation Area 3 | 4 | |
9539 | 9539 | 9538 | {"type": "MultiPolygon", "coordinates": [[[[-118.31957, 33.74707], [-118.31942, 33.74709], [-118.31936, 33.7467], [-118.3191, 33.74575], [-118.31911, 33.7457], [-118.31924, 33.74568], [-118.31926, 33.7457], [-118.31947, 33.74646], [-118.31954, 33.74679], [-118.31957, 33.74707]]], [[[-118.31996, 33.74921], [-118.31982, 33.74928], [-118.31971, 33.74913], [-118.31966, 33.74901], [-118.31962, 33.74886], [-118.31962, 33.74877], [-118.31968, 33.74836], [-118.31968, 33.74813], [-118.31963, 33.74788], [-118.31952, 33.74756], [-118.31942, 33.74714], [-118.31959, 33.74712], [-118.31963, 33.74737], [-118.31978, 33.74782], [-118.31983, 33.74803], [-118.31984, 33.74831], [-118.3198, 33.74887], [-118.31988, 33.74908], [-118.31996, 33.74921]]], [[[-118.32135, 33.75015], [-118.3213, 33.75029], [-118.32109, 33.75022], [-118.32063, 33.75], [-118.32023, 33.74971], [-118.32002, 33.74952], [-118.31987, 33.74934], [-118.32002, 33.74926], [-118.32025, 33.74952], [-118.32053, 33.74975], [-118.32098, 33.75001], [-118.32135, 33.75015]]], [[[-118.32351, 33.7498], [-118.32345, 33.74985], [-118.32325, 33.74997], [-118.32303, 33.75005], [-118.32211, 33.7503], [-118.32178, 33.75034], [-118.32159, 33.75034], [-118.32137, 33.7503], [-118.32143, 33.75017], [-118.32165, 33.7502], [-118.32191, 33.75019], [-118.32351, 33.7498]]], [[[-118.32508, 33.74962], [-118.32433, 33.74974], [-118.32383, 33.74986], [-118.32381, 33.7498], [-118.32406, 33.74967], [-118.32419, 33.74964], [-118.32504, 33.74949], [-118.32508, 33.74962]]]]} | Open Access 1 | 47836 | Miraleste Median | 31778 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 3.263 | Miraleste Median | None 791 | |||
9541 | 9541 | 9540 | {"type": "Polygon", "coordinates": [[[-118.32587, 33.74953], [-118.32572, 33.74942], [-118.32569, 33.74937], [-118.32556, 33.74827], [-118.32549, 33.74805], [-118.32543, 33.74795], [-118.32579, 33.74783], [-118.32587, 33.74783], [-118.32587, 33.74785], [-118.32587, 33.74953]]]} | Open Access 1 | 47837 | Miltenberger Park | 31779 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 1.104 | Miltenberger Park | 0 | Local Park 2 | 4 | |
9547 | 9547 | 9546 | {"type": "Polygon", "coordinates": [[[-118.319, 33.74614], [-118.31877, 33.74618], [-118.31864, 33.74623], [-118.31846, 33.74607], [-118.31846, 33.74603], [-118.31855, 33.74586], [-118.3188, 33.74581], [-118.31892, 33.74587], [-118.319, 33.74614]]]} | Open Access 1 | 47838 | Miraleste Park | 31780 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.395 | Miraleste Park | 0 | Local Park 2 | 4 | |
9548 | 9548 | 9547 | {"type": "Polygon", "coordinates": [[[-118.31871, 33.75148], [-118.3186, 33.75159], [-118.3186, 33.7517], [-118.31842, 33.75196], [-118.31843, 33.74806], [-118.31846, 33.74607], [-118.31864, 33.74623], [-118.31866, 33.74651], [-118.31866, 33.7466], [-118.31862, 33.74662], [-118.31859, 33.75138], [-118.31871, 33.75148]]]} | Open Access 1 | 47839 | Lorraine Trail | 31782 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 2.557 | Lorraine Trail | 0 | Local Recreation Area 3 | 4 | |
9549 | 9549 | 9548 | {"type": "Polygon", "coordinates": [[[-118.32588, 33.7512], [-118.32569, 33.75113], [-118.32582, 33.75079], [-118.32552, 33.75069], [-118.32515, 33.75073], [-118.32511, 33.75097], [-118.32475, 33.75096], [-118.32453, 33.75099], [-118.32427, 33.75107], [-118.32405, 33.75118], [-118.32387, 33.75099], [-118.32318, 33.75133], [-118.32271, 33.75141], [-118.32252, 33.7515], [-118.32265, 33.75175], [-118.32264, 33.75176], [-118.32258, 33.75178], [-118.32244, 33.75154], [-118.32133, 33.75207], [-118.32135, 33.75226], [-118.32116, 33.75229], [-118.32107, 33.75233], [-118.32097, 33.75239], [-118.3208, 33.75223], [-118.32044, 33.75241], [-118.31947, 33.75237], [-118.31861, 33.75275], [-118.31877, 33.753], [-118.31873, 33.75321], [-118.31842, 33.75321], [-118.31842, 33.75196], [-118.3186, 33.7517], [-118.31861, 33.75181], [-118.3187, 33.7517], [-118.31875, 33.75173], [-118.31876, 33.75212], [-118.31926, 33.75203], [-118.32016, 33.75204], [-118.32047, 33.75195], [-118.32125, 33.7514], [-118.32161, 33.75107], [-118.32246, 33.75079], [-118.32385, 33.75045], [-118.32372, 33.75006], [-118.32393, 33.75001], [-118.32411, 33.75038], [-118.32457, 33.75026], [-118.32529, 33.75014], [-118.32553, 33.74992], [-118.32587, 33.75017], [-118.32588, 33.7512]]]} | Open Access 1 | 47840 | Canada Park | 31781 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 13.159 | Canada Park | 0 | Local Park 2 | 4 | |
15667 | 15667 | 15666 | {"type": "MultiPolygon", "coordinates": [[[[-117.78087, 34.13432], [-117.77956, 34.13623], [-117.77952, 34.13623], [-117.77668, 34.13961], [-117.77672, 34.13656], [-117.77842, 34.13656], [-117.77907, 34.13625], [-117.77907, 34.13623], [-117.77757, 34.13623], [-117.77816, 34.13544], [-117.78087, 34.13432]]], [[[-117.78553, 34.13746], [-117.7855, 34.13899], [-117.78448, 34.1382], [-117.78414, 34.13855], [-117.78324, 34.13797], [-117.78188, 34.13857], [-117.77931, 34.14076], [-117.77831, 34.14213], [-117.7783, 34.14331], [-117.77675, 34.14332], [-117.77677, 34.13975], [-117.77972, 34.13625], [-117.77971, 34.13623], [-117.78, 34.1358], [-117.78077, 34.1347], [-117.78082, 34.13473], [-117.78093, 34.13461], [-117.7812, 34.13438], [-117.78164, 34.13411], [-117.78274, 34.13355], [-117.78304, 34.13334], [-117.78316, 34.13323], [-117.78323, 34.1332], [-117.78327, 34.1332], [-117.78333, 34.13323], [-117.7842, 34.13378], [-117.78317, 34.13427], [-117.78294, 34.13488], [-117.78326, 34.13531], [-117.78441, 34.13592], [-117.78436, 34.13609], [-117.78435, 34.13626], [-117.78438, 34.13643], [-117.78449, 34.13664], [-117.78468, 34.13683], [-117.78553, 34.13746]], [[-117.78214, 34.13578], [-117.78214, 34.13579], [-117.78231, 34.13592], [-117.78253, 34.13571], [-117.78235, 34.13558], [-117.78214, 34.13578]]]]} | Restricted Access 2 | 6754 | San Dimas Canyon Golf Course | 33021 | 2135 | San Dimas-La Verne Recreational Facilities Authority 1160 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2135 | San Dimas-La Verne Recreational Facilities Authority 1104 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 103.27 | San Dimas Canyon GC | 0 | Local Recreation Area 3 | 4 | ||
15845 | 15845 | 15844 | {"type": "MultiPolygon", "coordinates": [[[[-118.37159, 33.76721], [-118.37139, 33.76744], [-118.37081, 33.76795], [-118.37054, 33.76809], [-118.37028, 33.76819], [-118.36988, 33.76826], [-118.36957, 33.76825], [-118.36931, 33.76821], [-118.36905, 33.76812], [-118.36801, 33.7677], [-118.3677, 33.76761], [-118.36738, 33.76756], [-118.36695, 33.76756], [-118.36722, 33.76751], [-118.36745, 33.76751], [-118.36778, 33.76756], [-118.36792, 33.7676], [-118.3693, 33.76817], [-118.36961, 33.76824], [-118.36984, 33.76825], [-118.37, 33.76823], [-118.37022, 33.76817], [-118.37042, 33.76808], [-118.37055, 33.76799], [-118.37068, 33.76788], [-118.37139, 33.76708], [-118.37138, 33.76701], [-118.37159, 33.76714], [-118.37159, 33.76721]]], [[[-118.3718, 33.76638], [-118.3718, 33.76662], [-118.37176, 33.76685], [-118.3717, 33.7669], [-118.37163, 33.76689], [-118.37158, 33.76686], [-118.37168, 33.7667], [-118.37175, 33.76655], [-118.37178, 33.76638], [-118.37178, 33.76628], [-118.3718, 33.76638]]]]} | Open Access 1 | 5926 | Ridgecrest Ranchos Open Space | 24353 | 2120 | Ridgecrest Ranchos Recreation and Park District 1162 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2120 | Ridgecrest Ranchos Recreation and Park District 1105 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 1.195 | Ridgecrest Ranchos OS | 0 | Local Recreation Area 3 | 4 | ||
16074 | 16074 | 16073 | {"type": "MultiPolygon", "coordinates": [[[[-118.7612, 34.15938], [-118.76095, 34.15967], [-118.76079, 34.15964], [-118.76019, 34.15956], [-118.76026, 34.15926], [-118.7602, 34.15894], [-118.75993, 34.15859], [-118.75947, 34.15828], [-118.7594, 34.1581], [-118.75933, 34.15771], [-118.75928, 34.15754], [-118.75913, 34.15724], [-118.7587, 34.1572], [-118.75815, 34.1572], [-118.75822, 34.15701], [-118.75818, 34.15698], [-118.75808, 34.15683], [-118.75806, 34.15666], [-118.75818, 34.15629], [-118.75888, 34.1563], [-118.75976, 34.15687], [-118.76107, 34.15873], [-118.7612, 34.15938]]], [[[-118.76954, 34.16551], [-118.76926, 34.16565], [-118.76899, 34.16554], [-118.76889, 34.16553], [-118.76868, 34.16556], [-118.76863, 34.16555], [-118.76848, 34.16557], [-118.76841, 34.16556], [-118.76817, 34.16586], [-118.76799, 34.16599], [-118.76781, 34.166], [-118.76685, 34.16618], [-118.76644, 34.16634], [-118.76606, 34.16631], [-118.76585, 34.1662], [-118.76521, 34.16592], [-118.76502, 34.16579], [-118.76443, 34.1657], [-118.76439, 34.16573], [-118.76408, 34.16558], [-118.76362, 34.16544], [-118.76321, 34.16525], [-118.76316, 34.16528], [-118.76309, 34.16546], [-118.76269, 34.16613], [-118.76236, 34.1664], [-118.76182, 34.16606], [-118.76212, 34.1658], [-118.76224, 34.16563], [-118.76245, 34.16527], [-118.76213, 34.16503], [-118.7621, 34.16502], [-118.7621, 34.16483], [-118.76209, 34.16468], [-118.76203, 34.16451], [-118.76189, 34.16429], [-118.7618, 34.16419], [-118.7613, 34.16381], [-118.76117, 34.16368], [-118.76108, 34.16358], [-118.76096, 34.16339], [-118.76085, 34.16318], [-118.7608, 34.16301], [-118.76076, 34.16283], [-118.76075, 34.16253], [-118.76082, 34.16216], [-118.76084, 34.16194], [-118.76082, 34.1617], [-118.76075, 34.16127], [-118.76061, 34.16085], [-118.76039, 34.16045], [-118.76026, 34.16029], [-118.7602, 34.16015], [-118.76017, 34.16006], [-118.76017, 34.15992], [-118.76019, 34.15978], [-118.76026, 34.15975], [-118.76079, 34.15982], [-118.76089, 34.15984], [-118.76091, 34.16037], [-118.76164, 34.16078], [-118.76173, 34.16089], [-118.76171, 34.16096], [-118.76177, 34.16102], [-118.76175, 34.16138], [-118.76183, 34.16158], [-118.7618, 34.16167], [-118.76162, 34.16197], [-118.76155, 34.16235], [-118.762, 34.16281], [-118.76257, 34.16261], [-118.76264, 34.16269], [-118.7627, 34.16271], [-118.7627, 34.16275], [-118.76321, 34.16279], [-118.76362, 34.16247], [-118.76366, 34.16279], [-118.76312, 34.16302], [-118.76311, 34.1631], [-118.76282, 34.16307], [-118.76254, 34.16309], [-118.76234, 34.16317], [-118.76219, 34.16331], [-118.76217, 34.16347], [-118.76232, 34.16356], [-118.76289, 34.1642], [-118.76304, 34.16427], [-118.76319, 34.16427], [-118.76332, 34.16425], [-118.76346, 34.16436], [-118.76389, 34.16474], [-118.76401, 34.16478], [-118.76428, 34.16508], [-118.76446, 34.16516], [-118.76463, 34.1652], [-118.76483, 34.1652], [-118.76513, 34.16517], [-118.76531, 34.16522], [-118.76542, 34.1653], [-118.7657, 34.16522], [-118.76613, 34.16548], [-118.76666, 34.16553], [-118.76692, 34.16544], [-118.76727, 34.16553], [-118.76754, 34.16553], [-118.76782, 34.16535], [-118.76801, 34.1651], [-118.76808, 34.16483], [-118.76809, 34.16455], [-118.76838, 34.16452], [-118.7687, 34.16432], [-118.7687, 34.16437], [-118.7688, 34.1644], [-118.76873, 34.16468], [-118.76869, 34.16477], [-118.76876, 34.16491], [-118.76893, 34.16506], [-118.7692, 34.16504], [-118.76954, 34.16551]]], [[[-118.76255, 34.1681], [-118.76176, 34.16809], [-118.76187, 34.16771], [-118.76174, 34.16744], [-118.7613, 34.16689], [-118.76124, 34.16679], [-118.76124, 34.16673], [-118.76128, 34.16655], [-118.76166, 34.16619], [-118.76187, 34.1663], [-118.76221, 34.16652], [-118.76196, 34.16673], [-118.76251, 34.16755], [-118.76248, 34.16781], [-118.76255, 34.1681]]]]} | Open Access 1 | 7085 | Medea Creek Open Space | 32643 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 42.16 | Medea Creek OS | 0 | Local Recreation Area 3 | 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]);