units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, AGNCY_TYP = 26 and DES_TP = 3
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6684 | 6684 | 6683 | {"type": "MultiPolygon", "coordinates": [[[[-116.74406, 32.79528], [-116.74353, 32.79522], [-116.74329, 32.79518], [-116.74299, 32.79506], [-116.74274, 32.79491], [-116.74253, 32.79473], [-116.74237, 32.79452], [-116.74203, 32.79381], [-116.74269, 32.79448], [-116.74301, 32.79475], [-116.74343, 32.795], [-116.74406, 32.79528]]], [[[-116.74494, 32.79562], [-116.73759, 32.79565], [-116.73759, 32.79051], [-116.73789, 32.79055], [-116.73815, 32.79063], [-116.73842, 32.79076], [-116.73864, 32.79093], [-116.73916, 32.79151], [-116.73931, 32.79174], [-116.73945, 32.79207], [-116.73953, 32.79219], [-116.73966, 32.79235], [-116.73981, 32.79247], [-116.74003, 32.79261], [-116.74114, 32.79309], [-116.74139, 32.79324], [-116.74162, 32.79342], [-116.7422, 32.7946], [-116.74237, 32.79482], [-116.74263, 32.79505], [-116.74295, 32.79523], [-116.74328, 32.79535], [-116.74354, 32.79539], [-116.74437, 32.79546], [-116.74467, 32.79553], [-116.74494, 32.79562]]], [[[-116.79678, 32.79555], [-116.78939, 32.79568], [-116.78942, 32.79919], [-116.78839, 32.79922], [-116.78843, 32.801], [-116.79007, 32.80102], [-116.7926, 32.80099], [-116.79263, 32.80279], [-116.78848, 32.80283], [-116.78424, 32.80279], [-116.78419, 32.79919], [-116.77998, 32.79918], [-116.77995, 32.7956], [-116.77575, 32.7956], [-116.77578, 32.80274], [-116.77261, 32.80276], [-116.7724, 32.80274], [-116.77211, 32.80269], [-116.77186, 32.80263], [-116.77035, 32.80211], [-116.76993, 32.80202], [-116.76944, 32.80196], [-116.76903, 32.80196], [-116.76866, 32.80199], [-116.76675, 32.80232], [-116.76636, 32.80235], [-116.76581, 32.80234], [-116.76495, 32.80223], [-116.76464, 32.80215], [-116.76436, 32.80203], [-116.76256, 32.80087], [-116.76202, 32.80057], [-116.76163, 32.80039], [-116.75955, 32.79963], [-116.75917, 32.79952], [-116.75871, 32.79944], [-116.75756, 32.7994], [-116.75701, 32.79933], [-116.75675, 32.79928], [-116.75557, 32.79895], [-116.75512, 32.79887], [-116.75485, 32.79885], [-116.75316, 32.79883], [-116.75283, 32.79885], [-116.75249, 32.79889], [-116.75205, 32.799], [-116.75162, 32.79915], [-116.75052, 32.79972], [-116.7503, 32.79981], [-116.7501, 32.79986], [-116.74989, 32.79989], [-116.74964, 32.7999], [-116.74943, 32.79988], [-116.74915, 32.7998], [-116.74876, 32.79962], [-116.74852, 32.79945], [-116.74831, 32.79924], [-116.74669, 32.7967], [-116.7464, 32.79635], [-116.74602, 32.79601], [-116.74601, 32.79564], [-116.74539, 32.79563], [-116.74374, 32.79496], [-116.74351, 32.79486], [-116.7433, 32.79473], [-116.74308, 32.79458], [-116.74288, 32.79441], [-116.74192, 32.79345], [-116.74156, 32.79315], [-116.74122, 32.79294], [-116.74012, 32.79246], [-116.73988, 32.79231], [-116.73976, 32.79219], [-116.73967, 32.79206], [-116.73948, 32.79166], [-116.73934, 32.79144], [-116.73886, 32.79089], [-116.73869, 32.79074], [-116.73845, 32.79058], [-116.73816, 32.79045], [-116.73791, 32.79038], [-116.73759, 32.79034], [-116.73759, 32.78851], [-116.73336, 32.78851], [-116.73331, 32.78476], [-116.73751, 32.78476], [-116.75429, 32.78443], [-116.7543, 32.77679], [-116.76715, 32.77703], [-116.76713, 32.77324], [-116.7714, 32.77332], [-116.77142, 32.77711], [-116.78805, 32.77718], [-116.78795, 32.77343], [-116.7965, 32.77338], [-116.79677, 32.78836], [-116.79252, 32.7884], [-116.79256, 32.79198], [-116.79677, 32.79194], [-116.79678, 32.79555]]], [[[-116.77178, 32.80276], [-116.76519, 32.80282], [-116.76299, 32.80279], [-116.75449, 32.80278], [-116.74607, 32.80287], [-116.74601, 32.79624], [-116.74632, 32.79654], [-116.74656, 32.79684], [-116.74806, 32.79921], [-116.74821, 32.7994], [-116.7484, 32.79959], [-116.74863, 32.79975], [-116.74954, 32.80016], [-116.74978, 32.80019], [-116.74989, 32.80018], [-116.75005, 32.80014], [-116.75067, 32.79984], [-116.75166, 32.79932], [-116.75207, 32.79917], [-116.75245, 32.79907], [-116.75283, 32.79901], [-116.75319, 32.79899], [-116.75482, 32.79902], [-116.75511, 32.79904], [-116.75554, 32.79911], [-116.75667, 32.79943], [-116.75698, 32.79949], [-116.75756, 32.79957], [-116.7587, 32.79961], [-116.7591, 32.79968], [-116.75948, 32.79979], [-116.76145, 32.80051], [-116.76196, 32.80073], [-116.76246, 32.80101], [-116.76427, 32.80217], [-116.7645, 32.80228], [-116.76478, 32.80237], [-116.7657, 32.8025], [-116.76602, 32.80252], [-116.76636, 32.80252], [-116.76682, 32.80247], [-116.7687, 32.80216], [-116.76907, 32.80213], [-116.76942, 32.80213], [-116.76989, 32.80218], [-116.77029, 32.80227], [-116.77178, 32.80276]]]]} | Open Access 1 | 4834 | Loveland Reservoir | 12983 | 2163 | Sweetwater Authority 840 | Special District 4 | Special District - Other 26 | http://www.sweetwater.org | Special District 4 | 2163 | Sweetwater Authority 817 | Special District 4 | Special District - Other 24 | http://www.sweetwater.org/index.aspx?page=111 | San Diego 4 | 3292.465 | Loveland Reservoir | 0 | Local Recreation Area 3 | 4 |
7018 | 7018 | 7017 | {"type": "MultiPolygon", "coordinates": [[[[-117.92563, 33.95386], [-117.92551, 33.95393], [-117.92534, 33.95397], [-117.92519, 33.95397], [-117.92506, 33.95395], [-117.92502, 33.95392], [-117.925, 33.95387], [-117.92501, 33.95383], [-117.92529, 33.95348], [-117.92549, 33.95359], [-117.92554, 33.95377], [-117.92563, 33.95386]]], [[[-117.92633, 33.95169], [-117.92624, 33.9518], [-117.92622, 33.9518], [-117.92621, 33.95185], [-117.92598, 33.95214], [-117.92521, 33.95305], [-117.923, 33.95593], [-117.92265, 33.95634], [-117.9225, 33.95639], [-117.92154, 33.95636], [-117.92414, 33.95009], [-117.92426, 33.95043], [-117.92458, 33.95062], [-117.9247, 33.95081], [-117.925, 33.95102], [-117.92517, 33.95146], [-117.92545, 33.95147], [-117.9257, 33.9516], [-117.92585, 33.95156], [-117.92597, 33.95157], [-117.92633, 33.95169]]]]} | Open Access 1 | 6496 | Powder Canyon Open Space | 7479 | 2091 | Native Habitat Preservation Authority 848 | Special District 4 | Special District - Other 26 | http://www.habitatauthority.org/ | Special District 4 | 2091 | Native Habitat Preservation Authority 826 | Special District 4 | Special District - Other 24 | http://www.lamountains.com/parks.asp?parkid=45 | Los Angeles 6 | 27.946 | Powder Canyon OS | 0 | Local Recreation Area 3 | 4 |
7251 | 7251 | 7250 | {"type": "Polygon", "coordinates": [[[-121.92994, 37.74522], [-121.92625, 37.74667], [-121.92569, 37.74579], [-121.92458, 37.74623], [-121.92512, 37.74711], [-121.92071, 37.74637], [-121.92092, 37.7457], [-121.92094, 37.7455], [-121.92092, 37.74535], [-121.921, 37.74482], [-121.9211, 37.7447], [-121.9213, 37.74459], [-121.92141, 37.74449], [-121.92146, 37.7444], [-121.92148, 37.74426], [-121.92136, 37.74378], [-121.92055, 37.74282], [-121.9205, 37.74268], [-121.92049, 37.74258], [-121.92053, 37.7422], [-121.92061, 37.74194], [-121.92088, 37.74171], [-121.9209, 37.74166], [-121.92086, 37.74144], [-121.921, 37.74106], [-121.92102, 37.74085], [-121.92096, 37.74024], [-121.92146, 37.73929], [-121.92181, 37.73883], [-121.92232, 37.73901], [-121.92245, 37.73928], [-121.92249, 37.73962], [-121.92256, 37.73977], [-121.92257, 37.73977], [-121.92276, 37.73954], [-121.92277, 37.73957], [-121.92258, 37.73982], [-121.9226, 37.73986], [-121.92258, 37.74002], [-121.9226, 37.74014], [-121.9227, 37.7404], [-121.92283, 37.74054], [-121.92298, 37.74068], [-121.92344, 37.74066], [-121.92396, 37.74073], [-121.92441, 37.74073], [-121.9246, 37.74075], [-121.9248, 37.74079], [-121.92491, 37.74089], [-121.92502, 37.74095], [-121.92519, 37.74109], [-121.92534, 37.74126], [-121.92543, 37.74145], [-121.92548, 37.74167], [-121.92547, 37.74189], [-121.92553, 37.74205], [-121.92563, 37.74213], [-121.92575, 37.74238], [-121.9259, 37.74263], [-121.92617, 37.74292], [-121.92625, 37.74304], [-121.92638, 37.74333], [-121.92669, 37.74351], [-121.92698, 37.74389], [-121.92725, 37.74414], [-121.92715, 37.74428], [-121.92706, 37.74444], [-121.92692, 37.74464], [-121.92691, 37.74469], [-121.92692, 37.74481], [-121.92801, 37.74475], [-121.92843, 37.74481], [-121.92869, 37.74482], [-121.92892, 37.74479], [-121.9294, 37.74467], [-121.92994, 37.74522]]]} | Open Access 1 | 48920 | Dougherty Valley Ridge Trail | 33643 | 2300 | Geologic Hazard Abatement District (San Ramon) 853 | Special District 4 | Special District - Other 26 | http://www.sanramon.ca.gov/engr/ghad.html | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | Contra Costa 12 | 89.586 | Dougherty Valley Ridge Trail | 0 | Local Recreation Area 3 | 4 |
7638 | 7638 | 7637 | {"type": "MultiPolygon", "coordinates": [[[[-117.01289, 32.68963], [-117.01273, 32.68983], [-117.01202, 32.69013], [-117.01125, 32.69018], [-117.01109, 32.69026], [-117.01139, 32.69105], [-117.01006, 32.69144], [-117.01049, 32.69249], [-117.01035, 32.69264], [-117.01027, 32.69282], [-117.01026, 32.69298], [-117.01031, 32.69315], [-117.01039, 32.69334], [-117.01048, 32.69348], [-117.01099, 32.69408], [-117.01119, 32.69426], [-117.01143, 32.69485], [-117.00956, 32.69534], [-117.00656, 32.69617], [-117.00618, 32.69512], [-117.00612, 32.69501], [-117.00435, 32.69499], [-117.0043, 32.69752], [-117.00427, 32.69832], [-117.00321, 32.69831], [-117.00225, 32.6976], [-117.0005, 32.69756], [-116.99905, 32.69953], [-116.99528, 32.70188], [-116.99528, 32.7009], [-116.99469, 32.70089], [-116.99469, 32.70118], [-116.99502, 32.70118], [-116.99502, 32.70219], [-116.99471, 32.70219], [-116.9947, 32.70197], [-116.99438, 32.70198], [-116.99437, 32.70129], [-116.9941, 32.7013], [-116.9941, 32.70218], [-116.99345, 32.70218], [-116.99345, 32.70131], [-116.99339, 32.7013], [-116.98986, 32.7032], [-116.98981, 32.70485], [-116.98865, 32.70483], [-116.98678, 32.70577], [-116.98678, 32.70679], [-116.98667, 32.70685], [-116.98666, 32.70691], [-116.98637, 32.70706], [-116.98598, 32.7073], [-116.98571, 32.70742], [-116.9846, 32.7074], [-116.98455, 32.70877], [-116.98409, 32.70894], [-116.98378, 32.70911], [-116.98276, 32.70928], [-116.98295, 32.7098], [-116.98281, 32.70996], [-116.981, 32.7124], [-116.98079, 32.71263], [-116.98037, 32.71304], [-116.98007, 32.71326], [-116.97835, 32.71428], [-116.97786, 32.71462], [-116.97751, 32.7149], [-116.97712, 32.71526], [-116.97656, 32.71585], [-116.9757, 32.71692], [-116.97558, 32.71703], [-116.97541, 32.71695], [-116.97547, 32.71378], [-116.97669, 32.71162], [-116.97486, 32.71069], [-116.97368, 32.71127], [-116.97187, 32.70999], [-116.96919, 32.71004], [-116.96717, 32.70956], [-116.96536, 32.7089], [-116.96242, 32.70748], [-116.96114, 32.7065], [-116.95846, 32.70964], [-116.95844, 32.711], [-116.9581, 32.71205], [-116.9566, 32.71183], [-116.95699, 32.71138], [-116.95618, 32.70806], [-116.95828, 32.70139], [-116.96282, 32.7014], [-116.96508, 32.70243], [-116.96727, 32.70129], [-116.96827, 32.70129], [-116.96827, 32.70216], [-116.97589, 32.70219], [-116.97777, 32.69987], [-116.97802, 32.69579], [-116.97824, 32.69276], [-116.97921, 32.69007], [-116.98595, 32.69006], [-116.98601, 32.69003], [-116.98608, 32.69003], [-116.98854, 32.68878], [-116.98853, 32.68673], [-116.98976, 32.68673], [-116.98976, 32.68514], [-116.99176, 32.68512], [-116.99176, 32.68303], [-116.99173, 32.68302], [-116.99173, 32.68284], [-116.99302, 32.68306], [-116.99443, 32.68312], [-116.99553, 32.68297], [-116.99641, 32.68324], [-116.99641, 32.68275], [-116.99729, 32.68246], [-116.99947, 32.68152], [-116.9996, 32.68176], [-117.00039, 32.68385], [-117.00165, 32.68355], [-117.00257, 32.68591], [-117.00289, 32.68583], [-117.00626, 32.68725], [-117.00585, 32.68795], [-117.00562, 32.68829], [-117.00584, 32.68882], [-117.00846, 32.68998], [-117.00851, 32.68999], [-117.00932, 32.68976], [-117.01078, 32.68938], [-117.01149, 32.6884], [-117.01152, 32.6883], [-117.01146, 32.68822], [-117.01148, 32.68813], [-117.01286, 32.68945], [-117.01289, 32.68963]], [[-116.9777, 32.71144], [-116.9769, 32.71243], [-116.97689, 32.71248], [-116.97658, 32.71286], [-116.97639, 32.71351], [-116.97646, 32.71453], [-116.97698, 32.71483], [-116.97704, 32.71474], [-116.97659, 32.71448], [-116.97651, 32.71352], [-116.9767, 32.71291], [-116.97787, 32.71141], [-116.97543, 32.71], [-116.97476, 32.70997], [-116.97399, 32.71061], [-116.97307, 32.70944], [-116.97225, 32.70918], [-116.97221, 32.70926], [-116.97223, 32.70928], [-116.97298, 32.70953], [-116.97395, 32.71076], [-116.97479, 32.71007], [-116.97537, 32.71009], [-116.9777, 32.71144]], [[-116.99677, 32.68615], [-116.99677, 32.68613], [-116.99635, 32.68554], [-116.99567, 32.68556], [-116.99569, 32.68666], [-116.99677, 32.68615]]], [[[-117.01103, 32.6939], [-117.01058, 32.6934], [-117.0105, 32.69326], [-117.01044, 32.69313], [-117.01041, 32.69298], [-117.01041, 32.69287], [-117.01046, 32.69273], [-117.01054, 32.69262], [-117.01103, 32.6939]]]]} | Open Access 1 | 7386 | Sweetwater Reservoir | 12984 | 2163 | Sweetwater Authority 840 | Special District 4 | Special District - Other 26 | http://www.sweetwater.org | Special District 4 | 2163 | Sweetwater Authority 817 | Special District 4 | Special District - Other 24 | http://www.sweetwater.org/index.aspx?page=112 | San Diego 4 | 1773.187 | Sweetwater Reservoir | 0 | Local Recreation Area 3 | 4 |
16046 | 16046 | 16045 | {"type": "MultiPolygon", "coordinates": [[[[-117.96288, 33.96984], [-117.96249, 33.9704], [-117.96226, 33.97064], [-117.96228, 33.97088], [-117.96219, 33.97105], [-117.96204, 33.97114], [-117.96194, 33.97104], [-117.96175, 33.97093], [-117.96168, 33.97086], [-117.96159, 33.97082], [-117.96145, 33.97083], [-117.96125, 33.97077], [-117.96113, 33.97071], [-117.96104, 33.97064], [-117.96095, 33.97051], [-117.96093, 33.97033], [-117.96147, 33.96993], [-117.96156, 33.97004], [-117.96202, 33.97003], [-117.96229, 33.96993], [-117.9626, 33.96994], [-117.9628, 33.96978], [-117.96288, 33.96984]]], [[[-117.96145, 33.96988], [-117.96145, 33.9699], [-117.96096, 33.97026], [-117.96096, 33.97024], [-117.961, 33.97017], [-117.96112, 33.97006], [-117.96145, 33.96988]]], [[[-117.96165, 33.97087], [-117.96164, 33.97088], [-117.96156, 33.97086], [-117.96159, 33.97086], [-117.96165, 33.97087]]], [[[-117.97696, 33.96632], [-117.9769, 33.9664], [-117.97684, 33.96644], [-117.97661, 33.96649], [-117.97661, 33.96619], [-117.97696, 33.96632]]], [[[-117.97702, 33.96785], [-117.97665, 33.96784], [-117.97661, 33.96655], [-117.97689, 33.96666], [-117.97687, 33.96681], [-117.97678, 33.96705], [-117.97674, 33.96723], [-117.97673, 33.96739], [-117.97679, 33.96759], [-117.97684, 33.96769], [-117.97691, 33.96778], [-117.97702, 33.96785]]], [[[-117.98084, 33.96788], [-117.97717, 33.96785], [-117.97699, 33.96778], [-117.97694, 33.96773], [-117.97683, 33.96751], [-117.97679, 33.96737], [-117.9768, 33.96723], [-117.97685, 33.96706], [-117.97694, 33.96682], [-117.97697, 33.96664], [-117.97672, 33.96652], [-117.9768, 33.96651], [-117.97689, 33.96648], [-117.97698, 33.9664], [-117.97701, 33.96633], [-117.97851, 33.96688], [-117.97904, 33.96694], [-117.97955, 33.96708], [-117.9798, 33.96713], [-117.98007, 33.96716], [-117.98041, 33.96705], [-117.98052, 33.96678], [-117.98059, 33.96681], [-117.98023, 33.96761], [-117.98084, 33.96788]]]]} | Open Access 1 | 6504 | Arroyo San Miguel Open Space | 15625 | 2091 | Native Habitat Preservation Authority 848 | Special District 4 | Special District - Other 26 | http://www.habitatauthority.org/ | Special District 4 | 2091 | Native Habitat Preservation Authority 826 | Special District 4 | Special District - Other 24 | Los Angeles 6 | 13.411 | Arroyo San Miguel OS | 0 | Local Recreation Area 3 | 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]);