superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 2, MNG_AGENCY = 665 and MNG_AG_TYP = 10
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Non Profit - Land Trust · 3 ✖
MNG_AGENCY 1
- The Conservation Fund - California · 3 ✖
ACCESS_TYP 1
- Restricted Access · 3 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3160 | 3160 | 3159 | {"type": "MultiPolygon", "coordinates": [[[[-116.68093, 32.60085], [-116.68055, 32.60089], [-116.68054, 32.60089], [-116.68054, 32.60089], [-116.68093, 32.60085]]], [[[-116.68153, 32.60102], [-116.68153, 32.60106], [-116.6815, 32.60111], [-116.68153, 32.60102], [-116.68152, 32.60097], [-116.68149, 32.60092], [-116.68139, 32.60088], [-116.68144, 32.60089], [-116.68149, 32.60092], [-116.68152, 32.60097], [-116.68153, 32.60102]]], [[[-116.68378, 32.60165], [-116.68372, 32.60158], [-116.68369, 32.60157], [-116.68364, 32.60157], [-116.68358, 32.60161], [-116.68362, 32.60158], [-116.68364, 32.60157], [-116.68365, 32.60157], [-116.68369, 32.60157], [-116.68372, 32.60158], [-116.68375, 32.60159], [-116.68378, 32.60165]]], [[[-116.68386, 32.60207], [-116.68385, 32.60192], [-116.68383, 32.60185], [-116.68384, 32.60189], [-116.68385, 32.60194], [-116.68386, 32.60207]]], [[[-116.68386, 32.60209], [-116.68386, 32.60211], [-116.68386, 32.60209], [-116.68386, 32.60209]]], [[[-116.68202, 32.6024], [-116.68181, 32.60235], [-116.68154, 32.60236], [-116.68179, 32.60235], [-116.68182, 32.60236], [-116.68187, 32.60236], [-116.68202, 32.6024]]], [[[-116.68384, 32.60247], [-116.68384, 32.60249], [-116.68383, 32.60251], [-116.68383, 32.60251], [-116.68384, 32.60247]]], [[[-116.68435, 32.60337], [-116.68425, 32.6033], [-116.68408, 32.60322], [-116.68422, 32.60329], [-116.68432, 32.60334], [-116.68435, 32.60337]]], [[[-116.68438, 32.60339], [-116.68438, 32.60339], [-116.68439, 32.6034], [-116.68438, 32.60339]]], [[[-116.68669, 32.60192], [-116.68659, 32.60417], [-116.68563, 32.60407], [-116.68538, 32.604], [-116.68518, 32.60389], [-116.68441, 32.60326], [-116.68397, 32.60303], [-116.68394, 32.60299], [-116.68386, 32.60281], [-116.68385, 32.60276], [-116.68397, 32.60248], [-116.68399, 32.60197], [-116.6839, 32.6016], [-116.68386, 32.60154], [-116.68378, 32.60148], [-116.68364, 32.60146], [-116.68353, 32.6015], [-116.68325, 32.60182], [-116.68272, 32.60218], [-116.68265, 32.6022], [-116.6821, 32.6023], [-116.6818, 32.60224], [-116.68147, 32.60225], [-116.6814, 32.60224], [-116.68107, 32.60191], [-116.68104, 32.60186], [-116.68103, 32.60179], [-116.68105, 32.60174], [-116.68116, 32.60151], [-116.6816, 32.60118], [-116.68166, 32.60108], [-116.68166, 32.60098], [-116.68249, 32.60097], [-116.6825, 32.60053], [-116.68293, 32.60077], [-116.68338, 32.60096], [-116.68669, 32.60192]]]]} | Restricted Access 2 | Conservation Fund | 17596 | 3087 | The Conservation Fund - California 665 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.conservationfund.org/ | Non Governmental Organization 10 | 23.2 | Conservation Fund | 0 | |
| 4816 | 4816 | 4815 | {"type": "MultiPolygon", "coordinates": [[[[-123.47898, 38.86227], [-123.47422, 38.86203], [-123.46489, 38.86134], [-123.4645, 38.86486], [-123.45962, 38.86448], [-123.45979, 38.86111], [-123.45496, 38.86076], [-123.45529, 38.85725], [-123.45073, 38.85696], [-123.45041, 38.86039], [-123.44566, 38.85999], [-123.44064, 38.85967], [-123.44109, 38.85667], [-123.43671, 38.85652], [-123.43604, 38.86108], [-123.43573, 38.86094], [-123.43546, 38.86079], [-123.43517, 38.86035], [-123.43513, 38.85992], [-123.43515, 38.85936], [-123.43379, 38.85935], [-123.43374, 38.85992], [-123.43178, 38.85993], [-123.4313, 38.86324], [-123.43121, 38.86454], [-123.43106, 38.86455], [-123.43087, 38.86463], [-123.43078, 38.86483], [-123.43078, 38.86493], [-123.43087, 38.86513], [-123.43092, 38.86534], [-123.43091, 38.86542], [-123.43077, 38.8657], [-123.43072, 38.86586], [-123.43072, 38.86609], [-123.4307, 38.86626], [-123.43063, 38.86644], [-123.43055, 38.86651], [-123.42996, 38.86678], [-123.42972, 38.86706], [-123.42932, 38.86726], [-123.42911, 38.86739], [-123.42891, 38.86765], [-123.42884, 38.86789], [-123.42885, 38.86798], [-123.42887, 38.86804], [-123.42891, 38.86807], [-123.42911, 38.86805], [-123.42938, 38.86807], [-123.42942, 38.86809], [-123.42955, 38.86823], [-123.42977, 38.86837], [-123.42992, 38.86853], [-123.43048, 38.86896], [-123.43108, 38.86926], [-123.43109, 38.87019], [-123.42668, 38.87024], [-123.42701, 38.86342], [-123.42729, 38.85984], [-123.42794, 38.85297], [-123.4283, 38.84975], [-123.424, 38.84965], [-123.42373, 38.84631], [-123.41399, 38.84598], [-123.41383, 38.84248], [-123.40891, 38.84235], [-123.4093, 38.84938], [-123.4091, 38.85263], [-123.40829, 38.85225], [-123.40716, 38.8518], [-123.40658, 38.85194], [-123.40562, 38.85212], [-123.40437, 38.852], [-123.40434, 38.85468], [-123.4041, 38.85443], [-123.40384, 38.85423], [-123.40372, 38.854], [-123.40358, 38.85378], [-123.40349, 38.85366], [-123.40341, 38.8536], [-123.4033, 38.85354], [-123.40239, 38.85337], [-123.40222, 38.85336], [-123.40199, 38.85337], [-123.40158, 38.85344], [-123.40144, 38.85344], [-123.40115, 38.8534], [-123.40099, 38.8534], [-123.4009, 38.85336], [-123.40088, 38.85328], [-123.40091, 38.85321], [-123.40101, 38.85317], [-123.4013, 38.85313], [-123.40145, 38.85303], [-123.40148, 38.85292], [-123.40147, 38.8528], [-123.4015, 38.8524], [-123.40158, 38.85206], [-123.40169, 38.85186], [-123.40183, 38.85172], [-123.40209, 38.85161], [-123.40232, 38.85157], [-123.40249, 38.85152], [-123.40273, 38.85141], [-123.40326, 38.85138], [-123.40338, 38.85136], [-123.40349, 38.85125], [-123.40349, 38.85119], [-123.4034, 38.85103], [-123.40338, 38.85093], [-123.40338, 38.85082], [-123.40346, 38.85057], [-123.40346, 38.85035], [-123.40343, 38.85022], [-123.40336, 38.85014], [-123.40314, 38.85001], [-123.40289, 38.84992], [-123.40237, 38.84981], [-123.40219, 38.84975], [-123.40152, 38.84925], [-123.40102, 38.84851], [-123.40081, 38.84841], [-123.4004, 38.84833], [-123.40023, 38.84832], [-123.40013, 38.84835], [-123.39998, 38.84842], [-123.39973, 38.84862], [-123.39963, 38.84868], [-123.39944, 38.84871], [-123.39881, 38.84873], [-123.39862, 38.84875], [-123.39847, 38.84879], [-123.39826, 38.84882], [-123.39798, 38.84882], [-123.39764, 38.84868], [-123.39744, 38.84862], [-123.39729, 38.84861], [-123.39706, 38.84869], [-123.397, 38.84869], [-123.39682, 38.84868], [-123.39667, 38.84865], [-123.39638, 38.8485], [-123.39617, 38.84835], [-123.39552, 38.84808], [-123.39495, 38.84799], [-123.39448, 38.8478], [-123.39404, 38.84753], [-123.39377, 38.84723], [-123.3931, 38.84658], [-123.39294, 38.84636], [-123.39284, 38.84627], [-123.3927, 38.84622], [-123.39247, 38.84619], [-123.39232, 38.84618], [-123.39215, 38.84613], [-123.39193, 38.84598], [-123.39165, 38.8459], [-123.39107, 38.84564], [-123.38933, 38.84435], [-123.38897, 38.84439], [-123.38879, 38.84444], [-123.38854, 38.84448], [-123.38812, 38.84446], [-123.38799, 38.84439], [-123.3877, 38.84414], [-123.38745, 38.84388], [-123.3873, 38.8438], [-123.38681, 38.84359], [-123.3866, 38.84352], [-123.38652, 38.84345], [-123.38586, 38.84326], [-123.38575, 38.84327], [-123.38558, 38.84332], [-123.3854, 38.8434], [-123.38516, 38.84345], [-123.38498, 38.84343], [-123.38462, 38.84329], [-123.38432, 38.84313], [-123.38411, 38.84305], [-123.38392, 38.843], [-123.38383, 38.84295], [-123.38376, 38.84288], [-123.38366, 38.84278], [-123.38349, 38.84256], [-123.38314, 38.84232], [-123.38298, 38.84213], [-123.38281, 38.84176], [-123.38258, 38.84102], [-123.38248, 38.84084], [-123.38161, 38.84038], [-123.38101, 38.83968], [-123.38039, 38.83912], [-123.37977, 38.83867], [-123.37887, 38.83824], [-123.37842, 38.83776], [-123.37789, 38.83713], [-123.37745, 38.83655], [-123.37703, 38.83602], [-123.37607, 38.83502], [-123.37545, 38.83514], [-123.37513, 38.83536], [-123.37425, 38.8358], [-123.3738, 38.83625], [-123.37287, 38.83695], [-123.37251, 38.83706], [-123.37213, 38.83704], [-123.37152, 38.83669], [-123.37122, 38.83638], [-123.3709, 38.836], [-123.37074, 38.83569], [-123.37038, 38.8353], [-123.37, 38.835], [-123.36957, 38.83458], [-123.36875, 38.83228], [-123.36893, 38.83088], [-123.3733, 38.83085], [-123.37331, 38.83083], [-123.37308, 38.82381], [-123.36887, 38.82379], [-123.36838, 38.82008], [-123.36839, 38.80966], [-123.36841, 38.80646], [-123.36841, 38.79905], [-123.3685, 38.79187], [-123.36832, 38.77718], [-123.37611, 38.77709], [-123.38225, 38.77708], [-123.38691, 38.77703], [-123.40395, 38.77682], [-123.41798, 38.77657], [-123.41895, 38.77657], [-123.41923, 38.77702], [-123.41982, 38.77731], [-123.4218, 38.77883], [-123.42286, 38.77936], [-123.4241, 38.78034], [-123.42588, 38.78038], [-123.42663, 38.78037], [-123.42812, 38.78025], [-123.42917, 38.78025], [-123.43052, 38.78027], [-123.43195, 38.78037], [-123.43314, 38.78041], [-123.43452, 38.7809], [-123.43557, 38.78148], [-123.43641, 38.78208], [-123.43702, 38.78278], [-123.4373, 38.78349], [-123.43774, 38.7847], [-123.43818, 38.78557], [-123.43873, 38.78656], [-123.43927, 38.78738], [-123.43961, 38.7881], [-123.43977, 38.78874], [-123.43988, 38.79005], [-123.44031, 38.79111], [-123.44054, 38.79177], [-123.44067, 38.79262], [-123.44073, 38.79425], [-123.44072, 38.79498], [-123.44064, 38.79566], [-123.44047, 38.79626], [-123.44004, 38.79701], [-123.4395, 38.79761], [-123.43877, 38.79822], [-123.43799, 38.79872], [-123.43707, 38.7992], [-123.43616, 38.79966], [-123.43523, 38.80001], [-123.43309, 38.80089], [-123.43229, 38.80124], [-123.43157, 38.80164], [-123.431, 38.80211], [-123.43057, 38.80266], [-123.43025, 38.80322], [-123.43009, 38.80366], [-123.42973, 38.80497], [-123.42785, 38.80494], [-123.42934, 38.80727], [-123.42936, 38.80841], [-123.42955, 38.80893], [-123.43016, 38.80978], [-123.43081, 38.81047], [-123.43171, 38.81113], [-123.43269, 38.81172], [-123.43523, 38.81309], [-123.43579, 38.81351], [-123.43619, 38.81393], [-123.43622, 38.81425], [-123.43619, 38.82007], [-123.43645, 38.82561], [-123.43708, 38.82597], [-123.43778, 38.82649], [-123.43869, 38.82727], [-123.43929, 38.82807], [-123.44081, 38.82956], [-123.44157, 38.83022], [-123.44234, 38.8308], [-123.44371, 38.83153], [-123.4448, 38.83193], [-123.44733, 38.83233], [-123.45983, 38.82934], [-123.46213, 38.82948], [-123.46273, 38.83652], [-123.46524, 38.83658], [-123.46512, 38.83994], [-123.46504, 38.84698], [-123.47892, 38.84758], [-123.47896, 38.8502], [-123.47894, 38.85134], [-123.47898, 38.86227]], [[-123.44438, 38.85014], [-123.44439, 38.85013], [-123.4443, 38.84658], [-123.442, 38.84651], [-123.44045, 38.84657], [-123.44029, 38.8464], [-123.44028, 38.84595], [-123.44007, 38.84575], [-123.43967, 38.84561], [-123.43922, 38.84583], [-123.43894, 38.84602], [-123.43877, 38.84633], [-123.43873, 38.84656], [-123.43924, 38.84696], [-123.43915, 38.84726], [-123.43751, 38.84729], [-123.43755, 38.84998], [-123.44206, 38.85011], [-123.44438, 38.85014]]], [[[-123.41901, 38.84956], [-123.41868, 38.85299], [-123.4139, 38.85284], [-123.4142, 38.84946], [-123.41901, 38.84956]]]]} | Restricted Access 2 | Gualala River Forest | 19561 | 3087 | The Conservation Fund - California 665 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.conservationfund.org/ | Non Governmental Organization 10 | 13558.732 | Gualala River Forest | ||
| 10277 | 10277 | 10276 | {"type": "MultiPolygon", "coordinates": [[[[-123.75672, 39.54169], [-123.75661, 39.5417], [-123.75661, 39.54179], [-123.75658, 39.54188], [-123.75649, 39.54196], [-123.75635, 39.542], [-123.75619, 39.54198], [-123.75592, 39.54186], [-123.75555, 39.54176], [-123.75456, 39.54131], [-123.75265, 39.53993], [-123.75164, 39.53936], [-123.75094, 39.53903], [-123.74967, 39.53835], [-123.74937, 39.53821], [-123.74889, 39.53801], [-123.74859, 39.53784], [-123.74806, 39.53759], [-123.74792, 39.53747], [-123.74779, 39.53733], [-123.74772, 39.53713], [-123.74759, 39.5364], [-123.74759, 39.53625], [-123.74762, 39.5361], [-123.7477, 39.53596], [-123.74779, 39.53585], [-123.74821, 39.53551], [-123.74833, 39.53537], [-123.74844, 39.53521], [-123.74868, 39.53478], [-123.74875, 39.53458], [-123.74879, 39.5343], [-123.74879, 39.53412], [-123.74872, 39.53387], [-123.74841, 39.53339], [-123.7481, 39.53299], [-123.74776, 39.53264], [-123.74732, 39.53209], [-123.74604, 39.53053], [-123.74582, 39.53024], [-123.74523, 39.52958], [-123.74437, 39.52852], [-123.744, 39.5282], [-123.74378, 39.52805], [-123.74352, 39.52796], [-123.74258, 39.52775], [-123.74191, 39.52757], [-123.74094, 39.52745], [-123.74091, 39.52761], [-123.7414, 39.52767], [-123.74218, 39.52781], [-123.7432, 39.52803], [-123.7436, 39.52817], [-123.74389, 39.52833], [-123.74423, 39.52866], [-123.74499, 39.52958], [-123.74589, 39.5307], [-123.74636, 39.53121], [-123.74719, 39.53222], [-123.74759, 39.53276], [-123.74807, 39.53324], [-123.74846, 39.53375], [-123.74857, 39.53403], [-123.7486, 39.53421], [-123.74859, 39.53445], [-123.74855, 39.53462], [-123.7484, 39.5349], [-123.74826, 39.53517], [-123.74811, 39.53537], [-123.74798, 39.5355], [-123.74766, 39.53572], [-123.74756, 39.53584], [-123.74747, 39.53596], [-123.74741, 39.5361], [-123.74741, 39.5363], [-123.74753, 39.53708], [-123.74758, 39.53727], [-123.74766, 39.53741], [-123.74782, 39.53758], [-123.74802, 39.53773], [-123.74858, 39.53801], [-123.74815, 39.53805], [-123.74781, 39.53813], [-123.74758, 39.53821], [-123.74679, 39.53855], [-123.74498, 39.53837], [-123.74511, 39.53123], [-123.74058, 39.53121], [-123.74072, 39.52779], [-123.74071, 39.52759], [-123.74068, 39.52752], [-123.73798, 39.52756], [-123.73741, 39.52742], [-123.73702, 39.52727], [-123.73662, 39.52705], [-123.73613, 39.52673], [-123.73545, 39.52642], [-123.73509, 39.52694], [-123.73448, 39.52668], [-123.73451, 39.52661], [-123.73472, 39.52629], [-123.73447, 39.52619], [-123.73424, 39.52619], [-123.73395, 39.52622], [-123.73381, 39.52626], [-123.73393, 39.52693], [-123.73309, 39.52705], [-123.73286, 39.52512], [-123.73192, 39.52523], [-123.73197, 39.52387], [-123.7409, 39.52395], [-123.74516, 39.52394], [-123.74505, 39.52765], [-123.74954, 39.52769], [-123.74939, 39.53006], [-123.7496, 39.53027], [-123.74987, 39.53029], [-123.75022, 39.53041], [-123.75044, 39.53057], [-123.75061, 39.53079], [-123.75082, 39.53097], [-123.75148, 39.53132], [-123.75149, 39.53331], [-123.75154, 39.53459], [-123.75429, 39.5346], [-123.75607, 39.53459], [-123.75571, 39.53707], [-123.75565, 39.53771], [-123.75566, 39.53839], [-123.75577, 39.53915], [-123.75596, 39.53997], [-123.75625, 39.54082], [-123.75672, 39.54169]], [[-123.73604, 39.52571], [-123.73613, 39.52556], [-123.73548, 39.52528], [-123.73516, 39.52572], [-123.73517, 39.52573], [-123.73604, 39.52571]]], [[[-123.75423, 39.54137], [-123.75357, 39.54166], [-123.75343, 39.54142], [-123.753, 39.54103], [-123.75263, 39.54058], [-123.7523, 39.54038], [-123.75157, 39.54], [-123.75065, 39.53965], [-123.74995, 39.53946], [-123.74889, 39.53933], [-123.74809, 39.53939], [-123.74698, 39.53964], [-123.74621, 39.5399], [-123.74597, 39.54008], [-123.74589, 39.54023], [-123.74589, 39.54034], [-123.74597, 39.54049], [-123.7462, 39.5407], [-123.74664, 39.54101], [-123.74686, 39.54138], [-123.74696, 39.54169], [-123.74708, 39.54196], [-123.74723, 39.54217], [-123.74737, 39.5423], [-123.74772, 39.54245], [-123.74791, 39.54257], [-123.7481, 39.54276], [-123.74817, 39.54293], [-123.74817, 39.54319], [-123.74791, 39.54404], [-123.7479, 39.54422], [-123.74796, 39.54444], [-123.74813, 39.54467], [-123.74882, 39.54535], [-123.74919, 39.54562], [-123.74666, 39.54563], [-123.7464, 39.54451], [-123.7463, 39.54427], [-123.7462, 39.54407], [-123.74593, 39.54376], [-123.74568, 39.54355], [-123.74495, 39.54275], [-123.74482, 39.54249], [-123.74478, 39.54225], [-123.74482, 39.54197], [-123.74492, 39.54153], [-123.7453, 39.54012], [-123.74544, 39.53984], [-123.74563, 39.53958], [-123.74586, 39.53931], [-123.74608, 39.53914], [-123.74699, 39.53869], [-123.74702, 39.53873], [-123.74794, 39.53834], [-123.7485, 39.53826], [-123.74881, 39.5383], [-123.74912, 39.53841], [-123.7497, 39.53871], [-123.75035, 39.53896], [-123.7512, 39.53934], [-123.75209, 39.53983], [-123.75268, 39.54022], [-123.75324, 39.54062], [-123.75423, 39.54137]]], [[[-123.74648, 39.54562], [-123.74527, 39.54564], [-123.74505, 39.54313], [-123.74594, 39.54407], [-123.74613, 39.54436], [-123.74626, 39.54471], [-123.74648, 39.54562]]]]} | Restricted Access 2 | Ten Mile | 26239 | 3087 | The Conservation Fund - California 665 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.conservationfund.org/ | Non Governmental Organization 10 | 388.554 | Ten Mile |
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]);