units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where AGNCY_LEV = 2 and MNG_AGENCY = 390 sorted by rowid descending
This data as json, copyable, CSV (advanced)
DES_TP 4
- Local Park 50
- Local Recreation Area 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 53
MNG_AGENCY 1
- Tracy, City of · 53 ✖
ACCESS_TYP 1
- Open Access 53
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
12053 | 12053 | 12052 | {"type": "Polygon", "coordinates": [[[-121.45704, 37.72677], [-121.45695, 37.72681], [-121.45695, 37.72733], [-121.45562, 37.72732], [-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 | 24735 | Marlow Park | 21882 | 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.878 | Marlow Park | 0 | Local Park 2 | 4 | |
12052 | 12052 | 12051 | {"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 | 24734 | Lowes Park | 21569 | 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.016 | Lowes Park | 0 | Local Park 2 | 4 | |
12051 | 12051 | 12050 | {"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 | 24732 | Kellogg Park | 20585 | 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.088 | Kellogg Park | 0 | Local Park 2 | 4 | |
12050 | 12050 | 12049 | {"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.7125], [-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 | 24731 | Fred Icardi Park | 19076 | 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.344 | Fred Icardi Park | 0 | Local Park 2 | 4 | |
12049 | 12049 | 12048 | {"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 | 24729 | Hastie Park | 19732 | 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.404 | Hastie 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 | |
12047 | 12047 | 12046 | {"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 | 24727 | Golden Spike | 19373 | 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 | Golden Spike | None 1059 | |||
12046 | 12046 | 12045 | {"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 | 24726 | Glover Park | 19351 | 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.139 | Glover Park | 0 | Local Park 2 | 4 | |
12045 | 12045 | 12044 | {"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 | 24725 | Fitzpatrick Park | 18932 | 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.453 | Fitzpatrick Park | 0 | Local Park 2 | 4 | |
12044 | 12044 | 12043 | {"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.73212], [-121.43444, 37.73211], [-121.43449, 37.73215], [-121.43453, 37.73346]]]} | Open Access 1 | 24724 | Fisher Park | 18920 | 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.004 | Fisher Park | 0 | Local Park 2 | 4 | |
12043 | 12043 | 12042 | {"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 | 24723 | Evans Park | 18754 | 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.873 | Evans Park | 0 | Local Park 2 | 4 | |
12042 | 12042 | 12041 | {"type": "Polygon", "coordinates": [[[-121.45903, 37.73485], [-121.45809, 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 | 24722 | John Erb Park | 20435 | 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.506 | John Erb Park | 0 | Local Park 2 | 4 | |
12041 | 12041 | 12040 | {"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 | 24721 | Emhoff Park | 18626 | 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.475 | Emhoff Park | 0 | Local Park 2 | 4 | |
12040 | 12040 | 12039 | {"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 | 24720 | Evelyn Costa Park | 18758 | 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.529 | Evelyn Costa Park | 0 | Local Park 2 | 4 | |
12039 | 12039 | 12038 | {"type": "Polygon", "coordinates": [[[-121.46131, 37.74542], [-121.4613, 37.74549], [-121.46114, 37.74565], [-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 | 24715 | Dr Ralph Allen Park | 18265 | 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.812 | Dr Ralph Allen Park | 0 | Local Park 2 | 4 | |
12038 | 12038 | 12037 | {"type": "Polygon", "coordinates": [[[-121.42023, 37.71427], [-121.42012, 37.71451], [-121.41981, 37.71452], [-121.41974, 37.71457], [-121.41934, 37.71457], [-121.41934, 37.71428], [-121.42023, 37.71427]]]} | Open Access 1 | 24714 | Clyde Abbott Park | 17449 | 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.541 | Clyde Abbott Park | 0 | Local Park 2 | 4 | |
12014 | 12014 | 12013 | {"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 | 24697 | Huck Park | 20131 | 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 | Huck Park | 0 | Local Park 2 | 4 | |
12013 | 12013 | 12012 | {"type": "Polygon", "coordinates": [[[-121.4577, 37.74148], [-121.45744, 37.74151], [-121.45714, 37.74152], [-121.45707, 37.74146], [-121.45704, 37.74121], [-121.45704, 37.74086], [-121.45711, 37.74081], [-121.45722, 37.74081], [-121.45736, 37.74082], [-121.45766, 37.74088], [-121.45766, 37.74117], [-121.4577, 37.74148]]]} | Open Access 1 | 24696 | Fabian Park | 18781 | 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.012 | Fabian 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]);