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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5697 | 5697 | 5696 | {"type": "Polygon", "coordinates": [[[-121.45642, 37.74867], [-121.45604, 37.74868], [-121.45602, 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 | Kelly Park | 20589 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.503 | Kelly Park | ||
5708 | 5708 | 5707 | {"type": "Polygon", "coordinates": [[[-121.45063, 37.75672], [-121.45057, 37.75678], [-121.45031, 37.75683], [-121.45007, 37.75691], [-121.44987, 37.757], [-121.44955, 37.75719], [-121.44932, 37.75727], [-121.44902, 37.75734], [-121.44873, 37.75737], [-121.44873, 37.75595], [-121.44894, 37.75594], [-121.44894, 37.75568], [-121.44929, 37.75568], [-121.44929, 37.75575], [-121.44942, 37.75584], [-121.44972, 37.75589], [-121.45019, 37.75569], [-121.45061, 37.75569], [-121.45063, 37.75672]]]} | Open Access 1 | Kenner Park | 20607 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 6.013 | Kenner Park | ||
5752 | 5752 | 5751 | {"type": "Polygon", "coordinates": [[[-121.45599, 37.72415], [-121.45592, 37.72421], [-121.45585, 37.72441], [-121.4558, 37.72465], [-121.45552, 37.72465], [-121.45527, 37.72461], [-121.45507, 37.72452], [-121.45491, 37.72438], [-121.45483, 37.72427], [-121.45479, 37.72415], [-121.45512, 37.72411], [-121.45513, 37.72397], [-121.45531, 37.72375], [-121.45558, 37.72365], [-121.45579, 37.72399], [-121.45599, 37.72415]]]} | Open Access 1 | Kingsley Chadeayne Park | 20670 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.718 | Kingsley Chadeayne Park | ||
6007 | 6007 | 6006 | {"type": "Polygon", "coordinates": [[[-121.43013, 37.72105], [-121.42976, 37.72105], [-121.42963, 37.72102], [-121.42947, 37.72103], [-121.4282, 37.72103], [-121.42812, 37.72097], [-121.42811, 37.71999], [-121.43012, 37.71998], [-121.43013, 37.72105]]]} | Open Access 1 | Larson Park | 21038 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 5.105 | Larson Park | ||
6202 | 6202 | 6201 | {"type": "Polygon", "coordinates": [[[-121.42572, 37.74329], [-121.42567, 37.74331], [-121.42566, 37.74341], [-121.42126, 37.74341], [-121.42125, 37.74213], [-121.42571, 37.74214], [-121.42572, 37.74329]]]} | Open Access 1 | Lincoln Park | 21273 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 13.731 | Lincoln Park | ||
6446 | 6446 | 6445 | {"type": "Polygon", "coordinates": [[[-121.43213, 37.70025], [-121.43155, 37.70025], [-121.43139, 37.70033], [-121.4313, 37.70034], [-121.43122, 37.70038], [-121.43122, 37.69928], [-121.43143, 37.69924], [-121.43173, 37.69922], [-121.43194, 37.69924], [-121.432, 37.69929], [-121.43201, 37.69986], [-121.43205, 37.70005], [-121.43213, 37.70025]]]} | Open Access 1 | Lowes Park | 21569 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 2.016 | Lowes Park | ||
6703 | 6703 | 6702 | {"type": "Polygon", "coordinates": [[[-121.45704, 37.72677], [-121.45695, 37.72681], [-121.45695, 37.72733], [-121.45562, 37.72733], [-121.45555, 37.72727], [-121.45554, 37.72632], [-121.4556, 37.72627], [-121.45595, 37.7262], [-121.4562, 37.72617], [-121.45694, 37.72616], [-121.45695, 37.72668], [-121.45704, 37.72672], [-121.45704, 37.72677]]]} | Open Access 1 | Marlow Park | 21882 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 3.878 | Marlow Park | ||
6805 | 6805 | 6804 | {"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 | McCray Family Park | 22012 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.802 | McCray Family Park | ||
6808 | 6808 | 6807 | {"type": "MultiPolygon", "coordinates": [[[[-121.42658, 37.73042], [-121.42564, 37.73045], [-121.42563, 37.73015], [-121.42657, 37.73015], [-121.42658, 37.73042]]], [[[-121.42659, 37.7308], [-121.42566, 37.73083], [-121.42564, 37.73051], [-121.42658, 37.73048], [-121.42659, 37.7308]]]]} | Open Access 1 | McDonald Park | 22023 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.385 | McDonald Park | ||
7237 | 7237 | 7236 | {"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 | Mount Diablo Park | 22526 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.239 | Mount Diablo Park | ||
7238 | 7238 | 7237 | {"type": "Polygon", "coordinates": [[[-121.43743, 37.71857], [-121.43736, 37.71858], [-121.43729, 37.71879], [-121.43722, 37.71879], [-121.43715, 37.71858], [-121.43708, 37.71857], [-121.43708, 37.71831], [-121.43742, 37.71831], [-121.43743, 37.71857]]]} | Open Access 1 | Mount Oso Park | 22529 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.292 | Mount Oso Park | ||
7343 | 7343 | 7342 | {"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 | New Harmon Park | 22707 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.505 | New Harmon Park | ||
8026 | 8026 | 8025 | {"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 | Patzer Park | 23527 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.497 | Patzer Park | ||
8224 | 8224 | 8223 | {"type": "Polygon", "coordinates": [[[-121.45925, 37.73898], [-121.45645, 37.73897], [-121.45529, 37.73893], [-121.45515, 37.7389], [-121.45501, 37.73885], [-121.454, 37.73807], [-121.45375, 37.73775], [-121.45365, 37.73739], [-121.45378, 37.73749], [-121.45465, 37.73749], [-121.45466, 37.73714], [-121.45923, 37.73713], [-121.45924, 37.73765], [-121.45925, 37.73898]]]} | Open Access 1 | Plasencia Fields | 23770 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 21.699 | Plasencia Fields | ||
8289 | 8289 | 8288 | {"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 | Pombo Family Park | 23877 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.505 | Pombo Family Park | ||
8536 | 8536 | 8535 | {"type": "Polygon", "coordinates": [[[-121.42879, 37.72261], [-121.42879, 37.72289], [-121.42848, 37.72289], [-121.42846, 37.72316], [-121.42824, 37.72315], [-121.42824, 37.72261], [-121.42879, 37.72261]]]} | Open Access 1 | Sullivan Park | 25950 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.519 | Sullivan Park | ||
8741 | 8741 | 8740 | {"type": "Polygon", "coordinates": [[[-121.45127, 37.73155], [-121.45125, 37.73174], [-121.45054, 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 | Rippin Park | 24400 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.569 | Rippin Park | ||
9704 | 9704 | 9703 | {"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.43691, 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 | Sister Cities Park | 25522 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.506 | Sister Cities Park | ||
9734 | 9734 | 9733 | {"type": "Polygon", "coordinates": [[[-121.44216, 37.75628], [-121.44189, 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 | Slayter Park | 25556 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.496 | Slayter Park | ||
9791 | 9791 | 9790 | {"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.74523], [-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 | Souza Family Park North | 25707 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.578 | Souza Family Park North |
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]);