units_with_maps

Table actions

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

9 rows where COUNTY = 45, MNG_AGENCY = 128 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

DES_TP 9

ACCESS_TYP 2

MNG_AG_TYP 1

  • State Agency · 9 ✖

MNG_AGENCY 1

  • Other State · 9 ✖
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
3458 3458 3457 {"type": "Polygon", "coordinates": [[[-123.78183, 40.4786], [-123.78172, 40.47967], [-123.78083, 40.47987], [-123.78082, 40.47937], [-123.78064, 40.47893], [-123.78183, 40.4786]]]} Open Access 1 35585 Other State 43 23264 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 2.359 Other State 43   None 287  
3467 3467 3466 {"type": "Polygon", "coordinates": [[[-123.67235, 40.14486], [-123.67136, 40.14484], [-123.67139, 40.14413], [-123.67233, 40.14419], [-123.67235, 40.14486]]]} Open Access 1 35712 Other State 11 23251 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 1.562 Other State 11   None 289  
3858 3858 3857 {"type": "Polygon", "coordinates": [[[-123.83901, 40.46367], [-123.839, 40.46751], [-123.83762, 40.46759], [-123.83761, 40.46748], [-123.83745, 40.46699], [-123.83691, 40.46742], [-123.83606, 40.46793], [-123.83528, 40.46801], [-123.83421, 40.46791], [-123.83496, 40.46784], [-123.83542, 40.46767], [-123.83587, 40.46725], [-123.83707, 40.46638], [-123.83754, 40.46561], [-123.8379, 40.46507], [-123.83813, 40.46474], [-123.83856, 40.46406], [-123.83884, 40.46367], [-123.83901, 40.46367]]]} Open Access 1 35592 Other State 4 23263 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 14.851 Other State 4   None 326  
3860 3860 3859 {"type": "Polygon", "coordinates": [[[-123.84468, 40.46319], [-123.84303, 40.46319], [-123.84302, 40.4623], [-123.8433, 40.46219], [-123.84379, 40.4621], [-123.84428, 40.46233], [-123.8444, 40.46257], [-123.84445, 40.46277], [-123.84468, 40.46319]]]} Open Access 1 35598 Other State 5 23265 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 3.304 Other State 5   None 327  
3861 3861 3860 {"type": "Polygon", "coordinates": [[[-123.62865, 40.48836], [-123.62865, 40.48852], [-123.62837, 40.48861], [-123.62769, 40.48868], [-123.62714, 40.48877], [-123.62629, 40.48945], [-123.62628, 40.48822], [-123.62671, 40.48819], [-123.62692, 40.48819], [-123.62682, 40.48845], [-123.62683, 40.48846], [-123.62714, 40.48835], [-123.62753, 40.4883], [-123.62865, 40.48836]]]} Open Access 1 35607 Other State 18 23254 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 2.876 Other State 18   None 328  
3862 3862 3861 {"type": "Polygon", "coordinates": [[[-123.67237, 40.14091], [-123.67235, 40.14147], [-123.67148, 40.1415], [-123.6715, 40.14089], [-123.67237, 40.14091]]]} Open Access 1 35608 Other State 14 23252 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 1.203 Other State 14   None 329  
4768 4768 4767 {"type": "MultiPolygon", "coordinates": [[[[-123.79434, 40.47335], [-123.79344, 40.47461], [-123.79172, 40.47464], [-123.7917, 40.47345], [-123.79184, 40.4734], [-123.79189, 40.47397], [-123.7929, 40.47349], [-123.7938, 40.47316], [-123.79434, 40.47335]]], [[[-123.80067, 40.46825], [-123.80044, 40.46859], [-123.80036, 40.4688], [-123.80034, 40.46903], [-123.80011, 40.46906], [-123.80066, 40.46963], [-123.79996, 40.46972], [-123.79992, 40.46966], [-123.79964, 40.46971], [-123.79961, 40.46959], [-123.79997, 40.46954], [-123.8001, 40.46907], [-123.80009, 40.46906], [-123.79735, 40.46919], [-123.79647, 40.46944], [-123.79653, 40.46852], [-123.79661, 40.46843], [-123.79718, 40.46811], [-123.79754, 40.46817], [-123.79789, 40.46815], [-123.7983, 40.46803], [-123.7993, 40.46811], [-123.79937, 40.46813], [-123.79941, 40.46807], [-123.79936, 40.46805], [-123.79938, 40.46802], [-123.80067, 40.46825]]], [[[-124.09997, 41.25922], [-124.0996, 41.26108], [-124.09945, 41.26144], [-124.09924, 41.26217], [-124.09926, 41.26243], [-124.09904, 41.26333], [-124.09904, 41.26429], [-124.09931, 41.26516], [-124.09974, 41.26573], [-124.09975, 41.2659], [-124.0997, 41.2661], [-124.09935, 41.26665], [-124.09928, 41.26672], [-124.09862, 41.26813], [-124.09732, 41.27163], [-124.097, 41.27279], [-124.09665, 41.27363], [-124.09622, 41.27454], [-124.09616, 41.27463], [-124.09565, 41.27589], [-124.09539, 41.27717], [-124.09365, 41.27719], [-124.09391, 41.2761], [-124.09413, 41.27503], [-124.09435, 41.27356], [-124.09491, 41.27158], [-124.09529, 41.27031], [-124.09573, 41.26915], [-124.09606, 41.2682], [-124.09669, 41.26687], [-124.09668, 41.26686], [-124.09536, 41.26684], [-124.09563, 41.26017], [-124.09518, 41.25926], [-124.09688, 41.25931], [-124.09997, 41.25922]]], [[[-124.19517, 40.77569], [-124.19492, 40.77704], [-124.19447, 40.77695], [-124.19466, 40.77632], [-124.19483, 40.77561], [-124.19517, 40.77569]]], [[[-124.26888, 40.62856], [-124.26886, 40.62923], [-124.26704, 40.62852], [-124.26888, 40.62856], [-124.26888, 40.62856]]]]} Open Access 1 46915 Unnamed site - Other State 28654 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 140.719   0 State Other or Unknown 104 4
5644 5644 5643 {"type": "Polygon", "coordinates": [[[-124.11238, 40.99977], [-124.11173, 41.00363], [-124.1111, 41.00601], [-124.11088, 41.00673], [-124.10992, 41.00671], [-124.11008, 41.00583], [-124.11159, 41.00045], [-124.11204, 40.99978], [-124.11238, 40.99977]]]} Unknown Access 4 46935 Clam Beach Ponds 30554 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 14.521 Clam Beach Ponds   None 458  
13746 13746 13745 {"type": "Polygon", "coordinates": [[[-123.84302, 40.46142], [-123.84302, 40.4623], [-123.84241, 40.46266], [-123.84217, 40.46286], [-123.84184, 40.46272], [-123.84171, 40.46257], [-123.84194, 40.46248], [-123.84194, 40.46233], [-123.84169, 40.46226], [-123.84173, 40.46216], [-123.84179, 40.46206], [-123.84179, 40.46192], [-123.84166, 40.46178], [-123.84133, 40.46157], [-123.84123, 40.46146], [-123.84168, 40.46116], [-123.8422, 40.4614], [-123.84302, 40.46142]]]} Open Access 1 36259 Other State 37 23260 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 4.068 Other State 37   None 1182  

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