units_with_maps

Table actions

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

2 rows where AGNCY_LEV = 2, DES_TP = 4 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • Recreation/Parks District · 2 ✖

DES_TP 1

  • Local Conservation Area · 2 ✖
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
12619 12619 12618 {"type": "Polygon", "coordinates": [[[-121.90962, 37.5042], [-121.90908, 37.50427], [-121.90891, 37.50432], [-121.90874, 37.5044], [-121.90856, 37.50454], [-121.90791, 37.50522], [-121.90852, 37.50826], [-121.90692, 37.50847], [-121.90647, 37.50889], [-121.90638, 37.50913], [-121.90662, 37.50945], [-121.90668, 37.50984], [-121.90655, 37.51047], [-121.90559, 37.51121], [-121.90509, 37.51143], [-121.90475, 37.51146], [-121.90409, 37.51164], [-121.90357, 37.51162], [-121.90283, 37.512], [-121.90193, 37.51238], [-121.90179, 37.51275], [-121.90132, 37.51305], [-121.90086, 37.51305], [-121.90053, 37.5134], [-121.8998, 37.51369], [-121.8995, 37.51384], [-121.89887, 37.51388], [-121.89793, 37.51408], [-121.89749, 37.51456], [-121.89724, 37.51509], [-121.89709, 37.5152], [-121.89675, 37.51533], [-121.89643, 37.51539], [-121.89623, 37.51557], [-121.8957, 37.51581], [-121.8952, 37.51621], [-121.89518, 37.51658], [-121.89505, 37.51675], [-121.89607, 37.51717], [-121.8973, 37.5191], [-121.89559, 37.51979], [-121.89411, 37.52032], [-121.8925, 37.5181], [-121.89141, 37.51714], [-121.89084, 37.5161], [-121.88835, 37.51567], [-121.88969, 37.51394], [-121.8902, 37.51374], [-121.8902, 37.51372], [-121.88923, 37.51314], [-121.8853, 37.51061], [-121.88081, 37.50774], [-121.88034, 37.507], [-121.87949, 37.50554], [-121.87889, 37.50392], [-121.87864, 37.50347], [-121.87699, 37.50033], [-121.90406, 37.49917], [-121.90419, 37.50092], [-121.90436, 37.50153], [-121.90334, 37.50181], [-121.90374, 37.5027], [-121.90413, 37.50285], [-121.90419, 37.50262], [-121.90474, 37.50247], [-121.90481, 37.50262], [-121.9051, 37.50314], [-121.90544, 37.50333], [-121.90595, 37.50335], [-121.9061, 37.50431], [-121.90775, 37.50405], [-121.9092, 37.50408], [-121.9096, 37.50404], [-121.90962, 37.5042]]]} Open Access 1 29420 Mission Peak Regional Preserve 3844 1113 Fremont, City of 381 City 2 City Agency 2 http://www.fremont.gov/316/Parks City 2 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/parks/mission Alameda 17 897.286 Mission Peak RPr 1976 Local Conservation Area 4 2
15409 15409 15408 {"type": "Polygon", "coordinates": [[[-121.74686, 37.21397], [-121.74675, 37.21408], [-121.74406, 37.21175], [-121.74273, 37.21269], [-121.74273, 37.2127], [-121.74574, 37.2153], [-121.74476, 37.21633], [-121.74487, 37.21644], [-121.74242, 37.21804], [-121.73356, 37.21042], [-121.73299, 37.2099], [-121.73292, 37.20993], [-121.72971, 37.20676], [-121.73058, 37.20587], [-121.73123, 37.20514], [-121.73217, 37.20435], [-121.73262, 37.20404], [-121.73268, 37.20403], [-121.73275, 37.20405], [-121.73301, 37.20386], [-121.733, 37.2038], [-121.73303, 37.20375], [-121.73596, 37.20169], [-121.73672, 37.20173], [-121.74017, 37.2049], [-121.74035, 37.2051], [-121.74145, 37.20611], [-121.74142, 37.20618], [-121.74165, 37.20638], [-121.74173, 37.20637], [-121.7461, 37.21033], [-121.74654, 37.21065], [-121.74691, 37.21362], [-121.74686, 37.21397]]]} Restricted Access 2 49043 Northern Coyote Valley Conservation Area 33748 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 2142 Santa Clara Valley Open Space Authority 468 Special District 4 Recreation/Parks District 4   Santa Clara 19 326.66 Northern Coyote Valley Conservation Area 0 Local Conservation Area 4 2

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