units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where DES_TP = 2 and MNG_AGENCY = 159
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 13
MNG_AGENCY 1
- Tulare, City of · 13 ✖
DES_TP 1
- Local Park · 13 ✖
ACCESS_TYP 1
- Open Access 13
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 | |
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]);