units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where DES_TP = 2, MNG_AGENCY = 376 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AG_TYP 1
- City Agency · 44 ✖
MNG_AGENCY 1
- Fremont, City of · 44 ✖
DES_TP 1
- Local Park · 44 ✖
ACCESS_TYP 1
- Open Access 44
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 | |
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 | |
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 | |
8396 | 8396 | 8395 | {"type": "Polygon", "coordinates": [[[-122.03871, 37.56994], [-122.0378, 37.57114], [-122.03777, 37.57116], [-122.03771, 37.57115], [-122.03747, 37.57104], [-122.03656, 37.57059], [-122.03654, 37.57056], [-122.03654, 37.57052], [-122.03739, 37.56944], [-122.03742, 37.56942], [-122.03748, 37.56942], [-122.03784, 37.5696], [-122.03791, 37.56969], [-122.03796, 37.56972], [-122.03807, 37.56973], [-122.03816, 37.56968], [-122.03871, 37.56994]]]} | Open Access 1 | 12995 | Crandall Creek Park | 17755 | 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.975 | Crandall Creek Park | 0 | Local Park 2 | 4 | |
1554 | 1554 | 1553 | {"type": "Polygon", "coordinates": [[[-122.05699, 37.58393], [-122.05651, 37.58415], [-122.05648, 37.58423], [-122.05642, 37.58425], [-122.05594, 37.58447], [-122.0559, 37.5845], [-122.05587, 37.58454], [-122.05583, 37.58453], [-122.0556, 37.58464], [-122.05579, 37.58493], [-122.05587, 37.58502], [-122.05659, 37.58605], [-122.05675, 37.58613], [-122.05662, 37.5863], [-122.05654, 37.58626], [-122.05643, 37.58613], [-122.05582, 37.58528], [-122.05559, 37.58539], [-122.05554, 37.58546], [-122.05547, 37.58547], [-122.05496, 37.58571], [-122.05493, 37.58575], [-122.05491, 37.58581], [-122.055, 37.58594], [-122.05453, 37.58616], [-122.05448, 37.58628], [-122.05393, 37.58652], [-122.05385, 37.58647], [-122.05331, 37.5867], [-122.05325, 37.58662], [-122.05376, 37.5864], [-122.05378, 37.58634], [-122.05389, 37.58633], [-122.05395, 37.58628], [-122.05403, 37.58631], [-122.05429, 37.5862], [-122.05409, 37.58592], [-122.05422, 37.58586], [-122.05427, 37.58587], [-122.05434, 37.58586], [-122.05484, 37.58563], [-122.0549, 37.58557], [-122.0549, 37.5855], [-122.05513, 37.58539], [-122.05492, 37.58509], [-122.05515, 37.58498], [-122.05521, 37.58485], [-122.05531, 37.5848], [-122.05534, 37.58472], [-122.05529, 37.58464], [-122.05561, 37.58425], [-122.0556, 37.5842], [-122.05565, 37.58419], [-122.05571, 37.58415], [-122.05601, 37.58376], [-122.05602, 37.58369], [-122.0561, 37.58368], [-122.05622, 37.58352], [-122.05647, 37.58364], [-122.0566, 37.58347], [-122.05682, 37.58369], [-122.05699, 37.58393]]]} | Open Access 1 | 13018 | Lowry Park | 21570 | 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 | 5.11 | Lowry Park | 0 | Local Park 2 | 4 | |
8398 | 8398 | 8397 | {"type": "Polygon", "coordinates": [[[-122.05496, 37.57223], [-122.05499, 37.57249], [-122.05499, 37.57273], [-122.05497, 37.57297], [-122.05493, 37.57321], [-122.05485, 37.5735], [-122.05477, 37.57373], [-122.05464, 37.57401], [-122.05455, 37.57415], [-122.05448, 37.57416], [-122.05421, 37.57405], [-122.05391, 37.57397], [-122.05365, 37.57394], [-122.05331, 37.57392], [-122.05311, 37.57388], [-122.05294, 37.57382], [-122.05276, 37.57373], [-122.05264, 37.57364], [-122.0525, 37.57351], [-122.05259, 37.57347], [-122.05274, 37.57346], [-122.05285, 37.57343], [-122.05319, 37.57346], [-122.05333, 37.57339], [-122.05342, 37.57329], [-122.05358, 37.57329], [-122.05367, 37.57325], [-122.05372, 37.57318], [-122.05375, 37.57302], [-122.0537, 37.57285], [-122.05381, 37.57279], [-122.05384, 37.57267], [-122.05399, 37.57252], [-122.05388, 37.57243], [-122.05387, 37.5724], [-122.05397, 37.57215], [-122.05444, 37.57221], [-122.0549, 37.57219], [-122.05494, 37.5722], [-122.05496, 37.57223]]]} | Open Access 1 | 13002 | Deep Creek Park | 17989 | 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.262 | Deep Creek Park | 0 | 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]);