superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
58 rows where MNG_AGENCY = 376 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4332 | 4332 | 4331 | {"type": "Polygon", "coordinates": [[[-121.95991, 37.53298], [-121.95978, 37.53314], [-121.95949, 37.53297], [-121.95949, 37.53297], [-121.95991, 37.53298]]]} | Open Access 1 | Irvington Plaza | 20274 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 0.081 | Irvington Plaza | 1961 | |
8608 | 8608 | 8607 | {"type": "Polygon", "coordinates": [[[-122.0072, 37.56736], [-122.0072, 37.56745], [-122.00688, 37.56752], [-122.00683, 37.56732], [-122.00689, 37.56727], [-122.0072, 37.56736]]]} | Open Access 1 | Surry Park | 26078 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 0.147 | Surry Park | ||
13425 | 13425 | 13424 | {"type": "Polygon", "coordinates": [[[-122.00741, 37.55856], [-122.00698, 37.55907], [-122.00686, 37.55908], [-122.00678, 37.55875], [-122.00712, 37.55842], [-122.00741, 37.55856]]]} | Open Access 1 | Bill Ball Civic Park | 30825 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 0.513 | Bill Ball Civic Park | ||
8089 | 8089 | 8088 | {"type": "Polygon", "coordinates": [[[-122.05922, 37.57803], [-122.05881, 37.57814], [-122.05853, 37.57833], [-122.05839, 37.57823], [-122.05836, 37.57818], [-122.05837, 37.57815], [-122.05884, 37.57762], [-122.05888, 37.5776], [-122.05894, 37.57761], [-122.05903, 37.57771], [-122.05911, 37.57782], [-122.05922, 37.57803]]]} | Open Access 1 | Peregrine Park | 23607 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 0.717 | Peregrine Park | ||
9681 | 9681 | 9680 | {"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 | Williams Historical Park | 27563 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 0.894 | Williams Historical Park | 1973 | |
13424 | 13424 | 13423 | {"type": "Polygon", "coordinates": [[[-121.91219, 37.50432], [-121.91168, 37.50446], [-121.91141, 37.50375], [-121.91142, 37.50369], [-121.91146, 37.50366], [-121.91188, 37.50352], [-121.91219, 37.50432]]]} | Open Access 1 | Weibel Historic Park | 30824 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1.058 | Weibel Historic Park | ||
8235 | 8235 | 8234 | {"type": "Polygon", "coordinates": [[[-122.01159, 37.54533], [-122.01151, 37.54542], [-122.01127, 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.54493], [-122.01035, 37.54512], [-122.01046, 37.54522], [-122.01042, 37.54527], [-122.01033, 37.54524], [-122.01011, 37.5453], [-122.01001, 37.54541], [-122.00973, 37.54527], [-122.00993, 37.54502], [-122.00997, 37.54502], [-122.01023, 37.54471], [-122.01, 37.54457], [-122.01005, 37.54451], [-122.01048, 37.54474], [-122.01051, 37.54479], [-122.0107, 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 | Plaza Park | 23782 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1.102 | Plaza Park | 1973 | |
11018 | 11018 | 11017 | {"type": "Polygon", "coordinates": [[[-122.06061, 37.5823], [-122.06044, 37.58247], [-122.06027, 37.58235], [-122.06005, 37.58217], [-122.05986, 37.58197], [-122.05972, 37.58179], [-122.05959, 37.58154], [-122.06024, 37.58146], [-122.06034, 37.58191], [-122.06037, 37.58196], [-122.06043, 37.58201], [-122.06057, 37.58205], [-122.06061, 37.5823]]]} | Open Access 1 | Warbler Park | 27252 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1.19 | Warbler Park | ||
2537 | 2537 | 2536 | {"type": "Polygon", "coordinates": [[[-121.99986, 37.58564], [-121.99972, 37.58581], [-121.99965, 37.58593], [-121.99961, 37.58596], [-121.99911, 37.58586], [-121.99892, 37.5858], [-121.99868, 37.58569], [-121.99852, 37.58557], [-121.99854, 37.58553], [-121.99871, 37.58539], [-121.99882, 37.58528], [-121.99908, 37.58507], [-121.99915, 37.58506], [-121.9992, 37.58507], [-121.99985, 37.58559], [-121.99986, 37.58564]]]} | Open Access 1 | California Terrace Park | 16729 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1.669 | California Terrace Park | 1972 | |
13436 | 13436 | 13435 | {"type": "Polygon", "coordinates": [[[-121.97933, 37.57715], [-121.9792, 37.57748], [-121.9791, 37.57747], [-121.979, 37.5777], [-121.97774, 37.57751], [-121.97799, 37.57683], [-121.97933, 37.57715]]]} | Open Access 1 | Niles Town Plaza | 30826 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2.123 | Niles Town Plaza | ||
2293 | 2293 | 2292 | {"type": "Polygon", "coordinates": [[[-122.02309, 37.56793], [-122.02259, 37.56859], [-122.02267, 37.56866], [-122.02253, 37.56884], [-122.02249, 37.56866], [-122.02161, 37.56762], [-122.02176, 37.56748], [-122.02192, 37.56727], [-122.02228, 37.56744], [-122.02242, 37.5676], [-122.02309, 37.56793]]]} | Open Access 1 | Brookvale Park | 16436 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2.345 | Brookvale Park | ||
7410 | 7410 | 7409 | {"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 | Noll Park | 22784 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2.784 | Noll Park | 1973 | |
13439 | 13439 | 13438 | {"type": "Polygon", "coordinates": [[[-121.95603, 37.54103], [-121.95584, 37.5411], [-121.95561, 37.53966], [-121.95519, 37.5368], [-121.9548, 37.53434], [-121.95503, 37.53453], [-121.95537, 37.53662], [-121.95603, 37.54103]]]} | Open Access 1 | East Bay Greenway Trail Corridor | 30830 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 3.363 | East Bay Greenway Trail Corridor | ||
13423 | 13423 | 13422 | {"type": "Polygon", "coordinates": [[[-122.00899, 37.55509], [-122.00805, 37.55463], [-122.00852, 37.55406], [-122.00852, 37.55404], [-122.00842, 37.55399], [-122.00888, 37.55341], [-122.00932, 37.55363], [-122.00945, 37.55372], [-122.00958, 37.55388], [-122.00962, 37.55397], [-122.00963, 37.55407], [-122.00962, 37.55422], [-122.00956, 37.55435], [-122.00899, 37.55509]]]} | Open Access 1 | Peralta/Dusterberry Park | 30823 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 3.62 | Peralta/Dusterberry Park | ||
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 | |
6795 | 6795 | 6794 | {"type": "Polygon", "coordinates": [[[-122.03474, 37.56159], [-122.03259, 37.56261], [-122.0325, 37.56271], [-122.03181, 37.56237], [-122.03162, 37.5626], [-122.03129, 37.56244], [-122.03313, 37.56157], [-122.0333, 37.56146], [-122.03352, 37.56166], [-122.03368, 37.56175], [-122.03393, 37.56177], [-122.03469, 37.56126], [-122.03473, 37.56143], [-122.03474, 37.56159]]]} | Open Access 1 | Patterson Park | 23520 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 3.861 | Patterson Park | ||
2727 | 2727 | 2726 | {"type": "Polygon", "coordinates": [[[-122.05715, 37.57857], [-122.05566, 37.58029], [-122.05467, 37.57972], [-122.0569, 37.57843], [-122.05715, 37.57857]]]} | Open Access 1 | David Jones Park | 17942 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 3.885 | David Jones Park | ||
11149 | 11149 | 11148 | {"type": "Polygon", "coordinates": [[[-122.02264, 37.56384], [-122.02152, 37.56529], [-122.02068, 37.56488], [-122.02173, 37.56353], [-122.02206, 37.56367], [-122.02246, 37.56378], [-122.02264, 37.56384]]]} | Open Access 1 | Westridge Park | 27420 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 3.914 | Westridge Park | ||
8506 | 8506 | 8505 | {"type": "Polygon", "coordinates": [[[-121.99256, 37.57229], [-121.99231, 37.5725], [-121.99224, 37.57281], [-121.99201, 37.5728], [-121.9917, 37.57283], [-121.99148, 37.5729], [-121.99125, 37.57302], [-121.991, 37.57276], [-121.99062, 37.57267], [-121.99116, 37.57122], [-121.99222, 37.57203], [-121.99212, 37.57212], [-121.99218, 37.57218], [-121.99231, 37.5721], [-121.99256, 37.57229]]]} | Open Access 1 | Rancho Arroyo Park | 24127 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 4.472 | Rancho Arroyo Park | ||
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 |
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]);