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