Street_Tree_List

Data source: data.sfgov.org

52 rows where qAddress = "1600 Bay Shore Blvd" and qSpecies = 178

View and edit SQL

Suggested facets: DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
27143 197825 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6011965.06287 2091392.40975 37.7232394169387 -122.40074704065701 (37.7232394169387, -122.400747040657)
30563 197865 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 70 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6012061.31156 2091075.0392200002 37.7223733500335 -122.400392044067 (37.7223733500335, -122.400392044067)
32085 197864 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 69 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6012060.1959 2091081.01697 37.7223897015024 -122.400396320338 (37.7223897015024, -122.400396320338)
32658 197832 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6011977.7440599995 2091356.8323099997 37.7231424358482 -122.400700705798 (37.7231424358482, -122.400700705798)
33327 197866 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 71 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 6ft   6012063.85801 2091068.416 37.7223553060236 -122.40038277654499 (37.7223553060236, -122.400382776545)
34615 197842 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6012001.83454 2091273.05649 37.7229137481456 -122.400611547001 (37.7229137481456, -122.400611547001)
34785 197862 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 63 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 6ft   6012051.726319999 2091110.75942 37.7224708958979 -122.400427686008 (37.7224708958979, -122.400427686008)
36152 197853 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 53 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 6ft   6012031.29161 2091170.72572 37.7226344115455 -122.400502534772 (37.7226344115455, -122.400502534772)
36868 197828 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6011973.2449 2091368.8338900001 37.7231751387972 -122.40071710133002 (37.7231751387972, -122.40071710133)
40386 197821 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 6ft   6011948.3491 2091445.19124 37.7233834118888 -122.40080852368799 (37.7233834118888, -122.400808523688)
45615 197863 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 68 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 6ft   6012058.46574 2091087.21256 37.7224066168474 -122.400402736103 (37.7224066168474, -122.400402736103)
47089 197845 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 41 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 6ft   6012007.9467400005 2091249.84858 37.7228503648454 -122.400588788767 (37.7228503648454, -122.400588788767)
48301 197854 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 54 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6012033.02176 2091164.53012 37.7226174961786 -122.400496118999 (37.7226174961786, -122.400496118999)
56679 197819 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6011944.173880001 2091457.7319099999 37.72341761312129 -122.400823837369 (37.7234176131213, -122.400823837369)
57257 197860 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6012046.4319 2091124.21465 37.722507545966 -122.400446932379 (37.722507545966, -122.400446932379)
58546 197855 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 55 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   6012034.51067 2091159.2407799999 37.722603055763 -122.400490600775 (37.722603055763, -122.400490600775)
60277 197857 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 57 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 6ft   6012039.29397 2091145.5342400002 37.7225656871526 -122.400473103552 (37.7225656871526, -122.400473103552)
68409 197818 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   6011942.23236 2091464.77748 37.7234368505223 -122.400831043644 (37.7234368505223, -122.400831043644)
68740 197839 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 33 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6011996.37526 2091289.30529 37.7229580595596 -122.40063155961701 (37.7229580595596, -122.400631559617)
71389 197840 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 34 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6011997.53285 2091285.37995 37.722947345938394 -122.40062728242701 (37.7229473459384, -122.400627282427)
72034 197843 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   6011998.75435 2091272.95857 37.722913307489 -122.40062218776899 (37.722913307489, -122.400622187769)
77231 197858 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6012040.59295 2091139.6421700001 37.7225495811701 -122.40046819956999 (37.7225495811701, -122.40046819957)
130496 197827 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6011971.4942 2091374.0034400001 37.7231892356806 -122.40072351619101 (37.7231892356806, -122.400723516191)
131642 197861 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 62 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 6ft   6012050.3961 2091116.33081 37.7224861196182 -122.40043267545299 (37.7224861196182, -122.400432675453)
131830 197841 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 35 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6011999.88138 2091279.17179 37.7229304305803 -122.400618728092 (37.7229304305803, -122.400618728092)
131860 197831 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6011976.53228 2091358.0890799998 37.7231458190956 -122.40070498295601 (37.7231458190956, -122.400704982956)
134275 197826 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6011969.15818 2091380.8270900003 37.7232078417381 -122.40073207055401 (37.7232078417381, -122.400732070554)
136021 197846 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 42 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6012009.495680001 2091244.88882 37.7228368327421 -122.400583086137 (37.7228368327421, -122.400583086137)
136043 197844 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 38 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 6ft   6012002.51285 2091266.59207 37.7228960359976 -122.400608748319 (37.7228960359976, -122.400608748319)
137585 197824 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 6ft   6011961.73381 2091401.10214 37.723263098784706 -122.40075915902399 (37.7232630987847, -122.400759159024)
149177 197856 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 56 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 6ft   6012037.62299 2091152.5684099998 37.722584908363 -122.40047937365101 (37.722584908363, -122.400479373651)
150558 197829 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6011975.02506 2091365.10159 37.7231649899516 -122.400710685553 (37.7231649899516, -122.400710685553)
156745 197851 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 51 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6012026.99861 2091182.7231 37.7226671144898 -122.400518217155 (37.7226671144898, -122.400518217155)
156996 197834 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 27 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6011984.73293 2091325.2723299998 37.723056168383295 -122.400674330476 (37.7230561683833, -122.400674330476)
158390 197867 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 72 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6012066.20658 2091062.20785 37.7223383906757 -122.400374222197 (37.7223383906757, -122.400374222197)
160157 197849 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 45 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6012013.93234 2091229.80813 37.722795671678796 -122.400566690598 (37.7227956716788, -122.400566690598)
167198 197830 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6011976.224330001 2091363.229 37.723159915090704 -122.40070640839701 (37.7231599150907, -122.400706408397)
169839 197820 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 6ft   6011946.65761 2091451.71293 37.7234012247695 -122.40081482885599 (37.7234012247695, -122.400814828856)
170715 197838 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 32 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6011994.83884 2091294.88087 37.722973283274605 -122.40063726222701 (37.7229732832746, -122.400637262227)
170741 197847 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 43 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6012011.01959 2091238.6974099998 37.7228199173828 -122.40057738355499 (37.7228199173828, -122.400577383555)
171775 197817 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 6ft   6011940.31193 2091472.8608799998 37.723458938768104 -122.400838249897 (37.7234589387681, -122.400838249897)
172263 197868 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 73 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 6ft   6012067.53263 2091056.4311900001 37.722322603090504 -122.40036923277701 (37.7223226030905, -122.400369232777)
174764 197837 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 30 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   6011988.7407 2091309.3789099997 37.723012751823 -122.40065936036699 (37.723012751823, -122.400659360367)
176686 197835 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 28 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6011986.88775 2091319.6841900002 37.7230409446734 -122.400666489273 (37.7230409446734, -122.400666489273)
177376 197859 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 60 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6012044.049980001 2091128.7806099998 37.7225199503291 -122.400455486754 (37.7225199503291, -122.400455486754)
178115 197833 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 24 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 6ft   6011978.85578 2091350.64928 37.7231255205156 -122.40069642862301 (37.7231255205156, -122.400696428623)
182350 197823 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6011949.3976 2091439.17555 37.723366952515995 -122.400804476766 (37.723366952516, -122.400804476766)
185140 197852 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 52 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 6ft   6012028.934719999 2091176.5233200002 37.7226501991326 -122.40051108911999 (37.7226501991326, -122.40051108912)
188059 197850 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 46 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 6ft   6012015.45208 2091223.4114400002 37.722778192429104 -122.40056098802499 (37.7227781924291, -122.400560988025)
188159 197822 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6011948.87446 2091441.14937 37.723372343042996 -122.40080642377899 (37.723372343043, -122.400806423779)
188673 197836 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6011988.43693 2091314.7241 37.7230274116816 -122.40066078576099 (37.7230274116816, -122.400660785761)
189036 197848 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 44 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 6ft   6012012.98096 2091233.72895 37.722806384392 -122.400570254626 (37.722806384392, -122.400570254626)

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 55.658ms · Data source: data.sfgov.org