superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
465 rows where MNG_AGENCY = 24 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
ACCESS_TYP 4
- Open Access 431
- Restricted Access 20
- No Public Access 11
- Unknown Access 3
MNG_AG_TYP 1
- City Agency 465
MNG_AGENCY 1
- Los Angeles, City of · 465 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6667 | 6667 | 6666 | {"type": "Polygon", "coordinates": [[[-118.2864, 33.75129], [-118.28462, 33.75194], [-118.28435, 33.752], [-118.28352, 33.752], [-118.2833, 33.75197], [-118.28308, 33.75187], [-118.28289, 33.75176], [-118.28268, 33.75159], [-118.28261, 33.75149], [-118.28262, 33.75146], [-118.28264, 33.75144], [-118.28298, 33.7514], [-118.2831, 33.75136], [-118.28316, 33.7513], [-118.28341, 33.75078], [-118.28377, 33.75022], [-118.28384, 33.75016], [-118.28393, 33.75013], [-118.28408, 33.75009], [-118.28424, 33.75007], [-118.28446, 33.75007], [-118.28446, 33.75089], [-118.28451, 33.75102], [-118.2846, 33.75111], [-118.28464, 33.75114], [-118.28476, 33.75119], [-118.28491, 33.75118], [-118.28611, 33.75074], [-118.2864, 33.75129]]]} | Open Access 1 | Knoll Hill Little League | 33648 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 8.901 | Knoll Hill Little League | ||
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 | ||
14612 | 14612 | 14611 | {"type": "Polygon", "coordinates": [[[-118.41888, 34.04508], [-118.41072, 34.04979], [-118.41066, 34.0498], [-118.41063, 34.04978], [-118.40947, 34.04839], [-118.41012, 34.04771], [-118.41049, 34.04727], [-118.41122, 34.04639], [-118.41134, 34.0462], [-118.4122, 34.04566], [-118.41232, 34.04557], [-118.4123, 34.04532], [-118.41195, 34.04482], [-118.4113, 34.04507], [-118.41049, 34.04518], [-118.41007, 34.0452], [-118.40951, 34.04518], [-118.40863, 34.04405], [-118.40825, 34.04398], [-118.40772, 34.04398], [-118.40754, 34.04391], [-118.40691, 34.04308], [-118.41032, 34.04122], [-118.41045, 34.04125], [-118.41408, 34.03927], [-118.41888, 34.04508]]]} | Restricted Access 2 | Rancho Park Municipal Golf Course | 33107 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 148.463 | Rancho Park Municipal GC | ||
13782 | 13782 | 13781 | {"type": "Polygon", "coordinates": [[[-118.4901, 34.19376], [-118.49007, 34.19379], [-118.48693, 34.19379], [-118.48692, 34.19036], [-118.48707, 34.19038], [-118.48713, 34.19038], [-118.4872, 34.19034], [-118.48722, 34.19027], [-118.48719, 34.19021], [-118.48713, 34.19017], [-118.48706, 34.19016], [-118.48692, 34.19019], [-118.48692, 34.18927], [-118.48706, 34.1893], [-118.48712, 34.18929], [-118.48719, 34.18925], [-118.48722, 34.18919], [-118.48719, 34.18912], [-118.48712, 34.18908], [-118.48683, 34.1891], [-118.48683, 34.18847], [-118.48697, 34.18851], [-118.48703, 34.1885], [-118.4871, 34.18846], [-118.48713, 34.18839], [-118.48709, 34.18832], [-118.48703, 34.18829], [-118.48696, 34.18829], [-118.48683, 34.18832], [-118.48683, 34.18769], [-118.48697, 34.18773], [-118.48704, 34.18772], [-118.4871, 34.18768], [-118.48713, 34.18761], [-118.4871, 34.18755], [-118.48702, 34.18751], [-118.48697, 34.18751], [-118.48683, 34.18754], [-118.48683, 34.18723], [-118.48687, 34.18724], [-118.4869, 34.18728], [-118.48695, 34.18728], [-118.48696, 34.18713], [-118.4869, 34.18712], [-118.48685, 34.18717], [-118.48675, 34.18717], [-118.48675, 34.18678], [-118.49004, 34.18677], [-118.49009, 34.1868], [-118.4901, 34.19376]]]} | Restricted Access 2 | Van Nuys Golf Course | http://lacity.org/ | 33076 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 56.264 | Van Nuys GC | |
5977 | 5977 | 5976 | {"type": "Polygon", "coordinates": [[[-118.41363, 33.95967], [-118.40927, 33.95968], [-118.40927, 33.95722], [-118.40942, 33.95725], [-118.40951, 33.95722], [-118.40956, 33.95713], [-118.40956, 33.95708], [-118.40953, 33.95704], [-118.40948, 33.957], [-118.40942, 33.95699], [-118.40928, 33.95702], [-118.4057, 33.95703], [-118.40454, 33.95711], [-118.4045, 33.95706], [-118.4045, 33.95483], [-118.40456, 33.95479], [-118.41077, 33.95416], [-118.41233, 33.95399], [-118.41264, 33.95412], [-118.41314, 33.95437], [-118.41362, 33.95468], [-118.41363, 33.95967]]]} | Restricted Access 2 | Westchester Golf Course | http://lacity.org/ | 33047 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 90.2 | Westchester GC | |
14586 | 14586 | 14585 | {"type": "Polygon", "coordinates": [[[-118.4665, 34.00437], [-118.46104, 34.00726], [-118.46085, 34.00736], [-118.46087, 34.00741], [-118.45724, 34.00933], [-118.45601, 34.00775], [-118.46158, 34.00479], [-118.46158, 34.00478], [-118.46148, 34.00472], [-118.46244, 34.00421], [-118.46252, 34.00428], [-118.46267, 34.00422], [-118.46531, 34.00282], [-118.4665, 34.00437]]]} | Restricted Access 2 | Penmar Golf Course | 33009 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 52.138 | Penmar GC | ||
4294 | 4294 | 4293 | {"type": "Polygon", "coordinates": [[[-118.43139, 34.07349], [-118.43133, 34.0739], [-118.43131, 34.07413], [-118.43128, 34.07416], [-118.43123, 34.07417], [-118.4312, 34.07415], [-118.43081, 34.0738], [-118.4306, 34.07366], [-118.4303, 34.07352], [-118.42983, 34.0734], [-118.42965, 34.0733], [-118.4295, 34.07319], [-118.42916, 34.07276], [-118.42892, 34.07255], [-118.42767, 34.07171], [-118.42764, 34.07166], [-118.42764, 34.0716], [-118.4278, 34.0712], [-118.42784, 34.07119], [-118.42921, 34.07171], [-118.42952, 34.07187], [-118.42979, 34.07208], [-118.43009, 34.07242], [-118.43027, 34.0726], [-118.43138, 34.07347], [-118.43139, 34.07349]]]} | Restricted Access 2 | Holmby Park | 32999 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 8.535 | Holmby Park | ||
902 | 902 | 901 | {"type": "Polygon", "coordinates": [[[-118.2356, 34.04165], [-118.23514, 34.0417], [-118.23507, 34.04127], [-118.23553, 34.04121], [-118.2356, 34.04165]]]} | Open Access 1 | Arts District Park | 32785 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.514 | Arts District Park | 2016 | |
870 | 870 | 869 | {"type": "Polygon", "coordinates": [[[-118.4065, 34.23117], [-118.4061, 34.23146], [-118.40628, 34.23165], [-118.40483, 34.23133], [-118.40587, 34.23057], [-118.4065, 34.23117]]]} | Open Access 1 | Sheldon Skate Park | 32744 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.191 | Sheldon Skate Park | ||
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 | |
631 | 631 | 630 | {"type": "Polygon", "coordinates": [[[-118.20749, 34.12111], [-118.2074, 34.12143], [-118.20711, 34.12138], [-118.20707, 34.12135], [-118.20707, 34.12132], [-118.20714, 34.12105], [-118.20749, 34.12111]]]} | Open Access 1 | York Boulevard Pocket Park | https://www.laparks.org/park/york-boulevard-park | 32599 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.293 | York Boulevard PP | |
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 |
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 |
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 | ||
308 | 308 | 307 | {"type": "Polygon", "coordinates": [[[-118.50705, 34.19144], [-118.50564, 34.19144], [-118.5056, 34.19012], [-118.50703, 34.19012], [-118.50705, 34.19144]]]} | Restricted Access 2 | Birmingham High School Park | 31941 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 4.739 | Birmingham High School Park | ||
307 | 307 | 306 | {"type": "Polygon", "coordinates": [[[-118.2635, 34.06257], [-118.26306, 34.06324], [-118.26301, 34.06325], [-118.26135, 34.0625], [-118.2617, 34.06184], [-118.2635, 34.06257]]]} | Restricted Access 2 | Belmont High School Park | 31940 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.75 | Belmont High School Park | ||
22 | 22 | 21 | {"type": "Polygon", "coordinates": [[[-118.20225, 34.07513], [-118.20167, 34.07513], [-118.20166, 34.07528], [-118.20122, 34.07529], [-118.20119, 34.07523], [-118.20091, 34.07524], [-118.20089, 34.07513], [-118.2003, 34.07515], [-118.20011, 34.07437], [-118.20176, 34.07436], [-118.20178, 34.07497], [-118.20225, 34.07497], [-118.20225, 34.07513]]]} | Restricted Access 2 | Abraham Lincoln High School Park | 31843 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.473 | Abraham Lincoln High School Park | ||
14209 | 14209 | 14208 | {"type": "Polygon", "coordinates": [[[-118.24174, 34.10058], [-118.2408, 34.10067], [-118.24073, 34.10141], [-118.24026, 34.10153], [-118.24008, 34.10105], [-118.23989, 34.10064], [-118.23963, 34.1002], [-118.2394, 34.09986], [-118.23909, 34.09947], [-118.23674, 34.09668], [-118.23649, 34.09643], [-118.23621, 34.09616], [-118.23573, 34.09577], [-118.2354, 34.09553], [-118.23528, 34.09552], [-118.2349, 34.09526], [-118.23451, 34.09501], [-118.23528, 34.09444], [-118.23594, 34.09452], [-118.23634, 34.09459], [-118.23672, 34.09469], [-118.2371, 34.09481], [-118.23746, 34.09495], [-118.238, 34.09522], [-118.23834, 34.09543], [-118.23864, 34.09566], [-118.23904, 34.09601], [-118.23927, 34.09626], [-118.23949, 34.09652], [-118.24137, 34.09927], [-118.24154, 34.0996], [-118.24166, 34.09996], [-118.24173, 34.10033], [-118.24174, 34.10058]]]} | No Public Access 3 | G2 Parcel | 31694 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 41.844 | G2 Parcel |
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]);