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 = 3 and LABEL_NAME = "Delta De Anza Reg. Trail"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Local Recreation 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
12590 12590 12589 {"type": "MultiPolygon", "coordinates": [[[[-121.85334, 38.00077], [-121.85324, 38.00103], [-121.84355, 37.99869], [-121.84381, 37.99847], [-121.85334, 38.00077]]], [[[-121.86747, 38.00445], [-121.86628, 38.00416], [-121.85344, 38.00108], [-121.85354, 38.00081], [-121.86198, 38.00284], [-121.86745, 38.00415], [-121.86749, 38.00417], [-121.8675, 38.00421], [-121.8675, 38.00433], [-121.86747, 38.00445]]], [[[-121.87183, 38.0052], [-121.87172, 38.00547], [-121.87081, 38.00525], [-121.86765, 38.00449], [-121.86768, 38.00436], [-121.86769, 38.00421], [-121.87183, 38.0052]]], [[[-121.8869, 38.00883], [-121.88683, 38.00909], [-121.87202, 38.00554], [-121.87212, 38.00527], [-121.8869, 38.00883]]], [[[-121.89186, 38.01001], [-121.89176, 38.01027], [-121.88716, 38.00917], [-121.88724, 38.0089], [-121.89186, 38.01001]]], [[[-121.89824, 38.01154], [-121.89814, 38.0118], [-121.89229, 38.0104], [-121.89239, 38.01014], [-121.89824, 38.01154]]], [[[-121.90445, 38.01304], [-121.9044, 38.01314], [-121.90428, 38.01328], [-121.8984, 38.01187], [-121.8985, 38.01161], [-121.90445, 38.01304]]], [[[-121.91117, 38.01465], [-121.9108, 38.01484], [-121.90446, 38.01332], [-121.90455, 38.01323], [-121.90463, 38.01308], [-121.91117, 38.01465]]], [[[-121.91293, 38.01535], [-121.91117, 38.01493], [-121.91117, 38.01493], [-121.91152, 38.01473], [-121.91251, 38.01496], [-121.91293, 38.01535]]], [[[-121.91986, 38.01673], [-121.91984, 38.01684], [-121.91985, 38.01702], [-121.91408, 38.01563], [-121.91365, 38.01549], [-121.91345, 38.01539], [-121.91325, 38.01527], [-121.91303, 38.0151], [-121.91986, 38.01673]]], [[[-121.92799, 38.01869], [-121.92716, 38.01877], [-121.92003, 38.01707], [-121.92001, 38.01693], [-121.92002, 38.01677], [-121.92799, 38.01869]]], [[[-121.93521, 38.02068], [-121.9328, 38.02011], [-121.93046, 38.01956], [-121.93156, 38.01953], [-121.9352, 38.02039], [-121.93521, 38.02068]]], [[[-121.93603, 38.02088], [-121.93538, 38.02072], [-121.93538, 38.02043], [-121.93602, 38.02059], [-121.93603, 38.02088]]], [[[-121.93687, 38.02108], [-121.9362, 38.02092], [-121.9362, 38.02063], [-121.93687, 38.02079], [-121.93687, 38.02108]]], [[[-121.94171, 38.02224], [-121.93704, 38.02112], [-121.93704, 38.02083], [-121.94171, 38.02195], [-121.94171, 38.02224]]], [[[-121.95116, 38.02451], [-121.95018, 38.02428], [-121.95007, 38.0259], [-121.95, 38.02589], [-121.9501, 38.02425], [-121.94212, 38.02234], [-121.94205, 38.02234], [-121.94204, 38.02203], [-121.95116, 38.02422], [-121.95116, 38.02451]]], [[[-121.95228, 38.02478], [-121.95133, 38.02455], [-121.95133, 38.02426], [-121.95227, 38.02449], [-121.95228, 38.02478]]], [[[-121.95332, 38.02503], [-121.95242, 38.02481], [-121.95242, 38.02452], [-121.95331, 38.02474], [-121.95332, 38.02503]]], [[[-121.95436, 38.02499], [-121.95436, 38.02528], [-121.95345, 38.02506], [-121.95345, 38.02477], [-121.95436, 38.02499]]], [[[-121.95584, 38.02563], [-121.9545, 38.02531], [-121.9545, 38.02502], [-121.95584, 38.02534], [-121.95584, 38.02563]]], [[[-121.95727, 38.02597], [-121.95602, 38.02567], [-121.95602, 38.02539], [-121.95726, 38.02569], [-121.95727, 38.02597]]], [[[-121.95987, 38.02631], [-121.95932, 38.02647], [-121.95741, 38.02601], [-121.95741, 38.02572], [-121.95987, 38.02631]]]]} Open Access 1 29162 Delta De Anza Regional Trail 18069 2031 East Bay Municipal Utility District 433 Special District 4 Water District 13 http://www.ebmud.com/ Special District 4 2031 East Bay Municipal Utility District 427 Special District 4 Water District 13   Contra Costa 12 75.03 Delta De Anza Reg. Trail 0 Local Recreation Area 3 4

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