units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 2, COUNTY = 41 and DES_TP = 14
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_LEV
MNG_AG_TYP 3
MNG_AGENCY 3
DES_TP 1
- Local Other or Unknown · 6 ✖
ACCESS_TYP 1
- Restricted Access · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4679 | 4679 | 4678 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45595], [-121.35327, 38.45636], [-121.35226, 38.45636], [-121.35227, 38.45624], [-121.3523, 38.45613], [-121.35236, 38.456], [-121.35243, 38.45591], [-121.35251, 38.45582], [-121.35281, 38.45567], [-121.35311, 38.4556], [-121.35318, 38.45561], [-121.35321, 38.45564], [-121.3533, 38.45594]]]} | Restricted Access 2 | 43001 | Unnamed site - Sacramento, County of | 28659 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 1.452 | 0 | Local Other or Unknown 14 | 4 | ||
4793 | 4793 | 4792 | {"type": "MultiPolygon", "coordinates": [[[[-121.29204, 38.27768], [-121.29158, 38.27785], [-121.29136, 38.27788], [-121.29122, 38.27786], [-121.29102, 38.27778], [-121.29092, 38.27771], [-121.29083, 38.27761], [-121.29072, 38.27737], [-121.29065, 38.27731], [-121.29057, 38.27728], [-121.29048, 38.27726], [-121.29034, 38.27729], [-121.29026, 38.27734], [-121.2902, 38.27744], [-121.29019, 38.27802], [-121.29016, 38.27812], [-121.2901, 38.27821], [-121.28997, 38.27832], [-121.28986, 38.27837], [-121.28977, 38.27838], [-121.28944, 38.27834], [-121.28902, 38.27938], [-121.28899, 38.27942], [-121.28886, 38.27952], [-121.28876, 38.27956], [-121.28864, 38.27957], [-121.28848, 38.27966], [-121.28881, 38.28013], [-121.28882, 38.28017], [-121.28881, 38.2802], [-121.28838, 38.28045], [-121.28808, 38.28066], [-121.28721, 38.28136], [-121.28673, 38.28166], [-121.28621, 38.28191], [-121.28512, 38.28234], [-121.28459, 38.28251], [-121.28411, 38.28262], [-121.28339, 38.28269], [-121.28279, 38.28271], [-121.28274, 38.2827], [-121.28271, 38.28266], [-121.28269, 38.28233], [-121.28313, 38.28232], [-121.28319, 38.28229], [-121.28327, 38.28233], [-121.28337, 38.28234], [-121.28349, 38.28231], [-121.28387, 38.28225], [-121.28423, 38.28218], [-121.28475, 38.28203], [-121.28583, 38.28161], [-121.28631, 38.28139], [-121.28676, 38.28112], [-121.28698, 38.28096], [-121.28717, 38.28078], [-121.28725, 38.28073], [-121.2873, 38.28066], [-121.2873, 38.2806], [-121.28728, 38.28055], [-121.28734, 38.28052], [-121.2876, 38.2799], [-121.28755, 38.27979], [-121.28758, 38.27975], [-121.28758, 38.2797], [-121.28771, 38.27969], [-121.28792, 38.27918], [-121.28802, 38.27903], [-121.28816, 38.2787], [-121.28869, 38.27764], [-121.28882, 38.27746], [-121.28898, 38.27728], [-121.28916, 38.27713], [-121.28948, 38.27693], [-121.28976, 38.27682], [-121.29042, 38.2766], [-121.29066, 38.27659], [-121.2909, 38.27663], [-121.29111, 38.27672], [-121.29122, 38.27681], [-121.29131, 38.2769], [-121.29135, 38.27695], [-121.29127, 38.27699], [-121.29147, 38.27745], [-121.29155, 38.27749], [-121.29169, 38.27751], [-121.29178, 38.2775], [-121.2919, 38.27744], [-121.29204, 38.27768]]], [[[-121.30035, 38.27651], [-121.30032, 38.27682], [-121.30028, 38.277], [-121.3002, 38.27717], [-121.29942, 38.27706], [-121.2968, 38.27706], [-121.29631, 38.27711], [-121.29594, 38.27721], [-121.29553, 38.27735], [-121.29535, 38.27739], [-121.29517, 38.27739], [-121.29498, 38.27738], [-121.29385, 38.27719], [-121.29363, 38.27718], [-121.29348, 38.2772], [-121.29334, 38.27725], [-121.29323, 38.27732], [-121.29301, 38.2775], [-121.29284, 38.27761], [-121.29264, 38.2777], [-121.29243, 38.27777], [-121.29213, 38.27722], [-121.29247, 38.27708], [-121.29274, 38.27684], [-121.29348, 38.27665], [-121.29354, 38.27669], [-121.29365, 38.2767], [-121.29379, 38.27663], [-121.29424, 38.27653], [-121.29443, 38.27653], [-121.29453, 38.27646], [-121.29458, 38.27648], [-121.29523, 38.27628], [-121.29553, 38.27621], [-121.29583, 38.27618], [-121.2963, 38.27617], [-121.29753, 38.27624], [-121.29758, 38.2763], [-121.29766, 38.27632], [-121.29784, 38.2763], [-121.29934, 38.27638], [-121.29947, 38.27642], [-121.29958, 38.2764], [-121.29964, 38.27635], [-121.30035, 38.27651]]], [[[-121.30096, 38.27735], [-121.30038, 38.27726], [-121.30051, 38.27695], [-121.30056, 38.27663], [-121.30091, 38.27661], [-121.30095, 38.27685], [-121.30096, 38.27735]]]]} | Restricted Access 2 | 48279 | Unnamed Site - Galt, City of | 32849 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 35.606 | 0 | Local Other or Unknown 14 | 4 | ||
11138 | 11138 | 11137 | {"type": "Polygon", "coordinates": [[[-121.29786, 38.49822], [-121.29733, 38.49802], [-121.2969, 38.49796], [-121.29661, 38.49799], [-121.29634, 38.49832], [-121.29629, 38.49874], [-121.29647, 38.49922], [-121.29644, 38.49953], [-121.29651, 38.49982], [-121.29676, 38.49992], [-121.29701, 38.49988], [-121.29784, 38.49901], [-121.29783, 38.50332], [-121.29735, 38.50321], [-121.29714, 38.50313], [-121.29689, 38.50305], [-121.29688, 38.50306], [-121.29691, 38.50315], [-121.29703, 38.50326], [-121.29748, 38.50354], [-121.29428, 38.50352], [-121.29385, 38.50329], [-121.29323, 38.50315], [-121.29275, 38.50326], [-121.29239, 38.50351], [-121.28867, 38.50348], [-121.28869, 38.50214], [-121.2923, 38.50215], [-121.29546, 38.49847], [-121.29544, 38.49627], [-121.29762, 38.49629], [-121.29774, 38.49637], [-121.29785, 38.49753], [-121.29786, 38.49822]], [[-121.29624, 38.50255], [-121.29625, 38.50254], [-121.29618, 38.50232], [-121.29606, 38.50211], [-121.29588, 38.50192], [-121.29566, 38.50176], [-121.29541, 38.50164], [-121.29512, 38.50157], [-121.29483, 38.50154], [-121.29453, 38.50156], [-121.29425, 38.50162], [-121.29398, 38.50173], [-121.29374, 38.50176], [-121.29351, 38.50182], [-121.2933, 38.50192], [-121.29313, 38.50205], [-121.293, 38.50219], [-121.29301, 38.5022], [-121.29326, 38.50215], [-121.29354, 38.50213], [-121.29382, 38.50215], [-121.29409, 38.50221], [-121.29464, 38.50225], [-121.29519, 38.50231], [-121.29572, 38.50242], [-121.29624, 38.50255]]]} | Restricted Access 2 | 21429 | Arroyo Seco (florin Mitigation Bank) | 15628 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 66.229 | Arroyo Seco (florin Mitigation Bank) | 0 | Local Other or Unknown 14 | 4 | |
11411 | 11411 | 11410 | {"type": "Polygon", "coordinates": [[[-121.44882, 38.38398], [-121.44574, 38.38469], [-121.44561, 38.38473], [-121.44549, 38.38479], [-121.44535, 38.38492], [-121.44535, 38.38427], [-121.44879, 38.38348], [-121.44879, 38.38397], [-121.44882, 38.38398]]]} | Restricted Access 2 | 22248 | Lotus Pond Drainage | 21545 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 4.291 | Lotus Pond Drainage | 0 | Local Other or Unknown 14 | 4 | |
11416 | 11416 | 11415 | {"type": "MultiPolygon", "coordinates": [[[[-121.21771, 38.43508], [-121.21767, 38.43514], [-121.21731, 38.43503], [-121.21701, 38.43503], [-121.21678, 38.43513], [-121.21658, 38.43516], [-121.21642, 38.43515], [-121.21609, 38.43504], [-121.21579, 38.43498], [-121.21541, 38.43495], [-121.21521, 38.43491], [-121.21521, 38.43479], [-121.2153, 38.43448], [-121.21529, 38.43433], [-121.2152, 38.43412], [-121.21522, 38.43402], [-121.2154, 38.43378], [-121.21556, 38.43335], [-121.21562, 38.43316], [-121.21558, 38.433], [-121.21538, 38.43274], [-121.21497, 38.43244], [-121.2147, 38.4323], [-121.21424, 38.43218], [-121.21361, 38.43208], [-121.21335, 38.43213], [-121.21298, 38.43228], [-121.21241, 38.43242], [-121.21216, 38.43255], [-121.21175, 38.43286], [-121.21165, 38.43299], [-121.21163, 38.4332], [-121.21162, 38.43355], [-121.21155, 38.43361], [-121.21145, 38.4336], [-121.21134, 38.43357], [-121.21111, 38.43335], [-121.21093, 38.43326], [-121.21068, 38.43323], [-121.21074, 38.43315], [-121.21279, 38.43099], [-121.2167, 38.43328], [-121.21655, 38.43334], [-121.21649, 38.43335], [-121.2163, 38.43348], [-121.21623, 38.43364], [-121.21624, 38.43385], [-121.21637, 38.43403], [-121.21673, 38.43437], [-121.21706, 38.43464], [-121.21766, 38.43499], [-121.21771, 38.43508]]], [[[-121.22965, 38.44085], [-121.22946, 38.44104], [-121.22924, 38.44124], [-121.22905, 38.44133], [-121.2284, 38.4414], [-121.22792, 38.44165], [-121.22743, 38.44203], [-121.22713, 38.44222], [-121.22653, 38.44252], [-121.22623, 38.44284], [-121.226, 38.443], [-121.22581, 38.44318], [-121.22536, 38.44373], [-121.22511, 38.44393], [-121.22441, 38.44463], [-121.22389, 38.44499], [-121.22347, 38.44513], [-121.22277, 38.44533], [-121.22211, 38.44582], [-121.22187, 38.44601], [-121.22168, 38.4462], [-121.22097, 38.44668], [-121.22032, 38.44693], [-121.21922, 38.44722], [-121.21851, 38.44722], [-121.21769, 38.44713], [-121.21696, 38.447], [-121.21555, 38.44658], [-121.21532, 38.44655], [-121.21717, 38.44459], [-121.21532, 38.4435], [-121.21808, 38.44059], [-121.21514, 38.43887], [-121.2152, 38.43879], [-121.21524, 38.43868], [-121.21537, 38.43863], [-121.2156, 38.43866], [-121.21601, 38.43877], [-121.21619, 38.4388], [-121.21635, 38.43874], [-121.21674, 38.43846], [-121.2169, 38.43837], [-121.21706, 38.43839], [-121.21718, 38.43847], [-121.21725, 38.43882], [-121.21726, 38.43969], [-121.2173, 38.43983], [-121.21742, 38.43991], [-121.2176, 38.43996], [-121.21794, 38.43998], [-121.21845, 38.44009], [-121.21868, 38.44008], [-121.21886, 38.43998], [-121.21899, 38.43996], [-121.21917, 38.44006], [-121.21933, 38.44013], [-121.21959, 38.44017], [-121.21986, 38.44018], [-121.21998, 38.44033], [-121.21998, 38.44046], [-121.21989, 38.44088], [-121.2199, 38.44104], [-121.21996, 38.44117], [-121.22011, 38.44136], [-121.22013, 38.44145], [-121.22008, 38.44158], [-121.22009, 38.44168], [-121.22019, 38.44185], [-121.22041, 38.44203], [-121.22087, 38.44236], [-121.22103, 38.44243], [-121.2212, 38.44241], [-121.22138, 38.44231], [-121.22142, 38.44216], [-121.22142, 38.442], [-121.22139, 38.44196], [-121.22139, 38.44201], [-121.22138, 38.44206], [-121.22133, 38.44208], [-121.22124, 38.44202], [-121.22115, 38.44202], [-121.22114, 38.44194], [-121.22118, 38.44188], [-121.22124, 38.44183], [-121.2213, 38.44186], [-121.22137, 38.44194], [-121.22139, 38.44193], [-121.22125, 38.44166], [-121.22108, 38.44122], [-121.22086, 38.44092], [-121.22063, 38.44071], [-121.22042, 38.44048], [-121.22025, 38.44006], [-121.21964, 38.43942], [-121.21954, 38.43924], [-121.21951, 38.43898], [-121.21963, 38.43889], [-121.21975, 38.43889], [-121.21991, 38.43898], [-121.22013, 38.43921], [-121.22054, 38.43948], [-121.22075, 38.43968], [-121.22107, 38.44003], [-121.22131, 38.44023], [-121.2215, 38.44033], [-121.22166, 38.44034], [-121.22211, 38.44031], [-121.22236, 38.44034], [-121.22272, 38.44034], [-121.22306, 38.4403], [-121.22328, 38.44022], [-121.22356, 38.44006], [-121.2241, 38.43986], [-121.22413, 38.43978], [-121.22409, 38.4397], [-121.224, 38.43964], [-121.22367, 38.43955], [-121.22339, 38.43955], [-121.22304, 38.43959], [-121.22272, 38.4396], [-121.22234, 38.43955], [-121.22181, 38.43943], [-121.22165, 38.43931], [-121.22141, 38.43903], [-121.22119, 38.43864], [-121.22098, 38.43849], [-121.22077, 38.43842], [-121.22022, 38.43828], [-121.22, 38.43813], [-121.21952, 38.43768], [-121.21906, 38.43738], [-121.21873, 38.43708], [-121.21861, 38.43684], [-121.21863, 38.43653], [-121.21878, 38.43618], [-121.21908, 38.43587], [-121.21941, 38.43558], [-121.21998, 38.4353], [-121.22005, 38.43525], [-121.22004, 38.43523], [-121.22007, 38.43523], [-121.22007, 38.43525], [-121.22965, 38.44085]]]]} | Restricted Access 2 | 22225 | Nelson Family Ranch | 22696 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 208.842 | Nelson Family Ranch | 0 | Local Other or Unknown 14 | 4 | |
16844 | 16844 | 16843 | {"type": "MultiPolygon", "coordinates": [[[[-121.49294, 38.45629], [-121.49213, 38.45647], [-121.49218, 38.45685], [-121.48371, 38.45792], [-121.48343, 38.458], [-121.48326, 38.45807], [-121.48306, 38.45818], [-121.4818, 38.45908], [-121.48117, 38.4597], [-121.48029, 38.46047], [-121.47972, 38.46077], [-121.47927, 38.461], [-121.47857, 38.46131], [-121.47809, 38.4615], [-121.4773, 38.46178], [-121.47655, 38.46201], [-121.47578, 38.46221], [-121.47474, 38.46243], [-121.47395, 38.46255], [-121.47315, 38.46264], [-121.47235, 38.4627], [-121.47143, 38.46274], [-121.47143, 38.46429], [-121.4643, 38.46431], [-121.46151, 38.46356], [-121.46101, 38.46008], [-121.46083, 38.46009], [-121.46067, 38.45882], [-121.46014, 38.45435], [-121.46031, 38.45435], [-121.46032, 38.45434], [-121.46011, 38.45253], [-121.46413, 38.45261], [-121.4641, 38.45613], [-121.46411, 38.45633], [-121.46845, 38.45635], [-121.46919, 38.45272], [-121.48258, 38.4528], [-121.48262, 38.4513], [-121.48259, 38.44598], [-121.48252, 38.44596], [-121.48224, 38.44051], [-121.48216, 38.4305], [-121.48752, 38.43049], [-121.48757, 38.43081], [-121.48791, 38.43225], [-121.48817, 38.43318], [-121.48917, 38.4378], [-121.48926, 38.43825], [-121.48937, 38.43912], [-121.48969, 38.43942], [-121.48989, 38.44033], [-121.48966, 38.44049], [-121.49012, 38.44225], [-121.49034, 38.44324], [-121.49017, 38.44322], [-121.49016, 38.44323], [-121.49158, 38.44986], [-121.49215, 38.45374], [-121.49229, 38.4543], [-121.49294, 38.45629]], [[-121.47786, 38.45972], [-121.47805, 38.45971], [-121.47776, 38.45842], [-121.47715, 38.45873], [-121.47632, 38.45909], [-121.47548, 38.45943], [-121.47461, 38.45973], [-121.46443, 38.45973], [-121.46441, 38.46016], [-121.46442, 38.46017], [-121.47461, 38.46018], [-121.47488, 38.46014], [-121.47516, 38.46007], [-121.47552, 38.45992], [-121.47596, 38.45972], [-121.47786, 38.45972]], [[-121.48047, 38.45628], [-121.48046, 38.45626], [-121.47733, 38.45634], [-121.47776, 38.45836], [-121.4782, 38.45812], [-121.4792, 38.45741], [-121.48047, 38.45628]]], [[[-121.46051, 38.46182], [-121.46014, 38.46182], [-121.45754, 38.46232], [-121.451, 38.46543], [-121.44687, 38.46343], [-121.44679, 38.46343], [-121.44671, 38.46232], [-121.44678, 38.46228], [-121.44675, 38.46187], [-121.44667, 38.46183], [-121.44656, 38.46034], [-121.44647, 38.45963], [-121.44654, 38.45958], [-121.44634, 38.4585], [-121.44731, 38.45854], [-121.44732, 38.45853], [-121.44716, 38.45731], [-121.44712, 38.45725], [-121.44609, 38.45726], [-121.44533, 38.45341], [-121.44515, 38.45268], [-121.44508, 38.45233], [-121.44497, 38.45132], [-121.44491, 38.45055], [-121.44486, 38.44945], [-121.44483, 38.44862], [-121.44483, 38.44779], [-121.44485, 38.44644], [-121.44484, 38.44534], [-121.44485, 38.44461], [-121.44489, 38.44394], [-121.44501, 38.44291], [-121.44499, 38.4429], [-121.44517, 38.44141], [-121.44555, 38.43957], [-121.44572, 38.43865], [-121.44619, 38.43587], [-121.44688, 38.43587], [-121.44693, 38.43561], [-121.44692, 38.4356], [-121.44624, 38.4356], [-121.44644, 38.43438], [-121.44647, 38.43433], [-121.44652, 38.43432], [-121.44714, 38.43432], [-121.45009, 38.43424], [-121.45691, 38.43426], [-121.45731, 38.43768], [-121.45766, 38.43769], [-121.45852, 38.44496], [-121.4587, 38.44501], [-121.46046, 38.46011], [-121.46029, 38.46013], [-121.46051, 38.46182]]]]} | Restricted Access 2 | 21778 | Sacramento Regional County Sanitation District | 24767 | 2130 | Sacramento Regional County Sanitation District 583 | Special District 4 | Sanitation District 18 | http://www.srcsd.com/ | Special District 4 | 2130 | Sacramento Regional County Sanitation District 575 | Special District 4 | Sanitation District 19 | Sacramento 41 | 1914.582 | Sacramento Reg. County Sanitation District | 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]);