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 descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10947 | 10947 | 10946 | {"type": "Polygon", "coordinates": [[[-117.94969, 33.6509], [-117.94959, 33.6521], [-117.94949, 33.65231], [-117.94736, 33.65233], [-117.94732, 33.65228], [-117.94726, 33.65226], [-117.94726, 33.65187], [-117.94811, 33.65141], [-117.94841, 33.65127], [-117.94899, 33.65106], [-117.94969, 33.6509]]]} | Open Access 1 | Vista Park | 27181 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 6.04 | Vista Park | ||
2600 | 2600 | 2599 | {"type": "Polygon", "coordinates": [[[-117.94388, 33.65053], [-117.94298, 33.65055], [-117.94297, 33.64956], [-117.94221, 33.64903], [-117.94242, 33.64852], [-117.94219, 33.64805], [-117.94197, 33.64801], [-117.94124, 33.64827], [-117.93923, 33.6483], [-117.93923, 33.64781], [-117.93994, 33.6472], [-117.93958, 33.64674], [-117.93878, 33.64692], [-117.93836, 33.64726], [-117.93812, 33.64802], [-117.93748, 33.64796], [-117.93643, 33.64778], [-117.93643, 33.64733], [-117.93741, 33.64732], [-117.93742, 33.64661], [-117.93774, 33.64661], [-117.93778, 33.64667], [-117.93797, 33.64664], [-117.93798, 33.64661], [-117.93818, 33.6466], [-117.93816, 33.64589], [-117.93925, 33.64587], [-117.93924, 33.64524], [-117.93875, 33.64428], [-117.93875, 33.64414], [-117.93984, 33.64411], [-117.93984, 33.64505], [-117.94018, 33.64569], [-117.9409, 33.64553], [-117.94173, 33.64553], [-117.94174, 33.64781], [-117.94383, 33.64781], [-117.94388, 33.65053]]]} | Open Access 1 | Canyon Park | 16823 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 35.417 | Canyon Park | ||
6656 | 6656 | 6655 | {"type": "Polygon", "coordinates": [[[-117.94332, 33.64278], [-117.94304, 33.64276], [-117.94312, 33.64316], [-117.94235, 33.64317], [-117.94234, 33.64285], [-117.94201, 33.64285], [-117.94194, 33.64278], [-117.94185, 33.64275], [-117.94156, 33.64278], [-117.94156, 33.64239], [-117.94317, 33.64238], [-117.94304, 33.64271], [-117.94331, 33.64275], [-117.94332, 33.64278]]]} | Open Access 1 | Marina View Park | 21839 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 2.332 | Marina View Park | ||
4059 | 4059 | 4058 | {"type": "Polygon", "coordinates": [[[-117.9385, 33.67267], [-117.93847, 33.67503], [-117.93841, 33.67502], [-117.93789, 33.67429], [-117.93753, 33.67395], [-117.93727, 33.67379], [-117.93692, 33.6736], [-117.93658, 33.67352], [-117.93629, 33.67352], [-117.93586, 33.6736], [-117.93572, 33.67329], [-117.93563, 33.67307], [-117.93559, 33.67289], [-117.93558, 33.67274], [-117.93563, 33.67273], [-117.93565, 33.67268], [-117.9385, 33.67267]]]} | Open Access 1 | Estancia Park | 18720 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 8.832 | Estancia Park | ||
8527 | 8527 | 8526 | {"type": "Polygon", "coordinates": [[[-117.9364, 33.69109], [-117.93599, 33.69171], [-117.93587, 33.69157], [-117.93559, 33.69172], [-117.93551, 33.69166], [-117.93541, 33.69167], [-117.93579, 33.69145], [-117.93609, 33.69122], [-117.93629, 33.69102], [-117.93637, 33.69105], [-117.9364, 33.69109]]]} | Open Access 1 | Suburbia Park | 25940 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 0.517 | Suburbia Park | ||
13162 | 13162 | 13161 | {"type": "Polygon", "coordinates": [[[-117.93489, 33.66312], [-117.93485, 33.66379], [-117.93477, 33.66411], [-117.9345, 33.66461], [-117.93433, 33.66497], [-117.93425, 33.66529], [-117.93426, 33.66553], [-117.93434, 33.66577], [-117.93453, 33.666], [-117.93474, 33.66616], [-117.93478, 33.66862], [-117.92476, 33.6687], [-117.92473, 33.66822], [-117.92475, 33.66793], [-117.92484, 33.66736], [-117.92489, 33.6672], [-117.92497, 33.66701], [-117.92513, 33.66676], [-117.92522, 33.66666], [-117.92542, 33.66648], [-117.92548, 33.66643], [-117.92616, 33.66626], [-117.92641, 33.66623], [-117.92763, 33.666], [-117.92836, 33.66592], [-117.92909, 33.66525], [-117.92957, 33.66396], [-117.92835, 33.66366], [-117.92836, 33.66356], [-117.92773, 33.66339], [-117.92855, 33.66129], [-117.92855, 33.66091], [-117.92852, 33.66079], [-117.92847, 33.66068], [-117.92838, 33.66059], [-117.92826, 33.66047], [-117.92805, 33.66034], [-117.928, 33.66028], [-117.92781, 33.66029], [-117.92391, 33.65934], [-117.9233, 33.65933], [-117.92289, 33.6595], [-117.9227, 33.65963], [-117.92122, 33.66345], [-117.92117, 33.66352], [-117.92111, 33.6636], [-117.92104, 33.66365], [-117.92095, 33.66369], [-117.92085, 33.6637], [-117.92035, 33.66362], [-117.91985, 33.66334], [-117.91972, 33.66323], [-117.91958, 33.66319], [-117.91947, 33.66318], [-117.91935, 33.6632], [-117.9193, 33.658], [-117.93043, 33.65793], [-117.93046, 33.6587], [-117.9315, 33.65867], [-117.93263, 33.66], [-117.9333, 33.65962], [-117.93389, 33.66033], [-117.93417, 33.66057], [-117.93451, 33.66076], [-117.93473, 33.66086], [-117.93476, 33.6631], [-117.93489, 33.66312]]]} | Restricted Access 2 | Golf and Country Club | 33096 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 239.306 | Golf and Country Club | ||
7178 | 7178 | 7177 | {"type": "Polygon", "coordinates": [[[-117.93472, 33.69366], [-117.93397, 33.69474], [-117.93286, 33.69432], [-117.93313, 33.69422], [-117.93323, 33.69429], [-117.93332, 33.6943], [-117.93356, 33.69417], [-117.93373, 33.69412], [-117.93387, 33.69411], [-117.93399, 33.69402], [-117.93401, 33.69391], [-117.93472, 33.69366]]]} | Open Access 1 | Moon Park | 22449 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1.684 | Moon Park | ||
6946 | 6946 | 6945 | {"type": "Polygon", "coordinates": [[[-117.93311, 33.67525], [-117.93289, 33.67546], [-117.93278, 33.67564], [-117.93273, 33.67568], [-117.93241, 33.6756], [-117.93223, 33.67557], [-117.93019, 33.67538], [-117.93014, 33.67536], [-117.93022, 33.67502], [-117.93065, 33.67501], [-117.9312, 33.67508], [-117.93228, 33.67519], [-117.93311, 33.67525]]]} | Open Access 1 | Mesa Verde Park | 22179 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 2.756 | Mesa Verde Park | ||
1192 | 1192 | 1191 | {"type": "Polygon", "coordinates": [[[-117.93128, 33.63885], [-117.9311, 33.63884], [-117.9311, 33.63844], [-117.93127, 33.63844], [-117.93128, 33.63885]]]} | Open Access 1 | Shalimar Park | 25353 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 0.179 | Shalimar Park | ||
10220 | 10220 | 10219 | {"type": "Polygon", "coordinates": [[[-117.92995, 33.67064], [-117.92995, 33.67067], [-117.92989, 33.6707], [-117.92974, 33.67077], [-117.92949, 33.67085], [-117.92907, 33.67085], [-117.92906, 33.67093], [-117.92817, 33.67094], [-117.92814, 33.66884], [-117.92882, 33.66884], [-117.9289, 33.66887], [-117.92917, 33.66905], [-117.92942, 33.66912], [-117.92946, 33.6695], [-117.92956, 33.66991], [-117.92967, 33.67017], [-117.92978, 33.67038], [-117.92995, 33.67064]]]} | Open Access 1 | Tanager Park | 26178 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 7.314 | Tanager Park | ||
4853 | 4853 | 4852 | {"type": "Polygon", "coordinates": [[[-117.92536, 33.68693], [-117.92049, 33.68692], [-117.92045, 33.68687], [-117.92044, 33.68679], [-117.92043, 33.6847], [-117.92533, 33.68468], [-117.92533, 33.68494], [-117.92536, 33.68693]]]} | Open Access 1 | Harbor Rest Memorial Park | 19665 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 27.822 | Harbor Rest Memorial Park | ||
9739 | 9739 | 9738 | {"type": "Polygon", "coordinates": [[[-117.92531, 33.68344], [-117.92503, 33.68345], [-117.92498, 33.68337], [-117.92487, 33.68332], [-117.92476, 33.68332], [-117.92467, 33.68334], [-117.92447, 33.68333], [-117.92445, 33.68309], [-117.92444, 33.68194], [-117.92531, 33.68194], [-117.92531, 33.68344]]]} | Open Access 1 | Smallwood Park | 25563 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 3.142 | Smallwood 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);