superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where LAYER = 2 and MNG_AGENCY = 125
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
595 | 595 | 594 | {"type": "Polygon", "coordinates": [[[-117.75231, 34.05414], [-117.75118, 34.05418], [-117.75115, 34.05336], [-117.75228, 34.05333], [-117.75231, 34.05414]]]} | Open Access 1 | Civic Center Plaza | http://www.ci.pomona.ca.us/index.php/visitors/park-directory/306-no-menu-articles/1798-park-directory-no-menu | 32695 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 2.338 | Civic Ctr. Plaza | |
600 | 600 | 599 | {"type": "Polygon", "coordinates": [[[-117.74684, 34.02858], [-117.74645, 34.02859], [-117.74644, 34.02843], [-117.74684, 34.02842], [-117.74684, 34.02858]]]} | Open Access 1 | Esperanza y Alegria Park | 32693 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 0.165 | Esperanza y Alegria Park | 2018 | |
2805 | 2805 | 2804 | {"type": "Polygon", "coordinates": [[[-117.80383, 34.0575], [-117.80371, 34.05761], [-117.80339, 34.05727], [-117.80318, 34.05728], [-117.80281, 34.05758], [-117.80268, 34.05745], [-117.80259, 34.05745], [-117.80249, 34.05749], [-117.80199, 34.05733], [-117.80352, 34.05674], [-117.80383, 34.0575]]]} | Open Access 1 | Cesar Chavez Park | 17098 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1.755 | Cesar Chavez Park | ||
3233 | 3233 | 3232 | {"type": "MultiPolygon", "coordinates": [[[[-117.7751, 34.02875], [-117.77509, 34.02879], [-117.77491, 34.029], [-117.77482, 34.02901], [-117.7744, 34.0288], [-117.77395, 34.02862], [-117.77375, 34.02857], [-117.77352, 34.02853], [-117.77325, 34.02851], [-117.77301, 34.02852], [-117.77268, 34.02857], [-117.77237, 34.02867], [-117.77226, 34.02864], [-117.77215, 34.02845], [-117.77209, 34.02823], [-117.77208, 34.02808], [-117.7721, 34.02768], [-117.77259, 34.02784], [-117.77404, 34.02827], [-117.77437, 34.02839], [-117.77469, 34.02852], [-117.775, 34.02868], [-117.7751, 34.02875]]], [[[-117.78404, 34.03463], [-117.78377, 34.03536], [-117.784, 34.03541], [-117.78395, 34.0357], [-117.78399, 34.03572], [-117.78393, 34.03604], [-117.7836, 34.03605], [-117.78325, 34.03608], [-117.78238, 34.03626], [-117.78205, 34.03631], [-117.78166, 34.03633], [-117.78133, 34.03631], [-117.78131, 34.03629], [-117.78029, 34.03619], [-117.77979, 34.03609], [-117.77947, 34.03599], [-117.77917, 34.03587], [-117.77888, 34.03574], [-117.77866, 34.03561], [-117.77825, 34.03532], [-117.77807, 34.03516], [-117.77786, 34.03494], [-117.77756, 34.03455], [-117.77741, 34.0343], [-117.77731, 34.0341], [-117.7772, 34.03383], [-117.77712, 34.03351], [-117.77695, 34.03231], [-117.77696, 34.03228], [-117.77699, 34.03225], [-117.77717, 34.03223], [-117.77715, 34.0321], [-117.77697, 34.0321], [-117.77692, 34.03206], [-117.77685, 34.03163], [-117.77677, 34.03129], [-117.77665, 34.03096], [-117.77649, 34.03065], [-117.77626, 34.03028], [-117.77594, 34.02988], [-117.77573, 34.02967], [-117.77551, 34.02947], [-117.77508, 34.02916], [-117.77506, 34.02909], [-117.77524, 34.02889], [-117.77529, 34.02886], [-117.77533, 34.02888], [-117.77561, 34.02907], [-117.77599, 34.02938], [-117.77628, 34.02967], [-117.77657, 34.03001], [-117.77679, 34.03034], [-117.77694, 34.03061], [-117.77707, 34.03089], [-117.77717, 34.03117], [-117.77724, 34.03143], [-117.7773, 34.03172], [-117.77754, 34.03347], [-117.77761, 34.03376], [-117.7777, 34.034], [-117.7779, 34.03438], [-117.77819, 34.03476], [-117.7785, 34.03506], [-117.77891, 34.03535], [-117.77921, 34.03552], [-117.77947, 34.03563], [-117.77975, 34.03573], [-117.78003, 34.0358], [-117.7805, 34.03588], [-117.78175, 34.03598], [-117.78179, 34.03561], [-117.78163, 34.03551], [-117.78109, 34.03533], [-117.78088, 34.03504], [-117.78083, 34.03503], [-117.78083, 34.03496], [-117.78078, 34.03491], [-117.7808, 34.03487], [-117.78067, 34.03462], [-117.78035, 34.03457], [-117.78017, 34.03451], [-117.78001, 34.03444], [-117.77971, 34.03425], [-117.77947, 34.03404], [-117.77927, 34.03378], [-117.77911, 34.03351], [-117.77906, 34.03336], [-117.77923, 34.03327], [-117.7792, 34.03297], [-117.77928, 34.03293], [-117.77932, 34.03286], [-117.77931, 34.0328], [-117.77927, 34.03276], [-117.77948, 34.03254], [-117.77988, 34.03263], [-117.77997, 34.03229], [-117.78013, 34.03232], [-117.78017, 34.03286], [-117.78055, 34.03292], [-117.78058, 34.03288], [-117.78161, 34.03322], [-117.78198, 34.03326], [-117.78227, 34.03349], [-117.78259, 34.03359], [-117.78256, 34.03367], [-117.7819, 34.03345], [-117.78152, 34.03343], [-117.78139, 34.03358], [-117.7813, 34.03355], [-117.78121, 34.03357], [-117.78062, 34.03336], [-117.78059, 34.03343], [-117.78053, 34.03346], [-117.78049, 34.0335], [-117.78048, 34.03354], [-117.78048, 34.0337], [-117.78045, 34.03372], [-117.78049, 34.03379], [-117.78053, 34.03383], [-117.78076, 34.03394], [-117.78101, 34.0341], [-117.78159, 34.03462], [-117.78159, 34.03465], [-117.7817, 34.03484], [-117.7818, 34.03493], [-117.782, 34.03498], [-117.78208, 34.03504], [-117.78261, 34.03485], [-117.78325, 34.03483], [-117.7835, 34.03506], [-117.78365, 34.03478], [-117.78359, 34.03466], [-117.78369, 34.03464], [-117.78375, 34.03457], [-117.78404, 34.03463]]]]} | Open Access 1 | Country Crossing Park | 17696 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 31.48 | Country Crossing Park | ||
4064 | 4064 | 4063 | {"type": "Polygon", "coordinates": [[[-117.7344, 34.06396], [-117.73343, 34.06398], [-117.73339, 34.06293], [-117.7344, 34.06291], [-117.7344, 34.06396]]]} | Open Access 1 | Garfield Park | 19215 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 2.654 | Garfield Park | ||
4474 | 4474 | 4473 | {"type": "MultiPolygon", "coordinates": [[[[-117.76386, 34.07472], [-117.76357, 34.07497], [-117.76348, 34.0748], [-117.76309, 34.07504], [-117.76286, 34.07513], [-117.76221, 34.07512], [-117.76128, 34.07537], [-117.7607, 34.07539], [-117.76013, 34.07511], [-117.76003, 34.075], [-117.76004, 34.07496], [-117.75955, 34.07441], [-117.75953, 34.07405], [-117.75944, 34.07375], [-117.75933, 34.07354], [-117.75923, 34.07339], [-117.75889, 34.07303], [-117.75882, 34.07293], [-117.75877, 34.07277], [-117.75877, 34.07268], [-117.7588, 34.07257], [-117.7589, 34.07242], [-117.75933, 34.07201], [-117.75947, 34.07179], [-117.75954, 34.0716], [-117.75962, 34.07156], [-117.76058, 34.07146], [-117.76085, 34.07136], [-117.76115, 34.07128], [-117.76152, 34.07122], [-117.76178, 34.0712], [-117.76238, 34.07119], [-117.7624, 34.07133], [-117.76341, 34.07135], [-117.76336, 34.07216], [-117.76284, 34.07249], [-117.76247, 34.07247], [-117.76218, 34.07234], [-117.76216, 34.07235], [-117.76234, 34.0728], [-117.76264, 34.07401], [-117.76256, 34.07419], [-117.76313, 34.07436], [-117.76363, 34.07457], [-117.76386, 34.07472]]], [[[-117.76676, 34.08086], [-117.76673, 34.08091], [-117.76667, 34.08092], [-117.76648, 34.08083], [-117.76636, 34.08075], [-117.76578, 34.07998], [-117.7656, 34.07983], [-117.76543, 34.07971], [-117.76521, 34.0796], [-117.76449, 34.07933], [-117.76417, 34.07919], [-117.76182, 34.07796], [-117.76159, 34.07786], [-117.76123, 34.07766], [-117.76092, 34.0777], [-117.76022, 34.07773], [-117.7599, 34.07783], [-117.75978, 34.07724], [-117.75968, 34.0765], [-117.75961, 34.07572], [-117.75957, 34.07472], [-117.75989, 34.07506], [-117.75992, 34.07506], [-117.76005, 34.0752], [-117.76066, 34.0755], [-117.7613, 34.07548], [-117.7622, 34.07523], [-117.76289, 34.07524], [-117.76316, 34.07514], [-117.76343, 34.07497], [-117.76352, 34.07516], [-117.76401, 34.07476], [-117.76414, 34.07484], [-117.764, 34.07514], [-117.76323, 34.07571], [-117.76274, 34.07597], [-117.76221, 34.07693], [-117.76246, 34.07725], [-117.76304, 34.07841], [-117.76315, 34.07852], [-117.76325, 34.07856], [-117.76335, 34.07857], [-117.76343, 34.07856], [-117.76368, 34.07848], [-117.76377, 34.07848], [-117.76384, 34.07851], [-117.76391, 34.07858], [-117.76394, 34.0787], [-117.76398, 34.07877], [-117.76405, 34.07883], [-117.76414, 34.07888], [-117.7642, 34.07895], [-117.76424, 34.07902], [-117.76425, 34.07911], [-117.76436, 34.07911], [-117.76436, 34.07898], [-117.76452, 34.07893], [-117.76468, 34.07908], [-117.76519, 34.07903], [-117.76531, 34.07915], [-117.76567, 34.07919], [-117.76576, 34.07908], [-117.76588, 34.07915], [-117.76617, 34.07924], [-117.76635, 34.07984], [-117.76675, 34.08009], [-117.76676, 34.08086]]]]} | Open Access 1 | Ganesha Park | 19185 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 60.818 | Ganesha Park | ||
4857 | 4857 | 4856 | {"type": "Polygon", "coordinates": [[[-117.76432, 34.0611], [-117.76355, 34.06112], [-117.76353, 34.06077], [-117.76352, 34.06076], [-117.76352, 34.06047], [-117.76396, 34.06047], [-117.76397, 34.06075], [-117.76431, 34.06075], [-117.76432, 34.0611]]]} | Open Access 1 | Hamilton Park | 19621 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1.02 | Hamilton Park | ||
5553 | 5553 | 5552 | {"type": "Polygon", "coordinates": [[[-117.78764, 34.06767], [-117.78733, 34.06785], [-117.78491, 34.06836], [-117.78459, 34.06732], [-117.78755, 34.06674], [-117.78759, 34.06726], [-117.78764, 34.06767]]]} | Open Access 1 | John F. Kennedy Park | 20438 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 7.771 | John F. Kennedy Park | ||
5691 | 5691 | 5690 | {"type": "Polygon", "coordinates": [[[-117.80958, 34.05732], [-117.80923, 34.05769], [-117.80883, 34.05801], [-117.80842, 34.05824], [-117.80809, 34.05839], [-117.80786, 34.05847], [-117.80618, 34.05741], [-117.80655, 34.05711], [-117.80708, 34.0573], [-117.80711, 34.05746], [-117.80747, 34.05747], [-117.8082, 34.05789], [-117.80899, 34.05708], [-117.80907, 34.05715], [-117.80915, 34.05719], [-117.80924, 34.05719], [-117.80934, 34.05717], [-117.80958, 34.05732]]]} | Open Access 1 | Kellogg Park | 20583 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 4.934 | Kellogg Park | ||
5758 | 5758 | 5757 | {"type": "Polygon", "coordinates": [[[-117.77312, 34.06733], [-117.77161, 34.06764], [-117.77153, 34.0676], [-117.77068, 34.06778], [-117.77043, 34.06692], [-117.77064, 34.06704], [-117.7729, 34.06659], [-117.77312, 34.06733]]]} | Open Access 1 | Kiwanis Park | 20682 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 4.776 | Kiwanis Park | ||
6200 | 6200 | 6199 | {"type": "Polygon", "coordinates": [[[-117.74481, 34.0701], [-117.745, 34.06999], [-117.74522, 34.06993], [-117.74545, 34.06994], [-117.74556, 34.06997], [-117.74569, 34.07003], [-117.74586, 34.07016], [-117.74591, 34.07024], [-117.74596, 34.07035], [-117.74598, 34.07046], [-117.74598, 34.07056], [-117.74591, 34.07074], [-117.74584, 34.07083], [-117.74575, 34.07092], [-117.74561, 34.07099], [-117.74548, 34.07104], [-117.74533, 34.07105], [-117.74518, 34.07105], [-117.74505, 34.07101], [-117.74492, 34.07096], [-117.7448, 34.07087], [-117.74472, 34.07078], [-117.74466, 34.07065], [-117.74463, 34.07055], [-117.74463, 34.07043], [-117.74466, 34.07032], [-117.74473, 34.0702], [-117.74481, 34.0701]]]} | Open Access 1 | Lincoln Park | 21268 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 3.001 | Lincoln Park | ||
6732 | 6732 | 6731 | {"type": "Polygon", "coordinates": [[[-117.75793, 34.03661], [-117.75611, 34.03666], [-117.75606, 34.03555], [-117.75671, 34.03559], [-117.7579, 34.03557], [-117.75793, 34.03661]]]} | Open Access 1 | Martin Luther King, Jr. Park | 21920 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 4.89 | Martin Luther King, Jr. Park | ||
6918 | 6918 | 6917 | {"type": "Polygon", "coordinates": [[[-117.75657, 34.05757], [-117.75572, 34.05759], [-117.75569, 34.05688], [-117.75655, 34.05686], [-117.75657, 34.05757]]]} | Open Access 1 | Memorial Park | 22129 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1.561 | Memorial Park | ||
7170 | 7170 | 7169 | {"type": "Polygon", "coordinates": [[[-117.72152, 34.07416], [-117.72151, 34.0754], [-117.72053, 34.07541], [-117.72052, 34.07529], [-117.72046, 34.075], [-117.72046, 34.07416], [-117.72152, 34.07416]]]} | Open Access 1 | Montvue Park | 22444 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 3.285 | Montvue Park | ||
7892 | 7892 | 7891 | {"type": "Polygon", "coordinates": [[[-117.74378, 34.09014], [-117.74377, 34.09357], [-117.74328, 34.09363], [-117.74292, 34.09363], [-117.74288, 34.09318], [-117.74255, 34.09317], [-117.74251, 34.09319], [-117.74159, 34.0932], [-117.7416, 34.09015], [-117.74378, 34.09014]]]} | Open Access 1 | Palomares Park | 23368 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 17.709 | Palomares Park | ||
7949 | 7949 | 7948 | {"type": "Polygon", "coordinates": [[[-117.77156, 34.04612], [-117.76587, 34.04476], [-117.76552, 34.04462], [-117.76521, 34.04446], [-117.76488, 34.04424], [-117.7645, 34.0439], [-117.76436, 34.04383], [-117.76422, 34.04378], [-117.76445, 34.0437], [-117.76472, 34.04357], [-117.76488, 34.04352], [-117.76514, 34.0435], [-117.76538, 34.04355], [-117.76558, 34.04364], [-117.7658, 34.0438], [-117.76599, 34.04392], [-117.76629, 34.04406], [-117.76668, 34.04416], [-117.76724, 34.04422], [-117.76742, 34.04426], [-117.76758, 34.04433], [-117.76781, 34.04447], [-117.76801, 34.04463], [-117.76823, 34.04472], [-117.76833, 34.04478], [-117.76841, 34.0449], [-117.76844, 34.04503], [-117.76865, 34.04508], [-117.76889, 34.04508], [-117.76912, 34.04501], [-117.76925, 34.04493], [-117.76936, 34.04478], [-117.76944, 34.04474], [-117.76951, 34.04474], [-117.76962, 34.04477], [-117.76971, 34.04478], [-117.76984, 34.04475], [-117.76993, 34.04469], [-117.77001, 34.04466], [-117.77071, 34.04468], [-117.77081, 34.04466], [-117.77091, 34.04461], [-117.771, 34.04453], [-117.77106, 34.04446], [-117.77107, 34.04491], [-117.77111, 34.04497], [-117.77134, 34.04494], [-117.77152, 34.04494], [-117.77156, 34.04612]]]} | Restricted Access 2 | Palm Lake Golf Course | 33090 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 15.15 | Palm Lake GC | ||
8121 | 8121 | 8120 | {"type": "Polygon", "coordinates": [[[-117.74271, 34.03333], [-117.74213, 34.03334], [-117.7421, 34.03274], [-117.74161, 34.03274], [-117.74156, 34.03168], [-117.74265, 34.03166], [-117.74271, 34.03333]]]} | Open Access 1 | Philadelphia Park | 23641 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 3.826 | Philadelphia Park | ||
8123 | 8123 | 8122 | {"type": "Polygon", "coordinates": [[[-117.77257, 34.03335], [-117.77218, 34.0342], [-117.76985, 34.03472], [-117.76979, 34.03442], [-117.76978, 34.03397], [-117.77257, 34.03335]]]} | Open Access 1 | Phillips Ranch Park | 23643 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 4.995 | Phillips Ranch Park | ||
8293 | 8293 | 8292 | {"type": "Polygon", "coordinates": [[[-117.73663, 34.0799], [-117.73503, 34.0806], [-117.73455, 34.08078], [-117.73416, 34.0809], [-117.73416, 34.07946], [-117.7362, 34.07945], [-117.73663, 34.07948], [-117.73663, 34.0799]]]} | Open Access 1 | Pomona Jaycees Community Park | 23881 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 6.099 | Pomona Jaycees Community Park | ||
8382 | 8382 | 8381 | {"type": "Polygon", "coordinates": [[[-117.7553, 34.0299], [-117.75521, 34.03004], [-117.75505, 34.0302], [-117.75463, 34.03004], [-117.7549, 34.02966], [-117.75508, 34.02943], [-117.75521, 34.02954], [-117.75527, 34.02962], [-117.75529, 34.02972], [-117.7553, 34.0299]]]} | Open Access 1 | Powers Park | 23973 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 0.736 | Powers 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]);