units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
116 rows where DES_TP = 19
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Fremont, City of 5
- Kern, County of 2
- Merced Cemetery District 2
- San Diego, City of 1
- Santa Barbara, County of 1
- Los Angeles, County of 1
- Monterey, County of 1
- Los Angeles, City of 1
- Monterey, City of 1
- San Ramon, City of 1
- San Mateo, City of 1
- Riverside, County of 1
- Pacific Grove, City of 1
- South Pasadena, City of 1
- Rio Vista, City of 1
- Merced, County of 1
- Modesto, City of 1
- Mono, County of 1
- Marysville, City of 1
- Eureka, City of 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
- Oak Hill Cemetery District 1
- Colma, City of 1
- …
MNG_AG_TYP 3
DES_TP 1
- Local Historic or Cultural Area · 37 ✖
ACCESS_TYP 1
- Open Access 37
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8127 | 8127 | 8126 | {"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 | 12304 | El Toro Memorial Park Cemetery | 18544 | 2104 | Orange County Cemetery District 885 | Special District 4 | Cemetery District 11 | http://www.occemeterydistrict.com/ | Special District 4 | 2104 | Orange County Cemetery District 861 | Special District 4 | Cemetery District 11 | Orange 3 | 25.36 | El Toro Memorial Park Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
8354 | 8354 | 8353 | {"type": "MultiPolygon", "coordinates": [[[[-118.23804, 34.05665], [-118.23761, 34.05703], [-118.23757, 34.05704], [-118.23752, 34.05703], [-118.23751, 34.05698], [-118.23761, 34.05653], [-118.23783, 34.05657], [-118.23804, 34.05665]]], [[[-118.23804, 34.05645], [-118.23761, 34.05638], [-118.23763, 34.05623], [-118.23763, 34.05623], [-118.23804, 34.05645]]], [[[-118.23843, 34.05598], [-118.23816, 34.05631], [-118.23813, 34.05632], [-118.23806, 34.05631], [-118.23784, 34.05617], [-118.23768, 34.05611], [-118.23767, 34.05608], [-118.23775, 34.05566], [-118.23786, 34.05564], [-118.23797, 34.05568], [-118.23843, 34.05598]]], [[[-118.23875, 34.05625], [-118.23891, 34.05628], [-118.23901, 34.05635], [-118.23907, 34.05644], [-118.23909, 34.05655], [-118.23906, 34.05667], [-118.23897, 34.05676], [-118.23885, 34.05682], [-118.23872, 34.05683], [-118.23858, 34.0568], [-118.23849, 34.05673], [-118.23842, 34.05664], [-118.2384, 34.05653], [-118.23842, 34.05643], [-118.2385, 34.05634], [-118.23861, 34.05627], [-118.23875, 34.05625]]]]} | Open Access 1 | 12941 | El Pueblo de Los Angeles Historic Monument | 28788 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.002 | El Pueblo de Los Angeles Historic Monument | 0 | Local Historic or Cultural Area 19 | 4 | |
8357 | 8357 | 8356 | {"type": "Polygon", "coordinates": [[[-121.97302, 37.57768], [-121.97271, 37.57778], [-121.97221, 37.57798], [-121.97175, 37.5782], [-121.97137, 37.57844], [-121.97084, 37.57884], [-121.97022, 37.57927], [-121.96994, 37.57941], [-121.96963, 37.57954], [-121.9693, 37.57963], [-121.96896, 37.5797], [-121.96831, 37.57978], [-121.97147, 37.57681], [-121.97151, 37.57678], [-121.9716, 37.57677], [-121.9717, 37.57679], [-121.97232, 37.57723], [-121.97302, 37.57768]]]} | Open Access 1 | 12898 | Vallejo Mill Historical Park | 26781 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 10.708 | Vallejo Mill Historical Park | 0 | Local Historic or Cultural Area 19 | 4 | |
8360 | 8360 | 8359 | {"type": "Polygon", "coordinates": [[[-121.98613, 37.54673], [-121.98584, 37.5471], [-121.98512, 37.54673], [-121.98542, 37.54636], [-121.98613, 37.54673]]]} | Open Access 1 | 12957 | Williams Historical Park | 27563 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 0.894 | Williams Historical Park | 1973 | Local Historic or Cultural Area 19 | 4 | |
8395 | 8395 | 8394 | {"type": "Polygon", "coordinates": [[[-121.99259, 37.57902], [-121.99259, 37.5792], [-121.99245, 37.57941], [-121.99233, 37.57986], [-121.99191, 37.57981], [-121.9916, 37.57975], [-121.98925, 37.57918], [-121.98833, 37.57892], [-121.98886, 37.57751], [-121.98938, 37.57762], [-121.98954, 37.57724], [-121.98953, 37.57723], [-121.989, 37.57711], [-121.98928, 37.57637], [-121.99188, 37.57696], [-121.99169, 37.57747], [-121.99174, 37.57756], [-121.99156, 37.57807], [-121.99154, 37.57807], [-121.99152, 37.57814], [-121.99143, 37.57821], [-121.99135, 37.57842], [-121.99133, 37.57843], [-121.99126, 37.57861], [-121.99131, 37.57897], [-121.99177, 37.57908], [-121.9924, 37.57902], [-121.99259, 37.57902]], [[-121.99109, 37.57735], [-121.99097, 37.57733], [-121.99092, 37.57749], [-121.9913, 37.57757], [-121.99136, 37.5774], [-121.99109, 37.57735]]]} | Open Access 1 | 12991 | California Nursery Historic Park | 30817 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 19.845 | California Nursery Historic Park | 0 | Local Historic or Cultural Area 19 | 4 | |
8676 | 8676 | 8675 | {"type": "Polygon", "coordinates": [[[-119.25839, 35.76429], [-119.25672, 35.76457], [-119.25645, 35.76341], [-119.25645, 35.76146], [-119.25834, 35.76146], [-119.25837, 35.7623], [-119.25839, 35.76429]]]} | Open Access 1 | 14006 | North Kern Cemetery | 22826 | 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 | 13.858 | North Kern Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
8683 | 8683 | 8682 | {"type": "Polygon", "coordinates": [[[-122.32986, 37.56138], [-122.32912, 37.5622], [-122.32894, 37.56233], [-122.32844, 37.56238], [-122.32831, 37.56247], [-122.32823, 37.56284], [-122.32781, 37.56315], [-122.32743, 37.56319], [-122.32742, 37.56305], [-122.32757, 37.56302], [-122.32772, 37.56297], [-122.32787, 37.56289], [-122.328, 37.56279], [-122.32812, 37.56262], [-122.32821, 37.56237], [-122.32832, 37.56226], [-122.32847, 37.56218], [-122.32876, 37.56213], [-122.32893, 37.56205], [-122.32912, 37.56187], [-122.32922, 37.56173], [-122.32935, 37.56164], [-122.32946, 37.56162], [-122.32953, 37.56157], [-122.32957, 37.56149], [-122.32952, 37.5614], [-122.3297, 37.56137], [-122.32986, 37.56138]]]} | Open Access 1 | 14040 | DeAnza Historical Area | 17979 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.425 | DeAnza Historical Area | 1940 | Local Historic or Cultural Area 19 | 4 | |
8688 | 8688 | 8687 | {"type": "Polygon", "coordinates": [[[-118.47884, 35.13979], [-118.4787, 35.14035], [-118.47877, 35.14051], [-118.47839, 35.14065], [-118.47798, 35.13995], [-118.4781, 35.13977], [-118.47884, 35.13979]]]} | Open Access 1 | 14050 | Old Tehachapi Cemetery | 23105 | 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 | 1.254 | Old Tehachapi Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
8862 | 8862 | 8861 | {"type": "Polygon", "coordinates": [[[-121.93261, 36.63166], [-121.93201, 36.63331], [-121.9294, 36.63268], [-121.92997, 36.63113], [-121.93025, 36.63117], [-121.93046, 36.63118], [-121.93084, 36.63115], [-121.93112, 36.6311], [-121.93131, 36.63103], [-121.9315, 36.63096], [-121.93171, 36.63084], [-121.93261, 36.63166]]]} | Open Access 1 | 14488 | El Carmelo Cemetery | 18487 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 12.698 | El Carmelo Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9011 | 9011 | 9010 | {"type": "Polygon", "coordinates": [[[-121.70163, 38.16458], [-121.70079, 38.16524], [-121.69973, 38.16441], [-121.69925, 38.16476], [-121.69829, 38.16404], [-121.69956, 38.16294], [-121.70163, 38.16458]]]} | Open Access 1 | 14918 | Cemetery | 17008 | 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 | 8.295 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9587 | 9587 | 9586 | {"type": "Polygon", "coordinates": [[[-120.45155, 34.63055], [-120.45154, 34.63089], [-120.45128, 34.63077], [-120.45087, 34.63037], [-120.45125, 34.63029], [-120.45155, 34.63055]]]} | Open Access 1 | 17395 | Lompoc Cemetery | 21418 | 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.518 | Lompoc Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9771 | 9771 | 9770 | {"type": "Polygon", "coordinates": [[[-121.24325, 36.3164], [-121.24255, 36.31678], [-121.24189, 36.31602], [-121.24259, 36.31563], [-121.24325, 36.3164]]]} | Open Access 1 | 16676 | Greenfield Cemetery | 19477 | 2040 | Greenfield Cemetery District 925 | Special District 4 | Cemetery District 11 | http://www.co.monterey.ca.us/factfinder/specdistr.htm | Special District 4 | 2040 | Greenfield Cemetery District 898 | Special District 4 | Cemetery District 11 | Monterey 14 | 1.939 | Greenfield Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9794 | 9794 | 9793 | {"type": "Polygon", "coordinates": [[[-120.57648, 34.95764], [-120.57647, 34.95894], [-120.57408, 34.95892], [-120.57408, 34.95762], [-120.57648, 34.95764]]]} | Open Access 1 | 16696 | Guadalupe Cemetery | 19541 | 2043 | Guadalupe Cemetery District 927 | Special District 4 | Cemetery District 11 | Special District 4 | 2043 | Guadalupe Cemetery District 900 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 7.795 | Guadalupe Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
9856 | 9856 | 9855 | {"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 | 16870 | Cemetery | 17009 | 2029 | Dos Palos Cemetery District 932 | Special District 4 | Cemetery District 11 | Special District 4 | 2029 | Dos Palos Cemetery District 905 | Special District 4 | Cemetery District 11 | Merced 37 | 19.154 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
9860 | 9860 | 9859 | {"type": "Polygon", "coordinates": [[[-119.79074, 36.62769], [-119.79073, 36.63053], [-119.78905, 36.63053], [-119.78908, 36.62705], [-119.78953, 36.62705], [-119.78954, 36.62767], [-119.79074, 36.62769]]]} | Open Access 1 | 16875 | Washington Colony Cemetery | 27268 | 2176 | Washington Colony Cemetery District 933 | Special District 4 | Cemetery District 11 | Special District 4 | 2176 | Washington Colony Cemetery District 906 | Special District 4 | Cemetery District 11 | Fresno 9 | 12.379 | Washington Colony Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
9867 | 9867 | 9866 | {"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 | 16900 | Cemetery | 17010 | 2047 | Hills Ferry Cemetery District 934 | Special District 4 | Cemetery District 11 | Special District 4 | 2047 | Hills Ferry Cemetery District 907 | Special District 4 | Cemetery District 11 | Merced 37 | 2.605 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
9870 | 9870 | 9869 | {"type": "Polygon", "coordinates": [[[-120.4723, 37.28882], [-120.47021, 37.29245], [-120.46974, 37.29228], [-120.46974, 37.29222], [-120.46756, 37.29221], [-120.46759, 37.28885], [-120.46978, 37.28886], [-120.4698, 37.28836], [-120.47013, 37.28838], [-120.47014, 37.28804], [-120.4702, 37.28805], [-120.4723, 37.28882]]]} | Open Access 1 | 16923 | Merced Cemetery | 22159 | 2076 | Merced Cemetery District 935 | Special District 4 | Cemetery District 11 | http://www.co.merced.ca.us/index.aspx?NID=1329 | Special District 4 | 2076 | Merced Cemetery District 908 | Special District 4 | Cemetery District 11 | Merced 37 | 33.39 | Merced Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9884 | 9884 | 9883 | {"type": "Polygon", "coordinates": [[[-120.48745, 37.28615], [-120.48741, 37.28801], [-120.48736, 37.28814], [-120.48725, 37.28825], [-120.48715, 37.28825], [-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 | 16920 | Cemetery | 17013 | 2076 | Merced Cemetery District 935 | Special District 4 | Cemetery District 11 | http://www.co.merced.ca.us/index.aspx?NID=1329 | Special District 4 | 2076 | Merced Cemetery District 908 | Special District 4 | Cemetery District 11 | Merced 37 | 13.619 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9952 | 9952 | 9951 | {"type": "Polygon", "coordinates": [[[-120.63123, 37.3803], [-120.62725, 37.38031], [-120.6272, 37.38206], [-120.62483, 37.38206], [-120.62482, 37.38031], [-120.62279, 37.38031], [-120.62281, 37.3785], [-120.62812, 37.37849], [-120.63036, 37.37943], [-120.63093, 37.37997], [-120.63123, 37.3803]]]} | Open Access 1 | 17120 | Winton Cemetery | 27657 | 2183 | Winton Cemetery District 939 | Special District 4 | Cemetery District 11 | http://www.co.merced.ca.us/index.aspx?NID=1329 | Special District 4 | 2183 | Winton Cemetery District 912 | Special District 4 | Cemetery District 11 | Merced 37 | 41.911 | Winton Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9973 | 9973 | 9972 | {"type": "Polygon", "coordinates": [[[-120.28195, 34.73211], [-120.28188, 34.73339], [-120.2803, 34.73332], [-120.2804, 34.73204], [-120.28195, 34.73211]]]} | Open Access 1 | 17408 | Los Alamos Cemetery | 21471 | 2064 | Los Alamos Cemetery District 940 | Special District 4 | Cemetery District 11 | Special District 4 | 2064 | Los Alamos Cemetery District 913 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 5.019 | Los Alamos 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]);