superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where ACCESS_TYP = 1, MNG_AGENCY = 555 and MNG_AG_LEV = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
543 | 543 | 542 | {"type": "Polygon", "coordinates": [[[-117.22792, 33.78575], [-117.22791, 33.7858], [-117.22716, 33.78584], [-117.22716, 33.78652], [-117.22629, 33.78652], [-117.22625, 33.78652], [-117.22623, 33.78649], [-117.22622, 33.78562], [-117.22627, 33.78556], [-117.22768, 33.78556], [-117.2277, 33.78574], [-117.22792, 33.78575]]]} | Open Access 1 | Russel Stewart Park/Cesar Chavez Library | http://www.cityofperris.org/residents/parks/parklist.html | 33527 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 2.69 | Russel Stewart Park/Cesar Chavez Library | |
1451 | 1451 | 1450 | {"type": "Polygon", "coordinates": [[[-117.21419, 33.78669], [-117.21416, 33.78846], [-117.2131, 33.78845], [-117.21308, 33.78667], [-117.21419, 33.78669]]]} | Open Access 1 | Bob Long Park | 16210 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 4.867 | Bob Long Park | ||
1746 | 1746 | 1745 | {"type": "Polygon", "coordinates": [[[-117.22851, 33.7902], [-117.22628, 33.7902], [-117.22628, 33.78801], [-117.22746, 33.788], [-117.22746, 33.78955], [-117.22846, 33.78956], [-117.22851, 33.7902]]]} | Open Access 1 | Banta Beatty Park | 15802 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 8.224 | Banta Beatty Park | ||
3178 | 3178 | 3177 | {"type": "Polygon", "coordinates": [[[-117.2226, 33.80668], [-117.2226, 33.80688], [-117.22237, 33.80757], [-117.22235, 33.80829], [-117.22118, 33.80829], [-117.22116, 33.80616], [-117.22126, 33.80613], [-117.22129, 33.80604], [-117.22131, 33.80534], [-117.22173, 33.80532], [-117.22166, 33.8049], [-117.22196, 33.80489], [-117.22201, 33.80552], [-117.22209, 33.80563], [-117.22225, 33.80566], [-117.22231, 33.80667], [-117.2226, 33.80668]]]} | Open Access 1 | Copper Creek Park | 17628 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 8.868 | Copper Creek Park | ||
6962 | 6962 | 6961 | {"type": "Polygon", "coordinates": [[[-117.23225, 33.7922], [-117.23211, 33.79222], [-117.23212, 33.7938], [-117.23068, 33.7938], [-117.22974, 33.79171], [-117.22954, 33.79115], [-117.2294, 33.7907], [-117.23224, 33.79069], [-117.23225, 33.7922]]]} | Open Access 1 | Metz Park | 22190 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 17.21 | Metz Park | ||
7176 | 7176 | 7175 | {"type": "MultiPolygon", "coordinates": [[[[-117.22935, 33.73821], [-117.22866, 33.73876], [-117.22889, 33.73903], [-117.22865, 33.73916], [-117.22836, 33.73929], [-117.22809, 33.73937], [-117.22782, 33.73942], [-117.22778, 33.73931], [-117.22785, 33.73923], [-117.22788, 33.73912], [-117.22786, 33.739], [-117.22777, 33.73885], [-117.22769, 33.73834], [-117.22762, 33.73819], [-117.2276, 33.73807], [-117.22764, 33.73797], [-117.22773, 33.73786], [-117.22792, 33.73778], [-117.22805, 33.73767], [-117.22826, 33.73759], [-117.22875, 33.73753], [-117.22881, 33.73782], [-117.2292, 33.73766], [-117.22927, 33.73772], [-117.2291, 33.73802], [-117.22935, 33.73821]]], [[[-117.22935, 33.73999], [-117.22899, 33.7404], [-117.22885, 33.74048], [-117.22861, 33.74056], [-117.22832, 33.74058], [-117.22815, 33.74057], [-117.22794, 33.73959], [-117.22815, 33.73954], [-117.22854, 33.73942], [-117.22876, 33.73932], [-117.22902, 33.73918], [-117.22927, 33.73946], [-117.22922, 33.73973], [-117.22923, 33.73983], [-117.22935, 33.73999]]]]} | Open Access 1 | Monument Ranch Park | 22447 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 8.567 | Monument Ranch Park | ||
7939 | 7939 | 7938 | {"type": "Polygon", "coordinates": [[[-117.22146, 33.82254], [-117.22143, 33.82281], [-117.22083, 33.82283], [-117.22083, 33.82245], [-117.21981, 33.8224], [-117.21975, 33.82263], [-117.21946, 33.82262], [-117.21943, 33.82277], [-117.21756, 33.82281], [-117.21749, 33.82274], [-117.21749, 33.81948], [-117.21758, 33.8194], [-117.21784, 33.81938], [-117.21788, 33.81979], [-117.21803, 33.81998], [-117.22078, 33.82231], [-117.22109, 33.82246], [-117.22146, 33.82254]]]} | Open Access 1 | Paragon Park | 23409 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 15.401 | Paragon Park | ||
10087 | 10087 | 10086 | {"type": "Polygon", "coordinates": [[[-117.21216, 33.83907], [-117.20865, 33.83908], [-117.20865, 33.8374], [-117.21216, 33.83739], [-117.21216, 33.83907]]]} | Open Access 1 | Morgan Park | http://www.cityofperris.org/residents/parks/parks/morgan-park.html | 28256 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 14.949 | Morgan Park | |
11532 | 11532 | 11531 | {"type": "Polygon", "coordinates": [[[-117.23464, 33.77386], [-117.23309, 33.77386], [-117.23308, 33.77214], [-117.23463, 33.77213], [-117.23464, 33.77386]]]} | Open Access 1 | Rotary Park | http://www.cityofperris.org/residents/parks/parks/rotary-park.html | 28260 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 6.793 | Rotary Park | |
11566 | 11566 | 11565 | {"type": "MultiPolygon", "coordinates": [[[[-117.22872, 33.7773], [-117.22831, 33.77731], [-117.22788, 33.77723], [-117.22683, 33.7766], [-117.22871, 33.77659], [-117.22872, 33.7773]]], [[[-117.22872, 33.77766], [-117.22872, 33.77766], [-117.22856, 33.77755], [-117.22872, 33.77754], [-117.22872, 33.77766]]]]} | Open Access 1 | Mercado Park | http://www.parks.ca.gov/?Page_id=26463 | 28049 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 2.349 | Mercado Park | |
11690 | 11690 | 11689 | {"type": "Polygon", "coordinates": [[[-117.1894, 33.82787], [-117.18909, 33.82788], [-117.18908, 33.8279], [-117.18702, 33.8279], [-117.18699, 33.8278], [-117.1869, 33.82772], [-117.1869, 33.8267], [-117.18897, 33.82669], [-117.18898, 33.82732], [-117.18935, 33.82734], [-117.1894, 33.82742], [-117.18942, 33.82749], [-117.18942, 33.82778], [-117.1894, 33.82787]]]} | Open Access 1 | May Ranch Park | http://www.cityofperris.org/residents/parks/parks/may-ranch-park.html | 28255 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 6.908 | May Ranch Park | |
11691 | 11691 | 11690 | {"type": "Polygon", "coordinates": [[[-117.19176, 33.83854], [-117.1914, 33.83854], [-117.1914, 33.83928], [-117.19101, 33.83918], [-117.19081, 33.83909], [-117.19065, 33.83899], [-117.19043, 33.83883], [-117.19007, 33.83847], [-117.19007, 33.83839], [-117.19066, 33.83797], [-117.19092, 33.83773], [-117.1911, 33.83751], [-117.1912, 33.83748], [-117.19144, 33.83755], [-117.19169, 33.83758], [-117.1917, 33.83847], [-117.19176, 33.83854]]]} | Open Access 1 | Frank Eaton Memorial Park | http://www.cityofperris.org/residents/parks/parks/frank-eaton-park.html | 28257 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 4.427 | Frank Eaton Memorial Park | |
11692 | 11692 | 11691 | {"type": "Polygon", "coordinates": [[[-117.20331, 33.82801], [-117.20331, 33.82811], [-117.20305, 33.82823], [-117.2028, 33.82828], [-117.2009, 33.82829], [-117.20067, 33.82826], [-117.20055, 33.82829], [-117.20006, 33.82829], [-117.20006, 33.82684], [-117.20188, 33.82684], [-117.20231, 33.82709], [-117.20266, 33.82735], [-117.20303, 33.82769], [-117.20331, 33.82801]]]} | Open Access 1 | Liberty Park | http://www.cityofperris.org/residents/parks/parks/liberty-park.html | 28258 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 9.984 | Liberty Park | |
11693 | 11693 | 11692 | {"type": "Polygon", "coordinates": [[[-117.21722, 33.79009], [-117.21716, 33.79014], [-117.21519, 33.79015], [-117.21519, 33.78843], [-117.21609, 33.78842], [-117.21662, 33.78887], [-117.21678, 33.78905], [-117.2169, 33.7892], [-117.21702, 33.78939], [-117.21712, 33.78963], [-117.21719, 33.78985], [-117.21722, 33.79009]]]} | Open Access 1 | Skydive Baseball Park | http://www.cityofperris.org/residents/parks/parks/skydive-park.html | 28259 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 7.227 | Skydive Baseball Park | |
11694 | 11694 | 11693 | {"type": "Polygon", "coordinates": [[[-117.20841, 33.79369], [-117.20708, 33.79371], [-117.20708, 33.79261], [-117.2084, 33.79258], [-117.20841, 33.79369]]]} | Open Access 1 | Patriot Park | http://www.cityofperris.org/residents/parks/parks/patriot-park.html | 28261 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 3.697 | Patriot 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]);