units_with_maps

Table actions

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

6 rows where ACCESS_TYP = 1 and MNG_AGENCY = 442

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 6 ✖
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
8887 8887 8886 {"type": "Polygon", "coordinates": [[[-121.95452, 37.28882], [-121.95338, 37.28882], [-121.95342, 37.29059], [-121.95184, 37.2906], [-121.95184, 37.29016], [-121.95207, 37.29016], [-121.9521, 37.28978], [-121.95206, 37.28972], [-121.95194, 37.28963], [-121.95194, 37.28922], [-121.95192, 37.28892], [-121.95194, 37.28877], [-121.95199, 37.28868], [-121.95215, 37.28861], [-121.95233, 37.28861], [-121.95244, 37.28868], [-121.95263, 37.28871], [-121.95281, 37.28871], [-121.953, 37.28867], [-121.95319, 37.2886], [-121.95337, 37.28845], [-121.95348, 37.28828], [-121.95347, 37.28711], [-121.9545, 37.28709], [-121.95452, 37.28882]]]} Open Access 1 14512 Campbell Community Center 16778 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 11.3 Campbell Community Ctr. 1985 Local Recreation Area 3 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]);