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 AGNCY_NAME descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
4352 | 4352 | 4351 | {"type": "Polygon", "coordinates": [[[-122.15012, 39.15433], [-122.14972, 39.15449], [-122.1496, 39.15431], [-122.15001, 39.15415], [-122.15012, 39.15433]]]} | Open Access 1 | 45673 | Williams Historic Town Square | 28702 | 1381 | Williams, City of 752 | City 2 | City Agency 2 | http://www.cityofwilliams.org/parks-rec/index.htm | City 2 | 1381 | Williams, City of 738 | City 2 | City Agency 2 | Colusa 49 | 0.22 | Williams Historic Town Square | 0 | Local Historic or Cultural Area 19 | 4 | |
14339 | 14339 | 14338 | {"type": "Polygon", "coordinates": [[[-124.15133, 40.79915], [-124.15105, 40.79916], [-124.15088, 40.79986], [-124.15065, 40.8], [-124.15066, 40.80016], [-124.1508, 40.80014], [-124.15074, 40.80036], [-124.15062, 40.80038], [-124.15061, 40.80046], [-124.15071, 40.80045], [-124.15058, 40.80093], [-124.15051, 40.80095], [-124.15012, 40.80067], [-124.14902, 40.79999], [-124.14903, 40.79819], [-124.14961, 40.79821], [-124.15103, 40.7982], [-124.15132, 40.79816], [-124.15133, 40.79915]]]} | Open Access 1 | 47011 | Myrtle Grove Cemetery | 30645 | 1419 | Eureka, City of 715 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | Humboldt 45 | 10.734 | Myrtle Grove Cemetery | 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 | |
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 | |
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 | |
3667 | 3667 | 3666 | {"type": "Polygon", "coordinates": [[[-120.63151, 35.14694], [-120.63138, 35.14758], [-120.63074, 35.14764], [-120.63031, 35.14745], [-120.63006, 35.14668], [-120.6304, 35.1465], [-120.63082, 35.14618], [-120.63134, 35.14628], [-120.63127, 35.14651], [-120.63141, 35.14683], [-120.63151, 35.14694]]]} | Open Access 1 | 48812 | Price Historical Park | 33532 | 1253 | Pismo Beach, City of 423 | City 2 | City Agency 2 | http://www.pismobeach.org/69/Parks-Halls | City 2 | 1253 | Pismo Beach, City of 417 | City 2 | City Agency 2 | https://www.pismobeach.org/307/Price-Regional-Park | San Luis Obispo 1 | 3.772 | Price Historical Park | 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 | |
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 | |
1713 | 1713 | 1712 | {"type": "MultiPolygon", "coordinates": [[[[-121.97999, 37.5644], [-121.98024, 37.56435], [-121.9804, 37.56434], [-121.98046, 37.56437], [-121.98049, 37.56446], [-121.98046, 37.56449], [-121.98039, 37.56453], [-121.9797, 37.56477], [-121.97952, 37.56481], [-121.97943, 37.56451], [-121.97999, 37.5644]]], [[[-121.98121, 37.5663], [-121.98119, 37.56634], [-121.98115, 37.56638], [-121.98079, 37.56649], [-121.98073, 37.56649], [-121.98067, 37.56646], [-121.98059, 37.56633], [-121.98044, 37.56604], [-121.98016, 37.56567], [-121.98005, 37.56548], [-121.97984, 37.56491], [-121.97984, 37.56487], [-121.97986, 37.56484], [-121.98051, 37.5646], [-121.98057, 37.5646], [-121.98063, 37.56462], [-121.98078, 37.5648], [-121.98102, 37.56501], [-121.98114, 37.56519], [-121.98121, 37.56537], [-121.98121, 37.56555], [-121.98115, 37.56583], [-121.98113, 37.56599], [-121.98115, 37.56614], [-121.98121, 37.5663]]]]} | Open Access 1 | 12857 | Shin Historic Park | 30828 | 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 | 4.615 | Shin Historic Park | 1984 | 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 | |
14399 | 14399 | 14398 | {"type": "Polygon", "coordinates": [[[-121.91219, 37.50432], [-121.91168, 37.50446], [-121.91141, 37.50375], [-121.91142, 37.50369], [-121.91146, 37.50366], [-121.91188, 37.50352], [-121.91219, 37.50432]]]} | Open Access 1 | 47143 | Weibel Historic Park | 30824 | 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 | 1.058 | Weibel Historic Park | 0 | Local Historic or Cultural Area 19 | 4 | |
14488 | 14488 | 14487 | {"type": "MultiPolygon", "coordinates": [[[[-121.92957, 37.52765], [-121.92904, 37.52787], [-121.92906, 37.52801], [-121.92896, 37.52804], [-121.92832, 37.52787], [-121.92821, 37.52768], [-121.92806, 37.52767], [-121.92798, 37.52757], [-121.92784, 37.52759], [-121.92782, 37.52755], [-121.92767, 37.52756], [-121.92716, 37.52778], [-121.92698, 37.52781], [-121.9268, 37.52779], [-121.92655, 37.5279], [-121.92631, 37.52794], [-121.92568, 37.528], [-121.92557, 37.52799], [-121.92539, 37.52794], [-121.92532, 37.52789], [-121.92531, 37.52787], [-121.92532, 37.52784], [-121.92488, 37.52769], [-121.92485, 37.52769], [-121.92481, 37.52764], [-121.92474, 37.52762], [-121.92468, 37.52761], [-121.92462, 37.52763], [-121.9245, 37.52774], [-121.92441, 37.52773], [-121.92368, 37.52734], [-121.92355, 37.52723], [-121.92347, 37.52714], [-121.92341, 37.52703], [-121.92337, 37.52685], [-121.92331, 37.52674], [-121.92334, 37.52666], [-121.92294, 37.5266], [-121.92293, 37.52658], [-121.92284, 37.52657], [-121.92283, 37.52652], [-121.9229, 37.52647], [-121.92239, 37.52481], [-121.92205, 37.52465], [-121.9222, 37.52446], [-121.92242, 37.52428], [-121.92333, 37.52532], [-121.92329, 37.52565], [-121.92358, 37.5262], [-121.92382, 37.52694], [-121.92471, 37.52719], [-121.92523, 37.52718], [-121.92528, 37.5273], [-121.92592, 37.52727], [-121.92643, 37.52729], [-121.92853, 37.52708], [-121.92946, 37.52696], [-121.92957, 37.52765]]], [[[-121.94454, 37.52675], [-121.94411, 37.52792], [-121.94373, 37.52835], [-121.94339, 37.52845], [-121.94033, 37.52856], [-121.93776, 37.52812], [-121.9377, 37.52828], [-121.93755, 37.52825], [-121.93748, 37.52829], [-121.93446, 37.52717], [-121.93354, 37.5271], [-121.93241, 37.52735], [-121.93246, 37.5277], [-121.93239, 37.52778], [-121.932, 37.52792], [-121.93159, 37.52816], [-121.93149, 37.52817], [-121.93142, 37.52813], [-121.93089, 37.52757], [-121.93026, 37.52685], [-121.92988, 37.52646], [-121.93123, 37.52608], [-121.93146, 37.52619], [-121.93183, 37.52574], [-121.93097, 37.52486], [-121.93146, 37.5247], [-121.93163, 37.52469], [-121.93189, 37.52473], [-121.93215, 37.52474], [-121.93232, 37.52552], [-121.93301, 37.52561], [-121.93331, 37.5253], [-121.93305, 37.52458], [-121.93338, 37.52458], [-121.93427, 37.52471], [-121.9347, 37.52482], [-121.9346, 37.52508], [-121.93491, 37.52518], [-121.93542, 37.52557], [-121.93557, 37.52566], [-121.93581, 37.52575], [-121.93603, 37.52579], [-121.93625, 37.5258], [-121.93657, 37.52578], [-121.93666, 37.5258], [-121.93716, 37.52612], [-121.93755, 37.52645], [-121.93771, 37.52635], [-121.93797, 37.52654], [-121.93844, 37.52644], [-121.93849, 37.52656], [-121.93857, 37.52668], [-121.93867, 37.52678], [-121.93878, 37.52688], [-121.93904, 37.52703], [-121.93939, 37.52713], [-121.93973, 37.52716], [-121.94005, 37.52714], [-121.94033, 37.52707], [-121.94076, 37.5269], [-121.94083, 37.52651], [-121.9408, 37.52645], [-121.94075, 37.5264], [-121.94038, 37.5262], [-121.93998, 37.52636], [-121.93985, 37.52639], [-121.93965, 37.52639], [-121.93946, 37.52634], [-121.9394, 37.52629], [-121.93937, 37.52623], [-121.93934, 37.52594], [-121.93926, 37.52568], [-121.93913, 37.52547], [-121.93896, 37.52529], [-121.93817, 37.52521], [-121.93761, 37.52504], [-121.93714, 37.52482], [-121.9364, 37.52432], [-121.93627, 37.52425], [-121.93614, 37.52421], [-121.93592, 37.52418], [-121.9357, 37.5242], [-121.93552, 37.52425], [-121.93527, 37.52437], [-121.93508, 37.5244], [-121.93492, 37.52438], [-121.93466, 37.52429], [-121.93444, 37.52424], [-121.93352, 37.52411], [-121.9333, 37.52409], [-121.93292, 37.5241], [-121.93213, 37.52425], [-121.93197, 37.52426], [-121.9319, 37.52425], [-121.93191, 37.52396], [-121.9317, 37.52394], [-121.93146, 37.52394], [-121.93124, 37.52397], [-121.93103, 37.52402], [-121.93026, 37.52431], [-121.93002, 37.52428], [-121.92978, 37.52432], [-121.92966, 37.52438], [-121.92956, 37.52446], [-121.92948, 37.52457], [-121.92943, 37.52469], [-121.92939, 37.5247], [-121.92922, 37.52363], [-121.92978, 37.52361], [-121.92998, 37.52359], [-121.93178, 37.52329], [-121.93211, 37.52319], [-121.93367, 37.52316], [-121.93492, 37.52335], [-121.9359, 37.52338], [-121.93712, 37.52368], [-121.93818, 37.52433], [-121.93973, 37.52487], [-121.93991, 37.52513], [-121.94096, 37.52561], [-121.94353, 37.52614], [-121.94397, 37.52636], [-121.94433, 37.52647], [-121.94454, 37.52675]]], [[[-121.93101, 37.52815], [-121.92994, 37.52826], [-121.92972, 37.52692], [-121.92985, 37.5269], [-121.93101, 37.52815]]]]} | Open Access 1 | 47147 | Sabercat Historic Park | 30829 | 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 | 110.979 | Sabercat Historic Park | 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 | |
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 | |
11279 | 11279 | 11278 | {"type": "Polygon", "coordinates": [[[-118.15783, 34.11516], [-118.15741, 34.1155], [-118.15725, 34.11565], [-118.15722, 34.11553], [-118.15722, 34.11543], [-118.15741, 34.11524], [-118.15742, 34.11513], [-118.15783, 34.11513], [-118.15783, 34.11516]]]} | Open Access 1 | 48041 | Ironwork Historical Museum and Park | 32534 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | https://www.southpasadenaca.gov/government/departments/community-services/administration/south-pasadena-historical-museum | Los Angeles 6 | 0.327 | Ironwork Historical Museum and Park | 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 | |
7308 | 7308 | 7307 | {"type": "Polygon", "coordinates": [[[-118.19678, 33.8389], [-118.19592, 33.84035], [-118.19458, 33.8398], [-118.1951, 33.83894], [-118.19568, 33.83917], [-118.19613, 33.8388], [-118.19607, 33.83861], [-118.19622, 33.83874], [-118.19634, 33.8388], [-118.19678, 33.8389]]]} | Restricted Access 2 | 6595 | Rancho Los Cerritos Historic Site | 32776 | 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.786 | Rancho Los Cerritos Historic Site | 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]);