superunits_with_maps

Table actions

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

3 rows where LAYER = 10 and MNG_AGENCY = 797

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Northcoast Regional Land Trust · 3 ✖

ACCESS_TYP 1

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
11549 11549 11548 {"type": "Polygon", "coordinates": [[[-124.18306, 40.75177], [-124.18271, 40.75197], [-124.18253, 40.75214], [-124.18242, 40.75249], [-124.18125, 40.75249], [-124.18016, 40.75287], [-124.17957, 40.75286], [-124.1794, 40.75284], [-124.17933, 40.75296], [-124.17898, 40.75279], [-124.17838, 40.7527], [-124.17814, 40.7527], [-124.1781, 40.7529], [-124.17789, 40.75289], [-124.17787, 40.75291], [-124.17827, 40.75381], [-124.17661, 40.7538], [-124.17659, 40.75401], [-124.17628, 40.75401], [-124.17627, 40.7538], [-124.17427, 40.75379], [-124.17328, 40.75483], [-124.17331, 40.75172], [-124.17589, 40.75172], [-124.17592, 40.75152], [-124.17591, 40.75105], [-124.17625, 40.75064], [-124.1765, 40.75041], [-124.17694, 40.75024], [-124.17736, 40.75018], [-124.17754, 40.7502], [-124.17786, 40.75028], [-124.17804, 40.75038], [-124.1782, 40.75052], [-124.17822, 40.75174], [-124.18306, 40.75177]]]} Unknown Access 4 Martin Slough   30246 3294 Northcoast Regional Land Trust 797 Non Profit 6 Non Profit - Land Trust 10 http://www.ncrlt.org/ Non Governmental Organization 10 41.212 Martin Slough  
11550 11550 11549 {"type": "Polygon", "coordinates": [[[-124.10154, 40.78543], [-124.09837, 40.78644], [-124.09699, 40.78702], [-124.09651, 40.78736], [-124.09547, 40.78733], [-124.09421, 40.78637], [-124.09389, 40.78634], [-124.0936, 40.78639], [-124.09263, 40.78672], [-124.09246, 40.78675], [-124.09223, 40.78675], [-124.09194, 40.78672], [-124.09156, 40.78664], [-124.09121, 40.78653], [-124.09109, 40.78639], [-124.09099, 40.78622], [-124.0909, 40.78602], [-124.09074, 40.7858], [-124.09059, 40.78568], [-124.09047, 40.78561], [-124.08992, 40.78549], [-124.0895, 40.78533], [-124.08937, 40.78525], [-124.08908, 40.78492], [-124.08893, 40.78461], [-124.08855, 40.784], [-124.08832, 40.78382], [-124.08816, 40.78381], [-124.0881, 40.78368], [-124.09263, 40.78369], [-124.09692, 40.78363], [-124.09748, 40.78367], [-124.09845, 40.78402], [-124.09916, 40.78435], [-124.10076, 40.78497], [-124.10114, 40.78505], [-124.10152, 40.78511], [-124.10154, 40.78543]]]} Unknown Access 4 Freshwater Farms Reserve   30247 3294 Northcoast Regional Land Trust 797 Non Profit 6 Non Profit - Land Trust 10 http://www.ncrlt.org/ Non Governmental Organization 10 71.839 Freshwater Farms Reserve  
13001 13001 13000 {"type": "Polygon", "coordinates": [[[-124.0807, 41.29969], [-124.07697, 41.29966], [-124.07626, 41.29946], [-124.07585, 41.29923], [-124.07587, 41.29685], [-124.07565, 41.29683], [-124.07566, 41.29585], [-124.07231, 41.29587], [-124.07002, 41.29466], [-124.0698, 41.29466], [-124.06958, 41.29464], [-124.06937, 41.29458], [-124.06913, 41.29447], [-124.06864, 41.29419], [-124.0685, 41.29408], [-124.06839, 41.29394], [-124.06832, 41.29379], [-124.06804, 41.29293], [-124.06774, 41.29221], [-124.07421, 41.29216], [-124.07424, 41.29259], [-124.07436, 41.29303], [-124.0745, 41.29335], [-124.07449, 41.29338], [-124.07457, 41.29353], [-124.07475, 41.29379], [-124.07488, 41.29396], [-124.07469, 41.29407], [-124.07424, 41.29423], [-124.07423, 41.29425], [-124.07428, 41.29436], [-124.0745, 41.29432], [-124.0747, 41.29432], [-124.07489, 41.29434], [-124.07508, 41.2944], [-124.07532, 41.29453], [-124.07578, 41.29489], [-124.07577, 41.29674], [-124.08069, 41.29671], [-124.0807, 41.29969]]]} Unknown Access 4 McNamara Dairy   30242 3294 Northcoast Regional Land Trust 797 Non Profit 6 Non Profit - Land Trust 10 http://www.ncrlt.org/ Non Governmental Organization 10 80.732 McNamara Dairy  

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