superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where MNG_AGENCY = 390
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4098 | 4098 | 4097 | {"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 | Evelyn Costa Park | 18758 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.529 | Evelyn Costa Park | ||
4224 | 4224 | 4223 | {"type": "Polygon", "coordinates": [[[-121.41719, 37.74334], [-121.41718, 37.74344], [-121.41714, 37.74354], [-121.41656, 37.74356], [-121.41656, 37.74296], [-121.41681, 37.74296], [-121.41712, 37.74322], [-121.41717, 37.74327], [-121.41719, 37.74334]]]} | Open Access 1 | Fine Park | 18901 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.743 | Fine Park | ||
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 | ||
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 | ||
4468 | 4468 | 4467 | {"type": "Polygon", "coordinates": [[[-121.46065, 37.74795], [-121.45958, 37.74796], [-121.45957, 37.74823], [-121.4595, 37.74823], [-121.45948, 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 | Galli Family Park | 19176 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 4.681 | Galli Family Park | ||
4597 | 4597 | 4596 | {"type": "Polygon", "coordinates": [[[-121.41718, 37.76135], [-121.41711, 37.76141], [-121.41575, 37.76141], [-121.41574, 37.76097], [-121.41599, 37.76096], [-121.41599, 37.76075], [-121.4171, 37.76075], [-121.41717, 37.7608], [-121.41718, 37.76135]]]} | Open Access 1 | Glover Park | 19351 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 2.141 | Glover 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 | ||
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 | ||
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 | ||
4730 | 4730 | 4729 | {"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.44387, 37.71366], [-121.44389, 37.71351], [-121.44518, 37.71351]]]} | Open Access 1 | Gretchen Talley Park | 19502 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 7.145 | Gretchen Talley Park | ||
4883 | 4883 | 4882 | {"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 | Hanson Park | 19653 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.341 | Hanson 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 | ||
4957 | 4957 | 4956 | {"type": "Polygon", "coordinates": [[[-121.47108, 37.74402], [-121.47101, 37.74408], [-121.47043, 37.74404], [-121.46951, 37.74386], [-121.46946, 37.74379], [-121.46972, 37.74302], [-121.4698, 37.74298], [-121.46999, 37.743], [-121.47047, 37.74301], [-121.47068, 37.74306], [-121.47086, 37.74316], [-121.47101, 37.74331], [-121.47109, 37.74349], [-121.47111, 37.7436], [-121.47108, 37.74402]]]} | Open Access 1 | Hastie Park | 19732 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 3.404 | Hastie Park | ||
5279 | 5279 | 5278 | {"type": "MultiPolygon", "coordinates": [[[[-121.42324, 37.73007], [-121.42312, 37.73043], [-121.42304, 37.73054], [-121.42293, 37.73066], [-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.42242, 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 | Hoyt Park | 20127 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 6.465 | Hoyt Park | ||
5284 | 5284 | 5283 | {"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 | Huck Park | 20131 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.517 | Huck Park | ||
5532 | 5532 | 5531 | {"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.72004], [-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 | Jim Raymond Park | 20413 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.493 | Jim Raymond Park | ||
5536 | 5536 | 5535 | {"type": "Polygon", "coordinates": [[[-121.46126, 37.72127], [-121.46121, 37.72163], [-121.46006, 37.72163], [-121.46005, 37.72138], [-121.45993, 37.72118], [-121.46083, 37.72083], [-121.46105, 37.72115], [-121.46126, 37.72127]]]} | Open Access 1 | Joan Sparks Park | 20417 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.789 | Joan Sparks Park | ||
5550 | 5550 | 5549 | {"type": "Polygon", "coordinates": [[[-121.45903, 37.73485], [-121.4581, 37.73486], [-121.45808, 37.73516], [-121.45791, 37.73516], [-121.4577, 37.73511], [-121.45751, 37.73502], [-121.45736, 37.73489], [-121.45723, 37.73468], [-121.45726, 37.73461], [-121.45766, 37.73446], [-121.45792, 37.73438], [-121.45847, 37.73427], [-121.45903, 37.73423], [-121.45903, 37.73485]]]} | Open Access 1 | John Erb Park | 20435 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 2.508 | John Erb Park | ||
5607 | 5607 | 5606 | {"type": "Polygon", "coordinates": [[[-121.41139, 37.71795], [-121.41016, 37.71795], [-121.41016, 37.71656], [-121.41048, 37.71659], [-121.41138, 37.7166], [-121.41139, 37.71795]]]} | Open Access 1 | Joseph Tiago Park | 20501 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 4.023 | Joseph Tiago Park | ||
5693 | 5693 | 5692 | {"type": "Polygon", "coordinates": [[[-121.40427, 37.71437], [-121.40422, 37.71452], [-121.40414, 37.71465], [-121.40387, 37.71489], [-121.40375, 37.71505], [-121.40367, 37.71508], [-121.40345, 37.71506], [-121.4029, 37.71505], [-121.40271, 37.71503], [-121.40249, 37.71498], [-121.40226, 37.71489], [-121.40213, 37.71481], [-121.402, 37.71469], [-121.40192, 37.71456], [-121.40197, 37.71449], [-121.40237, 37.7144], [-121.40278, 37.71424], [-121.40301, 37.7141], [-121.40327, 37.71391], [-121.40336, 37.71391], [-121.40379, 37.71416], [-121.404, 37.71424], [-121.40422, 37.7143], [-121.40427, 37.71437]]]} | Open Access 1 | Kellogg Park | 20585 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 4.088 | Kellogg Park |
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]);