superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where MNG_AGENCY = 366 sorted by MNG_AG_LEV
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47 | 47 | 46 | {"type": "Polygon", "coordinates": [[[-118.18057, 33.81348], [-118.18057, 33.81362], [-118.18053, 33.8138], [-118.18, 33.81378], [-118.17999, 33.81348], [-118.18057, 33.81348]]]} | Open Access 1 | Signal Hill Dog Park | http://www.cityofsignalhill.org/Facilities/Facility/Details/Signal-Hill-Dog-Park-27 | 31767 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 0.441 | Signal Hill Dog Park | 2018 |
2483 | 2483 | 2482 | {"type": "Polygon", "coordinates": [[[-118.1811, 33.80179], [-118.18076, 33.80179], [-118.18076, 33.80122], [-118.18108, 33.80123], [-118.1811, 33.80179]]]} | Open Access 1 | Calbrisas Park | 16673 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 0.474 | Calbrisas Park | ||
3615 | 3615 | 3614 | {"type": "Polygon", "coordinates": [[[-118.15891, 33.80072], [-118.15821, 33.80071], [-118.15821, 33.80066], [-118.15828, 33.8006], [-118.15833, 33.80064], [-118.15839, 33.80066], [-118.15846, 33.80065], [-118.15851, 33.80061], [-118.15857, 33.80065], [-118.15879, 33.80061], [-118.15873, 33.8002], [-118.15856, 33.79971], [-118.1584, 33.79923], [-118.15838, 33.79906], [-118.15812, 33.79913], [-118.1581, 33.79908], [-118.15831, 33.79901], [-118.15832, 33.79899], [-118.15825, 33.79887], [-118.15815, 33.79876], [-118.15783, 33.79847], [-118.15778, 33.79837], [-118.15775, 33.79836], [-118.15758, 33.79851], [-118.15754, 33.79858], [-118.15748, 33.79856], [-118.15754, 33.79846], [-118.15756, 33.79831], [-118.15758, 33.79826], [-118.15727, 33.79812], [-118.15718, 33.79805], [-118.15697, 33.79771], [-118.15689, 33.79765], [-118.1567, 33.79738], [-118.15666, 33.79739], [-118.15665, 33.79759], [-118.15659, 33.79757], [-118.1566, 33.79746], [-118.15659, 33.79738], [-118.15656, 33.79731], [-118.15646, 33.7972], [-118.15875, 33.7972], [-118.15879, 33.79723], [-118.15879, 33.7976], [-118.15884, 33.79807], [-118.15879, 33.79813], [-118.1588, 33.79824], [-118.15884, 33.79856], [-118.15892, 33.79882], [-118.15891, 33.80072]]]} | Open Access 1 | Discovery Well Park | 18169 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 8.24 | Discovery Well Park | ||
4147 | 4147 | 4146 | {"type": "Polygon", "coordinates": [[[-118.16629, 33.79923], [-118.16621, 33.79945], [-118.16606, 33.79976], [-118.16573, 33.80021], [-118.16535, 33.79997], [-118.16507, 33.79997], [-118.16502, 33.79995], [-118.165, 33.79992], [-118.16501, 33.7988], [-118.16506, 33.79879], [-118.16535, 33.79881], [-118.16596, 33.79897], [-118.1661, 33.79905], [-118.16619, 33.79908], [-118.16624, 33.79911], [-118.16627, 33.79915], [-118.16629, 33.79923]]]} | Open Access 1 | Hilltop Park | http://www.cityofsignalhill.org/facilities/Facility/Details/3 | 19991 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 3.316 | Hilltop Park | |
5149 | 5149 | 5148 | {"type": "Polygon", "coordinates": [[[-118.15958, 33.79117], [-118.15899, 33.79119], [-118.15902, 33.79082], [-118.15956, 33.79083], [-118.15958, 33.79117]]]} | Open Access 1 | Hillbrook Park | 19961 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 0.509 | Hillbrook Park | ||
7919 | 7919 | 7918 | {"type": "Polygon", "coordinates": [[[-118.16498, 33.80029], [-118.1646, 33.80054], [-118.16419, 33.80076], [-118.16375, 33.80095], [-118.16331, 33.80111], [-118.16277, 33.80125], [-118.16221, 33.80134], [-118.16188, 33.80137], [-118.16172, 33.80136], [-118.16156, 33.80133], [-118.16141, 33.80127], [-118.16124, 33.80116], [-118.16114, 33.80107], [-118.16105, 33.80092], [-118.161, 33.80081], [-118.16098, 33.80066], [-118.16099, 33.80054], [-118.16102, 33.80039], [-118.16102, 33.80029], [-118.16099, 33.80018], [-118.16092, 33.80008], [-118.1608, 33.79999], [-118.16065, 33.79994], [-118.16024, 33.7999], [-118.15992, 33.79982], [-118.15967, 33.79972], [-118.15947, 33.79959], [-118.15924, 33.79938], [-118.15908, 33.79915], [-118.15898, 33.79895], [-118.15892, 33.79875], [-118.15892, 33.79859], [-118.15909, 33.79859], [-118.15919, 33.79895], [-118.1593, 33.79916], [-118.15944, 33.79934], [-118.15963, 33.79949], [-118.15984, 33.79961], [-118.16017, 33.7997], [-118.1607, 33.79976], [-118.16083, 33.7998], [-118.16094, 33.79985], [-118.16116, 33.80004], [-118.16116, 33.80016], [-118.16119, 33.80026], [-118.1612, 33.80036], [-118.16115, 33.80056], [-118.16114, 33.80065], [-118.16118, 33.80082], [-118.16125, 33.80095], [-118.16136, 33.80106], [-118.16149, 33.80114], [-118.16164, 33.8012], [-118.16186, 33.80123], [-118.16218, 33.8012], [-118.16263, 33.80113], [-118.16306, 33.80103], [-118.16351, 33.80089], [-118.16394, 33.80072], [-118.16441, 33.80048], [-118.1648, 33.80024], [-118.16498, 33.80029]]]} | Open Access 1 | Panorama Promenade | http://www.cityofsignalhill.org/Facilities/Facility/Details/5 | 23392 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 3.189 | Panorama Promenade | |
8607 | 8607 | 8606 | {"type": "Polygon", "coordinates": [[[-118.16393, 33.79882], [-118.16364, 33.79882], [-118.16357, 33.79876], [-118.16352, 33.79865], [-118.16345, 33.79857], [-118.16302, 33.79827], [-118.16309, 33.79825], [-118.16335, 33.79828], [-118.16356, 33.79833], [-118.16359, 33.79838], [-118.16364, 33.79841], [-118.16378, 33.79842], [-118.16379, 33.7987], [-118.16393, 33.79882]]]} | Open Access 1 | Sunset View Park | http://www.cityofsignalhill.org/Facilities/Facility/Details/4 | 26069 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 0.508 | Sunset View Park | |
8646 | 8646 | 8645 | {"type": "Polygon", "coordinates": [[[-118.17515, 33.81884], [-118.17416, 33.81885], [-118.17418, 33.81711], [-118.17514, 33.81709], [-118.17515, 33.81884]]]} | Open Access 1 | Reservoir Park | 24302 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 4.304 | Reservoir Park | ||
9664 | 9664 | 9663 | {"type": "Polygon", "coordinates": [[[-118.17034, 33.79537], [-118.17034, 33.79703], [-118.16786, 33.79703], [-118.16781, 33.797], [-118.16783, 33.79622], [-118.16787, 33.7957], [-118.16789, 33.79574], [-118.1692, 33.79574], [-118.16922, 33.79537], [-118.17034, 33.79537]]]} | Open Access 1 | Signal Hill Park | 25476 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 9.221 | Signal Hill Park | ||
12692 | 12692 | 12691 | {"type": "Polygon", "coordinates": [[[-118.16494, 33.79101], [-118.16494, 33.7913], [-118.16449, 33.7913], [-118.1645, 33.79101], [-118.16494, 33.79101]]]} | Open Access 1 | Raymond Arbor Park | http://www.cityofsignalhill.org/Facilities/Facility/Details/6 | 29841 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 0.325 | Raymond Arbor Park |
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]);