units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where MNG_AGENCY = 125 and MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17051 | 17051 | 17050 | {"type": "Polygon", "coordinates": [[[-117.74578, 34.02877], [-117.74542, 34.02878], [-117.74539, 34.02875], [-117.74539, 34.02862], [-117.74577, 34.02861], [-117.74578, 34.02877]]]} | Restricted Access 2 | 46518 | Renacimiento Community Center | 29805 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/81-renacimiento-community-center | Los Angeles 6 | 0.157 | Renacimiento Community Ctr. | 0 | Local Recreation Area 3 | 4 |
17030 | 17030 | 17029 | {"type": "Polygon", "coordinates": [[[-117.75231, 34.05415], [-117.75118, 34.05418], [-117.75115, 34.05336], [-117.75228, 34.05333], [-117.75231, 34.05415]]]} | Open Access 1 | 48157 | Civic Center Plaza | 32695 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://www.ci.pomona.ca.us/index.php/visitors/park-directory/306-no-menu-articles/1798-park-directory-no-menu | Los Angeles 6 | 2.339 | Civic Ctr. Plaza | 0 | Local Park 2 | 4 |
15711 | 15711 | 15710 | {"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.04391], [-117.76436, 34.04383], [-117.76422, 34.04378], [-117.76445, 34.0437], [-117.76472, 34.04357], [-117.76489, 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.7708, 34.04466], [-117.77091, 34.04461], [-117.771, 34.04453], [-117.77106, 34.04446], [-117.77107, 34.04492], [-117.77111, 34.04498], [-117.77134, 34.04494], [-117.77152, 34.04494], [-117.77156, 34.04612]]]} | Restricted Access 2 | 28355 | Palm Lake Golf Course | 33090 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 15.151 | Palm Lake GC | 0 | Local Recreation Area 3 | 4 | |
15337 | 15337 | 15336 | {"type": "Polygon", "coordinates": [[[-117.74783, 34.05789], [-117.74741, 34.0579], [-117.74739, 34.05748], [-117.74782, 34.05747], [-117.74783, 34.05789]]]} | Open Access 1 | 46519 | Centennial Park | 29806 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/60-centennial-park | Los Angeles 6 | 0.461 | Centennial Park | 0 | Local Park 2 | 4 |
14601 | 14601 | 14600 | {"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.06727], [-117.78764, 34.06767]]]} | Open Access 1 | 44819 | John F. Kennedy Park | 20438 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 7.771 | John F. Kennedy Park | 0 | Local Park 2 | 4 | |
10832 | 10832 | 10831 | {"type": "Polygon", "coordinates": [[[-117.75793, 34.03661], [-117.75611, 34.03666], [-117.75606, 34.03555], [-117.7567, 34.03559], [-117.7579, 34.03557], [-117.75793, 34.03661]]]} | Open Access 1 | 20558 | Martin Luther King, Jr. Park | 21920 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 4.891 | Martin Luther King, Jr. Park | 0 | Local Park 2 | 4 | |
10831 | 10831 | 10830 | {"type": "MultiPolygon", "coordinates": [[[[-117.77491, 34.029], [-117.77482, 34.02901], [-117.7744, 34.0288], [-117.77394, 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.02865], [-117.77215, 34.02846], [-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.77509, 34.02879], [-117.77491, 34.029]]], [[[-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.78132, 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.03209], [-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.02887], [-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.03599], [-117.7818, 34.03561], [-117.78163, 34.03551], [-117.78109, 34.03533], [-117.78087, 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.03294], [-117.77932, 34.03286], [-117.77931, 34.0328], [-117.77927, 34.03276], [-117.77948, 34.03254], [-117.77988, 34.03264], [-117.77997, 34.03229], [-117.78013, 34.03232], [-117.78017, 34.03285], [-117.78055, 34.03293], [-117.78057, 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.78061, 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.03371], [-117.78048, 34.03379], [-117.78053, 34.03383], [-117.78076, 34.03394], [-117.78101, 34.0341], [-117.78159, 34.03462], [-117.78158, 34.03465], [-117.7817, 34.03484], [-117.7818, 34.03493], [-117.782, 34.03498], [-117.78207, 34.03504], [-117.78261, 34.03485], [-117.78325, 34.03483], [-117.78351, 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 | 20557 | Country Crossing Park | 17696 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 31.442 | Country Crossing Park | 0 | Local Park 2 | 4 | |
10820 | 10820 | 10819 | {"type": "Polygon", "coordinates": [[[-117.74724, 34.08286], [-117.7463, 34.08461], [-117.74534, 34.08428], [-117.74633, 34.08224], [-117.74724, 34.08286]]]} | Open Access 1 | 20552 | Ted Greene Park | 26214 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 5.66 | Ted Greene Park | 0 | Local Park 2 | 4 | |
10819 | 10819 | 10818 | {"type": "MultiPolygon", "coordinates": [[[[-117.76386, 34.07472], [-117.76357, 34.07497], [-117.76349, 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.76005, 34.07497], [-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.76239, 34.07133], [-117.76341, 34.07135], [-117.76336, 34.07216], [-117.76284, 34.07249], [-117.76247, 34.07247], [-117.76218, 34.07233], [-117.76216, 34.07234], [-117.76234, 34.0728], [-117.76264, 34.07401], [-117.76255, 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.76122, 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.07507], [-117.75992, 34.07506], [-117.76005, 34.0752], [-117.76066, 34.0755], [-117.76129, 34.07548], [-117.7622, 34.07523], [-117.76289, 34.07524], [-117.76316, 34.07514], [-117.76343, 34.07497], [-117.76351, 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.07692], [-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.76424, 34.07911], [-117.76436, 34.07911], [-117.76436, 34.07898], [-117.76452, 34.07893], [-117.76468, 34.07908], [-117.76519, 34.07903], [-117.7653, 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 | 20551 | Ganesha Park | 19185 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 60.795 | Ganesha Park | 0 | Local Park 2 | 4 | |
10740 | 10740 | 10739 | {"type": "Polygon", "coordinates": [[[-117.74271, 34.03333], [-117.74213, 34.03334], [-117.7421, 34.03273], [-117.74161, 34.03274], [-117.74156, 34.03168], [-117.74265, 34.03166], [-117.74271, 34.03333]]]} | Open Access 1 | 20559 | Philadelphia Park | 23641 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 3.823 | Philadelphia Park | 0 | Local Park 2 | 4 | |
9174 | 9174 | 9173 | {"type": "Polygon", "coordinates": [[[-117.76727, 34.05089], [-117.76725, 34.05092], [-117.76721, 34.05094], [-117.76519, 34.05099], [-117.76513, 34.04928], [-117.76679, 34.04924], [-117.76705, 34.04934], [-117.76719, 34.04933], [-117.7672, 34.04938], [-117.76721, 34.04939], [-117.76727, 34.05089]]]} | Open Access 1 | 15228 | Welch Park | 27338 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 8.892 | Welch Park | 0 | Local Park 2 | 4 | |
9160 | 9160 | 9159 | {"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 | 15209 | Kiwanis Park | 20682 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 4.775 | Kiwanis Park | 0 | Local Park 2 | 4 | |
8483 | 8483 | 8482 | {"type": "Polygon", "coordinates": [[[-117.78412, 34.04819], [-117.78399, 34.04952], [-117.78397, 34.04954], [-117.78394, 34.04955], [-117.78238, 34.04949], [-117.78234, 34.04807], [-117.78412, 34.04819]]]} | Open Access 1 | 15304 | Westmont Park | 27410 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 5.976 | Westmont Park | 0 | Local Park 2 | 4 | |
7783 | 7783 | 7782 | {"type": "Polygon", "coordinates": [[[-117.73663, 34.0799], [-117.73503, 34.08061], [-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 | 8761 | Pomona Jaycees Community Park | 23881 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 6.101 | Pomona Jaycees Community Park | 0 | Local Park 2 | 4 | |
7678 | 7678 | 7677 | {"type": "Polygon", "coordinates": [[[-117.74378, 34.09014], [-117.74377, 34.09357], [-117.74328, 34.09363], [-117.74292, 34.09363], [-117.74289, 34.09318], [-117.74254, 34.09317], [-117.74251, 34.09319], [-117.74159, 34.0932], [-117.7416, 34.09015], [-117.74378, 34.09014]]]} | Open Access 1 | 7603 | Palomares Park | 23368 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 17.705 | Palomares Park | 0 | Local Park 2 | 4 | |
6929 | 6929 | 6928 | {"type": "Polygon", "coordinates": [[[-117.74092, 34.04896], [-117.74039, 34.04898], [-117.74042, 34.04989], [-117.74003, 34.0499], [-117.74004, 34.05021], [-117.74002, 34.05029], [-117.73897, 34.05028], [-117.73847, 34.05044], [-117.73793, 34.05046], [-117.73785, 34.05051], [-117.73787, 34.05087], [-117.73694, 34.05089], [-117.73685, 34.04829], [-117.74089, 34.04819], [-117.74092, 34.04896]]]} | Open Access 1 | 5825 | Washington Park | 27277 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 20.529 | Washington Park | 0 | Local Park 2 | 4 | |
6881 | 6881 | 6880 | {"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 | 5604 | Memorial Park | 22129 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 1.562 | Memorial Park | 0 | Local Park 2 | 4 | |
6836 | 6836 | 6835 | {"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 | 5458 | Montvue Park | 22444 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 3.286 | Montvue Park | 0 | Local Park 2 | 4 | |
6523 | 6523 | 6522 | {"type": "Polygon", "coordinates": [[[-117.80958, 34.05732], [-117.80924, 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.0572], [-117.80934, 34.05717], [-117.80958, 34.05732]]]} | Open Access 1 | 2778 | Kellogg Park | 20583 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 4.928 | Kellogg Park | 0 | Local Park 2 | 4 | |
6306 | 6306 | 6305 | {"type": "Polygon", "coordinates": [[[-117.74296, 34.10224], [-117.74278, 34.10225], [-117.7426, 34.10228], [-117.74223, 34.10243], [-117.74204, 34.10248], [-117.74158, 34.1025], [-117.74154, 34.10249], [-117.74153, 34.10247], [-117.74153, 34.1023], [-117.74155, 34.10212], [-117.74168, 34.10174], [-117.74171, 34.10159], [-117.74174, 34.10112], [-117.74295, 34.10111], [-117.74296, 34.10224]]]} | Open Access 1 | 1468 | Willie White Park | 27570 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 4.212 | Willie White 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]);