units_with_maps

Table actions

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

13 rows where ACCESS_TYP = 3, GAP_STS = 2 and MNG_AGENCY = 593

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • American River Conservancy · 13 ✖

DES_TP 1

ACCESS_TYP 1

  • No Public Access · 13 ✖
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
3247 3247 3246 {"type": "Polygon", "coordinates": [[[-120.82265, 38.76759], [-120.82261, 38.77004], [-120.82166, 38.77002], [-120.8217, 38.76791], [-120.8204, 38.7679], [-120.8206, 38.76763], [-120.82087, 38.76723], [-120.82106, 38.7671], [-120.82135, 38.76686], [-120.82133, 38.76734], [-120.82168, 38.76727], [-120.82168, 38.76705], [-120.82179, 38.76716], [-120.82201, 38.76729], [-120.82256, 38.76752], [-120.82265, 38.76759]]]} No Public Access 3 23317 Chili Bar 17200 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 7.888 Chili Bar 0 Private Conservation 16 2
3260 3260 3259 {"type": "MultiPolygon", "coordinates": [[[[-120.7965, 38.61535], [-120.79633, 38.62279], [-120.79567, 38.62277], [-120.79185, 38.62276], [-120.7919, 38.61618], [-120.79189, 38.6153], [-120.7965, 38.61535]]], [[[-120.90694, 38.79848], [-120.90679, 38.79843], [-120.90681, 38.79852], [-120.90607, 38.79953], [-120.90651, 38.79973], [-120.90656, 38.80019], [-120.90546, 38.80173], [-120.90364, 38.80302], [-120.90349, 38.80296], [-120.9027, 38.79998], [-120.89999, 38.79985], [-120.90024, 38.79404], [-120.90136, 38.79491], [-120.90499, 38.79766], [-120.9066, 38.79767], [-120.90691, 38.79838], [-120.90694, 38.79848]]]]} No Public Access 3 23332 Van Noord 26829 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 154.278 Van Noord 0 Private Conservation 16 2
3279 3279 3278 {"type": "Polygon", "coordinates": [[[-120.9889, 38.82713], [-120.98787, 38.82714], [-120.98483, 38.82713], [-120.98489, 38.82712], [-120.98485, 38.82698], [-120.98311, 38.8197], [-120.9866, 38.81975], [-120.98651, 38.82011], [-120.98625, 38.82065], [-120.98624, 38.82099], [-120.98631, 38.82126], [-120.9863, 38.8213], [-120.9865, 38.82179], [-120.98694, 38.82251], [-120.98712, 38.82289], [-120.9872, 38.823], [-120.98759, 38.82338], [-120.98777, 38.82376], [-120.98792, 38.82394], [-120.98822, 38.82421], [-120.98854, 38.82472], [-120.98858, 38.82499], [-120.98872, 38.82552], [-120.989, 38.82633], [-120.98901, 38.8266], [-120.98898, 38.82699], [-120.9889, 38.82713]]]} No Public Access 3 23318 Cronan Ranch 17831 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 63.637 Cronan Ranch 0 Private Conservation 16 2
3280 3280 3279 {"type": "Polygon", "coordinates": [[[-120.93652, 38.63111], [-120.9365, 38.63193], [-120.93417, 38.63196], [-120.93415, 38.63114], [-120.93652, 38.63111]]]} No Public Access 3 23322 Lipa Waterfalls 21329 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 4.642 Lipa Waterfalls 0 Private Conservation 16 2
3281 3281 3280 {"type": "Polygon", "coordinates": [[[-121.04125, 38.76909], [-121.03825, 38.76914], [-121.03819, 38.76642], [-121.04048, 38.76638], [-121.04117, 38.76638], [-121.04125, 38.76909]]]} No Public Access 3 23324 Nash 22635 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 19.438 Nash 0 Private Conservation 16 2
3282 3282 3281 {"type": "Polygon", "coordinates": [[[-121.04117, 38.76638], [-121.04048, 38.76638], [-121.03502, 38.76647], [-121.03499, 38.76554], [-121.04021, 38.76549], [-121.04023, 38.76594], [-121.04115, 38.76594], [-121.04117, 38.76638]]]} No Public Access 3 23325 Pearson 23548 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 12.35 Pearson 0 Private Conservation 16 2
3283 3283 3282 {"type": "Polygon", "coordinates": [[[-120.73962, 38.6495], [-120.73921, 38.64993], [-120.7388, 38.65022], [-120.73853, 38.65033], [-120.73807, 38.65074], [-120.73779, 38.65096], [-120.73712, 38.65128], [-120.73623, 38.65135], [-120.73528, 38.64942], [-120.73449, 38.64788], [-120.73405, 38.6479], [-120.73339, 38.64639], [-120.73504, 38.64557], [-120.73852, 38.64548], [-120.73911, 38.64587], [-120.73675, 38.6478], [-120.73664, 38.64821], [-120.73757, 38.64914], [-120.73805, 38.64939], [-120.73962, 38.6495]]]} No Public Access 3 23327 Pollock 23873 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 43.967 Pollock 0 Private Conservation 16 2
3903 3903 3902 {"type": "Polygon", "coordinates": [[[-121.03542, 38.78141], [-121.03507, 38.78183], [-121.0346, 38.78212], [-121.03407, 38.78232], [-121.03329, 38.78251], [-121.03294, 38.78277], [-121.03281, 38.78309], [-121.03251, 38.78343], [-121.03212, 38.78352], [-121.03173, 38.78352], [-121.03122, 38.78337], [-121.0308, 38.78336], [-121.03049, 38.78342], [-121.03022, 38.78367], [-121.02605, 38.7837], [-121.02584, 38.77615], [-121.02577, 38.77476], [-121.02639, 38.77374], [-121.02717, 38.77352], [-121.03037, 38.77412], [-121.0309, 38.77359], [-121.03129, 38.77362], [-121.03139, 38.7737], [-121.03083, 38.77451], [-121.03091, 38.77531], [-121.03245, 38.77575], [-121.03465, 38.7743], [-121.03466, 38.77614], [-121.02705, 38.77614], [-121.02704, 38.77615], [-121.03315, 38.77619], [-121.03315, 38.77636], [-121.03329, 38.77676], [-121.03362, 38.77707], [-121.03421, 38.77714], [-121.03468, 38.77725], [-121.03503, 38.77769], [-121.03515, 38.77801], [-121.03498, 38.77838], [-121.03517, 38.77907], [-121.03541, 38.77968], [-121.03542, 38.78141]]]} No Public Access 3 36005 Brush Creek Ranch 16454 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 188.734 Brush Creek Ranch 0 Private Conservation 16 2
6350 6350 6349 {"type": "Polygon", "coordinates": [[[-120.69679, 38.57498], [-120.69649, 38.5788], [-120.68726, 38.57844], [-120.68746, 38.57462], [-120.69186, 38.57497], [-120.69679, 38.57498]]]} No Public Access 3 47503 Horan 31218 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 82.976 Horan 0 Private Conservation 16 2
11473 11473 11472 {"type": "Polygon", "coordinates": [[[-120.99733, 38.78125], [-120.99384, 38.77961], [-120.99126, 38.77775], [-120.99111, 38.77741], [-120.99213, 38.77714], [-120.99327, 38.77628], [-120.99328, 38.77611], [-120.99356, 38.77581], [-120.99483, 38.77689], [-120.99715, 38.77875], [-120.99733, 38.77874], [-120.99733, 38.78125]]]} No Public Access 3 23333 Weiner 27332 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 36.591 Weiner 0 Private Conservation 16 2
11491 11491 11490 {"type": "Polygon", "coordinates": [[[-120.77806, 38.63768], [-120.77462, 38.63758], [-120.77107, 38.63752], [-120.77102, 38.64128], [-120.76872, 38.64124], [-120.76429, 38.64111], [-120.76022, 38.64107], [-120.7573, 38.64112], [-120.75802, 38.64063], [-120.75802, 38.64061], [-120.75717, 38.64113], [-120.7498, 38.64127], [-120.7499, 38.63796], [-120.74989, 38.63739], [-120.74996, 38.63668], [-120.74997, 38.6353], [-120.75, 38.6339], [-120.75449, 38.63396], [-120.75835, 38.63414], [-120.75949, 38.63422], [-120.76853, 38.63428], [-120.76861, 38.63259], [-120.76878, 38.63261], [-120.7694, 38.63258], [-120.76978, 38.63253], [-120.76997, 38.63226], [-120.77073, 38.63165], [-120.77203, 38.63101], [-120.77281, 38.63056], [-120.77334, 38.63035], [-120.77402, 38.63023], [-120.77471, 38.63031], [-120.77577, 38.6302], [-120.7762, 38.63021], [-120.77666, 38.63042], [-120.77691, 38.63036], [-120.77704, 38.63021], [-120.77707, 38.62996], [-120.77798, 38.62996], [-120.77804, 38.63242], [-120.77806, 38.63388], [-120.77806, 38.63768]], [[-120.7581, 38.63436], [-120.75809, 38.63434], [-120.75745, 38.63465], [-120.75712, 38.63501], [-120.75757, 38.63474], [-120.75777, 38.63457], [-120.7581, 38.63436]], [[-120.75869, 38.64016], [-120.7587, 38.64017], [-120.75904, 38.63994], [-120.75941, 38.63957], [-120.75945, 38.63935], [-120.75944, 38.63935], [-120.75926, 38.63961], [-120.75869, 38.64016]], [[-120.75958, 38.63877], [-120.75915, 38.63838], [-120.75911, 38.63837], [-120.75911, 38.63839], [-120.75954, 38.63877], [-120.75952, 38.63915], [-120.75949, 38.63923], [-120.7595, 38.63924], [-120.75959, 38.63913], [-120.75958, 38.63877]]]} No Public Access 3 23320 Ladies Valley 20825 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 485.277 Ladies Valley 0 Private Conservation 16 2
11492 11492 11491 {"type": "Polygon", "coordinates": [[[-120.97547, 38.67216], [-120.97547, 38.67475], [-120.96631, 38.67478], [-120.96624, 38.67115], [-120.97194, 38.67113], [-120.97229, 38.67133], [-120.97256, 38.67157], [-120.97292, 38.67184], [-120.97378, 38.67217], [-120.97547, 38.67216]]]} No Public Access 3 23329 Smith and Gabb2 25567 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 72.885 Smith and Gabb2 0 Private Conservation 16 2
11493 11493 11492 {"type": "Polygon", "coordinates": [[[-120.9753, 38.72624], [-120.97528, 38.7292], [-120.97223, 38.72922], [-120.97223, 38.72627], [-120.97243, 38.72625], [-120.97326, 38.72601], [-120.9753, 38.72624]]]} No Public Access 3 23330 Thomas 26305 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 22.424 Thomas 0 Private Conservation 16 2

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