units_with_maps

Table actions

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

2 rows where DES_TP = 4, MNG_AGENCY = 639 and MNG_AG_LEV = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Sunrise Recreation and Park District · 2 ✖

DES_TP 1

  • Local Conservation Area · 2 ✖

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
3774 3774 3773 {"type": "Polygon", "coordinates": [[[-121.27757, 38.6844], [-121.27735, 38.6846], [-121.27714, 38.68446], [-121.27711, 38.68447], [-121.2769, 38.68433], [-121.27643, 38.68417], [-121.27632, 38.68409], [-121.27631, 38.68391], [-121.27174, 38.68393], [-121.27173, 38.68226], [-121.27214, 38.68226], [-121.27215, 38.68233], [-121.2722, 38.68239], [-121.27221, 38.68272], [-121.27308, 38.68271], [-121.27344, 38.68278], [-121.27471, 38.68354], [-121.27632, 38.68353], [-121.27632, 38.68368], [-121.27663, 38.68395], [-121.27711, 38.68411], [-121.27733, 38.68427], [-121.27736, 38.68425], [-121.27757, 38.6844]]]} Open Access 1 45019 Arcade Creek Park Preserve Development 15564 2199 Sunrise Recreation and Park District 650 Special District 4 Recreation/Parks District 4 http://sunriseparks.com/ Special District 4 2199 Sunrise Recreation and Park District 639 Special District 4 Recreation/Parks District 4   Sacramento 41 10.069 Arcade Creek Park Preserve Development 0 Local Conservation Area 4 2
13650 13650 13649 {"type": "MultiPolygon", "coordinates": [[[[-121.33733, 38.65608], [-121.33726, 38.65614], [-121.33675, 38.65624], [-121.33626, 38.65622], [-121.33625, 38.65614], [-121.33611, 38.65614], [-121.33612, 38.65605], [-121.33626, 38.65605], [-121.33626, 38.65586], [-121.33595, 38.65586], [-121.33594, 38.65596], [-121.33567, 38.65597], [-121.33544, 38.656], [-121.33528, 38.65609], [-121.33507, 38.65607], [-121.3349, 38.65612], [-121.33473, 38.65611], [-121.33473, 38.65602], [-121.33503, 38.65542], [-121.33588, 38.65516], [-121.33664, 38.65615], [-121.33685, 38.65592], [-121.33686, 38.65596], [-121.3369, 38.65595], [-121.337, 38.65602], [-121.33708, 38.65596], [-121.33714, 38.65588], [-121.33712, 38.65577], [-121.33701, 38.65573], [-121.33713, 38.6556], [-121.33733, 38.65608]]], [[[-121.34277, 38.65129], [-121.3424, 38.65235], [-121.34226, 38.65268], [-121.3423, 38.65301], [-121.34224, 38.65322], [-121.34218, 38.65329], [-121.34119, 38.65388], [-121.34097, 38.65419], [-121.34028, 38.65443], [-121.34023, 38.65451], [-121.34015, 38.65456], [-121.33895, 38.65492], [-121.33851, 38.65508], [-121.33812, 38.65534], [-121.33759, 38.65583], [-121.33737, 38.65531], [-121.33768, 38.65521], [-121.33764, 38.65509], [-121.33794, 38.65502], [-121.33797, 38.65507], [-121.33997, 38.65418], [-121.33999, 38.65419], [-121.34003, 38.65419], [-121.34057, 38.65396], [-121.34096, 38.65375], [-121.34127, 38.65348], [-121.34133, 38.65336], [-121.34178, 38.65282], [-121.34199, 38.65245], [-121.34206, 38.6523], [-121.34193, 38.65232], [-121.34204, 38.65212], [-121.34207, 38.65191], [-121.34226, 38.65143], [-121.34184, 38.65078], [-121.34162, 38.6506], [-121.34115, 38.64998], [-121.34119, 38.64993], [-121.34115, 38.64975], [-121.34121, 38.6493], [-121.34129, 38.64906], [-121.3418, 38.64906], [-121.34176, 38.64925], [-121.34156, 38.64955], [-121.34175, 38.64992], [-121.34179, 38.65006], [-121.34183, 38.65041], [-121.34215, 38.65048], [-121.34264, 38.65089], [-121.34277, 38.65129]]]]} Open Access 1 36015 Arcade Creek Nature Area 15562 2199 Sunrise Recreation and Park District 650 Special District 4 Recreation/Parks District 4 http://sunriseparks.com/ Special District 4 2199 Sunrise Recreation and Park District 639 Special District 4 Recreation/Parks District 4   Sacramento 41 12.32 Arcade Creek Nature 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]);