units_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, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8405 | 8405 | 8404 | {"type": "Polygon", "coordinates": [[[-121.95991, 37.53298], [-121.95978, 37.53314], [-121.95949, 37.53297], [-121.95991, 37.53298], [-121.95991, 37.53298]]]} | Open Access 1 | 13011 | Irvington Plaza | 20274 | 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.081 | Irvington Plaza | 1961 | Local Park 2 | 4 | |
11295 | 11295 | 11294 | {"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 | 22009 | Surry Park | 26078 | 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.147 | Surry Park | 0 | Local Park 2 | 4 | |
14287 | 14287 | 14286 | {"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 | 47144 | Bill Ball Civic Park | 30825 | 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.513 | Bill Ball Civic Park | 0 | Local Park 2 | 4 | |
8416 | 8416 | 8415 | {"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 | 13044 | Peregrine Park | 23607 | 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.717 | Peregrine Park | 0 | 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 | |
14399 | 14399 | 14398 | {"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 | 47143 | Weibel Historic Park | 30824 | 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.058 | Weibel Historic Park | 0 | Local Historic or Cultural Area 19 | 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 | |
1729 | 1729 | 1728 | {"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 | 12922 | Warbler Park | 27252 | 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.19 | Warbler Park | 0 | Local Park 2 | 4 | |
1749 | 1749 | 1748 | {"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.99909, 37.58507], [-121.99915, 37.58506], [-121.9992, 37.58507], [-121.99985, 37.58559], [-121.99986, 37.58564]]]} | Open Access 1 | 12992 | California Terrace Park | 16729 | 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.669 | California Terrace Park | 1972 | Local Park 2 | 4 | |
14350 | 14350 | 14349 | {"type": "Polygon", "coordinates": [[[-121.97933, 37.57715], [-121.9792, 37.57748], [-121.97911, 37.57746], [-121.979, 37.5777], [-121.97774, 37.57751], [-121.97799, 37.57683], [-121.97933, 37.57715]]]} | Open Access 1 | 47145 | Niles Town Plaza | 30826 | 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.122 | Niles Town Plaza | 0 | Local Park 2 | 4 | |
1748 | 1748 | 1747 | {"type": "Polygon", "coordinates": [[[-122.02309, 37.56793], [-122.02258, 37.5686], [-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 | 12983 | Brookvale Park | 16436 | 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.344 | Brookvale Park | 0 | 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 | |
14489 | 14489 | 14488 | {"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 | 47148 | East Bay Greenway Trail Corridor | 30830 | 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.364 | East Bay Greenway Trail Corridor | 0 | Local Conservation Area 4 | 2 | |
14430 | 14430 | 14429 | {"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 | 47142 | Peralta/Dusterberry Park | 30823 | 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.62 | Peralta/Dusterberry Park | 0 | 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 | |
8415 | 8415 | 8414 | {"type": "Polygon", "coordinates": [[[-122.03474, 37.56159], [-122.03258, 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.03369, 37.56176], [-122.03393, 37.56177], [-122.03469, 37.56126], [-122.03473, 37.56143], [-122.03474, 37.56159]]]} | Open Access 1 | 13043 | Patterson Park | 23520 | 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.859 | Patterson Park | 0 | Local Park 2 | 4 | |
1552 | 1552 | 1551 | {"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 | 13000 | David Jones Park | 17942 | 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.885 | David Jones Park | 0 | Local Park 2 | 4 | |
1737 | 1737 | 1736 | {"type": "Polygon", "coordinates": [[[-122.02264, 37.56384], [-122.02152, 37.56529], [-122.02068, 37.56488], [-122.02173, 37.56353], [-122.02206, 37.56367], [-122.02247, 37.56378], [-122.02264, 37.56384]]]} | Open Access 1 | 12946 | Westridge Park | 27420 | 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.914 | Westridge Park | 0 | Local Park 2 | 4 | |
1700 | 1700 | 1699 | {"type": "Polygon", "coordinates": [[[-121.99256, 37.57229], [-121.99231, 37.57249], [-121.99224, 37.57281], [-121.99201, 37.5728], [-121.99171, 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.99219, 37.57219], [-121.99231, 37.5721], [-121.99256, 37.57229]]]} | Open Access 1 | 12826 | Rancho Arroyo Park | 24127 | 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.47 | Rancho Arroyo Park | 0 | Local Park 2 | 4 | |
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 |
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]);