units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 114
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
12783 | 12783 | 12782 | {"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.92837, 33.66356], [-117.92773, 33.66339], [-117.92855, 33.66129], [-117.92855, 33.66091], [-117.92852, 33.66079], [-117.92846, 33.66068], [-117.92838, 33.66059], [-117.92826, 33.66047], [-117.92805, 33.66034], [-117.92801, 33.66028], [-117.92781, 33.66029], [-117.92391, 33.65934], [-117.92331, 33.65933], [-117.92288, 33.6595], [-117.9227, 33.65963], [-117.92122, 33.66345], [-117.92117, 33.66352], [-117.92111, 33.6636], [-117.92105, 33.66365], [-117.92095, 33.66369], [-117.92085, 33.6637], [-117.92035, 33.66362], [-117.91985, 33.66334], [-117.91972, 33.66324], [-117.91959, 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.66032], [-117.93417, 33.66057], [-117.93451, 33.66076], [-117.93473, 33.66086], [-117.93476, 33.66311], [-117.93489, 33.66312]]]} | Restricted Access 2 | 30213 | Golf and Country Club | 33096 | 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 | 239.277 | Golf and Country Club | 0 | Local Recreation Area 3 | 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 | |
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 | |
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 | |
12787 | 12787 | 12786 | {"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.65107], [-117.94969, 33.6509]]]} | Open Access 1 | 30218 | Vista Park | 27181 | 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 | 6.041 | Vista 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]);