superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where MNG_AGENCY = 390 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6446 | 6446 | 6445 | {"type": "Polygon", "coordinates": [[[-121.43213, 37.70025], [-121.43155, 37.70025], [-121.43139, 37.70033], [-121.4313, 37.70034], [-121.43122, 37.70038], [-121.43122, 37.69928], [-121.43143, 37.69924], [-121.43173, 37.69922], [-121.43194, 37.69924], [-121.432, 37.69929], [-121.43201, 37.69986], [-121.43205, 37.70005], [-121.43213, 37.70025]]]} | Open Access 1 | Lowes Park | 21569 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 2.016 | Lowes Park | ||
3338 | 3338 | 3337 | {"type": "Polygon", "coordinates": [[[-121.43453, 37.73346], [-121.43448, 37.7335], [-121.43393, 37.73351], [-121.43393, 37.73297], [-121.43387, 37.73292], [-121.43389, 37.73287], [-121.43388, 37.7328], [-121.43394, 37.73272], [-121.43393, 37.73241], [-121.43383, 37.73217], [-121.43401, 37.73213], [-121.43417, 37.73211], [-121.43444, 37.73211], [-121.43449, 37.73215], [-121.43453, 37.73346]]]} | Open Access 1 | Fisher Park | 18920 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 2.005 | Fisher Park | ||
4387 | 4387 | 4386 | {"type": "Polygon", "coordinates": [[[-121.4363, 37.7128], [-121.43589, 37.7128], [-121.43589, 37.71232], [-121.43626, 37.71232], [-121.43626, 37.71246], [-121.43618, 37.71247], [-121.43611, 37.71249], [-121.43607, 37.71255], [-121.43607, 37.7126], [-121.43609, 37.71265], [-121.43614, 37.71269], [-121.4363, 37.71271], [-121.4363, 37.7128]]]} | Open Access 1 | Fred Icardi Park | 19076 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.344 | Fred Icardi Park | ||
1145 | 1145 | 1144 | {"type": "Polygon", "coordinates": [[[-121.43653, 37.68873], [-121.43601, 37.68921], [-121.43568, 37.68937], [-121.43565, 37.68851], [-121.43653, 37.6885], [-121.43653, 37.68873]]]} | Open Access 1 | American Legion Park | 15452 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.257 | American Legion Park | ||
4627 | 4627 | 4626 | {"type": "Polygon", "coordinates": [[[-121.43665, 37.7036], [-121.43664, 37.70422], [-121.43636, 37.70421], [-121.43629, 37.70416], [-121.4363, 37.70365], [-121.43637, 37.7036], [-121.43665, 37.7036]]]} | Open Access 1 | Kimball Park | 20645 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.515 | Kimball Park | ||
7237 | 7237 | 7236 | {"type": "Polygon", "coordinates": [[[-121.4374, 37.7211], [-121.43714, 37.7211], [-121.43713, 37.72084], [-121.43719, 37.72064], [-121.43725, 37.72064], [-121.43735, 37.72083], [-121.4374, 37.72083], [-121.4374, 37.7211]]]} | Open Access 1 | Mount Diablo Park | 22526 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.239 | Mount Diablo Park | ||
7238 | 7238 | 7237 | {"type": "Polygon", "coordinates": [[[-121.43743, 37.71857], [-121.43736, 37.71858], [-121.43729, 37.71879], [-121.43722, 37.71879], [-121.43715, 37.71858], [-121.43708, 37.71857], [-121.43708, 37.71831], [-121.43742, 37.71831], [-121.43743, 37.71857]]]} | Open Access 1 | Mount Oso Park | 22529 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.292 | Mount Oso Park | ||
4640 | 4640 | 4639 | {"type": "Polygon", "coordinates": [[[-121.43761, 37.71718], [-121.43716, 37.71718], [-121.43724, 37.71684], [-121.43724, 37.7166], [-121.43752, 37.71662], [-121.43758, 37.71668], [-121.43758, 37.7169], [-121.43761, 37.71718]]]} | Open Access 1 | Golden Spike | 19373 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.506 | Golden Spike | ||
9704 | 9704 | 9703 | {"type": "Polygon", "coordinates": [[[-121.43761, 37.72738], [-121.43729, 37.72752], [-121.43714, 37.72747], [-121.43714, 37.72742], [-121.43712, 37.72738], [-121.43703, 37.72732], [-121.43691, 37.72732], [-121.43682, 37.72737], [-121.43673, 37.72722], [-121.43721, 37.72702], [-121.43741, 37.72722], [-121.43761, 37.72738]]]} | Open Access 1 | Sister Cities Park | 25522 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.506 | Sister Cities Park | ||
10617 | 10617 | 10616 | {"type": "Polygon", "coordinates": [[[-121.43788, 37.72287], [-121.43781, 37.72293], [-121.43726, 37.72293], [-121.43726, 37.72266], [-121.43728, 37.72259], [-121.43782, 37.72258], [-121.43787, 37.72272], [-121.43788, 37.72287]]]} | Open Access 1 | Valley Oak Park | 26792 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.497 | Valley Oak Park | ||
10436 | 10436 | 10435 | {"type": "Polygon", "coordinates": [[[-121.43885, 37.72484], [-121.43881, 37.72486], [-121.43877, 37.72509], [-121.43829, 37.72499], [-121.43822, 37.72492], [-121.43821, 37.72477], [-121.43877, 37.72458], [-121.43884, 37.72471], [-121.43883, 37.72477], [-121.43885, 37.72484]]]} | Open Access 1 | Tracy Press Park | 26505 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.518 | Tracy Press Park | ||
3700 | 3700 | 3699 | {"type": "Polygon", "coordinates": [[[-121.43981, 37.74807], [-121.43977, 37.74811], [-121.43934, 37.74813], [-121.43852, 37.74809], [-121.43803, 37.74802], [-121.4365, 37.74774], [-121.43583, 37.74769], [-121.43517, 37.74768], [-121.43516, 37.74692], [-121.4398, 37.74691], [-121.43981, 37.74807]]]} | Open Access 1 | Dr Powers Park | 18264 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 11.137 | Dr Powers Park | ||
10326 | 10326 | 10325 | {"type": "Polygon", "coordinates": [[[-121.43988, 37.70742], [-121.43876, 37.70743], [-121.43861, 37.70742], [-121.43836, 37.70735], [-121.43816, 37.70722], [-121.43876, 37.70671], [-121.43904, 37.70634], [-121.43905, 37.70513], [-121.43919, 37.70513], [-121.43946, 37.70527], [-121.43968, 37.70546], [-121.43975, 37.70557], [-121.43982, 37.7057], [-121.43986, 37.70587], [-121.43988, 37.70742]]]} | Open Access 1 | Thoming Park | 26311 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 5.417 | Thoming Park | ||
11239 | 11239 | 11238 | {"type": "Polygon", "coordinates": [[[-121.44027, 37.70235], [-121.43919, 37.70235], [-121.43919, 37.70066], [-121.43925, 37.7006], [-121.43978, 37.70057], [-121.44027, 37.70049], [-121.44027, 37.70235]]]} | Open Access 1 | William Adams Park | 27538 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 4.702 | William Adams Park | ||
1127 | 1127 | 1126 | {"type": "Polygon", "coordinates": [[[-121.44091, 37.7344], [-121.44095, 37.73455], [-121.44096, 37.73472], [-121.44085, 37.73529], [-121.44084, 37.73547], [-121.44084, 37.73572], [-121.44051, 37.73576], [-121.44056, 37.73608], [-121.44064, 37.7364], [-121.44069, 37.73664], [-121.44071, 37.73705], [-121.44062, 37.73748], [-121.44047, 37.73784], [-121.44019, 37.73776], [-121.44033, 37.73739], [-121.44036, 37.7372], [-121.44039, 37.73693], [-121.44038, 37.73674], [-121.44035, 37.73659], [-121.44036, 37.73657], [-121.44023, 37.73603], [-121.4402, 37.73581], [-121.44021, 37.73574], [-121.43998, 37.73566], [-121.43988, 37.7356], [-121.43976, 37.7355], [-121.43968, 37.73539], [-121.43963, 37.73527], [-121.43962, 37.73509], [-121.43966, 37.73494], [-121.43974, 37.7348], [-121.43984, 37.7347], [-121.43995, 37.73463], [-121.44015, 37.73455], [-121.44055, 37.73449], [-121.44091, 37.7344]]]} | Open Access 1 | Alden Park | 15345 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 4.929 | Alden Park | ||
9734 | 9734 | 9733 | {"type": "Polygon", "coordinates": [[[-121.44216, 37.75628], [-121.44189, 37.75628], [-121.44187, 37.75654], [-121.44171, 37.75654], [-121.44171, 37.75628], [-121.44157, 37.75627], [-121.44157, 37.75601], [-121.44216, 37.75601], [-121.44216, 37.75628]]]} | Open Access 1 | Slayter Park | 25556 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.496 | Slayter Park | ||
4252 | 4252 | 4251 | {"type": "Polygon", "coordinates": [[[-121.44232, 37.70854], [-121.4418, 37.70853], [-121.44165, 37.70849], [-121.44165, 37.70825], [-121.44224, 37.70825], [-121.44231, 37.7083], [-121.44232, 37.70854]]]} | Open Access 1 | Fitzpatrick Park | 18932 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.452 | Fitzpatrick Park | ||
11127 | 11127 | 11126 | {"type": "Polygon", "coordinates": [[[-121.44241, 37.7118], [-121.44234, 37.71184], [-121.44231, 37.71192], [-121.44216, 37.71192], [-121.44215, 37.71185], [-121.44207, 37.71179], [-121.44207, 37.71125], [-121.44241, 37.71124], [-121.44241, 37.7118]]]} | Open Access 1 | Westside Pioneer | 27430 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.516 | Westside Pioneer | ||
3989 | 3989 | 3988 | {"type": "Polygon", "coordinates": [[[-121.44256, 37.70544], [-121.44256, 37.70571], [-121.44184, 37.70571], [-121.44184, 37.70543], [-121.44256, 37.70544]]]} | Open Access 1 | Emhoff Park | 18626 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.475 | Emhoff Park | ||
4098 | 4098 | 4097 | {"type": "Polygon", "coordinates": [[[-121.44278, 37.71963], [-121.44271, 37.7197], [-121.4427, 37.71975], [-121.44272, 37.7198], [-121.44263, 37.71983], [-121.44257, 37.71994], [-121.44224, 37.71989], [-121.4423, 37.71951], [-121.44235, 37.7194], [-121.4424, 37.71932], [-121.44264, 37.71944], [-121.44278, 37.71963]]]} | Open Access 1 | Evelyn Costa Park | 18758 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.529 | Evelyn Costa 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]);