units_with_maps

Table actions

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

2 rows where LAYER = 4, MNG_AGENCY = 607 and MNG_AG_TYP = 17

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Community Services District · 2 ✖

MNG_AGENCY 1

  • Manila Community Services District · 2 ✖

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
3319 3319 3318 {"type": "MultiPolygon", "coordinates": [[[[-124.16824, 40.85924], [-124.16709, 40.86133], [-124.16528, 40.86127], [-124.15926, 40.86121], [-124.15927, 40.86055], [-124.16009, 40.8591], [-124.16824, 40.85924]]], [[[-124.17983, 40.83876], [-124.17625, 40.84479], [-124.17547, 40.84606], [-124.17116, 40.85399], [-124.16888, 40.85808], [-124.16438, 40.85809], [-124.16426, 40.85767], [-124.16325, 40.85769], [-124.16253, 40.8578], [-124.16234, 40.85708], [-124.16173, 40.85708], [-124.16171, 40.85701], [-124.16406, 40.857], [-124.164, 40.85397], [-124.16796, 40.85399], [-124.16798, 40.84978], [-124.16822, 40.84977], [-124.16816, 40.84801], [-124.16989, 40.84799], [-124.1699, 40.84788], [-124.17062, 40.84787], [-124.17056, 40.84614], [-124.17287, 40.84609], [-124.17275, 40.84247], [-124.17293, 40.84245], [-124.17281, 40.83882], [-124.17788, 40.83876], [-124.17983, 40.83876]]]]} Open Access 1 29677 Manila Dunes Recreation Area 6209 2319 Manila Community Services District 618 Special District 4 Community Services District 19 http://www.manilacsd.com/ Special District 4 2319 Manila Community Services District 607 Special District 4 Community Services District 17 http://www.friendsofthedunes.org/resources/ Humboldt 45 265.033 Manila Dunes Rec. Area 0 Local Recreation Area 3 4
3321 3321 3320 {"type": "Polygon", "coordinates": [[[-124.16247, 40.85177], [-124.16166, 40.85293], [-124.16151, 40.85317], [-124.15946, 40.85236], [-124.15859, 40.852], [-124.15866, 40.85177], [-124.15859, 40.8514], [-124.15856, 40.85106], [-124.15866, 40.85071], [-124.15889, 40.85049], [-124.15943, 40.85029], [-124.16022, 40.85014], [-124.16032, 40.85011], [-124.16004, 40.85044], [-124.16002, 40.85068], [-124.16191, 40.85144], [-124.162, 40.85158], [-124.16247, 40.85177]]]} Open Access 1 29679 Manila Community Park 21749 2319 Manila Community Services District 618 Special District 4 Community Services District 19 http://www.manilacsd.com/ Special District 4 2319 Manila Community Services District 607 Special District 4 Community Services District 17   Humboldt 45 15.038 Manila Community Park 0 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]);