units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
55 rows where DES_TP = 19 and MNG_AG_TYP = 11
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Selma Cemetery District 2
- Sanger/Del Rey Cemetery District 2
- Merced Cemetery District 2
- Santa Maria Cemetery District 1
- Lindsay-Strathmore Cemetery District 1
- Plainsburg Cemetery District 1
- Parlier Cemetery District 1
- Bardsdale Cemetery District 1
- Kingsburg Cemetery District 1
- Lompoc Cemetery District 1
- Pajaro Valley Public Cemetery District 1
- Lancaster Cemetery District 1
- Visalia Cemetery District 1
- Coalinga Cemetery District 1
- Simi Valley Public Cemetery District 1
- Three Rivers Public Cemetery District 1
- Cambria Public Cemetery District 1
- Reedley Cemetery District 1
- Porterville Public Cemetery District 1
- Carpinteria Cemetery District 1
- Castroville Cemetery District 1
- Piru Cemetery District 1
- Orange County Cemetery District 1
- Greenfield Cemetery District 1
- Guadalupe Cemetery District 1
- Dos Palos Cemetery District 1
- Washington Colony Cemetery District 1
- Hills Ferry Cemetery District 1
- Winton Cemetery District 1
- Los Alamos Cemetery District 1
- …
MNG_AG_TYP 1
- Cemetery District · 35 ✖
DES_TP 1
- Local Historic or Cultural Area · 35 ✖
ACCESS_TYP 1
- Open Access 35
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2298 | 2298 | 2297 | {"type": "Polygon", "coordinates": [[[-120.33032, 37.236], [-120.329, 37.236], [-120.32896, 37.23284], [-120.32958, 37.23283], [-120.32959, 37.23288], [-120.33029, 37.23288], [-120.33032, 37.236]]]} | Open Access 1 | 16928 | Plainsburg Cemetery | 23766 | 2111 | Plainsburg Cemetery District 507 | Special District 4 | Cemetery District 11 | http://www.co.merced.ca.us/index.aspx?NID=1329 | Special District 4 | 2111 | Plainsburg Cemetery District 499 | Special District 4 | Cemetery District 11 | Merced 37 | 10.119 | Plainsburg Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
2325 | 2325 | 2324 | {"type": "Polygon", "coordinates": [[[-119.54766, 36.62225], [-119.54431, 36.61985], [-119.54358, 36.61933], [-119.54757, 36.61933], [-119.54756, 36.61965], [-119.54766, 36.62225]]]} | Open Access 1 | 18386 | Parlier Cemetery | 23465 | 2109 | Parlier Cemetery District 512 | Special District 4 | Cemetery District 11 | Special District 4 | 2109 | Parlier Cemetery District 505 | Special District 4 | Cemetery District 11 | Fresno 9 | 14.213 | Parlier Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
2337 | 2337 | 2336 | {"type": "Polygon", "coordinates": [[[-118.9423, 34.36055], [-118.9423, 34.36195], [-118.94129, 34.36223], [-118.94129, 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 | 17047 | Bardsdale Cemetery | 15812 | 2005 | Bardsdale Cemetery District 515 | Special District 4 | Cemetery District 11 | http://bardsdalecemetery.com/ | Special District 4 | 2005 | Bardsdale Cemetery District 508 | Special District 4 | Cemetery District 11 | Ventura 8 | 14.314 | Bardsdale Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
2364 | 2364 | 2363 | {"type": "Polygon", "coordinates": [[[-119.56142, 36.50347], [-119.56141, 36.5051], [-119.55689, 36.50507], [-119.55687, 36.50343], [-119.56142, 36.50347]]]} | Open Access 1 | 17153 | Kingsburg Cemetery | 20667 | 2053 | Kingsburg Cemetery District 518 | Special District 4 | Cemetery District 11 | Special District 4 | 2053 | Kingsburg Cemetery District 511 | Special District 4 | Cemetery District 11 | Fresno 9 | 18.234 | Kingsburg Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
2368 | 2368 | 2367 | {"type": "Polygon", "coordinates": [[[-120.41878, 34.85391], [-120.41878, 34.85526], [-120.41827, 34.85526], [-120.41827, 34.85391], [-120.41878, 34.85391]]]} | Open Access 1 | 18541 | Pine Grove Cemetery | 23677 | 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 | 1.717 | Pine Grove Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
2460 | 2460 | 2459 | {"type": "Polygon", "coordinates": [[[-120.45154, 34.63089], [-120.45154, 34.63099], [-120.44878, 34.63096], [-120.44841, 34.63085], [-120.44601, 34.63083], [-120.446, 34.63074], [-120.44531, 34.63074], [-120.4453, 34.63071], [-120.44519, 34.63071], [-120.44522, 34.63014], [-120.44594, 34.62906], [-120.44681, 34.62907], [-120.44682, 34.62893], [-120.44884, 34.62894], [-120.44887, 34.62739], [-120.44917, 34.6274], [-120.44916, 34.62827], [-120.44944, 34.62828], [-120.4503, 34.62929], [-120.45069, 34.63019], [-120.45128, 34.63077], [-120.45154, 34.63089]]]} | Open Access 1 | 17397 | Lompoc Cemetery - Lompoc Cemetery District | 21419 | 2063 | Lompoc Cemetery District 526 | Special District 4 | Cemetery District 11 | Special District 4 | 2063 | Lompoc Cemetery District 518 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 27.221 | Lompoc Cemetery - Lompoc Cemetery District | 0 | Local Historic or Cultural Area 19 | 4 | ||
2793 | 2793 | 2792 | {"type": "Polygon", "coordinates": [[[-121.76676, 36.92508], [-121.76492, 36.92663], [-121.7632, 36.92467], [-121.76454, 36.92389], [-121.76432, 36.92363], [-121.76487, 36.92332], [-121.76462, 36.92303], [-121.76486, 36.92289], [-121.76531, 36.92344], [-121.76676, 36.92508]]]} | Open Access 1 | 18569 | Pioneer Cemetery | 23711 | 2107 | Pajaro Valley Public Cemetery District 554 | Special District 4 | Cemetery District 11 | Special District 4 | 2107 | Pajaro Valley Public Cemetery District 547 | Special District 4 | Cemetery District 11 | Santa Cruz 5 | 15.079 | Pioneer Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
4354 | 4354 | 4353 | {"type": "Polygon", "coordinates": [[[-118.1303, 34.6981], [-118.13028, 34.69811], [-118.13028, 34.69818], [-118.12875, 34.69818], [-118.12873, 34.69777], [-118.12606, 34.69778], [-118.12606, 34.69691], [-118.12608, 34.69689], [-118.12611, 34.69688], [-118.12787, 34.69686], [-118.12864, 34.69679], [-118.13024, 34.69679], [-118.13029, 34.69681], [-118.1303, 34.6981]]]} | Open Access 1 | 45697 | Lancaster Cemetery | 28596 | 2357 | Lancaster Cemetery District 753 | Special District 4 | Cemetery District 11 | http://lancastercemetery.net/ | Special District 4 | 2357 | Lancaster Cemetery District 739 | Special District 4 | Cemetery District 11 | http://lancastercemetery.net/ | Los Angeles 6 | 11.633 | Lancaster 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 | ||
5106 | 5106 | 5105 | {"type": "Polygon", "coordinates": [[[-120.28304, 36.15116], [-120.28139, 36.15118], [-120.28136, 36.14926], [-120.283, 36.14924], [-120.28304, 36.15116]]]} | Open Access 1 | 5450 | Pleasant Valley Cemetery | 23799 | 2020 | Coalinga Cemetery District 795 | Special District 4 | Cemetery District 11 | Special District 4 | 2020 | Coalinga Cemetery District 775 | Special District 4 | Cemetery District 11 | Fresno 9 | 7.802 | Pleasant Valley Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
5217 | 5217 | 5216 | {"type": "Polygon", "coordinates": [[[-118.76793, 34.2654], [-118.76793, 34.26719], [-118.76722, 34.26733], [-118.76684, 34.26739], [-118.76684, 34.26455], [-118.76694, 34.26455], [-118.76694, 34.2654], [-118.76793, 34.2654]]]} | Open Access 1 | 818 | Simi Cemetery | 25504 | 2151 | Simi Valley Public Cemetery District 798 | Special District 4 | Cemetery District 11 | Special District 4 | 2151 | Simi Valley Public Cemetery District 778 | Special District 4 | Cemetery District 11 | Ventura 8 | 5.453 | Simi 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 | ||
5260 | 5260 | 5259 | {"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.57412], [-121.09133, 35.57387], [-121.09398, 35.57389], [-121.09494, 35.57501]]]} | Open Access 1 | 1946 | Cambria Public Cemetery | 16751 | 2011 | Cambria Public Cemetery District 800 | Special District 4 | Cemetery District 11 | http://www.cambriacemetery.com/ | Special District 4 | 2011 | Cambria Public Cemetery District 780 | Special District 4 | Cemetery District 11 | San Luis Obispo 1 | 12.234 | Cambria Public Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
5737 | 5737 | 5736 | {"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 | 1770 | Bethel Cemetery | 16047 | 2138 | Sanger/Del Rey Cemetery District 815 | Special District 4 | Cemetery District 11 | Special District 4 | 2138 | Sanger/Del Rey Cemetery District 794 | Special District 4 | Cemetery District 11 | Fresno 9 | 2.179 | Bethel Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
5987 | 5987 | 5986 | {"type": "Polygon", "coordinates": [[[-119.4628, 36.57774], [-119.4621, 36.57883], [-119.46146, 36.57935], [-119.46083, 36.58102], [-119.45916, 36.58435], [-119.45766, 36.58435], [-119.45776, 36.58144], [-119.45776, 36.58062], [-119.4579, 36.57789], [-119.4628, 36.57774]]]} | Open Access 1 | 589 | Reedley Cemetery | 24260 | 2119 | Reedley Cemetery District 822 | Special District 4 | Cemetery District 11 | Special District 4 | 2119 | Reedley Cemetery District 800 | Special District 4 | Cemetery District 11 | Fresno 9 | 48.695 | Reedley Cemetery | 0 | Local Historic or Cultural Area 19 | 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 | ||
6501 | 6501 | 6500 | {"type": "Polygon", "coordinates": [[[-119.51068, 36.72515], [-119.51076, 36.72766], [-119.51065, 36.7279], [-119.51046, 36.72803], [-119.51022, 36.72806], [-119.5047, 36.72801], [-119.50437, 36.72815], [-119.50388, 36.72815], [-119.50402, 36.7275], [-119.50459, 36.72719], [-119.50611, 36.72693], [-119.50694, 36.72718], [-119.50716, 36.72722], [-119.508, 36.72703], [-119.50884, 36.72654], [-119.50976, 36.7258], [-119.51068, 36.72515]]]} | Open Access 1 | 2373 | Sanger Cemetery | 25027 | 2138 | Sanger/Del Rey Cemetery District 815 | Special District 4 | Cemetery District 11 | Special District 4 | 2138 | Sanger/Del Rey Cemetery District 794 | Special District 4 | Cemetery District 11 | Fresno 9 | 21.934 | Sanger Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
6525 | 6525 | 6524 | {"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 | 3223 | Floral Memorial Cemetery | 18958 | 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 | 6.039 | Floral Memorial Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
6588 | 6588 | 6587 | {"type": "Polygon", "coordinates": [[[-119.61964, 36.57633], [-119.61961, 36.57808], [-119.6152, 36.57812], [-119.61521, 36.5764], [-119.61535, 36.5764], [-119.61536, 36.57643], [-119.61541, 36.5764], [-119.61964, 36.57633]]]} | Open Access 1 | 4094 | Selma Cemetery | 25290 | 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 | 18.807 | Selma 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]);