units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
69 rows where DES_TP = 2 and MNG_AGENCY = 390 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 69
MNG_AGENCY 1
- Tracy, City of · 69 ✖
DES_TP 1
- Local Park · 69 ✖
ACCESS_TYP 1
- Open Access 69
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES ▼ | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12596 | 12596 | 12595 | {"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 | 29254 | Mount Diablo Park | 22526 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.239 | Mount Diablo Park | 0 | Local Park 2 | 4 | |
12335 | 12335 | 12334 | {"type": "Polygon", "coordinates": [[[-121.43743, 37.71857], [-121.43736, 37.71857], [-121.43729, 37.71879], [-121.43722, 37.71879], [-121.43715, 37.71857], [-121.43708, 37.71857], [-121.43708, 37.71831], [-121.43742, 37.71831], [-121.43743, 37.71857]]]} | Open Access 1 | 26019 | Mount Oso Park | 22529 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.291 | Mount Oso Park | 0 | Local Park 2 | 4 | |
12050 | 12050 | 12049 | {"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.7125], [-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 | 24731 | Fred Icardi Park | 19076 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.344 | Fred Icardi Park | 0 | Local Park 2 | 4 | |
3708 | 3708 | 3707 | {"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 | 44513 | Civic Center Plaza | 17369 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.348 | Civic Ctr. Plaza | 0 | Local Park 2 | 4 | |
12045 | 12045 | 12044 | {"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 | 24725 | Fitzpatrick Park | 18932 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.453 | Fitzpatrick Park | 0 | Local Park 2 | 4 | |
12396 | 12396 | 12395 | {"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 | 26544 | Harvest Park | 19724 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.472 | Harvest Park | 0 | Local Park 2 | 4 | |
12041 | 12041 | 12040 | {"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 | 24721 | Emhoff Park | 18626 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.475 | Emhoff Park | 0 | Local Park 2 | 4 | |
4882 | 4882 | 4881 | {"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 | 24716 | Bailor Hennan Park | 15762 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.479 | Bailor Hennan Park | 0 | Local Park 2 | 4 | |
12599 | 12599 | 12598 | {"type": "Polygon", "coordinates": [[[-121.42299, 37.72758], [-121.42293, 37.72759], [-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 | 29258 | Stevens Park | 25843 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.48 | Stevens Park | 0 | Local Park 2 | 4 | |
5392 | 5392 | 5391 | {"type": "Polygon", "coordinates": [[[-121.44216, 37.75628], [-121.44188, 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 | 24698 | Slayter Park | 25556 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.493 | Slayter Park | 0 | Local Park 2 | 4 | |
12398 | 12398 | 12397 | {"type": "Polygon", "coordinates": [[[-121.45137, 37.73582], [-121.45121, 37.73613], [-121.45115, 37.73614], [-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 | 26547 | Kit Fox Park | 20678 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.496 | Kit Fox Park | 0 | Local Park 2 | 4 | |
5196 | 5196 | 5195 | {"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 | 24737 | Patzer Park | 23527 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.498 | Patzer Park | 0 | Local Park 2 | 4 | |
12437 | 12437 | 12436 | {"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 | 28065 | Valley Oak Park | 26792 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.498 | Valley Oak Park | 0 | Local Park 2 | 4 | |
2610 | 2610 | 2609 | {"type": "Polygon", "coordinates": [[[-121.45642, 37.74867], [-121.45604, 37.74868], [-121.45603, 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 | 17995 | Kelly Park | 20589 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.502 | Kelly Park | 0 | Local Park 2 | 4 | |
3401 | 3401 | 3400 | {"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.4369, 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 | 24740 | Sister Cities Park | 25522 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.505 | Sister Cities Park | 0 | Local Park 2 | 4 | |
5423 | 5423 | 5422 | {"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 | 24738 | Pombo Family Park | 23877 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.505 | Pombo Family Park | 0 | Local Park 2 | 4 | |
11931 | 11931 | 11930 | {"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 | 24736 | New Harmon Park | 22707 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.506 | New Harmon Park | 0 | Local Park 2 | 4 | |
3400 | 3400 | 3399 | {"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 | 24733 | Kimball Park | 20645 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.515 | Kimball Park | 0 | Local Park 2 | 4 | |
5399 | 5399 | 5398 | {"type": "Polygon", "coordinates": [[[-121.42879, 37.72261], [-121.42879, 37.72289], [-121.42847, 37.72289], [-121.42846, 37.72316], [-121.42824, 37.72315], [-121.42824, 37.72261], [-121.42879, 37.72261]]]} | Open Access 1 | 24742 | Sullivan Park | 25950 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.517 | Sullivan Park | 0 | Local Park 2 | 4 | |
12014 | 12014 | 12013 | {"type": "Polygon", "coordinates": [[[-121.41891, 37.73385], [-121.41881, 37.73389], [-121.41869, 37.73384], [-121.41869, 37.7338], [-121.41866, 37.73375], [-121.41862, 37.73372], [-121.41855, 37.7337], [-121.41831, 37.7333], [-121.41862, 37.73318], [-121.41887, 37.73359], [-121.41886, 37.73365], [-121.41887, 37.73369], [-121.41891, 37.73374], [-121.41891, 37.73385]]]} | Open Access 1 | 24697 | Huck Park | 20131 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.517 | Huck Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);