superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AG_TYP = 2 and YR_EST = 2006
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4810 | 4810 | 4809 | {"type": "Polygon", "coordinates": [[[-117.31395, 34.03037], [-117.31395, 34.03064], [-117.31376, 34.03064], [-117.31376, 34.03043], [-117.31383, 34.03037], [-117.31395, 34.03037]]]} | Open Access 1 | Gwen Karger Park | http://www.grandterrace-ca.gov/gwen-karger-park.html | 19578 | 1123 | Grand Terrace, City of 161 | City 2 | City Agency 2 | http://www.cityofgrandterrace.org/index.aspx?nid=25 | City 2 | 0.128 | Gwen Karger Park | 2006 |
6535 | 6535 | 6534 | {"type": "Polygon", "coordinates": [[[-122.25145, 38.17329], [-122.25132, 38.17587], [-122.24971, 38.17597], [-122.24975, 38.17328], [-122.25145, 38.17329]]]} | Open Access 1 | Main Street Park | 21690 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 10.508 | Main Street Park | 2006 | |
9678 | 9678 | 9677 | {"type": "Polygon", "coordinates": [[[-122.25007, 38.16579], [-122.25005, 38.16611], [-122.24926, 38.16618], [-122.24901, 38.16619], [-122.24855, 38.16624], [-122.24795, 38.16628], [-122.24767, 38.16632], [-122.24714, 38.16636], [-122.24707, 38.16634], [-122.24676, 38.16635], [-122.24673, 38.16638], [-122.2466, 38.16636], [-122.24648, 38.16624], [-122.24617, 38.16623], [-122.24613, 38.16637], [-122.2461, 38.16692], [-122.24607, 38.16705], [-122.24567, 38.16833], [-122.24481, 38.16833], [-122.24437, 38.16835], [-122.24435, 38.16612], [-122.24297, 38.1657], [-122.24259, 38.16565], [-122.2424, 38.16566], [-122.24223, 38.16562], [-122.24167, 38.16545], [-122.24143, 38.16543], [-122.24137, 38.16545], [-122.24127, 38.16537], [-122.24113, 38.16538], [-122.24109, 38.16533], [-122.24066, 38.16533], [-122.24065, 38.16535], [-122.24096, 38.16671], [-122.24044, 38.16609], [-122.24015, 38.16562], [-122.24004, 38.16511], [-122.24004, 38.16489], [-122.24005, 38.16481], [-122.24015, 38.16476], [-122.24067, 38.16488], [-122.24128, 38.16496], [-122.24386, 38.16536], [-122.24448, 38.16579], [-122.24464, 38.16579], [-122.2447, 38.16598], [-122.24472, 38.16623], [-122.24684, 38.16591], [-122.2472, 38.16605], [-122.24759, 38.16583], [-122.24809, 38.16587], [-122.24906, 38.16569], [-122.24922, 38.1656], [-122.24923, 38.16557], [-122.24991, 38.16564], [-122.25007, 38.16579]]]} | Open Access 1 | Silver Oak Park | 25492 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 19.22 | Silver Oak Park | 2006 |
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]);