units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 3, LAYER = 10 and MNG_AGENCY = 50

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Save the Redwoods League · 2 ✖

ACCESS_TYP 1

  • No Public Access · 2 ✖
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
12688 12688 12687 {"type": "Polygon", "coordinates": [[[-123.83146, 39.72663], [-123.83143, 39.72668], [-123.83132, 39.72676], [-123.83116, 39.72681], [-123.83096, 39.72683], [-123.8309, 39.72688], [-123.83086, 39.72695], [-123.83085, 39.727], [-123.83085, 39.72714], [-123.83084, 39.72726], [-123.83071, 39.72754], [-123.83078, 39.72761], [-123.83077, 39.72765], [-123.83065, 39.72767], [-123.83063, 39.72778], [-123.83053, 39.7279], [-123.83052, 39.72794], [-123.83055, 39.72807], [-123.83064, 39.72812], [-123.83091, 39.7281], [-123.83098, 39.72814], [-123.83119, 39.72818], [-123.83121, 39.72824], [-123.83119, 39.72835], [-123.83127, 39.72842], [-123.83126, 39.7285], [-123.83123, 39.72855], [-123.83118, 39.72857], [-123.8311, 39.72859], [-123.83106, 39.72859], [-123.83095, 39.72855], [-123.83088, 39.72851], [-123.8308, 39.72851], [-123.83074, 39.72855], [-123.83074, 39.72859], [-123.83087, 39.72871], [-123.82548, 39.72866], [-123.8199, 39.72866], [-123.82007, 39.72771], [-123.81978, 39.72773], [-123.81941, 39.72767], [-123.81892, 39.7272], [-123.81835, 39.72704], [-123.81823, 39.72655], [-123.81849, 39.72625], [-123.81855, 39.72551], [-123.81834, 39.72548], [-123.81816, 39.72494], [-123.81858, 39.72449], [-123.81843, 39.72437], [-123.81805, 39.72432], [-123.81535, 39.72206], [-123.81496, 39.72203], [-123.81466, 39.72193], [-123.81443, 39.72182], [-123.81392, 39.72201], [-123.81347, 39.72226], [-123.81315, 39.72247], [-123.81299, 39.72247], [-123.81267, 39.7223], [-123.81169, 39.72253], [-123.81178, 39.72144], [-123.81176, 39.71622], [-123.8196, 39.71633], [-123.81988, 39.71646], [-123.82011, 39.7166], [-123.82027, 39.71666], [-123.8206, 39.71683], [-123.82102, 39.71696], [-123.82136, 39.71713], [-123.82166, 39.71723], [-123.82186, 39.71727], [-123.8221, 39.71726], [-123.82258, 39.71736], [-123.8229, 39.71745], [-123.82358, 39.71774], [-123.82376, 39.71776], [-123.82398, 39.71786], [-123.82442, 39.71796], [-123.8248, 39.71814], [-123.82517, 39.71849], [-123.82542, 39.71878], [-123.82578, 39.71915], [-123.82596, 39.71928], [-123.82619, 39.71949], [-123.82624, 39.71953], [-123.82628, 39.71959], [-123.82643, 39.71977], [-123.82646, 39.71985], [-123.82663, 39.72008], [-123.82677, 39.72022], [-123.82699, 39.72042], [-123.82712, 39.72048], [-123.82719, 39.72058], [-123.82766, 39.72112], [-123.8279, 39.72132], [-123.82819, 39.72162], [-123.8283, 39.72168], [-123.82834, 39.72174], [-123.8284, 39.72179], [-123.82847, 39.72181], [-123.82873, 39.72202], [-123.8288, 39.72205], [-123.82889, 39.72212], [-123.82897, 39.72216], [-123.82909, 39.72228], [-123.82913, 39.72229], [-123.82916, 39.72232], [-123.82918, 39.7224], [-123.82936, 39.72256], [-123.82936, 39.72261], [-123.82934, 39.72264], [-123.82936, 39.72278], [-123.82943, 39.72295], [-123.82951, 39.72304], [-123.82957, 39.72305], [-123.8296, 39.72303], [-123.82967, 39.72302], [-123.82972, 39.72306], [-123.82973, 39.7231], [-123.82978, 39.72311], [-123.82981, 39.72307], [-123.83001, 39.72303], [-123.83016, 39.72305], [-123.83023, 39.72304], [-123.83032, 39.72305], [-123.83042, 39.72313], [-123.83051, 39.72319], [-123.83053, 39.72325], [-123.83052, 39.72329], [-123.83055, 39.72332], [-123.83054, 39.72354], [-123.83052, 39.7236], [-123.83042, 39.72371], [-123.83027, 39.72373], [-123.83023, 39.72377], [-123.83021, 39.72384], [-123.83011, 39.72395], [-123.83009, 39.72405], [-123.83008, 39.72421], [-123.83, 39.72448], [-123.83, 39.72452], [-123.83007, 39.7247], [-123.83004, 39.72482], [-123.83007, 39.72501], [-123.83005, 39.7251], [-123.83005, 39.72518], [-123.83007, 39.72529], [-123.83011, 39.72539], [-123.83005, 39.7255], [-123.83009, 39.72578], [-123.83013, 39.72585], [-123.83023, 39.72599], [-123.83036, 39.72611], [-123.83041, 39.72614], [-123.8305, 39.72614], [-123.83055, 39.72611], [-123.83069, 39.72597], [-123.83075, 39.72595], [-123.83082, 39.72596], [-123.83088, 39.726], [-123.83097, 39.72611], [-123.83106, 39.72613], [-123.83116, 39.72626], [-123.8312, 39.72636], [-123.83125, 39.72641], [-123.83142, 39.72652], [-123.83146, 39.72659], [-123.83146, 39.72663]]]} No Public Access 3 29682 Cape Vizcaino 16831 3074 Save the Redwoods League 52 Non Profit 6 Non Profit - Land Trust 10 http://www.savetheredwoods.org Non Governmental Organization 10 3074 Save the Redwoods League 50 Non Profit 6 Non Profit - Land Trust 10   Mendocino 24 374.258 Cape Vizcaino 0 Private Conservation 16 2
13164 13164 13163 {"type": "Polygon", "coordinates": [[[-123.14988, 38.62899], [-123.12765, 38.62914], [-123.12689, 38.61779], [-123.13593, 38.6178], [-123.14053, 38.61778], [-123.14063, 38.62152], [-123.14948, 38.6215], [-123.14988, 38.62899]]]} No Public Access 3 35117 The Cedars Area of Critical Environmental Concern 28162 3074 Save the Redwoods League 52 Non Profit 6 Non Profit - Land Trust 10 http://www.savetheredwoods.org Non Governmental Organization 10 3074 Save the Redwoods League 50 Non Profit 6 Non Profit - Land Trust 10 http://www.savetheredwoods.org/our-work/protect/create/acres-protected-by-the-league/ Sonoma 16 522.768 The Cedars Area of Critical Environmental Concern 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]);