superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
171 rows where MNG_AGENCY = 16 and MNG_AG_LEV = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12057 | 12057 | 12056 | {"type": "Polygon", "coordinates": [[[-118.23999, 33.92472], [-118.23998, 33.92479], [-118.23922, 33.9248], [-118.23925, 33.92475], [-118.2393, 33.92473], [-118.23999, 33.92472]]]} | Open Access 1 | Martin Luther King Jr. Fitness Garden | http://parks.lacounty.gov/wps/portal/dpr/Parks/Martin_Luther_King_Jr_Fitness_Park | 28949 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.133 | Martin Luther King Jr. Fitness Garden | |
12026 | 12026 | 12025 | {"type": "MultiPolygon", "coordinates": [[[[-118.15919, 34.01886], [-118.15904, 34.01936], [-118.15896, 34.01951], [-118.15899, 34.0193], [-118.15913, 34.01885], [-118.15916, 34.01883], [-118.15918, 34.01884], [-118.15919, 34.01886]]], [[[-118.15947, 34.01784], [-118.15947, 34.01795], [-118.15928, 34.01858], [-118.15923, 34.0186], [-118.15921, 34.01856], [-118.1594, 34.01795], [-118.15947, 34.01784]]]]} | Open Access 1 | Woods Avenue Park | http://parks.lacounty.gov/wps/portal/dpr/Parks/Woods_Avenue_Park | 28914 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.218 | Woods Avenue Park | |
12016 | 12016 | 12015 | {"type": "Polygon", "coordinates": [[[-117.8205, 34.09105], [-117.82051, 34.09113], [-117.82049, 34.09123], [-117.82036, 34.09135], [-117.82033, 34.09142], [-117.82026, 34.09145], [-117.82024, 34.09087], [-117.82037, 34.09095], [-117.8205, 34.09105]]]} | Open Access 1 | San Dimas Staging Area | http://parks.lacounty.gov/wps/portal/dpr/Parks/San_Dimas_Staging_Area | 28895 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.247 | San Dimas Staging Area | |
6633 | 6633 | 6632 | {"type": "Polygon", "coordinates": [[[-118.45957, 33.97626], [-118.45923, 33.97627], [-118.4592, 33.97624], [-118.4591, 33.97585], [-118.45895, 33.97554], [-118.45957, 33.97626]]]} | Open Access 1 | Marina del Rey pocket park | 21821 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.299 | Marina del Rey pocket park | ||
12025 | 12025 | 12024 | {"type": "Polygon", "coordinates": [[[-118.19408, 33.89118], [-118.19324, 33.89119], [-118.19323, 33.89102], [-118.19407, 33.89102], [-118.19408, 33.89118]]]} | Unknown Access 4 | Washington Ave Park | 28912 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.359 | Washington Ave Park | ||
6379 | 6379 | 6378 | {"type": "Polygon", "coordinates": [[[-118.63309, 34.12589], [-118.63308, 34.12624], [-118.63243, 34.12624], [-118.63244, 34.12598], [-118.63309, 34.12589]]]} | Open Access 1 | Los Angeles holding 5 | 21492 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.502 | Los Angeles holding 5 | ||
11742 | 11742 | 11741 | {"type": "Polygon", "coordinates": [[[-118.24398, 33.98243], [-118.24382, 33.9825], [-118.24369, 33.9826], [-118.24358, 33.98273], [-118.24352, 33.98286], [-118.24352, 33.98212], [-118.24397, 33.98212], [-118.24398, 33.98243]]]} | Open Access 1 | El Parque Nuestro | http://parks.lacounty.gov/wps/portal/dpr/Parks/El_Parque_Nuestro | 28364 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.536 | El Parque Nuestro | |
6407 | 6407 | 6406 | {"type": "Polygon", "coordinates": [[[-118.16406, 34.20859], [-118.16399, 34.20877], [-118.16379, 34.20908], [-118.16333, 34.20952], [-118.16322, 34.20967], [-118.16298, 34.20963], [-118.16307, 34.20948], [-118.16318, 34.20935], [-118.16368, 34.20899], [-118.16383, 34.20886], [-118.16406, 34.20859]]]} | Open Access 1 | Los Angeles holding 11 | 21486 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.54 | Los Angeles holding 11 | ||
5319 | 5319 | 5318 | {"type": "Polygon", "coordinates": [[[-118.60165, 34.05301], [-118.60165, 34.05347], [-118.60118, 34.05348], [-118.60118, 34.05301], [-118.60165, 34.05301]]]} | No Public Access 3 | Los Angeles County Open Space | 21480 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.547 | Los Angeles County OS | ||
14773 | 14773 | 14772 | {"type": "Polygon", "coordinates": [[[-118.60408, 34.12532], [-118.60355, 34.12532], [-118.60343, 34.12511], [-118.60323, 34.12504], [-118.60322, 34.12533], [-118.60305, 34.12533], [-118.60304, 34.12497], [-118.60288, 34.12491], [-118.6019, 34.12492], [-118.6019, 34.12487], [-118.60222, 34.12486], [-118.60221, 34.12436], [-118.60228, 34.12438], [-118.6023, 34.12486], [-118.60291, 34.12486], [-118.60349, 34.12507], [-118.6036, 34.12527], [-118.60408, 34.12526], [-118.60408, 34.12532]]]} | Open Access 1 | Canyon Oaks Open Space Access | 16820 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.586 | Canyon Oaks OS Access | ||
6857 | 6857 | 6856 | {"type": "Polygon", "coordinates": [[[-118.05463, 33.98259], [-118.05463, 33.98262], [-118.05459, 33.98263], [-118.05399, 33.98263], [-118.0539, 33.9826], [-118.05387, 33.98256], [-118.05386, 33.98251], [-118.05397, 33.98223], [-118.05403, 33.98219], [-118.05411, 33.98218], [-118.05417, 33.9822], [-118.05456, 33.98246], [-118.05462, 33.98252], [-118.05463, 33.98259]]]} | Open Access 1 | McNees Park | 22064 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.604 | McNees Park | ||
12102 | 12102 | 12101 | {"type": "Polygon", "coordinates": [[[-118.33769, 33.99873], [-118.33749, 33.99926], [-118.33744, 33.99931], [-118.33736, 33.99931], [-118.33691, 33.99912], [-118.33688, 33.99909], [-118.3369, 33.99905], [-118.33762, 33.99869], [-118.33767, 33.99869], [-118.33769, 33.99873]]]} | Open Access 1 | Monteith Parkway | 29043 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.64 | Monteith Parkway | ||
4669 | 4669 | 4668 | {"type": "Polygon", "coordinates": [[[-118.50387, 34.02695], [-118.50386, 34.02706], [-118.5038, 34.02717], [-118.50371, 34.02726], [-118.5036, 34.02732], [-118.50347, 34.02736], [-118.50337, 34.02737], [-118.50327, 34.02733], [-118.50321, 34.02727], [-118.50319, 34.02722], [-118.5032, 34.02716], [-118.50325, 34.02704], [-118.50335, 34.02693], [-118.50346, 34.02686], [-118.50361, 34.02682], [-118.50373, 34.02681], [-118.50382, 34.02686], [-118.50387, 34.02695]]]} | Open Access 1 | Goose Egg Park | 19406 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.674 | Goose Egg Park | ||
12018 | 12018 | 12017 | {"type": "Polygon", "coordinates": [[[-118.11482, 34.19575], [-118.11463, 34.19638], [-118.11441, 34.19634], [-118.11429, 34.1954], [-118.11451, 34.19531], [-118.11449, 34.19545], [-118.11455, 34.19559], [-118.11466, 34.19569], [-118.11471, 34.19569], [-118.11482, 34.19575]]]} | No Public Access 3 | Casa Del Caballero | 28900 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.819 | Casa Del Caballero | ||
1249 | 1249 | 1248 | {"type": "Polygon", "coordinates": [[[-118.45619, 33.96552], [-118.45317, 33.967], [-118.45309, 33.9669], [-118.45614, 33.96543], [-118.45619, 33.96552]]]} | Open Access 1 | Aubrey E. Austin Jr. Park and North Jetty | https://beaches.lacounty.gov/?s=Aubrey+E.+Austin+Jr.+Park+and+North+Jetty | 15682 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.965 | Aubrey E. Austin Jr. Park and North Jetty | |
6382 | 6382 | 6381 | {"type": "Polygon", "coordinates": [[[-118.60788, 34.06942], [-118.60718, 34.06977], [-118.60688, 34.06935], [-118.60758, 34.069], [-118.60788, 34.06942]]]} | Open Access 1 | Los Angeles holding 8 | 21495 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1.023 | Los Angeles holding 8 | ||
6405 | 6405 | 6404 | {"type": "Polygon", "coordinates": [[[-118.61573, 34.06931], [-118.61507, 34.06932], [-118.61506, 34.06843], [-118.61534, 34.06856], [-118.6155, 34.0687], [-118.61554, 34.06878], [-118.61559, 34.06896], [-118.61573, 34.06931]]]} | Open Access 1 | Los Angeles holding 10 | 21485 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1.032 | Los Angeles holding 10 | ||
14338 | 14338 | 14337 | {"type": "Polygon", "coordinates": [[[-118.63997, 34.08326], [-118.63997, 34.08356], [-118.63947, 34.08386], [-118.6392, 34.08385], [-118.63897, 34.08343], [-118.63935, 34.08326], [-118.63997, 34.08326]]]} | No Public Access 3 | Unnamed site - Los Angeles County Waterworks | 30320 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1.128 | |||
12021 | 12021 | 12020 | {"type": "MultiPolygon", "coordinates": [[[[-118.18119, 34.01648], [-118.18066, 34.01648], [-118.18065, 34.01554], [-118.18118, 34.01554], [-118.18119, 34.01648]]], [[[-118.1819, 34.01593], [-118.18139, 34.01594], [-118.18139, 34.01566], [-118.1819, 34.01566], [-118.1819, 34.01593]]]]} | Open Access 1 | Parque de los Suenos | http://parks.lacounty.gov/wps/portal/dpr/Parks/Parque_de_los_Suenos | 28908 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1.609 | Parque de los Suenos | |
6381 | 6381 | 6380 | {"type": "Polygon", "coordinates": [[[-118.16322, 34.20967], [-118.16308, 34.21031], [-118.16183, 34.21032], [-118.1618, 34.20908], [-118.16226, 34.2091], [-118.16218, 34.20921], [-118.16211, 34.20936], [-118.16205, 34.20958], [-118.16203, 34.20973], [-118.16203, 34.21], [-118.16209, 34.2101], [-118.1622, 34.21018], [-118.16229, 34.2102], [-118.1624, 34.2102], [-118.16254, 34.21014], [-118.16284, 34.20986], [-118.16294, 34.20972], [-118.16298, 34.20963], [-118.16322, 34.20967]]]} | Open Access 1 | Los Angeles holding 7 | 21494 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1.731 | Los Angeles holding 7 |
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]);