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