superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where ACCESS_TYP = 1 and MNG_AGENCY = 390 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
15548 | 15548 | 15547 | {"type": "Polygon", "coordinates": [[[-121.42033, 37.73804], [-121.42004, 37.73828], [-121.41973, 37.73803], [-121.42002, 37.7378], [-121.42033, 37.73804]]]} | Open Access 1 | Civic Center Plaza | 17369 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.348 | Civic Ctr. Plaza | ||
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 | ||
4947 | 4947 | 4946 | {"type": "Polygon", "coordinates": [[[-121.45122, 37.72983], [-121.45093, 37.72984], [-121.45086, 37.72978], [-121.45085, 37.72934], [-121.45092, 37.72928], [-121.45121, 37.72928], [-121.45122, 37.72983]]]} | Open Access 1 | Harvest Park | 19724 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.471 | Harvest Park | ||
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 | ||
1723 | 1723 | 1722 | {"type": "Polygon", "coordinates": [[[-121.45134, 37.72705], [-121.45081, 37.72706], [-121.45079, 37.72676], [-121.45114, 37.72663], [-121.45128, 37.72666], [-121.45134, 37.72686], [-121.45134, 37.72705]]]} | Open Access 1 | Bailor Hennan Park | 15762 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.478 | Bailor Hennan Park | ||
9964 | 9964 | 9963 | {"type": "Polygon", "coordinates": [[[-121.42299, 37.72758], [-121.42287, 37.72762], [-121.42283, 37.72767], [-121.42282, 37.72772], [-121.4227, 37.72772], [-121.42268, 37.72767], [-121.42265, 37.72763], [-121.42259, 37.7276], [-121.42253, 37.72759], [-121.42253, 37.72728], [-121.4226, 37.72727], [-121.42265, 37.72724], [-121.42269, 37.72719], [-121.4227, 37.72714], [-121.42282, 37.72714], [-121.42283, 37.72718], [-121.42286, 37.72723], [-121.42292, 37.72726], [-121.42299, 37.72727], [-121.42299, 37.72758]]]} | Open Access 1 | Stevens Park | 25843 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.482 | Stevens Park | ||
4659 | 4659 | 4658 | {"type": "Polygon", "coordinates": [[[-121.45137, 37.73582], [-121.45121, 37.73613], [-121.45115, 37.73615], [-121.45113, 37.73644], [-121.45081, 37.73639], [-121.45076, 37.73632], [-121.45097, 37.73597], [-121.45103, 37.73582], [-121.45111, 37.73579], [-121.45137, 37.73582]]]} | Open Access 1 | Kit Fox Park | 20678 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.496 | Kit Fox 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 | ||
8026 | 8026 | 8025 | {"type": "Polygon", "coordinates": [[[-121.44705, 37.7373], [-121.44705, 37.73738], [-121.44679, 37.73756], [-121.44636, 37.73713], [-121.44658, 37.73699], [-121.44668, 37.73699], [-121.44705, 37.7373]]]} | Open Access 1 | Patzer Park | 23527 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.497 | Patzer 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 | ||
5697 | 5697 | 5696 | {"type": "Polygon", "coordinates": [[[-121.45642, 37.74867], [-121.45604, 37.74868], [-121.45602, 37.74858], [-121.45565, 37.74858], [-121.45565, 37.74832], [-121.45593, 37.74833], [-121.45636, 37.74841], [-121.45642, 37.74845], [-121.45642, 37.74867]]]} | Open Access 1 | Kelly Park | 20589 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.503 | Kelly Park | ||
7343 | 7343 | 7342 | {"type": "Polygon", "coordinates": [[[-121.45549, 37.74985], [-121.45549, 37.75012], [-121.45482, 37.75012], [-121.45482, 37.74986], [-121.45489, 37.7498], [-121.45542, 37.7498], [-121.45549, 37.74985]]]} | Open Access 1 | New Harmon Park | 22707 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.505 | New Harmon Park | ||
8289 | 8289 | 8288 | {"type": "Polygon", "coordinates": [[[-121.45662, 37.75152], [-121.4565, 37.7517], [-121.45623, 37.75198], [-121.45597, 37.75189], [-121.45592, 37.75184], [-121.45592, 37.75159], [-121.45604, 37.75155], [-121.45612, 37.75158], [-121.4562, 37.75157], [-121.4563, 37.75152], [-121.45662, 37.75152]]]} | Open Access 1 | Pombo Family Park | 23877 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.505 | Pombo Family 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 | ||
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 | ||
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 |
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]);