units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where DES_TP = 19 and MNG_AG_TYP = 2 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
MNG_AGENCY 29
- Fremont, City of 6
- Long Beach, City of 3
- Rio Vista, City of 2
- Oakdale, City of 1
- San Diego, City of 1
- Los Angeles, City of 1
- San Jose, City of 1
- Monterey, City of 1
- Turlock, City of 1
- San Ramon, City of 1
- San Juan Capistrano, City of 1
- Oxnard, City of 1
- San Mateo, City of 1
- Rialto, City of 1
- Ventura, City of 1
- Carlsbad, City of 1
- Pacific Grove, City of 1
- Santa Monica, City of 1
- South Pasadena, City of 1
- Redwood City, City of 1
- Gilroy, City of 1
- Pismo Beach, City of 1
- Modesto, City of 1
- Firebaugh, City of 1
- Marysville, City of 1
- Eureka, City of 1
- Williams, City of 1
- Los Angeles - Community Redevelopment Agency, City of 1
- Colma, City of 1
COUNTY 17 ✖
- Los Angeles 7
- Alameda 6
- Stanislaus 3
- San Mateo 3
- San Diego 2
- Ventura 2
- Monterey 2
- Santa Clara 2
- Solano 2
- San Luis Obispo 1
- Orange 1
- Fresno 1
- Contra Costa 1
- San Bernardino 1
- Yuba 1
- Humboldt 1
- Colusa 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 37 ✖
DES_TP 1
- Local Historic or Cultural Area · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10440 | 10440 | 10439 | {"type": "Polygon", "coordinates": [[[-120.98531, 37.64901], [-120.98463, 37.64903], [-120.98465, 37.65], [-120.98013, 37.65001], [-120.98012, 37.64965], [-120.97954, 37.64967], [-120.97858, 37.64965], [-120.97844, 37.64819], [-120.9788, 37.64804], [-120.97888, 37.64799], [-120.97931, 37.64775], [-120.97965, 37.6476], [-120.98014, 37.64747], [-120.98097, 37.64734], [-120.98438, 37.6473], [-120.98461, 37.64722], [-120.98472, 37.64719], [-120.98498, 37.64709], [-120.98508, 37.64706], [-120.98517, 37.64708], [-120.98524, 37.64712], [-120.98528, 37.6472], [-120.98531, 37.64901]]]} | Open Access 1 | 18450 | Acacia Memorial Park Cemeteries | 15242 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 39.539 | Acacia Memorial Park Cemeteries | 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 | |
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 | |
12422 | 12422 | 12421 | {"type": "Polygon", "coordinates": [[[-122.45638, 37.68223], [-122.45632, 37.68224], [-122.45604, 37.68209], [-122.4562, 37.68199], [-122.45636, 37.68214], [-122.45638, 37.68223]]]} | Open Access 1 | 27027 | Colma Historical | 17523 | 1456 | Colma, City of 968 | City 2 | City Agency 2 | http://www.colma.ca.gov/ | City 2 | 1456 | Colma, City of 934 | City 2 | City Agency 2 | San Mateo 15 | 0.098 | Colma Historical | 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 | |
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 | |
13090 | 13090 | 13089 | {"type": "Polygon", "coordinates": [[[-121.9528, 37.73557], [-121.95073, 37.73637], [-121.94946, 37.73461], [-121.9492, 37.73429], [-121.95111, 37.73302], [-121.95184, 37.73419], [-121.952, 37.73427], [-121.95247, 37.73463], [-121.95246, 37.73468], [-121.9528, 37.73557]]]} | Open Access 1 | 35009 | Forest Home Farms Historic Park | 18994 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 15.479 | Forest Home Farms Historic Park | 0 | Local Historic or Cultural Area 19 | 4 | |
3577 | 3577 | 3576 | {"type": "Polygon", "coordinates": [[[-121.90718, 37.34301], [-121.90614, 37.34373], [-121.90546, 37.34312], [-121.90653, 37.3424], [-121.90718, 37.34301]]]} | Open Access 1 | 29148 | Historic Orchard | 20007 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 2.747 | Historic Orchard | 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 | |
6431 | 6431 | 6430 | {"type": "Polygon", "coordinates": [[[-117.23992, 33.11868], [-117.23968, 33.12004], [-117.23953, 33.12006], [-117.23882, 33.12], [-117.23835, 33.11991], [-117.23795, 33.12013], [-117.23771, 33.12034], [-117.23735, 33.12062], [-117.23697, 33.12084], [-117.23701, 33.12088], [-117.23698, 33.12091], [-117.23632, 33.12138], [-117.23525, 33.12035], [-117.23528, 33.12033], [-117.23525, 33.12019], [-117.23525, 33.12012], [-117.23532, 33.11989], [-117.2357, 33.11951], [-117.23574, 33.11935], [-117.23573, 33.11929], [-117.23562, 33.11916], [-117.23573, 33.11901], [-117.23569, 33.11894], [-117.23563, 33.11888], [-117.23551, 33.11886], [-117.23545, 33.11884], [-117.23531, 33.11875], [-117.23541, 33.11845], [-117.23546, 33.11814], [-117.23543, 33.11795], [-117.23535, 33.11772], [-117.23527, 33.11758], [-117.2353, 33.11753], [-117.23553, 33.11743], [-117.23577, 33.11762], [-117.23577, 33.11765], [-117.23599, 33.11774], [-117.23602, 33.11778], [-117.23625, 33.11783], [-117.23627, 33.11786], [-117.23636, 33.11788], [-117.23655, 33.11782], [-117.23665, 33.11761], [-117.23783, 33.11779], [-117.23816, 33.11782], [-117.23812, 33.11828], [-117.23831, 33.11843], [-117.23851, 33.11847], [-117.23868, 33.11847], [-117.23992, 33.11868]]]} | Open Access 1 | 1950 | Leo Carillo Ranch Historic Park | 21165 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/south/carrillo.asp | San Diego 4 | 27.397 | Leo Carillo Ranch Historic Park | 0 | Local Historic or Cultural Area 19 | 4 |
7348 | 7348 | 7347 | {"type": "Polygon", "coordinates": [[[-118.17741, 33.80621], [-118.17642, 33.80621], [-118.17642, 33.80452], [-118.17647, 33.80448], [-118.1774, 33.80448], [-118.17741, 33.80621]]]} | Open Access 1 | 6670 | Long Beach Municipal Cemetery | 21448 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 4.336 | Long Beach Municipal Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
10099 | 10099 | 10098 | {"type": "Polygon", "coordinates": [[[-121.89403, 36.60846], [-121.89279, 36.60845], [-121.89238, 36.60732], [-121.89352, 36.60702], [-121.89403, 36.60846]]]} | Open Access 1 | 17491 | Lower Presidio Historic Park | 21563 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 3.927 | Lower Presidio Historic Park | 0 | Local Historic or Cultural Area 19 | 4 | |
10882 | 10882 | 10881 | {"type": "Polygon", "coordinates": [[[-121.5905, 39.16306], [-121.58991, 39.16309], [-121.58918, 39.16319], [-121.58873, 39.16338], [-121.58845, 39.16366], [-121.5879, 39.1643], [-121.58752, 39.16179], [-121.58779, 39.16135], [-121.5894, 39.16106], [-121.59023, 39.16096], [-121.5905, 39.16306]]]} | Open Access 1 | 20796 | Marysville Cemetery | 21939 | 1199 | Marysville, City of 539 | City 2 | City Agency 2 | http://www.marysville.ca.us/index.php/city-services/parks-facilities | City 2 | 1199 | Marysville, City of 532 | City 2 | City Agency 2 | Yuba 25 | 14.695 | Marysville Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
10724 | 10724 | 10723 | {"type": "MultiPolygon", "coordinates": [[[[-117.11649, 32.70594], [-117.11649, 32.7063], [-117.11572, 32.70628], [-117.11532, 32.70631], [-117.11495, 32.70636], [-117.11458, 32.70643], [-117.11421, 32.70653], [-117.11385, 32.70665], [-117.11357, 32.70677], [-117.11306, 32.70703], [-117.11046, 32.70859], [-117.11008, 32.70877], [-117.10962, 32.70894], [-117.10841, 32.70544], [-117.10898, 32.70544], [-117.10905, 32.70531], [-117.10918, 32.70519], [-117.10936, 32.70513], [-117.10958, 32.70512], [-117.10958, 32.70489], [-117.11436, 32.70488], [-117.11437, 32.70556], [-117.11498, 32.70557], [-117.11548, 32.70616], [-117.11575, 32.70615], [-117.11601, 32.70611], [-117.11615, 32.70608], [-117.11649, 32.70594]]], [[[-117.11649, 32.70644], [-117.11649, 32.70802], [-117.11644, 32.70818], [-117.11643, 32.7084], [-117.11641, 32.71134], [-117.11635, 32.71139], [-117.11262, 32.71135], [-117.11043, 32.71131], [-117.10966, 32.70906], [-117.11006, 32.70892], [-117.11054, 32.7087], [-117.11314, 32.70714], [-117.1135, 32.70696], [-117.11387, 32.70679], [-117.1142, 32.70668], [-117.11451, 32.70659], [-117.1151, 32.70648], [-117.11575, 32.70643], [-117.11649, 32.70644]]]]} | Open Access 1 | 19929 | Mt Hope Cemetery | 22573 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 108.763 | Mt Hope Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
2909 | 2909 | 2908 | {"type": "Polygon", "coordinates": [[[-120.84105, 37.76305], [-120.84027, 37.76338], [-120.84025, 37.76306], [-120.83825, 37.76356], [-120.83698, 37.76391], [-120.83696, 37.76186], [-120.84023, 37.76187], [-120.84105, 37.76305]]]} | Open Access 1 | 18977 | Oakdale Citizens Cemetery | 23022 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 14.241 | Oakdale Citizens Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
1136 | 1136 | 1135 | {"type": "Polygon", "coordinates": [[[-118.10845, 33.77696], [-118.10812, 33.77733], [-118.10811, 33.77767], [-118.1074, 33.77768], [-118.1063, 33.7776], [-118.10633, 33.77741], [-118.10608, 33.77704], [-118.10604, 33.77647], [-118.10563, 33.77642], [-118.10564, 33.77625], [-118.10604, 33.77629], [-118.10686, 33.77626], [-118.10722, 33.77607], [-118.10745, 33.77636], [-118.10787, 33.77635], [-118.10794, 33.77631], [-118.10845, 33.77696]]]} | Open Access 1 | 6659 | Rancho Los Alamitos Historic Site | 24152 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 7.405 | Rancho Los Alamitos Historic Site | 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 | |
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 | |
5930 | 5930 | 5929 | {"type": "Polygon", "coordinates": [[[-120.86721, 37.49685], [-120.86724, 37.50022], [-120.86539, 37.50025], [-120.86542, 37.49801], [-120.86237, 37.49803], [-120.86236, 37.4969], [-120.86415, 37.49687], [-120.8642, 37.49471], [-120.8649, 37.4947], [-120.86489, 37.49284], [-120.86718, 37.49284], [-120.86717, 37.49545], [-120.86721, 37.49685]]]} | Open Access 1 | 431 | Turlock Memorial Park Cemetery | 26582 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 49.361 | Turlock Memorial Park Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
5104 | 5104 | 5103 | {"type": "Polygon", "coordinates": [[[-122.22471, 37.47312], [-122.2232, 37.47432], [-122.22235, 37.475], [-122.22294, 37.47252], [-122.22471, 37.47312]]]} | Open Access 1 | 13961 | Union Cemetery | 26655 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 5.763 | Union Cemetery | 1962 | 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]);