units_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)
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 |
4303 | 4303 | 4302 | {"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 | 48156 | Esperanza y Alegria Park | 32693 | 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 | 0.165 | Esperanza y Alegria Park | 2018 | Local Park 2 | 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 |
2996 | 2996 | 2995 | {"type": "Polygon", "coordinates": [[[-117.75508, 34.02943], [-117.75521, 34.02954], [-117.75527, 34.02962], [-117.75529, 34.02972], [-117.7553, 34.0299], [-117.75521, 34.03004], [-117.75505, 34.0302], [-117.75463, 34.03004], [-117.7549, 34.02966], [-117.75508, 34.02943]]]} | Open Access 1 | 20560 | Powers Park | 23973 | 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 | 0.737 | Powers Park | 0 | Local Park 2 | 4 | |
6256 | 6256 | 6255 | {"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 | 1350 | Hamilton Park | 19621 | 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.018 | Hamilton 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 | |
756 | 756 | 755 | {"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 | 4947 | Tony Cerda Park | 26398 | 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.637 | Tony Cerda Park | 0 | Local Park 2 | 4 | |
2997 | 2997 | 2996 | {"type": "Polygon", "coordinates": [[[-117.80383, 34.0575], [-117.80371, 34.05761], [-117.8034, 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 | 20561 | Cesar Chavez Park | 17098 | 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.754 | Cesar Chavez Park | 0 | Local Park 2 | 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 |
310 | 310 | 309 | {"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 | 839 | Garfield Park | 19215 | 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 | 2.655 | Garfield Park | 0 | Local Park 2 | 4 | |
5368 | 5368 | 5367 | {"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.07045], [-117.74598, 34.07056], [-117.74591, 34.07074], [-117.74585, 34.07083], [-117.74575, 34.07092], [-117.74561, 34.071], [-117.74548, 34.07104], [-117.74532, 34.07106], [-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 | 5691 | Lincoln Park | 21268 | 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.001 | Lincoln 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
1380 | 1380 | 1379 | {"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 | 8406 | Phillips Ranch Park | 23643 | 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.995 | Phillips Ranch Park | 0 | Local Park 2 | 4 | |
4315 | 4315 | 4314 | {"type": "Polygon", "coordinates": [[[-117.76956, 34.03515], [-117.76947, 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.76507, 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], [-117.76964, 34.03513], [-117.76956, 34.03515]]]} | Open Access 1 | 45403 | Neighborhood Park | 28179 | 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.613 | Neighborhood 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 |
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]);