units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
111 rows where DES_TP = 19 and YR_EST = 0
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Kern, County of 5
- Fremont, City of 4
- Santa Barbara, County of 2
- Riverside, County of 2
- Selma Cemetery District 2
- Long Beach, City of 2
- Rio Vista, City of 2
- Mono, County of 2
- Sanger/Del Rey Cemetery District 2
- Merced Cemetery District 2
- Oakdale, City of 1
- San Diego, City of 1
- Los Angeles, County of 1
- Monterey, County of 1
- Los Angeles, City of 1
- San Jose, City of 1
- Monterey, City of 1
- Turlock, City of 1
- Santa Maria Cemetery District 1
- San Ramon, City of 1
- San Juan Capistrano, City of 1
- Oxnard, City of 1
- San Diego, County of 1
- Rialto, City of 1
- Ventura, City of 1
- Lindsay-Strathmore Cemetery District 1
- Carlsbad, City of 1
- Pacific Grove, City of 1
- Santa Monica, City of 1
- San Benito, County of 1
- …
MNG_AG_TYP 4
ACCESS_TYP 2
DES_TP 1
- Local Historic or Cultural Area · 91 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1401 | 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 | |
1403 | 1403 | 1402 | {"type": "Polygon", "coordinates": [[[-119.78424, 36.31712], [-119.78421, 36.3183], [-119.78422, 36.31887], [-119.78171, 36.3189], [-119.7817, 36.31897], [-119.78093, 36.31891], [-119.78091, 36.31714], [-119.78424, 36.31712]]]} | Open Access 1 | 8812 | Lemoore Cemetery | 21157 | 304 | Kings, County of 360 | County 3 | County Agency 3 | http://www.countyofkings.com/departments/public-works | County 3 | 304 | Kings, County of 357 | County 3 | County Agency 3 | Kings 44 | 14.396 | Lemoore Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
1453 | 1453 | 1452 | {"type": "Polygon", "coordinates": [[[-117.37692, 34.10313], [-117.37483, 34.10313], [-117.37483, 34.10156], [-117.37691, 34.10156], [-117.37692, 34.10313]]]} | Open Access 1 | 12579 | Rialto Park Cemetery | 24316 | 1273 | Rialto, City of 106 | City 2 | City Agency 2 | http://www.rialtoca.gov/ | City 2 | 1273 | Rialto, City of 103 | City 2 | City Agency 2 | San Bernardino 22 | 8.305 | Rialto Park Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
1638 | 1638 | 1637 | {"type": "Polygon", "coordinates": [[[-119.43775, 35.1571], [-119.43547, 35.15711], [-119.43547, 35.15585], [-119.43514, 35.15584], [-119.43497, 35.15576], [-119.43496, 35.15468], [-119.43774, 35.15467], [-119.43775, 35.1571]]]} | Open Access 1 | 14097 | Westside Cemetery | 27421 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 15.293 | Westside Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
1643 | 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 | ||
1685 | 1685 | 1684 | {"type": "Polygon", "coordinates": [[[-121.59246, 37.01144], [-121.59242, 37.01347], [-121.58778, 37.01342], [-121.58781, 37.0113], [-121.58913, 37.01137], [-121.58934, 37.0114], [-121.59246, 37.01144]]]} | Open Access 1 | 14569 | St. Mary's Cemetery | 25770 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | Santa Clara 19 | 23.292 | St. Mary's Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
1839 | 1839 | 1838 | {"type": "Polygon", "coordinates": [[[-118.46441, 35.13789], [-118.4644, 35.13906], [-118.46227, 35.13906], [-118.46228, 35.13789], [-118.46441, 35.13789]]]} | Open Access 1 | 14074 | Tehachapi West Side Cemetery | 26219 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 6.23 | Tehachapi West Side Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
1928 | 1928 | 1927 | {"type": "Polygon", "coordinates": [[[-121.69947, 38.16059], [-121.69822, 38.1616], [-121.69725, 38.16089], [-121.69786, 38.16039], [-121.69803, 38.16032], [-121.69864, 38.15988], [-121.69947, 38.16059]]]} | Open Access 1 | 14905 | St. Joseph Cemetery | 31581 | 1276 | Rio Vista, City of 327 | City 2 | City Agency 2 | http://riovistacity.com/parks-dept/ | City 2 | 1276 | Rio Vista, City of 324 | City 2 | City Agency 2 | Solano 26 | 4.479 | St. Joseph Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
1935 | 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 | |
1942 | 1942 | 1941 | {"type": "Polygon", "coordinates": [[[-121.43074, 36.49462], [-121.42983, 36.49537], [-121.42837, 36.49418], [-121.4298, 36.49384], [-121.43074, 36.49462]]]} | Open Access 1 | 16639 | Gonzales Cemetery | 19393 | 2038 | Gonzales Cemetery District 457 | Special District 4 | Cemetery District 11 | Special District 4 | 2038 | Gonzales Cemetery District 451 | Special District 4 | Cemetery District 11 | Monterey 14 | 4.437 | Gonzales Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
2049 | 2049 | 2048 | {"type": "Polygon", "coordinates": [[[-121.13879, 36.20777], [-121.1387, 36.20806], [-121.13875, 36.20846], [-121.13866, 36.20877], [-121.13851, 36.20885], [-121.13608, 36.2066], [-121.13769, 36.20538], [-121.13782, 36.20538], [-121.1382, 36.20563], [-121.13821, 36.20604], [-121.1385, 36.2066], [-121.13853, 36.2066], [-121.13879, 36.20777]]]} | Open Access 1 | 17107 | King City Cemetery | 20649 | 2052 | King City Cemetery District 471 | Special District 4 | Cemetery District 11 | Special District 4 | 2052 | King City Cemetery District 464 | Special District 4 | Cemetery District 11 | Monterey 14 | 11.815 | King City Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
2224 | 2224 | 2223 | {"type": "MultiPolygon", "coordinates": [[[[-119.78067, 34.4404], [-119.78035, 34.4404], [-119.78034, 34.44016], [-119.78067, 34.44016], [-119.78067, 34.4404]]], [[[-119.78168, 34.43949], [-119.78168, 34.4396], [-119.78068, 34.4396], [-119.78068, 34.43949], [-119.78168, 34.43949]]]]} | Open Access 1 | 16611 | Goleta Cemetery | 19380 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.487 | Goleta Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
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 | |
2394 | 2394 | 2393 | {"type": "Polygon", "coordinates": [[[-120.45327, 36.85931], [-120.45288, 36.85957], [-120.45288, 36.85961], [-120.45117, 36.85982], [-120.45094, 36.85983], [-120.45032, 36.86], [-120.4499, 36.86022], [-120.44966, 36.86037], [-120.44952, 36.86052], [-120.44829, 36.85938], [-120.44841, 36.85912], [-120.44868, 36.85886], [-120.44889, 36.85862], [-120.44897, 36.85833], [-120.4498, 36.8584], [-120.45047, 36.85836], [-120.45209, 36.85818], [-120.45215, 36.85822], [-120.45327, 36.85931]]]} | Open Access 1 | 18627 | Andrew Firebaugh Historical Park | 15484 | 1107 | Firebaugh, City of 523 | City 2 | City Agency 2 | http://www.ci.firebaugh.ca.us/ | City 2 | 1107 | Firebaugh, City of 516 | City 2 | City Agency 2 | Fresno 9 | 16.635 | Andrew Firebaugh Historical Park | 0 | Local Historic or Cultural Area 19 | 4 | |
2454 | 2454 | 2453 | {"type": "Polygon", "coordinates": [[[-117.66179, 33.49999], [-117.66168, 33.50071], [-117.66109, 33.50064], [-117.66106, 33.50059], [-117.66064, 33.50046], [-117.6607, 33.5], [-117.66083, 33.50002], [-117.66099, 33.49984], [-117.66179, 33.49999]]]} | Open Access 1 | 12330 | Historic Town Center (HTC) Park | 20008 | 1305 | San Juan Capistrano, City of 92 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | Orange 3 | 1.879 | Historic Town Ctr. (HTC) Park | 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 |
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]);