units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where MNG_AGENCY = 62
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
DES_TP 4
- Local Park 24
- Local Recreation Area 4
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 30
MNG_AGENCY 1
- Yorba Linda, City of · 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
166 | 166 | 165 | {"type": "Polygon", "coordinates": [[[-117.79359, 33.89318], [-117.7925, 33.89354], [-117.79204, 33.89354], [-117.79144, 33.89368], [-117.79082, 33.89369], [-117.79105, 33.89335], [-117.79115, 33.89317], [-117.79126, 33.89285], [-117.79131, 33.8926], [-117.79133, 33.89305], [-117.79295, 33.89303], [-117.79295, 33.89283], [-117.79312, 33.89283], [-117.79312, 33.89263], [-117.79317, 33.89262], [-117.79317, 33.89234], [-117.79344, 33.89233], [-117.79343, 33.89188], [-117.79357, 33.89188], [-117.79359, 33.89318]]]} | Open Access 1 | 437 | Fairmont Knolls Park | 18803 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 4.085 | Fairmont Knolls Park | 0 | Local Park 2 | 4 | |
274 | 274 | 273 | {"type": "Polygon", "coordinates": [[[-117.72318, 33.87548], [-117.72312, 33.87587], [-117.7229, 33.87584], [-117.72266, 33.87578], [-117.72254, 33.87582], [-117.72248, 33.87589], [-117.72204, 33.87581], [-117.72218, 33.87558], [-117.72251, 33.87523], [-117.72255, 33.87523], [-117.72297, 33.87543], [-117.72318, 33.87548]]]} | Open Access 1 | 47365 | Vista Lampara Park | 31088 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 1.193 | Vista Lampara Park | 0 | Local Park 2 | 4 | |
1258 | 1258 | 1257 | {"type": "Polygon", "coordinates": [[[-117.82647, 33.89296], [-117.82647, 33.89501], [-117.82493, 33.89501], [-117.82475, 33.8951], [-117.82447, 33.89519], [-117.82441, 33.89517], [-117.82441, 33.89385], [-117.82507, 33.89384], [-117.82507, 33.89327], [-117.82524, 33.89325], [-117.82543, 33.89329], [-117.8257, 33.89332], [-117.82585, 33.89332], [-117.82599, 33.89329], [-117.8262, 33.89321], [-117.82632, 33.89311], [-117.82647, 33.89296]]]} | Open Access 1 | 5672 | Hurless Barton Park | 20159 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 8.379 | Hurless Barton Park | 0 | Local Park 2 | 4 | |
4917 | 4917 | 4916 | {"type": "Polygon", "coordinates": [[[-117.82853, 33.89184], [-117.82817, 33.89197], [-117.828, 33.89201], [-117.82759, 33.89206], [-117.82747, 33.89209], [-117.82732, 33.89215], [-117.82719, 33.89224], [-117.82688, 33.89253], [-117.82632, 33.89311], [-117.82612, 33.89323], [-117.82593, 33.89329], [-117.82571, 33.8933], [-117.82521, 33.89324], [-117.82534, 33.89321], [-117.82536, 33.89213], [-117.82549, 33.89178], [-117.8255, 33.89028], [-117.82852, 33.89025], [-117.82853, 33.89184]], [[-117.82741, 33.89046], [-117.82742, 33.89038], [-117.82737, 33.89037], [-117.82737, 33.89045], [-117.82741, 33.89046]]]} | Open Access 1 | 47363 | Veterans Park | 31086 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 17.975 | Veterans Park | 0 | Local Park 2 | 4 | |
5270 | 5270 | 5269 | {"type": "Polygon", "coordinates": [[[-117.78541, 33.90474], [-117.7852, 33.90483], [-117.78511, 33.90484], [-117.78479, 33.9047], [-117.78462, 33.90466], [-117.78444, 33.90463], [-117.78409, 33.90462], [-117.78399, 33.90459], [-117.78389, 33.90453], [-117.78375, 33.90428], [-117.78342, 33.9044], [-117.78343, 33.90367], [-117.78306, 33.90367], [-117.78344, 33.90343], [-117.78346, 33.90345], [-117.78358, 33.90344], [-117.78388, 33.9037], [-117.78402, 33.90378], [-117.78417, 33.90384], [-117.78457, 33.90395], [-117.78477, 33.90406], [-117.78488, 33.90416], [-117.78532, 33.90462], [-117.78541, 33.90474]]]} | Open Access 1 | 47381 | Quarterhorse Staging Area | 31104 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 3.406 | Quarterhorse Staging Area | None 425 | |||
5272 | 5272 | 5271 | {"type": "MultiPolygon", "coordinates": [[[[-117.78127, 33.89583], [-117.78072, 33.89766], [-117.78052, 33.89762], [-117.78091, 33.89661], [-117.78088, 33.89655], [-117.78049, 33.89621], [-117.78049, 33.89612], [-117.78089, 33.89611], [-117.78098, 33.89576], [-117.78127, 33.89583]]], [[[-117.78851, 33.89929], [-117.78656, 33.89912], [-117.78583, 33.8991], [-117.78574, 33.89903], [-117.78572, 33.89835], [-117.78684, 33.89835], [-117.78687, 33.89838], [-117.78695, 33.89851], [-117.78709, 33.89867], [-117.78728, 33.89878], [-117.78751, 33.89885], [-117.78775, 33.89887], [-117.78786, 33.89886], [-117.78801, 33.89883], [-117.78823, 33.89875], [-117.7883, 33.89875], [-117.78842, 33.8988], [-117.78846, 33.89886], [-117.78845, 33.8991], [-117.78849, 33.89919], [-117.78851, 33.89929]]]]} | Open Access 1 | 47383 | Lucia Kust Park | 31106 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 5.24 | Lucia Kust Park | 0 | Local Park 2 | 4 | |
5303 | 5303 | 5302 | {"type": "Polygon", "coordinates": [[[-117.76807, 33.90058], [-117.76805, 33.90172], [-117.76745, 33.90161], [-117.76653, 33.90194], [-117.76642, 33.90185], [-117.76624, 33.90176], [-117.7661, 33.90172], [-117.7659, 33.90171], [-117.76563, 33.90173], [-117.7652, 33.90185], [-117.76499, 33.90186], [-117.76471, 33.90183], [-117.76465, 33.90179], [-117.76466, 33.90151], [-117.76463, 33.90124], [-117.76433, 33.90031], [-117.76436, 33.90029], [-117.76471, 33.90019], [-117.76495, 33.90081], [-117.7652, 33.90081], [-117.76521, 33.90031], [-117.7654, 33.90052], [-117.76654, 33.90065], [-117.76689, 33.90065], [-117.76755, 33.90058], [-117.76807, 33.90058]]]} | Open Access 1 | 5777 | San Antonio Park | 24835 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 10.607 | San Antonio Park | 0 | Local Park 2 | 4 | |
5356 | 5356 | 5355 | {"type": "Polygon", "coordinates": [[[-117.80042, 33.89015], [-117.79835, 33.89014], [-117.7983, 33.88891], [-117.7984, 33.88883], [-117.80037, 33.88883], [-117.80042, 33.89015]]]} | Open Access 1 | 24630 | Jessamyn West Park | 20405 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 6.898 | Jessamyn West Park | 0 | Local Park 2 | 4 | |
5357 | 5357 | 5356 | {"type": "Polygon", "coordinates": [[[-117.7957, 33.87147], [-117.79535, 33.87176], [-117.79514, 33.87188], [-117.79406, 33.87241], [-117.79388, 33.87247], [-117.7938, 33.87221], [-117.79385, 33.87219], [-117.79387, 33.87176], [-117.79437, 33.8717], [-117.79459, 33.87144], [-117.79459, 33.87131], [-117.79516, 33.87131], [-117.7957, 33.87147]]]} | Open Access 1 | 24631 | Roland Bigonger Park | 24570 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 2.61 | Roland Bigonger Park | 0 | Local Park 2 | 4 | |
5358 | 5358 | 5357 | {"type": "Polygon", "coordinates": [[[-117.76123, 33.88455], [-117.76003, 33.88457], [-117.76003, 33.88439], [-117.75976, 33.88438], [-117.75977, 33.88407], [-117.75945, 33.88382], [-117.75828, 33.88381], [-117.75824, 33.88297], [-117.75902, 33.88303], [-117.75937, 33.88296], [-117.75966, 33.88264], [-117.75941, 33.88235], [-117.75956, 33.88227], [-117.75966, 33.88224], [-117.75991, 33.88219], [-117.76004, 33.88218], [-117.76019, 33.88218], [-117.76041, 33.88222], [-117.76057, 33.88229], [-117.76074, 33.88239], [-117.76099, 33.88258], [-117.76121, 33.88268], [-117.76122, 33.88271], [-117.76121, 33.88302], [-117.76123, 33.88455]]]} | Open Access 1 | 24632 | Travis Ranch Park | 26515 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 11.796 | Travis Ranch Park | 0 | Local Park 2 | 4 | |
6029 | 6029 | 6028 | {"type": "Polygon", "coordinates": [[[-117.80884, 33.88104], [-117.80739, 33.88209], [-117.80722, 33.88213], [-117.807, 33.88222], [-117.80693, 33.88222], [-117.80675, 33.88216], [-117.80693, 33.88149], [-117.80694, 33.8814], [-117.80691, 33.8813], [-117.80686, 33.88122], [-117.80678, 33.88115], [-117.80663, 33.88108], [-117.80691, 33.88065], [-117.80809, 33.88063], [-117.80862, 33.8807], [-117.80884, 33.88104]]]} | Open Access 1 | 47362 | Phillip S. Paxton Equestrian Center | 31085 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 5.418 | Phillip S. Paxton Equestrian Ctr. | 0 | Local Recreation Area 3 | 4 | |
6341 | 6341 | 6340 | {"type": "Polygon", "coordinates": [[[-117.84173, 33.89423], [-117.83972, 33.89424], [-117.83966, 33.89199], [-117.8408, 33.89197], [-117.84079, 33.89285], [-117.84024, 33.89286], [-117.84024, 33.89331], [-117.84092, 33.89332], [-117.84092, 33.89378], [-117.84123, 33.89378], [-117.84122, 33.89348], [-117.84171, 33.89348], [-117.84173, 33.89423]]]} | Restricted Access 2 | 47441 | Rose Drive Elementary School Recreational Facilities | 31157 | 2410 | Placentia-Yorba Linda Unified School District 833 | Special District 4 | School District 14 | http://www.pylusd.org/ | Special District 4 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 7.295 | Rose Drive Elementary School Recreational Facilities | 0 | Local Recreation Area 3 | 4 | |
7525 | 7525 | 7524 | {"type": "Polygon", "coordinates": [[[-117.78951, 33.897], [-117.78951, 33.89703], [-117.78906, 33.89703], [-117.78901, 33.8971], [-117.7886, 33.89748], [-117.78854, 33.89749], [-117.78841, 33.89747], [-117.7883, 33.89754], [-117.78819, 33.89755], [-117.78811, 33.89754], [-117.78792, 33.89757], [-117.78781, 33.89755], [-117.78775, 33.89748], [-117.78745, 33.89731], [-117.78725, 33.89726], [-117.787, 33.89721], [-117.78661, 33.8972], [-117.78636, 33.89713], [-117.78623, 33.89704], [-117.78613, 33.89701], [-117.78606, 33.89696], [-117.78618, 33.89673], [-117.78635, 33.89649], [-117.78655, 33.89626], [-117.78678, 33.89604], [-117.78703, 33.89585], [-117.7873, 33.89567], [-117.78785, 33.89538], [-117.78789, 33.89625], [-117.78889, 33.89625], [-117.78888, 33.89644], [-117.78889, 33.89655], [-117.78894, 33.89667], [-117.789, 33.89674], [-117.78919, 33.89691], [-117.78939, 33.89697], [-117.78951, 33.897]]]} | Open Access 1 | 47606 | Mustang Fields | 31336 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 9.247 | Mustang Fields | 2017 | Local Recreation Area 3 | 4 | |
7528 | 7528 | 7527 | {"type": "Polygon", "coordinates": [[[-117.81163, 33.90348], [-117.81127, 33.90335], [-117.81104, 33.90329], [-117.81069, 33.90324], [-117.8101, 33.90324], [-117.81004, 33.90322], [-117.81002, 33.90317], [-117.80999, 33.90318], [-117.80995, 33.90325], [-117.80988, 33.9033], [-117.80931, 33.90356], [-117.80928, 33.9036], [-117.80922, 33.90359], [-117.80926, 33.90352], [-117.80943, 33.90341], [-117.80943, 33.90339], [-117.8097, 33.90319], [-117.80979, 33.90305], [-117.80979, 33.90293], [-117.80973, 33.90281], [-117.80962, 33.90273], [-117.80944, 33.90265], [-117.80953, 33.9025], [-117.8095, 33.90244], [-117.8095, 33.90239], [-117.80973, 33.90208], [-117.80977, 33.902], [-117.80979, 33.90187], [-117.80974, 33.90172], [-117.81005, 33.9018], [-117.81038, 33.90185], [-117.81121, 33.90181], [-117.81124, 33.90227], [-117.8113, 33.90257], [-117.81127, 33.90259], [-117.81142, 33.90304], [-117.81163, 33.90348]]]} | Open Access 1 | 47607 | Vista Del Verde Park II | 31337 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 6.316 | Vista Del Verde Park II | None 626 | |||
12865 | 12865 | 12864 | {"type": "Polygon", "coordinates": [[[-117.76555, 33.88034], [-117.76461, 33.88017], [-117.76306, 33.88031], [-117.76281, 33.88041], [-117.76189, 33.87954], [-117.76233, 33.87972], [-117.76268, 33.87981], [-117.76335, 33.8799], [-117.76416, 33.87985], [-117.76458, 33.87971], [-117.76515, 33.87938], [-117.76551, 33.87923], [-117.76552, 33.87943], [-117.76549, 33.87972], [-117.76555, 33.88034]]]} | Open Access 1 | 30320 | Dominguez Trailside Park | 18198 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 4.344 | Dominguez Trailside Park | 0 | Local Park 2 | 4 | |
12871 | 12871 | 12870 | {"type": "Polygon", "coordinates": [[[-117.70288, 33.87817], [-117.70251, 33.87832], [-117.70206, 33.87863], [-117.70185, 33.87874], [-117.70172, 33.87879], [-117.70147, 33.87886], [-117.70108, 33.87889], [-117.70017, 33.87881], [-117.69987, 33.87873], [-117.69893, 33.87834], [-117.69873, 33.87829], [-117.69841, 33.87826], [-117.69839, 33.87801], [-117.69991, 33.8781], [-117.70086, 33.87811], [-117.70161, 33.87808], [-117.70218, 33.87803], [-117.70279, 33.87795], [-117.70288, 33.87817]]]} | Open Access 1 | 30315 | Brush Canyon Park | 16452 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 6.253 | Brush Canyon Park | 0 | Local Park 2 | 4 | |
12872 | 12872 | 12871 | {"type": "Polygon", "coordinates": [[[-117.71543, 33.88099], [-117.71522, 33.88101], [-117.71505, 33.88106], [-117.71493, 33.88115], [-117.71472, 33.88136], [-117.71458, 33.88166], [-117.71451, 33.88166], [-117.71445, 33.88123], [-117.71436, 33.88118], [-117.71431, 33.88117], [-117.71407, 33.88137], [-117.71396, 33.88129], [-117.71391, 33.88128], [-117.71385, 33.88129], [-117.7137, 33.8814], [-117.71361, 33.8814], [-117.71357, 33.88127], [-117.71346, 33.88116], [-117.71338, 33.88111], [-117.71335, 33.88102], [-117.71335, 33.88093], [-117.71337, 33.88087], [-117.71323, 33.88077], [-117.71345, 33.88066], [-117.71368, 33.88049], [-117.71381, 33.88039], [-117.714, 33.8802], [-117.71543, 33.88099]]]} | Open Access 1 | 30316 | Bryant Ranch Park | 16459 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 3.661 | Bryant Ranch Park | 0 | Local Park 2 | 4 | |
12873 | 12873 | 12872 | {"type": "Polygon", "coordinates": [[[-117.72843, 33.88586], [-117.72826, 33.88624], [-117.72779, 33.88617], [-117.72761, 33.8864], [-117.72743, 33.88638], [-117.7273, 33.88689], [-117.7271, 33.88749], [-117.72611, 33.88751], [-117.727, 33.88512], [-117.72779, 33.88526], [-117.72824, 33.88528], [-117.72829, 33.88532], [-117.72831, 33.88558], [-117.72835, 33.88572], [-117.72843, 33.88586]]]} | Open Access 1 | 30317 | Box Canyon Park | 16313 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 7.091 | Box Canyon Park | 0 | Local Park 2 | 4 | |
12874 | 12874 | 12873 | {"type": "Polygon", "coordinates": [[[-117.75005, 33.87785], [-117.74989, 33.87934], [-117.74912, 33.88554], [-117.74839, 33.88686], [-117.74802, 33.88679], [-117.74801, 33.88677], [-117.74797, 33.88676], [-117.74775, 33.88679], [-117.74591, 33.88666], [-117.74591, 33.88628], [-117.74601, 33.88553], [-117.74597, 33.88517], [-117.74588, 33.88488], [-117.7459, 33.88373], [-117.74699, 33.88334], [-117.74711, 33.88264], [-117.74716, 33.88247], [-117.74735, 33.8821], [-117.74736, 33.88214], [-117.74739, 33.88218], [-117.74746, 33.8822], [-117.74761, 33.88219], [-117.74778, 33.88213], [-117.74796, 33.88203], [-117.74809, 33.8819], [-117.74816, 33.88181], [-117.74828, 33.88162], [-117.74848, 33.88126], [-117.74858, 33.88093], [-117.74887, 33.87857], [-117.74889, 33.87839], [-117.74887, 33.87835], [-117.74895, 33.87822], [-117.74904, 33.87815], [-117.74927, 33.87802], [-117.74953, 33.87791], [-117.74981, 33.87786], [-117.75005, 33.87785]]]} | Open Access 1 | 30318 | East Side Community Park | 18382 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 46.316 | East Side Community Park | 0 | Local Park 2 | 4 | |
12875 | 12875 | 12874 | {"type": "Polygon", "coordinates": [[[-117.75023, 33.88204], [-117.7501, 33.88221], [-117.74999, 33.88239], [-117.74953, 33.88226], [-117.74969, 33.88091], [-117.74971, 33.88107], [-117.75, 33.8819], [-117.75023, 33.88204]]]} | Open Access 1 | 30319 | Jean Woodard Park | 20374 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 1.117 | Jean Woodard Park | 0 | Local Park 2 | 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]);