units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
119 rows where MNG_AGENCY = 7 and MNG_AG_TYP = 3 sorted by DES_TP descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, YR_EST, GAP_STS
DES_TP 19
- Local Park 40
- Local Other or Unknown 39
- Local Recreation Area 19
- Local Conservation Area 5
- Local Historic or Cultural Area 2
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
- Open Access 105
- Unknown Access 13
- No Public Access 1
MNG_AG_TYP 1
- County Agency · 119 ✖
MNG_AGENCY 1
- Santa Barbara, County of · 119 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13276 | 13276 | 13275 | {"type": "Polygon", "coordinates": [[[-120.63883, 34.95912], [-120.63659, 34.95879], [-120.63662, 34.9577], [-120.6378, 34.9583], [-120.63834, 34.95875], [-120.63883, 34.95912]]]} | Open Access 1 | 45324 | Rancho Guadalupe Dunes | 24146 | 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 | 3.499 | Rancho Guadalupe Dunes | None 1151 | |||
10534 | 10534 | 10533 | {"type": "Polygon", "coordinates": [[[-120.64412, 34.90026], [-120.64204, 34.90058], [-120.64173, 34.89828], [-120.64219, 34.8982], [-120.64204, 34.89799], [-120.64215, 34.89777], [-120.64198, 34.89745], [-120.64183, 34.89732], [-120.64137, 34.89716], [-120.64138, 34.89665], [-120.6409, 34.8964], [-120.64063, 34.89541], [-120.64012, 34.89522], [-120.64029, 34.89485], [-120.63925, 34.89369], [-120.6401, 34.89205], [-120.64001, 34.89015], [-120.64053, 34.89152], [-120.6419, 34.89213], [-120.64356, 34.8994], [-120.64411, 34.89945], [-120.64412, 34.90026]]]} | Open Access 1 | 18744 | Point Sal | 30308 | 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 | http://cosb.countyofsb.org/parks/parks03.aspx?id=13402 | Santa Barbara 7 | 44.382 | Point Sal | None 923 | ||
10076 | 10076 | 10075 | {"type": "Polygon", "coordinates": [[[-119.88428, 34.43726], [-119.88429, 34.43764], [-119.88422, 34.43784], [-119.8841, 34.4383], [-119.8841, 34.43883], [-119.88322, 34.43885], [-119.88319, 34.43884], [-119.88317, 34.43881], [-119.88317, 34.43831], [-119.88319, 34.43814], [-119.88326, 34.4379], [-119.8834, 34.43768], [-119.88348, 34.4375], [-119.88353, 34.4373], [-119.88357, 34.43727], [-119.88428, 34.43726]]]} | Open Access 1 | 17722 | Bella Vista I & II | 15977 | 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 | 3.564 | Bella Vista I & II | None 871 | |||
9763 | 9763 | 9762 | {"type": "Polygon", "coordinates": [[[-119.63709, 34.41583], [-119.63704, 34.41641], [-119.63642, 34.41654], [-119.63646, 34.41695], [-119.63641, 34.41723], [-119.63631, 34.41757], [-119.63611, 34.41758], [-119.63581, 34.41763], [-119.63571, 34.41761], [-119.63562, 34.41754], [-119.6355, 34.41737], [-119.6354, 34.4173], [-119.63519, 34.41724], [-119.63496, 34.41724], [-119.63486, 34.41687], [-119.6343, 34.41698], [-119.6338, 34.41711], [-119.63385, 34.41696], [-119.63423, 34.41679], [-119.63501, 34.41663], [-119.63563, 34.41644], [-119.63623, 34.4162], [-119.6365, 34.41604], [-119.63678, 34.4159], [-119.63709, 34.41583]]]} | Unknown Access 4 | 16729 | Hammond's Meadow | 19627 | 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 | 5.367 | Hammond's Meadow | 0 | None 843 | ||
6484 | 6484 | 6483 | {"type": "Polygon", "coordinates": [[[-119.89231, 34.42456], [-119.89194, 34.42456], [-119.89112, 34.4248], [-119.89092, 34.42448], [-119.89071, 34.42428], [-119.8899, 34.42429], [-119.89004, 34.4238], [-119.89106, 34.42379], [-119.89102, 34.42384], [-119.89106, 34.42414], [-119.89131, 34.42436], [-119.89168, 34.4244], [-119.89195, 34.42437], [-119.8923, 34.42437], [-119.89231, 34.42456]]]} | Open Access 1 | 2366 | Campus Glen | 16786 | 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 | 2.424 | Campus Glen | None 523 | |||
5986 | 5986 | 5985 | {"type": "Polygon", "coordinates": [[[-120.1236, 34.60253], [-120.12359, 34.60288], [-120.12353, 34.60288], [-120.12353, 34.60258], [-120.12298, 34.60278], [-120.12308, 34.60299], [-120.12289, 34.60309], [-120.12231, 34.60349], [-120.12213, 34.60366], [-120.12199, 34.60387], [-120.12138, 34.60522], [-120.12135, 34.60537], [-120.12135, 34.60551], [-120.12041, 34.60677], [-120.12006, 34.60677], [-120.1204, 34.60648], [-120.12062, 34.60616], [-120.12062, 34.60585], [-120.12072, 34.60567], [-120.12064, 34.60526], [-120.12075, 34.60503], [-120.12119, 34.60489], [-120.12117, 34.60452], [-120.12148, 34.60432], [-120.12159, 34.60385], [-120.1212, 34.60323], [-120.12158, 34.60313], [-120.12283, 34.60232], [-120.12284, 34.60236], [-120.12279, 34.60252], [-120.1228, 34.60253], [-120.1236, 34.60253]]]} | Open Access 1 | 587 | Alamo Pintado Creek (Solvang area) | 15320 | 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 | 6.784 | Alamo Pintado Creek (Solvang area) | None 481 | |||
5981 | 5981 | 5980 | {"type": "MultiPolygon", "coordinates": [[[[-120.57149, 34.97539], [-120.57144, 34.97556], [-120.57136, 34.97569], [-120.57125, 34.97578], [-120.57111, 34.97585], [-120.57117, 34.97538], [-120.57149, 34.97539]]], [[[-120.57027, 34.97531], [-120.57026, 34.97583], [-120.56846, 34.97601], [-120.56811, 34.97606], [-120.56776, 34.97608], [-120.56742, 34.97607], [-120.56707, 34.97602], [-120.56673, 34.97595], [-120.56573, 34.97567], [-120.5635, 34.97513], [-120.56095, 34.97464], [-120.55788, 34.97431], [-120.55621, 34.97422], [-120.55444, 34.97367], [-120.55789, 34.97375], [-120.5579, 34.97386], [-120.56036, 34.9741], [-120.56361, 34.97468], [-120.56368, 34.97454], [-120.56401, 34.97461], [-120.56396, 34.97476], [-120.56397, 34.97477], [-120.56707, 34.97552], [-120.56736, 34.97556], [-120.56766, 34.97558], [-120.56797, 34.97557], [-120.57027, 34.97531]]], [[[-120.55274, 34.97282], [-120.55227, 34.97363], [-120.54431, 34.97442], [-120.54358, 34.97544], [-120.54006, 34.97599], [-120.51284, 34.98081], [-120.51265, 34.97972], [-120.51277, 34.97971], [-120.51284, 34.98009], [-120.513, 34.98022], [-120.53916, 34.97546], [-120.53998, 34.97431], [-120.54702, 34.97309], [-120.55274, 34.97282]]], [[[-120.53866, 34.98161], [-120.53788, 34.98229], [-120.51433, 34.98672], [-120.51413, 34.98716], [-120.51421, 34.98764], [-120.51408, 34.98765], [-120.51384, 34.9863], [-120.53866, 34.98161]]], [[[-120.47587, 34.98734], [-120.47586, 34.98785], [-120.4659, 34.98969], [-120.46394, 34.98997], [-120.46217, 34.99011], [-120.45826, 34.98975], [-120.45272, 34.98952], [-120.45272, 34.98923], [-120.453, 34.98925], [-120.45301, 34.98943], [-120.45678, 34.98961], [-120.45761, 34.98969], [-120.45762, 34.98963], [-120.45999, 34.98971], [-120.46285, 34.98957], [-120.46286, 34.98949], [-120.46302, 34.98948], [-120.46302, 34.98954], [-120.46364, 34.98949], [-120.46588, 34.98917], [-120.47587, 34.98734]]], [[[-120.47967, 34.98664], [-120.47965, 34.99181], [-120.47784, 34.99165], [-120.47789, 34.98694], [-120.47967, 34.98664]]], [[[-120.51386, 34.98767], [-120.51376, 34.98768], [-120.51368, 34.98716], [-120.51331, 34.98688], [-120.51188, 34.98728], [-120.50779, 34.9882], [-120.50391, 34.98892], [-120.4877, 34.99201], [-120.48536, 34.99237], [-120.48337, 34.99218], [-120.48345, 34.98595], [-120.4854, 34.98558], [-120.48776, 34.98517], [-120.48777, 34.98558], [-120.4877, 34.99145], [-120.48771, 34.99146], [-120.51138, 34.98689], [-120.51362, 34.98635], [-120.51386, 34.98767]]]]} | Open Access 1 | 574 | Santa Maria River | 11840 | 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 | 285.306 | Santa Maria River | 0 | None 480 | ||
5597 | 5597 | 5596 | {"type": "Polygon", "coordinates": [[[-120.49458, 34.67098], [-120.49431, 34.67124], [-120.49306, 34.67174], [-120.493, 34.6711], [-120.49457, 34.67081], [-120.49458, 34.67098]]]} | Unknown Access 4 | 631 | Santa Ynez River | 25145 | 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 | 1.884 | Santa Ynez River | None 451 | |||
4845 | 4845 | 4844 | {"type": "Polygon", "coordinates": [[[-119.84133, 34.45093], [-119.84062, 34.45098], [-119.84059, 34.45044], [-119.84067, 34.45043], [-119.84073, 34.45041], [-119.84077, 34.45036], [-119.84079, 34.4503], [-119.84075, 34.4497], [-119.84072, 34.44964], [-119.84067, 34.4496], [-119.84055, 34.44958], [-119.84054, 34.44941], [-119.84028, 34.44897], [-119.84057, 34.44897], [-119.84115, 34.44969], [-119.84132, 34.44997], [-119.84133, 34.45093]]]} | Open Access 1 | 1110 | Stonebridge | 25878 | 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 | 2.613 | Stonebridge | None 406 | |||
3753 | 3753 | 3752 | {"type": "Polygon", "coordinates": [[[-119.69543, 34.43397], [-119.69509, 34.43541], [-119.69424, 34.43536], [-119.69419, 34.43629], [-119.69257, 34.4363], [-119.69256, 34.43377], [-119.69278, 34.4335], [-119.6928, 34.43343], [-119.69302, 34.43324], [-119.69368, 34.43246], [-119.69391, 34.43263], [-119.69364, 34.43294], [-119.69351, 34.43319], [-119.69331, 34.43328], [-119.69335, 34.43335], [-119.69344, 34.43332], [-119.69346, 34.43333], [-119.69364, 34.43368], [-119.69373, 34.43372], [-119.69382, 34.43371], [-119.69382, 34.43374], [-119.69527, 34.43376], [-119.69515, 34.43396], [-119.69543, 34.43397]]]} | Unknown Access 4 | 467 | Santa Barbara Bowl | 25038 | 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 | 16.55 | Santa Barbara Bowl | None 315 | |||
2535 | 2535 | 2534 | {"type": "Polygon", "coordinates": [[[-119.88382, 34.43947], [-119.88316, 34.43948], [-119.88316, 34.43906], [-119.88317, 34.43903], [-119.8832, 34.43902], [-119.88379, 34.43902], [-119.88381, 34.43905], [-119.88382, 34.43947]]]} | Open Access 1 | 17758 | Bella Vista III | 15978 | 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.76 | Bella Vista III | None 208 | |||
2071 | 2071 | 2070 | {"type": "MultiPolygon", "coordinates": [[[[-119.89262, 34.43884], [-119.89269, 34.43916], [-119.89271, 34.4395], [-119.8927, 34.43963], [-119.89265, 34.43988], [-119.89261, 34.4399], [-119.89232, 34.4398], [-119.89214, 34.43966], [-119.89204, 34.43955], [-119.89163, 34.43896], [-119.89154, 34.43885], [-119.89133, 34.43865], [-119.89101, 34.43845], [-119.89073, 34.43834], [-119.89043, 34.43827], [-119.89028, 34.43826], [-119.88921, 34.43829], [-119.88894, 34.43834], [-119.88879, 34.4384], [-119.88854, 34.43802], [-119.88821, 34.43768], [-119.88786, 34.43766], [-119.88737, 34.43779], [-119.8877, 34.43814], [-119.88789, 34.4383], [-119.88793, 34.43836], [-119.888, 34.43839], [-119.8881, 34.4384], [-119.88817, 34.43844], [-119.88764, 34.43883], [-119.88746, 34.43904], [-119.88774, 34.43919], [-119.88766, 34.43931], [-119.88757, 34.43951], [-119.88754, 34.43952], [-119.88704, 34.43953], [-119.88708, 34.4393], [-119.88708, 34.43889], [-119.8874, 34.43825], [-119.88673, 34.43805], [-119.88627, 34.43734], [-119.88582, 34.43694], [-119.88519, 34.43694], [-119.88516, 34.43552], [-119.88529, 34.43552], [-119.88647, 34.43593], [-119.88718, 34.43652], [-119.89012, 34.43693], [-119.89012, 34.43702], [-119.88961, 34.437], [-119.88989, 34.43746], [-119.89066, 34.43751], [-119.89169, 34.43778], [-119.89209, 34.4381], [-119.8921, 34.43842], [-119.89218, 34.43853], [-119.8923, 34.43889], [-119.89262, 34.43884]]], [[[-119.88793, 34.44143], [-119.88788, 34.44135], [-119.88786, 34.44123], [-119.88781, 34.44124], [-119.88781, 34.44143], [-119.88746, 34.44144], [-119.88744, 34.44058], [-119.88687, 34.44047], [-119.88701, 34.43969], [-119.88749, 34.43967], [-119.88754, 34.4397], [-119.88757, 34.43995], [-119.88763, 34.44013], [-119.88767, 34.44021], [-119.88793, 34.44059], [-119.88803, 34.44081], [-119.88807, 34.44093], [-119.88815, 34.4414], [-119.88811, 34.44143], [-119.88793, 34.44143]]]]} | Open Access 1 | 15735 | Evergreen Acres | 18765 | 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 | 28.758 | Evergreen Acres | None 163 | |||
1400 | 1400 | 1399 | {"type": "Polygon", "coordinates": [[[-119.87288, 34.43682], [-119.8723, 34.43682], [-119.87211, 34.43667], [-119.872, 34.43654], [-119.87193, 34.43639], [-119.8719, 34.43628], [-119.87195, 34.43605], [-119.87205, 34.43605], [-119.87221, 34.43614], [-119.87248, 34.4365], [-119.87277, 34.43651], [-119.87288, 34.43682]]]} | Open Access 1 | 16492 | Glen Annie at Del Norte | 19314 | 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.987 | Glen Annie at Del Norte | None 119 | |||
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 | |
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 | |
133 | 133 | 132 | {"type": "Polygon", "coordinates": [[[-119.74246, 34.44054], [-119.74244, 34.44072], [-119.74241, 34.44073], [-119.74215, 34.44091], [-119.74194, 34.44113], [-119.74168, 34.44129], [-119.74157, 34.44128], [-119.7414, 34.44128], [-119.74181, 34.44101], [-119.74204, 34.44079], [-119.74227, 34.44062], [-119.74234, 34.44054], [-119.74246, 34.44054]]]} | Unknown Access 4 | 414 | San Roque Creek | 24990 | 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.477 | San Roque Creek | 0 | Local Other or Unknown 14 | 4 | |
4567 | 4567 | 4566 | {"type": "Polygon", "coordinates": [[[-119.71084, 34.46312], [-119.71071, 34.46336], [-119.70994, 34.46337], [-119.70995, 34.46314], [-119.71084, 34.46312]]]} | Open Access 1 | 35211 | Unnamed site - Santa Barbara, County of | 28662 | 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.489 | 0 | Local Other or Unknown 14 | 4 | ||
4568 | 4568 | 4567 | {"type": "Polygon", "coordinates": [[[-119.62321, 34.44984], [-119.62318, 34.45014], [-119.62286, 34.45046], [-119.62231, 34.45075], [-119.62214, 34.45112], [-119.62197, 34.45112], [-119.62196, 34.45078], [-119.6221, 34.45066], [-119.62217, 34.45053], [-119.62231, 34.44987], [-119.62232, 34.44975], [-119.6223, 34.44957], [-119.62216, 34.44918], [-119.62211, 34.44896], [-119.6221, 34.44883], [-119.62209, 34.44827], [-119.62239, 34.44829], [-119.62238, 34.44846], [-119.62223, 34.44862], [-119.62265, 34.44905], [-119.62283, 34.44907], [-119.62296, 34.44939], [-119.62321, 34.44984]]]} | Open Access 1 | 35212 | Unnamed site - Santa Barbara, County of | 28662 | 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 | 4.011 | 0 | Local Other or Unknown 14 | 4 | ||
4574 | 4574 | 4573 | {"type": "Polygon", "coordinates": [[[-120.41847, 34.87892], [-120.41847, 34.87914], [-120.41845, 34.87917], [-120.41794, 34.87923], [-120.41794, 34.87885], [-120.418, 34.87884], [-120.41807, 34.8788], [-120.41847, 34.87892]]]} | No Public Access 3 | 35227 | Unnamed site - Santa Barbara, County of | 28691 | 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.465 | 0 | Local Other or Unknown 14 | 4 | ||
4575 | 4575 | 4574 | {"type": "Polygon", "coordinates": [[[-120.41196, 34.87233], [-120.40988, 34.87235], [-120.40988, 34.87167], [-120.41063, 34.87167], [-120.41063, 34.87165], [-120.41048, 34.87139], [-120.41055, 34.87137], [-120.41071, 34.87164], [-120.41102, 34.87133], [-120.4118, 34.87166], [-120.41179, 34.87207], [-120.41196, 34.87233]]]} | Open Access 1 | 35235 | Unnamed site - Santa Barbara, County of | 28662 | 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 | 3.807 | 0 | Local Other or Unknown 14 | 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]);