units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, DES_TP = 4 and YR_EST = 1984

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Local Conservation Area · 1 ✖

ACCESS_TYP 1

  • Open Access · 1 ✖
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
16935 16935 16934 {"type": "Polygon", "coordinates": [[[-122.50541, 37.90591], [-122.50534, 37.90605], [-122.50522, 37.90616], [-122.50459, 37.90659], [-122.50382, 37.90704], [-122.50302, 37.90743], [-122.50218, 37.90776], [-122.50306, 37.90921], [-122.503, 37.90921], [-122.503, 37.90923], [-122.5049, 37.91201], [-122.50298, 37.912], [-122.49847, 37.91206], [-122.49852, 37.91399], [-122.49878, 37.91399], [-122.49879, 37.91419], [-122.49867, 37.91419], [-122.49868, 37.91522], [-122.49851, 37.91523], [-122.49854, 37.91707], [-122.49503, 37.91709], [-122.49504, 37.91835], [-122.49507, 37.91938], [-122.49505, 37.92006], [-122.49507, 37.92109], [-122.49451, 37.92098], [-122.49223, 37.92006], [-122.49223, 37.91987], [-122.49322, 37.91967], [-122.49337, 37.91953], [-122.49337, 37.91851], [-122.49214, 37.91723], [-122.49208, 37.91532], [-122.48721, 37.91542], [-122.48643, 37.91494], [-122.48659, 37.91492], [-122.48672, 37.91487], [-122.48683, 37.91481], [-122.48693, 37.91471], [-122.48698, 37.91462], [-122.48701, 37.91452], [-122.487, 37.91416], [-122.48796, 37.91427], [-122.48823, 37.91388], [-122.48798, 37.91363], [-122.48811, 37.91295], [-122.48762, 37.91287], [-122.48746, 37.91285], [-122.48729, 37.91287], [-122.48709, 37.91292], [-122.48679, 37.91307], [-122.48619, 37.91331], [-122.48584, 37.91313], [-122.48495, 37.91399], [-122.48425, 37.91354], [-122.48423, 37.91236], [-122.48228, 37.9111], [-122.48225, 37.91002], [-122.48313, 37.91002], [-122.48365, 37.9096], [-122.48364, 37.9088], [-122.48223, 37.90818], [-122.48221, 37.90669], [-122.48226, 37.90505], [-122.4841, 37.90617], [-122.48678, 37.9079], [-122.48759, 37.90775], [-122.48808, 37.908], [-122.48821, 37.90809], [-122.48859, 37.90739], [-122.48946, 37.90655], [-122.49045, 37.90632], [-122.49166, 37.90576], [-122.4919, 37.90567], [-122.49233, 37.90566], [-122.49197, 37.90645], [-122.49204, 37.90683], [-122.49381, 37.90723], [-122.49382, 37.90786], [-122.4943, 37.90815], [-122.49519, 37.90782], [-122.4953, 37.90669], [-122.49637, 37.90626], [-122.49695, 37.90579], [-122.49702, 37.90586], [-122.4965, 37.90663], [-122.49633, 37.90707], [-122.49698, 37.90724], [-122.49692, 37.90747], [-122.49688, 37.90769], [-122.49688, 37.90778], [-122.49691, 37.90788], [-122.497, 37.908], [-122.49712, 37.90808], [-122.49726, 37.90813], [-122.49743, 37.90814], [-122.49733, 37.90834], [-122.49744, 37.90873], [-122.49717, 37.90893], [-122.49728, 37.90932], [-122.49841, 37.90937], [-122.49929, 37.9087], [-122.49958, 37.90828], [-122.49959, 37.90789], [-122.49965, 37.90787], [-122.4997, 37.90783], [-122.50075, 37.9077], [-122.50172, 37.90737], [-122.50196, 37.90737], [-122.50285, 37.90723], [-122.50336, 37.90661], [-122.50384, 37.90658], [-122.50426, 37.90627], [-122.50423, 37.90599], [-122.50406, 37.90565], [-122.50473, 37.90506], [-122.50521, 37.90539], [-122.50532, 37.90549], [-122.5054, 37.90561], [-122.50543, 37.9057], [-122.50543, 37.9058], [-122.50541, 37.90591]], [[-122.4969, 37.91227], [-122.4969, 37.91226], [-122.49682, 37.91205], [-122.49633, 37.91212], [-122.49642, 37.91236], [-122.4969, 37.91227]]]} Open Access 1 166 Ring Mountain Open Space Preserve 31485 2070 Marin County Open Space District 44 Special District 4 Recreation/Parks District 4 http://www.marincountyparks.org/Depts/PK.aspx Special District 4 2070 Marin County Open Space District 43 Special District 4 Recreation/Parks District 4 http://www.marincountyparks.org/depts/pk/divisions/open-space/ring-mountain Marin 23 389.212 Ring Mtn. OSP 1984 Local Conservation Area 4 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]);