units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where DES_TP = 3, GAP_STS = 4 and MNG_AGENCY = 284
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Los Angeles County Flood Control District · 6 ✖
DES_TP 1
- Local Recreation Area · 6 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 986 | 986 | 985 | {"type": "MultiPolygon", "coordinates": [[[[-118.07211, 33.98316], [-118.0721, 33.98317], [-118.07151, 33.98276], [-118.07152, 33.98275], [-118.07211, 33.98316]]], [[[-118.07278, 33.98341], [-118.07277, 33.98343], [-118.07221, 33.98304], [-118.07222, 33.98303], [-118.07278, 33.98341]]], [[[-118.07399, 33.98445], [-118.07398, 33.98447], [-118.07355, 33.98418], [-118.07356, 33.98416], [-118.07399, 33.98445]]]]} | Open Access 1 | 6696 | San Gabriel River & Bike Trail | 24897 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 0.082 | San Gabriel River & Bike Trail | 0 | Local Recreation Area 3 | 4 | |
| 1274 | 1274 | 1273 | {"type": "Polygon", "coordinates": [[[-118.23627, 33.89605], [-118.23616, 33.89604], [-118.23608, 33.89598], [-118.2362, 33.89598], [-118.23627, 33.89605]]]} | Open Access 1 | 7201 | Compton Creek & Bike Path | 17572 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 0.02 | Compton Creek & Bike Path | 0 | Local Recreation Area 3 | 4 | |
| 1383 | 1383 | 1382 | {"type": "MultiPolygon", "coordinates": [[[[-118.11369, 33.74771], [-118.11255, 33.74876], [-118.11157, 33.74945], [-118.11111, 33.74973], [-118.11072, 33.75002], [-118.10969, 33.75059], [-118.10907, 33.75104], [-118.10859, 33.75128], [-118.10795, 33.75156], [-118.10746, 33.75184], [-118.10626, 33.75271], [-118.10615, 33.7526], [-118.10645, 33.75239], [-118.10679, 33.7521], [-118.10724, 33.75181], [-118.10794, 33.75137], [-118.10847, 33.7511], [-118.10942, 33.75052], [-118.11024, 33.75006], [-118.11049, 33.74986], [-118.11078, 33.74967], [-118.11147, 33.74927], [-118.11266, 33.74838], [-118.11291, 33.74808], [-118.11342, 33.74755], [-118.11353, 33.74764], [-118.11369, 33.74771]]], [[[-118.11145, 33.91335], [-118.11145, 33.91375], [-118.11156, 33.91471], [-118.1116, 33.91546], [-118.11167, 33.91642], [-118.11171, 33.91749], [-118.1118, 33.91832], [-118.11186, 33.91924], [-118.11187, 33.92019], [-118.11192, 33.92073], [-118.11189, 33.92139], [-118.11181, 33.92169], [-118.11149, 33.92319], [-118.11111, 33.92383], [-118.11077, 33.92461], [-118.11028, 33.92567], [-118.10967, 33.92685], [-118.10915, 33.928], [-118.10913, 33.928], [-118.1088, 33.92855], [-118.10837, 33.92938], [-118.10822, 33.92971], [-118.10783, 33.93064], [-118.10766, 33.93119], [-118.10745, 33.93166], [-118.10705, 33.93227], [-118.10669, 33.93288], [-118.10635, 33.9333], [-118.10614, 33.9336], [-118.10521, 33.93457], [-118.10477, 33.93515], [-118.10426, 33.93566], [-118.10372, 33.93624], [-118.10267, 33.9375], [-118.10222, 33.93811], [-118.1019, 33.93842], [-118.10146, 33.93901], [-118.10117, 33.93944], [-118.10115, 33.93944], [-118.10089, 33.93981], [-118.10051, 33.94047], [-118.10037, 33.94076], [-118.10031, 33.94104], [-118.10013, 33.94157], [-118.10007, 33.942], [-118.09992, 33.94246], [-118.09979, 33.94295], [-118.09969, 33.94343], [-118.0995, 33.94406], [-118.09941, 33.94443], [-118.09927, 33.9452], [-118.09912, 33.94539], [-118.09913, 33.94542], [-118.09891, 33.94581], [-118.09846, 33.94641], [-118.09783, 33.94708], [-118.09726, 33.94777], [-118.09665, 33.94841], [-118.09618, 33.94895], [-118.09485, 33.95055], [-118.09431, 33.95115], [-118.09373, 33.95176], [-118.09286, 33.95272], [-118.0923, 33.95331], [-118.09176, 33.95393], [-118.09132, 33.9545], [-118.09065, 33.95523], [-118.09021, 33.9559], [-118.08916, 33.95768], [-118.08874, 33.95854], [-118.08812, 33.9597], [-118.08791, 33.96041], [-118.08788, 33.96063], [-118.08793, 33.96163], [-118.08806, 33.96206], [-118.08832, 33.96268], [-118.08858, 33.96321], [-118.08887, 33.96363], [-118.08911, 33.96406], [-118.08941, 33.96464], [-118.08975, 33.9656], [-118.08987, 33.96622], [-118.08997, 33.96658], [-118.08997, 33.967], [-118.08988, 33.96752], [-118.08982, 33.96801], [-118.0896, 33.96863], [-118.08948, 33.9691], [-118.08918, 33.96955], [-118.08829, 33.97064], [-118.0876, 33.97136], [-118.08698, 33.97208], [-118.08584, 33.97349], [-118.08494, 33.9745], [-118.08391, 33.97578], [-118.08352, 33.97618], [-118.08311, 33.97664], [-118.08179, 33.97851], [-118.08046, 33.98048], [-118.0798, 33.98132], [-118.07925, 33.98212], [-118.07851, 33.98314], [-118.07771, 33.98444], [-118.07714, 33.98566], [-118.07692, 33.98619], [-118.07652, 33.98729], [-118.07632, 33.98773], [-118.07609, 33.98832], [-118.07552, 33.98955], [-118.07471, 33.99158], [-118.07426, 33.99266], [-118.07409, 33.99312], [-118.0733, 33.99488], [-118.07307, 33.99554], [-118.07271, 33.99623], [-118.07261, 33.9966], [-118.07235, 33.99713], [-118.07209, 33.99773], [-118.07154, 33.99906], [-118.07147, 33.99927], [-118.07122, 34.00026], [-118.07102, 34.00093], [-118.07088, 34.00162], [-118.07067, 34.00216], [-118.07066, 34.00243], [-118.07047, 34.003], [-118.07038, 34.00362], [-118.07038, 34.00391], [-118.07021, 34.00418], [-118.07016, 34.00445], [-118.06972, 34.00539], [-118.0696, 34.00584], [-118.06946, 34.00622], [-118.06931, 34.00676], [-118.06895, 34.00746], [-118.06867, 34.0079], [-118.06836, 34.00844], [-118.06781, 34.00925], [-118.06706, 34.01014], [-118.0663, 34.01092], [-118.06576, 34.01153], [-118.06514, 34.0121], [-118.06397, 34.01328], [-118.0635, 34.01365], [-118.06319, 34.01393], [-118.0627, 34.01428], [-118.06241, 34.01459], [-118.06179, 34.01516], [-118.06153, 34.01547], [-118.06135, 34.01595], [-118.0611, 34.01647], [-118.06093, 34.01676], [-118.0608, 34.01691], [-118.06067, 34.0168], [-118.0608, 34.01667], [-118.06099, 34.01641], [-118.06113, 34.01606], [-118.06131, 34.01568], [-118.06141, 34.01533], [-118.06165, 34.01503], [-118.06209, 34.01468], [-118.0627, 34.01406], [-118.06301, 34.01386], [-118.06323, 34.01367], [-118.0636, 34.01338], [-118.06526, 34.01165], [-118.06597, 34.01097], [-118.0662, 34.01081], [-118.06654, 34.01041], [-118.06704, 34.00992], [-118.06736, 34.0095], [-118.06769, 34.00911], [-118.06803, 34.00865], [-118.0683, 34.0082], [-118.06902, 34.00694], [-118.06969, 34.00525], [-118.07008, 34.0041], [-118.07019, 34.00376], [-118.07037, 34.00297], [-118.07049, 34.00258], [-118.07055, 34.00223], [-118.07075, 34.00144], [-118.07107, 34.00026], [-118.07125, 33.99976], [-118.07129, 33.99953], [-118.0716, 33.99861], [-118.07188, 33.99802], [-118.07222, 33.99716], [-118.07268, 33.99609], [-118.07298, 33.99531], [-118.07314, 33.99495], [-118.07352, 33.9942], [-118.07374, 33.99365], [-118.07389, 33.99318], [-118.07415, 33.9926], [-118.07467, 33.99119], [-118.07515, 33.99008], [-118.07543, 33.98937], [-118.07636, 33.98721], [-118.07665, 33.98652], [-118.07712, 33.98555], [-118.07738, 33.98482], [-118.07775, 33.98403], [-118.07837, 33.98307], [-118.07881, 33.98249], [-118.07901, 33.98211], [-118.08013, 33.98069], [-118.08051, 33.9801], [-118.08086, 33.97963], [-118.08178, 33.9783], [-118.08222, 33.9777], [-118.0835, 33.97588], [-118.08387, 33.97557], [-118.08439, 33.97496], [-118.08511, 33.97397], [-118.08584, 33.97323], [-118.08694, 33.97187], [-118.08721, 33.97156], [-118.08789, 33.9707], [-118.08833, 33.97033], [-118.08873, 33.96978], [-118.08924, 33.969], [-118.08947, 33.96838], [-118.08962, 33.96776], [-118.0897, 33.96718], [-118.08979, 33.96675], [-118.08963, 33.96575], [-118.08942, 33.96511], [-118.08885, 33.96387], [-118.08854, 33.96352], [-118.08806, 33.96243], [-118.08775, 33.96147], [-118.08775, 33.9605], [-118.08793, 33.95968], [-118.0881, 33.95931], [-118.08873, 33.95825], [-118.08958, 33.95666], [-118.08997, 33.95586], [-118.09069, 33.95491], [-118.09096, 33.95468], [-118.09148, 33.95393], [-118.09189, 33.95354], [-118.09264, 33.95264], [-118.09325, 33.95196], [-118.09431, 33.95085], [-118.09475, 33.95026], [-118.09504, 33.94997], [-118.09593, 33.94898], [-118.09652, 33.94827], [-118.0971, 33.94771], [-118.09741, 33.9473], [-118.0981, 33.94652], [-118.09851, 33.9459], [-118.09877, 33.94553], [-118.099, 33.94518], [-118.09901, 33.94517], [-118.09921, 33.94455], [-118.09952, 33.94326], [-118.09962, 33.94275], [-118.09982, 33.94198], [-118.10008, 33.94104], [-118.10025, 33.94062], [-118.10078, 33.93965], [-118.10101, 33.93934], [-118.10104, 33.93935], [-118.10107, 33.93912], [-118.1013, 33.93878], [-118.10179, 33.93824], [-118.10231, 33.93752], [-118.10291, 33.9369], [-118.10354, 33.93621], [-118.10462, 33.93496], [-118.10507, 33.93439], [-118.10564, 33.9338], [-118.10633, 33.93301], [-118.10685, 33.93224], [-118.10733, 33.93159], [-118.10753, 33.93111], [-118.10774, 33.9305], [-118.10865, 33.92863], [-118.10902, 33.92795], [-118.10902, 33.92793], [-118.10907, 33.92775], [-118.10922, 33.92736], [-118.10952, 33.92684], [-118.11015, 33.92552], [-118.11042, 33.92497], [-118.11058, 33.92448], [-118.11093, 33.92389], [-118.11116, 33.92327], [-118.11138, 33.92283], [-118.11158, 33.92211], [-118.11163, 33.92147], [-118.11174, 33.9208], [-118.11172, 33.92027], [-118.11165, 33.91966], [-118.11163, 33.91881], [-118.11154, 33.91766], [-118.11152, 33.91708], [-118.11151, 33.91632], [-118.11128, 33.91439], [-118.11111, 33.91334], [-118.11084, 33.91257], [-118.1106, 33.91174], [-118.11012, 33.91058], [-118.10995, 33.90989], [-118.10948, 33.90865], [-118.1091, 33.90752], [-118.10902, 33.90695], [-118.10887, 33.90639], [-118.10878, 33.90541], [-118.10875, 33.90384], [-118.10882, 33.9029], [-118.1088, 33.90236], [-118.10873, 33.90169], [-118.1087, 33.90098], [-118.10872, 33.89992], [-118.10871, 33.89818], [-118.10867, 33.89737], [-118.10866, 33.89624], [-118.10865, 33.89471], [-118.10868, 33.89372], [-118.1086, 33.89303], [-118.1086, 33.89125], [-118.10855, 33.8899], [-118.10855, 33.8891], [-118.10851, 33.88793], [-118.10853, 33.88792], [-118.10854, 33.88722], [-118.10852, 33.88668], [-118.10855, 33.88609], [-118.10852, 33.88552], [-118.10853, 33.8851], [-118.10851, 33.88463], [-118.10852, 33.88325], [-118.10849, 33.88214], [-118.10851, 33.88166], [-118.10846, 33.88005], [-118.10839, 33.87947], [-118.10823, 33.87873], [-118.10798, 33.87781], [-118.10794, 33.8775], [-118.10786, 33.87706], [-118.10778, 33.87685], [-118.10757, 33.87602], [-118.10746, 33.87551], [-118.10723, 33.87475], [-118.1069, 33.87356], [-118.10663, 33.87256], [-118.10639, 33.87174], [-118.10579, 33.8694], [-118.10474, 33.86573], [-118.10475, 33.86572], [-118.10456, 33.86493], [-118.104, 33.86272], [-118.10277, 33.8584], [-118.10251, 33.85716], [-118.10152, 33.85364], [-118.10041, 33.84941], [-118.10022, 33.84877], [-118.09958, 33.8471], [-118.09906, 33.84599], [-118.09835, 33.84487], [-118.09746, 33.8433], [-118.0968, 33.84209], [-118.09614, 33.84093], [-118.09572, 33.84012], [-118.09546, 33.83946], [-118.09512, 33.8387], [-118.09432, 33.83671], [-118.09408, 33.83598], [-118.09389, 33.83528], [-118.09373, 33.83441], [-118.09355, 33.83343], [-118.09332, 33.83196], [-118.09313, 33.83084], [-118.09279, 33.82844], [-118.09251, 33.82674], [-118.09207, 33.82368], [-118.09143, 33.81899], [-118.09134, 33.81863], [-118.0913, 33.81799], [-118.0912, 33.81723], [-118.09101, 33.81449], [-118.091, 33.81362], [-118.09097, 33.81305], [-118.0909, 33.8106], [-118.09079, 33.80959], [-118.09057, 33.80436], [-118.09054, 33.80303], [-118.09042, 33.80198], [-118.09024, 33.7987], [-118.09022, 33.79805], [-118.09015, 33.79648], [-118.09019, 33.7955], [-118.09024, 33.79518], [-118.0904, 33.79456], [-118.09065, 33.79381], [-118.09181, 33.79143], [-118.09208, 33.79098], [-118.09273, 33.78978], [-118.0941, 33.78691], [-118.09415, 33.78693], [-118.09426, 33.7866], [-118.09459, 33.78591], [-118.09488, 33.78539], [-118.09572, 33.7835], [-118.09606, 33.7828], [-118.09642, 33.78224], [-118.09699, 33.78087], [-118.09729, 33.78039], [-118.09746, 33.77997], [-118.09769, 33.77955], [-118.09797, 33.77848], [-118.09802, 33.7779], [-118.09801, 33.77769], [-118.09807, 33.77694], [-118.09805, 33.77661], [-118.09808, 33.7763], [-118.09809, 33.77611], [-118.09805, 33.77579], [-118.09807, 33.77496], [-118.09813, 33.77457], [-118.09807, 33.77406], [-118.09814, 33.77374], [-118.09815, 33.77353], [-118.09822, 33.77312], [-118.09825, 33.77207], [-118.09822, 33.77099], [-118.09826, 33.77015], [-118.09823, 33.76935], [-118.09826, 33.76888], [-118.09824, 33.76801], [-118.09828, 33.76735], [-118.09826, 33.76646], [-118.09829, 33.76368], [-118.09827, 33.76247], [-118.09829, 33.76165], [-118.09832, 33.76107], [-118.0984, 33.76069], [-118.09852, 33.76021], [-118.09862, 33.75986], [-118.09878, 33.75948], [-118.09893, 33.75948], [-118.09881, 33.7597], [-118.09863, 33.76009], [-118.09851, 33.76065], [-118.09844, 33.76129], [-118.0984, 33.76198], [-118.09833, 33.76418], [-118.09835, 33.76521], [-118.09832, 33.76597], [-118.09835, 33.76748], [-118.0983, 33.76963], [-118.09832, 33.77024], [-118.0983, 33.77106], [-118.09833, 33.77283], [-118.09831, 33.7732], [-118.09825, 33.77371], [-118.09825, 33.77395], [-118.09828, 33.77423], [-118.09827, 33.77469], [-118.09818, 33.77524], [-118.09817, 33.7769], [-118.09818, 33.7781], [-118.09814, 33.77848], [-118.09804, 33.77884], [-118.098, 33.77911], [-118.09772, 33.77984], [-118.09758, 33.7801], [-118.09731, 33.78075], [-118.09704, 33.78135], [-118.09675, 33.78186], [-118.09576, 33.78393], [-118.09508, 33.78547], [-118.09446, 33.78663], [-118.09438, 33.78714], [-118.09402, 33.78763], [-118.09356, 33.78864], [-118.09351, 33.78866], [-118.09333, 33.78902], [-118.09318, 33.78927], [-118.09281, 33.79009], [-118.09186, 33.79202], [-118.09151, 33.79271], [-118.09113, 33.79348], [-118.09092, 33.79387], [-118.09044, 33.79512], [-118.09042, 33.79527], [-118.09039, 33.79561], [-118.09035, 33.79592], [-118.09074, 33.80355], [-118.09091, 33.80678], [-118.09119, 33.81024], [-118.09109, 33.81079], [-118.09106, 33.8113], [-118.09107, 33.81199], [-118.09113, 33.81301], [-118.09116, 33.81418], [-118.09135, 33.81736], [-118.0914, 33.81782], [-118.09151, 33.81852], [-118.09159, 33.81899], [-118.09162, 33.819], [-118.09222, 33.82339], [-118.09307, 33.82926], [-118.09357, 33.83202], [-118.09366, 33.83283], [-118.09366, 33.8329], [-118.09382, 33.83404], [-118.09393, 33.83464], [-118.09412, 33.83543], [-118.09436, 33.83621], [-118.09466, 33.83699], [-118.09578, 33.83971], [-118.09626, 33.84073], [-118.09725, 33.84253], [-118.09776, 33.84349], [-118.09804, 33.84382], [-118.09946, 33.84633], [-118.09971, 33.84684], [-118.09994, 33.84738], [-118.10017, 33.84795], [-118.10034, 33.84843], [-118.10057, 33.84919], [-118.10266, 33.85689], [-118.10301, 33.85821], [-118.10312, 33.85892], [-118.10393, 33.8619], [-118.10454, 33.86404], [-118.10486, 33.86521], [-118.10494, 33.86568], [-118.10489, 33.86571], [-118.10496, 33.86571], [-118.10529, 33.8671], [-118.10555, 33.86805], [-118.10611, 33.86994], [-118.10646, 33.87134], [-118.10667, 33.87199], [-118.10707, 33.87348], [-118.10749, 33.87484], [-118.10776, 33.87584], [-118.10801, 33.87694], [-118.1082, 33.87764], [-118.1084, 33.87859], [-118.10854, 33.87918], [-118.10864, 33.87979], [-118.10866, 33.88017], [-118.10867, 33.88675], [-118.10871, 33.88799], [-118.10874, 33.89197], [-118.1088, 33.89366], [-118.10879, 33.89486], [-118.10874, 33.89587], [-118.1088, 33.8977], [-118.10885, 33.90208], [-118.1089, 33.90243], [-118.10885, 33.90308], [-118.10891, 33.90538], [-118.10896, 33.9062], [-118.10927, 33.90754], [-118.10954, 33.90844], [-118.10998, 33.9094], [-118.11019, 33.91003], [-118.11071, 33.91122], [-118.11096, 33.91216], [-118.11123, 33.91292], [-118.11145, 33.91335]]], [[[-118.06064, 34.01704], [-118.06034, 34.0173], [-118.05995, 34.01767], [-118.05967, 34.01775], [-118.06008, 34.01736], [-118.06039, 34.01702], [-118.06059, 34.01691], [-118.06064, 34.01704]]], [[[-118.05718, 34.0202], [-118.05659, 34.0208], [-118.05647, 34.02082], [-118.05624, 34.02078], [-118.05599, 34.02104], [-118.05596, 34.02124], [-118.05637, 34.02164], [-118.05628, 34.02168], [-118.05609, 34.02156], [-118.05585, 34.02136], [-118.05583, 34.0211], [-118.05607, 34.02078], [-118.05619, 34.02066], [-118.05645, 34.02071], [-118.05669, 34.02039], [-118.05703, 34.01998], [-118.05718, 34.0202]]], [[[-118.0539, 34.02414], [-118.05363, 34.02458], [-118.05288, 34.02562], [-118.05262, 34.02605], [-118.05234, 34.02643], [-118.0518, 34.02731], [-118.05126, 34.02796], [-118.05091, 34.02813], [-118.05152, 34.02738], [-118.05216, 34.02646], [-118.05316, 34.02491], [-118.05363, 34.02431], [-118.05385, 34.02384], [-118.0539, 34.02414]]], [[[-117.99167, 34.09319], [-117.99071, 34.09454], [-117.99031, 34.09439], [-117.99042, 34.09422], [-117.99113, 34.09362], [-117.99167, 34.09319]]], [[[-117.97634, 34.10744], [-117.97608, 34.10761], [-117.97604, 34.10758], [-117.97623, 34.1074], [-117.97634, 34.10744]]], [[[-118.03841, 34.03443], [-118.0324, 34.03706], [-118.03018, 34.03805], [-118.02831, 34.03884], [-118.02725, 34.03933], [-118.02466, 34.04038], [-118.02313, 34.04115], [-118.01905, 34.04296], [-118.01815, 34.04339], [-118.01733, 34.04382], [-118.01651, 34.04431], [-118.01579, 34.04478], [-118.01522, 34.0452], [-118.0144, 34.0459], [-118.01379, 34.04646], [-118.01334, 34.04692], [-118.0127, 34.04762], [-118.01229, 34.0481], [-118.01185, 34.04865], [-118.01143, 34.04923], [-118.01104, 34.0498], [-118.01067, 34.0504], [-118.01041, 34.05085], [-118.01011, 34.05143], [-118.00984, 34.05201], [-118.00961, 34.05255], [-118.00918, 34.05364], [-118.00877, 34.05498], [-118.00841, 34.05642], [-118.00853, 34.05676], [-118.00828, 34.05662], [-118.00826, 34.05674], [-118.00809, 34.05698], [-118.00816, 34.05703], [-118.008, 34.05721], [-118.00785, 34.05767], [-118.0078, 34.05766], [-118.00756, 34.05839], [-118.00726, 34.05917], [-118.00702, 34.05986], [-118.00691, 34.06003], [-118.00677, 34.06047], [-118.00656, 34.06097], [-118.00577, 34.06334], [-118.00573, 34.06372], [-118.00563, 34.0639], [-118.00555, 34.06409], [-118.00447, 34.0672], [-118.00342, 34.07028], [-118.00244, 34.07336], [-118.00212, 34.07414], [-118.00162, 34.07595], [-118.00138, 34.0775], [-118.0011, 34.07988], [-118.00077, 34.08225], [-118.00048, 34.08333], [-117.99952, 34.08611], [-117.99883, 34.08743], [-117.99849, 34.08795], [-117.9978, 34.08896], [-117.99715, 34.08987], [-117.99624, 34.09098], [-117.99515, 34.09219], [-117.99433, 34.09301], [-117.99251, 34.09463], [-117.98862, 34.09757], [-117.98778, 34.09826], [-117.98357, 34.10155], [-117.98094, 34.10352], [-117.97911, 34.10501], [-117.97674, 34.10689], [-117.97486, 34.10858], [-117.97242, 34.11067], [-117.96989, 34.11265], [-117.96979, 34.11257], [-117.9713, 34.11147], [-117.9751, 34.10817], [-117.98058, 34.10365], [-117.98343, 34.10148], [-117.99237, 34.09448], [-117.99415, 34.09298], [-117.9948, 34.09232], [-117.99554, 34.09137], [-117.99694, 34.08992], [-117.99791, 34.0884], [-117.99841, 34.08769], [-117.99965, 34.08523], [-118.00005, 34.0841], [-118.00045, 34.08271], [-118.00091, 34.08013], [-118.00095, 34.07947], [-118.00119, 34.07765], [-118.00121, 34.07686], [-118.00158, 34.07548], [-118.00219, 34.07355], [-118.00345, 34.06993], [-118.00448, 34.06686], [-118.00525, 34.06466], [-118.00541, 34.06411], [-118.00558, 34.06375], [-118.00575, 34.06306], [-118.00589, 34.06267], [-118.00634, 34.06144], [-118.00668, 34.06039], [-118.00733, 34.05852], [-118.00749, 34.05786], [-118.00764, 34.05739], [-118.00781, 34.05704], [-118.00785, 34.05682], [-118.00783, 34.0568], [-118.00796, 34.0567], [-118.0091, 34.05338], [-118.00931, 34.05269], [-118.00957, 34.05196], [-118.00978, 34.0514], [-118.00996, 34.051], [-118.01037, 34.05026], [-118.01047, 34.05005], [-118.01064, 34.0498], [-118.01078, 34.04953], [-118.01129, 34.04876], [-118.01166, 34.04831], [-118.01188, 34.048], [-118.01226, 34.0476], [-118.01275, 34.04704], [-118.01285, 34.04696], [-118.01339, 34.04634], [-118.01411, 34.04568], [-118.01481, 34.04516], [-118.01533, 34.04473], [-118.01622, 34.04415], [-118.0179, 34.0432], [-118.01874, 34.0428], [-118.01978, 34.04237], [-118.02122, 34.0417], [-118.02386, 34.04053], [-118.02709, 34.03914], [-118.02842, 34.03864], [-118.02972, 34.03804], [-118.03838, 34.03431], [-118.03841, 34.03443]]], [[[-117.94882, 34.13119], [-117.94815, 34.13196], [-117.94725, 34.13264], [-117.94681, 34.1329], [-117.94647, 34.1332], [-117.9457, 34.13373], [-117.94468, 34.13451], [-117.94405, 34.13496], [-117.94331, 34.13575], [-117.94298, 34.13616], [-117.94252, 34.13659], [-117.94216, 34.13687], [-117.94166, 34.13724], [-117.93952, 34.13805], [-117.93877, 34.13838], [-117.93806, 34.13866], [-117.9376, 34.13889], [-117.93713, 34.13919], [-117.93675, 34.13949], [-117.9365, 34.13973], [-117.93611, 34.14015], [-117.93558, 34.14081], [-117.93523, 34.1412], [-117.93496, 34.1416], [-117.93456, 34.142], [-117.93419, 34.14229], [-117.93352, 34.14267], [-117.93293, 34.14296], [-117.93156, 34.14375], [-117.93119, 34.14388], [-117.93077, 34.14418], [-117.92998, 34.14464], [-117.93036, 34.14423], [-117.93092, 34.14395], [-117.93147, 34.14365], [-117.93206, 34.14328], [-117.93258, 34.143], [-117.93314, 34.14262], [-117.93373, 34.14233], [-117.93422, 34.14202], [-117.93448, 34.14176], [-117.93508, 34.1411], [-117.93592, 34.14006], [-117.93682, 34.13925], [-117.93747, 34.13882], [-117.93794, 34.13857], [-117.9386, 34.1383], [-117.93932, 34.138], [-117.94031, 34.13764], [-117.94117, 34.1373], [-117.94137, 34.1372], [-117.9421, 34.13679], [-117.94235, 34.13659], [-117.94279, 34.13606], [-117.94341, 34.13538], [-117.94402, 34.13482], [-117.94567, 34.13364], [-117.94765, 34.13216], [-117.94805, 34.1319], [-117.94844, 34.13138], [-117.94872, 34.13114], [-117.94882, 34.13119]]], [[[-117.92065, 34.15278], [-117.92025, 34.15317], [-117.91981, 34.15357], [-117.91921, 34.15419], [-117.91761, 34.15578], [-117.91702, 34.15626], [-117.91596, 34.15701], [-117.91538, 34.15736], [-117.91429, 34.15813], [-117.91293, 34.15896], [-117.91355, 34.15845], [-117.91457, 34.1578], [-117.91504, 34.15742], [-117.91566, 34.15706], [-117.91611, 34.15677], [-117.91675, 34.15628], [-117.91731, 34.15589], [-117.91839, 34.15479], [-117.91917, 34.15404], [-117.91943, 34.15376], [-117.9197, 34.1535], [-117.92065, 34.15278]]], [[[-117.91021, 34.15971], [-117.91019, 34.15985], [-117.90895, 34.16001], [-117.90814, 34.15997], [-117.90749, 34.15987], [-117.9079, 34.15985], [-117.90861, 34.15989], [-117.90949, 34.15984], [-117.91021, 34.15971]]]]} | Open Access 1 | 12123 | San Gabriel River and Bike Trail | 24899 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 198.354 | San Gabriel River and Bike Trail | 0 | Local Recreation Area 3 | 4 | |
| 1702 | 1702 | 1701 | {"type": "MultiPolygon", "coordinates": [[[[-118.10957, 33.99118], [-118.10841, 33.99393], [-118.10812, 33.99414], [-118.10776, 33.99428], [-118.10723, 33.99468], [-118.1056, 33.99616], [-118.1049, 33.99713], [-118.10463, 33.99726], [-118.10446, 33.99744], [-118.10439, 33.99781], [-118.104, 33.99834], [-118.10373, 33.99899], [-118.1034, 33.99955], [-118.09727, 34.00134], [-118.09715, 34.00171], [-118.09154, 33.99932], [-118.09273, 33.99735], [-118.09448, 33.99594], [-118.09703, 33.99726], [-118.09734, 33.99688], [-118.09773, 33.99673], [-118.09793, 33.99653], [-118.10047, 33.99561], [-118.10232, 33.9928], [-118.10204, 33.99241], [-118.10691, 33.99146], [-118.10957, 33.99118]]], [[[-118.10991, 33.9911], [-118.1069, 33.99141], [-118.102, 33.99238], [-118.10139, 33.99156], [-118.10665, 33.98858], [-118.10706, 33.9888], [-118.10745, 33.98908], [-118.10935, 33.99074], [-118.10962, 33.99093], [-118.10991, 33.9911]]]]} | No Public Access 3 | 6693 | Rio Hondo & Bike Trail | 24380 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 234.812 | Rio Hondo & Bike Trail | 0 | Local Recreation Area 3 | 4 | |
| 7356 | 7356 | 7355 | {"type": "MultiPolygon", "coordinates": [[[[-118.0628, 33.83198], [-118.0623, 33.83332], [-118.0618, 33.83474], [-118.06169, 33.83513], [-118.06187, 33.83514], [-118.06185, 33.83522], [-118.06169, 33.83519], [-118.06164, 33.83536], [-118.0615, 33.83603], [-118.06132, 33.83727], [-118.0613, 33.83754], [-118.06124, 33.83796], [-118.06119, 33.8381], [-118.06114, 33.83843], [-118.06119, 33.83852], [-118.06131, 33.83859], [-118.06131, 33.83862], [-118.05997, 33.83865], [-118.05998, 33.83862], [-118.06021, 33.8385], [-118.06055, 33.8359], [-118.06077, 33.83494], [-118.06068, 33.83492], [-118.06058, 33.83495], [-118.0607, 33.83451], [-118.06094, 33.83379], [-118.06107, 33.83344], [-118.0628, 33.83198]]], [[[-118.06126, 33.83895], [-118.06125, 33.83898], [-118.06107, 33.83906], [-118.06104, 33.83915], [-118.06065, 33.84192], [-118.06053, 33.84251], [-118.06071, 33.84255], [-118.06063, 33.84287], [-118.06045, 33.84285], [-118.06031, 33.84332], [-118.06015, 33.84377], [-118.06033, 33.84383], [-118.06029, 33.84391], [-118.06012, 33.84387], [-118.0601, 33.84388], [-118.06005, 33.84403], [-118.06022, 33.84408], [-118.06016, 33.84424], [-118.05998, 33.84419], [-118.05961, 33.84495], [-118.05926, 33.84555], [-118.05916, 33.8457], [-118.05931, 33.84579], [-118.05914, 33.84603], [-118.05915, 33.84608], [-118.05904, 33.84601], [-118.05903, 33.84404], [-118.05933, 33.84332], [-118.05956, 33.84256], [-118.05972, 33.84173], [-118.05976, 33.84146], [-118.05936, 33.84143], [-118.05939, 33.84138], [-118.05938, 33.84131], [-118.05978, 33.84133], [-118.06007, 33.8393], [-118.0601, 33.83929], [-118.06013, 33.83911], [-118.05992, 33.83901], [-118.05993, 33.83898], [-118.06126, 33.83895]]], [[[-118.05906, 33.84647], [-118.05887, 33.84646], [-118.05885, 33.84651], [-118.05848, 33.84671], [-118.05662, 33.84944], [-118.05631, 33.84983], [-118.05507, 33.84984], [-118.05525, 33.84969], [-118.05551, 33.84942], [-118.05575, 33.84913], [-118.05749, 33.84657], [-118.0575, 33.84635], [-118.05754, 33.84628], [-118.05892, 33.84628], [-118.05906, 33.84636], [-118.05906, 33.84647]]], [[[-118.05583, 33.85032], [-118.0555, 33.85058], [-118.05501, 33.85093], [-118.05491, 33.85112], [-118.05476, 33.85123], [-118.05468, 33.85127], [-118.0546, 33.8512], [-118.04664, 33.85659], [-118.04643, 33.85693], [-118.04634, 33.85714], [-118.04633, 33.85671], [-118.04639, 33.85671], [-118.04639, 33.85664], [-118.04633, 33.85663], [-118.04632, 33.85595], [-118.04638, 33.85594], [-118.04638, 33.85586], [-118.04631, 33.85585], [-118.0463, 33.8556], [-118.04653, 33.85566], [-118.04784, 33.85479], [-118.04784, 33.85477], [-118.04764, 33.85477], [-118.04801, 33.85452], [-118.04824, 33.85453], [-118.04963, 33.85362], [-118.0504, 33.85363], [-118.0504, 33.85303], [-118.05091, 33.8527], [-118.05367, 33.85081], [-118.05441, 33.85033], [-118.05583, 33.85032]]]]} | Open Access 1 | 6698 | Coyote Creek & Bike Trail | 17737 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 63.536 | Coyote Creek & Bike Trail | 0 | Local Recreation Area 3 | 4 | |
| 15861 | 15861 | 15860 | {"type": "MultiPolygon", "coordinates": [[[[-118.38822, 33.8722], [-118.38765, 33.87247], [-118.38748, 33.87223], [-118.38807, 33.87196], [-118.38822, 33.8722]]], [[[-118.38856, 33.87271], [-118.38781, 33.87273], [-118.3877, 33.87257], [-118.38829, 33.8723], [-118.38856, 33.87271]]], [[[-118.38891, 33.87189], [-118.38834, 33.87214], [-118.38818, 33.87191], [-118.38876, 33.87164], [-118.38891, 33.87189]]]]} | Open Access 1 | 6066 | Redondo Beach Open Space | 24240 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 1.473 | Redondo Beach 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]);