superunits_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, MNG_AG_TYP = 7 and YR_EST = 1970

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency - Parks · 2 ✖

ACCESS_TYP 1

  • Open Access · 2 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
2174 2174 2173 {"type": "Polygon", "coordinates": [[[-122.51009, 38.36459], [-122.51009, 38.36459], [-122.5059, 38.36725], [-122.50542, 38.36613], [-122.50569, 38.36589], [-122.50569, 38.36502], [-122.50624, 38.36485], [-122.50574, 38.36403], [-122.50846, 38.36297], [-122.51009, 38.36459]]]} Open Access 1 Bouverie Wildflower Preserve   16304 328 Sonoma County Regional Parks Dept., County of 189 County 3 County Agency - Parks 7 http://parks.sonomacounty.ca.gov/ County 3 24.51 Bouverie Wildflower Preserve 1970
15112 15112 15111 {"type": "MultiPolygon", "coordinates": [[[[-122.66092, 38.45518], [-122.65973, 38.45626], [-122.65975, 38.45936], [-122.65617, 38.45995], [-122.65546, 38.4601], [-122.65464, 38.46042], [-122.65457, 38.46055], [-122.65418, 38.46074], [-122.65383, 38.46066], [-122.65373, 38.46078], [-122.6537, 38.46089], [-122.65372, 38.46161], [-122.6533, 38.46124], [-122.65302, 38.46095], [-122.65167, 38.45939], [-122.65137, 38.45911], [-122.65106, 38.45885], [-122.65078, 38.45866], [-122.65049, 38.45849], [-122.64994, 38.45822], [-122.64936, 38.45801], [-122.64866, 38.45784], [-122.64862, 38.45782], [-122.64859, 38.45775], [-122.64865, 38.4575], [-122.64865, 38.45735], [-122.64848, 38.45642], [-122.64841, 38.45632], [-122.64833, 38.45627], [-122.6482, 38.45626], [-122.64716, 38.45652], [-122.64707, 38.45652], [-122.64701, 38.45649], [-122.64697, 38.45644], [-122.64698, 38.45638], [-122.64733, 38.45561], [-122.6486, 38.45566], [-122.64968, 38.455], [-122.64989, 38.45454], [-122.64988, 38.45453], [-122.649, 38.45479], [-122.64871, 38.45495], [-122.64857, 38.45477], [-122.64836, 38.45463], [-122.64792, 38.45453], [-122.64786, 38.45448], [-122.64826, 38.45363], [-122.64812, 38.45357], [-122.64854, 38.45273], [-122.64847, 38.45267], [-122.64836, 38.45234], [-122.64825, 38.4523], [-122.64799, 38.45235], [-122.64736, 38.45268], [-122.64702, 38.45284], [-122.64642, 38.45304], [-122.64597, 38.4531], [-122.64534, 38.4531], [-122.64489, 38.45307], [-122.64496, 38.45367], [-122.64267, 38.45431], [-122.6435, 38.45134], [-122.64456, 38.45143], [-122.6482, 38.44901], [-122.64782, 38.44614], [-122.64767, 38.44586], [-122.6476, 38.44565], [-122.64757, 38.44542], [-122.6476, 38.44518], [-122.64766, 38.44493], [-122.64761, 38.44458], [-122.64765, 38.44392], [-122.64764, 38.44359], [-122.64786, 38.44383], [-122.6481, 38.44392], [-122.64837, 38.44417], [-122.64868, 38.44435], [-122.6494, 38.44444], [-122.64969, 38.4444], [-122.64989, 38.44433], [-122.65007, 38.44418], [-122.65083, 38.44306], [-122.65083, 38.44301], [-122.65156, 38.44273], [-122.65161, 38.44288], [-122.65162, 38.44308], [-122.65159, 38.44324], [-122.6515, 38.44346], [-122.65093, 38.44418], [-122.65108, 38.44567], [-122.65145, 38.44877], [-122.65288, 38.44828], [-122.65288, 38.44824], [-122.65402, 38.44754], [-122.65408, 38.44758], [-122.65441, 38.44738], [-122.65481, 38.44829], [-122.65664, 38.44869], [-122.65663, 38.44906], [-122.6567, 38.44962], [-122.6572, 38.44987], [-122.65844, 38.45468], [-122.66092, 38.45518]]], [[[-122.64843, 38.45767], [-122.64835, 38.45774], [-122.64824, 38.45775], [-122.6469, 38.45746], [-122.64388, 38.45708], [-122.64438, 38.45707], [-122.64506, 38.45703], [-122.64608, 38.45691], [-122.64721, 38.45669], [-122.64823, 38.45644], [-122.64828, 38.45644], [-122.64831, 38.45647], [-122.64848, 38.45735], [-122.64843, 38.45767]]]]} Open Access 1 Spring Lake Regional Park http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Spring_Lake_Regional_Park.aspx 28940 328 Sonoma County Regional Parks Dept., County of 189 County 3 County Agency - Parks 7 http://parks.sonomacounty.ca.gov/ County 3 352.406 Spring Lake RP 1970

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);