superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "17.355" and MNG_AGENCY = 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10428 | 10428 | 10427 | {"type": "Polygon", "coordinates": [[[-117.27414, 33.9303], [-117.27373, 33.93047], [-117.27341, 33.93062], [-117.27307, 33.93022], [-117.27271, 33.9302], [-117.27233, 33.9304], [-117.27226, 33.93049], [-117.27226, 33.93059], [-117.27252, 33.93064], [-117.2726, 33.93064], [-117.27261, 33.93067], [-117.27257, 33.93068], [-117.27232, 33.93086], [-117.27232, 33.93088], [-117.2741, 33.93202], [-117.27379, 33.93222], [-117.27206, 33.93113], [-117.27105, 33.93222], [-117.27066, 33.93199], [-117.27036, 33.93185], [-117.27008, 33.93174], [-117.26982, 33.93166], [-117.26976, 33.93157], [-117.27001, 33.93095], [-117.2701, 33.93078], [-117.27017, 33.93054], [-117.2702, 33.93038], [-117.27022, 33.93016], [-117.27021, 33.92961], [-117.27035, 33.92969], [-117.27063, 33.92969], [-117.27071, 33.92965], [-117.27074, 33.92961], [-117.27379, 33.92959], [-117.27387, 33.92956], [-117.27394, 33.92954], [-117.27405, 33.92948], [-117.27406, 33.92991], [-117.27414, 33.9303]]]} | Open Access 1 | Towngate Memorial Park | 26496 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 17.355 | Towngate Memorial 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]);