units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where MNG_AGENCY = 534 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, GAP_STS
DES_TP 10
- Local Park 192
- Local Recreation Area 18
- Local Conservation Area 3
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 220
MNG_AGENCY 1
- Sacramento, City of · 220 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16367 | 16367 | 16366 | {"type": "MultiPolygon", "coordinates": [[[[-121.38138, 38.63987], [-121.38132, 38.64069], [-121.38048, 38.64048], [-121.3791, 38.64071], [-121.37843, 38.6411], [-121.37685, 38.64253], [-121.37584, 38.64298], [-121.37292, 38.64406], [-121.37237, 38.6445], [-121.37201, 38.6446], [-121.37165, 38.64452], [-121.37031, 38.64352], [-121.36696, 38.64393], [-121.36672, 38.64436], [-121.36645, 38.64449], [-121.36556, 38.64378], [-121.36557, 38.6436], [-121.36622, 38.64308], [-121.36644, 38.64294], [-121.36673, 38.64278], [-121.36723, 38.64256], [-121.36848, 38.64217], [-121.37178, 38.6412], [-121.37542, 38.64008], [-121.37779, 38.63927], [-121.38036, 38.6383], [-121.38138, 38.63987]]], [[[-121.40097, 38.63756], [-121.39996, 38.63792], [-121.39972, 38.63804], [-121.39941, 38.63824], [-121.39796, 38.63953], [-121.3966, 38.64082], [-121.39624, 38.64114], [-121.39557, 38.64167], [-121.39525, 38.64189], [-121.39447, 38.64233], [-121.39261, 38.64273], [-121.39227, 38.64182], [-121.39188, 38.64199], [-121.38973, 38.64316], [-121.38949, 38.64327], [-121.38921, 38.64338], [-121.38891, 38.64345], [-121.38835, 38.64354], [-121.38809, 38.64356], [-121.38806, 38.64359], [-121.38804, 38.64364], [-121.38779, 38.64362], [-121.38775, 38.6436], [-121.38738, 38.64354], [-121.38634, 38.64328], [-121.3862, 38.64322], [-121.38598, 38.6431], [-121.38591, 38.6431], [-121.38571, 38.64299], [-121.38567, 38.64295], [-121.38518, 38.64265], [-121.38486, 38.64252], [-121.38465, 38.64248], [-121.3842, 38.64244], [-121.3834, 38.64232], [-121.38341, 38.64166], [-121.38358, 38.64163], [-121.38363, 38.64095], [-121.38412, 38.63958], [-121.3842, 38.6394], [-121.38434, 38.63921], [-121.38487, 38.63866], [-121.38657, 38.63709], [-121.38786, 38.63673], [-121.38866, 38.63728], [-121.38859, 38.63753], [-121.38821, 38.6379], [-121.38805, 38.63812], [-121.38811, 38.63825], [-121.38824, 38.63837], [-121.38852, 38.63877], [-121.38849, 38.639], [-121.38839, 38.63929], [-121.388, 38.63972], [-121.38775, 38.63982], [-121.3875, 38.63999], [-121.38746, 38.64011], [-121.38749, 38.64026], [-121.38759, 38.64039], [-121.38784, 38.64051], [-121.38838, 38.64059], [-121.38942, 38.64064], [-121.38974, 38.64072], [-121.39015, 38.64075], [-121.39082, 38.64075], [-121.39146, 38.6407], [-121.39199, 38.64066], [-121.39247, 38.64056], [-121.39308, 38.64054], [-121.39444, 38.64055], [-121.39482, 38.6405], [-121.39524, 38.64033], [-121.39606, 38.64003], [-121.39645, 38.63969], [-121.39689, 38.63946], [-121.39721, 38.63917], [-121.3975, 38.63872], [-121.39804, 38.6384], [-121.39897, 38.63771], [-121.39945, 38.63746], [-121.39986, 38.63736], [-121.4004, 38.63744], [-121.40097, 38.63756]]]]} | Open Access 1 | 21262 | Del Paso Regional Park | 18046 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 188.665 | Del Paso RP | 0 | Local Park 2 | 4 | |
5669 | 5669 | 5668 | {"type": "MultiPolygon", "coordinates": [[[[-121.39146, 38.55714], [-121.39076, 38.55721], [-121.39064, 38.55522], [-121.39032, 38.55522], [-121.38874, 38.55538], [-121.38866, 38.55491], [-121.38868, 38.55472], [-121.38862, 38.55445], [-121.38924, 38.55437], [-121.38979, 38.55436], [-121.38998, 38.55437], [-121.39001, 38.5544], [-121.39002, 38.55448], [-121.3902, 38.55448], [-121.39021, 38.55439], [-121.39026, 38.55436], [-121.39103, 38.55434], [-121.39128, 38.55431], [-121.39146, 38.55714]]], [[[-121.39125, 38.55376], [-121.39098, 38.55378], [-121.391, 38.55418], [-121.39057, 38.55419], [-121.39041, 38.55143], [-121.38987, 38.55054], [-121.39086, 38.55056], [-121.39086, 38.55089], [-121.39111, 38.55127], [-121.39125, 38.55376]]]]} | Open Access 1 | 21154 | Magoichi Oki Park | 21685 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 15.066 | Magoichi Oki Park | 0 | Local Park 2 | 4 | |
3909 | 3909 | 3908 | {"type": "MultiPolygon", "coordinates": [[[[-121.40358, 38.44966], [-121.40323, 38.44988], [-121.40321, 38.44992], [-121.40314, 38.44992], [-121.40308, 38.44995], [-121.40305, 38.44999], [-121.40304, 38.45003], [-121.40298, 38.45003], [-121.40187, 38.45093], [-121.40186, 38.45097], [-121.40176, 38.45101], [-121.40172, 38.45108], [-121.40166, 38.45109], [-121.40142, 38.45128], [-121.4011, 38.45103], [-121.40134, 38.45084], [-121.40134, 38.45079], [-121.40144, 38.45076], [-121.40147, 38.45072], [-121.40148, 38.45068], [-121.40154, 38.45068], [-121.40272, 38.44975], [-121.40272, 38.4497], [-121.40282, 38.44966], [-121.40285, 38.44962], [-121.40286, 38.44959], [-121.40291, 38.44958], [-121.40325, 38.44934], [-121.40358, 38.44966]]], [[[-121.40435, 38.44886], [-121.4041, 38.44915], [-121.40398, 38.44968], [-121.40393, 38.4497], [-121.4036, 38.44935], [-121.40317, 38.44901], [-121.40321, 38.44897], [-121.4038, 38.44891], [-121.40417, 38.44871], [-121.40435, 38.44886]]]]} | Open Access 1 | 36023 | Fales Park | 18829 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.798 | Fales Park | 0 | Local Park 2 | 4 | |
5666 | 5666 | 5665 | {"type": "MultiPolygon", "coordinates": [[[[-121.40892, 38.56163], [-121.4089, 38.5621], [-121.40883, 38.56227], [-121.40819, 38.56243], [-121.40787, 38.5625], [-121.40788, 38.56186], [-121.40892, 38.56163]]], [[[-121.40901, 38.56247], [-121.40895, 38.5634], [-121.4079, 38.56338], [-121.40793, 38.56264], [-121.40833, 38.56256], [-121.40901, 38.56247]]]]} | Open Access 1 | 21150 | University Park | 26687 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.716 | University Park | 0 | Local Park 2 | 4 | |
11026 | 11026 | 11025 | {"type": "MultiPolygon", "coordinates": [[[[-121.41422, 38.53219], [-121.41307, 38.5322], [-121.41293, 38.53216], [-121.41289, 38.53211], [-121.41292, 38.53205], [-121.41299, 38.53202], [-121.41418, 38.53201], [-121.41422, 38.53203], [-121.41423, 38.53216], [-121.41422, 38.53219]]], [[[-121.41671, 38.53219], [-121.41443, 38.53219], [-121.41441, 38.53218], [-121.41439, 38.53203], [-121.41442, 38.53202], [-121.41666, 38.53202], [-121.4167, 38.53204], [-121.41671, 38.53219]]], [[[-121.41912, 38.53205], [-121.41898, 38.53229], [-121.4189, 38.53231], [-121.41792, 38.53231], [-121.4169, 38.5322], [-121.41688, 38.53218], [-121.41688, 38.53204], [-121.41691, 38.53202], [-121.41909, 38.53202], [-121.41912, 38.53205]]], [[[-121.42107, 38.53205], [-121.42106, 38.53229], [-121.42104, 38.53231], [-121.41918, 38.5323], [-121.41933, 38.53204], [-121.41937, 38.53202], [-121.42105, 38.53202], [-121.42107, 38.53205]]], [[[-121.42604, 38.53216], [-121.42604, 38.53227], [-121.42601, 38.53228], [-121.42297, 38.53227], [-121.42248, 38.53232], [-121.42127, 38.53231], [-121.42124, 38.53229], [-121.42125, 38.53205], [-121.42128, 38.53203], [-121.42312, 38.53203], [-121.42419, 38.53215], [-121.42604, 38.53216]]], [[[-121.42712, 38.53223], [-121.42711, 38.53225], [-121.42691, 38.53224], [-121.42678, 38.53228], [-121.42624, 38.53228], [-121.42622, 38.53227], [-121.42623, 38.53217], [-121.42624, 38.53215], [-121.42663, 38.53217], [-121.42712, 38.53223]]], [[[-121.4294, 38.53226], [-121.42938, 38.53227], [-121.42797, 38.53227], [-121.42796, 38.53226], [-121.42797, 38.53225], [-121.42818, 38.53225], [-121.4284, 38.53221], [-121.42899, 38.53215], [-121.42939, 38.53214], [-121.4294, 38.53226]]], [[[-121.43268, 38.53204], [-121.43268, 38.53227], [-121.43264, 38.5323], [-121.43224, 38.5323], [-121.43202, 38.53227], [-121.4296, 38.53227], [-121.42959, 38.53226], [-121.42959, 38.53215], [-121.42962, 38.53214], [-121.43036, 38.53214], [-121.43129, 38.53203], [-121.43265, 38.53202], [-121.43268, 38.53204]]], [[[-121.43516, 38.5322], [-121.43456, 38.53227], [-121.43288, 38.5323], [-121.43286, 38.53229], [-121.43286, 38.53204], [-121.43289, 38.53201], [-121.43512, 38.53199], [-121.43515, 38.53201], [-121.43518, 38.53217], [-121.43516, 38.5322]]], [[[-121.43863, 38.53196], [-121.43864, 38.53198], [-121.43853, 38.53212], [-121.43848, 38.53213], [-121.43566, 38.53216], [-121.4354, 38.53219], [-121.43537, 38.53217], [-121.43533, 38.53201], [-121.43535, 38.53198], [-121.43863, 38.53196]]], [[[-121.44204, 38.53208], [-121.44201, 38.53209], [-121.43875, 38.53213], [-121.43874, 38.53211], [-121.43884, 38.53197], [-121.43888, 38.53195], [-121.44129, 38.53192], [-121.44158, 38.53195], [-121.44202, 38.53194], [-121.44204, 38.53195], [-121.44204, 38.53208]]], [[[-121.44318, 38.53193], [-121.44319, 38.53196], [-121.44319, 38.53205], [-121.44317, 38.53206], [-121.44224, 38.53209], [-121.44222, 38.53208], [-121.44222, 38.53196], [-121.44224, 38.53194], [-121.44318, 38.53193]]], [[[-121.44435, 38.53195], [-121.44434, 38.53204], [-121.44432, 38.53206], [-121.44339, 38.53206], [-121.44337, 38.53204], [-121.44338, 38.53195], [-121.4434, 38.53194], [-121.44435, 38.53195]]], [[[-121.44543, 38.53192], [-121.44542, 38.53194], [-121.4452, 38.53199], [-121.4449, 38.53204], [-121.44455, 38.53206], [-121.44453, 38.53203], [-121.44453, 38.53195], [-121.44456, 38.53193], [-121.44543, 38.53192]]]]} | Open Access 1 | 21183 | 21st Avenue Parkway | 15182 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 13.339 | 21st Avenue Parkway | 0 | Local Recreation Area 3 | 4 | |
5675 | 5675 | 5674 | {"type": "MultiPolygon", "coordinates": [[[[-121.43379, 38.54469], [-121.43375, 38.54471], [-121.43354, 38.54472], [-121.43351, 38.54233], [-121.43398, 38.54232], [-121.43402, 38.54235], [-121.43402, 38.54243], [-121.434, 38.5425], [-121.43394, 38.54259], [-121.43371, 38.5428], [-121.43363, 38.54293], [-121.43359, 38.54305], [-121.43357, 38.54317], [-121.43358, 38.5443], [-121.43362, 38.54439], [-121.43377, 38.54461], [-121.43379, 38.54469]]], [[[-121.43418, 38.54232], [-121.4368, 38.54229], [-121.43685, 38.54231], [-121.43685, 38.54466], [-121.43681, 38.54469], [-121.43402, 38.54471], [-121.43393, 38.54468], [-121.43387, 38.54451], [-121.43381, 38.54442], [-121.43385, 38.54438], [-121.43381, 38.5443], [-121.4338, 38.54423], [-121.4338, 38.54331], [-121.43369, 38.5433], [-121.4337, 38.54312], [-121.43374, 38.54299], [-121.4338, 38.54287], [-121.43387, 38.54278], [-121.43403, 38.54264], [-121.43409, 38.54257], [-121.43418, 38.54232]]]]} | Open Access 1 | 21172 | Tahoe Park | 26167 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 18.006 | Tahoe Park | 0 | Local Park 2 | 4 | |
10996 | 10996 | 10995 | {"type": "MultiPolygon", "coordinates": [[[[-121.44157, 38.63372], [-121.44112, 38.63372], [-121.44112, 38.63475], [-121.44009, 38.63474], [-121.4401, 38.63351], [-121.44112, 38.63351], [-121.44113, 38.6331], [-121.44157, 38.6331], [-121.44157, 38.63372]]], [[[-121.44223, 38.6338], [-121.44223, 38.63476], [-121.44176, 38.63476], [-121.44175, 38.63375], [-121.44179, 38.6338], [-121.44223, 38.6338]]]]} | Open Access 1 | 21064 | Mama Marks Park | 21715 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 4.786 | Mama Marks Park | 0 | Local Park 2 | 4 | |
11708 | 11708 | 11707 | {"type": "MultiPolygon", "coordinates": [[[[-121.44531, 38.55478], [-121.44524, 38.55494], [-121.44395, 38.55458], [-121.44361, 38.55445], [-121.44357, 38.55443], [-121.44355, 38.55439], [-121.44357, 38.55436], [-121.44361, 38.55436], [-121.44391, 38.5544], [-121.44531, 38.55478]]], [[[-121.44712, 38.55534], [-121.44711, 38.55537], [-121.44708, 38.55539], [-121.44675, 38.55535], [-121.4454, 38.55498], [-121.44547, 38.55483], [-121.44679, 38.55519], [-121.44703, 38.55528], [-121.4471, 38.55531], [-121.44712, 38.55534]]]]} | Open Access 1 | 24005 | Sierra Vista Park | 25469 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.305 | Sierra Vista Park | 0 | Local Park 2 | 4 | |
13644 | 13644 | 13643 | {"type": "MultiPolygon", "coordinates": [[[[-121.44956, 38.5861], [-121.44954, 38.5864], [-121.44955, 38.58802], [-121.44936, 38.58792], [-121.4492, 38.58787], [-121.44913, 38.58782], [-121.44894, 38.58773], [-121.44885, 38.58766], [-121.4487, 38.58762], [-121.44846, 38.58746], [-121.4483, 38.5874], [-121.44784, 38.58717], [-121.4482, 38.58685], [-121.44865, 38.58653], [-121.44913, 38.58628], [-121.44956, 38.5861]]], [[[-121.46355, 38.58344], [-121.46215, 38.58683], [-121.46184, 38.58692], [-121.46141, 38.58712], [-121.46114, 38.58726], [-121.46079, 38.58738], [-121.46041, 38.58758], [-121.46024, 38.58765], [-121.45999, 38.58773], [-121.45976, 38.58783], [-121.45965, 38.5879], [-121.45951, 38.58792], [-121.45935, 38.58799], [-121.45887, 38.58812], [-121.45856, 38.58826], [-121.45831, 38.58832], [-121.45816, 38.58841], [-121.45787, 38.58852], [-121.45762, 38.58859], [-121.45712, 38.58871], [-121.45676, 38.58886], [-121.45656, 38.58889], [-121.45634, 38.58902], [-121.45611, 38.58907], [-121.4558, 38.58918], [-121.45557, 38.58921], [-121.45536, 38.58927], [-121.45514, 38.58926], [-121.45503, 38.58927], [-121.45478, 38.58938], [-121.45421, 38.5894], [-121.45392, 38.58948], [-121.45354, 38.58946], [-121.45327, 38.58955], [-121.45241, 38.58956], [-121.45215, 38.58947], [-121.45183, 38.58944], [-121.45163, 38.58929], [-121.45135, 38.5898], [-121.45077, 38.58953], [-121.45073, 38.58877], [-121.45066, 38.58876], [-121.45063, 38.58827], [-121.45067, 38.5878], [-121.45113, 38.58571], [-121.45191, 38.58557], [-121.45271, 38.58546], [-121.45391, 38.58533], [-121.45575, 38.58518], [-121.45829, 38.58509], [-121.45864, 38.58506], [-121.45907, 38.58501], [-121.45958, 38.5849], [-121.45999, 38.58477], [-121.46046, 38.58459], [-121.46091, 38.58437], [-121.46132, 38.58411], [-121.4617, 38.58382], [-121.46203, 38.5835], [-121.46236, 38.58311], [-121.46355, 38.58344]]]]} | Open Access 1 | 36002 | Sutters Landing Regional Park | 26087 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 108.631 | Sutters Landing RP | 0 | Local Park 2 | 4 | |
11380 | 11380 | 11379 | {"type": "MultiPolygon", "coordinates": [[[[-121.45543, 38.6061], [-121.45441, 38.6061], [-121.45437, 38.60608], [-121.45435, 38.60605], [-121.45435, 38.60509], [-121.45436, 38.60506], [-121.45441, 38.60504], [-121.45506, 38.60501], [-121.45585, 38.60504], [-121.45589, 38.60506], [-121.45591, 38.60511], [-121.45575, 38.6057], [-121.45565, 38.60585], [-121.45547, 38.60602], [-121.45543, 38.6061]]], [[[-121.45815, 38.60582], [-121.45747, 38.60582], [-121.45746, 38.60593], [-121.45678, 38.60593], [-121.45683, 38.60556], [-121.45681, 38.60551], [-121.45676, 38.60546], [-121.45669, 38.60544], [-121.45625, 38.60546], [-121.45605, 38.60546], [-121.45597, 38.60544], [-121.45606, 38.60508], [-121.45609, 38.60505], [-121.45612, 38.60504], [-121.45659, 38.60506], [-121.4568, 38.6051], [-121.45717, 38.60521], [-121.45732, 38.60523], [-121.45746, 38.60522], [-121.45759, 38.60517], [-121.45764, 38.60517], [-121.45815, 38.60582]]]]} | Open Access 1 | 22181 | Woodlake Park | 27717 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 6.15 | Woodlake Park | 0 | Local Park 2 | 4 | |
11025 | 11025 | 11024 | {"type": "MultiPolygon", "coordinates": [[[[-121.45673, 38.62431], [-121.45673, 38.62501], [-121.45639, 38.62499], [-121.4557, 38.62501], [-121.45533, 38.62505], [-121.45427, 38.62553], [-121.45334, 38.62588], [-121.44766, 38.62582], [-121.44766, 38.62491], [-121.44814, 38.62481], [-121.44854, 38.62477], [-121.44913, 38.62477], [-121.45093, 38.62501], [-121.45128, 38.62503], [-121.4519, 38.62501], [-121.45313, 38.62488], [-121.45314, 38.62485], [-121.45347, 38.62479], [-121.45367, 38.62471], [-121.45385, 38.62461], [-121.45401, 38.62449], [-121.45404, 38.62444], [-121.45415, 38.62434], [-121.45438, 38.62418], [-121.4546, 38.62405], [-121.45475, 38.62399], [-121.45501, 38.62391], [-121.45592, 38.6237], [-121.45641, 38.62361], [-121.45673, 38.62357], [-121.45673, 38.62431]]], [[[-121.44729, 38.625], [-121.44729, 38.62596], [-121.4464, 38.62624], [-121.44634, 38.62625], [-121.44628, 38.6261], [-121.44628, 38.62557], [-121.44629, 38.62543], [-121.44729, 38.625]]], [[[-121.44602, 38.62595], [-121.44601, 38.62596], [-121.44601, 38.62623], [-121.44593, 38.62642], [-121.4455, 38.6266], [-121.44535, 38.62665], [-121.44451, 38.62683], [-121.44409, 38.62705], [-121.44374, 38.62732], [-121.44346, 38.6275], [-121.44318, 38.62764], [-121.4429, 38.62774], [-121.44252, 38.62781], [-121.44242, 38.62782], [-121.44241, 38.62783], [-121.44206, 38.62787], [-121.44164, 38.62784], [-121.44164, 38.62722], [-121.4419, 38.62722], [-121.44221, 38.6272], [-121.44236, 38.62717], [-121.44253, 38.62713], [-121.44305, 38.62691], [-121.44323, 38.6268], [-121.44375, 38.62636], [-121.44395, 38.62624], [-121.44414, 38.62617], [-121.44491, 38.62604], [-121.44512, 38.62596], [-121.44597, 38.62557], [-121.44602, 38.62567], [-121.44602, 38.62595]]], [[[-121.44144, 38.6278], [-121.44088, 38.62773], [-121.44074, 38.62773], [-121.44052, 38.62776], [-121.4399, 38.62803], [-121.43989, 38.62805], [-121.43947, 38.62817], [-121.43924, 38.62822], [-121.43924, 38.62825], [-121.43876, 38.62833], [-121.43858, 38.62805], [-121.43834, 38.6281], [-121.43849, 38.62837], [-121.43793, 38.62843], [-121.4374, 38.62842], [-121.43669, 38.62838], [-121.43668, 38.62837], [-121.43651, 38.62835], [-121.4365, 38.62831], [-121.43618, 38.62826], [-121.43618, 38.62808], [-121.4337, 38.62751], [-121.43232, 38.62747], [-121.43244, 38.62719], [-121.43318, 38.62719], [-121.43389, 38.62726], [-121.43473, 38.62747], [-121.43486, 38.62752], [-121.43608, 38.62783], [-121.43632, 38.62787], [-121.43703, 38.62786], [-121.43704, 38.62785], [-121.43747, 38.62791], [-121.43781, 38.62791], [-121.43842, 38.62786], [-121.43887, 38.62776], [-121.43918, 38.62767], [-121.43944, 38.62757], [-121.44023, 38.62719], [-121.44043, 38.62714], [-121.44045, 38.62716], [-121.44077, 38.62714], [-121.44144, 38.6272], [-121.44144, 38.6278]]], [[[-121.46612, 38.65884], [-121.4661, 38.65939], [-121.46611, 38.65985], [-121.46604, 38.65988], [-121.46567, 38.65996], [-121.46496, 38.66027], [-121.46398, 38.66053], [-121.46276, 38.66085], [-121.46211, 38.66098], [-121.46164, 38.661], [-121.46113, 38.66126], [-121.46039, 38.66171], [-121.4593, 38.66245], [-121.45828, 38.663], [-121.45774, 38.66342], [-121.45719, 38.66373], [-121.45652, 38.66384], [-121.45571, 38.66368], [-121.45534, 38.66383], [-121.45448, 38.66478], [-121.45411, 38.66504], [-121.4535, 38.66517], [-121.45313, 38.66536], [-121.45265, 38.66589], [-121.45245, 38.66594], [-121.45176, 38.6671], [-121.45155, 38.66773], [-121.45097, 38.66816], [-121.45041, 38.66816], [-121.44965, 38.6681], [-121.44935, 38.66811], [-121.44936, 38.66696], [-121.45095, 38.66696], [-121.45129, 38.66678], [-121.45187, 38.66607], [-121.45221, 38.66538], [-121.45259, 38.66512], [-121.45323, 38.66485], [-121.45391, 38.66454], [-121.45435, 38.66417], [-121.45466, 38.66378], [-121.45503, 38.66351], [-121.45642, 38.6632], [-121.45659, 38.66286], [-121.4571, 38.66238], [-121.45778, 38.66216], [-121.45825, 38.66207], [-121.4587, 38.6619], [-121.46042, 38.66095], [-121.46153, 38.66051], [-121.46432, 38.65945], [-121.46612, 38.65884]]], [[[-121.48584, 38.68491], [-121.48432, 38.68491], [-121.48428, 38.67469], [-121.48407, 38.67458], [-121.47764, 38.67178], [-121.47749, 38.67085], [-121.47697, 38.67085], [-121.47565, 38.66401], [-121.47541, 38.66402], [-121.47435, 38.65723], [-121.47404, 38.65554], [-121.47339, 38.65223], [-121.47227, 38.64637], [-121.46891, 38.62863], [-121.46841, 38.62606], [-121.4674, 38.62064], [-121.46734, 38.62063], [-121.46729, 38.62071], [-121.46642, 38.62119], [-121.46531, 38.62187], [-121.46482, 38.62212], [-121.46414, 38.62244], [-121.46366, 38.62271], [-121.46322, 38.62289], [-121.46293, 38.62305], [-121.46264, 38.62316], [-121.46144, 38.62373], [-121.46098, 38.62391], [-121.46073, 38.62399], [-121.46026, 38.62419], [-121.46004, 38.62427], [-121.45986, 38.6244], [-121.45942, 38.62517], [-121.45934, 38.62525], [-121.45924, 38.62531], [-121.45884, 38.6254], [-121.45883, 38.62546], [-121.45871, 38.62551], [-121.4585, 38.62546], [-121.45719, 38.62503], [-121.45717, 38.62349], [-121.45778, 38.6235], [-121.45779, 38.62349], [-121.45834, 38.62348], [-121.45901, 38.62341], [-121.45947, 38.6233], [-121.46002, 38.62312], [-121.4602, 38.62305], [-121.46333, 38.62138], [-121.46688, 38.61945], [-121.4669, 38.6195], [-121.46717, 38.61943], [-121.46637, 38.61515], [-121.46604, 38.61328], [-121.466, 38.61294], [-121.46596, 38.61222], [-121.46599, 38.61114], [-121.46612, 38.61007], [-121.46629, 38.60912], [-121.46658, 38.60812], [-121.46682, 38.60742], [-121.46697, 38.60713], [-121.46713, 38.60673], [-121.46726, 38.60637], [-121.46753, 38.60592], [-121.46759, 38.60575], [-121.46833, 38.60539], [-121.46752, 38.60752], [-121.4672, 38.60846], [-121.46699, 38.60917], [-121.46689, 38.60958], [-121.46682, 38.61], [-121.46672, 38.61073], [-121.46669, 38.61123], [-121.46811, 38.61125], [-121.4681, 38.6119], [-121.46812, 38.61226], [-121.46818, 38.61261], [-121.47043, 38.62426], [-121.47083, 38.62607], [-121.47085, 38.62688], [-121.4715, 38.63026], [-121.46995, 38.63024], [-121.46994, 38.63026], [-121.46997, 38.63038], [-121.47151, 38.63038], [-121.47209, 38.63327], [-121.47327, 38.63939], [-121.47359, 38.64072], [-121.47325, 38.64098], [-121.47201, 38.64114], [-121.472, 38.64115], [-121.47208, 38.6416], [-121.47326, 38.64148], [-121.47374, 38.64166], [-121.4751, 38.64941], [-121.47499, 38.64942], [-121.47499, 38.64943], [-121.47611, 38.65515], [-121.47526, 38.65522], [-121.4747, 38.6553], [-121.47472, 38.65546], [-121.4753, 38.65538], [-121.47604, 38.65533], [-121.47707, 38.66058], [-121.47747, 38.66284], [-121.47756, 38.66322], [-121.47754, 38.66652], [-121.47798, 38.66954], [-121.4782, 38.67071], [-121.47825, 38.67084], [-121.47843, 38.67084], [-121.4786, 38.67117], [-121.47881, 38.67145], [-121.47902, 38.67164], [-121.47934, 38.67185], [-121.47958, 38.67197], [-121.48423, 38.67403], [-121.4846, 38.67422], [-121.4849, 38.67443], [-121.48516, 38.67468], [-121.48536, 38.67497], [-121.4855, 38.67523], [-121.48557, 38.67544], [-121.48561, 38.67567], [-121.48584, 38.68491]]]]} | Open Access 1 | 21117 | Ueda Parkway | 9929 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://www.cityofsacramento.org/parksandrecreation/parks/sites/ueda_parkway.htm | Sacramento 41 | 475.439 | Ueda Parkway | 0 | Local Recreation Area 3 | 4 |
5649 | 5649 | 5648 | {"type": "MultiPolygon", "coordinates": [[[[-121.4595, 38.57645], [-121.45919, 38.57719], [-121.45722, 38.57666], [-121.45758, 38.57593], [-121.4595, 38.57645]]], [[[-121.46367, 38.57597], [-121.46275, 38.57809], [-121.45934, 38.57718], [-121.46062, 38.57419], [-121.46066, 38.57416], [-121.46367, 38.57497], [-121.46378, 38.57509], [-121.46382, 38.57525], [-121.4638, 38.57535], [-121.46363, 38.57576], [-121.46363, 38.57587], [-121.46367, 38.57597]]], [[[-121.46413, 38.57503], [-121.46379, 38.57583], [-121.46377, 38.57583], [-121.46378, 38.57577], [-121.46392, 38.57542], [-121.46395, 38.5753], [-121.46394, 38.57514], [-121.46386, 38.57497], [-121.46389, 38.57497], [-121.46413, 38.57503]]]]} | Open Access 1 | 21133 | William Mckinley Park | 27552 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 31.223 | William Mckinley Park | 0 | Local Park 2 | 4 | |
11382 | 11382 | 11381 | {"type": "MultiPolygon", "coordinates": [[[[-121.46586, 38.61877], [-121.46372, 38.61875], [-121.46279, 38.61927], [-121.46144, 38.61925], [-121.46052, 38.61961], [-121.46053, 38.61774], [-121.46198, 38.61776], [-121.46202, 38.61774], [-121.46205, 38.6177], [-121.46205, 38.61711], [-121.46208, 38.61706], [-121.46212, 38.61705], [-121.46329, 38.61704], [-121.46338, 38.61705], [-121.46355, 38.61712], [-121.46382, 38.61736], [-121.46385, 38.6176], [-121.46392, 38.61781], [-121.46401, 38.61794], [-121.46423, 38.61815], [-121.46436, 38.61822], [-121.4645, 38.61828], [-121.46473, 38.61833], [-121.46512, 38.61833], [-121.46554, 38.61827], [-121.46575, 38.61826], [-121.46586, 38.61877]]], [[[-121.46688, 38.61787], [-121.46568, 38.61786], [-121.46573, 38.61814], [-121.46512, 38.61823], [-121.46482, 38.61821], [-121.46465, 38.61817], [-121.46449, 38.61811], [-121.46435, 38.61803], [-121.46422, 38.61793], [-121.46412, 38.61782], [-121.46402, 38.61762], [-121.46397, 38.61732], [-121.46393, 38.61725], [-121.46375, 38.61709], [-121.46375, 38.61695], [-121.46671, 38.61697], [-121.46688, 38.61787]]]]} | Open Access 1 | 22182 | Johnston Park | 20482 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 24.225 | Johnston Park | 0 | Local Park 2 | 4 | |
11375 | 11375 | 11374 | {"type": "MultiPolygon", "coordinates": [[[[-121.47396, 38.59528], [-121.47304, 38.59734], [-121.47239, 38.5976], [-121.47263, 38.59799], [-121.4714, 38.59854], [-121.47312, 38.59458], [-121.47347, 38.59486], [-121.47374, 38.59514], [-121.47396, 38.59528]]], [[[-121.4752, 38.59647], [-121.4752, 38.59647], [-121.4733, 38.59725], [-121.47409, 38.59542], [-121.47462, 38.59588], [-121.47501, 38.59634], [-121.4752, 38.59647]]]]} | Open Access 1 | 22179 | Ueda Park Site | 26643 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 11.813 | Ueda Park Site | 0 | Local Park 2 | 4 | |
5674 | 5674 | 5673 | {"type": "MultiPolygon", "coordinates": [[[[-121.47899, 38.54805], [-121.47897, 38.5475], [-121.47908, 38.54753], [-121.47922, 38.54764], [-121.47934, 38.54771], [-121.47961, 38.54777], [-121.47966, 38.54781], [-121.47968, 38.54786], [-121.47968, 38.548], [-121.47963, 38.54804], [-121.47899, 38.54805]]], [[[-121.48009, 38.54377], [-121.47905, 38.54378], [-121.479, 38.5406], [-121.48004, 38.54042], [-121.48009, 38.54377]]], [[[-121.48012, 38.5452], [-121.47907, 38.54521], [-121.47905, 38.54394], [-121.4801, 38.54393], [-121.48012, 38.5452]]], [[[-121.48013, 38.54591], [-121.47908, 38.54592], [-121.47907, 38.54537], [-121.48012, 38.54536], [-121.48013, 38.54591]]], [[[-121.48013, 38.54607], [-121.48015, 38.5473], [-121.48011, 38.54743], [-121.48006, 38.54751], [-121.47998, 38.54758], [-121.47988, 38.54764], [-121.47978, 38.54767], [-121.47955, 38.54769], [-121.47944, 38.54767], [-121.47934, 38.54763], [-121.47924, 38.54756], [-121.47918, 38.5475], [-121.47911, 38.54735], [-121.47908, 38.54608], [-121.48013, 38.54607]]], [[[-121.48031, 38.54803], [-121.47996, 38.54804], [-121.47992, 38.54803], [-121.47989, 38.54799], [-121.47989, 38.54777], [-121.47992, 38.54771], [-121.48006, 38.54762], [-121.48015, 38.54753], [-121.48023, 38.5475], [-121.48029, 38.54749], [-121.48031, 38.54803]]]]} | Open Access 1 | 21160 | William Curtis Park | 27542 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 17.577 | William Curtis Park | 0 | Local Park 2 | 4 | |
11068 | 11068 | 11067 | {"type": "MultiPolygon", "coordinates": [[[[-121.48235, 38.49361], [-121.48044, 38.49362], [-121.48044, 38.4925], [-121.48046, 38.49243], [-121.4805, 38.49238], [-121.48056, 38.49235], [-121.48062, 38.49233], [-121.48066, 38.49234], [-121.48097, 38.49259], [-121.48202, 38.49327], [-121.48222, 38.49346], [-121.48235, 38.49361]]], [[[-121.48082, 38.49178], [-121.48186, 38.49179], [-121.48203, 38.49183], [-121.48215, 38.49187], [-121.48238, 38.49202], [-121.48249, 38.49213], [-121.48255, 38.49223], [-121.48261, 38.49243], [-121.48261, 38.49309], [-121.48258, 38.49318], [-121.48252, 38.49327], [-121.48247, 38.4933], [-121.48241, 38.49329], [-121.48215, 38.49307], [-121.48118, 38.49244], [-121.48098, 38.49229], [-121.4808, 38.4921], [-121.48065, 38.49188], [-121.48065, 38.49185], [-121.48068, 38.49181], [-121.48082, 38.49178]]]]} | Open Access 1 | 21267 | 24th Street Bypass Park | 15186 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 7.38 | 24th Street Bypass Park | 0 | Local Park 2 | 4 | |
2685 | 2685 | 2684 | {"type": "MultiPolygon", "coordinates": [[[[-121.48293, 38.51018], [-121.48097, 38.51019], [-121.48096, 38.50922], [-121.4829, 38.50921], [-121.48293, 38.51018]]], [[[-121.48293, 38.51026], [-121.48294, 38.51071], [-121.48292, 38.51075], [-121.48286, 38.51077], [-121.48266, 38.5107], [-121.48201, 38.51037], [-121.48198, 38.51032], [-121.482, 38.51028], [-121.48205, 38.51027], [-121.48293, 38.51026]]], [[[-121.48603, 38.50975], [-121.48435, 38.50907], [-121.48421, 38.50905], [-121.48314, 38.50905], [-121.48311, 38.50825], [-121.48452, 38.50824], [-121.48455, 38.50891], [-121.48602, 38.50891], [-121.48603, 38.50975]]]]} | Open Access 1 | 21162 | Airport Little League Park | 15302 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 9.948 | Airport Little League Park | 0 | Local Park 2 | 4 | |
11075 | 11075 | 11074 | {"type": "MultiPolygon", "coordinates": [[[[-121.4912, 38.54398], [-121.49146, 38.54403], [-121.49149, 38.54405], [-121.4915, 38.54409], [-121.49131, 38.54436], [-121.49116, 38.54469], [-121.49106, 38.54476], [-121.49097, 38.54478], [-121.49093, 38.54475], [-121.49092, 38.54471], [-121.49115, 38.54402], [-121.4912, 38.54398]]], [[[-121.49146, 38.54318], [-121.49151, 38.54319], [-121.49154, 38.54322], [-121.49159, 38.54335], [-121.49154, 38.54364], [-121.49155, 38.54385], [-121.49153, 38.54389], [-121.49148, 38.5439], [-121.49126, 38.54386], [-121.49122, 38.54381], [-121.49141, 38.54321], [-121.49146, 38.54318]]]]} | Open Access 1 | 21278 | Brockway Park | 16413 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 0.923 | Brockway Park | 0 | Local Park 2 | 4 | |
13660 | 13660 | 13659 | {"type": "MultiPolygon", "coordinates": [[[[-121.50422, 38.61644], [-121.50421, 38.61606], [-121.50427, 38.6151], [-121.50376, 38.61442], [-121.50357, 38.61436], [-121.50332, 38.61406], [-121.50336, 38.61375], [-121.50361, 38.61361], [-121.50363, 38.61358], [-121.50374, 38.61358], [-121.5038, 38.61353], [-121.50424, 38.61352], [-121.50418, 38.61324], [-121.50408, 38.61312], [-121.50394, 38.61304], [-121.50383, 38.61292], [-121.50482, 38.61296], [-121.5049, 38.61299], [-121.50491, 38.61302], [-121.50489, 38.6134], [-121.50491, 38.61364], [-121.50496, 38.61384], [-121.50509, 38.61422], [-121.50515, 38.61442], [-121.50518, 38.61467], [-121.50519, 38.61495], [-121.50524, 38.61523], [-121.50533, 38.61551], [-121.50542, 38.61569], [-121.50558, 38.61595], [-121.50579, 38.61619], [-121.5058, 38.61621], [-121.50577, 38.61626], [-121.50565, 38.61635], [-121.50551, 38.6164], [-121.5054, 38.61643], [-121.50422, 38.61644]]], [[[-121.50603, 38.61927], [-121.50594, 38.61935], [-121.5059, 38.61944], [-121.50591, 38.6199], [-121.50594, 38.61998], [-121.50601, 38.62004], [-121.50599, 38.62007], [-121.50599, 38.62064], [-121.50591, 38.6207], [-121.50587, 38.6208], [-121.50588, 38.62085], [-121.50591, 38.62093], [-121.50591, 38.62118], [-121.50589, 38.6212], [-121.50585, 38.62122], [-121.50558, 38.62121], [-121.50558, 38.62063], [-121.50556, 38.62059], [-121.50562, 38.62053], [-121.50566, 38.62046], [-121.50566, 38.61997], [-121.50563, 38.61989], [-121.50554, 38.61982], [-121.50556, 38.6198], [-121.50556, 38.61926], [-121.50553, 38.61923], [-121.50559, 38.61918], [-121.50562, 38.61911], [-121.50562, 38.61862], [-121.50559, 38.61855], [-121.50551, 38.61849], [-121.50542, 38.61847], [-121.50522, 38.61847], [-121.50519, 38.6182], [-121.50508, 38.61819], [-121.50508, 38.61793], [-121.50517, 38.61793], [-121.50523, 38.61789], [-121.50526, 38.61783], [-121.50524, 38.61777], [-121.50544, 38.61755], [-121.5054, 38.61746], [-121.50484, 38.61717], [-121.50487, 38.61711], [-121.50487, 38.61705], [-121.5048, 38.61691], [-121.50477, 38.61678], [-121.50477, 38.61664], [-121.50481, 38.61659], [-121.5052, 38.61658], [-121.5052, 38.61685], [-121.50544, 38.61692], [-121.5058, 38.61712], [-121.50577, 38.61717], [-121.50578, 38.61722], [-121.50587, 38.61731], [-121.5059, 38.61738], [-121.5059, 38.61853], [-121.50594, 38.61862], [-121.50603, 38.61868], [-121.50602, 38.61924], [-121.50603, 38.61927]]], [[[-121.50593, 38.62452], [-121.50574, 38.62452], [-121.50568, 38.62449], [-121.50567, 38.62409], [-121.50564, 38.62402], [-121.50556, 38.62396], [-121.50557, 38.62394], [-121.50557, 38.62339], [-121.50556, 38.62337], [-121.50563, 38.62331], [-121.50567, 38.62322], [-121.50567, 38.62276], [-121.50564, 38.62269], [-121.50557, 38.62264], [-121.50559, 38.62261], [-121.50559, 38.62232], [-121.50559, 38.62205], [-121.50557, 38.62202], [-121.50563, 38.62197], [-121.50566, 38.62191], [-121.50567, 38.62144], [-121.50569, 38.62141], [-121.50573, 38.6214], [-121.50591, 38.62142], [-121.50593, 38.62452]]], [[[-121.5058, 38.62731], [-121.50574, 38.6273], [-121.5057, 38.62725], [-121.50569, 38.62622], [-121.50566, 38.62615], [-121.50558, 38.62608], [-121.50559, 38.62606], [-121.50559, 38.6255], [-121.50557, 38.62548], [-121.50564, 38.62542], [-121.50568, 38.62536], [-121.50568, 38.62473], [-121.5057, 38.62469], [-121.50575, 38.62467], [-121.50578, 38.62467], [-121.5058, 38.62731]]]]} | Open Access 1 | 36026 | Bannon Creek Parkway | 15800 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 18.591 | Bannon Creek Parkway | 0 | Local Recreation Area 3 | 4 | |
5648 | 5648 | 5647 | {"type": "MultiPolygon", "coordinates": [[[[-121.50611, 38.57814], [-121.50593, 38.57856], [-121.50485, 38.57827], [-121.50503, 38.57785], [-121.50611, 38.57814]]], [[[-121.50632, 38.57767], [-121.50614, 38.57809], [-121.50505, 38.5778], [-121.50523, 38.57738], [-121.50632, 38.57767]]]]} | Open Access 1 | 21132 | Crocker Park | 17825 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 2.429 | Crocker 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]);