superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17 rows where ACCESS_TYP = 1 and MNG_AGENCY = 60
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP 1
- City Agency 17
ACCESS_TYP 1
- Open Access · 17 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2842 | 2842 | 2841 | {"type": "Polygon", "coordinates": [[[-118.01094, 33.78847], [-118.01094, 33.78949], [-118.00971, 33.78947], [-118.00969, 33.78966], [-118.00911, 33.78965], [-118.00908, 33.79057], [-118.00892, 33.7906], [-118.00893, 33.79107], [-118.00771, 33.79106], [-118.00771, 33.78841], [-118.01085, 33.78839], [-118.01094, 33.78847]]]} | Open Access 1 | Chapman Sports Park | 17134 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 14.524 | Chapman Sports Park | ||
3811 | 3811 | 3810 | {"type": "Polygon", "coordinates": [[[-118.0348, 33.78905], [-118.03472, 33.78907], [-118.03341, 33.78895], [-118.03335, 33.78892], [-118.03333, 33.78887], [-118.03336, 33.78839], [-118.03332, 33.78795], [-118.03334, 33.78789], [-118.03339, 33.78787], [-118.03471, 33.78771], [-118.03476, 33.78772], [-118.0348, 33.78775], [-118.03484, 33.78812], [-118.03485, 33.7886], [-118.03483, 33.78892], [-118.0348, 33.78905]]]} | Open Access 1 | Eastgate Park | 18393 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 4.635 | Eastgate Park | ||
3848 | 3848 | 3847 | {"type": "Polygon", "coordinates": [[[-118.02716, 33.77607], [-118.02715, 33.77847], [-118.02713, 33.77851], [-118.02649, 33.77851], [-118.02651, 33.77704], [-118.02563, 33.77703], [-118.02407, 33.77705], [-118.02407, 33.77607], [-118.02716, 33.77607]]]} | Open Access 1 | Edgar Park | 18433 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 10.037 | Edgar Park | ||
4187 | 4187 | 4186 | {"type": "Polygon", "coordinates": [[[-117.95453, 33.79354], [-117.95368, 33.79353], [-117.95366, 33.79224], [-117.9545, 33.79224], [-117.95453, 33.79354]]]} | Open Access 1 | Faylane Park | 18859 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 2.785 | Faylane Park | ||
4485 | 4485 | 4484 | {"type": "Polygon", "coordinates": [[[-117.96845, 33.76476], [-117.96845, 33.76548], [-117.96805, 33.76552], [-117.96584, 33.76553], [-117.96585, 33.76371], [-117.96593, 33.76369], [-117.96597, 33.76366], [-117.96602, 33.76356], [-117.96601, 33.76349], [-117.96592, 33.76334], [-117.96591, 33.76276], [-117.96589, 33.75969], [-117.9659, 33.75965], [-117.96596, 33.7596], [-117.96667, 33.75958], [-117.96797, 33.75957], [-117.96815, 33.75957], [-117.96821, 33.75958], [-117.96823, 33.75961], [-117.96827, 33.76103], [-117.96826, 33.76304], [-117.96828, 33.76417], [-117.96827, 33.7646], [-117.96824, 33.76476], [-117.96821, 33.76484], [-117.96822, 33.76489], [-117.96829, 33.76493], [-117.96838, 33.76492], [-117.96841, 33.76485], [-117.96842, 33.76476], [-117.96845, 33.76476]]]} | Open Access 1 | Garden Grove Park | 19197 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 36.147 | Garden Grove Park | ||
4807 | 4807 | 4806 | {"type": "Polygon", "coordinates": [[[-117.97183, 33.79249], [-117.97103, 33.79199], [-117.97103, 33.79179], [-117.97112, 33.79177], [-117.97112, 33.79137], [-117.97181, 33.79137], [-117.97183, 33.79249]]]} | Open Access 1 | Gutosky Park | 19574 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1.639 | Gutosky Park | ||
6478 | 6478 | 6477 | {"type": "Polygon", "coordinates": [[[-117.9754, 33.79782], [-117.97538, 33.79784], [-117.97535, 33.79785], [-117.97515, 33.7978], [-117.97503, 33.79779], [-117.97413, 33.79779], [-117.9741, 33.79649], [-117.97479, 33.79616], [-117.97529, 33.79588], [-117.97536, 33.7959], [-117.97538, 33.79594], [-117.9754, 33.79782]]]} | Open Access 1 | Magnolia Park | 21678 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 5.274 | Magnolia Park | ||
8181 | 8181 | 8180 | {"type": "Polygon", "coordinates": [[[-117.91112, 33.78643], [-117.91106, 33.78645], [-117.91109, 33.78871], [-117.90944, 33.78872], [-117.90943, 33.78631], [-117.9105, 33.78629], [-117.9105, 33.78638], [-117.91112, 33.7864], [-117.91112, 33.78643]]]} | Open Access 1 | Pioneer Park | 23721 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 9.91 | Pioneer Park | ||
10504 | 10504 | 10503 | {"type": "Polygon", "coordinates": [[[-117.91021, 33.77886], [-117.91011, 33.77924], [-117.91002, 33.77937], [-117.90977, 33.77954], [-117.9095, 33.7796], [-117.90889, 33.77961], [-117.90812, 33.77958], [-117.90789, 33.77973], [-117.90756, 33.78034], [-117.90756, 33.78049], [-117.90749, 33.78065], [-117.90721, 33.78087], [-117.90695, 33.78105], [-117.90692, 33.78101], [-117.90711, 33.78078], [-117.90715, 33.78061], [-117.90716, 33.78047], [-117.90712, 33.78028], [-117.90711, 33.78008], [-117.90715, 33.77982], [-117.90744, 33.77959], [-117.90759, 33.7794], [-117.90764, 33.77924], [-117.90768, 33.7786], [-117.9078, 33.77847], [-117.90809, 33.77838], [-117.90888, 33.77832], [-117.90943, 33.77832], [-117.9097, 33.77835], [-117.91004, 33.77847], [-117.91017, 33.77868], [-117.91021, 33.77886]], [[-117.90851, 33.7789], [-117.90839, 33.77887], [-117.90829, 33.77893], [-117.90827, 33.77907], [-117.9082, 33.77927], [-117.90807, 33.77939], [-117.90808, 33.77948], [-117.90819, 33.77951], [-117.90833, 33.7795], [-117.90918, 33.77922], [-117.90928, 33.77911], [-117.90931, 33.77896], [-117.90922, 33.77888], [-117.909, 33.77891], [-117.90885, 33.77889], [-117.90871, 33.77881], [-117.9086, 33.77884], [-117.90851, 33.7789]]]} | Open Access 1 | Twin Lakes Park | 26618 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 7.922 | Twin Lakes Park | ||
10893 | 10893 | 10892 | {"type": "Polygon", "coordinates": [[[-117.94093, 33.77908], [-117.9409, 33.77909], [-117.94088, 33.77919], [-117.94084, 33.77929], [-117.94072, 33.77928], [-117.94037, 33.77891], [-117.93998, 33.77859], [-117.93998, 33.77856], [-117.93993, 33.77855], [-117.93965, 33.77834], [-117.93963, 33.77785], [-117.93954, 33.77784], [-117.93952, 33.77714], [-117.93944, 33.77712], [-117.93943, 33.777], [-117.94042, 33.77699], [-117.94043, 33.77688], [-117.94048, 33.77686], [-117.94048, 33.77642], [-117.94085, 33.77642], [-117.94087, 33.77777], [-117.94083, 33.77778], [-117.94083, 33.77788], [-117.94089, 33.7779], [-117.94089, 33.77808], [-117.94086, 33.7781], [-117.94086, 33.77825], [-117.94091, 33.77827], [-117.94093, 33.77908]]]} | Open Access 1 | Village Green Park | 27114 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 6.653 | Village Green Park | ||
11130 | 11130 | 11129 | {"type": "Polygon", "coordinates": [[[-118.03955, 33.77926], [-118.03949, 33.77996], [-118.0395, 33.78018], [-118.03948, 33.78023], [-118.03944, 33.78025], [-118.03728, 33.7811], [-118.03713, 33.78085], [-118.03694, 33.78063], [-118.03703, 33.78057], [-118.03845, 33.77935], [-118.03862, 33.77923], [-118.03875, 33.77919], [-118.03897, 33.77916], [-118.03952, 33.77922], [-118.03955, 33.77926]]]} | Open Access 1 | Westgrove Park | 27397 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 6.655 | Westgrove Park | ||
11132 | 11132 | 11131 | {"type": "Polygon", "coordinates": [[[-117.92355, 33.78525], [-117.92136, 33.78525], [-117.92136, 33.78342], [-117.92228, 33.78342], [-117.9223, 33.78344], [-117.92351, 33.78344], [-117.92355, 33.78525]]]} | Open Access 1 | Westhaven Park | 27399 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 10.016 | Westhaven Park | ||
11369 | 11369 | 11368 | {"type": "Polygon", "coordinates": [[[-117.93334, 33.76242], [-117.93165, 33.76243], [-117.93165, 33.76204], [-117.93194, 33.76203], [-117.93194, 33.76145], [-117.93242, 33.76144], [-117.93244, 33.76152], [-117.93332, 33.76151], [-117.93334, 33.76242]]]} | Open Access 1 | Woodbury Park | 27701 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 3.598 | Woodbury Park | ||
13614 | 13614 | 13613 | {"type": "Polygon", "coordinates": [[[-117.91151, 33.75859], [-117.91145, 33.75859], [-117.91144, 33.75857], [-117.91141, 33.75856], [-117.90784, 33.75858], [-117.90784, 33.75854], [-117.90788, 33.75851], [-117.90879, 33.7585], [-117.90885, 33.75851], [-117.9089, 33.75855], [-117.90895, 33.75855], [-117.90902, 33.75851], [-117.90909, 33.7585], [-117.9091, 33.75844], [-117.9095, 33.75843], [-117.9095, 33.75847], [-117.90952, 33.7585], [-117.90966, 33.75855], [-117.90972, 33.75854], [-117.90975, 33.7585], [-117.91142, 33.75849], [-117.91149, 33.75852], [-117.91151, 33.75854], [-117.91151, 33.75859]]]} | Open Access 1 | Jardín de Los Niños | 31077 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 0.684 | Jardín de Los Niños | ||
13629 | 13629 | 13628 | {"type": "Polygon", "coordinates": [[[-117.95895, 33.78192], [-117.95877, 33.78192], [-117.95878, 33.78147], [-117.95882, 33.78141], [-117.95886, 33.7814], [-117.95894, 33.7814], [-117.95895, 33.78192]]]} | Open Access 1 | Bicentennial Park | 31093 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 0.219 | Bicentennial Park | ||
15443 | 15443 | 15442 | {"type": "MultiPolygon", "coordinates": [[[[-117.9105, 33.77986], [-117.9082, 33.77989], [-117.9082, 33.78113], [-117.90717, 33.78114], [-117.90716, 33.78158], [-117.90636, 33.78158], [-117.90629, 33.78153], [-117.90631, 33.78046], [-117.90633, 33.78044], [-117.90632, 33.77987], [-117.90662, 33.77987], [-117.90723, 33.77934], [-117.90722, 33.77807], [-117.90968, 33.77807], [-117.91048, 33.77805], [-117.9105, 33.77986]], [[-117.90812, 33.77958], [-117.90889, 33.77961], [-117.9095, 33.7796], [-117.90977, 33.77954], [-117.91002, 33.77937], [-117.91011, 33.77924], [-117.91021, 33.77886], [-117.91017, 33.77868], [-117.91004, 33.77847], [-117.9097, 33.77835], [-117.90943, 33.77832], [-117.90888, 33.77832], [-117.9081, 33.77838], [-117.90779, 33.77847], [-117.90768, 33.7786], [-117.90764, 33.77924], [-117.90759, 33.7794], [-117.90744, 33.77959], [-117.90715, 33.77982], [-117.90711, 33.78008], [-117.90712, 33.78028], [-117.90716, 33.78047], [-117.90715, 33.78061], [-117.90712, 33.78078], [-117.90693, 33.781], [-117.90694, 33.78104], [-117.90721, 33.78087], [-117.90749, 33.78065], [-117.90756, 33.78049], [-117.90756, 33.78035], [-117.90789, 33.77973], [-117.90812, 33.77958]]], [[[-117.90931, 33.77895], [-117.90928, 33.77911], [-117.90919, 33.77921], [-117.90833, 33.7795], [-117.90819, 33.77951], [-117.90807, 33.77948], [-117.90807, 33.77939], [-117.9082, 33.77926], [-117.90827, 33.77907], [-117.90829, 33.77893], [-117.90839, 33.77887], [-117.90851, 33.7789], [-117.9086, 33.77884], [-117.90871, 33.77881], [-117.90885, 33.77889], [-117.909, 33.77891], [-117.90922, 33.77888], [-117.90931, 33.77895]]]]} | Open Access 1 | Haster Basin Recreational Park | 31078 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 14.519 | Haster Basin Recreational Park | ||
15544 | 15544 | 15543 | {"type": "MultiPolygon", "coordinates": [[[[-117.93816, 33.77732], [-117.93814, 33.77739], [-117.93761, 33.77765], [-117.9374, 33.77772], [-117.93719, 33.77775], [-117.93704, 33.77775], [-117.93705, 33.77751], [-117.93734, 33.77751], [-117.93735, 33.77746], [-117.93758, 33.77745], [-117.93759, 33.77739], [-117.93763, 33.77738], [-117.93763, 33.77715], [-117.93606, 33.77714], [-117.93518, 33.7771], [-117.93515, 33.77735], [-117.93443, 33.77735], [-117.93442, 33.77689], [-117.93712, 33.7769], [-117.93713, 33.7765], [-117.93698, 33.77648], [-117.93697, 33.77616], [-117.93771, 33.77615], [-117.93776, 33.77619], [-117.93781, 33.7765], [-117.93788, 33.77674], [-117.93798, 33.777], [-117.93816, 33.77732]]], [[[-117.93857, 33.77784], [-117.93824, 33.77785], [-117.93772, 33.77786], [-117.93827, 33.77759], [-117.93834, 33.7776], [-117.93857, 33.77784]]]]} | Open Access 1 | Civic Center Park | 17357 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 5.212 | Civic Ctr. Park |
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]);