superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AGENCY = 149 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7611 | 7611 | 7610 | {"type": "Polygon", "coordinates": [[[-117.97897, 33.75604], [-117.97875, 33.75605], [-117.97875, 33.75572], [-117.97897, 33.75571], [-117.97897, 33.75604]]]} | Open Access 1 | Oasis Park | 23040 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 0.189 | Oasis Park | ||
2058 | 2058 | 2057 | {"type": "Polygon", "coordinates": [[[-117.97892, 33.75922], [-117.97849, 33.75922], [-117.97848, 33.75856], [-117.97872, 33.75856], [-117.97873, 33.75838], [-117.97892, 33.75838], [-117.97892, 33.75922]]]} | Open Access 1 | Blakey Park | 16154 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 0.824 | Blakey Park | ||
9631 | 9631 | 9630 | {"type": "Polygon", "coordinates": [[[-117.9853, 33.7564], [-117.98447, 33.75641], [-117.98446, 33.75567], [-117.98529, 33.75566], [-117.9853, 33.7564]]]} | Open Access 1 | Sid Goldstein Freedom Park | 25438 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1.551 | Sid Goldstein Freedom Park | ||
4645 | 4645 | 4644 | {"type": "Polygon", "coordinates": [[[-118.01093, 33.77007], [-118.01083, 33.77015], [-118.01069, 33.7703], [-118.01061, 33.77048], [-118.01056, 33.77071], [-118.01055, 33.77119], [-118.01052, 33.77121], [-118.01012, 33.77121], [-118.01011, 33.76991], [-118.01073, 33.76991], [-118.01093, 33.77007]]]} | Open Access 1 | Goldenwest Park | 19378 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1.77 | Goldenwest Park | ||
5348 | 5348 | 5347 | {"type": "Polygon", "coordinates": [[[-118.02439, 33.76206], [-118.02432, 33.76212], [-118.02366, 33.76157], [-118.02356, 33.7615], [-118.02337, 33.76144], [-118.02313, 33.76143], [-118.02311, 33.76064], [-118.02425, 33.7615], [-118.02432, 33.76159], [-118.02437, 33.76169], [-118.02439, 33.76189], [-118.02439, 33.76206]]]} | Open Access 1 | Indian Village Park | 20212 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1.81 | Indian Village Park | ||
10935 | 10935 | 10934 | {"type": "Polygon", "coordinates": [[[-118.02439, 33.76206], [-118.02432, 33.76212], [-118.02366, 33.76157], [-118.02356, 33.7615], [-118.02337, 33.76144], [-118.02313, 33.76143], [-118.02311, 33.76064], [-118.02425, 33.7615], [-118.02432, 33.76159], [-118.02437, 33.76169], [-118.02439, 33.76189], [-118.02439, 33.76206]]]} | Open Access 1 | Virginia Boos Park | 27156 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1.81 | Virginia Boos Park | ||
3196 | 3196 | 3195 | {"type": "Polygon", "coordinates": [[[-117.96817, 33.74006], [-117.96818, 33.7406], [-117.96816, 33.7407], [-117.96686, 33.74072], [-117.96685, 33.74018], [-117.96725, 33.74018], [-117.96738, 33.74023], [-117.96746, 33.74024], [-117.96755, 33.7402], [-117.96758, 33.74017], [-117.96759, 33.7401], [-117.96782, 33.74011], [-117.96784, 33.74006], [-117.96817, 33.74006]]]} | Open Access 1 | Coronet Park | 17651 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1.909 | Coronet Park | ||
3038 | 3038 | 3037 | {"type": "Polygon", "coordinates": [[[-117.96085, 33.73497], [-117.9595, 33.73555], [-117.95934, 33.73531], [-117.95943, 33.73525], [-117.95952, 33.73515], [-117.95957, 33.73499], [-117.95957, 33.73468], [-117.95962, 33.73466], [-117.96075, 33.73465], [-117.96085, 33.73497]]]} | Open Access 1 | Cloverdale Park | 17443 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 2.021 | Cloverdale Park | ||
7354 | 7354 | 7353 | {"type": "Polygon", "coordinates": [[[-117.95924, 33.74856], [-117.95924, 33.74929], [-117.95809, 33.74929], [-117.95808, 33.74857], [-117.95924, 33.74856]]]} | Open Access 1 | Newcastle Park | 22720 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 2.116 | Newcastle Park | ||
2678 | 2678 | 2677 | {"type": "Polygon", "coordinates": [[[-118.02242, 33.75773], [-118.02137, 33.75769], [-118.0211, 33.75765], [-118.02093, 33.7576], [-118.02077, 33.75752], [-118.02035, 33.75721], [-118.02241, 33.75719], [-118.02242, 33.75773]]]} | Open Access 1 | Cascade Park | 16938 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 2.179 | Cascade Park | ||
11140 | 11140 | 11139 | {"type": "Polygon", "coordinates": [[[-118.03817, 33.75731], [-118.03808, 33.75738], [-118.03803, 33.75758], [-118.03804, 33.75772], [-118.03799, 33.75777], [-118.03778, 33.75812], [-118.03773, 33.75815], [-118.03696, 33.75816], [-118.03691, 33.75813], [-118.03692, 33.75751], [-118.03718, 33.75731], [-118.03742, 33.75718], [-118.03746, 33.75713], [-118.03793, 33.75709], [-118.03817, 33.75731]]]} | Open Access 1 | Westminster Village Park | 27408 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 2.567 | Westminster Village Park | ||
2181 | 2181 | 2180 | {"type": "Polygon", "coordinates": [[[-117.95344, 33.74992], [-117.95343, 33.74995], [-117.95339, 33.74996], [-117.95254, 33.74998], [-117.95229, 33.75004], [-117.952, 33.75019], [-117.95194, 33.75017], [-117.95192, 33.75005], [-117.95191, 33.74935], [-117.95195, 33.7492], [-117.95209, 33.749], [-117.95272, 33.749], [-117.95272, 33.74927], [-117.95312, 33.74927], [-117.95338, 33.74966], [-117.95344, 33.74985], [-117.95344, 33.74992]]]} | Open Access 1 | Bowling Green Park | 16310 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 3.18 | Bowling Green Park | ||
4904 | 4904 | 4903 | {"type": "Polygon", "coordinates": [[[-117.99828, 33.74354], [-117.99677, 33.74355], [-117.99676, 33.74265], [-117.99827, 33.74264], [-117.99828, 33.74354]]]} | Open Access 1 | Land Park | 21001 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 3.451 | Land Park | ||
3930 | 3930 | 3929 | {"type": "Polygon", "coordinates": [[[-117.96021, 33.73828], [-117.95756, 33.7383], [-117.95755, 33.7378], [-117.95909, 33.73779], [-117.95911, 33.73774], [-117.96021, 33.73773], [-117.96021, 33.73828]]]} | Open Access 1 | Elden F Gillespie Park | 18549 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 3.524 | Elden F Gillespie Park | ||
3098 | 3098 | 3097 | {"type": "Polygon", "coordinates": [[[-117.99996, 33.73891], [-117.99964, 33.73891], [-117.99932, 33.73914], [-117.9991, 33.73934], [-117.99859, 33.73889], [-117.99857, 33.7375], [-117.99908, 33.7375], [-117.99908, 33.73789], [-117.99928, 33.73813], [-117.99961, 33.73829], [-117.99995, 33.73829], [-117.99996, 33.73891]]]} | Open Access 1 | College Park | 17512 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 3.925 | College Park | ||
13813 | 13813 | 13812 | {"type": "Polygon", "coordinates": [[[-117.99946, 33.76633], [-117.99897, 33.76634], [-117.99892, 33.76292], [-117.99942, 33.76295], [-117.99946, 33.76633]]]} | Open Access 1 | Frank G. Fry Park | 33129 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 4.262 | Frank G. Fry Park | ||
2127 | 2127 | 2126 | {"type": "Polygon", "coordinates": [[[-118.03598, 33.76355], [-118.03598, 33.76445], [-118.03394, 33.76445], [-118.03395, 33.76355], [-118.03598, 33.76355]]]} | Open Access 1 | Bolsa Chica Park | 16246 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 4.622 | Bolsa Chica Park | ||
7956 | 7956 | 7955 | {"type": "Polygon", "coordinates": [[[-117.98493, 33.73923], [-117.98486, 33.73923], [-117.98483, 33.73916], [-117.98475, 33.73912], [-117.98468, 33.73912], [-117.98453, 33.73917], [-117.98374, 33.73918], [-117.98369, 33.73915], [-117.98368, 33.73912], [-117.98367, 33.73806], [-117.98359, 33.73775], [-117.98359, 33.73768], [-117.9837, 33.7376], [-117.98491, 33.7376], [-117.98493, 33.73923]]]} | Open Access 1 | Park West Park | 23441 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 5.013 | Park West Park | ||
9338 | 9338 | 9337 | {"type": "Polygon", "coordinates": [[[-118.00358, 33.75773], [-118.00072, 33.75774], [-118.00071, 33.75692], [-118.00358, 33.75691], [-118.00358, 33.75773]]]} | Open Access 1 | Sigler Park | 25473 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 5.983 | Sigler Park | ||
6152 | 6152 | 6151 | {"type": "Polygon", "coordinates": [[[-117.98542, 33.76027], [-117.98532, 33.76029], [-117.98534, 33.76166], [-117.9837, 33.76167], [-117.98369, 33.76028], [-117.98491, 33.76027], [-117.98493, 33.76004], [-117.98542, 33.76004], [-117.98542, 33.76027]]]} | Open Access 1 | Liberty Park | 21213 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 6.088 | Liberty 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]);