units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 2016
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
200 | 200 | 199 | {"type": "Polygon", "coordinates": [[[-122.73156, 38.45287], [-122.73152, 38.45293], [-122.7309, 38.45305], [-122.73084, 38.45292], [-122.73075, 38.45281], [-122.73039, 38.4517], [-122.73106, 38.45137], [-122.73117, 38.4516], [-122.73156, 38.45287]]]} | Open Access 1 | 47323 | Finali Park | 31030 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | https://srcity.org/Facilities/Facility/Details/Finali-Park-66 | Sonoma 16 | 2.768 | Finali Park | 2016 | Local Park 2 | 4 |
4131 | 4131 | 4130 | {"type": "Polygon", "coordinates": [[[-118.54299, 34.19064], [-118.54284, 34.19074], [-118.54242, 34.19049], [-118.54196, 34.1903], [-118.54174, 34.19014], [-118.54291, 34.18966], [-118.54291, 34.19054], [-118.54299, 34.19064]]]} | Open Access 1 | 47400 | Los Angeles River and Aliso Creek Confluence Park | 31121 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.tpl.org/our-work/los-angeles-river-aliso-creek-confluence-project | Los Angeles 6 | 1.682 | Los Angeles River and Aliso Creek Confluence Park | 2016 | Local Park 2 | 4 |
4464 | 4464 | 4463 | {"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 | 46647 | Arts District Park | 32785 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.514 | Arts District Park | 2016 | Local Park 2 | 4 | |
4787 | 4787 | 4786 | {"type": "Polygon", "coordinates": [[[-120.86036, 37.48086], [-120.85915, 37.48087], [-120.85916, 37.48008], [-120.86035, 37.48008], [-120.86036, 37.48086]]]} | Open Access 1 | 48062 | Montana Park | 32554 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 2.273 | Montana Park | 2016 | Local Park 2 | 4 | |
5165 | 5165 | 5164 | {"type": "Polygon", "coordinates": [[[-122.35762, 38.40022], [-122.35748, 38.40034], [-122.3573, 38.40051], [-122.35739, 38.39999], [-122.3576, 38.39989], [-122.35762, 38.40022]]]} | Open Access 1 | 47672 | Oak Circle Neighborhood Park | 31413 | 1385 | Yountville, Town of 730 | City 2 | City Agency 2 | http://www.townofyountville.com/index.aspx?page=88 | City 2 | 1385 | Yountville, Town of 714 | City 2 | City Agency 2 | Napa 11 | 0.249 | Oak Circle Neighborhood Park | 2016 | Local Park 2 | 4 | |
6258 | 6258 | 6257 | {"type": "Polygon", "coordinates": [[[-119.18952, 34.19789], [-119.18952, 34.19806], [-119.18886, 34.19806], [-119.18888, 34.19845], [-119.18803, 34.19844], [-119.18803, 34.19787], [-119.18952, 34.19789]]]} | Open Access 1 | 48414 | Campus Park Dog Park | 33011 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/dog-park-opening/ | Ventura 8 | 1.496 | Campus Park Dog Park | 2016 | Local Park 2 | 4 |
7829 | 7829 | 7828 | {"type": "Polygon", "coordinates": [[[-122.50267, 37.76171], [-122.50184, 37.76175], [-122.50179, 37.76106], [-122.50262, 37.76102], [-122.50267, 37.76171]]]} | Open Access 1 | 47708 | Playland at 43rd Avenue | 31457 | 2414 | San Francisco Unified School District 881 | Special District 4 | School District 14 | http://www.sfusd.edu/ | Special District 4 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.382 | Playland at 43rd Avenue | 2016 | None 654 | ||
9629 | 9629 | 9628 | {"type": "Polygon", "coordinates": [[[-118.00178, 34.13276], [-118.00168, 34.13302], [-118.00144, 34.13297], [-118.00143, 34.13326], [-118.00096, 34.13325], [-118.00096, 34.13303], [-118.00094, 34.13296], [-118.00095, 34.13262], [-118.00102, 34.13264], [-118.00103, 34.13262], [-118.00163, 34.13273], [-118.00164, 34.13272], [-118.00178, 34.13276]]]} | Open Access 1 | 47851 | Station Square Park | 31797 | 1209 | Monrovia, City of 312 | City 2 | City Agency 2 | http://www.cityofmonrovia.org/publicworks/page/parks | City 2 | 1209 | Monrovia, City of 309 | City 2 | City Agency 2 | https://www.cityofmonrovia.org/Home/Components/FacilityDirectory/FacilityDirectory/16/787 | Los Angeles 6 | 0.95 | Station Square Park | 2016 | Local Park 2 | 4 |
11432 | 11432 | 11431 | {"type": "Polygon", "coordinates": [[[-118.19075, 33.79976], [-118.19062, 33.79976], [-118.19062, 33.79951], [-118.19075, 33.79951], [-118.19075, 33.79976]]]} | Open Access 1 | 48115 | Locust Tot Lot | 32630 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/park-and-facilities/directory/locust-tot-lot/ | Los Angeles 6 | 0.085 | Locust Tot Lot | 2016 | Local Recreation Area 3 | 4 |
15322 | 15322 | 15321 | {"type": "Polygon", "coordinates": [[[-117.84833, 33.96677], [-117.84766, 33.96715], [-117.84745, 33.96733], [-117.84713, 33.96767], [-117.84701, 33.96771], [-117.84699, 33.96774], [-117.8468, 33.96774], [-117.8468, 33.96772], [-117.84666, 33.96772], [-117.84618, 33.96778], [-117.84613, 33.96766], [-117.84619, 33.96762], [-117.8462, 33.96756], [-117.84623, 33.96755], [-117.84629, 33.96747], [-117.84634, 33.96746], [-117.84671, 33.96683], [-117.84686, 33.96663], [-117.84697, 33.96655], [-117.84715, 33.9665], [-117.84727, 33.96651], [-117.8473, 33.96648], [-117.84718, 33.96644], [-117.84698, 33.96642], [-117.84673, 33.96634], [-117.84665, 33.96633], [-117.84658, 33.96626], [-117.84648, 33.96621], [-117.84643, 33.96629], [-117.84617, 33.96619], [-117.8459, 33.96634], [-117.84585, 33.96623], [-117.8458, 33.96617], [-117.84555, 33.96607], [-117.8453, 33.96591], [-117.84508, 33.96583], [-117.84502, 33.96576], [-117.84498, 33.96566], [-117.84502, 33.9657], [-117.84507, 33.96572], [-117.84518, 33.96571], [-117.8469, 33.96621], [-117.84705, 33.96627], [-117.84764, 33.96656], [-117.8478, 33.96635], [-117.84796, 33.96641], [-117.84817, 33.96659], [-117.84814, 33.96665], [-117.84815, 33.96671], [-117.84818, 33.96673], [-117.84826, 33.96675], [-117.84831, 33.96674], [-117.84833, 33.96677]]]} | Open Access 1 | 46486 | Diamond Canyon Park | 31870 | 1085 | Diamond Bar, City of 315 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | Los Angeles 6 | 4.985 | Diamond Canyon Park | 2016 | Local Park 2 | 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]);