superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 114 sorted by map
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10245 | 10245 | 10244 | {"type": "MultiPolygon", "coordinates": [[[[-117.89506, 33.66917], [-117.89502, 33.66945], [-117.89484, 33.66981], [-117.89453, 33.6701], [-117.89438, 33.67027], [-117.89424, 33.67046], [-117.89409, 33.67092], [-117.89407, 33.67114], [-117.89405, 33.67149], [-117.89236, 33.67151], [-117.89236, 33.67062], [-117.8927, 33.67059], [-117.89242, 33.66996], [-117.89277, 33.66984], [-117.89269, 33.66962], [-117.89279, 33.6695], [-117.89292, 33.6695], [-117.89292, 33.66924], [-117.89309, 33.66923], [-117.89309, 33.6691], [-117.89495, 33.66907], [-117.89506, 33.66917]]], [[[-117.8996, 33.67125], [-117.89837, 33.67127], [-117.89834, 33.67128], [-117.89831, 33.67133], [-117.89829, 33.67146], [-117.89432, 33.6715], [-117.89433, 33.67095], [-117.89438, 33.67073], [-117.89447, 33.67053], [-117.89464, 33.67028], [-117.8951, 33.66981], [-117.89518, 33.66968], [-117.89528, 33.66942], [-117.89532, 33.66918], [-117.89545, 33.66906], [-117.89958, 33.669], [-117.8996, 33.67125]]]]} | Open Access 1 | Te Winkle Park | 26208 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 40.986 | Te Winkle Park | ||
380 | 380 | 379 | {"type": "MultiPolygon", "coordinates": [[[[-117.9371, 33.6686], [-117.93478, 33.66862], [-117.93474, 33.66617], [-117.93453, 33.666], [-117.93434, 33.66577], [-117.93426, 33.66553], [-117.93425, 33.66529], [-117.93433, 33.66497], [-117.9345, 33.66461], [-117.93476, 33.66411], [-117.93485, 33.66379], [-117.93489, 33.66314], [-117.93476, 33.66312], [-117.93473, 33.66086], [-117.93497, 33.66095], [-117.93521, 33.66102], [-117.93618, 33.66122], [-117.93643, 33.66131], [-117.93665, 33.66142], [-117.93691, 33.66158], [-117.93716, 33.66179], [-117.93736, 33.66201], [-117.93752, 33.66224], [-117.93762, 33.6624], [-117.93772, 33.66267], [-117.93776, 33.66286], [-117.93777, 33.66485], [-117.93776, 33.66565], [-117.93773, 33.66589], [-117.93767, 33.66611], [-117.93755, 33.66638], [-117.93733, 33.66677], [-117.93716, 33.66716], [-117.9371, 33.66746], [-117.93709, 33.66788], [-117.9371, 33.6686]]], [[[-117.94524, 33.66565], [-117.94451, 33.66855], [-117.93744, 33.6686], [-117.93741, 33.66756], [-117.93743, 33.66739], [-117.93755, 33.66705], [-117.93791, 33.66635], [-117.93801, 33.6661], [-117.93807, 33.6659], [-117.93809, 33.66568], [-117.93811, 33.66544], [-117.93808, 33.66335], [-117.93808, 33.66306], [-117.93806, 33.66286], [-117.93791, 33.66239], [-117.93772, 33.66208], [-117.93756, 33.66186], [-117.93735, 33.66164], [-117.93691, 33.6613], [-117.93866, 33.66024], [-117.93867, 33.65964], [-117.94073, 33.65963], [-117.94071, 33.65784], [-117.94224, 33.65783], [-117.94357, 33.65784], [-117.94334, 33.66349], [-117.94295, 33.66519], [-117.94524, 33.66565]]]]} | Open Access 1 | Fairview Park | http://www.costamesaca.gov/index.aspx?page=247 | 2844 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 202.434 | Fairview Park | |
3534 | 3534 | 3533 | {"type": "Polygon", "coordinates": [[[-117.88005, 33.68343], [-117.88004, 33.68419], [-117.88001, 33.68423], [-117.87996, 33.68424], [-117.87885, 33.68425], [-117.87886, 33.68343], [-117.88005, 33.68343]]]} | Open Access 1 | Del Mesa Park | 18038 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 2.464 | Del Mesa Park | ||
13633 | 13633 | 13632 | {"type": "Polygon", "coordinates": [[[-117.89292, 33.66951], [-117.89279, 33.66951], [-117.89269, 33.66961], [-117.89278, 33.66984], [-117.89243, 33.66997], [-117.89271, 33.67061], [-117.89241, 33.67062], [-117.89239, 33.67015], [-117.89135, 33.67016], [-117.89223, 33.66934], [-117.89259, 33.66924], [-117.89292, 33.66924], [-117.89292, 33.66951]]]} | Open Access 1 | Bark Park | http://www.costamesaca.gov/index.aspx?page=1207 | 31103 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 2.243 | Bark Park | |
9591 | 9591 | 9590 | {"type": "Polygon", "coordinates": [[[-117.89382, 33.68704], [-117.89249, 33.68704], [-117.89243, 33.68687], [-117.89228, 33.68538], [-117.89228, 33.68471], [-117.89294, 33.68471], [-117.89296, 33.68543], [-117.89381, 33.68544], [-117.89381, 33.68569], [-117.89372, 33.68564], [-117.89352, 33.68565], [-117.89348, 33.68569], [-117.89347, 33.68584], [-117.89351, 33.6859], [-117.89356, 33.68592], [-117.89374, 33.68591], [-117.8938, 33.68586], [-117.89382, 33.68642], [-117.89372, 33.68637], [-117.89353, 33.68638], [-117.89348, 33.68644], [-117.89348, 33.68657], [-117.89352, 33.68664], [-117.89358, 33.68665], [-117.89374, 33.68664], [-117.89382, 33.68659], [-117.89382, 33.68704]]]} | Open Access 1 | Shiffer Park | 25410 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 6.728 | Shiffer Park | ||
2230 | 2230 | 2229 | {"type": "Polygon", "coordinates": [[[-117.89586, 33.65551], [-117.89554, 33.65584], [-117.89512, 33.65555], [-117.89446, 33.6562], [-117.89426, 33.65606], [-117.89521, 33.65512], [-117.89547, 33.65529], [-117.89575, 33.65543], [-117.89586, 33.65551]]]} | Open Access 1 | Brentwood Park | 16358 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1.395 | Brentwood Park | ||
10981 | 10981 | 10980 | {"type": "Polygon", "coordinates": [[[-117.9008, 33.69206], [-117.90077, 33.69208], [-117.90076, 33.69241], [-117.89863, 33.69242], [-117.89863, 33.69057], [-117.90077, 33.69059], [-117.9008, 33.69206]]]} | Open Access 1 | Wakeham Park | 27212 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 10.045 | Wakeham Park | ||
6214 | 6214 | 6213 | {"type": "Polygon", "coordinates": [[[-117.90107, 33.65222], [-117.90012, 33.65317], [-117.89899, 33.65237], [-117.90032, 33.65106], [-117.90067, 33.6513], [-117.9005, 33.65148], [-117.90057, 33.65155], [-117.90053, 33.65183], [-117.90107, 33.65222]]]} | Open Access 1 | Lindbergh Park | 21287 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 5.326 | Lindbergh Park | ||
5602 | 5602 | 5601 | {"type": "Polygon", "coordinates": [[[-117.90111, 33.64326], [-117.90042, 33.64395], [-117.8996, 33.64336], [-117.9003, 33.64266], [-117.90111, 33.64326]]]} | Open Access 1 | Jordan Park | 20490 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 2.483 | Jordan Park | ||
8033 | 8033 | 8032 | {"type": "Polygon", "coordinates": [[[-117.90125, 33.6842], [-117.90106, 33.6842], [-117.90105, 33.68448], [-117.90086, 33.68448], [-117.90086, 33.68422], [-117.90077, 33.68421], [-117.90076, 33.68247], [-117.90123, 33.68247], [-117.90125, 33.6842]]]} | Open Access 1 | Paularino Park | 23534 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 2.233 | Paularino Park | ||
11309 | 11309 | 11308 | {"type": "Polygon", "coordinates": [[[-117.9062, 33.69358], [-117.90623, 33.6938], [-117.90617, 33.69417], [-117.90608, 33.69433], [-117.90596, 33.69446], [-117.90579, 33.69458], [-117.90568, 33.69463], [-117.90541, 33.69469], [-117.9052, 33.69469], [-117.90518, 33.69441], [-117.90501, 33.69441], [-117.905, 33.69412], [-117.90509, 33.69404], [-117.90513, 33.69395], [-117.90511, 33.6932], [-117.90511, 33.69313], [-117.90515, 33.69306], [-117.9052, 33.69305], [-117.90535, 33.69307], [-117.90547, 33.69307], [-117.90549, 33.6934], [-117.90551, 33.69342], [-117.90568, 33.69342], [-117.90568, 33.69356], [-117.90571, 33.69358], [-117.9062, 33.69358]]]} | Open Access 1 | Wimbledon Park | 27615 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 3.327 | Wimbledon Park | ||
15540 | 15540 | 15539 | {"type": "Polygon", "coordinates": [[[-117.90689, 33.6632], [-117.90688, 33.66376], [-117.90604, 33.66374], [-117.90486, 33.66375], [-117.90486, 33.66326], [-117.90642, 33.66326], [-117.90644, 33.6632], [-117.90689, 33.6632]]]} | Open Access 1 | Civic Center Park | 17353 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 2.586 | Civic Ctr. Park | ||
2933 | 2933 | 2932 | {"type": "Polygon", "coordinates": [[[-117.90754, 33.67295], [-117.90754, 33.67441], [-117.90273, 33.67445], [-117.9027, 33.67296], [-117.90754, 33.67295]]]} | Open Access 1 | Farm Sports Complex | 18845 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 18.102 | Farm Sports Complex | ||
4914 | 4914 | 4913 | {"type": "Polygon", "coordinates": [[[-117.91056, 33.6321], [-117.91, 33.63265], [-117.90957, 33.63237], [-117.91011, 33.63178], [-117.91056, 33.6321]]]} | Open Access 1 | Harper Park | 19689 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1.045 | Harper Park | ||
4572 | 4572 | 4571 | {"type": "Polygon", "coordinates": [[[-117.91234, 33.68711], [-117.91234, 33.68758], [-117.91151, 33.68755], [-117.90816, 33.68727], [-117.90801, 33.68716], [-117.90801, 33.68702], [-117.90918, 33.68704], [-117.90918, 33.68713], [-117.90923, 33.68714], [-117.90926, 33.68705], [-117.91061, 33.68703], [-117.91061, 33.68712], [-117.91063, 33.68713], [-117.91066, 33.687], [-117.912, 33.68701], [-117.91202, 33.68711], [-117.91234, 33.68711]]]} | Open Access 1 | Gisler Park | 19303 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 4.357 | Gisler Park | ||
8163 | 8163 | 8162 | {"type": "Polygon", "coordinates": [[[-117.91502, 33.63059], [-117.91441, 33.6312], [-117.91347, 33.63056], [-117.9137, 33.63033], [-117.91372, 33.63034], [-117.9141, 33.62995], [-117.91502, 33.63059]]]} | Open Access 1 | Pinkley Park | 23698 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 2.465 | Pinkley Park | ||
11303 | 11303 | 11302 | {"type": "Polygon", "coordinates": [[[-117.91515, 33.65803], [-117.91463, 33.65803], [-117.91461, 33.6573], [-117.91415, 33.6573], [-117.91414, 33.65666], [-117.91411, 33.65664], [-117.9141, 33.65627], [-117.91513, 33.65627], [-117.91515, 33.65803]]]} | Open Access 1 | Wilson Park | 27608 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 3.641 | Wilson Park | ||
5020 | 5020 | 5019 | {"type": "Polygon", "coordinates": [[[-117.9211, 33.63125], [-117.9205, 33.63183], [-117.92012, 33.63158], [-117.9199, 33.6314], [-117.91952, 33.63113], [-117.92009, 33.63056], [-117.9211, 33.63125]]]} | Open Access 1 | Heller Park | 19806 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 2.521 | Heller Park | ||
5731 | 5731 | 5730 | {"type": "Polygon", "coordinates": [[[-117.92271, 33.6527], [-117.92269, 33.65297], [-117.92211, 33.65298], [-117.9221, 33.65274], [-117.92173, 33.65273], [-117.92171, 33.65261], [-117.92264, 33.65264], [-117.92271, 33.6527]]]} | Open Access 1 | Ketchum-Libolt Park | 20637 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 0.618 | Ketchum-Libolt Park | ||
6252 | 6252 | 6251 | {"type": "Polygon", "coordinates": [[[-117.9232, 33.64208], [-117.92122, 33.64211], [-117.9212, 33.63994], [-117.92319, 33.63992], [-117.9232, 33.64208]]]} | Open Access 1 | Lions Park | 21318 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 10.917 | Lions 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]);