superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
431 rows where ACCESS_TYP = 1 and MNG_AGENCY = 24 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 411
MNG_AGENCY 1
- Los Angeles, City of · 411 ✖
ACCESS_TYP 1
- Open Access · 411 ✖
Link | rowid ▲ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14458 | 14458 | 14457 | {"type": "Polygon", "coordinates": [[[-118.35534, 34.01483], [-118.35527, 34.01483], [-118.35522, 34.01487], [-118.35483, 34.01488], [-118.35481, 34.01478], [-118.35463, 34.01478], [-118.35459, 34.01483], [-118.35418, 34.01483], [-118.35415, 34.01324], [-118.35421, 34.01321], [-118.35422, 34.01316], [-118.35369, 34.01306], [-118.35267, 34.01268], [-118.35261, 34.01267], [-118.35244, 34.0126], [-118.35201, 34.01244], [-118.35155, 34.01232], [-118.35169, 34.01201], [-118.35174, 34.01198], [-118.35176, 34.01183], [-118.35143, 34.01178], [-118.35119, 34.01176], [-118.35042, 34.01179], [-118.35038, 34.01174], [-118.3502, 34.01174], [-118.35017, 34.01178], [-118.35006, 34.01178], [-118.34966, 34.01171], [-118.34938, 34.01163], [-118.35013, 34.01064], [-118.35019, 34.01064], [-118.35049, 34.01087], [-118.3512, 34.01124], [-118.3514, 34.01131], [-118.35213, 34.01149], [-118.35392, 34.01216], [-118.35418, 34.01222], [-118.35444, 34.01226], [-118.35519, 34.01226], [-118.35525, 34.0123], [-118.35533, 34.01232], [-118.3553, 34.01258], [-118.35534, 34.01483]]]} | Open Access 1 | Jim Gilliam Recreation Center | 20411 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 17.634 | Jim Gilliam Rec. Ctr. | ||
14316 | 14316 | 14315 | {"type": "Polygon", "coordinates": [[[-118.445, 34.26558], [-118.44458, 34.26545], [-118.44422, 34.26529], [-118.4438, 34.26504], [-118.44348, 34.26478], [-118.44336, 34.26486], [-118.44333, 34.26484], [-118.44307, 34.26456], [-118.44309, 34.26422], [-118.44317, 34.26385], [-118.445, 34.26558]]]} | Open Access 1 | Unnamed site - Los Angeles, City of | 28718 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.287 | |||
14040 | 14040 | 14039 | {"type": "Polygon", "coordinates": [[[-118.29214, 33.74614], [-118.29214, 33.74647], [-118.29177, 33.74647], [-118.29177, 33.74612], [-118.29179, 33.74611], [-118.2921, 33.74611], [-118.29214, 33.74614]]]} | Open Access 1 | Los Angeles Sister Cities Plaza | https://www.laparks.org/park/los-angeles-sister-cities-plaza | 32611 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.333 | Los Angeles Sister Cities Plaza | |
14038 | 14038 | 14037 | {"type": "Polygon", "coordinates": [[[-118.44058, 34.20165], [-118.44015, 34.20165], [-118.44015, 34.20137], [-118.44021, 34.20134], [-118.44058, 34.20134], [-118.44058, 34.20165]]]} | Open Access 1 | Greenwood Square Park | https://www.laparks.org/park/greenwood-square-park | 32609 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.331 | Greenwood Square Park | |
14030 | 14030 | 14029 | {"type": "Polygon", "coordinates": [[[-118.29133, 33.98266], [-118.29128, 33.9827], [-118.2911, 33.9827], [-118.2911, 33.98267], [-118.29108, 33.98267], [-118.29108, 33.98256], [-118.29105, 33.98254], [-118.29105, 33.9822], [-118.29129, 33.98228], [-118.29132, 33.9823], [-118.29133, 33.98266]]]} | Open Access 1 | Vermont Gage Park | https://www.laparks.org/park/vermont-and-gage-park | 32601 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.306 | Vermont Gage Park | |
13984 | 13984 | 13983 | {"type": "Polygon", "coordinates": [[[-118.30056, 34.0395], [-118.30046, 34.0395], [-118.30046, 34.03918], [-118.30049, 34.03915], [-118.30055, 34.03915], [-118.30056, 34.0395]]]} | Open Access 1 | West Adams Heights Park | https://www.laparks.org/park/west-adams-heights-park | 32572 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.088 | West Adams Heights Park | 2014 |
13841 | 13841 | 13840 | {"type": "MultiPolygon", "coordinates": [[[[-118.26072, 33.94705], [-118.26071, 33.94739], [-118.26068, 33.94742], [-118.25879, 33.94744], [-118.25875, 33.94743], [-118.25874, 33.9474], [-118.25874, 33.94706], [-118.26072, 33.94705]]], [[[-118.265, 33.94722], [-118.265, 33.94739], [-118.26494, 33.94743], [-118.26096, 33.94745], [-118.26093, 33.94744], [-118.26091, 33.94741], [-118.26092, 33.94703], [-118.26328, 33.94702], [-118.26329, 33.94723], [-118.265, 33.94722]]]]} | Open Access 1 | Jacaranda Park | 33131 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 5.33 | Jacaranda Park | ||
13746 | 13746 | 13745 | {"type": "Polygon", "coordinates": [[[-118.29521, 34.27884], [-118.29519, 34.2801], [-118.29503, 34.28012], [-118.29504, 34.2803], [-118.2952, 34.28031], [-118.29519, 34.28119], [-118.29466, 34.28157], [-118.29422, 34.28183], [-118.29408, 34.28193], [-118.29383, 34.28219], [-118.29376, 34.2823], [-118.29367, 34.28249], [-118.29369, 34.28251], [-118.29404, 34.28224], [-118.29422, 34.28204], [-118.29436, 34.28194], [-118.29469, 34.28176], [-118.29496, 34.28158], [-118.29518, 34.28141], [-118.29514, 34.28609], [-118.29164, 34.28609], [-118.29166, 34.28599], [-118.29165, 34.28597], [-118.29157, 34.28602], [-118.29153, 34.28609], [-118.29132, 34.28609], [-118.2914, 34.28588], [-118.29123, 34.28531], [-118.29102, 34.2843], [-118.29098, 34.28401], [-118.29159, 34.28334], [-118.29146, 34.28272], [-118.29116, 34.28235], [-118.29016, 34.28207], [-118.28993, 34.28138], [-118.28979, 34.28133], [-118.28989, 34.28109], [-118.28996, 34.28047], [-118.29016, 34.28012], [-118.29081, 34.27972], [-118.29084, 34.27882], [-118.29521, 34.27884]]]} | Open Access 1 | Tujunga Little League Field | http://www.tujungalittleleague.com/ | 31254 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 79.162 | Tujunga Little League Field | |
13737 | 13737 | 13736 | {"type": "Polygon", "coordinates": [[[-118.34039, 34.03371], [-118.34038, 34.03384], [-118.34032, 34.03407], [-118.34007, 34.03394], [-118.34039, 34.03352], [-118.34039, 34.03371]]]} | Open Access 1 | Gladys Jean Wesson Park | https://www.laparks.org/park/gladys-jean-wesson-park-aka-west-boulevard | 32559 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.209 | Gladys Jean Wesson Park | 2014 |
13541 | 13541 | 13540 | {"type": "Polygon", "coordinates": [[[-118.36933, 34.27138], [-118.36934, 34.27154], [-118.36933, 34.27158], [-118.36927, 34.27162], [-118.36915, 34.27167], [-118.36888, 34.27172], [-118.36875, 34.27177], [-118.36856, 34.2719], [-118.36846, 34.27199], [-118.36839, 34.27207], [-118.36834, 34.27218], [-118.36828, 34.2722], [-118.36823, 34.27225], [-118.3682, 34.27246], [-118.3682, 34.27267], [-118.36779, 34.27246], [-118.36555, 34.26923], [-118.36819, 34.269], [-118.36821, 34.26921], [-118.36828, 34.26945], [-118.36837, 34.2695], [-118.36848, 34.26953], [-118.36848, 34.26958], [-118.36851, 34.26964], [-118.36861, 34.26974], [-118.36871, 34.26981], [-118.36876, 34.26986], [-118.36881, 34.26999], [-118.36881, 34.27011], [-118.36878, 34.27038], [-118.36874, 34.27046], [-118.36868, 34.27055], [-118.36862, 34.27071], [-118.36862, 34.27081], [-118.36865, 34.27091], [-118.36873, 34.27105], [-118.3688, 34.27111], [-118.36919, 34.27127], [-118.36933, 34.27138]]]} | Open Access 1 | Orcas Gabrieleno Equestrian Park | 30958 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 17.355 | Orcas Gabrieleno Equestrian Park | ||
13494 | 13494 | 13493 | {"type": "Polygon", "coordinates": [[[-118.26938, 33.95566], [-118.26937, 33.95639], [-118.26526, 33.95641], [-118.26526, 33.95567], [-118.26938, 33.95566]]]} | Open Access 1 | Green Meadows Recreation Center | http://www.laparks.org/dos/reccenter/facility/greenMeadowsRC.htm | 30907 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 7.635 | Green Meadows Rec. Ctr. | |
13473 | 13473 | 13472 | {"type": "MultiPolygon", "coordinates": [[[[-118.5359, 34.18972], [-118.53552, 34.18962], [-118.53514, 34.1895], [-118.5345, 34.18923], [-118.53383, 34.18888], [-118.53017, 34.18682], [-118.53017, 34.18674], [-118.53582, 34.18674], [-118.53586, 34.18679], [-118.53586, 34.18957], [-118.5359, 34.18959], [-118.5359, 34.18972]]], [[[-118.5347, 34.19014], [-118.53177, 34.19015], [-118.53176, 34.18851], [-118.53371, 34.18959], [-118.53405, 34.18977], [-118.53405, 34.1898], [-118.5347, 34.19008], [-118.5347, 34.19014]]]]} | Open Access 1 | Reseda Park | http://www.laparks.org/dos/parks/facility/resedapk.htm | 30890 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 29.765 | Reseda Park | |
13380 | 13380 | 13379 | {"type": "Polygon", "coordinates": [[[-118.2415, 34.06352], [-118.24093, 34.0646], [-118.24034, 34.06439], [-118.24089, 34.06331], [-118.2415, 34.06352]]]} | Open Access 1 | Alpine Park and Recreation Center | http://www.laparks.org/dos/reccenter/facility/alpineRC.htm | 30744 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.936 | Alpine Park and Rec. Ctr. | |
13362 | 13362 | 13361 | {"type": "Polygon", "coordinates": [[[-118.24127, 33.93867], [-118.24126, 33.93886], [-118.24082, 33.93867], [-118.24091, 33.93867], [-118.24127, 33.93867]]]} | Open Access 1 | Watts Towers of Simon Rodia State Historic Park | 30713 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.109 | Watts Towers of Simon Rodia SHP | 1978 | |
13167 | 13167 | 13166 | {"type": "Polygon", "coordinates": [[[-118.30708, 34.09441], [-118.30692, 34.09441], [-118.30691, 34.094], [-118.30708, 34.094], [-118.30708, 34.09441]]]} | Open Access 1 | La Mirada Avenue Park | 32026 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.172 | La Mirada Avenue Park | ||
13158 | 13158 | 13157 | {"type": "Polygon", "coordinates": [[[-118.18582, 34.1138], [-118.18566, 34.11396], [-118.18558, 34.11393], [-118.18558, 34.11395], [-118.18563, 34.11399], [-118.18476, 34.11484], [-118.18453, 34.11494], [-118.18429, 34.11501], [-118.18404, 34.11507], [-118.18378, 34.1151], [-118.18338, 34.11496], [-118.18348, 34.11486], [-118.18355, 34.1147], [-118.18392, 34.11442], [-118.18404, 34.11403], [-118.1844, 34.11402], [-118.18582, 34.1138]]]} | Open Access 1 | Highland Park Adult Senior Citizen Center | 30450 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.717 | Highland Park Adult Senior Citizen Ctr. | ||
13101 | 13101 | 13100 | {"type": "MultiPolygon", "coordinates": [[[[-118.37695, 34.02689], [-118.37693, 34.02697], [-118.37689, 34.02697], [-118.37687, 34.027], [-118.37687, 34.02701], [-118.37669, 34.02746], [-118.37653, 34.0277], [-118.3764, 34.02785], [-118.37638, 34.0279], [-118.37635, 34.02789], [-118.37669, 34.027], [-118.37625, 34.02698], [-118.37626, 34.02689], [-118.37623, 34.02686], [-118.37627, 34.02684], [-118.37633, 34.02687], [-118.37672, 34.02687], [-118.37681, 34.02654], [-118.37689, 34.02614], [-118.37694, 34.02617], [-118.37688, 34.02654], [-118.37678, 34.02686], [-118.37692, 34.02687], [-118.37695, 34.02689]], [[-118.37686, 34.02701], [-118.37686, 34.02699], [-118.37674, 34.027], [-118.3765, 34.02763], [-118.37664, 34.02745], [-118.3768, 34.02705], [-118.37686, 34.02701]]], [[[-118.40076, 34.00143], [-118.40066, 34.00171], [-118.40048, 34.00221], [-118.40042, 34.00218], [-118.40059, 34.00164], [-118.40068, 34.00143], [-118.40076, 34.00143]]], [[[-118.40476, 33.9948], [-118.40448, 33.99506], [-118.40385, 33.99577], [-118.40371, 33.99594], [-118.403, 33.99677], [-118.40288, 33.99699], [-118.40277, 33.99766], [-118.40238, 33.99838], [-118.40239, 33.99842], [-118.4016, 33.9998], [-118.40152, 33.99976], [-118.40198, 33.99897], [-118.40221, 33.99864], [-118.40221, 33.99862], [-118.40137, 33.99966], [-118.40126, 33.99987], [-118.4012, 33.99986], [-118.40137, 33.99952], [-118.40229, 33.99834], [-118.40271, 33.99759], [-118.40282, 33.99697], [-118.40295, 33.99674], [-118.4036, 33.996], [-118.40378, 33.99575], [-118.40399, 33.99553], [-118.40442, 33.99499], [-118.4045, 33.99491], [-118.40476, 33.9948]]], [[[-118.43253, 33.97541], [-118.43245, 33.97547], [-118.4325, 33.97555], [-118.43243, 33.97558], [-118.4323, 33.9756], [-118.43172, 33.97596], [-118.43135, 33.97616], [-118.43008, 33.97693], [-118.42908, 33.97756], [-118.42733, 33.97874], [-118.42729, 33.97875], [-118.42705, 33.97891], [-118.4252, 33.98023], [-118.42496, 33.98044], [-118.42283, 33.98202], [-118.42282, 33.98204], [-118.42297, 33.98218], [-118.42288, 33.98224], [-118.42275, 33.9821], [-118.42269, 33.98213], [-118.41929, 33.9846], [-118.41722, 33.98613], [-118.41612, 33.98697], [-118.41605, 33.98692], [-118.41584, 33.98705], [-118.41533, 33.98744], [-118.41532, 33.98748], [-118.41257, 33.98955], [-118.4119, 33.98993], [-118.41174, 33.99009], [-118.4118, 33.99018], [-118.41172, 33.9902], [-118.40635, 33.99335], [-118.40617, 33.99349], [-118.40518, 33.99448], [-118.40502, 33.99457], [-118.405, 33.99449], [-118.40512, 33.99441], [-118.40631, 33.99332], [-118.41069, 33.99074], [-118.41186, 33.98988], [-118.41254, 33.98952], [-118.41525, 33.98747], [-118.41575, 33.98698], [-118.41597, 33.98684], [-118.41682, 33.98637], [-118.4172, 33.9861], [-118.42423, 33.98091], [-118.42423, 33.98089], [-118.42749, 33.97856], [-118.42905, 33.97752], [-118.43012, 33.97684], [-118.43162, 33.97594], [-118.4325, 33.97537], [-118.43253, 33.97541]]]]} | Open Access 1 | Ballona Creek Trail and Bike Path | 30330 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 7.147 | Ballona Creek Trail and Bike Path | ||
13086 | 13086 | 13085 | {"type": "Polygon", "coordinates": [[[-118.18472, 34.14368], [-118.1847, 34.14373], [-118.1843, 34.1441], [-118.18411, 34.14425], [-118.18398, 34.14441], [-118.18362, 34.14471], [-118.18336, 34.14452], [-118.18362, 34.14438], [-118.18361, 34.14434], [-118.1838, 34.14425], [-118.1839, 34.14415], [-118.18417, 34.14373], [-118.18417, 34.14368], [-118.18413, 34.14353], [-118.18414, 34.14341], [-118.18415, 34.14338], [-118.18422, 34.14338], [-118.18428, 34.14334], [-118.18431, 34.14328], [-118.18429, 34.14323], [-118.18433, 34.14321], [-118.18471, 34.14364], [-118.18472, 34.14368]]]} | Open Access 1 | Richard Alatorre Park | https://www.laparks.org/park/richard-alatorre | 31684 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.405 | Richard Alatorre Park | |
12780 | 12780 | 12779 | {"type": "Polygon", "coordinates": [[[-118.52909, 34.18524], [-118.52906, 34.18542], [-118.529, 34.18552], [-118.52891, 34.18561], [-118.52875, 34.18571], [-118.5286, 34.18575], [-118.52848, 34.18576], [-118.52829, 34.18574], [-118.52821, 34.18572], [-118.52783, 34.18552], [-118.52739, 34.18533], [-118.52739, 34.18524], [-118.52909, 34.18524]]]} | Open Access 1 | Caballero Creek Park | 29974 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.527 | Caballero Creek Park | ||
12779 | 12779 | 12778 | {"type": "Polygon", "coordinates": [[[-118.42237, 34.19409], [-118.42237, 34.19469], [-118.42212, 34.19469], [-118.42212, 34.19406], [-118.42231, 34.19406], [-118.42235, 34.19407], [-118.42237, 34.19409]]]} | Open Access 1 | Fulton Avenue Park | 29973 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.394 | Fulton Avenue Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);