superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 2 and MNG_AGENCY = 294
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11644 | 11644 | 11643 | {"type": "MultiPolygon", "coordinates": [[[[-118.13501, 33.77369], [-118.13477, 33.7743], [-118.13469, 33.77462], [-118.13464, 33.77502], [-118.13454, 33.77499], [-118.1345, 33.77494], [-118.13435, 33.77492], [-118.13433, 33.77494], [-118.13425, 33.77511], [-118.13425, 33.77522], [-118.12861, 33.77521], [-118.12861, 33.77359], [-118.13184, 33.77359], [-118.13186, 33.77356], [-118.13486, 33.77356], [-118.13498, 33.77362], [-118.13501, 33.77369]]], [[[-118.13709, 33.77258], [-118.13709, 33.77342], [-118.13549, 33.77344], [-118.13549, 33.77345], [-118.13554, 33.77351], [-118.13295, 33.77351], [-118.13294, 33.77344], [-118.13291, 33.77343], [-118.13288, 33.77266], [-118.13278, 33.77231], [-118.13275, 33.77212], [-118.13276, 33.7719], [-118.1328, 33.7718], [-118.13288, 33.77168], [-118.13298, 33.77163], [-118.13306, 33.77162], [-118.13502, 33.77188], [-118.13513, 33.77204], [-118.13533, 33.77205], [-118.13573, 33.7722], [-118.1358, 33.77229], [-118.13586, 33.77253], [-118.13593, 33.77262], [-118.13602, 33.7727], [-118.13612, 33.77274], [-118.13623, 33.77276], [-118.13634, 33.77276], [-118.13644, 33.77273], [-118.13657, 33.77265], [-118.13666, 33.77253], [-118.13709, 33.77258]]]]} | Restricted Access 2 | Recreation 9 Hole Golf Course | http://www.recpark9.com/ | 33115 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 40.595 | Rec. 9 Hole GC | |
12062 | 12062 | 12061 | {"type": "Polygon", "coordinates": [[[-118.19716, 33.76369], [-118.19705, 33.76402], [-118.19697, 33.76419], [-118.19684, 33.7644], [-118.19667, 33.76459], [-118.19658, 33.76458], [-118.19607, 33.76429], [-118.19559, 33.76406], [-118.19599, 33.76353], [-118.19603, 33.76342], [-118.19603, 33.76328], [-118.19614, 33.76327], [-118.19626, 33.76322], [-118.19631, 33.76322], [-118.19716, 33.76369]]]} | Restricted Access 2 | Long Beach Aquarium of the Pacific | 28978 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 3.167 | Long Beach Aquarium of the Pacific | ||
13566 | 13566 | 13565 | {"type": "Polygon", "coordinates": [[[-118.17797, 33.79308], [-118.17745, 33.79307], [-118.17745, 33.79266], [-118.17796, 33.79266], [-118.17797, 33.79275], [-118.17797, 33.79308]]]} | Restricted Access 2 | Martin Luther King Jr. Park | 32772 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.547 | Martin Luther King Jr. Park | ||
13720 | 13720 | 13719 | {"type": "Polygon", "coordinates": [[[-118.10763, 33.83029], [-118.10763, 33.83204], [-118.10759, 33.8321], [-118.09924, 33.83206], [-118.09919, 33.83205], [-118.09916, 33.83201], [-118.09956, 33.8307], [-118.09974, 33.83027], [-118.10362, 33.83028], [-118.10363, 33.83055], [-118.10506, 33.83056], [-118.10508, 33.83028], [-118.10763, 33.83029]]]} | Restricted Access 2 | Heartwell Golf Course | 33019 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 36.519 | Heartwell GC | ||
14563 | 14563 | 14562 | {"type": "MultiPolygon", "coordinates": [[[[-118.14175, 33.82338], [-118.13512, 33.82334], [-118.13509, 33.82283], [-118.13466, 33.82244], [-118.13408, 33.82244], [-118.13409, 33.81902], [-118.13416, 33.81896], [-118.13886, 33.81895], [-118.139, 33.81906], [-118.1391, 33.81948], [-118.13924, 33.81986], [-118.13935, 33.82009], [-118.13975, 33.82078], [-118.13995, 33.82107], [-118.14019, 33.82137], [-118.14125, 33.82253], [-118.14146, 33.82291], [-118.14163, 33.82315], [-118.14164, 33.82325], [-118.14169, 33.82326], [-118.14175, 33.82338]]], [[[-118.13891, 33.81857], [-118.13878, 33.81867], [-118.13416, 33.81868], [-118.1341, 33.81863], [-118.13413, 33.81186], [-118.13414, 33.81143], [-118.13419, 33.81124], [-118.1342, 33.81077], [-118.13422, 33.81074], [-118.13428, 33.81072], [-118.13441, 33.81072], [-118.13497, 33.81078], [-118.13539, 33.81088], [-118.13582, 33.81105], [-118.13625, 33.81129], [-118.13757, 33.81228], [-118.13794, 33.81248], [-118.13814, 33.81256], [-118.13848, 33.81267], [-118.1388, 33.81275], [-118.1389, 33.81284], [-118.1389, 33.81374], [-118.13894, 33.81402], [-118.13894, 33.81428], [-118.13895, 33.81713], [-118.13889, 33.81799], [-118.13889, 33.81832], [-118.13891, 33.81857]]]]} | Restricted Access 2 | Skylinks Golf Course | 33018 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 152.019 | Skylinks GC |
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]);