units_with_maps

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

116 rows where DES_TP = 19

View and edit SQL

Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, COUNTY, YR_EST

ACCESS_TYP

DES_TP

  • Local Historic or Cultural Area · 116
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
173 172 {"type": "Polygon", "coordinates": [[[-120.4259, 37.94699], [-120.42564, 37.9476], [-120.4255, 37.94811], [-120.42551, 37.94822], [-120.42504, 37.94841], [-120.42471, 37.94817], [-120.42435, 37.94782], [-120.42412, 37.94745], [-120.42349, 37.94692], [-120.42464, 37.94646], [-120.42483, 37.94685], [-120.42539, 37.94659], [-120.42558, 37.94679], [-120.4259, 37.94699]]]} Open Access 1 548 Cemetery 17011 2050 Jamestown Cemetery District 66 Special District 4 Cemetery District 11   Special District 4 2050 Jamestown Cemetery District 64 Special District 4 Cemetery District 11   Tuolumne 21 6.082 Cemetery 0 Local Historic or Cultural Area 19 4
175 174 {"type": "Polygon", "coordinates": [[[-119.65914, 34.41998], [-119.65807, 34.4201], [-119.65671, 34.42044], [-119.65662, 34.42048], [-119.65651, 34.42056], [-119.65592, 34.42119], [-119.65575, 34.42131], [-119.65555, 34.42137], [-119.65541, 34.42139], [-119.65297, 34.42138], [-119.65294, 34.42134], [-119.65294, 34.41914], [-119.65261, 34.41913], [-119.65261, 34.41724], [-119.65352, 34.41719], [-119.65403, 34.41712], [-119.65457, 34.41717], [-119.65502, 34.41711], [-119.65526, 34.41712], [-119.65548, 34.41708], [-119.65595, 34.41711], [-119.65614, 34.41706], [-119.65649, 34.41705], [-119.65687, 34.41702], [-119.65729, 34.41703], [-119.65751, 34.41701], [-119.65793, 34.41701], [-119.65827, 34.41698], [-119.6587, 34.41702], [-119.65912, 34.41699], [-119.65914, 34.41998]]]} Open Access 1 481 Santa Barbara Cemetery 25039 2140 Santa Barbara Cemetery Association 67 Special District 4 Cemetery District 11   Special District 4 2140 Santa Barbara Cemetery Association 65 Special District 4 Cemetery District 11   Santa Barbara 7 59.983 Santa Barbara Cemetery 0 Local Historic or Cultural Area 19 4
180 179 {"type": "Polygon", "coordinates": [[[-120.42711, 34.93148], [-120.42706, 34.93392], [-120.42702, 34.93833], [-120.42498, 34.93831], [-120.42501, 34.93448], [-120.42505, 34.93211], [-120.42507, 34.93195], [-120.42508, 34.93153], [-120.42511, 34.93149], [-120.42515, 34.93147], [-120.42711, 34.93148]]]} Open Access 1 568 Santa Maria Cemetery 25103 2145 Santa Maria Cemetery District 68 Special District 4 Cemetery District 11 http://www.countyofsb.org/pwd/pwsurveyor.aspx Special District 4 2145 Santa Maria Cemetery District 66 Special District 4 Cemetery District 11   Santa Barbara 7 35.019 Santa Maria Cemetery 0 Local Historic or Cultural Area 19 4
182 181 {"type": "Polygon", "coordinates": [[[-120.40136, 38.00555], [-120.40072, 38.00607], [-120.40064, 38.00615], [-120.40061, 38.00621], [-120.40038, 38.00615], [-120.40036, 38.00603], [-120.39992, 38.00605], [-120.39963, 38.00604], [-120.40009, 38.00557], [-120.40036, 38.00524], [-120.40055, 38.00505], [-120.40073, 38.00515], [-120.40136, 38.00555]]]} Open Access 1 579 Cemetery 17015 2150 Shaws Flat Cemetery District 69 Special District 4 Cemetery District 11   Special District 4 2150 Shaws Flat Cemetery District 67 Special District 4 Cemetery District 11   Tuolumne 21 2.301 Cemetery 0 Local Historic or Cultural Area 19 4
184 183 {"type": "Polygon", "coordinates": [[[-120.2455, 37.82767], [-120.24545, 37.82809], [-120.24528, 37.82907], [-120.24525, 37.82917], [-120.24352, 37.82889], [-120.24371, 37.82745], [-120.2455, 37.82767]]]} Open Access 1 561 Cemetery 17014 2098 Oak Grove Cemetery District 71 Special District 4 Cemetery District 11   Special District 4 2098 Oak Grove Cemetery District 69 Special District 4 Cemetery District 11   Tuolumne 21 6.428 Cemetery 0 Local Historic or Cultural Area 19 4
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
269 268 {"type": "Polygon", "coordinates": [[[-120.10404, 37.44406], [-120.10403, 37.44496], [-120.10267, 37.44507], [-120.10278, 37.44409], [-120.10404, 37.44406]]]} Open Access 1 47348 Catheys Valley Cemetery 31064 307 Mariposa, County of 110 County 3 County Agency 3 https://www.mariposacounty.org/index.aspx?NID=207 County 3 307 Mariposa, County of 107 County 3 County Agency 3   Mariposa 31 2.97 Catheys Valley Cemetery 0 Local Historic or Cultural Area 19 4
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 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 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 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
332 331 {"type": "Polygon", "coordinates": [[[-121.31293, 36.42631], [-121.31293, 36.42822], [-121.31184, 36.42912], [-121.3115, 36.42912], [-121.3115, 36.42606], [-121.31293, 36.42631]]]} Open Access 1 911 Soledad Cemetery 25597 2153 Soledad Cemetery District 135 Special District 4 Cemetery District 11   Special District 4 2153 Soledad Cemetery District 132 Special District 4 Cemetery District 11   Monterey 14 9.116 Soledad Cemetery 0 Local Historic or Cultural Area 19 4
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
389 388 {"type": "Polygon", "coordinates": [[[-118.80196, 34.27578], [-118.801, 34.27578], [-118.80023, 34.27408], [-118.80034, 34.2741], [-118.80041, 34.27419], [-118.80046, 34.27422], [-118.80057, 34.27424], [-118.80064, 34.27422], [-118.80071, 34.27418], [-118.80074, 34.27413], [-118.80076, 34.27408], [-118.80183, 34.27407], [-118.80196, 34.27578]]]} Open Access 1 1158 Strathearn Historical Park & Museum 25908 2118 Rancho Simi Recreation and Park District 80 Special District 4 Recreation/Parks District 4 http://www.rsrpd.org/ Special District 4 2118 Rancho Simi Recreation and Park District 78 Special District 4 Recreation/Parks District 4   Ventura 8 5.386 Strathearn Historical Park & Museum 0 Local Historic or Cultural Area 19 4
430 429 {"type": "Polygon", "coordinates": [[[-117.69087, 33.64713], [-117.69085, 33.64716], [-117.69051, 33.64729], [-117.68995, 33.64727], [-117.68923, 33.64768], [-117.68869, 33.64759], [-117.68877, 33.64738], [-117.68882, 33.64717], [-117.68975, 33.64643], [-117.69027, 33.64681], [-117.69087, 33.64713]]]} Open Access 1 1728 Heritage Hill Historic Site 19835 312 Orange, County of 142 County 3 County Agency 3 http://ocparks.com/ County 3 312 Orange, County of 138 County 3 County Agency 3   Orange 3 3.228 Heritage Hill Historic Site 0 Local Historic or Cultural Area 19 4
615 614 {"type": "Polygon", "coordinates": [[[-117.87482, 33.89648], [-117.87514, 33.89647], [-117.87518, 33.89649], [-117.87521, 33.89653], [-117.87521, 33.89758], [-117.87518, 33.89763], [-117.87514, 33.89764], [-117.87508, 33.89764], [-117.87503, 33.8976], [-117.87496, 33.89757], [-117.87445, 33.89756], [-117.87443, 33.89649], [-117.87482, 33.89648]]]} Open Access 1 944 George Key Ranch Historic Park 19269 312 Orange, County of 142 County 3 County Agency 3 http://ocparks.com/ County 3 312 Orange, County of 138 County 3 County Agency 3   Orange 3 2.158 George Key Ranch Historic Park 0 Local Historic or Cultural Area 19 4
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
749 748 {"type": "Polygon", "coordinates": [[[-119.62108, 36.558], [-119.62104, 36.55974], [-119.62088, 36.55974], [-119.62087, 36.55979], [-119.61988, 36.55979], [-119.61991, 36.558], [-119.62036, 36.55799], [-119.62108, 36.558]]]} Open Access 1 4873 West Selma Cemetery 27375 2148 Selma Cemetery District 251 Special District 4 Cemetery District 11   Special District 4 2148 Selma Cemetery District 247 Special District 4 Cemetery District 11   Fresno 9 5.109 West Selma Cemetery 0 Local Historic or Cultural Area 19 4
994 993 {"type": "Polygon", "coordinates": [[[-118.25629, 33.79377], [-118.25421, 33.79388], [-118.2541, 33.79231], [-118.25461, 33.79228], [-118.25462, 33.79225], [-118.25616, 33.79216], [-118.25616, 33.79219], [-118.25618, 33.79219], [-118.25629, 33.79377]]]} Open Access 1 6195 Wilmington Cemetery 27598 2182 Wilmington Public Cemetery District 302 Special District 4 Cemetery District 11   Special District 4 2182 Wilmington Public Cemetery District 298 Special District 4 Cemetery District 11   Los Angeles 6 8.461 Wilmington Cemetery 0 Local Historic or Cultural Area 19 4
1136 1135 {"type": "Polygon", "coordinates": [[[-118.10845, 33.77696], [-118.10812, 33.77733], [-118.10811, 33.77767], [-118.1074, 33.77768], [-118.1063, 33.7776], [-118.10633, 33.77741], [-118.10608, 33.77704], [-118.10604, 33.77647], [-118.10563, 33.77642], [-118.10564, 33.77625], [-118.10604, 33.77629], [-118.10686, 33.77626], [-118.10722, 33.77607], [-118.10745, 33.77636], [-118.10787, 33.77635], [-118.10794, 33.77631], [-118.10845, 33.77696]]]} Open Access 1 6659 Rancho Los Alamitos Historic Site 24152 1184 Long Beach, City of 298 City 2 City Agency 2 http://www.longbeach.gov/park/default.asp City 2 1184 Long Beach, City of 294 City 2 City Agency 2   Los Angeles 6 7.405 Rancho Los Alamitos Historic Site 0 Local Historic or Cultural Area 19 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Query took 160.648ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette