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 map
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 | |
10277 | 10277 | 10276 | {"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 | 18014 | McDonald Park | 22023 | 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.386 | McDonald Park | 0 | Local Park 2 | 4 | |
2611 | 2611 | 2610 | {"type": "MultiPolygon", "coordinates": [[[[-121.44227, 37.72363], [-121.44223, 37.7237], [-121.44136, 37.72401], [-121.44088, 37.72409], [-121.4408, 37.72405], [-121.44072, 37.7238], [-121.44073, 37.72376], [-121.44075, 37.72375], [-121.44091, 37.72373], [-121.44135, 37.72373], [-121.44149, 37.72378], [-121.44161, 37.72377], [-121.44167, 37.72374], [-121.4417, 37.72369], [-121.44171, 37.72362], [-121.44167, 37.72356], [-121.44179, 37.72351], [-121.44179, 37.72335], [-121.44221, 37.72335], [-121.44223, 37.7235], [-121.44227, 37.72363]]], [[[-121.44384, 37.72334], [-121.44325, 37.72335], [-121.44255, 37.72359], [-121.44246, 37.72355], [-121.44243, 37.72347], [-121.44242, 37.72313], [-121.44247, 37.72308], [-121.44285, 37.72303], [-121.4435, 37.72286], [-121.44384, 37.72283], [-121.44384, 37.72334]]]]} | Open Access 1 | 18010 | Barbozo Park | 15810 | 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.772 | Barbozo 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 | |
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 | |
5415 | 5415 | 5414 | {"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 | 24743 | Joseph Tiago Park | 20501 | 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.024 | Joseph Tiago Park | 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 | |
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 | |
2614 | 2614 | 2613 | {"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 | 17991 | Fine Park | 18901 | 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.743 | Fine 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 | |
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 | |
3708 | 3708 | 3707 | {"type": "Polygon", "coordinates": [[[-121.42033, 37.73804], [-121.42004, 37.73828], [-121.41973, 37.73803], [-121.42002, 37.7378], [-121.42033, 37.73804]]]} | Open Access 1 | 44513 | Civic Center Plaza | 17369 | 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.348 | Civic Ctr. Plaza | 0 | Local Park 2 | 4 | |
5210 | 5210 | 5209 | {"type": "Polygon", "coordinates": [[[-121.42156, 37.70578], [-121.42154, 37.70599], [-121.42146, 37.70623], [-121.42133, 37.70643], [-121.42117, 37.70658], [-121.42097, 37.70673], [-121.42071, 37.70685], [-121.42045, 37.70691], [-121.42018, 37.70694], [-121.42016, 37.70659], [-121.42016, 37.70596], [-121.42012, 37.70596], [-121.42012, 37.70576], [-121.42156, 37.70578]]]} | Open Access 1 | 24747 | Yasui Park | 27764 | 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.133 | Yasui Park | 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 | |
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 | |
2242 | 2242 | 2241 | {"type": "Polygon", "coordinates": [[[-121.42572, 37.74329], [-121.42566, 37.7433], [-121.42566, 37.74341], [-121.42126, 37.74341], [-121.42125, 37.74213], [-121.42571, 37.74214], [-121.42572, 37.74329]]]} | Open Access 1 | 18006 | Lincoln Park | 21273 | 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 | 13.731 | Lincoln Park | 0 | Local Park 2 | 4 | |
5399 | 5399 | 5398 | {"type": "Polygon", "coordinates": [[[-121.42879, 37.72261], [-121.42879, 37.72289], [-121.42847, 37.72289], [-121.42846, 37.72316], [-121.42824, 37.72315], [-121.42824, 37.72261], [-121.42879, 37.72261]]]} | Open Access 1 | 24742 | Sullivan Park | 25950 | 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 | Sullivan Park | 0 | Local Park 2 | 4 | |
10274 | 10274 | 10273 | {"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 | 18003 | Larson Park | 21038 | 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.105 | Larson Park | 0 | Local Park 2 | 4 | |
2609 | 2609 | 2608 | {"type": "Polygon", "coordinates": [[[-121.43046, 37.7577], [-121.42818, 37.75771], [-121.42817, 37.75587], [-121.42953, 37.75575], [-121.42952, 37.75433], [-121.43045, 37.75433], [-121.43046, 37.7577]]]} | Open Access 1 | 17988 | El Pescadero Park | 18528 | 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 | 13.77 | El Pescadero 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 |
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]);