units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where COUNTY = 29 and MNG_AG_TYP = 11
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, MNG_AG_ID
MNG_AGENCY 9
- Exeter Cemetery District 3
- Lindsay-Strathmore Cemetery District 2
- Porterville Public Cemetery District 2
- Woodlake Public Cemetery District 1
- Tulare Veterans Memorial District 1
- Woodville Public Cemetery District 1
- Tulare Cemetery District 1
- Visalia Cemetery District 1
- Three Rivers Public Cemetery District 1
DES_TP 2
MNG_AG_TYP 1
- Cemetery District · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
239 | 239 | 238 | {"type": "Polygon", "coordinates": [[[-119.19796, 36.31684], [-119.19795, 36.31782], [-119.19604, 36.31789], [-119.196, 36.31689], [-119.19796, 36.31684]]]} | Open Access 1 | 773 | Deep Creek Cemetery | 17988 | 2033 | Exeter Cemetery District 99 | Special District 4 | Cemetery District 11 | Special District 4 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Tulare 29 | 4.704 | Deep Creek Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
286 | 286 | 285 | {"type": "Polygon", "coordinates": [[[-119.13521, 36.30947], [-119.1351, 36.31147], [-119.13075, 36.31143], [-119.13077, 36.31043], [-119.1323, 36.31043], [-119.13238, 36.30936], [-119.13521, 36.30947]]]} | Open Access 1 | 778 | Exeter Cemetery | 18773 | 2033 | Exeter Cemetery District 99 | Special District 4 | Cemetery District 11 | Special District 4 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Tulare 29 | 18.069 | Exeter Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
290 | 290 | 289 | {"type": "Polygon", "coordinates": [[[-119.10764, 36.34977], [-119.10762, 36.35107], [-119.1054, 36.35107], [-119.10542, 36.34976], [-119.10764, 36.34977]]]} | Open Access 1 | 782 | Hamilton Cemetery | 19616 | 2033 | Exeter Cemetery District 99 | Special District 4 | Cemetery District 11 | Special District 4 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Tulare 29 | 7.139 | Hamilton Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
298 | 298 | 297 | {"type": "Polygon", "coordinates": [[[-118.95592, 36.14627], [-118.95521, 36.14626], [-118.9552, 36.14479], [-118.95589, 36.1448], [-118.95592, 36.14627]]]} | Open Access 1 | 802 | Frazier Valley Cemetery | 19071 | 2060 | Lindsay-Strathmore Cemetery District 122 | Special District 4 | Cemetery District 11 | Special District 4 | 2060 | Lindsay-Strathmore Cemetery District 119 | Special District 4 | Cemetery District 11 | Tulare 29 | 2.538 | Frazier Valley Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
304 | 304 | 303 | {"type": "Polygon", "coordinates": [[[-119.10787, 36.41389], [-119.10786, 36.41561], [-119.10573, 36.41561], [-119.10572, 36.4146], [-119.10643, 36.4146], [-119.10644, 36.41385], [-119.10787, 36.41389]]]} | Open Access 1 | 1041 | Antelope Cemetery | 15507 | 2184 | Woodlake Public Cemetery District 124 | Special District 4 | Cemetery District 11 | Special District 4 | 2184 | Woodlake Public Cemetery District 121 | Special District 4 | Cemetery District 11 | Tulare 29 | 7.877 | Antelope Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
351 | 351 | 350 | {"type": "Polygon", "coordinates": [[[-119.32193, 36.20761], [-119.32189, 36.20923], [-119.32081, 36.20925], [-119.32078, 36.20934], [-119.31981, 36.20934], [-119.31987, 36.20762], [-119.32193, 36.20761]]]} | Open Access 1 | 969 | Tulare Veterans Memorial Park | 26570 | 2168 | Tulare Veterans Memorial District 144 | Special District 4 | Cemetery District 11 | Special District 4 | 2168 | Tulare Veterans Memorial District 140 | Special District 4 | Cemetery District 11 | Tulare 29 | 8.555 | Tulare Veterans Memorial Park | 0 | Local Park 2 | 4 | ||
366 | 366 | 365 | {"type": "Polygon", "coordinates": [[[-119.18856, 36.09471], [-119.18594, 36.09472], [-119.18594, 36.09315], [-119.18855, 36.09314], [-119.18856, 36.09471]]]} | Open Access 1 | 1046 | Woodville Cemetery | 27750 | 2185 | Woodville Public Cemetery District 150 | Special District 4 | Cemetery District 11 | Special District 4 | 2185 | Woodville Public Cemetery District 146 | Special District 4 | Cemetery District 11 | Tulare 29 | 10.155 | Woodville Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
616 | 616 | 615 | {"type": "Polygon", "coordinates": [[[-119.3355, 36.20739], [-119.33118, 36.20737], [-119.33122, 36.2057], [-119.33122, 36.20386], [-119.33545, 36.20385], [-119.3355, 36.20739]]]} | Open Access 1 | 964 | Tulare Cemetery | 26563 | 2167 | Tulare Cemetery District 223 | Special District 4 | Cemetery District 11 | Special District 4 | 2167 | Tulare Cemetery District 219 | Special District 4 | Cemetery District 11 | Tulare 29 | 37.023 | Tulare Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
5018 | 5018 | 5017 | {"type": "Polygon", "coordinates": [[[-119.30799, 36.33786], [-119.30696, 36.33786], [-119.30696, 36.338], [-119.30721, 36.33801], [-119.30723, 36.34003], [-119.30546, 36.34002], [-119.30545, 36.34006], [-119.30335, 36.34005], [-119.30332, 36.33602], [-119.30438, 36.33602], [-119.30437, 36.33463], [-119.30565, 36.33464], [-119.30566, 36.33527], [-119.30637, 36.33527], [-119.30637, 36.33464], [-119.30693, 36.33465], [-119.30694, 36.33508], [-119.30752, 36.33508], [-119.30753, 36.33557], [-119.30797, 36.33558], [-119.30797, 36.33586], [-119.30739, 36.33586], [-119.30741, 36.33769], [-119.30799, 36.33771], [-119.30799, 36.33786]]]} | Open Access 1 | 1036 | Visalia Cemetery | 27161 | 2173 | Visalia Cemetery District 793 | Special District 4 | Cemetery District 11 | Special District 4 | 2173 | Visalia Cemetery District 771 | Special District 4 | Cemetery District 11 | Tulare 29 | 48.629 | Visalia Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
5224 | 5224 | 5223 | {"type": "Polygon", "coordinates": [[[-118.90503, 36.42081], [-118.90499, 36.42148], [-118.90499, 36.42203], [-118.90271, 36.42198], [-118.90281, 36.42075], [-118.90503, 36.42081]]]} | Open Access 1 | 957 | Blossom Peak Cemetery | 16174 | 2165 | Three Rivers Public Cemetery District 799 | Special District 4 | Cemetery District 11 | Special District 4 | 2165 | Three Rivers Public Cemetery District 779 | Special District 4 | Cemetery District 11 | Tulare 29 | 6.762 | Blossom Peak Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
6011 | 6011 | 6010 | {"type": "Polygon", "coordinates": [[[-118.99501, 36.06561], [-118.99069, 36.06572], [-118.99063, 36.06396], [-118.99499, 36.06385], [-118.99501, 36.06561]]]} | Open Access 1 | 812 | Hillcrest Memorial Park | 19967 | 2115 | Porterville Public Cemetery District 823 | Special District 4 | Cemetery District 11 | Special District 4 | 2115 | Porterville Public Cemetery District 801 | Special District 4 | Cemetery District 11 | Tulare 29 | 18.954 | Hillcrest Memorial Park | 0 | Local Park 2 | 4 | ||
6069 | 6069 | 6068 | {"type": "Polygon", "coordinates": [[[-119.07762, 36.1962], [-119.07557, 36.19623], [-119.07559, 36.19823], [-119.07329, 36.19825], [-119.0732, 36.19629], [-119.07535, 36.19628], [-119.07532, 36.19505], [-119.07759, 36.19504], [-119.07762, 36.1962]]]} | Open Access 1 | 807 | Olive Cemetery | 23121 | 2060 | Lindsay-Strathmore Cemetery District 122 | Special District 4 | Cemetery District 11 | Special District 4 | 2060 | Lindsay-Strathmore Cemetery District 119 | Special District 4 | Cemetery District 11 | Tulare 29 | 17.89 | Olive Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
6073 | 6073 | 6072 | {"type": "MultiPolygon", "coordinates": [[[[-118.99563, 36.06685], [-118.99394, 36.06686], [-118.99391, 36.06574], [-118.99563, 36.06575], [-118.99563, 36.06685]]], [[[-118.99749, 36.06564], [-118.99527, 36.06567], [-118.99526, 36.06442], [-118.99747, 36.06442], [-118.99749, 36.06564]]]]} | Open Access 1 | 819 | Porterville Cemetery | 23902 | 2115 | Porterville Public Cemetery District 823 | Special District 4 | Cemetery District 11 | Special District 4 | 2115 | Porterville Public Cemetery District 801 | Special District 4 | Cemetery District 11 | Tulare 29 | 11.434 | Porterville Cemetery | 0 | Local Historic or Cultural Area 19 | 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]);