superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
102 rows where ACCESS_TYP = 1, MNG_AGENCY = 101 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- County Agency · 102 ✖
MNG_AGENCY 1
- San Diego, County of · 102 ✖
ACCESS_TYP 1
- Open Access · 102 ✖
| Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 746 | 746 | 745 | {"type": "Polygon", "coordinates": [[[-116.60586, 33.035], [-116.60569, 33.04233], [-116.60489, 33.0424], [-116.60129, 33.04245], [-116.60127, 33.04251], [-116.60002, 33.04253], [-116.5987, 33.0425], [-116.59842, 33.04233], [-116.59829, 33.04218], [-116.59813, 33.04195], [-116.59794, 33.04155], [-116.59784, 33.04137], [-116.59773, 33.04123], [-116.59756, 33.04106], [-116.59713, 33.04074], [-116.59715, 33.03891], [-116.5931, 33.03889], [-116.59286, 33.03891], [-116.59281, 33.0403], [-116.59279, 33.04249], [-116.58846, 33.0425], [-116.58844, 33.04973], [-116.5842, 33.04971], [-116.58417, 33.05062], [-116.57558, 33.05059], [-116.57561, 33.04971], [-116.57569, 33.04969], [-116.57555, 33.04248], [-116.58428, 33.04247], [-116.58426, 33.03633], [-116.58423, 33.03631], [-116.58416, 33.02825], [-116.58831, 33.02827], [-116.59249, 33.02826], [-116.59259, 33.02535], [-116.59252, 33.02528], [-116.59264, 33.02518], [-116.59278, 33.02511], [-116.59294, 33.02507], [-116.59311, 33.02506], [-116.59328, 33.02508], [-116.59344, 33.02513], [-116.59395, 33.02547], [-116.59409, 33.02551], [-116.59424, 33.02553], [-116.59439, 33.02552], [-116.59468, 33.02542], [-116.59704, 33.02542], [-116.59708, 33.02825], [-116.6015, 33.0282], [-116.60473, 33.02811], [-116.60482, 33.03498], [-116.60586, 33.035]], [[-116.58846, 33.0389], [-116.58852, 33.03727], [-116.58789, 33.03725], [-116.58785, 33.03796], [-116.58784, 33.03889], [-116.58846, 33.0389]], [[-116.5927, 33.03902], [-116.59271, 33.03901], [-116.59268, 33.03895], [-116.59071, 33.03894], [-116.58907, 33.03896], [-116.58908, 33.03902], [-116.5927, 33.03902]]]} | Open Access 1 | William Heise County Park | http://www.sdparks.org/content/sdparks/en/park-pages/WilliamHeise.html | 10697 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 1012.584 | William Heise County Park | |
| 935 | 935 | 934 | {"type": "Polygon", "coordinates": [[[-116.55091, 32.68226], [-116.5509, 32.68904], [-116.54671, 32.68904], [-116.54666, 32.69624], [-116.54247, 32.69617], [-116.54246, 32.69264], [-116.53813, 32.69259], [-116.53814, 32.68901], [-116.53405, 32.68894], [-116.53398, 32.69617], [-116.53815, 32.6962], [-116.53809, 32.71037], [-116.53398, 32.71042], [-116.53382, 32.71605], [-116.53385, 32.72189], [-116.52947, 32.72189], [-116.52952, 32.72556], [-116.52511, 32.72556], [-116.52519, 32.71823], [-116.52073, 32.71818], [-116.52069, 32.71598], [-116.52076, 32.7146], [-116.51671, 32.71461], [-116.51659, 32.70729], [-116.50785, 32.70736], [-116.50786, 32.71104], [-116.50351, 32.71109], [-116.5035, 32.71481], [-116.49896, 32.71499], [-116.4951, 32.71505], [-116.4951, 32.71112], [-116.49937, 32.71107], [-116.49957, 32.6966], [-116.50366, 32.69661], [-116.50365, 32.70018], [-116.50784, 32.70019], [-116.508, 32.69288], [-116.51156, 32.6929], [-116.51245, 32.69289], [-116.51259, 32.68983], [-116.51262, 32.68937], [-116.51405, 32.68937], [-116.51423, 32.68936], [-116.51428, 32.6885], [-116.51486, 32.68808], [-116.51478, 32.68764], [-116.51501, 32.68739], [-116.515, 32.68715], [-116.51517, 32.68685], [-116.51506, 32.68635], [-116.51528, 32.68609], [-116.51576, 32.68605], [-116.51581, 32.68606], [-116.51608, 32.68574], [-116.51671, 32.68595], [-116.51671, 32.68474], [-116.51678, 32.68255], [-116.51675, 32.68254], [-116.51675, 32.68218], [-116.52375, 32.68219], [-116.52542, 32.68216], [-116.52542, 32.67813], [-116.53398, 32.67817], [-116.534, 32.67113], [-116.53823, 32.67113], [-116.5382, 32.67463], [-116.54239, 32.67461], [-116.54239, 32.67816], [-116.54667, 32.67819], [-116.5467, 32.68224], [-116.55091, 32.68226]], [[-116.534, 32.67817], [-116.53399, 32.67819], [-116.53399, 32.68218], [-116.53813, 32.68223], [-116.53816, 32.6782], [-116.534, 32.67817]]]} | Open Access 1 | Lake Morena County Park | http://www.sdparks.org/content/sdparks/en/park-pages/LakeMorena.html | 10398 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 3279.849 | Lake Morena County Park | |
| 965 | 965 | 964 | {"type": "MultiPolygon", "coordinates": [[[[-117.14805, 33.08584], [-117.14789, 33.0859], [-117.14775, 33.08597], [-117.14704, 33.08645], [-117.14671, 33.08662], [-117.14508, 33.08436], [-117.13959, 33.08443], [-117.13958, 33.08754], [-117.13651, 33.08756], [-117.12968, 33.08756], [-117.12962, 33.09117], [-117.12315, 33.09115], [-117.12313, 33.08756], [-117.11888, 33.08755], [-117.11889, 33.08746], [-117.11885, 33.08602], [-117.1189, 33.08492], [-117.11888, 33.08399], [-117.11911, 33.08376], [-117.11916, 33.08376], [-117.11941, 33.08345], [-117.11939, 33.08342], [-117.1194, 33.08339], [-117.11947, 33.0833], [-117.11965, 33.083], [-117.11982, 33.08265], [-117.11992, 33.08237], [-117.12041, 33.08055], [-117.12047, 33.08025], [-117.12056, 33.07972], [-117.12075, 33.0797], [-117.12076, 33.07899], [-117.12108, 33.07897], [-117.12106, 33.07836], [-117.12084, 33.07835], [-117.1211, 33.07661], [-117.12112, 33.07652], [-117.12116, 33.07651], [-117.1212, 33.07624], [-117.12126, 33.07623], [-117.12135, 33.07562], [-117.12131, 33.0756], [-117.12133, 33.07548], [-117.1213, 33.07546], [-117.12141, 33.07449], [-117.12151, 33.07448], [-117.1219, 33.07199], [-117.12179, 33.07194], [-117.12245, 33.06783], [-117.12255, 33.06781], [-117.12257, 33.06766], [-117.12265, 33.06739], [-117.12276, 33.06717], [-117.12289, 33.06695], [-117.12283, 33.06691], [-117.1229, 33.06681], [-117.12305, 33.06665], [-117.12318, 33.06653], [-117.12349, 33.06632], [-117.12368, 33.06617], [-117.12387, 33.06596], [-117.12401, 33.06571], [-117.12412, 33.0657], [-117.12411, 33.06544], [-117.12415, 33.06518], [-117.12415, 33.06479], [-117.12423, 33.06438], [-117.12603, 33.06455], [-117.12788, 33.06455], [-117.12813, 33.06459], [-117.12826, 33.0646], [-117.12862, 33.06454], [-117.12897, 33.06451], [-117.12907, 33.06454], [-117.12925, 33.06468], [-117.12939, 33.06474], [-117.12952, 33.06476], [-117.1298, 33.06476], [-117.13004, 33.06483], [-117.13017, 33.06485], [-117.1304, 33.06485], [-117.13053, 33.06486], [-117.13064, 33.0649], [-117.13091, 33.06506], [-117.12933, 33.06755], [-117.1271, 33.06757], [-117.12711, 33.07295], [-117.12719, 33.08019], [-117.13631, 33.08017], [-117.13631, 33.08116], [-117.13629, 33.08152], [-117.13634, 33.08392], [-117.13957, 33.0839], [-117.13955, 33.08019], [-117.14401, 33.08032], [-117.14803, 33.08027], [-117.14803, 33.08388], [-117.14805, 33.08584]]], [[[-117.13193, 33.06024], [-117.1319, 33.06349], [-117.13096, 33.06498], [-117.13069, 33.06483], [-117.13055, 33.06478], [-117.13042, 33.06477], [-117.1302, 33.06477], [-117.13005, 33.06475], [-117.1298, 33.06467], [-117.12954, 33.06467], [-117.12941, 33.06466], [-117.12927, 33.06459], [-117.12914, 33.06448], [-117.129, 33.06443], [-117.12886, 33.06443], [-117.12866, 33.06445], [-117.12833, 33.06451], [-117.12823, 33.06452], [-117.12769, 33.06443], [-117.12734, 33.0643], [-117.12689, 33.06409], [-117.12647, 33.06398], [-117.12639, 33.06391], [-117.12638, 33.06383], [-117.12642, 33.06376], [-117.12671, 33.06361], [-117.1268, 33.06353], [-117.12685, 33.06344], [-117.12688, 33.06336], [-117.12692, 33.0627], [-117.12709, 33.06259], [-117.12723, 33.06248], [-117.12759, 33.06209], [-117.12771, 33.06199], [-117.12786, 33.06191], [-117.12802, 33.06185], [-117.12849, 33.06178], [-117.12867, 33.06172], [-117.12883, 33.06164], [-117.12904, 33.06148], [-117.12933, 33.06112], [-117.12945, 33.06102], [-117.12965, 33.06092], [-117.13193, 33.06024]]]]} | Open Access 1 | Del Dios Highlands Preserve | http://www.sdparks.org/content/sdparks/en/park-pages/DelDiosHighlands.html | 10675 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 781.925 | Del Dios Highlands Preserve | |
| 979 | 979 | 978 | {"type": "MultiPolygon", "coordinates": [[[[-116.92352, 32.60821], [-116.9235, 32.61195], [-116.91216, 32.61202], [-116.91079, 32.61199], [-116.91094, 32.61568], [-116.90658, 32.61568], [-116.90666, 32.61927], [-116.90219, 32.61927], [-116.90214, 32.61198], [-116.91077, 32.61198], [-116.9108, 32.60449], [-116.91928, 32.60446], [-116.91928, 32.6082], [-116.92352, 32.60821]]], [[[-116.91632, 32.65562], [-116.91629, 32.65938], [-116.91356, 32.65931], [-116.91311, 32.65864], [-116.91287, 32.65836], [-116.91254, 32.65791], [-116.91207, 32.65716], [-116.91169, 32.65659], [-116.91154, 32.65645], [-116.91128, 32.65626], [-116.91056, 32.65556], [-116.91239, 32.65554], [-116.91632, 32.65562]]]]} | Open Access 1 | Otay Ranch Preserve | http://www.sandiegocounty.gov/pds/mscp/or.html | 10734 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 369.026 | Otay Ranch Preserve | |
| 1740 | 1740 | 1739 | {"type": "Polygon", "coordinates": [[[-117.00133, 32.74581], [-117.00084, 32.74581], [-117.00082, 32.74585], [-117.00087, 32.74595], [-117.00053, 32.74629], [-117.00034, 32.74616], [-117.00008, 32.74645], [-116.99996, 32.74633], [-116.99954, 32.74618], [-116.99953, 32.74531], [-117.00019, 32.74531], [-117.00021, 32.74539], [-117.00066, 32.74538], [-117.00066, 32.74515], [-117.00083, 32.74497], [-117.00083, 32.74462], [-117.00132, 32.74461], [-117.00133, 32.74581]]]} | Open Access 1 | Bancroft Park | http://www.sdparks.org/content/sdparks/en/park-pages/Bancroft.html | 15792 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 4.682 | Bancroft Park | |
| 2432 | 2432 | 2431 | {"type": "Polygon", "coordinates": [[[-116.86232, 33.04283], [-116.86091, 33.04362], [-116.85968, 33.04204], [-116.8611, 33.04126], [-116.86164, 33.04196], [-116.86162, 33.04199], [-116.86171, 33.0421], [-116.86175, 33.04209], [-116.86232, 33.04283]]]} | Open Access 1 | Collier Park | http://www.sdparks.org/content/sdparks/en/park-pages/Collier.html | 17519 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 8.145 | Collier Park | |
| 2468 | 2468 | 2467 | {"type": "MultiPolygon", "coordinates": [[[[-116.91484, 32.86884], [-116.91485, 32.87034], [-116.91482, 32.87063], [-116.91469, 32.87097], [-116.91454, 32.87121], [-116.91438, 32.87142], [-116.91412, 32.87164], [-116.91342, 32.87076], [-116.91262, 32.87037], [-116.91096, 32.87045], [-116.91023, 32.86652], [-116.91402, 32.86599], [-116.91456, 32.86881], [-116.91484, 32.86884]]], [[[-116.91825, 32.86993], [-116.91733, 32.87197], [-116.91627, 32.87239], [-116.91504, 32.87239], [-116.91426, 32.87179], [-116.91425, 32.87177], [-116.91446, 32.87159], [-116.91462, 32.87141], [-116.91477, 32.8712], [-116.91487, 32.87103], [-116.91497, 32.87078], [-116.91502, 32.87058], [-116.91505, 32.87035], [-116.91505, 32.8701], [-116.91599, 32.87019], [-116.91532, 32.87033], [-116.91537, 32.87051], [-116.91825, 32.86993]]]]} | Open Access 1 | Cactus Park | http://www.sdparks.org/content/sdparks/en/park-pages/Cactus.html | 16651 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 61.045 | Cactus Park | |
| 3416 | 3416 | 3415 | {"type": "Polygon", "coordinates": [[[-116.94512, 32.75532], [-116.94511, 32.75706], [-116.94501, 32.75707], [-116.94501, 32.75859], [-116.94202, 32.75855], [-116.94197, 32.75818], [-116.94278, 32.7581], [-116.94286, 32.75813], [-116.94294, 32.75812], [-116.94301, 32.75808], [-116.94303, 32.75805], [-116.94303, 32.758], [-116.94301, 32.75794], [-116.94294, 32.75789], [-116.94297, 32.75782], [-116.94254, 32.75688], [-116.94212, 32.75672], [-116.94171, 32.75665], [-116.94122, 32.7557], [-116.94096, 32.75447], [-116.94109, 32.75444], [-116.94116, 32.75429], [-116.94128, 32.75428], [-116.94133, 32.75425], [-116.94136, 32.7542], [-116.94165, 32.75423], [-116.94281, 32.75501], [-116.94286, 32.75503], [-116.94512, 32.75532]]]} | Open Access 1 | Damon Lane Park | http://www.sdparks.org/content/sdparks/en/park-pages/DamonLane.html | 17902 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 29.503 | Damon Lane Park | |
| 3536 | 3536 | 3535 | {"type": "Polygon", "coordinates": [[[-116.9683, 32.73338], [-116.9683, 32.73465], [-116.96616, 32.73505], [-116.9659, 32.73378], [-116.96607, 32.73381], [-116.96615, 32.73378], [-116.96617, 32.73375], [-116.96619, 32.73366], [-116.96614, 32.73359], [-116.96606, 32.73356], [-116.96598, 32.73356], [-116.96587, 32.73363], [-116.96582, 32.73336], [-116.9683, 32.73338]]]} | Open Access 1 | Del Parque Park | 18044 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 8.751 | Del Parque Park | ||
| 3652 | 3652 | 3651 | {"type": "Polygon", "coordinates": [[[-117.25791, 33.37491], [-117.25791, 33.37556], [-117.25754, 33.37556], [-117.25754, 33.3752], [-117.25724, 33.37489], [-117.25791, 33.37491]]]} | Open Access 1 | Don Dussault Park | http://www.sdparks.org/content/sdparks/en/park-pages/DonDussault.html | 18203 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 0.746 | Don Dussault Park | |
| 3669 | 3669 | 3668 | {"type": "Polygon", "coordinates": [[[-116.94463, 32.99593], [-116.94441, 32.9987], [-116.94439, 32.99875], [-116.94439, 32.99899], [-116.94433, 32.9996], [-116.94028, 32.99968], [-116.93617, 32.99969], [-116.93612, 32.99608], [-116.94463, 32.99593]]]} | Open Access 1 | Dos Picos Park | http://www.sdparks.org/content/sdparks/en/park-pages/DosPicos.html | 18228 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 78.101 | Dos Picos Park | |
| 3904 | 3904 | 3903 | {"type": "MultiPolygon", "coordinates": [[[[-116.85271, 32.89302], [-116.85016, 32.89317], [-116.85013, 32.89281], [-116.84423, 32.89275], [-116.84295, 32.89205], [-116.84351, 32.8922], [-116.84518, 32.89238], [-116.84573, 32.89242], [-116.84616, 32.89241], [-116.84661, 32.89238], [-116.84788, 32.89222], [-116.8482, 32.89215], [-116.8485, 32.89204], [-116.84878, 32.89189], [-116.84902, 32.89172], [-116.84923, 32.89151], [-116.84936, 32.89135], [-116.84947, 32.89115], [-116.84995, 32.89012], [-116.85271, 32.89302]]], [[[-116.85018, 32.88908], [-116.85003, 32.88947], [-116.84931, 32.89106], [-116.84922, 32.89122], [-116.84905, 32.89144], [-116.84886, 32.89162], [-116.84863, 32.89178], [-116.8484, 32.8919], [-116.84815, 32.89199], [-116.84785, 32.89205], [-116.8466, 32.89221], [-116.846, 32.89225], [-116.84526, 32.89223], [-116.84343, 32.89201], [-116.84478, 32.88919], [-116.84558, 32.8872], [-116.84609, 32.88674], [-116.84638, 32.88601], [-116.84995, 32.88843], [-116.85002, 32.8885], [-116.85007, 32.88858], [-116.85018, 32.88908]]]]} | Open Access 1 | El Monte Park | http://www.sdparks.org/content/sdparks/en/park-pages/ElMonte.html | 18518 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 87.508 | El Monte Park | |
| 4082 | 4082 | 4081 | {"type": "Polygon", "coordinates": [[[-117.00204, 32.76133], [-117.00199, 32.76124], [-117.00192, 32.76106], [-117.00179, 32.76094], [-117.00165, 32.76087], [-117.00111, 32.76077], [-117.00098, 32.76071], [-117.00094, 32.76067], [-117.0009, 32.76055], [-117.00108, 32.76046], [-117.00102, 32.76025], [-117.00045, 32.75882], [-117.00166, 32.75882], [-117.00223, 32.76019], [-117.00229, 32.76049], [-117.00228, 32.76074], [-117.00221, 32.76103], [-117.0021, 32.76124], [-117.00204, 32.76133]]]} | Open Access 1 | Eucalyptus Park | http://www.sdparks.org/content/sdparks/en/park-pages/Eucalyptus.html | 18739 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 6.739 | Eucalyptus Park | |
| 4152 | 4152 | 4151 | {"type": "Polygon", "coordinates": [[[-116.92544, 32.74521], [-116.92529, 32.74527], [-116.92388, 32.74556], [-116.92186, 32.74538], [-116.92193, 32.7451], [-116.92209, 32.74475], [-116.92224, 32.74452], [-116.9224, 32.74436], [-116.92264, 32.74419], [-116.9229, 32.74407], [-116.92313, 32.74401], [-116.92344, 32.74397], [-116.92381, 32.744], [-116.92395, 32.74404], [-116.92412, 32.74409], [-116.92441, 32.74424], [-116.92459, 32.74438], [-116.92544, 32.74521]]]} | Open Access 1 | Hilton Head Park | http://www.sdparks.org/content/sdparks/en/park-pages/HiltonHead.html | 19997 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 9.881 | Hilton Head Park | |
| 4199 | 4199 | 4198 | {"type": "Polygon", "coordinates": [[[-117.08786, 33.07997], [-117.08663, 33.08481], [-117.0855, 33.08398], [-117.08509, 33.08399], [-117.08483, 33.08422], [-117.08478, 33.08422], [-117.08463, 33.08428], [-117.0845, 33.08425], [-117.08444, 33.08419], [-117.08339, 33.0828], [-117.08329, 33.08262], [-117.08314, 33.08231], [-117.083, 33.08184], [-117.08296, 33.08162], [-117.08294, 33.08128], [-117.08302, 33.08086], [-117.08394, 33.08103], [-117.084, 33.08092], [-117.08399, 33.0809], [-117.08305, 33.08074], [-117.0832, 33.08033], [-117.08426, 33.07827], [-117.08433, 33.07802], [-117.0844, 33.07797], [-117.08441, 33.07795], [-117.08443, 33.07795], [-117.08542, 33.07814], [-117.08571, 33.07944], [-117.08628, 33.07986], [-117.08671, 33.07998], [-117.08786, 33.07997]]]} | Open Access 1 | Felicita Park | http://www.sdparks.org/content/sdparks/en/park-pages/Felicita.html | 18866 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 51.882 | Felicita Park | |
| 4262 | 4262 | 4261 | {"type": "Polygon", "coordinates": [[[-116.86437, 32.84792], [-116.86395, 32.84801], [-116.86323, 32.84819], [-116.86121, 32.84874], [-116.86081, 32.84886], [-116.86032, 32.84905], [-116.85989, 32.84924], [-116.85946, 32.84947], [-116.85905, 32.84973], [-116.85909, 32.84962], [-116.85783, 32.84868], [-116.85712, 32.84965], [-116.85469, 32.84965], [-116.85468, 32.8487], [-116.85753, 32.84505], [-116.86185, 32.84502], [-116.86186, 32.845], [-116.86171, 32.84478], [-116.8618, 32.84476], [-116.86312, 32.84505], [-116.86229, 32.84565], [-116.86362, 32.84766], [-116.86437, 32.84792]]]} | Open Access 1 | Flinn Springs County Park | http://www.sdparks.org/content/sdparks/en/park-pages/FlinnSprings.html | 18950 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 75.533 | Flinn Springs County Park | |
| 4650 | 4650 | 4649 | {"type": "Polygon", "coordinates": [[[-117.00957, 32.73712], [-117.00956, 32.73771], [-117.00891, 32.7377], [-117.00892, 32.73676], [-117.00933, 32.73677], [-117.00933, 32.73711], [-117.00957, 32.73712]]]} | Open Access 1 | Goodland Acres Park | http://www.sdparks.org/content/sdparks/en/park-pages/GoodlandAcres.html | 19403 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 1.352 | Goodland Acres Park | |
| 4670 | 4670 | 4669 | {"type": "Polygon", "coordinates": [[[-117.18378, 33.25255], [-117.18377, 33.25259], [-117.18374, 33.25261], [-117.18272, 33.25297], [-117.18189, 33.25323], [-117.18125, 33.25339], [-117.18097, 33.25343], [-117.18104, 33.24925], [-117.18302, 33.24925], [-117.18316, 33.24949], [-117.18322, 33.24967], [-117.1836, 33.25208], [-117.18366, 33.2523], [-117.18378, 33.25255]]]} | Open Access 1 | Gopher Canyon Reserve | 19407 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 23.855 | Gopher Canyon Reserve | ||
| 4739 | 4739 | 4738 | {"type": "Polygon", "coordinates": [[[-117.13525, 33.02933], [-117.1352, 33.03273], [-117.1346, 33.03273], [-117.13458, 33.03241], [-117.13336, 33.03194], [-117.13294, 33.0302], [-117.13281, 33.0301], [-117.13258, 33.03004], [-117.1325, 33.02998], [-117.13233, 33.02954], [-117.1323, 33.02934], [-117.13525, 33.02933]]]} | Open Access 1 | Greenfield Preserve | 19479 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 17.376 | Greenfield Preserve | ||
| 4886 | 4886 | 4885 | {"type": "Polygon", "coordinates": [[[-116.90222, 32.84651], [-116.90218, 32.84649], [-116.90213, 32.84651], [-116.9021, 32.84659], [-116.90205, 32.84692], [-116.9019, 32.84712], [-116.89878, 32.84713], [-116.89877, 32.84549], [-116.89944, 32.84553], [-116.90107, 32.84593], [-116.90178, 32.84602], [-116.90196, 32.84615], [-116.9022, 32.84643], [-116.90222, 32.84651]]]} | Open Access 1 | Lakeside Linkage Preserve | http://www.sdparks.org/content/sdparks/en/park-pages/LakesideLinkage.html | 20976 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 11.423 | Lakeside Linkage Preserve |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps(
id INT,
map,
ACCESS_TYP INT,
PARK_NAME TEXT,
PARK_URL TEXT,
SUID_NMA INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
ON [superunits_with_maps] ([ACCESS_TYP]);