superunits_with_maps

Table actions

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

13 rows where ACCESS_TYP = 3, MNG_AGENCY = 593 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 13 ✖

MNG_AGENCY 1

  • American River Conservancy · 13 ✖

ACCESS_TYP 1

  • No Public Access · 13 ✖
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
2305 2305 2304 {"type": "Polygon", "coordinates": [[[-121.03542, 38.78141], [-121.03507, 38.78183], [-121.0346, 38.78212], [-121.03407, 38.78232], [-121.03329, 38.78251], [-121.03295, 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.03036, 38.77412], [-121.0309, 38.77359], [-121.03129, 38.77362], [-121.03139, 38.7737], [-121.03083, 38.77451], [-121.03091, 38.7753], [-121.03245, 38.77575], [-121.03465, 38.7743], [-121.03466, 38.77614], [-121.02818, 38.77614], [-121.02817, 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.03499, 38.77838], [-121.03517, 38.77907], [-121.03541, 38.77968], [-121.03542, 38.78141]]]} No Public Access 3 Brush Creek Ranch   16454 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 188.843 Brush Creek Ranch  
2904 2904 2903 {"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.76733], [-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 Chili Bar   17200 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 7.905 Chili Bar  
3352 3352 3351 {"type": "Polygon", "coordinates": [[[-120.9889, 38.82713], [-120.98787, 38.82714], [-120.98483, 38.82713], [-120.98488, 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.98631, 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 Cronan Ranch   17831 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 63.637 Cronan Ranch  
5864 5864 5863 {"type": "Polygon", "coordinates": [[[-120.77806, 38.63768], [-120.77462, 38.63758], [-120.77107, 38.63753], [-120.77102, 38.64128], [-120.76872, 38.64124], [-120.76429, 38.64111], [-120.76022, 38.64107], [-120.7573, 38.64112], [-120.758, 38.64065], [-120.758, 38.64063], [-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.76852, 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.75809, 38.63436], [-120.75808, 38.63434], [-120.75745, 38.63465], [-120.75717, 38.63498], [-120.75718, 38.63498], [-120.75757, 38.63474], [-120.75777, 38.63457], [-120.75809, 38.63436]], [[-120.75945, 38.63936], [-120.75943, 38.63936], [-120.75926, 38.63961], [-120.7587, 38.64015], [-120.7587, 38.64016], [-120.75904, 38.63994], [-120.75941, 38.63957], [-120.75945, 38.63936]], [[-120.75958, 38.63877], [-120.75915, 38.63838], [-120.75911, 38.63838], [-120.75954, 38.63877], [-120.75951, 38.63922], [-120.75959, 38.63913], [-120.75958, 38.63877]]]} No Public Access 3 Ladies Valley   20825 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 485.344 Ladies Valley  
6262 6262 6261 {"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 Lipa Waterfalls   21329 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 4.642 Lipa Waterfalls  
7305 7305 7304 {"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 Nash   22635 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 19.436 Nash  
8047 8047 8046 {"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 Pearson   23548 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 12.353 Pearson  
8285 8285 8284 {"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.64789], [-120.73405, 38.6479], [-120.73339, 38.64639], [-120.73504, 38.64557], [-120.73852, 38.64548], [-120.73911, 38.64587], [-120.73675, 38.64779], [-120.73664, 38.64821], [-120.73757, 38.64914], [-120.73805, 38.64939], [-120.73962, 38.6495]]]} No Public Access 3 Pollock   23873 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 43.973 Pollock  
9725 9725 9724 {"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 Smith and Gabb2   25567 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 72.885 Smith and Gabb2  
10322 10322 10321 {"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 Thomas   26305 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 22.423 Thomas  
10657 10657 10656 {"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.79844], [-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.79765], [-120.9066, 38.79767], [-120.90691, 38.79838], [-120.90694, 38.79848]]]]} No Public Access 3 Van Noord   26829 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 154.299 Van Noord  
11082 11082 11081 {"type": "Polygon", "coordinates": [[[-120.99733, 38.78125], [-120.99384, 38.77961], [-120.99126, 38.77775], [-120.99111, 38.77741], [-120.99214, 38.77714], [-120.99327, 38.77628], [-120.99328, 38.77611], [-120.99356, 38.77581], [-120.99483, 38.77689], [-120.99715, 38.77874], [-120.99733, 38.77874], [-120.99733, 38.78125]]]} No Public Access 3 Weiner   27332 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 36.59 Weiner  
13725 13725 13724 {"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 Horan   31218 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 82.974 Horan  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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