units_with_maps

Table actions

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

3 rows where DES_TP = 3, MNG_AGENCY = 459 and MNG_AG_LEV = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Pleasant Hill Recreation and Park District · 3 ✖

DES_TP 1

  • Local Recreation Area · 3 ✖

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
3364 3364 3363 {"type": "Polygon", "coordinates": [[[-122.06821, 37.96242], [-122.06779, 37.96243], [-122.06778, 37.96239], [-122.06715, 37.9624], [-122.06651, 37.96247], [-122.06646, 37.96233], [-122.06626, 37.96208], [-122.06625, 37.96193], [-122.06635, 37.96168], [-122.06738, 37.96154], [-122.06818, 37.96148], [-122.06821, 37.96242]]]} Open Access 1 31033 Pleasant Hill Community Center / Frank Salfingere Park 23794 2112 Pleasant Hill Recreation and Park District 466 Special District 4 Recreation/Parks District 4 http://www.pleasanthillrec.com Special District 4 2112 Pleasant Hill Recreation and Park District 459 Special District 4 Recreation/Parks District 4   Contra Costa 12 3.829 Pleasant Hill Community Ctr. / Frank Salfingere Park 0 Local Recreation Area 3 4
11862 11862 11861 {"type": "Polygon", "coordinates": [[[-122.09727, 37.96835], [-122.09717, 37.96862], [-122.09485, 37.96935], [-122.09203, 37.969], [-122.092, 37.96452], [-122.09276, 37.96373], [-122.09296, 37.96333], [-122.093, 37.96256], [-122.09383, 37.96217], [-122.09419, 37.96211], [-122.09448, 37.96223], [-122.09467, 37.9622], [-122.09489, 37.96209], [-122.09533, 37.96201], [-122.09572, 37.96197], [-122.09637, 37.96319], [-122.09604, 37.96332], [-122.09595, 37.96369], [-122.09583, 37.96389], [-122.09567, 37.96404], [-122.09538, 37.96418], [-122.0947, 37.96427], [-122.09443, 37.96422], [-122.09396, 37.96436], [-122.09374, 37.96447], [-122.0936, 37.96466], [-122.0936, 37.96496], [-122.09385, 37.96515], [-122.09405, 37.96526], [-122.09418, 37.96538], [-122.09401, 37.96587], [-122.0937, 37.96661], [-122.09358, 37.96706], [-122.09401, 37.96735], [-122.09441, 37.96727], [-122.09466, 37.96712], [-122.09476, 37.96666], [-122.09485, 37.96614], [-122.09485, 37.9656], [-122.09496, 37.96529], [-122.09588, 37.96527], [-122.09727, 37.96835]]]} Open Access 1 31035 Ridgeview Open Space 24358 2112 Pleasant Hill Recreation and Park District 466 Special District 4 Recreation/Parks District 4 http://www.pleasanthillrec.com Special District 4 2112 Pleasant Hill Recreation and Park District 459 Special District 4 Recreation/Parks District 4   Contra Costa 12 58.402 Ridgeview OS 0 Local Recreation Area 3 4
11864 11864 11863 {"type": "Polygon", "coordinates": [[[-122.08599, 37.95319], [-122.0867, 37.95368], [-122.08696, 37.95388], [-122.08706, 37.95399], [-122.0871, 37.95408], [-122.08712, 37.95418], [-122.08711, 37.95427], [-122.08708, 37.95436], [-122.08703, 37.95444], [-122.08696, 37.95451], [-122.08668, 37.95472], [-122.08599, 37.95516], [-122.08599, 37.95319]]]} Open Access 1 31034 Winslow Center 27650 2112 Pleasant Hill Recreation and Park District 466 Special District 4 Recreation/Parks District 4 http://www.pleasanthillrec.com Special District 4 2112 Pleasant Hill Recreation and Park District 459 Special District 4 Recreation/Parks District 4   Contra Costa 12 3.264 Winslow Ctr. 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]);