units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where ACCESS_TYP = 1, MNG_AGENCY = 376 and YR_EST = 1973
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1545 | 1545 | 1544 | {"type": "Polygon", "coordinates": [[[-121.92081, 37.47824], [-121.92042, 37.47893], [-121.91967, 37.47868], [-121.91913, 37.47883], [-121.91902, 37.47896], [-121.91873, 37.47891], [-121.91828, 37.47906], [-121.91812, 37.47925], [-121.91824, 37.47946], [-121.91842, 37.47985], [-121.9173, 37.48026], [-121.91631, 37.47851], [-121.91682, 37.47833], [-121.9171, 37.47884], [-121.91744, 37.47892], [-121.91786, 37.47879], [-121.91967, 37.47812], [-121.92003, 37.47831], [-121.92062, 37.47809], [-121.92078, 37.47818], [-121.92081, 37.47821], [-121.92081, 37.47824]]]} | Open Access 1 | 12981 | Booster Park | 16273 | 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 | 8.178 | Booster Park | 1973 | Local Park 2 | 4 | |
1716 | 1716 | 1715 | {"type": "Polygon", "coordinates": [[[-122.01159, 37.54533], [-122.01151, 37.54542], [-122.01126, 37.54529], [-122.01121, 37.54529], [-122.01094, 37.54515], [-122.01092, 37.54508], [-122.01075, 37.54499], [-122.01066, 37.545], [-122.01051, 37.54492], [-122.01035, 37.54512], [-122.01046, 37.54522], [-122.01042, 37.54527], [-122.01034, 37.54524], [-122.0101, 37.5453], [-122.01001, 37.54541], [-122.00973, 37.54527], [-122.00993, 37.54502], [-122.00997, 37.54503], [-122.01024, 37.5447], [-122.01, 37.54457], [-122.01005, 37.54451], [-122.01048, 37.54474], [-122.0105, 37.54479], [-122.01071, 37.54489], [-122.01076, 37.54489], [-122.01103, 37.54503], [-122.01105, 37.54508], [-122.01125, 37.54518], [-122.01129, 37.54517], [-122.01159, 37.54533]]]} | Open Access 1 | 12873 | Plaza Park | 23782 | 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 | 1.095 | Plaza Park | 1973 | Local Park 2 | 4 | |
1751 | 1751 | 1750 | {"type": "Polygon", "coordinates": [[[-121.98462, 37.5346], [-121.98436, 37.5349], [-121.98351, 37.53593], [-121.98325, 37.53578], [-121.98309, 37.53561], [-121.98301, 37.53546], [-121.98399, 37.53428], [-121.98462, 37.5346]]]} | Open Access 1 | 13032 | Noll Park | 22784 | 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 | 2.784 | Noll Park | 1973 | Local Park 2 | 4 | |
8340 | 8340 | 8339 | {"type": "MultiPolygon", "coordinates": [[[[-121.97251, 37.51695], [-121.97249, 37.5171], [-121.97244, 37.51724], [-121.97235, 37.51737], [-121.97223, 37.51749], [-121.97209, 37.51758], [-121.97193, 37.51766], [-121.97206, 37.51791], [-121.97163, 37.518], [-121.97121, 37.51641], [-121.97107, 37.51542], [-121.97073, 37.51549], [-121.97073, 37.51546], [-121.97107, 37.51535], [-121.97097, 37.51513], [-121.97063, 37.51502], [-121.97017, 37.51506], [-121.96998, 37.51478], [-121.96971, 37.51449], [-121.96938, 37.51428], [-121.96916, 37.51449], [-121.96909, 37.51445], [-121.96988, 37.51368], [-121.97012, 37.51408], [-121.97082, 37.51421], [-121.97133, 37.51525], [-121.97164, 37.51518], [-121.97165, 37.5152], [-121.97136, 37.51532], [-121.97203, 37.51667], [-121.97234, 37.5166], [-121.97236, 37.51662], [-121.97206, 37.51673], [-121.97217, 37.51695], [-121.97251, 37.51695]]], [[[-121.97295, 37.5191], [-121.97259, 37.51951], [-121.97245, 37.51945], [-121.9726, 37.5192], [-121.97236, 37.51912], [-121.9721, 37.5191], [-121.97184, 37.51911], [-121.97109, 37.51924], [-121.9709, 37.51853], [-121.97173, 37.51839], [-121.97167, 37.51812], [-121.97204, 37.51805], [-121.9722, 37.51841], [-121.97237, 37.51887], [-121.97295, 37.5191]]]]} | Open Access 1 | 12848 | Rix Park | 24472 | 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 | 10.725 | Rix Park | 1973 | Local Park 2 | 4 | |
8360 | 8360 | 8359 | {"type": "Polygon", "coordinates": [[[-121.98613, 37.54673], [-121.98584, 37.5471], [-121.98512, 37.54673], [-121.98542, 37.54636], [-121.98613, 37.54673]]]} | Open Access 1 | 12957 | Williams Historical Park | 27563 | 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 | 0.894 | Williams Historical Park | 1973 | Local Historic or Cultural Area 19 | 4 | |
8375 | 8375 | 8374 | {"type": "Polygon", "coordinates": [[[-121.93225, 37.50991], [-121.93204, 37.51012], [-121.93181, 37.51023], [-121.93159, 37.51028], [-121.93114, 37.51029], [-121.93086, 37.51035], [-121.93082, 37.51033], [-121.93058, 37.51007], [-121.9304, 37.50992], [-121.93017, 37.50976], [-121.92982, 37.50957], [-121.93049, 37.50885], [-121.93022, 37.50868], [-121.93039, 37.5085], [-121.9304, 37.50844], [-121.9304, 37.50839], [-121.93036, 37.50832], [-121.92988, 37.5079], [-121.92977, 37.50786], [-121.92968, 37.50787], [-121.92962, 37.50789], [-121.92919, 37.50748], [-121.92948, 37.50745], [-121.93084, 37.50722], [-121.93088, 37.50723], [-121.93101, 37.50771], [-121.93102, 37.50784], [-121.93101, 37.50803], [-121.93096, 37.50821], [-121.93089, 37.50837], [-121.9308, 37.5085], [-121.9306, 37.50873], [-121.93058, 37.50878], [-121.93055, 37.50884], [-121.93056, 37.50895], [-121.93061, 37.50899], [-121.93068, 37.50902], [-121.93075, 37.50901], [-121.93081, 37.50899], [-121.93084, 37.50895], [-121.93086, 37.50891], [-121.93083, 37.50881], [-121.93083, 37.50876], [-121.93114, 37.50894], [-121.93204, 37.50965], [-121.932, 37.50975], [-121.93225, 37.50991]]]} | Open Access 1 | 12969 | Arroyo Agua Caliente Park | 15608 | 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 | 8.639 | Arroyo Agua Caliente Park | 1973 | Local Park 2 | 4 | |
8378 | 8378 | 8377 | {"type": "Polygon", "coordinates": [[[-121.99645, 37.5323], [-121.99529, 37.53248], [-121.99431, 37.53369], [-121.99277, 37.53289], [-121.99248, 37.53294], [-121.9924, 37.53304], [-121.992, 37.53283], [-121.99219, 37.5326], [-121.99241, 37.53271], [-121.99421, 37.53243], [-121.99502, 37.53145], [-121.99614, 37.53202], [-121.99626, 37.5321], [-121.99629, 37.5321], [-121.99638, 37.53219], [-121.99645, 37.5323]]]} | Open Access 1 | 12972 | Azevada Park | 15739 | 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 | 7.832 | Azevada Park | 1973 | Local Park 2 | 4 | |
8403 | 8403 | 8402 | {"type": "Polygon", "coordinates": [[[-121.95484, 37.55058], [-121.95467, 37.55059], [-121.95169, 37.55095], [-121.95126, 37.55128], [-121.94894, 37.54939], [-121.95022, 37.54841], [-121.95122, 37.54927], [-121.95149, 37.54909], [-121.95151, 37.54916], [-121.95122, 37.54937], [-121.95178, 37.54986], [-121.952, 37.55015], [-121.95214, 37.55027], [-121.95256, 37.55029], [-121.9527, 37.55019], [-121.9527, 37.55017], [-121.95249, 37.54998], [-121.95253, 37.54993], [-121.95267, 37.55001], [-121.95322, 37.54998], [-121.95323, 37.55005], [-121.95321, 37.5501], [-121.95284, 37.55012], [-121.9529, 37.55039], [-121.95325, 37.55056], [-121.95364, 37.55051], [-121.95388, 37.55026], [-121.95384, 37.55001], [-121.95413, 37.54999], [-121.9542, 37.54991], [-121.95428, 37.54994], [-121.95436, 37.54993], [-121.95478, 37.54996], [-121.95484, 37.55058]]]} | Open Access 1 | 13008 | Gomes Park | 19388 | 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 | 14.299 | Gomes Park | 1973 | Local Park 2 | 4 | |
8406 | 8406 | 8405 | {"type": "Polygon", "coordinates": [[[-121.91653, 37.47485], [-121.9162, 37.47533], [-121.91599, 37.47559], [-121.91525, 37.47665], [-121.91428, 37.47497], [-121.91463, 37.47484], [-121.91467, 37.47477], [-121.91475, 37.47478], [-121.91483, 37.47476], [-121.91488, 37.47472], [-121.91491, 37.47465], [-121.91526, 37.47444], [-121.91566, 37.47425], [-121.91605, 37.47455], [-121.91651, 37.4748], [-121.91653, 37.47485]]]} | Open Access 1 | 13013 | Lone Tree Creek Park | 21442 | 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 | 6.426 | Lone Tree Creek Park | 1973 | Local Park 2 | 4 | |
8409 | 8409 | 8408 | {"type": "Polygon", "coordinates": [[[-121.98342, 37.52049], [-121.98325, 37.52069], [-121.98311, 37.52088], [-121.98307, 37.52088], [-121.98158, 37.52257], [-121.98078, 37.52351], [-121.9791, 37.52268], [-121.9795, 37.52216], [-121.97916, 37.52199], [-121.97933, 37.52185], [-121.97963, 37.52171], [-121.97956, 37.52193], [-121.97982, 37.52209], [-121.98066, 37.52227], [-121.98071, 37.52215], [-121.98114, 37.52224], [-121.98134, 37.52163], [-121.9805, 37.52145], [-121.98055, 37.52127], [-121.98073, 37.52117], [-121.98087, 37.52105], [-121.98095, 37.52095], [-121.98102, 37.52083], [-121.98167, 37.52075], [-121.98243, 37.51979], [-121.98295, 37.52017], [-121.98342, 37.52049]]]} | Open Access 1 | 13025 | Marshall Park | 21897 | 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 | 13.314 | Marshall Park | 1973 | Local Park 2 | 4 | |
17024 | 17024 | 17023 | {"type": "Polygon", "coordinates": [[[-121.99179, 37.55472], [-121.9905, 37.55623], [-121.9886, 37.55525], [-121.98988, 37.55374], [-121.99179, 37.55472]]]} | Open Access 1 | 12994 | Centerville Community Park | 17042 | 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 | 10.034 | Centerville Community Park | 1973 | 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]);