superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where MNG_AGENCY = 158
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
876 | 876 | 875 | {"type": "Polygon", "coordinates": [[[-115.52004, 32.98567], [-115.51876, 32.98567], [-115.51874, 32.986], [-115.51873, 32.98602], [-115.51797, 32.98602], [-115.51795, 32.986], [-115.51794, 32.98531], [-115.51881, 32.98531], [-115.51882, 32.98493], [-115.52004, 32.98493], [-115.52004, 32.98567]]]} | Open Access 1 | Alyce Gereaux Park | 15433 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 3.838 | Alyce Gereaux Park | ||
1896 | 1896 | 1895 | {"type": "Polygon", "coordinates": [[[-115.53929, 32.98428], [-115.53929, 32.98506], [-115.5373, 32.98507], [-115.53731, 32.98428], [-115.53929, 32.98428]]]} | Open Access 1 | Beechey Field | 15951 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 3.985 | Beechey Field | ||
2963 | 2963 | 2962 | {"type": "Polygon", "coordinates": [[[-115.55946, 32.96148], [-115.55945, 32.9616], [-115.55943, 32.96168], [-115.55936, 32.96179], [-115.5593, 32.96185], [-115.55922, 32.9619], [-115.55909, 32.96196], [-115.55887, 32.96199], [-115.55888, 32.96145], [-115.55941, 32.96145], [-115.55946, 32.96148]]]} | Open Access 1 | Citrus View Park | 17288 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 0.659 | Citrus View Park | ||
4664 | 4664 | 4663 | {"type": "Polygon", "coordinates": [[[-115.54149, 32.97992], [-115.54149, 32.98078], [-115.53953, 32.98078], [-115.53954, 32.97992], [-115.54149, 32.97992]]]} | Open Access 1 | Gonzalez Park | 19400 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 4.311 | Gonzalez Park | ||
4795 | 4795 | 4794 | {"type": "Polygon", "coordinates": [[[-115.52412, 32.9724], [-115.52322, 32.9724], [-115.52322, 32.97086], [-115.52412, 32.97086], [-115.52412, 32.9724]]]} | Open Access 1 | Guadalupe Park | 19557 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 3.576 | Guadalupe Park | ||
5182 | 5182 | 5181 | {"type": "Polygon", "coordinates": [[[-115.52958, 32.97543], [-115.52929, 32.97631], [-115.52654, 32.97631], [-115.52654, 32.97543], [-115.52958, 32.97543]]]} | Open Access 1 | Hinojosa Park | 20003 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 6.522 | Hinojosa Park | ||
5504 | 5504 | 5503 | {"type": "Polygon", "coordinates": [[[-115.55893, 32.95857], [-115.55893, 32.9593], [-115.55892, 32.95971], [-115.55887, 32.95976], [-115.55724, 32.95976], [-115.55719, 32.95971], [-115.55721, 32.95931], [-115.55721, 32.95857], [-115.55726, 32.95852], [-115.55888, 32.95853], [-115.55893, 32.95857]]]} | Open Access 1 | Jeff Thornton Park | 20378 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 5.415 | Jeff Thornton Park | ||
6959 | 6959 | 6958 | {"type": "Polygon", "coordinates": [[[-115.53932, 32.9741], [-115.53736, 32.97411], [-115.53736, 32.97323], [-115.53932, 32.97322], [-115.53932, 32.9741]]]} | Open Access 1 | Meserve Park | 22184 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 4.433 | Meserve Park | ||
8005 | 8005 | 8004 | {"type": "Polygon", "coordinates": [[[-115.55341, 32.98653], [-115.55204, 32.9878], [-115.55202, 32.98844], [-115.55218, 32.98901], [-115.5517, 32.9898], [-115.55149, 32.98987], [-115.55125, 32.99018], [-115.55124, 32.99022], [-115.54745, 32.99023], [-115.54745, 32.98968], [-115.54769, 32.98932], [-115.54769, 32.98843], [-115.54885, 32.98842], [-115.5506, 32.98653], [-115.55341, 32.98653]]]} | Open Access 1 | Pat Williams Park | 23505 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 33.148 | Pat Williams Park | ||
8242 | 8242 | 8241 | {"type": "Polygon", "coordinates": [[[-115.5347, 32.97881], [-115.53469, 32.97938], [-115.53399, 32.9788], [-115.53399, 32.9788], [-115.5347, 32.97881]]]} | Open Access 1 | Plaza Park | 23790 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 0.52 | Plaza Park | ||
8689 | 8689 | 8688 | {"type": "Polygon", "coordinates": [[[-115.54563, 32.99059], [-115.54479, 32.99129], [-115.54476, 32.99128], [-115.54476, 32.99107], [-115.54482, 32.99102], [-115.54482, 32.99089], [-115.54477, 32.99087], [-115.54476, 32.99085], [-115.54476, 32.9906], [-115.54479, 32.99057], [-115.54561, 32.99057], [-115.54563, 32.99059]]]} | Open Access 1 | Ridge Park | 24348 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 0.843 | Ridge Park | ||
9025 | 9025 | 9024 | {"type": "Polygon", "coordinates": [[[-115.55711, 32.97077], [-115.55283, 32.97078], [-115.5528, 32.96623], [-115.55288, 32.96623], [-115.55297, 32.96642], [-115.55304, 32.96667], [-115.55317, 32.96669], [-115.55347, 32.96669], [-115.55395, 32.96654], [-115.55419, 32.96639], [-115.55448, 32.96627], [-115.55474, 32.96625], [-115.55524, 32.96616], [-115.55556, 32.96609], [-115.55711, 32.96559], [-115.5571, 32.96914], [-115.55711, 32.97077]]]} | Open Access 1 | Rotary Park | 24699 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 50.247 | Rotary Park | ||
10971 | 10971 | 10970 | {"type": "Polygon", "coordinates": [[[-115.54148, 32.98654], [-115.54148, 32.98727], [-115.54144, 32.98732], [-115.53936, 32.98733], [-115.53907, 32.98732], [-115.53879, 32.98725], [-115.53855, 32.98713], [-115.53821, 32.98684], [-115.53796, 32.98669], [-115.53767, 32.98659], [-115.5373, 32.98655], [-115.54148, 32.98654]]]} | Open Access 1 | Volunteer Park | 27196 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 6.342 | Volunteer Park | ||
11008 | 11008 | 11007 | {"type": "Polygon", "coordinates": [[[-115.53878, 32.98523], [-115.53877, 32.98655], [-115.5373, 32.98655], [-115.5373, 32.98523], [-115.53878, 32.98523]]]} | Open Access 1 | Wiest Field | 27489 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 4.977 | Wiest Field | ||
14417 | 14417 | 14416 | {"type": "Polygon", "coordinates": [[[-115.54211, 32.97803], [-115.54179, 32.97803], [-115.54179, 32.97758], [-115.5421, 32.97758], [-115.54211, 32.97803]]]} | Open Access 1 | Jeff Kissee Park | http://www.brawley-ca.gov/section/Parks-and-Recreation/Parks-and-Facilities | 33472 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 0.362 | Jeff Kissee 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]);