Street_Tree_List

Data source: data.sfgov.org

21 rows where qLegalStatus = 2, qSiteInfo = 9 and qSpecies = 48

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
36328 119240 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 50 Sutro Heights Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   5981455.34518 2111336.83463 37.776252294734 -122.507690683983 (37.776252294734, -122.507690683983)
44951 227560 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 84 Seward St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   6000737.03493 2104555.7602 37.758750228049294 -122.44050372379101 (37.7587502280493, -122.440503723791)
46405 176898 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 167 Madison St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6005619.38027 2092788.13013 37.7267157831975 -122.42278201629601 (37.7267157831975, -122.422782016296)
48201 119241 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 50 Sutro Heights Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   5981435.03386 2111334.77238 37.776245435782 -122.50776079209999 (37.776245435782, -122.5077607921)
55628 227559 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 84 Seward St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   6000741.2761699995 2104538.3206 37.758702584674204 -122.44048780488001 (37.7587025846742, -122.44048780488)
63496 227556 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 95 Seward St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   6000674.34081 2104608.13246 37.7588904593411 -122.440724304978 (37.7588904593411, -122.440724304978)
66467 176899 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 167 Madison St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6005613.54422 2092807.28897 37.7267680598911 -122.422803552358 (37.7267680598911, -122.422803552358)
68212 119242 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 50 Sutro Heights Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   5981417.66127 2111333.86508 37.7762419210818 -122.507820820241 (37.7762419210818, -122.507820820241)
68691 176904 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 68 Cambridge St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6006443.50632 2094472.10137 37.7313860651023 -122.42005248574499 (37.7313860651023, -122.420052485745)
68947 176905 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 68 Cambridge St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6006453.00873 2094472.53688 37.731387796298705 -122.420019664972 (37.7313877962987, -122.420019664972)
74077 227120 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 799 Duncan St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 4ft   6001486.2339699995 2099669.55813 37.7453765205103 -122.43756273743 (37.7453765205103, -122.43756273743)
75318 176901 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 167 Madison St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6005600.43917 2092849.05844 37.7268820102711 -122.42285182346599 (37.7268820102711, -122.422851823466)
129668 207044 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 755 Foerster St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   5998014.32968 2095894.50831 37.7348131350024 -122.44929603208 (37.7348131350024, -122.44929603208)
133941 227561 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 84 Seward St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   6000738.66154 2104570.78605 37.7587915779822 -122.44049917592 (37.7587915779822, -122.44049917592)
134142 191226 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2350 20th St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 7ft   6011107.06002 2104648.42845 37.7595897074225 -122.40464574203199 (37.7595897074225, -122.404645742032)
158101 119243 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 50 Sutro Heights Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   5981398.37029 2111333.4256599997 37.7762395779827 -122.507887519226 (37.7762395779827, -122.507887519226)
160084 191225 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2350 20th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     6011119.4005 2104649.28038 37.759592736331705 -122.404603122242 (37.7595927363317, -122.404603122242)
164734 120000 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 818 30th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   5986676.70436 2110336.5469299997 37.7738120096448 -122.489555240793 (37.7738120096448, -122.489555240793)
173018 227119 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 799 Duncan St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6001473.16561 2099668.76787 37.7453736076231 -122.437607869022 (37.7453736076231, -122.437607869022)
187240 191224 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2350 20th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     6011129.67031 2104650.44992 37.7595965215873 -122.404567686256 (37.7595965215873, -122.404567686256)
187445 176900 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 167 Madison St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6005606.72127 2092829.9713400002 37.7268299557374 -122.42282875044701 (37.7268299557374, -122.422828750447)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 2997.817ms · Data source: data.sfgov.org