superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where MNG_AGENCY = 125 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12679 | 12679 | 12678 | {"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 | Renacimiento Community Center | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/81-renacimiento-community-center | 29805 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 0.157 | Renacimiento Community Ctr. | |
12669 | 12669 | 12668 | {"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 | Centennial Park | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/60-centennial-park | 29806 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 0.461 | Centennial Park | |
12642 | 12642 | 12641 | {"type": "Polygon", "coordinates": [[[-117.78863, 34.0562], [-117.78469, 34.05669], [-117.78406, 34.05571], [-117.78833, 34.05518], [-117.78863, 34.0562]]]} | Restricted Access 2 | Veterans Park Soccer Complex | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/84-veterans-park | 29804 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 10.985 | Veterans Park Soccer Complex | |
11631 | 11631 | 11630 | {"type": "Polygon", "coordinates": [[[-117.76967, 34.03509], [-117.76964, 34.03513], [-117.76956, 34.03515], [-117.76946, 34.03481], [-117.76899, 34.03488], [-117.76876, 34.03465], [-117.76821, 34.03464], [-117.76771, 34.03495], [-117.76689, 34.03517], [-117.76601, 34.03488], [-117.7656, 34.03491], [-117.76508, 34.03505], [-117.76515, 34.03541], [-117.76487, 34.03548], [-117.76472, 34.03485], [-117.76774, 34.03436], [-117.76861, 34.03428], [-117.76944, 34.03426], [-117.76949, 34.03427], [-117.76952, 34.03431], [-117.76954, 34.03456], [-117.76967, 34.03509]]]} | Open Access 1 | Neighborhood Park | 28179 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 5.62 | Neighborhood Park | ||
11270 | 11270 | 11269 | {"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 | Willie White Park | 27570 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 4.212 | Willie White Park | ||
11142 | 11142 | 11141 | {"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 | Westmont Park | 27410 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 5.976 | Westmont Park | ||
11092 | 11092 | 11091 | {"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 | Welch Park | 27338 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 8.891 | Welch Park | ||
11037 | 11037 | 11036 | {"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.05052], [-117.73787, 34.05087], [-117.73694, 34.05089], [-117.73685, 34.04829], [-117.74089, 34.04819], [-117.74092, 34.04896]]]} | Open Access 1 | Washington Park | 27277 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 20.536 | Washington Park | ||
10386 | 10386 | 10385 | {"type": "Polygon", "coordinates": [[[-117.754, 34.04755], [-117.75398, 34.04758], [-117.75395, 34.0476], [-117.75305, 34.04762], [-117.75302, 34.04678], [-117.75365, 34.04678], [-117.75367, 34.04722], [-117.75399, 34.04722], [-117.754, 34.04755]]]} | Open Access 1 | Tony Cerda Park | 26398 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1.639 | Tony Cerda Park | ||
10249 | 10249 | 10248 | {"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 | Ted Greene Park | 26214 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 5.659 | Ted Greene 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);