units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where ACCESS_TYP = 3 and AGNCY_TYP = 3 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7405 | 7405 | 7404 | {"type": "MultiPolygon", "coordinates": [[[[-117.23498, 33.26852], [-117.23496, 33.27233], [-117.23359, 33.27235], [-117.23078, 33.27536], [-117.2318, 33.27604], [-117.23496, 33.27267], [-117.23495, 33.27324], [-117.23464, 33.27384], [-117.23427, 33.27442], [-117.23398, 33.27479], [-117.2335, 33.27532], [-117.23297, 33.2758], [-117.23238, 33.27624], [-117.23175, 33.27664], [-117.23131, 33.27687], [-117.2296, 33.27764], [-117.22894, 33.27798], [-117.22851, 33.27823], [-117.22812, 33.2785], [-117.22775, 33.27877], [-117.2274, 33.27907], [-117.22706, 33.27938], [-117.2263, 33.28031], [-117.22556, 33.28144], [-117.22523, 33.28242], [-117.22503, 33.28174], [-117.22578, 33.27963], [-117.22622, 33.27921], [-117.22623, 33.2761], [-117.22649, 33.2759], [-117.22668, 33.27572], [-117.22705, 33.27529], [-117.22744, 33.27491], [-117.22765, 33.27474], [-117.22792, 33.27457], [-117.22842, 33.27429], [-117.22867, 33.27417], [-117.22899, 33.27408], [-117.22942, 33.27402], [-117.22972, 33.27394], [-117.22985, 33.2739], [-117.23058, 33.27357], [-117.23079, 33.27345], [-117.23183, 33.27282], [-117.23212, 33.27261], [-117.23234, 33.27239], [-117.23282, 33.27179], [-117.23295, 33.27157], [-117.23302, 33.27139], [-117.23305, 33.27113], [-117.23304, 33.27089], [-117.23312, 33.27088], [-117.23313, 33.26857], [-117.23498, 33.26852]]], [[[-117.22101, 33.29299], [-117.22101, 33.29463], [-117.22047, 33.29505], [-117.2195, 33.29631], [-117.21933, 33.29663], [-117.21973, 33.29664], [-117.21935, 33.29772], [-117.21915, 33.29819], [-117.21898, 33.29849], [-117.21878, 33.29877], [-117.21791, 33.29973], [-117.21752, 33.30024], [-117.21752, 33.30028], [-117.21746, 33.30029], [-117.2171, 33.30092], [-117.21714, 33.30094], [-117.21679, 33.30156], [-117.2167, 33.30187], [-117.21659, 33.3021], [-117.21638, 33.30236], [-117.21613, 33.30257], [-117.21582, 33.30273], [-117.21461, 33.3032], [-117.21433, 33.30334], [-117.21402, 33.30354], [-117.21369, 33.3032], [-117.21166, 33.30492], [-117.20899, 33.30653], [-117.20816, 33.30681], [-117.20803, 33.30738], [-117.20798, 33.3074], [-117.208, 33.30742], [-117.20575, 33.30789], [-117.1988, 33.30926], [-117.19536, 33.30995], [-117.19489, 33.31006], [-117.19476, 33.3096], [-117.19539, 33.30858], [-117.19637, 33.308], [-117.19704, 33.30771], [-117.19751, 33.30765], [-117.19807, 33.30773], [-117.19838, 33.30772], [-117.19871, 33.30758], [-117.19925, 33.30719], [-117.1994, 33.30701], [-117.19949, 33.30671], [-117.2, 33.30637], [-117.2002, 33.30614], [-117.20024, 33.30599], [-117.20274, 33.30505], [-117.20322, 33.30471], [-117.20374, 33.30425], [-117.20445, 33.3039], [-117.20626, 33.30282], [-117.20718, 33.30208], [-117.20829, 33.30028], [-117.21061, 33.29909], [-117.21174, 33.29842], [-117.21174, 33.2984], [-117.21162, 33.29828], [-117.2121, 33.29803], [-117.21283, 33.2976], [-117.21304, 33.29744], [-117.21387, 33.29677], [-117.21415, 33.29663], [-117.21459, 33.29651], [-117.21472, 33.29646], [-117.21484, 33.29639], [-117.21517, 33.29616], [-117.21526, 33.29608], [-117.21533, 33.29599], [-117.2154, 33.29588], [-117.21543, 33.29577], [-117.21555, 33.29434], [-117.21563, 33.29409], [-117.21572, 33.29395], [-117.21588, 33.2938], [-117.21658, 33.29325], [-117.2167, 33.29311], [-117.21677, 33.29298], [-117.22101, 33.29299]]], [[[-117.17733, 33.31358], [-117.17383, 33.31428], [-117.16985, 33.3143], [-117.16983, 33.31791], [-117.16585, 33.31793], [-117.16581, 33.31518], [-117.16597, 33.31501], [-117.1661, 33.31492], [-117.16631, 33.31513], [-117.16754, 33.31432], [-117.16932, 33.31297], [-117.17072, 33.31254], [-117.17158, 33.31259], [-117.17432, 33.31214], [-117.17474, 33.31238], [-117.17529, 33.3124], [-117.17733, 33.31358]]]]} | No Public Access 3 | 47590 | San Luis Rey River Park | 31317 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 473.331 | San Luis Rey River Park | 0 | Local Park 2 | 4 | |
7421 | 7421 | 7420 | {"type": "MultiPolygon", "coordinates": [[[[-117.03935, 32.56205], [-117.03896, 32.56244], [-117.03867, 32.56267], [-117.0382, 32.563], [-117.03798, 32.56312], [-117.03799, 32.56315], [-117.03687, 32.56394], [-117.03653, 32.56411], [-117.03624, 32.56419], [-117.03603, 32.56422], [-117.0356, 32.56422], [-117.03527, 32.56414], [-117.03507, 32.56405], [-117.03489, 32.56394], [-117.03478, 32.56389], [-117.03462, 32.56384], [-117.03447, 32.56381], [-117.03419, 32.56381], [-117.0341, 32.56383], [-117.03301, 32.56389], [-117.03268, 32.56395], [-117.03246, 32.56402], [-117.03233, 32.56408], [-117.03243, 32.56189], [-117.03219, 32.55451], [-117.03357, 32.55452], [-117.03369, 32.55819], [-117.03658, 32.55822], [-117.03665, 32.56184], [-117.03935, 32.56184], [-117.03935, 32.56205]], [[-117.03532, 32.56185], [-117.03521, 32.56166], [-117.03511, 32.5616], [-117.03493, 32.56161], [-117.03517, 32.56209], [-117.03524, 32.56207], [-117.0353, 32.56197], [-117.03527, 32.56192], [-117.03532, 32.56185]]], [[[-117.03934, 32.56405], [-117.03934, 32.56405], [-117.03714, 32.56405], [-117.0382, 32.56327], [-117.03934, 32.56308], [-117.03934, 32.56405]]], [[[-117.03935, 32.56227], [-117.03935, 32.56266], [-117.03899, 32.56267], [-117.03898, 32.56259], [-117.03935, 32.56227]]]]} | No Public Access 3 | 47593 | Furby-North Property | 31320 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 89.107 | Furby-North Property | 0 | Local Other or Unknown 14 | 4 | |
7864 | 7864 | 7863 | {"type": "MultiPolygon", "coordinates": [[[[-116.92777, 32.58949], [-116.92777, 32.59228], [-116.92719, 32.59236], [-116.92709, 32.59253], [-116.92678, 32.59284], [-116.92635, 32.59308], [-116.92611, 32.59314], [-116.92622, 32.59232], [-116.92562, 32.59183], [-116.92563, 32.5918], [-116.92293, 32.5893], [-116.92211, 32.58875], [-116.92204, 32.58879], [-116.92131, 32.58828], [-116.91987, 32.58695], [-116.91737, 32.58824], [-116.91724, 32.58868], [-116.91579, 32.58965], [-116.91571, 32.59019], [-116.91743, 32.59146], [-116.92026, 32.59141], [-116.92062, 32.59165], [-116.92179, 32.59313], [-116.92285, 32.59318], [-116.92318, 32.59348], [-116.92371, 32.5935], [-116.92369, 32.59353], [-116.92526, 32.595], [-116.92514, 32.59515], [-116.92556, 32.59554], [-116.92582, 32.59535], [-116.92587, 32.59561], [-116.92593, 32.59573], [-116.92601, 32.59583], [-116.92635, 32.59609], [-116.9266, 32.5963], [-116.92681, 32.59658], [-116.92695, 32.59689], [-116.91079, 32.59702], [-116.9107, 32.59326], [-116.9129, 32.59324], [-116.91243, 32.59374], [-116.91342, 32.59443], [-116.91457, 32.59326], [-116.91516, 32.59328], [-116.91548, 32.5923], [-116.91619, 32.5921], [-116.91584, 32.59121], [-116.91508, 32.59097], [-116.91467, 32.59137], [-116.9128, 32.59139], [-116.91275, 32.58957], [-116.91061, 32.58958], [-116.91052, 32.58587], [-116.91906, 32.5858], [-116.92128, 32.5858], [-116.92129, 32.58715], [-116.92666, 32.58812], [-116.92777, 32.58949]]], [[[-116.92994, 32.59688], [-116.92778, 32.59688], [-116.92778, 32.59585], [-116.92807, 32.5955], [-116.92806, 32.59492], [-116.92993, 32.59491], [-116.92994, 32.59688]]], [[[-116.98385, 32.58252], [-116.97937, 32.58383], [-116.97937, 32.58383], [-116.97936, 32.5825], [-116.98385, 32.58252]]]]} | No Public Access 3 | 47717 | Otay Valley Regional Park | 31497 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.ovrp.org/ | San Diego 4 | 324.329 | Otay Valley RP | 0 | Local Park 2 | 4 |
12242 | 12242 | 12241 | {"type": "MultiPolygon", "coordinates": [[[[-117.18634, 33.08768], [-117.18422, 33.08768], [-117.18424, 33.08862], [-117.1842, 33.09134], [-117.18211, 33.09133], [-117.18197, 33.09493], [-117.17742, 33.09493], [-117.17755, 33.08762], [-117.17527, 33.08759], [-117.17541, 33.08587], [-117.17429, 33.08585], [-117.17445, 33.08402], [-117.17778, 33.08404], [-117.17803, 33.08039], [-117.17905, 33.08039], [-117.18143, 33.08206], [-117.18122, 33.08316], [-117.17997, 33.08494], [-117.1802, 33.08476], [-117.18126, 33.08458], [-117.18138, 33.08479], [-117.18209, 33.08429], [-117.1826, 33.08426], [-117.1827, 33.08451], [-117.18264, 33.08506], [-117.18284, 33.08558], [-117.18309, 33.08538], [-117.18327, 33.08488], [-117.18313, 33.08447], [-117.18316, 33.08417], [-117.18324, 33.08408], [-117.18445, 33.08407], [-117.18504, 33.08445], [-117.18538, 33.08469], [-117.18565, 33.08491], [-117.18581, 33.08507], [-117.18633, 33.08568], [-117.18634, 33.08768]]], [[[-117.18635, 33.08529], [-117.186, 33.08489], [-117.18581, 33.08472], [-117.18524, 33.08429], [-117.18491, 33.08407], [-117.18633, 33.08407], [-117.18635, 33.08529]]]]} | No Public Access 3 | 25447 | Sage Hill Preserve | 29254 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 231.523 | Sage Hill Preserve | 0 | Local Conservation Area 4 | 2 | |
13225 | 13225 | 13224 | {"type": "Polygon", "coordinates": [[[-117.12022, 33.25594], [-117.11798, 33.25608], [-117.11133, 33.25648], [-117.11148, 33.25634], [-117.11161, 33.25629], [-117.11177, 33.25622], [-117.11191, 33.25612], [-117.11201, 33.25602], [-117.11211, 33.256], [-117.11224, 33.25577], [-117.11221, 33.25567], [-117.11279, 33.25455], [-117.11293, 33.25435], [-117.11314, 33.25414], [-117.11321, 33.25417], [-117.11343, 33.25402], [-117.11339, 33.25397], [-117.11357, 33.25388], [-117.11582, 33.25311], [-117.1161, 33.25299], [-117.11637, 33.25284], [-117.12005, 33.2528], [-117.12022, 33.25594]]]} | No Public Access 3 | 45242 | Old Castle Mitigation Area | 23082 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 58.565 | Old Castle Mitigation Area | 0 | Local Other or Unknown 14 | 4 | |
14553 | 14553 | 14552 | {"type": "Polygon", "coordinates": [[[-117.142, 33.36266], [-117.14183, 33.36576], [-117.13969, 33.36579], [-117.13986, 33.36259], [-117.142, 33.36266]]]} | No Public Access 3 | 45226 | Pala Mesa Mitigation Property | 29252 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 17.191 | Pala Mesa Mitigation Property | 0 | Local Other or Unknown 14 | 4 | |
14610 | 14610 | 14609 | {"type": "MultiPolygon", "coordinates": [[[[-117.18723, 33.06546], [-117.18548, 33.06687], [-117.18548, 33.06687], [-117.1855, 33.06545], [-117.18723, 33.06546]]], [[[-117.19071, 33.0655], [-117.18965, 33.06846], [-117.18937, 33.06842], [-117.18924, 33.06843], [-117.18905, 33.06849], [-117.18895, 33.06856], [-117.18842, 33.06661], [-117.18836, 33.06649], [-117.18808, 33.06547], [-117.19071, 33.0655]]], [[[-117.18728, 33.0727], [-117.1848, 33.07266], [-117.18489, 33.07234], [-117.18501, 33.07155], [-117.18506, 33.0713], [-117.18494, 33.07096], [-117.18482, 33.07042], [-117.18453, 33.06973], [-117.18441, 33.06953], [-117.18417, 33.06924], [-117.18403, 33.06917], [-117.18387, 33.06916], [-117.18385, 33.0691], [-117.18541, 33.06911], [-117.18638, 33.06908], [-117.18726, 33.06908], [-117.18728, 33.0727]]], [[[-117.17423, 33.07671], [-117.17417, 33.0784], [-117.17415, 33.07845], [-117.17348, 33.07833], [-117.17312, 33.0783], [-117.17248, 33.07829], [-117.17227, 33.07826], [-117.17207, 33.0782], [-117.17154, 33.07797], [-117.17111, 33.07773], [-117.17073, 33.07743], [-117.16999, 33.07663], [-117.17001, 33.07636], [-117.17294, 33.07642], [-117.17294, 33.0767], [-117.17423, 33.07671]]], [[[-117.19572, 33.07672], [-117.1957, 33.0794], [-117.19324, 33.07923], [-117.19334, 33.07904], [-117.19314, 33.07854], [-117.19205, 33.07829], [-117.19191, 33.07822], [-117.19179, 33.07814], [-117.19161, 33.07794], [-117.19153, 33.07779], [-117.19149, 33.07761], [-117.19143, 33.0776], [-117.19146, 33.07717], [-117.19145, 33.07663], [-117.18855, 33.07658], [-117.18857, 33.07545], [-117.19146, 33.07551], [-117.19146, 33.07663], [-117.19572, 33.07672]]], [[[-117.17416, 33.07869], [-117.17408, 33.08036], [-117.16976, 33.08034], [-117.16984, 33.07885], [-117.16998, 33.07701], [-117.17052, 33.07759], [-117.17088, 33.07786], [-117.17113, 33.07803], [-117.1714, 33.07817], [-117.17195, 33.07841], [-117.17216, 33.07848], [-117.17237, 33.07851], [-117.17326, 33.07855], [-117.1736, 33.07859], [-117.17416, 33.07869]]], [[[-117.15319, 33.08571], [-117.15294, 33.08582], [-117.15251, 33.08596], [-117.15219, 33.08602], [-117.15183, 33.08606], [-117.15133, 33.08605], [-117.14956, 33.08587], [-117.14844, 33.0858], [-117.14823, 33.0858], [-117.14805, 33.08584], [-117.14803, 33.08027], [-117.15231, 33.08034], [-117.15223, 33.08571], [-117.15319, 33.08571]]], [[[-117.14475, 33.08745], [-117.1439, 33.08753], [-117.1439, 33.08753], [-117.1439, 33.08751], [-117.14394, 33.08751], [-117.14414, 33.08745], [-117.14475, 33.08745]]], [[[-117.15649, 33.08564], [-117.15649, 33.08741], [-117.15009, 33.08746], [-117.15012, 33.08937], [-117.14806, 33.0894], [-117.14808, 33.09109], [-117.1522, 33.09107], [-117.15221, 33.09471], [-117.1507, 33.09472], [-117.15069, 33.09473], [-117.1529, 33.09685], [-117.1533, 33.09789], [-117.15372, 33.09849], [-117.15353, 33.09873], [-117.15287, 33.09997], [-117.15245, 33.10051], [-117.15247, 33.10086], [-117.15329, 33.10166], [-117.15378, 33.10215], [-117.15386, 33.10237], [-117.15388, 33.10252], [-117.15386, 33.10266], [-117.15379, 33.10284], [-117.15365, 33.10304], [-117.15361, 33.10318], [-117.15363, 33.10332], [-117.15381, 33.10356], [-117.15382, 33.10365], [-117.15376, 33.10382], [-117.15357, 33.10398], [-117.15352, 33.10411], [-117.15351, 33.10421], [-117.15356, 33.10433], [-117.1537, 33.10449], [-117.15383, 33.10459], [-117.15398, 33.10468], [-117.15435, 33.10482], [-117.15455, 33.10504], [-117.15475, 33.10519], [-117.15482, 33.1053], [-117.15484, 33.10539], [-117.15488, 33.10548], [-117.15495, 33.10555], [-117.15522, 33.10568], [-117.15528, 33.10574], [-117.15536, 33.10597], [-117.15542, 33.10607], [-117.15567, 33.10631], [-117.15573, 33.10641], [-117.1558, 33.10661], [-117.15591, 33.10672], [-117.156, 33.10677], [-117.15617, 33.10681], [-117.15621, 33.10686], [-117.15622, 33.10691], [-117.1562, 33.10696], [-117.15615, 33.10699], [-117.15615, 33.10711], [-117.15609, 33.10712], [-117.15602, 33.10951], [-117.15534, 33.10922], [-117.15424, 33.10859], [-117.15415, 33.1086], [-117.15418, 33.10894], [-117.15418, 33.11015], [-117.15412, 33.11003], [-117.15402, 33.10997], [-117.15375, 33.1091], [-117.15355, 33.10862], [-117.1534, 33.10836], [-117.15337, 33.10821], [-117.1534, 33.10809], [-117.15344, 33.10805], [-117.15356, 33.10797], [-117.15383, 33.10784], [-117.15404, 33.10777], [-117.15451, 33.10766], [-117.15487, 33.10749], [-117.15514, 33.10743], [-117.15544, 33.10728], [-117.15566, 33.10722], [-117.15596, 33.10708], [-117.15596, 33.10706], [-117.15425, 33.10641], [-117.15282, 33.10651], [-117.15056, 33.10608], [-117.14915, 33.10526], [-117.14816, 33.10531], [-117.14802, 33.09843], [-117.13961, 33.09842], [-117.13962, 33.09474], [-117.14391, 33.09473], [-117.14393, 33.09378], [-117.1439, 33.09109], [-117.1396, 33.09109], [-117.13961, 33.09282], [-117.13652, 33.09281], [-117.13649, 33.0927], [-117.13649, 33.09251], [-117.13651, 33.0923], [-117.13645, 33.09202], [-117.13643, 33.09161], [-117.13651, 33.09136], [-117.13665, 33.0911], [-117.13685, 33.09077], [-117.13738, 33.09003], [-117.13755, 33.08972], [-117.13766, 33.08945], [-117.13778, 33.08925], [-117.13793, 33.08906], [-117.13802, 33.08897], [-117.13817, 33.08887], [-117.13835, 33.08879], [-117.13851, 33.08877], [-117.1387, 33.08878], [-117.13924, 33.08898], [-117.13943, 33.08902], [-117.13959, 33.08903], [-117.1396, 33.08909], [-117.14002, 33.08903], [-117.1404, 33.08901], [-117.14066, 33.08897], [-117.14123, 33.08882], [-117.14372, 33.08787], [-117.14407, 33.08772], [-117.14433, 33.08764], [-117.14518, 33.08757], [-117.14537, 33.08753], [-117.14561, 33.08744], [-117.148, 33.08744], [-117.14801, 33.08748], [-117.14803, 33.08747], [-117.14806, 33.08608], [-117.14818, 33.08605], [-117.1483, 33.08603], [-117.14876, 33.08605], [-117.14953, 33.08611], [-117.1514, 33.0863], [-117.15187, 33.08631], [-117.15239, 33.08624], [-117.15292, 33.0861], [-117.15339, 33.08588], [-117.15366, 33.0857], [-117.15649, 33.08564]]]]} | No Public Access 3 | 44822 | Escondido Creek Preserve | 29232 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 625.018 | Escondido Creek Preserve | 0 | Local Conservation Area 4 | 2 | |
15149 | 15149 | 15148 | {"type": "Polygon", "coordinates": [[[-117.22985, 33.12069], [-117.22559, 33.1207], [-117.22559, 33.12034], [-117.22632, 33.12033], [-117.2275, 33.11994], [-117.22846, 33.11978], [-117.22826, 33.11881], [-117.22822, 33.11871], [-117.2277, 33.11842], [-117.22665, 33.11804], [-117.22645, 33.11788], [-117.2261, 33.1179], [-117.22608, 33.1176], [-117.22604, 33.11748], [-117.22594, 33.11732], [-117.22574, 33.11714], [-117.22573, 33.11712], [-117.22574, 33.11708], [-117.22579, 33.11704], [-117.22666, 33.11703], [-117.22668, 33.11773], [-117.22982, 33.11772], [-117.22985, 33.12069]]]} | No Public Access 3 | 45992 | Diamond Trail | 29166 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/content/dam/sdc/dpw/WATERSHED_PROTECTION_PROGRAM/Pacific%20Watersheds.pdf | San Diego 4 | 19.749 | Diamond Trail | 0 | Local Recreation Area 3 | 4 |
9975 | 9975 | 9974 | {"type": "Polygon", "coordinates": [[[-122.11034, 37.25814], [-122.1099, 37.25831], [-122.10963, 37.25848], [-122.10956, 37.25855], [-122.10952, 37.25863], [-122.10951, 37.25873], [-122.10953, 37.25882], [-122.10846, 37.25883], [-122.10844, 37.25755], [-122.11032, 37.25756], [-122.11034, 37.25814]]]} | No Public Access 3 | 47967 | Saratoga Gap Open Space Preserve | 31468 | 373 | Santa Clara, County of 941 | County 3 | County Agency 3 | http://www.sccgov.org/sites/scc/Pages/default.aspx | County 3 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_saratoga_gap.asp | Santa Clara 19 | 4.827 | Saratoga Gap OSP | 2006 | Local Conservation Area 4 | 2 |
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]);