superunits_with_maps

Table actions

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

61 rows where ACCESS_TYP = 1, MNG_AG_LEV = 4 and MNG_AG_TYP = 11

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Cemetery District · 61 ✖

ACCESS_TYP 1

  • Open Access · 61 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
1511 1511 1510 {"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 Antelope Cemetery   15507 2184 Woodlake Public Cemetery District 121 Special District 4 Cemetery District 11   Special District 4 7.882 Antelope Cemetery  
1760 1760 1759 {"type": "Polygon", "coordinates": [[[-118.9423, 34.36055], [-118.9423, 34.36195], [-118.94129, 34.36223], [-118.94128, 34.36118], [-118.93907, 34.36194], [-118.93823, 34.36211], [-118.93755, 34.3607], [-118.93811, 34.3605], [-118.9423, 34.36055]]]} Open Access 1 Bardsdale Cemetery   15812 2005 Bardsdale Cemetery District 508 Special District 4 Cemetery District 11 http://bardsdalecemetery.com/ Special District 4 14.328 Bardsdale Cemetery  
1937 1937 1936 {"type": "Polygon", "coordinates": [[[-119.54108, 34.41138], [-119.54104, 34.41331], [-119.5386, 34.41327], [-119.53861, 34.4125], [-119.53904, 34.41046], [-119.54094, 34.41042], [-119.54094, 34.41136], [-119.54108, 34.41138]]]} Open Access 1 Carpinteria Cemetery   16894 2014 Carpinteria Cemetery District 815 Special District 4 Cemetery District 11 http://www.carpinteriacemetery.com/ Special District 4 16.221 Carpinteria Cemetery  
1982 1982 1981 {"type": "Polygon", "coordinates": [[[-119.5816, 36.67854], [-119.58049, 36.67855], [-119.58052, 36.67774], [-119.58158, 36.67773], [-119.5816, 36.6778], [-119.5816, 36.67854]]]} Open Access 1 Bethel Cemetery   16047 2138 Sanger/Del Rey Cemetery District 794 Special District 4 Cemetery District 11   Special District 4 2.179 Bethel Cemetery  
2068 2068 2067 {"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 Blossom Peak Cemetery   16174 2165 Three Rivers Public Cemetery District 779 Special District 4 Cemetery District 11   Special District 4 6.761 Blossom Peak Cemetery  
2101 2101 2100 {"type": "Polygon", "coordinates": [[[-120.63928, 36.98336], [-120.63928, 36.98477], [-120.63698, 36.98476], [-120.63697, 36.98408], [-120.63568, 36.98408], [-120.63567, 36.98192], [-120.63822, 36.98193], [-120.63823, 36.98335], [-120.63928, 36.98336]]]} Open Access 1 Cemetery   17009 2029 Dos Palos Cemetery District 905 Special District 4 Cemetery District 11   Special District 4 19.168 Cemetery  
2210 2210 2209 {"type": "Polygon", "coordinates": [[[-121.04115, 37.18702], [-121.04113, 37.18781], [-121.03979, 37.18782], [-121.03981, 37.18701], [-121.04115, 37.18702]]]} Open Access 1 Cemetery   17010 2047 Hills Ferry Cemetery District 907 Special District 4 Cemetery District 11   Special District 4 2.605 Cemetery  
2547 2547 2546 {"type": "Polygon", "coordinates": [[[-121.09494, 35.57501], [-121.09451, 35.57558], [-121.09347, 35.57506], [-121.09278, 35.57593], [-121.09109, 35.57504], [-121.09181, 35.57413], [-121.09133, 35.57387], [-121.09398, 35.57389], [-121.09494, 35.57501]]]} Open Access 1 Cambria Public Cemetery   16751 2011 Cambria Public Cemetery District 780 Special District 4 Cemetery District 11 http://www.cambriacemetery.com/ Special District 4 12.246 Cambria Public Cemetery  
2700 2700 2699 {"type": "Polygon", "coordinates": [[[-121.7877, 36.79149], [-121.78737, 36.79341], [-121.785, 36.79391], [-121.78428, 36.79221], [-121.7877, 36.79149]]]} Open Access 1 Castroville Cemetery   16967 2015 Castroville Cemetery District 820 Special District 4 Cemetery District 11   Special District 4 13.067 Castroville Cemetery  
2736 2736 2735 {"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.94684], [-120.42539, 37.94659], [-120.42558, 37.94679], [-120.4259, 37.94699]]]} Open Access 1 Cemetery   17011 2050 Jamestown Cemetery District 64 Special District 4 Cemetery District 11   Special District 4 6.085 Cemetery  
2737 2737 2736 {"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 Cemetery   17012 2069 Los Banos Cemetery District 355 Special District 4 Cemetery District 11 http://www.co.merced.ca.us/index.aspx?NID=1329 Special District 4 39.932 Cemetery  
2738 2738 2737 {"type": "Polygon", "coordinates": [[[-120.48745, 37.28615], [-120.48741, 37.28801], [-120.48736, 37.28814], [-120.48725, 37.28825], [-120.48715, 37.28826], [-120.48709, 37.28835], [-120.48474, 37.28825], [-120.48474, 37.2882], [-120.48468, 37.2882], [-120.48471, 37.28645], [-120.48561, 37.28647], [-120.48563, 37.28612], [-120.48745, 37.28615]]]} Open Access 1 Cemetery   17013 2076 Merced Cemetery District 908 Special District 4 Cemetery District 11 http://www.co.merced.ca.us/index.aspx?NID=1329 Special District 4 13.623 Cemetery  
2739 2739 2738 {"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 Cemetery   17014 2098 Oak Grove Cemetery District 69 Special District 4 Cemetery District 11   Special District 4 6.427 Cemetery  
2740 2740 2739 {"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 Cemetery   17015 2150 Shaws Flat Cemetery District 67 Special District 4 Cemetery District 11   Special District 4 2.302 Cemetery  
3501 3501 3500 {"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 Deep Creek Cemetery   17988 2033 Exeter Cemetery District 97 Special District 4 Cemetery District 11   Special District 4 4.704 Deep Creek Cemetery  
3895 3895 3894 {"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 Hamilton Cemetery   19616 2033 Exeter Cemetery District 97 Special District 4 Cemetery District 11   Special District 4 7.138 Hamilton Cemetery  
3927 3927 3926 {"type": "Polygon", "coordinates": [[[-117.68379, 33.64177], [-117.68361, 33.64242], [-117.68314, 33.64365], [-117.68303, 33.64446], [-117.68101, 33.64482], [-117.68049, 33.64436], [-117.67955, 33.6437], [-117.68281, 33.64044], [-117.68379, 33.64177]]]} Open Access 1 El Toro Memorial Park Cemetery   18544 2104 Orange County Cemetery District 861 Special District 4 Cemetery District 11 http://www.occemeterydistrict.com/ Special District 4 25.359 El Toro Memorial Park Cemetery  
4112 4112 4111 {"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 Exeter Cemetery   18773 2033 Exeter Cemetery District 97 Special District 4 Cemetery District 11   Special District 4 18.077 Exeter Cemetery  
4271 4271 4270 {"type": "Polygon", "coordinates": [[[-119.62216, 36.57616], [-119.61991, 36.57617], [-119.61986, 36.57615], [-119.61984, 36.57612], [-119.61982, 36.57405], [-119.62216, 36.57616]]]} Open Access 1 Floral Memorial Cemetery   18958 2148 Selma Cemetery District 247 Special District 4 Cemetery District 11   Special District 4 6.038 Floral Memorial Cemetery  
4348 4348 4347 {"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 Fowler Cemetery   19028 2035 Fowler Cemetery District 394 Special District 4 Cemetery District 11   Special District 4 16.465 Fowler Cemetery  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);