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 LABEL_NAME descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12054 | 12054 | 12053 | {"type": "Polygon", "coordinates": [[[-121.4498, 37.74505], [-121.44971, 37.74505], [-121.44874, 37.74425], [-121.44865, 37.74416], [-121.44859, 37.74406], [-121.44854, 37.74394], [-121.44853, 37.74383], [-121.44853, 37.74372], [-121.44856, 37.74363], [-121.44868, 37.74344], [-121.44885, 37.74332], [-121.44897, 37.74326], [-121.44914, 37.74321], [-121.44933, 37.7432], [-121.44948, 37.74321], [-121.44964, 37.74325], [-121.44981, 37.74334], [-121.44993, 37.74344], [-121.45002, 37.74356], [-121.45007, 37.74368], [-121.45009, 37.74379], [-121.45009, 37.74464], [-121.45005, 37.74477], [-121.45, 37.74486], [-121.44991, 37.74496], [-121.4498, 37.74505]]]} | Open Access 1 | 24748 | Zanussi Park | 27855 | 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.966 | Zanussi Park | 0 | Local Park 2 | 4 | |
5210 | 5210 | 5209 | {"type": "Polygon", "coordinates": [[[-121.42156, 37.70578], [-121.42154, 37.70599], [-121.42146, 37.70623], [-121.42133, 37.70643], [-121.42117, 37.70658], [-121.42097, 37.70673], [-121.42071, 37.70685], [-121.42045, 37.70691], [-121.42018, 37.70694], [-121.42016, 37.70659], [-121.42016, 37.70596], [-121.42012, 37.70596], [-121.42012, 37.70576], [-121.42156, 37.70578]]]} | Open Access 1 | 24747 | Yasui Park | 27764 | 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 | 3.133 | Yasui 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 | |
12438 | 12438 | 12437 | {"type": "Polygon", "coordinates": [[[-121.42552, 37.69643], [-121.42551, 37.69738], [-121.42467, 37.69738], [-121.42451, 37.69728], [-121.42431, 37.69719], [-121.4241, 37.69713], [-121.42389, 37.6971], [-121.42199, 37.6971], [-121.42179, 37.69706], [-121.42168, 37.69709], [-121.4216, 37.69715], [-121.42115, 37.69714], [-121.42115, 37.69644], [-121.42552, 37.69643]]]} | Open Access 1 | 28066 | Veterans Park | 27050 | 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.874 | Veterans Park | 0 | Local Park 2 | 4 | |
12048 | 12048 | 12047 | {"type": "Polygon", "coordinates": [[[-121.46221, 37.73283], [-121.46197, 37.73283], [-121.46156, 37.73288], [-121.4607, 37.73307], [-121.46069, 37.73235], [-121.46221, 37.73235], [-121.46221, 37.73283]]]} | Open Access 1 | 24728 | Vernor Hanson Park | 27004 | 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.095 | Vernor Hanson 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 | |
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 | |
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 | |
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 | |
12598 | 12598 | 12597 | {"type": "Polygon", "coordinates": [[[-121.4741, 37.74227], [-121.47427, 37.7423], [-121.47443, 37.74235], [-121.47455, 37.74243], [-121.47467, 37.74252], [-121.47477, 37.74264], [-121.47484, 37.74277], [-121.47487, 37.74288], [-121.47488, 37.74301], [-121.47485, 37.74316], [-121.47479, 37.74328], [-121.4747, 37.7434], [-121.47458, 37.7435], [-121.47447, 37.74357], [-121.47428, 37.74365], [-121.47411, 37.74368], [-121.47394, 37.74369], [-121.47397, 37.74306], [-121.47409, 37.74271], [-121.4741, 37.74227]]]} | Open Access 1 | 29257 | Souza Family Park South | 25708 | 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.29 | Souza Family Park South | 0 | Local Park 2 | 4 | |
12603 | 12603 | 12602 | {"type": "Polygon", "coordinates": [[[-121.47489, 37.74603], [-121.47425, 37.7458], [-121.47412, 37.74566], [-121.47354, 37.74546], [-121.47355, 37.74543], [-121.47372, 37.7453], [-121.47385, 37.74524], [-121.47399, 37.74519], [-121.47413, 37.74518], [-121.47428, 37.74518], [-121.47454, 37.74525], [-121.47465, 37.7453], [-121.47475, 37.74538], [-121.47484, 37.74548], [-121.47489, 37.74557], [-121.47493, 37.74568], [-121.47494, 37.7458], [-121.47493, 37.74591], [-121.47489, 37.74603]]]} | Open Access 1 | 29263 | Souza Family Park North | 25707 | 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.579 | Souza Family Park North | 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 | |
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 | |
5424 | 5424 | 5423 | {"type": "Polygon", "coordinates": [[[-121.45127, 37.73155], [-121.45125, 37.73174], [-121.45053, 37.73168], [-121.45049, 37.73173], [-121.45037, 37.73172], [-121.45031, 37.73145], [-121.4506, 37.73144], [-121.4508, 37.73145], [-121.45121, 37.73149], [-121.45127, 37.73155]]]} | Open Access 1 | 24739 | Rippin Park | 24400 | 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.569 | Rippin 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 | |
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 | |
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 | |
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 | |
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 |
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]);