units_with_maps

Table actions

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

3 rows where DES_TP = 4, MNG_AGENCY = 534 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 3 ✖

MNG_AGENCY 1

  • Sacramento, City of · 3 ✖

DES_TP 1

  • Local Conservation Area · 3 ✖

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
3082 3082 3081 {"type": "Polygon", "coordinates": [[[-121.50672, 38.66802], [-121.50672, 38.66802], [-121.50395, 38.66804], [-121.50412, 38.66774], [-121.50423, 38.66746], [-121.5043, 38.66714], [-121.50431, 38.66685], [-121.50529, 38.66685], [-121.50671, 38.66684], [-121.50672, 38.66802]]]} Open Access 1 21265 North Natomas Park Nature Area 22833 1287 Sacramento, City of 541 City 2 City Agency 2 http://portal.cityofsacramento.org/ParksandRec City 2 1287 Sacramento, City of 534 City 2 City Agency 2   Sacramento 41 7.099 North Natomas Park Nature Area 0 Local Conservation Area 4 2
11022 11022 11021 {"type": "Polygon", "coordinates": [[[-121.50608, 38.60857], [-121.50599, 38.60901], [-121.50599, 38.60912], [-121.50602, 38.60919], [-121.50591, 38.60958], [-121.50573, 38.60985], [-121.50543, 38.61018], [-121.50549, 38.61022], [-121.50499, 38.61022], [-121.50473, 38.6102], [-121.50492, 38.60947], [-121.50493, 38.60813], [-121.50453, 38.60802], [-121.50453, 38.60744], [-121.50521, 38.60734], [-121.50479, 38.60784], [-121.5053, 38.60811], [-121.50575, 38.60838], [-121.50598, 38.60832], [-121.50608, 38.60857]]]} Open Access 1 21107 Bannon Creek Preserve 15801 1287 Sacramento, City of 541 City 2 City Agency 2 http://portal.cityofsacramento.org/ParksandRec City 2 1287 Sacramento, City of 534 City 2 City Agency 2   Sacramento 41 5.638 Bannon Creek Preserve 0 Local Conservation Area 4 2
16749 16749 16748 {"type": "Polygon", "coordinates": [[[-121.44432, 38.44752], [-121.44402, 38.44743], [-121.44376, 38.44729], [-121.44143, 38.44517], [-121.44122, 38.44501], [-121.44097, 38.44484], [-121.4405, 38.44461], [-121.43876, 38.44396], [-121.43738, 38.44311], [-121.43728, 38.44316], [-121.43711, 38.44301], [-121.43685, 38.44284], [-121.43659, 38.44271], [-121.4363, 38.4426], [-121.43604, 38.44253], [-121.43581, 38.4425], [-121.43441, 38.4424], [-121.43404, 38.44235], [-121.43378, 38.44227], [-121.4336, 38.4422], [-121.43303, 38.44189], [-121.43274, 38.44176], [-121.43245, 38.44167], [-121.43207, 38.44161], [-121.43174, 38.4416], [-121.43117, 38.44162], [-121.43091, 38.44166], [-121.43065, 38.44173], [-121.43048, 38.44172], [-121.43014, 38.44175], [-121.42893, 38.44195], [-121.42871, 38.44197], [-121.42848, 38.44196], [-121.42828, 38.44192], [-121.42713, 38.44181], [-121.42536, 38.44167], [-121.42363, 38.43929], [-121.42337, 38.43899], [-121.42303, 38.43868], [-121.42265, 38.43842], [-121.42221, 38.43819], [-121.42171, 38.43801], [-121.42444, 38.43799], [-121.42551, 38.43985], [-121.42569, 38.44004], [-121.42591, 38.44018], [-121.42616, 38.44026], [-121.42659, 38.44032], [-121.42669, 38.44035], [-121.42677, 38.44035], [-121.43071, 38.44083], [-121.43156, 38.43987], [-121.43156, 38.43964], [-121.43139, 38.4395], [-121.4315, 38.43935], [-121.43154, 38.43917], [-121.43153, 38.43844], [-121.43154, 38.43836], [-121.43153, 38.43831], [-121.43149, 38.43827], [-121.43149, 38.43794], [-121.43614, 38.4379], [-121.43617, 38.44146], [-121.43814, 38.44147], [-121.43848, 38.44194], [-121.43862, 38.44206], [-121.43877, 38.44214], [-121.43878, 38.44232], [-121.43895, 38.44252], [-121.43909, 38.44264], [-121.43934, 38.44279], [-121.43959, 38.44287], [-121.43984, 38.44292], [-121.43993, 38.44296], [-121.44008, 38.44293], [-121.44102, 38.44293], [-121.44125, 38.44294], [-121.4415, 38.44301], [-121.44173, 38.44314], [-121.44189, 38.44328], [-121.44291, 38.44461], [-121.44299, 38.4447], [-121.44312, 38.44479], [-121.44324, 38.44485], [-121.44338, 38.44489], [-121.44361, 38.44492], [-121.44367, 38.44495], [-121.44365, 38.44546], [-121.44361, 38.44554], [-121.4436, 38.44558], [-121.44391, 38.4459], [-121.44431, 38.44623], [-121.44432, 38.44752]]]} Open Access 1 21254 North Laguna Creek Wildlife Area 22828 1287 Sacramento, City of 541 City 2 City Agency 2 http://portal.cityofsacramento.org/ParksandRec City 2 1287 Sacramento, City of 534 City 2 City Agency 2   Sacramento 41 111.625 North Laguna Creek Wildlife 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]);