Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9972 | 9972 | 173766 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
9974 | 9974 | 173765 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
9975 | 9975 | 173768 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
9976 | 9976 | 173769 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
9978 | 9978 | 173767 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
13296 | 13296 | 187658 | Property Tree 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 600X Clarendon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5995637.0 | 2102382.0 | 37.7524899085688 | -122.457984564932 | (37.7524899085688, -122.457984564932) | ||||
23961 | 23961 | 247944 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 21 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010317.99645 | 2098902.9194900002 | 37.7437696775404 | -122.40696976733999 | (37.7437696775404, -122.40696976734) | ||||
30956 | 30956 | 191848 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1951 Revere Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6013055.009930001 | 2095902.15156 | 37.735682976376204 | -122.397295372485 | (37.7356829763762, -122.397295372485) | ||||
37941 | 37941 | 201685 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 401 08th St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6010307.98401 | 2109858.68813 | 37.773851197808206 | -122.407776750616 | (37.7738511978082, -122.407776750616) | ||||
38233 | 38233 | 191806 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 347 San Bruno Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6010921.55784 | 2106905.85989 | 37.7657777364646 | -122.405446288816 | (37.7657777364646, -122.405446288816) | ||||
47483 | 47483 | 223974 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2 Miguel St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6003823.8109 | 2097275.5293400004 | 37.7389356956285 | -122.429309094259 | (37.7389356956285, -122.429309094259) | ||||
53072 | 53072 | 191824 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 295 San Bruno Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 6010910.67908 | 2107126.67361 | 37.7663834325752 | -122.405499469327 | (37.7663834325752, -122.405499469327) | ||||
53797 | 53797 | 201666 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 401 08th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6010327.42074 | 2109693.60049 | 37.77339899349779 | -122.40769787286999 | (37.7733989934978, -122.40769787287) | ||||
64580 | 64580 | 246671 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 950 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 8ft | 6005232.0889 | 2097709.97714 | 37.7402082183385 | -122.424470809079 | (37.7402082183385, -122.424470809079) | |||
66845 | 66845 | 191823 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 295 San Bruno Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6010913.1498300005 | 2107097.65952 | 37.766303904620706 | -122.405488879804 | (37.7663039046207, -122.405488879804) | ||||
71070 | 71070 | 191828 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 295 San Bruno Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010898.97678 | 2107303.7409200002 | 37.7668689648497 | -122.40555241780301 | (37.7668689648497, -122.405552417803) | ||||
87916 | 87916 | 98953 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 302 Ivy St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | |||||
95272 | 95272 | 101396 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 305X Hickory St | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005503.9 | 2110451.5 | 37.775208804322 | -122.42443704976002 | (37.775208804322, -122.42443704976) | |||||
97455 | 97455 | 98954 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 302 Ivy St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | |||||
98079 | 98079 | 104865 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 80 Stoneman St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770375 | 6007947.7 | 2099422.0 | 37.7450620347132 | -122.415202450973 | (37.7450620347132, -122.415202450973) | ||||
116217 | 116217 | 101395 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 305X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005503.9 | 2110451.5 | 37.775208804322 | -122.42443704976002 | (37.775208804322, -122.42443704976) | |||||
120530 | 120530 | 101394 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 305X Hickory St | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005503.9 | 2110451.5 | 37.775208804322 | -122.42443704976002 | (37.775208804322, -122.42443704976) | |||||
124473 | 124473 | 101397 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 305X Hickory St | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005503.9 | 2110451.5 | 37.775208804322 | -122.42443704976002 | (37.775208804322, -122.42443704976) | |||||
127862 | 127862 | 101393 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 305X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005503.9 | 2110451.5 | 37.775208804322 | -122.42443704976002 | (37.775208804322, -122.42443704976) | |||||
130839 | 130839 | 201686 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 401 08th St | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6010289.03016 | 2109854.63752 | 37.773839014688605 | -122.40784202968399 | (37.7738390146886, -122.407842029684) | ||||
135514 | 135514 | 191807 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 347 San Bruno Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010921.23065 | 2106894.45313 | 37.765746397792896 | -122.405446617089 | (37.7657463977929, -122.405446617089) | ||||
135707 | 135707 | 191829 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 295 San Bruno Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6010896.91966 | 2107334.2705900003 | 37.7669526773576 | -122.405561683542 | (37.7669526773576, -122.405561683542) | ||||
142126 | 142126 | 104912 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 606 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
142622 | 142622 | 101392 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 305X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005503.9 | 2110451.5 | 37.775208804322 | -122.42443704976002 | (37.775208804322, -122.42443704976) | |||||
157785 | 157785 | 191846 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 501 Cargo Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6016191.78302 | 2099504.51493 | 37.7457484711066 | -122.386701364192 | (37.7457484711066, -122.386701364192) | ||||
169471 | 169471 | 191845 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 501 Cargo Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6016186.96689 | 2099510.84816 | 37.745765594211896 | -122.386718459388 | (37.7457655942119, -122.386718459388) | ||||
176655 | 176655 | 191825 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 295 San Bruno Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010908.23936 | 2107157.2110599997 | 37.766467145063295 | -122.40551005884399 | (37.7664671450633, -122.405510058844) | ||||
183953 | 183953 | 191827 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 295 San Bruno Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6010901.57651 | 2107243.4746 | 37.7667036325957 | -122.405539180706 | (37.7667036325957, -122.405539180706) | ||||
188356 | 188356 | 191826 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 295 San Bruno Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6010905.89274 | 2107192.31992 | 37.7665634148087 | -122.40552064836099 | (37.7665634148087, -122.405520648361) |
JSON shape: default, array, newline-delimited
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");