units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

6 rows where ACCESS_TYP = 2 and COUNTY = 34

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, LABEL_NAME, YR_EST, GAP_STS

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
4416 4416 4415 {"type": "MultiPolygon", "coordinates": [[[[-120.90814, 38.57014], [-120.88983, 38.57064], [-120.88467, 38.57039], [-120.87584, 38.57006], [-120.87151, 38.56993], [-120.8715, 38.56994], [-120.86697, 38.56993], [-120.86692, 38.56986], [-120.8621, 38.56961], [-120.86253, 38.55815], [-120.85319, 38.55806], [-120.85317, 38.56585], [-120.84869, 38.5658], [-120.84867, 38.56178], [-120.84703, 38.56175], [-120.84722, 38.56109], [-120.84747, 38.56052], [-120.84786, 38.55986], [-120.84785, 38.55864], [-120.84776, 38.55795], [-120.84741, 38.55706], [-120.84716, 38.55637], [-120.84716, 38.55602], [-120.84747, 38.55538], [-120.8479, 38.55469], [-120.84815, 38.55447], [-120.85319, 38.55445], [-120.85298, 38.55034], [-120.85383, 38.55007], [-120.85469, 38.54965], [-120.8556, 38.54902], [-120.85593, 38.54876], [-120.85622, 38.54844], [-120.85654, 38.54799], [-120.85673, 38.54759], [-120.85682, 38.54727], [-120.86255, 38.54729], [-120.86253, 38.54355], [-120.86193, 38.54352], [-120.8622, 38.54343], [-120.8624, 38.54325], [-120.86258, 38.54305], [-120.86265, 38.54278], [-120.86275, 38.54246], [-120.86278, 38.54217], [-120.86285, 38.54182], [-120.86295, 38.54149], [-120.86296, 38.54115], [-120.86303, 38.54057], [-120.86312, 38.54032], [-120.8632, 38.54004], [-120.8632, 38.53983], [-120.86315, 38.53957], [-120.86318, 38.53931], [-120.86318, 38.53903], [-120.86315, 38.53865], [-120.86303, 38.53826], [-120.86299, 38.53795], [-120.86305, 38.53755], [-120.86304, 38.53735], [-120.86308, 38.53705], [-120.86308, 38.53681], [-120.86312, 38.53663], [-120.87136, 38.53664], [-120.87142, 38.54103], [-120.87181, 38.55451], [-120.88584, 38.55578], [-120.88549, 38.55967], [-120.89525, 38.55995], [-120.89521, 38.56332], [-120.8996, 38.56317], [-120.9078, 38.56279], [-120.90814, 38.57014]]], [[[-120.86073, 38.54359], [-120.85581, 38.5436], [-120.85581, 38.5436], [-120.85591, 38.5434], [-120.85607, 38.54316], [-120.85627, 38.54297], [-120.8565, 38.54279], [-120.85668, 38.54269], [-120.85716, 38.54254], [-120.8574, 38.54244], [-120.85763, 38.54239], [-120.85782, 38.54241], [-120.85828, 38.54248], [-120.85862, 38.54256], [-120.85924, 38.54276], [-120.85942, 38.54276], [-120.85951, 38.5429], [-120.85966, 38.543], [-120.85987, 38.5431], [-120.86022, 38.5432], [-120.86038, 38.54328], [-120.86073, 38.54359]]]]} Restricted Access 2 47296 El Dorado Ranch 31004 3003 American River Conservancy 604 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10   El Dorado 34 2066.338 El Dorado Ranch 0 Private Conservation 16 2
13036 13036 13035 {"type": "MultiPolygon", "coordinates": [[[[-120.89266, 38.89126], [-120.89257, 38.89479], [-120.89056, 38.89479], [-120.89053, 38.89645], [-120.89055, 38.8965], [-120.89052, 38.89651], [-120.89051, 38.89665], [-120.89026, 38.89606], [-120.88994, 38.89557], [-120.8897, 38.89539], [-120.8902, 38.89507], [-120.8902, 38.89505], [-120.88701, 38.89192], [-120.8863, 38.89232], [-120.88538, 38.89288], [-120.88669, 38.89416], [-120.88634, 38.89408], [-120.88574, 38.89398], [-120.88504, 38.89384], [-120.88368, 38.89339], [-120.88316, 38.89325], [-120.88272, 38.89324], [-120.88239, 38.89325], [-120.88173, 38.89342], [-120.88175, 38.89109], [-120.88161, 38.88749], [-120.88598, 38.88758], [-120.88601, 38.88811], [-120.88448, 38.8884], [-120.88543, 38.89022], [-120.88525, 38.89116], [-120.88723, 38.89118], [-120.8875, 38.89026], [-120.89055, 38.89032], [-120.89056, 38.89124], [-120.89266, 38.89126]]], [[[-120.89052, 38.89708], [-120.8905, 38.89832], [-120.88629, 38.89826], [-120.88628, 38.8948], [-120.88172, 38.89471], [-120.88173, 38.89359], [-120.88261, 38.89353], [-120.88289, 38.89353], [-120.88321, 38.89357], [-120.88468, 38.89404], [-120.88557, 38.89425], [-120.88708, 38.89452], [-120.88862, 38.89603], [-120.88939, 38.89557], [-120.88966, 38.89576], [-120.89001, 38.89629], [-120.89025, 38.8967], [-120.89052, 38.89708]]], [[[-120.90802, 38.89769], [-120.90801, 38.8995], [-120.90421, 38.90102], [-120.90182, 38.89809], [-120.89949, 38.89818], [-120.89948, 38.89819], [-120.90211, 38.9014], [-120.90057, 38.90137], [-120.89993, 38.90132], [-120.89957, 38.90128], [-120.8991, 38.90119], [-120.89758, 38.90074], [-120.89596, 38.90018], [-120.89767, 38.90006], [-120.89943, 38.89996], [-120.89948, 38.89911], [-120.89947, 38.89808], [-120.90172, 38.89795], [-120.90373, 38.89788], [-120.90802, 38.89769]]], [[[-120.908, 38.89979], [-120.90797, 38.90135], [-120.90794, 38.90478], [-120.90656, 38.90475], [-120.90316, 38.90188], [-120.90172, 38.90292], [-120.90342, 38.90439], [-120.90344, 38.90474], [-120.90345, 38.90756], [-120.90024, 38.90617], [-120.89942, 38.90698], [-120.89945, 38.90553], [-120.89607, 38.90576], [-120.89515, 38.90581], [-120.89522, 38.90208], [-120.89524, 38.90015], [-120.89592, 38.90046], [-120.89747, 38.90106], [-120.89842, 38.90136], [-120.89937, 38.90157], [-120.90043, 38.90171], [-120.90143, 38.90177], [-120.90226, 38.90178], [-120.90291, 38.90174], [-120.90321, 38.90174], [-120.90373, 38.90161], [-120.90439, 38.90138], [-120.90532, 38.90099], [-120.90561, 38.90082], [-120.908, 38.89979]]]]} Restricted Access 2 34872 BLM 16163 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1 http://www.blm.gov/wo/st/en.html US Bureau of Land Management 1 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1   El Dorado 34 313.299 BLM 1963 National Public Lands 1 3
13037 13037 13036 {"type": "MultiPolygon", "coordinates": [[[[-120.91216, 38.91541], [-120.91209, 38.91725], [-120.90299, 38.9179], [-120.90314, 38.91614], [-120.91216, 38.91541]]], [[[-120.91554, 38.91278], [-120.91489, 38.9134], [-120.91489, 38.91518], [-120.91293, 38.91536], [-120.9126, 38.91537], [-120.91264, 38.91385], [-120.91256, 38.91389], [-120.90898, 38.91085], [-120.908, 38.91025], [-120.90805, 38.90805], [-120.91228, 38.90808], [-120.9148, 38.90807], [-120.91488, 38.91165], [-120.91488, 38.91253], [-120.9149, 38.91254], [-120.91511, 38.91239], [-120.91554, 38.91278]]]]} Restricted Access 2 34873 BLM 16163 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1 http://www.blm.gov/wo/st/en.html US Bureau of Land Management 1 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1   El Dorado 34 121.211 BLM 1963 National Public Lands 1 3
15622 15622 15621 {"type": "MultiPolygon", "coordinates": [[[[-120.99849, 38.71474], [-120.9984, 38.72556], [-120.99379, 38.72559], [-120.98918, 38.72557], [-120.98919, 38.72192], [-120.99263, 38.72192], [-120.99266, 38.72007], [-120.99614, 38.7201], [-120.99614, 38.71828], [-120.99268, 38.71828], [-120.99266, 38.71736], [-120.98803, 38.71733], [-120.98799, 38.72006], [-120.98457, 38.72003], [-120.9846, 38.71472], [-120.99849, 38.71474]]], [[[-120.99758, 38.75808], [-120.99756, 38.75933], [-120.99756, 38.76166], [-120.99276, 38.76166], [-120.99278, 38.75805], [-120.99758, 38.75808]]], [[[-121.01128, 38.76173], [-121.01128, 38.76536], [-121.00666, 38.76527], [-121.00665, 38.76166], [-121.01128, 38.76173]]], [[[-121.0308, 38.73276], [-121.03076, 38.73635], [-121.02602, 38.73638], [-121.02145, 38.73638], [-121.02146, 38.73434], [-121.02149, 38.7328], [-121.02595, 38.7328], [-121.0308, 38.73276]]], [[[-121.04395, 38.75464], [-121.04405, 38.75901], [-121.04389, 38.7595], [-121.04381, 38.75961], [-121.03042, 38.75956], [-121.0304, 38.76194], [-121.02538, 38.76194], [-121.02521, 38.75456], [-121.04395, 38.75464]]], [[[-121.03722, 38.76319], [-121.03512, 38.76242], [-121.03273, 38.7626], [-121.03226, 38.76226], [-121.03304, 38.76135], [-121.03306, 38.7614], [-121.0331, 38.76146], [-121.03318, 38.76147], [-121.03327, 38.76146], [-121.03337, 38.7614], [-121.03465, 38.76141], [-121.03489, 38.76138], [-121.03451, 38.76022], [-121.03598, 38.76012], [-121.03594, 38.76022], [-121.03594, 38.7603], [-121.03614, 38.76073], [-121.03636, 38.7611], [-121.03646, 38.7613], [-121.03657, 38.76144], [-121.03676, 38.76161], [-121.03687, 38.76175], [-121.03709, 38.76217], [-121.03715, 38.76242], [-121.03722, 38.76319]]]]} Restricted Access 2 21565 Pine Hill Ecological Reserve 23679 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Pine-Hill-ER El Dorado 34 666.591 Pine Hill ER 1979 State Conservation Area 8 2
15705 15705 15704 {"type": "Polygon", "coordinates": [[[-119.96788, 38.93696], [-119.96716, 38.93808], [-119.96692, 38.93882], [-119.96734, 38.93893], [-119.96695, 38.93973], [-119.96669, 38.94016], [-119.9666, 38.94043], [-119.9664, 38.94068], [-119.96631, 38.94081], [-119.96625, 38.94096], [-119.96611, 38.94122], [-119.96603, 38.94149], [-119.96602, 38.94177], [-119.96604, 38.94205], [-119.96572, 38.94257], [-119.96554, 38.94452], [-119.96536, 38.94453], [-119.96523, 38.94455], [-119.96498, 38.94464], [-119.96485, 38.94474], [-119.96423, 38.94526], [-119.9642, 38.94528], [-119.96415, 38.94528], [-119.964, 38.94391], [-119.96426, 38.94258], [-119.96414, 38.94251], [-119.96435, 38.94196], [-119.96434, 38.9418], [-119.96449, 38.94166], [-119.96448, 38.94092], [-119.96347, 38.94023], [-119.96245, 38.94032], [-119.96204, 38.93986], [-119.962, 38.93969], [-119.96214, 38.93955], [-119.96216, 38.93944], [-119.9634, 38.93944], [-119.9643, 38.93877], [-119.96429, 38.93697], [-119.96662, 38.93695], [-119.96788, 38.93696]]]} Restricted Access 2 24106 Bijou Municipal Golf Course 33083 1411 South Lake Tahoe, City of 990 City 2 City Agency 2 http://www.cityofslt.us/index.aspx?nid=196 City 2 1411 South Lake Tahoe, City of 954 City 2 City Agency 2   El Dorado 34 46.201 Bijou Municipal GC 1920 Local Recreation Area 3 4
15706 15706 15705 {"type": "Polygon", "coordinates": [[[-119.97095, 38.93236], [-119.96792, 38.93236], [-119.96793, 38.93432], [-119.9666, 38.93433], [-119.96663, 38.93074], [-119.97033, 38.93071], [-119.97138, 38.93201], [-119.97138, 38.93206], [-119.97135, 38.93211], [-119.97109, 38.93226], [-119.97095, 38.93236]]]} Restricted Access 2 24109 Disc Golf Course 33084 1411 South Lake Tahoe, City of 990 City 2 City Agency 2 http://www.cityofslt.us/index.aspx?nid=196 City 2 1411 South Lake Tahoe, City of 954 City 2 City Agency 2   El Dorado 34 22.894 Disc GC 0 Local Recreation Area 3 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);