superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where MNG_AGENCY = 376 and YR_EST = 1984
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2342 | 2342 | 2341 | {"type": "Polygon", "coordinates": [[[-121.94629, 37.55413], [-121.94554, 37.5548], [-121.94613, 37.55522], [-121.94594, 37.55538], [-121.94582, 37.55544], [-121.94487, 37.55626], [-121.9447, 37.55637], [-121.94463, 37.55636], [-121.94461, 37.55634], [-121.94456, 37.55617], [-121.94449, 37.55605], [-121.94437, 37.55591], [-121.94414, 37.55573], [-121.94412, 37.55571], [-121.94413, 37.55567], [-121.94596, 37.55405], [-121.94603, 37.55402], [-121.9461, 37.55402], [-121.94629, 37.55413]]]} | Open Access 1 | Buena Vista Park | 16491 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 4.547 | Buena Vista Park | 1984 | |
7059 | 7059 | 7058 | {"type": "Polygon", "coordinates": [[[-121.93952, 37.54652], [-121.93642, 37.54749], [-121.93634, 37.54757], [-121.93601, 37.54739], [-121.93593, 37.54741], [-121.93544, 37.54713], [-121.93594, 37.54656], [-121.93702, 37.54622], [-121.93777, 37.5454], [-121.93841, 37.54539], [-121.93841, 37.54585], [-121.93928, 37.54636], [-121.93952, 37.54652]]]} | Open Access 1 | Mission San Jose Community Park | 22310 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 9.581 | Mission San Jose Community Park | 1984 | |
7651 | 7651 | 7650 | {"type": "Polygon", "coordinates": [[[-121.92796, 37.5226], [-121.92787, 37.52269], [-121.92771, 37.52292], [-121.92771, 37.52297], [-121.92773, 37.52305], [-121.92758, 37.52326], [-121.92747, 37.52349], [-121.92705, 37.52345], [-121.92659, 37.52335], [-121.9262, 37.52319], [-121.92571, 37.52289], [-121.92557, 37.52283], [-121.92532, 37.52276], [-121.92494, 37.52273], [-121.92454, 37.52275], [-121.92429, 37.52279], [-121.92409, 37.52284], [-121.92386, 37.52293], [-121.92364, 37.52303], [-121.9235, 37.52312], [-121.92328, 37.52328], [-121.92319, 37.52329], [-121.92315, 37.52328], [-121.92297, 37.52311], [-121.92273, 37.52296], [-121.92265, 37.52288], [-121.92257, 37.52277], [-121.92252, 37.52263], [-121.92238, 37.52166], [-121.92232, 37.52148], [-121.92219, 37.52124], [-121.92219, 37.52121], [-121.92223, 37.52116], [-121.92312, 37.52085], [-121.92328, 37.52081], [-121.92348, 37.52079], [-121.92406, 37.52084], [-121.92432, 37.52083], [-121.92462, 37.52078], [-121.92494, 37.52067], [-121.92502, 37.52066], [-121.92506, 37.52068], [-121.92529, 37.52097], [-121.92552, 37.52121], [-121.92573, 37.52139], [-121.92596, 37.52155], [-121.92634, 37.52177], [-121.92772, 37.52242], [-121.92796, 37.5226]]]} | Open Access 1 | Old Mission Park | 23094 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 22.896 | Old Mission Park | 1984 | |
8256 | 8256 | 8255 | {"type": "MultiPolygon", "coordinates": [[[[-121.91002, 37.46761], [-121.90977, 37.4677], [-121.90874, 37.46595], [-121.90901, 37.46587], [-121.91002, 37.46761]]], [[[-121.9104, 37.46826], [-121.91022, 37.46833], [-121.91016, 37.46837], [-121.90986, 37.46784], [-121.9101, 37.46776], [-121.9104, 37.46826]]], [[[-121.91157, 37.47029], [-121.91138, 37.47037], [-121.91134, 37.47036], [-121.9113, 37.47034], [-121.91026, 37.46854], [-121.91025, 37.4685], [-121.91028, 37.46846], [-121.91048, 37.46839], [-121.91157, 37.47029]]], [[[-121.91227, 37.4715], [-121.91208, 37.47158], [-121.91203, 37.47157], [-121.912, 37.47155], [-121.91143, 37.47057], [-121.91143, 37.47054], [-121.91145, 37.47051], [-121.91165, 37.47043], [-121.91227, 37.4715]]]]} | Open Access 1 | Plomosa Park | 23812 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 3.847 | Plomosa Park | 1984 | |
11024 | 11024 | 11023 | {"type": "Polygon", "coordinates": [[[-121.923, 37.48603], [-121.92178, 37.48647], [-121.92177, 37.48649], [-121.92182, 37.48658], [-121.92114, 37.48684], [-121.9199, 37.48473], [-121.9219, 37.48403], [-121.92244, 37.48494], [-121.92239, 37.48498], [-121.923, 37.48603]]]} | Open Access 1 | Warm Springs Park | 27260 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 11.662 | Warm Springs Park | 1984 | |
13412 | 13412 | 13411 | {"type": "MultiPolygon", "coordinates": [[[[-121.98049, 37.56446], [-121.98046, 37.56449], [-121.98039, 37.56453], [-121.9797, 37.56477], [-121.97952, 37.56481], [-121.97943, 37.56451], [-121.98024, 37.56435], [-121.9804, 37.56434], [-121.98046, 37.56437], [-121.98049, 37.56446]]], [[[-121.98121, 37.5663], [-121.98119, 37.56634], [-121.98115, 37.56638], [-121.9808, 37.56649], [-121.98073, 37.56649], [-121.98067, 37.56646], [-121.98059, 37.56633], [-121.98044, 37.56604], [-121.98016, 37.56567], [-121.98005, 37.56548], [-121.97984, 37.56492], [-121.97984, 37.56487], [-121.97986, 37.56484], [-121.98051, 37.5646], [-121.98057, 37.5646], [-121.98063, 37.56462], [-121.98078, 37.5648], [-121.98101, 37.565], [-121.98114, 37.56519], [-121.98121, 37.56537], [-121.98121, 37.56555], [-121.98115, 37.56583], [-121.98114, 37.56599], [-121.98115, 37.56614], [-121.98121, 37.5663]]]]} | Open Access 1 | Shin Historic Park | 30828 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 4.613 | Shin Historic Park | 1984 |
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]);