superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where MNG_AG_TYP = 2 and YR_EST = 2014
This data as json, copyable, CSV (advanced)
Suggested facets: LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1234 | 1234 | 1233 | {"type": "Polygon", "coordinates": [[[-121.86113, 37.71247], [-121.8611, 37.7125], [-121.86104, 37.71252], [-121.86002, 37.71261], [-121.85976, 37.71089], [-121.86027, 37.71076], [-121.86054, 37.71074], [-121.86081, 37.71062], [-121.86088, 37.71077], [-121.86094, 37.71101], [-121.86113, 37.71243], [-121.86113, 37.71247]]]} | Open Access 1 | Passatempo Park | https://www.dublin.ca.gov/Facilities/Facility/Details/Passatempo-Park-26 | 32913 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 5.009 | Passatempo Park | 2014 |
2294 | 2294 | 2293 | {"type": "Polygon", "coordinates": [[[-117.65864, 33.66425], [-117.65843, 33.66496], [-117.65853, 33.665], [-117.65847, 33.66516], [-117.65837, 33.66515], [-117.65817, 33.66558], [-117.65756, 33.66544], [-117.65723, 33.66615], [-117.65658, 33.66736], [-117.65606, 33.66707], [-117.65557, 33.66674], [-117.65503, 33.6663], [-117.65502, 33.66621], [-117.65489, 33.66611], [-117.65478, 33.6661], [-117.65431, 33.66572], [-117.65377, 33.66536], [-117.65339, 33.66514], [-117.65288, 33.6649], [-117.65284, 33.66481], [-117.653, 33.66444], [-117.65313, 33.66407], [-117.65324, 33.6637], [-117.65332, 33.66332], [-117.65343, 33.66343], [-117.65379, 33.66356], [-117.65403, 33.66361], [-117.65418, 33.66354], [-117.65435, 33.6635], [-117.65449, 33.66343], [-117.65459, 33.66335], [-117.65479, 33.66312], [-117.65494, 33.66283], [-117.65495, 33.66247], [-117.65501, 33.66234], [-117.6551, 33.66185], [-117.65509, 33.6618], [-117.65506, 33.66176], [-117.65498, 33.66171], [-117.65485, 33.66168], [-117.65482, 33.66164], [-117.65481, 33.66159], [-117.65484, 33.66155], [-117.65505, 33.66138], [-117.65531, 33.66114], [-117.65554, 33.66104], [-117.65564, 33.66109], [-117.65573, 33.66102], [-117.6557, 33.66098], [-117.65577, 33.66093], [-117.65583, 33.66087], [-117.65588, 33.66078], [-117.65588, 33.66072], [-117.65586, 33.66069], [-117.65579, 33.66063], [-117.65559, 33.66053], [-117.65557, 33.66048], [-117.65568, 33.66038], [-117.65632, 33.66031], [-117.65652, 33.66013], [-117.65669, 33.66003], [-117.65696, 33.65992], [-117.65716, 33.65989], [-117.65736, 33.65988], [-117.65765, 33.65991], [-117.65784, 33.65997], [-117.65802, 33.66005], [-117.65859, 33.66037], [-117.65923, 33.66092], [-117.65931, 33.66101], [-117.65937, 33.66111], [-117.6594, 33.66122], [-117.6594, 33.66134], [-117.65934, 33.66151], [-117.65819, 33.66297], [-117.65793, 33.66386], [-117.65794, 33.66387], [-117.65837, 33.66381], [-117.65835, 33.66409], [-117.65864, 33.66425]]]} | Open Access 1 | Lake Forest Sports Park | http://lfsportspark.com/ | 32259 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 66.115 | Lake Forest Sports Park | 2014 |
12335 | 12335 | 12334 | {"type": "Polygon", "coordinates": [[[-121.30121, 37.826], [-121.30039, 37.8261], [-121.29978, 37.82615], [-121.2988, 37.82617], [-121.29874, 37.82611], [-121.29874, 37.82524], [-121.29879, 37.82509], [-121.29878, 37.82501], [-121.29874, 37.82497], [-121.29934, 37.82496], [-121.29995, 37.82493], [-121.30093, 37.82482], [-121.30121, 37.826]]]} | Open Access 1 | Lathrop Generations Center | http://www.kla-ca.com/portfolio/lathrop-generations-center/ | 32370 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 6.76 | Lathrop Generations Ctr. | 2014 |
12708 | 12708 | 12707 | {"type": "Polygon", "coordinates": [[[-117.17031, 33.14175], [-117.1696, 33.14194], [-117.16948, 33.14144], [-117.1694, 33.14144], [-117.16914, 33.14076], [-117.16876, 33.14084], [-117.16851, 33.14017], [-117.16966, 33.13987], [-117.17001, 33.14078], [-117.16995, 33.14082], [-117.17031, 33.14175]]]} | Open Access 1 | Connors Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/151/1081 | 31392 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 4.594 | Connors Park | 2014 |
12738 | 12738 | 12737 | {"type": "Polygon", "coordinates": [[[-118.20264, 33.82045], [-118.20248, 33.82045], [-118.20153, 33.81926], [-118.20157, 33.81922], [-118.2021, 33.81932], [-118.20229, 33.81937], [-118.20231, 33.81941], [-118.20247, 33.81946], [-118.20248, 33.81943], [-118.20264, 33.81948], [-118.20264, 33.82045]]]} | Open Access 1 | Wrigley Heights Dog Park | 29932 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.703 | Wrigley Heights Dog Park | 2014 | |
12756 | 12756 | 12755 | {"type": "Polygon", "coordinates": [[[-118.17189, 33.79348], [-118.17189, 33.79369], [-118.17147, 33.79396], [-118.17068, 33.79345], [-118.17083, 33.79329], [-118.17083, 33.79327], [-118.16931, 33.79229], [-118.16929, 33.79021], [-118.17188, 33.79021], [-118.17189, 33.79321], [-118.17163, 33.79322], [-118.17163, 33.79346], [-118.17189, 33.79348]]]} | Open Access 1 | Chittick Field | 29942 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 19.456 | Chittick Field | 2014 | |
12758 | 12758 | 12757 | {"type": "Polygon", "coordinates": [[[-118.17117, 33.79377], [-118.1707, 33.79377], [-118.1707, 33.79348], [-118.17072, 33.79348], [-118.17117, 33.79377]]]} | No Public Access 3 | Chittick Field | 29944 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.181 | Chittick Field | 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 |
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 |
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]);