units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where DES_TP = 2, MNG_AGENCY = 376 and YR_EST = 1984
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1546 | 1546 | 1545 | {"type": "Polygon", "coordinates": [[[-121.94629, 37.55413], [-121.94553, 37.55481], [-121.94613, 37.55522], [-121.94594, 37.55538], [-121.94582, 37.55544], [-121.94486, 37.55627], [-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 | 12987 | Buena Vista Park | 16491 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 4.54 | Buena Vista Park | 1984 | Local Park 2 | 4 | |
1733 | 1733 | 1732 | {"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.48497], [-121.923, 37.48603]]]} | Open Access 1 | 12934 | Warm Springs Park | 27260 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 11.662 | Warm Springs Park | 1984 | Local Park 2 | 4 | |
8329 | 8329 | 8328 | {"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 | 12816 | Plomosa Park | 23812 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 3.848 | Plomosa Park | 1984 | Local Park 2 | 4 | |
8410 | 8410 | 8409 | {"type": "Polygon", "coordinates": [[[-121.93952, 37.54652], [-121.93642, 37.5475], [-121.93634, 37.54757], [-121.93601, 37.54739], [-121.93593, 37.54741], [-121.93544, 37.54713], [-121.93594, 37.54656], [-121.93702, 37.54623], [-121.93777, 37.54539], [-121.93841, 37.54539], [-121.93841, 37.54585], [-121.93928, 37.54636], [-121.93952, 37.54652]]]} | Open Access 1 | 13027 | Mission San Jose Community Park | 22310 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 9.578 | Mission San Jose Community Park | 1984 | Local Park 2 | 4 | |
8414 | 8414 | 8413 | {"type": "Polygon", "coordinates": [[[-121.92796, 37.5226], [-121.92787, 37.52269], [-121.92771, 37.52293], [-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.92533, 37.52276], [-121.92494, 37.52273], [-121.92454, 37.52275], [-121.92429, 37.52279], [-121.92409, 37.52284], [-121.92385, 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 | 13041 | Old Mission Park | 23094 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 22.896 | Old Mission Park | 1984 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);