units_with_maps

Table actions

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

3 rows where AGNCY_TYP = 3, DES_TP = 3 and MNG_AGENCY = 292

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Fresno, County of · 3 ✖

DES_TP 1

  • Local Recreation Area · 3 ✖
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
12322 12322 12321 {"type": "Polygon", "coordinates": [[[-119.47502, 36.7331], [-119.47483, 36.73317], [-119.47481, 36.73326], [-119.47375, 36.73264], [-119.47308, 36.73291], [-119.4716, 36.73202], [-119.47134, 36.73246], [-119.47051, 36.73212], [-119.47043, 36.7321], [-119.47052, 36.73197], [-119.47095, 36.7312], [-119.47206, 36.73151], [-119.47297, 36.73185], [-119.47502, 36.7331]]]} Open Access 1 25985 Kings river Access Park 20661 301 Fresno, County of 296 County 3 County Agency 3 http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 County 3 301 Fresno, County of 292 County 3 County Agency 3   Fresno 9 7.286 Kings river Access Park 0 Local Recreation Area 3 4
15708 15708 15707 {"type": "Polygon", "coordinates": [[[-119.91096, 36.84512], [-119.90786, 36.84617], [-119.90717, 36.84638], [-119.90647, 36.84658], [-119.90541, 36.84683], [-119.90469, 36.84697], [-119.90396, 36.8471], [-119.90287, 36.84725], [-119.90247, 36.84764], [-119.89722, 36.84425], [-119.90643, 36.84421], [-119.90626, 36.84057], [-119.90871, 36.84057], [-119.91065, 36.84027], [-119.91086, 36.84418], [-119.91096, 36.84418], [-119.91096, 36.84512]]]} Restricted Access 2 25955 Riverside Municipal Golf Course 33087 301 Fresno, County of 296 County 3 County Agency 3 http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 County 3 301 Fresno, County of 292 County 3 County Agency 3   Fresno 9 107.589 Riverside Municipal GC 0 Local Recreation Area 3 4
16711 16711 16710 {"type": "Polygon", "coordinates": [[[-119.74048, 36.9629], [-119.74046, 36.96322], [-119.74044, 36.96339], [-119.73993, 36.96544], [-119.73943, 36.96697], [-119.73768, 36.97137], [-119.73595, 36.97372], [-119.73239, 36.97692], [-119.73129, 36.97793], [-119.73031, 36.97791], [-119.72304, 36.97794], [-119.72301, 36.97562], [-119.72458, 36.9743], [-119.72577, 36.9743], [-119.72576, 36.97335], [-119.72618, 36.97296], [-119.72661, 36.9725], [-119.727, 36.97202], [-119.72727, 36.97165], [-119.72758, 36.97113], [-119.72785, 36.9706], [-119.72803, 36.97019], [-119.72821, 36.96964], [-119.72832, 36.96922], [-119.72846, 36.96849], [-119.72876, 36.96559], [-119.72882, 36.96514], [-119.72884, 36.96481], [-119.72883, 36.96447], [-119.72878, 36.96392], [-119.72872, 36.96359], [-119.72864, 36.96326], [-119.72779, 36.96087], [-119.73636, 36.96082], [-119.73638, 36.96293], [-119.74048, 36.9629]]]} Open Access 1 25929 Lost Lake Recreation Area 21541 301 Fresno, County of 296 County 3 County Agency 3 http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 County 3 301 Fresno, County of 292 County 3 County Agency 3   Fresno 9 425.466 Lost Lake Rec. Area 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]);