units_with_maps

Table actions

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

1 row where AGNCY_LEV = 2, DES_TP = 1247 and MNG_AGENCY = 32

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Jose, City of · 1 ✖

DES_TP 1

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
14629 14629 14628 {"type": "MultiPolygon", "coordinates": [[[[-121.82904, 37.20107], [-121.82877, 37.2012], [-121.82751, 37.20023], [-121.82682, 37.19987], [-121.82557, 37.19944], [-121.82524, 37.19927], [-121.82507, 37.19909], [-121.825, 37.19897], [-121.82495, 37.19878], [-121.82471, 37.19836], [-121.82465, 37.19815], [-121.82467, 37.19785], [-121.82498, 37.19687], [-121.82499, 37.19673], [-121.82496, 37.19662], [-121.82386, 37.19564], [-121.82358, 37.19548], [-121.82337, 37.19529], [-121.82317, 37.19495], [-121.82309, 37.19441], [-121.82296, 37.19408], [-121.82277, 37.19374], [-121.82226, 37.19327], [-121.82207, 37.19305], [-121.82174, 37.19289], [-121.82159, 37.19272], [-121.82138, 37.19261], [-121.82116, 37.19232], [-121.82071, 37.19225], [-121.82044, 37.1921], [-121.82001, 37.19168], [-121.81997, 37.19159], [-121.81989, 37.19128], [-121.81949, 37.19081], [-121.81966, 37.19073], [-121.82003, 37.19121], [-121.82009, 37.19144], [-121.82017, 37.19162], [-121.82053, 37.19205], [-121.82075, 37.19218], [-121.82125, 37.19225], [-121.8215, 37.19256], [-121.82172, 37.19268], [-121.82192, 37.19284], [-121.82209, 37.19291], [-121.82221, 37.19299], [-121.82235, 37.19317], [-121.82245, 37.19325], [-121.82258, 37.19334], [-121.82269, 37.19344], [-121.8228, 37.1935], [-121.82291, 37.19361], [-121.823, 37.19373], [-121.82307, 37.19386], [-121.82321, 37.19427], [-121.82326, 37.19436], [-121.82345, 37.19503], [-121.82354, 37.19517], [-121.82367, 37.19528], [-121.8241, 37.19549], [-121.8242, 37.19559], [-121.82477, 37.19604], [-121.82509, 37.19633], [-121.82522, 37.19655], [-121.82526, 37.19665], [-121.82529, 37.1969], [-121.82504, 37.19775], [-121.82499, 37.19822], [-121.82517, 37.19879], [-121.82523, 37.19892], [-121.82533, 37.19907], [-121.82545, 37.19917], [-121.82616, 37.19946], [-121.82675, 37.19964], [-121.82709, 37.19978], [-121.82793, 37.20026], [-121.8289, 37.20093], [-121.82904, 37.20107]]], [[[-121.83038, 37.20352], [-121.82933, 37.20334], [-121.82928, 37.20256], [-121.82924, 37.20229], [-121.82914, 37.20204], [-121.82907, 37.20192], [-121.8289, 37.2017], [-121.8288, 37.20161], [-121.82946, 37.20132], [-121.82968, 37.20117], [-121.83004, 37.20166], [-121.83016, 37.20192], [-121.83024, 37.20218], [-121.83029, 37.20245], [-121.83038, 37.20352]]], [[[-121.83272, 37.2123], [-121.83266, 37.2119], [-121.83266, 37.21175], [-121.83267, 37.21156], [-121.83276, 37.21106], [-121.83275, 37.21081], [-121.83269, 37.21065], [-121.8325, 37.21031], [-121.83238, 37.21003], [-121.83228, 37.20975], [-121.83218, 37.20929], [-121.83187, 37.20838], [-121.8318, 37.20806], [-121.83173, 37.20763], [-121.83168, 37.20747], [-121.83158, 37.20726], [-121.83143, 37.20703], [-121.83101, 37.20658], [-121.83005, 37.20539], [-121.82978, 37.20516], [-121.82957, 37.20491], [-121.82944, 37.20464], [-121.82941, 37.20453], [-121.82937, 37.20377], [-121.83041, 37.20395], [-121.83043, 37.20444], [-121.83051, 37.20457], [-121.83057, 37.20464], [-121.83092, 37.20491], [-121.83183, 37.20605], [-121.83232, 37.20659], [-121.8325, 37.20687], [-121.83263, 37.20714], [-121.83276, 37.20753], [-121.83286, 37.20809], [-121.83316, 37.20905], [-121.83329, 37.20959], [-121.83342, 37.20993], [-121.83361, 37.21028], [-121.83369, 37.21045], [-121.83375, 37.21069], [-121.83378, 37.21092], [-121.83378, 37.21108], [-121.83373, 37.21147], [-121.83374, 37.21174], [-121.83377, 37.21197], [-121.83376, 37.212], [-121.83371, 37.21203], [-121.83272, 37.2123]]]]} Open Access 1 47646 Alamitos Creek Parkchain 31390 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 35.751 Alamitos Creek Parkchain   None 1247  

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]);