units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 114 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12780 | 12780 | 12779 | {"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.93477, 33.66411], [-117.93485, 33.66379], [-117.93489, 33.66313], [-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.94294, 33.66519], [-117.94524, 33.66565]]]]} | Open Access 1 | 30212 | Fairview Park | 2844 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=247 | Orange 3 | 202.397 | Fairview Park | 0 | Local Park 2 | 4 |
10767 | 10767 | 10766 | {"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 | 20080 | Brentwood Park | 16358 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 1.391 | Brentwood Park | 0 | Local Park 2 | 4 | |
8677 | 8677 | 8676 | {"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.93995, 33.6472], [-117.93958, 33.64674], [-117.93878, 33.64692], [-117.93835, 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.93777, 33.64667], [-117.93798, 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.6457], [-117.9409, 33.64553], [-117.94173, 33.64553], [-117.94174, 33.64781], [-117.94383, 33.64781], [-117.94388, 33.65053]]]} | Open Access 1 | 14007 | Canyon Park | 16823 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 35.363 | Canyon Park | 0 | Local Park 2 | 4 | |
11969 | 11969 | 11968 | {"type": "Polygon", "coordinates": [[[-117.90689, 33.6632], [-117.90688, 33.66376], [-117.90604, 33.66374], [-117.90486, 33.66375], [-117.90486, 33.66326], [-117.90643, 33.66326], [-117.90644, 33.6632], [-117.90689, 33.6632]]]} | Open Access 1 | 24587 | Civic Center Park | 17353 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 2.585 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
10765 | 10765 | 10764 | {"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 | 20076 | Del Mesa Park | 18038 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 2.464 | Del Mesa Park | 0 | Local Park 2 | 4 | |
5906 | 5906 | 5905 | {"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.9363, 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 | 361 | Estancia Park | 18720 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 8.831 | Estancia Park | 0 | Local Park 2 | 4 | |
12784 | 12784 | 12783 | {"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 | 30214 | Farm Sports Complex | 18845 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 18.104 | Farm Sports Complex | 0 | Local Recreation Area 3 | 4 | |
10762 | 10762 | 10761 | {"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.68714], [-117.90924, 33.68714], [-117.90926, 33.68705], [-117.91061, 33.68703], [-117.91061, 33.68712], [-117.91064, 33.68713], [-117.91066, 33.687], [-117.912, 33.68701], [-117.91201, 33.68711], [-117.91234, 33.68711]]]} | Open Access 1 | 20073 | Gisler Park | 19303 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 4.354 | Gisler Park | 0 | Local Park 2 | 4 | |
5069 | 5069 | 5068 | {"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 | 1393 | Harbor Rest Memorial Park | 19665 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 27.826 | Harbor Rest Memorial Park | 0 | Local Park 2 | 4 | |
766 | 766 | 765 | {"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 | 5657 | Harper Park | 19689 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 1.045 | Harper Park | 0 | Local Park 2 | 4 | |
2943 | 2943 | 2942 | {"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 | 20084 | Heller Park | 19806 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 2.521 | Heller Park | 0 | Local Park 2 | 4 | |
2519 | 2519 | 2518 | {"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 | 20092 | Jordan Park | 20490 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 2.484 | Jordan Park | 0 | Local Park 2 | 4 | |
3701 | 3701 | 3700 | {"type": "Polygon", "coordinates": [[[-117.92271, 33.6527], [-117.92269, 33.65297], [-117.92211, 33.65298], [-117.9221, 33.65273], [-117.92173, 33.65273], [-117.92171, 33.65261], [-117.92264, 33.65264], [-117.92271, 33.6527]]]} | Open Access 1 | 30215 | Ketchum-Libolt Park | 20637 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 0.616 | Ketchum-Libolt Park | 0 | Local Park 2 | 4 | |
12785 | 12785 | 12784 | {"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.90052, 33.65183], [-117.90107, 33.65222]]]} | Open Access 1 | 30216 | Lindbergh Park | 21287 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 5.324 | Lindbergh Park | 0 | Local Park 2 | 4 | |
5374 | 5374 | 5373 | {"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 | 5700 | Lions Park | 21318 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 10.919 | Lions Park | 0 | Local Park 2 | 4 | |
10768 | 10768 | 10767 | {"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.94195, 33.64278], [-117.94185, 33.64275], [-117.94156, 33.64278], [-117.94156, 33.64239], [-117.94317, 33.64238], [-117.94304, 33.64272], [-117.94331, 33.64275], [-117.94332, 33.64278]]]} | Open Access 1 | 20087 | Marina View Park | 21839 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 2.323 | Marina View Park | 0 | Local Park 2 | 4 | |
6797 | 6797 | 6796 | {"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 | 5306 | Mesa Verde Park | 22179 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 2.756 | Mesa Verde Park | 0 | Local Park 2 | 4 | |
2944 | 2944 | 2943 | {"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.93396, 33.69406], [-117.93399, 33.69402], [-117.93401, 33.69391], [-117.93472, 33.69366]]]} | Open Access 1 | 20094 | Moon Park | 22449 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 1.682 | Moon Park | 0 | Local Park 2 | 4 | |
7295 | 7295 | 7294 | {"type": "Polygon", "coordinates": [[[-117.90125, 33.6842], [-117.90105, 33.6842], [-117.90105, 33.68448], [-117.90086, 33.68448], [-117.90086, 33.68421], [-117.90077, 33.68421], [-117.90076, 33.68247], [-117.90123, 33.68247], [-117.90125, 33.6842]]]} | Open Access 1 | 8122 | Paularino Park | 23534 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 2.231 | Paularino Park | 0 | Local Park 2 | 4 | |
3555 | 3555 | 3554 | {"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 | 8521 | Pinkley Park | 23698 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 2.465 | Pinkley 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]);