units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17 rows where ACCESS_TYP = 1, AGNCY_LEV = 2 and MNG_AGENCY = 60
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Park 14
- Local Recreation Area 2
- None 1
MNG_AG_TYP 1
- City Agency 17
MNG_AGENCY 1
- Garden Grove, City of · 17 ✖
ACCESS_TYP 1
- Open Access · 17 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
153 | 153 | 152 | {"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 | 483 | Faylane Park | 18859 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 2.786 | Faylane Park | 0 | Local Park 2 | 4 | |
293 | 293 | 292 | {"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 | 47369 | Bicentennial Park | 31093 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 0.219 | Bicentennial Park | 0 | Local Park 2 | 4 | |
420 | 420 | 419 | {"type": "Polygon", "coordinates": [[[-117.97183, 33.79249], [-117.97103, 33.79199], [-117.97103, 33.79179], [-117.97112, 33.79178], [-117.97112, 33.79137], [-117.97181, 33.79137], [-117.97183, 33.79249]]]} | Open Access 1 | 1294 | Gutosky Park | 19574 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 1.639 | Gutosky Park | 0 | Local Park 2 | 4 | |
1021 | 1021 | 1020 | {"type": "Polygon", "coordinates": [[[-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], [-118.03472, 33.78907], [-118.03341, 33.78895], [-118.03335, 33.78892], [-118.03333, 33.78888], [-118.03336, 33.78839], [-118.03332, 33.78795], [-118.03334, 33.78789], [-118.03339, 33.78787], [-118.03471, 33.78771]]]} | Open Access 1 | 5638 | Eastgate Park | 18393 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 4.635 | Eastgate Park | 0 | Local Park 2 | 4 | |
1915 | 1915 | 1914 | {"type": "MultiPolygon", "coordinates": [[[[-117.9105, 33.77986], [-117.90819, 33.77988], [-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.78045], [-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.90809, 33.77838], [-117.9078, 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.78101], [-117.90695, 33.78105], [-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.77927], [-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 | 14867 | Haster Basin Recreational Park | 31078 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 14.494 | Haster Basin Recreational Park | 0 | Local Recreation Area 3 | 4 | |
2025 | 2025 | 2024 | {"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.93243, 33.76152], [-117.93332, 33.76151], [-117.93334, 33.76242]]]} | Open Access 1 | 15468 | Woodbury Park | 27701 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 3.596 | Woodbury Park | 0 | Local Park 2 | 4 | |
6044 | 6044 | 6043 | {"type": "Polygon", "coordinates": [[[-117.91151, 33.7586], [-117.91145, 33.75859], [-117.91145, 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.7586]]]} | Open Access 1 | 47357 | Jardín de Los Niños | 31077 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 0.684 | Jardín de Los Niños | None 488 | |||
6074 | 6074 | 6073 | {"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.76277], [-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.96839, 33.76492], [-117.96841, 33.76485], [-117.96842, 33.76476], [-117.96845, 33.76476]]]} | Open Access 1 | 820 | Garden Grove Park | 19197 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 36.146 | Garden Grove Park | 0 | Local Park 2 | 4 | |
6695 | 6695 | 6694 | {"type": "Polygon", "coordinates": [[[-117.97529, 33.79588], [-117.97536, 33.7959], [-117.97538, 33.79594], [-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]]]} | Open Access 1 | 4975 | Magnolia Park | 21678 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 5.275 | Magnolia Park | 0 | Local Park 2 | 4 | |
6908 | 6908 | 6907 | {"type": "Polygon", "coordinates": [[[-117.91112, 33.78643], [-117.91106, 33.78644], [-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 | 5760 | Pioneer Park | 23721 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 9.909 | Pioneer Park | 0 | Local Park 2 | 4 | |
9201 | 9201 | 9200 | {"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 | 15293 | Westgrove Park | 27397 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 6.655 | Westgrove Park | 0 | Local Park 2 | 4 | |
10605 | 10605 | 10604 | {"type": "Polygon", "coordinates": [[[-118.02716, 33.77607], [-118.02715, 33.77847], [-118.02713, 33.77851], [-118.02649, 33.77851], [-118.02652, 33.77704], [-118.02563, 33.77703], [-118.02407, 33.77705], [-118.02407, 33.77607], [-118.02716, 33.77607]]]} | Open Access 1 | 18942 | Edgar Park | 18433 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 10.025 | Edgar Park | 0 | Local Park 2 | 4 | |
11968 | 11968 | 11967 | {"type": "Polygon", "coordinates": [[[-118.01094, 33.78847], [-118.01094, 33.78949], [-118.0097, 33.78947], [-118.00969, 33.78966], [-118.0091, 33.78965], [-118.00908, 33.79057], [-118.00892, 33.79059], [-118.00893, 33.79107], [-118.00771, 33.79106], [-118.00771, 33.78841], [-118.01085, 33.78839], [-118.01094, 33.78847]]]} | Open Access 1 | 24589 | Chapman Sports Park | 17134 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 14.513 | Chapman Sports Park | 0 | Local Recreation Area 3 | 4 | |
11970 | 11970 | 11969 | {"type": "Polygon", "coordinates": [[[-117.92355, 33.78525], [-117.92136, 33.78525], [-117.92136, 33.78342], [-117.92228, 33.78342], [-117.92229, 33.78344], [-117.92351, 33.78344], [-117.92355, 33.78525]]]} | Open Access 1 | 24590 | Westhaven Park | 27399 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 10.017 | Westhaven Park | 0 | Local Park 2 | 4 | |
12891 | 12891 | 12890 | {"type": "Polygon", "coordinates": [[[-117.94093, 33.77908], [-117.9409, 33.77908], [-117.94088, 33.77918], [-117.94084, 33.77929], [-117.94072, 33.77928], [-117.94037, 33.77891], [-117.93998, 33.77859], [-117.93998, 33.77855], [-117.93993, 33.77855], [-117.93965, 33.77834], [-117.93963, 33.77784], [-117.93954, 33.77784], [-117.93952, 33.77713], [-117.93944, 33.77712], [-117.93943, 33.777], [-117.94042, 33.77699], [-117.94043, 33.77688], [-117.94048, 33.77687], [-117.94048, 33.77642], [-117.94085, 33.77642], [-117.94087, 33.77777], [-117.94083, 33.77778], [-117.94083, 33.77789], [-117.94089, 33.7779], [-117.94089, 33.77808], [-117.94086, 33.77809], [-117.94086, 33.77826], [-117.94091, 33.77827], [-117.94093, 33.77908]]]} | Open Access 1 | 30349 | Village Green Park | 27114 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 6.647 | Village Green Park | 0 | Local Park 2 | 4 | |
12975 | 12975 | 12974 | {"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.93517, 33.7771], [-117.93515, 33.77735], [-117.93443, 33.77735], [-117.93442, 33.77689], [-117.93713, 33.7769], [-117.93713, 33.77649], [-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 | 30453 | Civic Center Park | 17357 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 5.195 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
12980 | 12980 | 12979 | {"type": "Polygon", "coordinates": [[[-117.91004, 33.77847], [-117.91017, 33.77868], [-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.77974], [-117.90756, 33.78035], [-117.90756, 33.78049], [-117.90749, 33.78065], [-117.90721, 33.78087], [-117.90695, 33.78105], [-117.90692, 33.78101], [-117.90712, 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.9085, 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.90919, 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.9085, 33.7789]]]} | Open Access 1 | 30452 | Twin Lakes Park | 26618 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 7.917 | Twin Lakes 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]);