units_with_maps

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

62 rows where MNG_AG_TYP = 11

View and edit SQL

Suggested facets: AGNCY_WEB, PARK_URL, COUNTY, YR_EST

MNG_AG_TYP

  • Cemetery District · 62

ACCESS_TYP

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
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
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 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 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
1401 1400 {"type": "Polygon", "coordinates": [[[-120.859, 37.04879], [-120.85833, 37.0488], [-120.85834, 37.04941], [-120.8539, 37.04946], [-120.85391, 37.04617], [-120.85899, 37.04611], [-120.859, 37.04879]]]} Open Access 1 16916 Cemetery 17012 2069 Los Banos Cemetery District 358 Special District 4 Cemetery District 11 http://www.co.merced.ca.us/index.aspx?NID=1329 Special District 4 2069 Los Banos Cemetery District 355 Special District 4 Cemetery District 11   Merced 37 39.929 Cemetery 0 Local Historic or Cultural Area 19 4
1643 1642 {"type": "Polygon", "coordinates": [[[-119.68461, 36.60967], [-119.68459, 36.61269], [-119.68239, 36.61268], [-119.68238, 36.60964], [-119.68461, 36.60967]]]} Open Access 1 14108 Fowler Cemetery 19028 2035 Fowler Cemetery District 400 Special District 4 Cemetery District 11   Special District 4 2035 Fowler Cemetery District 394 Special District 4 Cemetery District 11   Fresno 9 16.466 Fowler Cemetery 0 Local Historic or Cultural Area 19 4
1705 1704 {"type": "Polygon", "coordinates": [[[-118.06777, 33.99672], [-118.06723, 33.99773], [-118.06591, 33.99683], [-118.06669, 33.996], [-118.06777, 33.99672]]]} Open Access 1 6543 Guirado Park 19564 2125 Rose Hills Memorial Park Association 412 Special District 4 Cemetery District 11 http://www.rosehills.com/ Special District 4 2125 Rose Hills Memorial Park Association 406 Special District 4 Cemetery District 11   Los Angeles 6 4.169 Guirado Park 0 Local Park 2 4
1935 1934 {"type": "Polygon", "coordinates": [[[-119.78286, 34.44151], [-119.78261, 34.44152], [-119.7826, 34.44155], [-119.78177, 34.44157], [-119.78068, 34.44156], [-119.77962, 34.44159], [-119.7786, 34.44154], [-119.77859, 34.44048], [-119.77991, 34.44048], [-119.77991, 34.4404], [-119.77984, 34.4404], [-119.77985, 34.43923], [-119.78015, 34.43911], [-119.78025, 34.43909], [-119.78039, 34.43907], [-119.78082, 34.43905], [-119.78091, 34.43898], [-119.78101, 34.43894], [-119.7812, 34.43878], [-119.7813, 34.43873], [-119.78138, 34.43872], [-119.78168, 34.43872], [-119.78168, 34.43949], [-119.78069, 34.43949], [-119.78067, 34.44015], [-119.78035, 34.44016], [-119.78035, 34.44039], [-119.7817, 34.4404], [-119.78171, 34.44067], [-119.78186, 34.44067], [-119.78186, 34.44053], [-119.78254, 34.44054], [-119.78286, 34.44151]]]} Open Access 1 16622 Goleta Cemetery 19381 2037 Goleta Cemetery District 456 Special District 4 Cemetery District 11 http://www.goletacemetery.com/ Special District 4 2037 Goleta Cemetery District 450 Special District 4 Cemetery District 11   Santa Barbara 7 15.518 Goleta Cemetery 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 70.355ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette