units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
16 rows where COUNTY = 29, MNG_AGENCY = 159 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
- City Agency · 16 ✖
MNG_AGENCY 1
- Tulare, City of · 16 ✖
ACCESS_TYP 1
- Open Access 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
405 | 405 | 404 | {"type": "Polygon", "coordinates": [[[-119.34539, 36.23661], [-119.3433, 36.23661], [-119.34258, 36.23569], [-119.34356, 36.2354], [-119.34401, 36.23528], [-119.3445, 36.23512], [-119.34479, 36.23504], [-119.34501, 36.23538], [-119.34514, 36.23564], [-119.34523, 36.23588], [-119.34531, 36.23614], [-119.34539, 36.23661]]]} | Open Access 1 | 1245 | Blain Park | 16148 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 7.423 | Blain Park | 0 | Local Park 2 | 4 | |
407 | 407 | 406 | {"type": "Polygon", "coordinates": [[[-119.35321, 36.21913], [-119.3532, 36.22023], [-119.35146, 36.22027], [-119.351, 36.21817], [-119.35206, 36.21818], [-119.35301, 36.21816], [-119.3532, 36.21824], [-119.35321, 36.21913]]]} | Open Access 1 | 1252 | Centennial Park | 17030 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 10.109 | Centennial Park | 0 | Local Park 2 | 4 | |
419 | 419 | 418 | {"type": "Polygon", "coordinates": [[[-119.35505, 36.20879], [-119.35454, 36.20886], [-119.35447, 36.20859], [-119.35391, 36.20865], [-119.35361, 36.2071], [-119.35416, 36.20701], [-119.35428, 36.20746], [-119.35473, 36.2074], [-119.35505, 36.20879]]]} | Open Access 1 | 1293 | Tyler Park | 26629 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 3.989 | Tyler Park | 0 | Local Park 2 | 4 | |
421 | 421 | 420 | {"type": "Polygon", "coordinates": [[[-119.34342, 36.20836], [-119.34235, 36.20852], [-119.34211, 36.20743], [-119.34318, 36.20728], [-119.34342, 36.20836]]]} | Open Access 1 | 1297 | Zumwalt Park | 27871 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 2.969 | Zumwalt Park | 0 | Local Park 2 | 4 | |
4339 | 4339 | 4338 | {"type": "Polygon", "coordinates": [[[-119.32188, 36.22778], [-119.32192, 36.22826], [-119.32202, 36.22887], [-119.32208, 36.2293], [-119.32211, 36.22973], [-119.32211, 36.23016], [-119.32207, 36.23074], [-119.322, 36.23117], [-119.3219, 36.23165], [-119.32173, 36.23221], [-119.32058, 36.23195], [-119.32051, 36.22779], [-119.32188, 36.22778]]]} | Open Access 1 | 45509 | Del Lago Park | 28343 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 15.428 | Del Lago Park | 0 | Local Park 2 | 4 | |
5609 | 5609 | 5608 | {"type": "Polygon", "coordinates": [[[-119.37747, 36.18538], [-119.37486, 36.1854], [-119.37481, 36.1819], [-119.37744, 36.18188], [-119.37747, 36.18538]]]} | Open Access 1 | 1281 | Tulare Cycle Park | 26564 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 22.659 | Tulare Cycle Park | 0 | Local Park 2 | 4 | |
6182 | 6182 | 6181 | {"type": "Polygon", "coordinates": [[[-119.34925, 36.20749], [-119.34773, 36.20771], [-119.34749, 36.20666], [-119.34899, 36.20642], [-119.34925, 36.20749]]]} | Open Access 1 | 1233 | Alice Topham Park | 15363 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 4.081 | Alice Topham Park | 0 | Local Park 2 | 4 | |
6201 | 6201 | 6200 | {"type": "Polygon", "coordinates": [[[-119.37383, 36.21451], [-119.37382, 36.21675], [-119.37153, 36.2167], [-119.37157, 36.21455], [-119.37383, 36.21451]]]} | Open Access 1 | 1241 | Bender Park | 16006 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 12.281 | Bender Park | 0 | Local Park 2 | 4 | |
6208 | 6208 | 6207 | {"type": "Polygon", "coordinates": [[[-119.33571, 36.19826], [-119.33384, 36.19827], [-119.33384, 36.19678], [-119.33571, 36.19678], [-119.33571, 36.19826]]]} | Open Access 1 | 1260 | Cesar E. Chavez Memorial Park | 17103 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 6.91 | Cesar E. Chavez Memorial Park | 0 | Local Park 2 | 4 | |
6211 | 6211 | 6210 | {"type": "Polygon", "coordinates": [[[-119.3233, 36.18707], [-119.32329, 36.18808], [-119.32324, 36.18902], [-119.32206, 36.189], [-119.32182, 36.18895], [-119.32185, 36.18881], [-119.32181, 36.18875], [-119.32173, 36.1887], [-119.32165, 36.1887], [-119.32156, 36.18874], [-119.32151, 36.1888], [-119.32152, 36.18887], [-119.32154, 36.18892], [-119.32161, 36.18898], [-119.32162, 36.18908], [-119.32118, 36.18909], [-119.32118, 36.18901], [-119.32081, 36.189], [-119.32081, 36.18827], [-119.32084, 36.18707], [-119.3233, 36.18707]]]} | Open Access 1 | 1265 | Cypress Park | 17881 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 11.649 | Cypress Park | 0 | Local Park 2 | 4 | |
6213 | 6213 | 6212 | {"type": "Polygon", "coordinates": [[[-119.32188, 36.21618], [-119.32188, 36.21842], [-119.32183, 36.22027], [-119.31808, 36.22026], [-119.31774, 36.22029], [-119.3177, 36.22008], [-119.31772, 36.21991], [-119.31772, 36.21844], [-119.31778, 36.21841], [-119.31977, 36.21841], [-119.31977, 36.2173], [-119.32126, 36.21648], [-119.32188, 36.21618]]]} | Open Access 1 | 1269 | Live Oak Park | 21372 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 27.621 | Live Oak Park | 0 | Local Park 2 | 4 | |
6215 | 6215 | 6214 | {"type": "Polygon", "coordinates": [[[-119.3522, 36.19197], [-119.35219, 36.19301], [-119.35165, 36.19309], [-119.35141, 36.19317], [-119.35092, 36.1934], [-119.35066, 36.19303], [-119.35057, 36.19297], [-119.35065, 36.19283], [-119.35113, 36.19227], [-119.35138, 36.1921], [-119.35166, 36.19199], [-119.3522, 36.19197]]]} | Open Access 1 | 1273 | Parkwood Meadows Park | 23463 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 3.683 | Parkwood Meadows Park | 0 | Local Park 2 | 4 | |
6219 | 6219 | 6218 | {"type": "Polygon", "coordinates": [[[-119.36219, 36.22769], [-119.35786, 36.22774], [-119.35784, 36.22578], [-119.36213, 36.22571], [-119.36219, 36.22769]]]} | Open Access 1 | 1277 | Prosperity Sports Park | 24022 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 20.867 | Prosperity Sports Park | 0 | Local Recreation Area 3 | 4 | |
6234 | 6234 | 6233 | {"type": "MultiPolygon", "coordinates": [[[[-119.38011, 36.20364], [-119.37241, 36.20906], [-119.3722, 36.20885], [-119.37894, 36.20412], [-119.37956, 36.20366], [-119.38011, 36.20364]]], [[[-119.36677, 36.21054], [-119.36676, 36.21078], [-119.36633, 36.21079], [-119.36632, 36.21055], [-119.36677, 36.21054]]], [[[-119.36626, 36.21079], [-119.36574, 36.21081], [-119.36574, 36.21055], [-119.36625, 36.21055], [-119.36626, 36.21079]]], [[[-119.37221, 36.2092], [-119.37158, 36.20964], [-119.37119, 36.20987], [-119.37055, 36.21019], [-119.36979, 36.21047], [-119.36901, 36.21068], [-119.36805, 36.21082], [-119.36711, 36.21083], [-119.36704, 36.21077], [-119.36704, 36.21059], [-119.36772, 36.21058], [-119.36853, 36.21049], [-119.3691, 36.21038], [-119.36964, 36.21023], [-119.36997, 36.21012], [-119.37039, 36.20996], [-119.37088, 36.20972], [-119.3714, 36.20941], [-119.372, 36.20899], [-119.37221, 36.2092]]], [[[-119.36545, 36.21055], [-119.36545, 36.21083], [-119.36437, 36.21083], [-119.36438, 36.21056], [-119.36545, 36.21055]]], [[[-119.36409, 36.21056], [-119.36408, 36.21084], [-119.36357, 36.21084], [-119.36358, 36.21056], [-119.36409, 36.21056]]], [[[-119.36351, 36.21056], [-119.3635, 36.21084], [-119.36301, 36.21084], [-119.36301, 36.21056], [-119.36351, 36.21056]]], [[[-119.36272, 36.21062], [-119.36271, 36.21084], [-119.36222, 36.21084], [-119.36221, 36.21063], [-119.36272, 36.21062]]], [[[-119.36214, 36.21062], [-119.36213, 36.21084], [-119.36164, 36.21084], [-119.36163, 36.21063], [-119.36214, 36.21062]]], [[[-119.36136, 36.21062], [-119.36136, 36.21087], [-119.36085, 36.21087], [-119.36082, 36.21067], [-119.36076, 36.21087], [-119.36034, 36.21088], [-119.36028, 36.21062], [-119.36136, 36.21062]]], [[[-119.36001, 36.21062], [-119.35998, 36.21089], [-119.35952, 36.21097], [-119.3595, 36.21062], [-119.36001, 36.21062]]], [[[-119.35873, 36.21096], [-119.35794, 36.21098], [-119.35793, 36.21089], [-119.35759, 36.21094], [-119.35757, 36.21087], [-119.35709, 36.21094], [-119.35705, 36.21074], [-119.35754, 36.21066], [-119.35756, 36.21072], [-119.35793, 36.21067], [-119.35794, 36.21062], [-119.35865, 36.21061], [-119.35865, 36.21068], [-119.35873, 36.21096]]], [[[-119.35552, 36.21089], [-119.355, 36.21097], [-119.35497, 36.2109], [-119.35443, 36.21098], [-119.35438, 36.21077], [-119.35546, 36.21061], [-119.35552, 36.21089]]], [[[-119.35682, 36.21091], [-119.35636, 36.21098], [-119.35628, 36.21077], [-119.35628, 36.21092], [-119.3558, 36.21099], [-119.35576, 36.21079], [-119.35677, 36.21064], [-119.35682, 36.21091]]], [[[-119.35943, 36.21063], [-119.35941, 36.21099], [-119.35912, 36.21105], [-119.35905, 36.211], [-119.35893, 36.21062], [-119.35943, 36.21063]]], [[[-119.35417, 36.21102], [-119.35311, 36.21118], [-119.35305, 36.21097], [-119.35412, 36.21081], [-119.35417, 36.21102]]], [[[-119.35283, 36.21122], [-119.35177, 36.21138], [-119.35171, 36.21116], [-119.35279, 36.21101], [-119.35283, 36.21122]]], [[[-119.3515, 36.21141], [-119.35043, 36.21158], [-119.35037, 36.21136], [-119.35145, 36.21121], [-119.3515, 36.21141]]], [[[-119.34835, 36.21188], [-119.34729, 36.21203], [-119.34724, 36.21182], [-119.3483, 36.21166], [-119.34835, 36.21188]]], [[[-119.34701, 36.21207], [-119.34594, 36.21223], [-119.34593, 36.21212], [-119.34579, 36.21162], [-119.34687, 36.21146], [-119.34701, 36.21207]]], [[[-119.34567, 36.21228], [-119.34461, 36.21245], [-119.34456, 36.21222], [-119.34562, 36.21207], [-119.34566, 36.21218], [-119.34567, 36.21228]]], [[[-119.34435, 36.21251], [-119.34328, 36.21266], [-119.34322, 36.21241], [-119.34429, 36.21226], [-119.34435, 36.21251]]], [[[-119.34301, 36.21266], [-119.34193, 36.21282], [-119.34188, 36.21262], [-119.34295, 36.21245], [-119.34301, 36.21266]]], [[[-119.34164, 36.21273], [-119.34059, 36.21289], [-119.34003, 36.21295], [-119.34003, 36.21307], [-119.33786, 36.21339], [-119.33785, 36.21326], [-119.34002, 36.21295], [-119.34009, 36.21288], [-119.34136, 36.21268], [-119.34163, 36.21265], [-119.34164, 36.21273]]], [[[-119.33765, 36.21323], [-119.33765, 36.2135], [-119.33456, 36.21394], [-119.33109, 36.21442], [-119.33109, 36.21413], [-119.33128, 36.21411], [-119.33686, 36.21332], [-119.33765, 36.21323]]], [[[-119.33086, 36.21418], [-119.33086, 36.21446], [-119.32945, 36.21465], [-119.32938, 36.21438], [-119.33086, 36.21418]]], [[[-119.32876, 36.21474], [-119.32488, 36.21528], [-119.32438, 36.21538], [-119.32385, 36.2155], [-119.32316, 36.21569], [-119.32258, 36.21589], [-119.32214, 36.21607], [-119.32214, 36.21576], [-119.32296, 36.21546], [-119.32344, 36.21531], [-119.32407, 36.21516], [-119.32489, 36.21501], [-119.32567, 36.21489], [-119.32867, 36.21448], [-119.32876, 36.21474]]], [[[-119.32188, 36.21587], [-119.32188, 36.21618], [-119.32126, 36.21648], [-119.31978, 36.2173], [-119.31977, 36.21841], [-119.31778, 36.21841], [-119.31321, 36.22093], [-119.31321, 36.22059], [-119.31718, 36.21841], [-119.32025, 36.2167], [-119.3212, 36.21619], [-119.32188, 36.21587]]], [[[-119.31283, 36.22135], [-119.306, 36.22588], [-119.30519, 36.22589], [-119.31283, 36.22082], [-119.31283, 36.22135]]]]} | Open Access 1 | 1285 | Tulare Santa Fe Public Trail | 26569 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 52.933 | Tulare Santa Fe Public Trail | 0 | Local Recreation Area 3 | 4 | |
14131 | 14131 | 14130 | {"type": "Polygon", "coordinates": [[[-119.32522, 36.15647], [-119.32197, 36.1564], [-119.32208, 36.15273], [-119.32208, 36.15273], [-119.32522, 36.15647]]]} | Open Access 1 | 48851 | Elk Bayou Soccer Complex | 33571 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | https://www.tulare.ca.gov/Home/Components/FacilityDirectory/FacilityDirectory/22/155 | Tulare 29 | 14.659 | Elk Bayou Soccer Complex | 0 | Local Recreation Area 3 | 4 |
14703 | 14703 | 14702 | {"type": "Polygon", "coordinates": [[[-119.36351, 36.19933], [-119.36052, 36.19935], [-119.36051, 36.19804], [-119.36351, 36.19802], [-119.36351, 36.19933]]]} | Open Access 1 | 45058 | Mulcahy Park | 22588 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 9.715 | Mulcahy 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]);