superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where MNG_AGENCY = 125 sorted by ACRES
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. | |
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 | |
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);