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 map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 49
MNG_AGENCY 1
- Tracy, City of · 49 ✖
DES_TP 1
- Local Park · 49 ✖
ACCESS_TYP 1
- Open Access 49
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12044 | 12044 | 12043 | {"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.73212], [-121.43444, 37.73211], [-121.43449, 37.73215], [-121.43453, 37.73346]]]} | Open Access 1 | 24724 | Fisher Park | 18920 | 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 | 2.004 | Fisher 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 | |
4079 | 4079 | 4078 | {"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 | 44482 | American Legion Park | 15452 | 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 | 1.258 | American Legion 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 | |
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 | |
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 | |
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 | |
5154 | 5154 | 5153 | {"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 | 24744 | Tracy Press Park | 26505 | 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.518 | Tracy Press Park | 0 | Local Park 2 | 4 | |
10264 | 10264 | 10263 | {"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 | 17985 | Dr Powers Park | 18264 | 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 | 11.137 | Dr Powers Park | 0 | Local Park 2 | 4 | |
12436 | 12436 | 12435 | {"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 | 28064 | Thoming Park | 26311 | 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 | 5.417 | Thoming Park | 0 | Local Park 2 | 4 | |
11094 | 11094 | 11093 | {"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 | 28067 | William Adams Park | 27538 | 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 | 4.703 | William Adams Park | 0 | Local Park 2 | 4 | |
3537 | 3537 | 3536 | {"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.73575], [-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.43985, 37.7347], [-121.43995, 37.73463], [-121.44015, 37.73455], [-121.44055, 37.73449], [-121.44091, 37.7344]]]} | Open Access 1 | 28133 | Alden Park | 15345 | 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 | 4.924 | Alden 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 | |
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 | |
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 | |
12040 | 12040 | 12039 | {"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 | 24720 | Evelyn Costa Park | 18758 | 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.529 | Evelyn Costa Park | 0 | Local Park 2 | 4 | |
12395 | 12395 | 12394 | {"type": "Polygon", "coordinates": [[[-121.44518, 37.71351], [-121.44518, 37.714], [-121.44389, 37.71402], [-121.4439, 37.7154], [-121.44286, 37.7154], [-121.44256, 37.71538], [-121.44254, 37.71376], [-121.44283, 37.71371], [-121.443, 37.71366], [-121.44388, 37.71366], [-121.44389, 37.71351], [-121.44518, 37.71351]]]} | Open Access 1 | 26543 | Gretchen Talley Park | 19502 | 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 | 7.134 | Gretchen Talley Park | 0 | Local Park 2 | 4 | |
10261 | 10261 | 10260 | {"type": "Polygon", "coordinates": [[[-121.44704, 37.7336], [-121.44559, 37.7336], [-121.44555, 37.73245], [-121.44403, 37.73247], [-121.4439, 37.73253], [-121.44375, 37.73255], [-121.44368, 37.73219], [-121.44367, 37.73171], [-121.44369, 37.73154], [-121.44484, 37.73154], [-121.44513, 37.73156], [-121.44546, 37.73164], [-121.44566, 37.73167], [-121.44593, 37.73168], [-121.44703, 37.7317], [-121.44704, 37.7336]]]} | Open Access 1 | 17981 | Ceciliani Park | 16992 | 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 | 10.923 | Ceciliani 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 |
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]);