units_with_maps

Table actions

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

1 row where AGNCY_NAME = 180, DES_TP = 2 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 1 ✖

DES_TP 1

  • Local Park · 1 ✖

ACCESS_TYP 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
16854 16854 16853 {"type": "Polygon", "coordinates": [[[-122.27281, 37.7628], [-122.27158, 37.76221], [-122.25694, 37.75677], [-122.25495, 37.75605], [-122.25057, 37.75438], [-122.24678, 37.75296], [-122.24667, 37.75307], [-122.24506, 37.75247], [-122.23877, 37.75051], [-122.23679, 37.74987], [-122.23701, 37.74992], [-122.23762, 37.75012], [-122.23783, 37.75017], [-122.23803, 37.75025], [-122.23854, 37.75039], [-122.23935, 37.75064], [-122.23973, 37.7507], [-122.24, 37.75076], [-122.24037, 37.75089], [-122.24067, 37.75091], [-122.24082, 37.75098], [-122.24094, 37.75106], [-122.24105, 37.7511], [-122.24119, 37.75113], [-122.24164, 37.75117], [-122.24183, 37.75116], [-122.24206, 37.75119], [-122.24283, 37.75148], [-122.24307, 37.75153], [-122.24327, 37.75161], [-122.24361, 37.75182], [-122.2437, 37.75185], [-122.24381, 37.75184], [-122.24391, 37.75181], [-122.24418, 37.75168], [-122.24432, 37.75167], [-122.24451, 37.75168], [-122.24464, 37.7517], [-122.24488, 37.75178], [-122.24503, 37.75181], [-122.2454, 37.75182], [-122.2457, 37.75188], [-122.24598, 37.75199], [-122.24614, 37.75208], [-122.24629, 37.7521], [-122.24662, 37.75211], [-122.2469, 37.75216], [-122.24704, 37.75222], [-122.24723, 37.75234], [-122.24741, 37.75237], [-122.24766, 37.75238], [-122.24792, 37.75235], [-122.24807, 37.75235], [-122.24853, 37.75245], [-122.24874, 37.75252], [-122.24895, 37.75264], [-122.24904, 37.75272], [-122.24908, 37.75279], [-122.2491, 37.7529], [-122.24913, 37.75299], [-122.24923, 37.75305], [-122.24936, 37.75308], [-122.24943, 37.75314], [-122.24947, 37.75326], [-122.24946, 37.75338], [-122.24951, 37.75343], [-122.24968, 37.75354], [-122.24987, 37.75363], [-122.25, 37.75371], [-122.25018, 37.75377], [-122.25024, 37.75376], [-122.25038, 37.75371], [-122.25048, 37.7537], [-122.25076, 37.7538], [-122.25101, 37.75394], [-122.25115, 37.75405], [-122.25127, 37.7541], [-122.25173, 37.75415], [-122.25242, 37.75433], [-122.25361, 37.7547], [-122.25394, 37.75483], [-122.2543, 37.75502], [-122.25492, 37.75527], [-122.25505, 37.75532], [-122.25512, 37.75533], [-122.25525, 37.75541], [-122.25561, 37.75555], [-122.25599, 37.75577], [-122.2562, 37.75586], [-122.2567, 37.75613], [-122.2575, 37.75644], [-122.25802, 37.7566], [-122.25877, 37.75693], [-122.25908, 37.7571], [-122.25986, 37.75741], [-122.26011, 37.75749], [-122.26051, 37.7575], [-122.2609, 37.75757], [-122.26136, 37.7577], [-122.26176, 37.75789], [-122.26223, 37.75816], [-122.26272, 37.75841], [-122.26334, 37.75869], [-122.26407, 37.75895], [-122.26445, 37.75906], [-122.2647, 37.75907], [-122.2656, 37.75939], [-122.26631, 37.75957], [-122.26674, 37.7597], [-122.26892, 37.76054], [-122.27008, 37.76105], [-122.27047, 37.7612], [-122.27093, 37.76141], [-122.27142, 37.7617], [-122.27203, 37.76211], [-122.27224, 37.76233], [-122.27273, 37.76269], [-122.27281, 37.7628]]]} Open Access 1 46017 Crown Memorial Regional Shoreline 1486 1001 Alameda, City of 180 City 2 City Agency 2 http://alamedaca.gov/recreation City 2 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/parks/crown_beach Alameda 17 47.607 Crown Memorial Reg. Shoreline 1967 Local Park 2 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]);