units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 114 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12786 | 12786 | 12785 | {"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 | 30217 | Shalimar Park | 25353 | 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.179 | Shalimar Park | 0 | Local Park 2 | 4 | |
2994 | 2994 | 2993 | {"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 | 20095 | Suburbia Park | 25940 | 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.515 | Suburbia 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 | |
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 | |
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 | |
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 | |
287 | 287 | 286 | {"type": "Polygon", "coordinates": [[[-117.89292, 33.66951], [-117.89279, 33.6695], [-117.89269, 33.66962], [-117.89278, 33.66984], [-117.89242, 33.66996], [-117.89271, 33.67061], [-117.89241, 33.67062], [-117.8924, 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 | 47380 | Bark Park | 31103 | 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=1207 | Orange 3 | 2.234 | Bark 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
10766 | 10766 | 10765 | {"type": "Polygon", "coordinates": [[[-117.92531, 33.68344], [-117.92503, 33.68345], [-117.92498, 33.68337], [-117.92488, 33.68332], [-117.92475, 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 | 20079 | Smallwood Park | 25563 | 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 | 3.142 | Smallwood Park | 0 | Local Park 2 | 4 | |
10764 | 10764 | 10763 | {"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.6944], [-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.90548, 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 | 20075 | Wimbledon Park | 27615 | 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 | 3.324 | Wimbledon Park | 0 | Local Park 2 | 4 | |
10753 | 10753 | 10752 | {"type": "Polygon", "coordinates": [[[-117.91515, 33.65803], [-117.91463, 33.65803], [-117.91462, 33.6573], [-117.91415, 33.6573], [-117.91414, 33.65665], [-117.91411, 33.65664], [-117.9141, 33.65627], [-117.91513, 33.65627], [-117.91515, 33.65803]]]} | Open Access 1 | 20081 | Wilson Park | 27608 | 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 | 3.637 | Wilson Park | 0 | Local Park 2 | 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 | |
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 |
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]);