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 rowid 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13806 | 13806 | 13805 | {"type": "MultiPolygon", "coordinates": [[[[-121.42324, 37.73007], [-121.42312, 37.73043], [-121.42304, 37.73054], [-121.42293, 37.73066], [-121.42286, 37.7307], [-121.42281, 37.73075], [-121.42269, 37.73092], [-121.42244, 37.73144], [-121.42236, 37.73146], [-121.42037, 37.73086], [-121.4205, 37.7306], [-121.42046, 37.73032], [-121.42052, 37.7303], [-121.42058, 37.73025], [-121.42063, 37.73028], [-121.42096, 37.73028], [-121.42243, 37.73027], [-121.42243, 37.73], [-121.42317, 37.73], [-121.42324, 37.73007]]], [[[-121.42395, 37.72957], [-121.42373, 37.73018], [-121.42344, 37.73014], [-121.4235, 37.73005], [-121.4235, 37.72995], [-121.42347, 37.72989], [-121.42342, 37.72985], [-121.42328, 37.72981], [-121.42327, 37.72957], [-121.42395, 37.72957]]]]} | Open Access 1 | 36377 | Hoyt Park | 20127 | 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 | 6.46 | Hoyt Park | 0 | Local Park 2 | 4 | |
12605 | 12605 | 12604 | {"type": "Polygon", "coordinates": [[[-121.46221, 37.73235], [-121.46069, 37.73235], [-121.46069, 37.73235], [-121.46074, 37.7321], [-121.46088, 37.73177], [-121.46096, 37.73174], [-121.46186, 37.73198], [-121.46176, 37.73224], [-121.46221, 37.73235]]]} | Open Access 1 | 29646 | Hanson Park | 19653 | 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.338 | Hanson Park | 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 | |
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 | |
12597 | 12597 | 12596 | {"type": "Polygon", "coordinates": [[[-121.41396, 37.71962], [-121.41392, 37.71982], [-121.41385, 37.72003], [-121.41374, 37.72023], [-121.4136, 37.72041], [-121.41306, 37.72012], [-121.41309, 37.72005], [-121.41307, 37.71999], [-121.41304, 37.71995], [-121.41303, 37.71942], [-121.4131, 37.71947], [-121.41317, 37.71948], [-121.41325, 37.71947], [-121.41332, 37.71943], [-121.41362, 37.7196], [-121.41396, 37.71962]]]} | Open Access 1 | 29256 | Jim Raymond Park | 20413 | 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.493 | Jim Raymond 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
12394 | 12394 | 12393 | {"type": "Polygon", "coordinates": [[[-121.46771, 37.7481], [-121.46753, 37.74837], [-121.46693, 37.74811], [-121.46713, 37.74782], [-121.46771, 37.7481]]]} | Open Access 1 | 26542 | Eagan Family Park | 18335 | 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.527 | Eagan Family Park | 0 | Local Park 2 | 4 | |
12393 | 12393 | 12392 | {"type": "Polygon", "coordinates": [[[-121.46065, 37.74795], [-121.45957, 37.74796], [-121.45957, 37.74823], [-121.4595, 37.74823], [-121.45949, 37.74796], [-121.45841, 37.74796], [-121.4584, 37.74716], [-121.45933, 37.74714], [-121.4601, 37.74705], [-121.46065, 37.74703], [-121.46065, 37.74795]]]} | Open Access 1 | 26541 | Galli Family Park | 19176 | 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.677 | Galli Family Park | 0 | Local Park 2 | 4 | |
12392 | 12392 | 12391 | {"type": "Polygon", "coordinates": [[[-121.45657, 37.74687], [-121.45652, 37.74691], [-121.45595, 37.74691], [-121.45599, 37.74617], [-121.45652, 37.74613], [-121.45659, 37.74647], [-121.45657, 37.74664], [-121.45657, 37.74687]]]} | Open Access 1 | 26539 | Dorlane Thrasher Park | 18220 | 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.09 | Dorlane Thrasher Park | 0 | Local Park 2 | 4 | |
12391 | 12391 | 12390 | {"type": "Polygon", "coordinates": [[[-121.45011, 37.69731], [-121.44977, 37.69731], [-121.44981, 37.69722], [-121.4498, 37.69714], [-121.44974, 37.69707], [-121.44965, 37.69702], [-121.44954, 37.69701], [-121.44937, 37.69705], [-121.44896, 37.69705], [-121.44877, 37.69703], [-121.44853, 37.69697], [-121.44813, 37.69681], [-121.44781, 37.69675], [-121.44781, 37.69634], [-121.4501, 37.69634], [-121.45011, 37.69731]]]} | Open Access 1 | 26538 | Don Close Park | 18200 | 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.749 | Don Close Park | 0 | Local Park 2 | 4 | |
12390 | 12390 | 12389 | {"type": "Polygon", "coordinates": [[[-121.44968, 37.70208], [-121.44961, 37.70213], [-121.44886, 37.70212], [-121.44856, 37.70204], [-121.44814, 37.70186], [-121.44825, 37.70166], [-121.44851, 37.70147], [-121.44851, 37.70092], [-121.44895, 37.70092], [-121.44912, 37.70094], [-121.44934, 37.70102], [-121.44951, 37.70115], [-121.44961, 37.70128], [-121.44967, 37.70144], [-121.44968, 37.70208]]]} | Open Access 1 | 26537 | Bill Schwartz Park | 16113 | 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.39 | Bill Schwartz 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 | |
12334 | 12334 | 12333 | {"type": "Polygon", "coordinates": [[[-121.45588, 37.74477], [-121.45584, 37.74546], [-121.45541, 37.74547], [-121.45521, 37.74542], [-121.45537, 37.74509], [-121.45541, 37.74483], [-121.45574, 37.74485], [-121.45581, 37.74483], [-121.45588, 37.74477]]]} | Open Access 1 | 26010 | McCray Family Park | 22012 | 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.801 | McCray Family 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]);