superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where MNG_AGENCY = 390 sorted by id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3050 | 3050 | 3049 | {"type": "Polygon", "coordinates": [[[-121.42023, 37.71427], [-121.42012, 37.71451], [-121.41982, 37.71452], [-121.41974, 37.71457], [-121.41934, 37.71457], [-121.41934, 37.71428], [-121.42023, 37.71427]]]} | Open Access 1 | Clyde Abbott Park | 17449 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.541 | Clyde Abbott Park | ||
3051 | 3051 | 3050 | {"type": "Polygon", "coordinates": [[[-121.4747, 37.74883], [-121.47108, 37.75046], [-121.47055, 37.74971], [-121.4706, 37.7496], [-121.47262, 37.74865], [-121.47268, 37.74866], [-121.47276, 37.74864], [-121.47341, 37.74834], [-121.4747, 37.74883]]]} | Open Access 1 | Clyde Bland Park | 17450 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 8.606 | Clyde Bland Park | ||
3338 | 3338 | 3337 | {"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.73211], [-121.43444, 37.73211], [-121.43449, 37.73215], [-121.43453, 37.73346]]]} | Open Access 1 | Fisher Park | 18920 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 2.005 | Fisher Park | ||
3435 | 3435 | 3434 | {"type": "Polygon", "coordinates": [[[-121.46404, 37.74007], [-121.46402, 37.7402], [-121.46398, 37.74035], [-121.4638, 37.74082], [-121.46369, 37.74103], [-121.46354, 37.74122], [-121.46326, 37.74106], [-121.46298, 37.74106], [-121.46297, 37.74002], [-121.46397, 37.74002], [-121.46404, 37.74007]]]} | Open Access 1 | Daniel Busch Park | 17919 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 2.397 | Daniel Busch Park | ||
3649 | 3649 | 3648 | {"type": "Polygon", "coordinates": [[[-121.45011, 37.69731], [-121.44977, 37.69731], [-121.44981, 37.69723], [-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 | Don Close Park | 18200 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 3.749 | Don Close Park | ||
3663 | 3663 | 3662 | {"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.74687]]]} | Open Access 1 | Dorlane Thrasher Park | 18220 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.095 | Dorlane Thrasher Park | ||
3700 | 3700 | 3699 | {"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 | Dr Powers Park | 18264 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 11.137 | Dr Powers Park | ||
3701 | 3701 | 3700 | {"type": "Polygon", "coordinates": [[[-121.46131, 37.74542], [-121.4613, 37.74549], [-121.46114, 37.74564], [-121.46104, 37.7458], [-121.46064, 37.74569], [-121.46063, 37.74505], [-121.46067, 37.74505], [-121.4607, 37.74513], [-121.46077, 37.74517], [-121.46087, 37.74518], [-121.46098, 37.74516], [-121.46107, 37.74517], [-121.46118, 37.74526], [-121.46131, 37.74542]]]} | Open Access 1 | Dr Ralph Allen Park | 18265 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.812 | Dr Ralph Allen Park | ||
3764 | 3764 | 3763 | {"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 | Eagan Family Park | 18335 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.526 | Eagan Family Park | ||
3849 | 3849 | 3848 | {"type": "Polygon", "coordinates": [[[-121.43046, 37.7577], [-121.42818, 37.75771], [-121.42817, 37.75587], [-121.42952, 37.75575], [-121.42952, 37.75433], [-121.43045, 37.75433], [-121.43046, 37.7577]]]} | Open Access 1 | El Pescadero Park | 18528 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 13.777 | El Pescadero Park | ||
3978 | 3978 | 3977 | {"type": "Polygon", "coordinates": [[[-121.4577, 37.74148], [-121.45743, 37.74151], [-121.45714, 37.74151], [-121.45707, 37.74146], [-121.45704, 37.74121], [-121.45704, 37.74086], [-121.45711, 37.74081], [-121.45721, 37.74081], [-121.45736, 37.74082], [-121.45766, 37.74088], [-121.45766, 37.74117], [-121.4577, 37.74148]]]} | Open Access 1 | Fabian Park | 18781 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.012 | Fabian Park | ||
3989 | 3989 | 3988 | {"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 | Emhoff Park | 18626 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.475 | Emhoff Park | ||
4094 | 4094 | 4093 | {"type": "MultiPolygon", "coordinates": [[[[-121.44523, 37.72254], [-121.44517, 37.72262], [-121.445, 37.72265], [-121.44446, 37.72266], [-121.44442, 37.72263], [-121.44514, 37.72238], [-121.44523, 37.72254]]], [[[-121.44617, 37.72219], [-121.44613, 37.72226], [-121.4455, 37.72251], [-121.44541, 37.72249], [-121.44532, 37.72231], [-121.44608, 37.72203], [-121.44617, 37.72219]]], [[[-121.44722, 37.72187], [-121.44718, 37.72194], [-121.44644, 37.72215], [-121.44635, 37.72213], [-121.44625, 37.72197], [-121.447, 37.72173], [-121.44715, 37.72179], [-121.44722, 37.72187]]], [[[-121.44868, 37.72149], [-121.44837, 37.72155], [-121.44748, 37.72184], [-121.44739, 37.72181], [-121.44724, 37.72154], [-121.44719, 37.72151], [-121.44711, 37.72149], [-121.44868, 37.72149]]]]} | Open Access 1 | Evans Park | 18754 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.873 | Evans Park | ||
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 |
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]);