units_with_maps

Table actions

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

5 rows where AGNCY_NAME = 448, DES_TP = 2 and MNG_AGENCY = 442

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Campbell, City of · 5 ✖

DES_TP 1

  • Local Park · 5 ✖

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
1886 1886 1885 {"type": "Polygon", "coordinates": [[[-121.94371, 37.28863], [-121.94342, 37.28862], [-121.9434, 37.28795], [-121.9437, 37.28795], [-121.94371, 37.28863]]]} Open Access 1 14511 Orchard City Green 23185 1043 Campbell, City of 448 City 2 City Agency 2 http://www.ci.campbell.ca.us/226/Recreation-Parks City 2 1043 Campbell, City of 442 City 2 City Agency 2   Santa Clara 19 0.481 Orchard City Green 1992 Local Park 2 4
8866 8866 8865 {"type": "Polygon", "coordinates": [[[-121.96063, 37.28436], [-121.96048, 37.28438], [-121.96041, 37.2843], [-121.96029, 37.28428], [-121.96018, 37.28432], [-121.96012, 37.28441], [-121.96008, 37.28444], [-121.9586, 37.28465], [-121.9579, 37.28199], [-121.95721, 37.28139], [-121.95575, 37.2814], [-121.95575, 37.28072], [-121.95599, 37.28069], [-121.95626, 37.28062], [-121.95651, 37.28049], [-121.95685, 37.28025], [-121.95701, 37.28022], [-121.95715, 37.28028], [-121.9579, 37.28083], [-121.95956, 37.28238], [-121.9598, 37.28262], [-121.96001, 37.28288], [-121.9602, 37.28316], [-121.96042, 37.2836], [-121.96053, 37.2839], [-121.96063, 37.28436]]]} Open Access 1 14514 John D. Morgan Park 20434 1043 Campbell, City of 448 City 2 City Agency 2 http://www.ci.campbell.ca.us/226/Recreation-Parks City 2 1043 Campbell, City of 442 City 2 City Agency 2   Santa Clara 19 18.397 John D. Morgan Park 1972 Local Park 2 4
8880 8880 8879 {"type": "Polygon", "coordinates": [[[-121.97616, 37.26531], [-121.97656, 37.26529], [-121.97661, 37.2653], [-121.97663, 37.26534], [-121.97665, 37.26558], [-121.97656, 37.26585], [-121.97654, 37.26597], [-121.97658, 37.26615], [-121.9767, 37.26634], [-121.97672, 37.26643], [-121.97674, 37.26694], [-121.97672, 37.26698], [-121.97669, 37.267], [-121.97573, 37.267], [-121.97568, 37.26698], [-121.97565, 37.26695], [-121.97563, 37.2668], [-121.97561, 37.26542], [-121.97562, 37.2654], [-121.97562, 37.26535], [-121.97616, 37.26531]]]} Open Access 1 14507 Jack Fischer Park 20304 1043 Campbell, City of 448 City 2 City Agency 2 http://www.ci.campbell.ca.us/226/Recreation-Parks City 2 1043 Campbell, City of 442 City 2 City Agency 2   Santa Clara 19 4.212 Jack Fischer Park 1996 Local Park 2 4
8881 8881 8880 {"type": "Polygon", "coordinates": [[[-121.94013, 37.28614], [-121.93949, 37.28697], [-121.93833, 37.28699], [-121.93878, 37.28638], [-121.93884, 37.28638], [-121.93913, 37.28596], [-121.93937, 37.28575], [-121.93964, 37.28558], [-121.93985, 37.2855], [-121.93957, 37.28586], [-121.94013, 37.28614]]]} Open Access 1 14509 Campbell Park 16779 1043 Campbell, City of 448 City 2 City Agency 2 http://www.ci.campbell.ca.us/226/Recreation-Parks City 2 1043 Campbell, City of 442 City 2 City Agency 2   Santa Clara 19 3.04 Campbell Park 1968 Local Park 2 4
12514 12514 12513 {"type": "Polygon", "coordinates": [[[-121.94347, 37.27888], [-121.94328, 37.27905], [-121.94231, 37.27968], [-121.94207, 37.27977], [-121.94181, 37.2798], [-121.94163, 37.27979], [-121.94147, 37.27974], [-121.94131, 37.27967], [-121.94112, 37.27953], [-121.94097, 37.27935], [-121.94079, 37.27887], [-121.94347, 37.27888]]]} Open Access 1 28348 Edith Morley Park 18448 1043 Campbell, City of 448 City 2 City Agency 2 http://www.ci.campbell.ca.us/226/Recreation-Parks City 2 1043 Campbell, City of 442 City 2 City Agency 2   Santa Clara 19 4.004 Edith Morley 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]);