units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,414 rows where AGNCY_LEV = 2 and DES_TP = 3 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 209
- Los Angeles, City of 115
- San Francisco, City and County of 80
- San Luis Obispo, City of 24
- Glendale, City of 24
- Davis, City of 23
- Long Beach, City of 23
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Santa Clarita, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Santa Cruz, City of 14
- San Marcos, City of 14
- Tiburon, Town of 13
- Poway, City of 12
- San Bernardino, City of 12
- Carlsbad, City of 11
- Mission Viejo, City of 11
- Fresno, City of 10
- Oceanside, City of 10
- Riverside, City of 9
- Irvine, City of 9
- Roseville, City of 9
- Santa Barbara, City of 8
- South San Francisco, City of 8
- Escondido, City of 8
- Chico, City of 8
- …
MNG_AG_TYP 7
ACCESS_TYP 4
- Open Access 1,229
- Restricted Access 140
- No Public Access 39
- Unknown Access 6
DES_TP 1
- Local Recreation Area · 1,414 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16239 | 16239 | 16238 | {"type": "Polygon", "coordinates": [[[-118.43979, 34.37452], [-118.43975, 34.37721], [-118.43642, 34.3772], [-118.43641, 34.3763], [-118.4342, 34.37628], [-118.4342, 34.37538], [-118.43309, 34.37537], [-118.4331, 34.37448], [-118.43979, 34.37452]]]} | Open Access 1 | 46271 | Placerita Golden Valley Ranch Open Space | 29557 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 35.339 | Placerita Golden Valley Ranch OS | 0 | Local Recreation Area 3 | 4 | |
16243 | 16243 | 16242 | {"type": "MultiPolygon", "coordinates": [[[[-118.36323, 34.43458], [-118.36322, 34.43457], [-118.36055, 34.43457], [-118.36051, 34.43809], [-118.36055, 34.44182], [-118.35619, 34.44135], [-118.35629, 34.44514], [-118.35199, 34.44471], [-118.35227, 34.45054], [-118.35121, 34.45123], [-118.34996, 34.45259], [-118.34943, 34.4556], [-118.34819, 34.45706], [-118.34734, 34.45754], [-118.34664, 34.45788], [-118.3451, 34.45882], [-118.34452, 34.4592], [-118.34411, 34.45949], [-118.34382, 34.45973], [-118.3431, 34.46042], [-118.34271, 34.461], [-118.34243, 34.46151], [-118.3421, 34.46221], [-118.34198, 34.46265], [-118.34153, 34.46301], [-118.34126, 34.46327], [-118.34096, 34.46349], [-118.33781, 34.46547], [-118.33439, 34.46541], [-118.33449, 34.45261], [-118.34343, 34.45164], [-118.34291, 34.43993], [-118.33652, 34.44005], [-118.33649, 34.4381], [-118.3369, 34.43822], [-118.33718, 34.43826], [-118.33746, 34.43827], [-118.33775, 34.43826], [-118.33803, 34.43822], [-118.33831, 34.43815], [-118.3394, 34.43775], [-118.33977, 34.43754], [-118.33997, 34.43738], [-118.34015, 34.43721], [-118.34031, 34.43701], [-118.3407, 34.43641], [-118.34081, 34.43628], [-118.34103, 34.43612], [-118.34131, 34.436], [-118.34273, 34.43601], [-118.34717, 34.43652], [-118.34715, 34.43365], [-118.34813, 34.43301], [-118.36054, 34.43456], [-118.36056, 34.43364], [-118.36089, 34.4336], [-118.3618, 34.43334], [-118.36205, 34.43328], [-118.36223, 34.43328], [-118.36241, 34.43329], [-118.36262, 34.43336], [-118.36287, 34.4335], [-118.36299, 34.43361], [-118.36312, 34.43381], [-118.36318, 34.43401], [-118.36321, 34.43414], [-118.36323, 34.43458]]], [[[-118.3409, 34.436], [-118.34069, 34.43615], [-118.34057, 34.43627], [-118.34013, 34.43694], [-118.33998, 34.43712], [-118.3398, 34.43729], [-118.3396, 34.43744], [-118.33939, 34.43756], [-118.3386, 34.43787], [-118.33858, 34.43737], [-118.33899, 34.43721], [-118.33931, 34.43703], [-118.34058, 34.436], [-118.3409, 34.436]]], [[[-118.36127, 34.45283], [-118.36122, 34.45645], [-118.35676, 34.45623], [-118.35673, 34.45849], [-118.35673, 34.45992], [-118.35224, 34.45977], [-118.35219, 34.46359], [-118.34774, 34.46348], [-118.34779, 34.45962], [-118.34587, 34.45955], [-118.34862, 34.45799], [-118.34875, 34.45789], [-118.35028, 34.45631], [-118.35134, 34.45393], [-118.35263, 34.45225], [-118.36127, 34.45283]]], [[[-118.36511, 34.43459], [-118.36365, 34.43458], [-118.36348, 34.43384], [-118.36335, 34.43357], [-118.36309, 34.43329], [-118.36283, 34.43313], [-118.36253, 34.43304], [-118.36221, 34.433], [-118.36195, 34.43302], [-118.36098, 34.43329], [-118.36057, 34.43336], [-118.36058, 34.43254], [-118.36187, 34.43258], [-118.3638, 34.43301], [-118.36414, 34.43315], [-118.36505, 34.43362], [-118.36511, 34.43459]]], [[[-118.36502, 34.43312], [-118.36439, 34.43279], [-118.36405, 34.43265], [-118.36345, 34.4325], [-118.36195, 34.43217], [-118.36058, 34.43212], [-118.36059, 34.43104], [-118.36489, 34.43103], [-118.36502, 34.43312]]]]} | Open Access 1 | 46243 | Eastern Greenbelt Open Space | 29554 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 1243.079 | Eastern Greenbelt OS | 0 | Local Recreation Area 3 | 4 | |
16246 | 16246 | 16245 | {"type": "MultiPolygon", "coordinates": [[[[-118.55666, 34.36353], [-118.55638, 34.36353], [-118.55606, 34.36251], [-118.55601, 34.36229], [-118.5559, 34.36205], [-118.55584, 34.36184], [-118.55603, 34.36154], [-118.55616, 34.36122], [-118.5562, 34.36102], [-118.55622, 34.36086], [-118.55622, 34.36066], [-118.55619, 34.36047], [-118.55624, 34.36041], [-118.55647, 34.36049], [-118.55666, 34.36063], [-118.5568, 34.36081], [-118.55687, 34.36101], [-118.55687, 34.36112], [-118.55686, 34.36123], [-118.55644, 34.36285], [-118.55666, 34.36353]]], [[[-118.5637, 34.36721], [-118.55864, 34.36719], [-118.55799, 34.36633], [-118.55783, 34.36608], [-118.55762, 34.36568], [-118.55724, 34.36447], [-118.55731, 34.36444], [-118.55715, 34.36394], [-118.55707, 34.36395], [-118.55678, 34.36302], [-118.55681, 34.36242], [-118.55734, 34.36199], [-118.55741, 34.36171], [-118.55717, 34.36119], [-118.55718, 34.36099], [-118.55713, 34.36079], [-118.55702, 34.36058], [-118.55685, 34.36041], [-118.55671, 34.36031], [-118.55654, 34.36023], [-118.55615, 34.36014], [-118.55597, 34.35986], [-118.56368, 34.35989], [-118.5637, 34.36721]]], [[[-118.58964, 34.37075], [-118.58812, 34.37037], [-118.58532, 34.37075], [-118.58102, 34.37074], [-118.58107, 34.37367], [-118.58021, 34.37368], [-118.57873, 34.37313], [-118.5763, 34.37189], [-118.57482, 34.37037], [-118.57234, 34.36904], [-118.57228, 34.36716], [-118.58094, 34.36723], [-118.58962, 34.36713], [-118.58964, 34.37075]]]]} | Open Access 1 | 46255 | Rivendale Ranch Open Space | 29537 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 297.561 | Rivendale Ranch OS | 0 | Local Recreation Area 3 | 4 | |
16260 | 16260 | 16259 | {"type": "MultiPolygon", "coordinates": [[[[-118.49356, 34.35386], [-118.48502, 34.35379], [-118.48506, 34.35159], [-118.48864, 34.35162], [-118.48894, 34.34448], [-118.48893, 34.34446], [-118.48492, 34.34449], [-118.48478, 34.33738], [-118.4844, 34.33028], [-118.48473, 34.3303], [-118.49129, 34.34281], [-118.49356, 34.35386]]], [[[-118.49223, 34.34234], [-118.48596, 34.33037], [-118.48876, 34.33053], [-118.48864, 34.32817], [-118.48942, 34.32864], [-118.48973, 34.32973], [-118.49187, 34.34057], [-118.49223, 34.34234]]], [[[-118.50547, 34.34135], [-118.5049, 34.342], [-118.50487, 34.34187], [-118.50482, 34.34177], [-118.50473, 34.3417], [-118.50462, 34.34168], [-118.50447, 34.34172], [-118.50433, 34.34184], [-118.50422, 34.34191], [-118.504, 34.34197], [-118.50382, 34.34197], [-118.50292, 34.34184], [-118.50269, 34.34186], [-118.50247, 34.34195], [-118.50239, 34.34203], [-118.50235, 34.34212], [-118.50242, 34.34262], [-118.50241, 34.34273], [-118.50238, 34.34282], [-118.50232, 34.34291], [-118.50168, 34.34362], [-118.50153, 34.34372], [-118.50152, 34.34378], [-118.50153, 34.34379], [-118.50163, 34.34375], [-118.50175, 34.34366], [-118.50245, 34.34287], [-118.50249, 34.34276], [-118.5025, 34.34264], [-118.50243, 34.34213], [-118.50245, 34.34207], [-118.50252, 34.34202], [-118.50269, 34.34194], [-118.50289, 34.34192], [-118.50377, 34.34204], [-118.50395, 34.34205], [-118.50412, 34.34202], [-118.50426, 34.34196], [-118.50438, 34.34189], [-118.50451, 34.34178], [-118.50456, 34.34176], [-118.50467, 34.34176], [-118.50476, 34.34183], [-118.50482, 34.342], [-118.50481, 34.34208], [-118.50479, 34.34218], [-118.50418, 34.34376], [-118.50372, 34.34488], [-118.50352, 34.34546], [-118.50347, 34.34573], [-118.50349, 34.34617], [-118.5028, 34.34557], [-118.50237, 34.34581], [-118.50235, 34.34589], [-118.50259, 34.34611], [-118.50311, 34.34639], [-118.50311, 34.34656], [-118.50351, 34.34692], [-118.50345, 34.34741], [-118.50332, 34.3477], [-118.50329, 34.34781], [-118.50328, 34.34815], [-118.5033, 34.34859], [-118.50335, 34.34912], [-118.50343, 34.34965], [-118.50352, 34.35006], [-118.50352, 34.35014], [-118.50346, 34.35024], [-118.50335, 34.3503], [-118.50284, 34.35033], [-118.50267, 34.35038], [-118.50258, 34.35045], [-118.50253, 34.35054], [-118.5025, 34.35063], [-118.50251, 34.35073], [-118.50257, 34.35083], [-118.50266, 34.35092], [-118.50322, 34.35116], [-118.50311, 34.35141], [-118.50304, 34.3517], [-118.50329, 34.35173], [-118.50338, 34.35144], [-118.50349, 34.35121], [-118.50365, 34.35099], [-118.50387, 34.35079], [-118.504, 34.35129], [-118.50382, 34.35176], [-118.50417, 34.35214], [-118.49895, 34.35224], [-118.4988, 34.35155], [-118.49516, 34.35161], [-118.49287, 34.34043], [-118.49077, 34.32978], [-118.49087, 34.32952], [-118.49073, 34.32943], [-118.49094, 34.32886], [-118.49202, 34.32845], [-118.49164, 34.32997], [-118.49181, 34.33008], [-118.49224, 34.32836], [-118.49355, 34.32962], [-118.49553, 34.32907], [-118.49586, 34.32851], [-118.49812, 34.32851], [-118.49829, 34.32887], [-118.49766, 34.32878], [-118.49735, 34.32883], [-118.49734, 34.32885], [-118.49736, 34.32891], [-118.49745, 34.32893], [-118.49754, 34.32896], [-118.49764, 34.32904], [-118.49776, 34.32905], [-118.49783, 34.32909], [-118.49787, 34.32919], [-118.49793, 34.32922], [-118.49809, 34.32924], [-118.49817, 34.32931], [-118.49839, 34.32929], [-118.49858, 34.33091], [-118.49864, 34.33107], [-118.49871, 34.33115], [-118.49998, 34.33231], [-118.50004, 34.33229], [-118.50058, 34.33321], [-118.50057, 34.33384], [-118.50052, 34.3339], [-118.50063, 34.33398], [-118.50069, 34.33394], [-118.50266, 34.3355], [-118.50322, 34.3357], [-118.50313, 34.33646], [-118.50358, 34.33667], [-118.50371, 34.337], [-118.50379, 34.33716], [-118.50381, 34.33716], [-118.50387, 34.33726], [-118.50381, 34.33731], [-118.5024, 34.33646], [-118.50238, 34.33646], [-118.50234, 34.33811], [-118.50189, 34.34125], [-118.50547, 34.34135]], [[-118.50144, 34.34439], [-118.50145, 34.34438], [-118.50144, 34.34437], [-118.50143, 34.34438], [-118.50144, 34.34439]]], [[[-118.50414, 34.33422], [-118.50355, 34.33549], [-118.50349, 34.33567], [-118.50345, 34.33587], [-118.50345, 34.33606], [-118.50349, 34.33625], [-118.50356, 34.3365], [-118.50331, 34.33638], [-118.50339, 34.33561], [-118.50275, 34.33538], [-118.50073, 34.33379], [-118.50075, 34.33318], [-118.50018, 34.33222], [-118.50356, 34.33061], [-118.50378, 34.33125], [-118.50403, 34.33224], [-118.5036, 34.3328], [-118.50334, 34.33331], [-118.50379, 34.33394], [-118.50414, 34.33422]]], [[[-118.50375, 34.35057], [-118.50348, 34.35082], [-118.50325, 34.35111], [-118.5027, 34.35087], [-118.50261, 34.35078], [-118.50257, 34.35067], [-118.50258, 34.35059], [-118.50261, 34.35052], [-118.50268, 34.35045], [-118.50276, 34.3504], [-118.50287, 34.35038], [-118.50331, 34.35037], [-118.50346, 34.35032], [-118.50352, 34.35027], [-118.50357, 34.3502], [-118.50359, 34.35013], [-118.50359, 34.35004], [-118.50361, 34.35004], [-118.50375, 34.35057]]], [[[-118.50544, 34.33608], [-118.50506, 34.33637], [-118.5042, 34.33701], [-118.5041, 34.33682], [-118.50404, 34.33666], [-118.50437, 34.33528], [-118.50451, 34.33513], [-118.50462, 34.33519], [-118.50489, 34.3349], [-118.50532, 34.33555], [-118.50544, 34.33608]]]]} | Open Access 1 | 46267 | Whitney Elsmere Open Space | 29551 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 883.758 | Whitney Elsmere OS | 0 | Local Recreation Area 3 | 4 | |
16261 | 16261 | 16260 | {"type": "MultiPolygon", "coordinates": [[[[-118.41512, 34.42708], [-118.415, 34.42714], [-118.4149, 34.42716], [-118.40919, 34.4272], [-118.40918, 34.42722], [-118.40769, 34.42743], [-118.40571, 34.42774], [-118.4042, 34.42807], [-118.40421, 34.42543], [-118.40506, 34.42529], [-118.40556, 34.42524], [-118.40614, 34.42521], [-118.41018, 34.42533], [-118.41083, 34.4254], [-118.41107, 34.42541], [-118.41511, 34.42538], [-118.41512, 34.42708]]], [[[-118.42066, 34.42601], [-118.41969, 34.42661], [-118.41932, 34.4268], [-118.41875, 34.42703], [-118.41816, 34.42721], [-118.41755, 34.42732], [-118.41694, 34.42738], [-118.41638, 34.42738], [-118.41534, 34.4273], [-118.41541, 34.42705], [-118.41538, 34.42697], [-118.41533, 34.42693], [-118.41533, 34.42662], [-118.41581, 34.42667], [-118.41582, 34.42654], [-118.41667, 34.4265], [-118.41889, 34.42631], [-118.41955, 34.42619], [-118.42054, 34.42589], [-118.42066, 34.42601]]], [[[-118.42333, 34.41915], [-118.42288, 34.41926], [-118.42269, 34.41891], [-118.42314, 34.41881], [-118.42333, 34.41915]]], [[[-118.42433, 34.41979], [-118.42386, 34.4198], [-118.4238, 34.41976], [-118.42379, 34.41972], [-118.42373, 34.41972], [-118.42368, 34.41943], [-118.42361, 34.41922], [-118.42353, 34.41903], [-118.42337, 34.41876], [-118.42372, 34.41868], [-118.42372, 34.41877], [-118.42432, 34.41955], [-118.42433, 34.41979]]]]} | Open Access 1 | 46268 | Lost Canyon River Trail Open Space | 29555 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 67.007 | Lost Canyon River Trail OS | 0 | Local Recreation Area 3 | 4 | |
14043 | 14043 | 14042 | {"type": "Polygon", "coordinates": [[[-122.52894, 37.92555], [-122.5287, 37.92554], [-122.52852, 37.9251], [-122.52838, 37.92462], [-122.52834, 37.92435], [-122.52836, 37.92395], [-122.52835, 37.92375], [-122.52841, 37.9233], [-122.52841, 37.92304], [-122.52834, 37.9227], [-122.52806, 37.92203], [-122.52792, 37.92202], [-122.52785, 37.92191], [-122.52791, 37.92188], [-122.52742, 37.92065], [-122.52722, 37.92036], [-122.52676, 37.91948], [-122.52677, 37.91915], [-122.52681, 37.91931], [-122.52704, 37.91928], [-122.52728, 37.91946], [-122.52764, 37.92033], [-122.52817, 37.92153], [-122.5281, 37.92157], [-122.52821, 37.92186], [-122.52833, 37.92208], [-122.52845, 37.92237], [-122.52851, 37.92255], [-122.52861, 37.92306], [-122.52855, 37.92425], [-122.5286, 37.92467], [-122.52873, 37.92511], [-122.52882, 37.92534], [-122.52894, 37.92555]]]} | Open Access 1 | 38043 | Corte Madera Bike Path | 17658 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 4.52 | Corte Madera Bike Path | 0 | Local Recreation Area 3 | 4 | |
7296 | 7296 | 7295 | {"type": "MultiPolygon", "coordinates": [[[[-118.09001, 33.80323], [-118.08973, 33.80323], [-118.08972, 33.80318], [-118.08943, 33.79703], [-118.0896, 33.79703], [-118.08976, 33.79762], [-118.09001, 33.80323]]], [[[-118.09035, 33.80941], [-118.09002, 33.8094], [-118.08982, 33.80517], [-118.09014, 33.80517], [-118.09035, 33.80941]]], [[[-118.09387, 33.78866], [-118.09152, 33.79346], [-118.09152, 33.79349], [-118.09142, 33.79369], [-118.09128, 33.7941], [-118.09112, 33.79469], [-118.09104, 33.7952], [-118.09101, 33.79591], [-118.0914, 33.80399], [-118.09119, 33.80398], [-118.09108, 33.80402], [-118.09108, 33.80406], [-118.09077, 33.80406], [-118.09035, 33.79591], [-118.09068, 33.7959], [-118.09069, 33.79548], [-118.09072, 33.79515], [-118.09082, 33.79456], [-118.0909, 33.79422], [-118.091, 33.79389], [-118.09124, 33.79331], [-118.09351, 33.78865], [-118.09387, 33.78866]]], [[[-118.09172, 33.81023], [-118.09119, 33.81024], [-118.09091, 33.80678], [-118.09078, 33.80436], [-118.09109, 33.80437], [-118.0911, 33.8044], [-118.09119, 33.80445], [-118.09143, 33.80444], [-118.09172, 33.81023]]]]} | Open Access 1 | 6580 | San Gabriel River Trail | 29917 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 36.911 | San Gabriel River Trail | 0 | Local Recreation Area 3 | 4 | |
15389 | 15389 | 15388 | {"type": "Polygon", "coordinates": [[[-118.09413, 33.83158], [-118.09346, 33.83146], [-118.093, 33.82842], [-118.09369, 33.82863], [-118.09413, 33.83158]]]} | Open Access 1 | 46608 | San Gabriel River Trail | 29917 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 5.002 | San Gabriel River Trail | 0 | Local Recreation Area 3 | 4 | |
16095 | 16095 | 16094 | {"type": "Polygon", "coordinates": [[[-118.74322, 34.13739], [-118.74273, 34.13773], [-118.7424, 34.13775], [-118.74194, 34.1385], [-118.74154, 34.13874], [-118.74103, 34.13875], [-118.74075, 34.13873], [-118.74055, 34.13832], [-118.74076, 34.13825], [-118.741, 34.13822], [-118.74111, 34.13819], [-118.74123, 34.13814], [-118.74132, 34.13807], [-118.74156, 34.13795], [-118.74167, 34.13786], [-118.74175, 34.1379], [-118.74179, 34.13782], [-118.74184, 34.13753], [-118.74189, 34.13743], [-118.74195, 34.13733], [-118.74201, 34.13727], [-118.74209, 34.13723], [-118.74285, 34.13708], [-118.74295, 34.13708], [-118.74305, 34.13713], [-118.74322, 34.13739]]]} | Open Access 1 | 12512 | Agoura Hills Open Space | 29518 | 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 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 4.255 | Agoura Hills OS | 0 | Local Recreation Area 3 | 4 | |
4062 | 4062 | 4061 | {"type": "Polygon", "coordinates": [[[-122.30734, 37.78918], [-122.30729, 37.7897], [-122.30701, 37.78969], [-122.30686, 37.78973], [-122.30677, 37.78959], [-122.3068, 37.78922], [-122.30689, 37.78916], [-122.30734, 37.78918]]]} | Open Access 1 | 47050 | City View Skate Park | 30700 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 0.667 | City View Skate Park | 0 | Local Recreation Area 3 | 4 | |
4107 | 4107 | 4106 | {"type": "Polygon", "coordinates": [[[-122.30486, 37.78899], [-122.30487, 37.78905], [-122.3047, 37.79053], [-122.30344, 37.79025], [-122.30345, 37.79004], [-122.30357, 37.79001], [-122.30361, 37.78948], [-122.30357, 37.78946], [-122.30359, 37.7889], [-122.30486, 37.78899]]]} | Open Access 1 | 47048 | Multipurpose Field | 30698 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 4.381 | Multipurpose Field | 0 | Local Recreation Area 3 | 4 | |
14448 | 14448 | 14447 | {"type": "Polygon", "coordinates": [[[-122.29245, 37.77738], [-122.29241, 37.77968], [-122.292, 37.77973], [-122.29174, 37.77979], [-122.29165, 37.77978], [-122.29156, 37.77971], [-122.29141, 37.77947], [-122.29133, 37.77887], [-122.29138, 37.77735], [-122.29245, 37.77738]]]} | Open Access 1 | 47059 | Main Street Soccer Field | 30710 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 6.06 | Main Street Soccer Field | 0 | Local Recreation Area 3 | 4 | |
11170 | 11170 | 11169 | {"type": "Polygon", "coordinates": [[[-122.29374, 37.88467], [-122.29357, 37.88471], [-122.29353, 37.88457], [-122.2937, 37.88454], [-122.29374, 37.88467]]]} | Open Access 1 | 48000 | Opal Staniek Tot Lot | 33380 | 1002 | Albany, City of 274 | City 2 | City Agency 2 | http://www.albanyca.org/index.aspx?page=473 | City 2 | 1002 | Albany, City of 269 | City 2 | City Agency 2 | https://www.albanyca.org/Home/Components/FacilityDirectory/FacilityDirectory/69/1670 | Alameda 17 | 0.06 | Opal Staniek Tot Lot | 0 | Local Recreation Area 3 | 4 |
13063 | 13063 | 13062 | {"type": "MultiPolygon", "coordinates": [[[[-122.29164, 37.88481], [-122.29136, 37.88486], [-122.29061, 37.88317], [-122.29078, 37.88314], [-122.29095, 37.88317], [-122.29109, 37.88309], [-122.29164, 37.88481]]], [[[-122.29253, 37.88761], [-122.29226, 37.88766], [-122.29143, 37.88499], [-122.29168, 37.88494], [-122.29253, 37.88761]]], [[[-122.29345, 37.89046], [-122.29317, 37.89048], [-122.29235, 37.88793], [-122.29262, 37.88787], [-122.29345, 37.89046]]], [[[-122.2942, 37.8928], [-122.29392, 37.8928], [-122.29324, 37.8907], [-122.29351, 37.89068], [-122.2942, 37.8928]]], [[[-122.29472, 37.89443], [-122.29445, 37.89449], [-122.29396, 37.89297], [-122.29425, 37.89297], [-122.29472, 37.89443]]], [[[-122.29524, 37.89605], [-122.29498, 37.8961], [-122.29471, 37.89533], [-122.2945, 37.89465], [-122.29477, 37.8946], [-122.29524, 37.89605]]], [[[-122.29576, 37.89767], [-122.29561, 37.8977], [-122.29513, 37.89624], [-122.29529, 37.89621], [-122.29576, 37.89767]]]]} | Open Access 1 | 34930 | Ohlone Greenway | 23074 | 1002 | Albany, City of 274 | City 2 | City Agency 2 | http://www.albanyca.org/index.aspx?page=473 | City 2 | 1002 | Albany, City of 269 | City 2 | City Agency 2 | Alameda 17 | 9.274 | Ohlone Greenway | 0 | Local Recreation Area 3 | 4 | |
8257 | 8257 | 8256 | {"type": "Polygon", "coordinates": [[[-118.11967, 34.09049], [-118.11966, 34.09074], [-118.11234, 34.09388], [-118.10973, 34.0882], [-118.10992, 34.08814], [-118.10934, 34.08688], [-118.1091, 34.08626], [-118.10941, 34.08615], [-118.10899, 34.08523], [-118.10881, 34.08475], [-118.11269, 34.08456], [-118.11268, 34.08483], [-118.11269, 34.0859], [-118.11273, 34.08679], [-118.11276, 34.08697], [-118.11298, 34.08739], [-118.1137, 34.08774], [-118.11393, 34.08771], [-118.11418, 34.08766], [-118.11449, 34.08765], [-118.11449, 34.08813], [-118.11461, 34.08814], [-118.11486, 34.08831], [-118.11491, 34.08836], [-118.11491, 34.08858], [-118.11575, 34.08939], [-118.11563, 34.08939], [-118.11563, 34.0896], [-118.11567, 34.08964], [-118.1157, 34.08965], [-118.11577, 34.08965], [-118.11578, 34.08941], [-118.11591, 34.08929], [-118.11685, 34.08929], [-118.11686, 34.09051], [-118.11967, 34.09049]]]} | Restricted Access 2 | 45406 | Alhambra Municipal Golf Course | 33112 | 1003 | Alhambra, City of 158 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://alhambragolf.com/ag/ | Los Angeles 6 | 107.021 | Alhambra Municipal GC | 0 | Local Recreation Area 3 | 4 |
10850 | 10850 | 10849 | {"type": "Polygon", "coordinates": [[[-118.13169, 34.08265], [-118.12945, 34.08267], [-118.12943, 34.08001], [-118.1294, 34.07954], [-118.12943, 34.07953], [-118.13166, 34.07952], [-118.13169, 34.08265]]]} | Open Access 1 | 20638 | Moor Field | 22457 | 1003 | Alhambra, City of 158 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | Los Angeles 6 | 17.798 | Moor Field | 0 | Local Recreation Area 3 | 4 | |
10127 | 10127 | 10126 | {"type": "Polygon", "coordinates": [[[-122.25999, 38.18782], [-122.25802, 38.18781], [-122.25773, 38.18636], [-122.2597, 38.18619], [-122.25999, 38.18782]]]} | Open Access 1 | 17597 | Little League Complex | 21344 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 7.36 | Little League Complex | 0 | Local Recreation Area 3 | 4 | |
3781 | 3781 | 3780 | {"type": "Polygon", "coordinates": [[[-117.93457, 33.80691], [-117.93442, 33.80719], [-117.93423, 33.80745], [-117.93415, 33.80743], [-117.93406, 33.80742], [-117.93397, 33.80743], [-117.9339, 33.8074], [-117.93378, 33.8074], [-117.93373, 33.80741], [-117.93365, 33.80747], [-117.93366, 33.80767], [-117.93284, 33.80768], [-117.93284, 33.80692], [-117.93457, 33.80691]]]} | Open Access 1 | 8684 | Energy Field Park | 18673 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 2.549 | Energy Field Park | 0 | Local Recreation Area 3 | 4 | |
10652 | 10652 | 10651 | {"type": "Polygon", "coordinates": [[[-117.82661, 33.83646], [-117.82589, 33.83675], [-117.82503, 33.83724], [-117.82501, 33.83776], [-117.82433, 33.83779], [-117.8237, 33.83789], [-117.82352, 33.8379], [-117.823, 33.83783], [-117.82292, 33.83683], [-117.82455, 33.83597], [-117.82493, 33.83624], [-117.82608, 33.83604], [-117.82637, 33.83617], [-117.82656, 33.83616], [-117.82661, 33.83646]]]} | Open Access 1 | 18994 | Olive Hills Tennis Courts | 23124 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 10.614 | Olive Hills Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
14694 | 14694 | 14693 | {"type": "Polygon", "coordinates": [[[-117.87789, 33.85315], [-117.87828, 33.85347], [-117.87829, 33.85352], [-117.87826, 33.85357], [-117.87816, 33.8536], [-117.87802, 33.8536], [-117.87749, 33.85356], [-117.87737, 33.85357], [-117.877, 33.85366], [-117.87768, 33.85322], [-117.8778, 33.85322], [-117.87789, 33.85315]]]} | Open Access 1 | 45056 | Miraloma Park and Community Center | 28051 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | https://www.anaheim.net/2206/Miraloma-Park-Family-Resource-Center | Orange 3 | 0.744 | Miraloma Park and Community Ctr. | 2015 | 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]);