Street_Tree_List

Data source: data.sfgov.org

26 rows where qSiteInfo = 10 and qSpecies = 26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
23569 23569 211718 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 431 Arch St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13 Width 4ft   5992705.448530001 2090061.4664900003 37.7184919399203 -122.46722653339701 (37.7184919399203, -122.467226533397)
38146 38146 133109 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2165 Larkin St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 3ft   6006796.6171 2118647.14337 37.797784942667796 -122.420547132639 (37.7977849426678, -122.420547132639)
39220 39220 234038 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 95 Scott St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     9 Width 3ft   6002345.035630001 2108759.77422 37.7703848563176 -122.43524322850901 (37.7703848563176, -122.435243228509)
43352 43352 211539 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2222 15th Ave 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 5ft   5991737.95589 2099026.97767 37.7430530932385 -122.471223572022 (37.7430530932385, -122.471223572022)
44695 44695 133086 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1363 Greenwich St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13 Width 3ft   6006377.99915 2119694.92675 37.8006382900875 -122.42207014351601 (37.8006382900875, -122.422070143516)
50421 50421 211541 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2222 15th Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 5ft   5991738.93886 2098974.6083299997 37.742909357292596 -122.471216358549 (37.7429093572926, -122.471216358549)
55054 55054 133041 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1540 Larkin St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 3ft   6007120.87894 2116663.94898 37.792357854292895 -122.41928433701901 (37.7923578542929, -122.419284337019)
60570 60570 178506 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 228 Cordova St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     15 Width 3ft   6001829.54929 2087210.3401900001 37.7111858584149 -122.43548448333 (37.7111858584149, -122.43548448333)
63137 63137 235070 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 215 Downey St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     21 Width 8ft   5998946.73151 2106903.42094 37.7650942121447 -122.44686432194901 (37.7650942121447, -122.446864321949)
67978 67978 133085 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1363 Greenwich St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     9 Width 3ft   6006365.71359 2119692.80875 37.800631781676 -122.422112506109 (37.800631781676, -122.422112506109)
72956 72956 194740 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 407 Mississippi St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 3ft   6014090.52172 2105188.8947400004 37.761240003849394 -122.39436520770201 (37.7612400038494, -122.394365207702)
73659 73659 133174 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1900 The Embarcadero 10 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 5ft   6010559.670419999 2122087.00358 37.8074413034386 -122.407768542507 (37.8074413034386, -122.407768542507)
73798 73798 234037 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 95 Scott St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 3ft   6002343.23108 2108773.3042200003 37.7704219038818 -122.435250438364 (37.7704219038818, -122.435250438364)
130422 130422 140117 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1245 SCOTT ST 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     22 Width 0ft   6001782.3984 2112830.1093 37.781529008773205 -122.437480910872 (37.7815290087732, -122.437480910872)
155751 155751 211540 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2222 15th Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 5ft   5991738.81904 2098988.7367 37.7429481432502 -122.47121780198 (37.7429481432502, -122.47121780198)
156115 156115 133175 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1900 The Embarcadero 11 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 8ft   6010562.9606 2122079.77861 37.807421649655204 -122.407756646259 (37.8074216496552, -122.407756646259)
158272 158272 133087 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1317 Greenwich St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     16 Width 3ft   6006619.24157 2119726.54508 37.800738709284396 -122.421237590762 (37.8007387092844, -122.421237590762)
162123 162123 138677 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1715 LYON ST 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 0ft   5999549.5882 2114750.275 37.786674090325704 -122.445343438769 (37.7866740903257, -122.445343438769)
163931 163931 234272 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 217 Montcalm St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 6ft   6009881.38473 2099607.36968 37.74567950211029 -122.40852915581999 (37.7456795021103, -122.40852915582)
166061 166061 234264 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 67 Elsie St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     14 Width 4ft   6007449.05655 2099022.65505 37.743937486518604 -122.416898387949 (37.7439374865186, -122.416898387949)
166839 166839 235158 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 3350 18th St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 3ft   6007121.98711 2105585.0630099997 37.761937957793606 -122.418494559572 (37.7619379577936, -122.418494559572)
171576 171576 211717 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 431 Arch St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     14 Width 4ft   5992705.603080001 2090068.8173099998 37.7185121324114 -122.46722653337099 (37.7185121324114, -122.467226533371)
172990 172990 138675 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1719 LYON ST 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 0ft   5999545.102999999 2114776.1511 37.7867448833104 -122.44536081765499 (37.7867448833104, -122.445360817655)
175324 175324 133042 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1540 Larkin St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 3ft   6007115.6453 2116707.0734200003 37.792475968553205 -122.41930550615 (37.7924759685532, -122.41930550615)
176789 176789 133148 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 240 Vallejo St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13 Width 10ft   6012318.917 2119175.00997 37.7995440040196 -122.401475444761 (37.7995440040196, -122.401475444761)
184274 184274 133108 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2165 Larkin St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10 Width 3ft   6006794.50098 2118664.81919 37.7978333567673 -122.420555710387 (37.7978333567673, -122.420555710387)

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