superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AGENCY = 549 sorted by LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1088 | 1088 | 1087 | {"type": "Polygon", "coordinates": [[[-118.08001, 33.87696], [-118.07997, 33.87704], [-118.07997, 33.87743], [-118.0794, 33.87743], [-118.07938, 33.8771], [-118.07816, 33.8771], [-118.07816, 33.8768], [-118.07818, 33.87679], [-118.07816, 33.87674], [-118.07825, 33.87676], [-118.07956, 33.87685], [-118.07979, 33.87689], [-118.08001, 33.87696]]]} | Open Access 1 | A.J. Padelford Park | 15228 | 1010 | Artesia, City of 549 | City 2 | City Agency 2 | http://www.cityofartesia.us/index.aspx?nid=127 | City 2 | 1.767 | A.J. Padelford Park | ||
1626 | 1626 | 1625 | {"type": "Polygon", "coordinates": [[[-118.07956, 33.86085], [-118.07681, 33.86088], [-118.07678, 33.85867], [-118.07681, 33.85862], [-118.0788, 33.8586], [-118.07871, 33.8587], [-118.07874, 33.85878], [-118.07884, 33.85886], [-118.07911, 33.85896], [-118.07955, 33.85959], [-118.07956, 33.86085]]]} | Open Access 1 | Artesia Park | 15639 | 1010 | Artesia, City of 549 | City 2 | City Agency 2 | http://www.cityofartesia.us/index.aspx?nid=127 | City 2 | 14.785 | Artesia Park | ||
1754 | 1754 | 1753 | {"type": "Polygon", "coordinates": [[[-118.09105, 33.8752], [-118.09097, 33.87507], [-118.0907, 33.87482], [-118.09062, 33.87469], [-118.09095, 33.87469], [-118.09106, 33.87497], [-118.09105, 33.8752]]]} | Open Access 1 | Barber Park | 15806 | 1010 | Artesia, City of 549 | City 2 | City Agency 2 | http://www.cityofartesia.us/index.aspx?nid=127 | City 2 | 0.253 | Barber 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]);