units_with_maps

Table actions

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

3 rows where ACCESS_TYP = 1, AGNCY_NAME = 624 and MNG_AG_TYP = 17

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Community Services District · 3 ✖

ACCESS_TYP 1

  • Open Access · 3 ✖
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
3352 3352 3351 {"type": "Polygon", "coordinates": [[[-124.10338, 40.95518], [-124.10286, 40.95518], [-124.10286, 40.95491], [-124.10338, 40.95491], [-124.10338, 40.95518]]]} Open Access 1 24241 Larissa Park 21027 2238 McKinleyville Community Services District 624 Special District 4 Community Services District 19 http://mckinleyvillecsd.com/ Special District 4 2238 McKinleyville Community Services District 613 Special District 4 Community Services District 17   Humboldt 45 0.324 Larissa Park 0 Local Park 2 4
11843 11843 11842 {"type": "MultiPolygon", "coordinates": [[[[-124.12092, 40.949], [-124.11648, 40.94898], [-124.11663, 40.9423], [-124.12009, 40.94232], [-124.12005, 40.94415], [-124.12013, 40.94702], [-124.12017, 40.94729], [-124.12021, 40.94747], [-124.12035, 40.94787], [-124.12092, 40.949]]], [[[-124.12553, 40.94239], [-124.1243, 40.94901], [-124.12126, 40.949], [-124.12063, 40.94769], [-124.12055, 40.9475], [-124.12043, 40.9471], [-124.12037, 40.94679], [-124.1203, 40.9442], [-124.12032, 40.94239], [-124.12553, 40.94239]]]]} Open Access 1 24242 Hiller Park Playground and Picnic Area 19973 2238 McKinleyville Community Services District 624 Special District 4 Community Services District 19 http://mckinleyvillecsd.com/ Special District 4 2238 McKinleyville Community Services District 613 Special District 4 Community Services District 17   Humboldt 45 124.095 Hiller Park Playground and Picnic Area 0 Local Recreation Area 3 4
11844 11844 11843 {"type": "Polygon", "coordinates": [[[-124.09944, 40.94435], [-124.09763, 40.94435], [-124.09762, 40.94319], [-124.09864, 40.94317], [-124.09865, 40.94306], [-124.09944, 40.94308], [-124.09944, 40.94435]]]} Open Access 1 24243 Pierson Park 23666 2238 McKinleyville Community Services District 624 Special District 4 Community Services District 19 http://mckinleyvillecsd.com/ Special District 4 2238 McKinleyville Community Services District 613 Special District 4 Community Services District 17 http://mckinleyvillecsd.com/pierson-park Humboldt 45 5.118 Pierson 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]);