superunits_with_maps

Table actions

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

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

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 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
15560 15560 15559 {"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.50219, 37.90777], [-122.50306, 37.90921], [-122.50301, 37.90921], [-122.503, 37.90923], [-122.5049, 37.91201], [-122.50298, 37.912], [-122.49848, 37.91207], [-122.49852, 37.91398], [-122.49878, 37.91399], [-122.49879, 37.91419], [-122.49867, 37.9142], [-122.49868, 37.91522], [-122.49851, 37.91523], [-122.49854, 37.91707], [-122.49504, 37.9171], [-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.49336, 37.91953], [-122.49337, 37.91852], [-122.49214, 37.91723], [-122.49208, 37.91533], [-122.48721, 37.91542], [-122.48643, 37.91494], [-122.48659, 37.91492], [-122.48671, 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.91426], [-122.48822, 37.91388], [-122.48798, 37.91363], [-122.4881, 37.91295], [-122.48762, 37.91287], [-122.48746, 37.91285], [-122.48729, 37.91287], [-122.48709, 37.91293], [-122.48679, 37.91307], [-122.48619, 37.91331], [-122.48584, 37.91313], [-122.48495, 37.91399], [-122.48425, 37.91354], [-122.48423, 37.91235], [-122.48228, 37.9111], [-122.48225, 37.91002], [-122.48313, 37.91002], [-122.48365, 37.9096], [-122.48363, 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.4882, 37.90808], [-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.90706], [-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.90894], [-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.90657], [-122.50426, 37.90627], [-122.50423, 37.90599], [-122.50406, 37.90565], [-122.50473, 37.90506], [-122.50521, 37.90539], [-122.50533, 37.90549], [-122.5054, 37.90561], [-122.50543, 37.9057], [-122.50543, 37.9058], [-122.50541, 37.90591]], [[-122.49689, 37.91227], [-122.4969, 37.91225], [-122.49681, 37.91205], [-122.49633, 37.91213], [-122.49642, 37.91236], [-122.49689, 37.91227]]]} Open Access 1 Ring Mountain Open Space Preserve http://www.marincountyparks.org/depts/pk/divisions/open-space/ring-mountain 31485 2070 Marin County Open Space District 43 Special District 4 Recreation/Parks District 4 http://www.marincountyparks.org/Depts/PK.aspx Special District 4 389.372 Ring Mtn. OSP 1984

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