Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23909 | 23909 | 249678 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2400 Baker St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5999727.06015 | 2117202.6736 | 37.7934178626924 | -122.444905786498 | (37.7934178626924, -122.444905786498) | ||||
30306 | 30306 | 248645 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Church St | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6004348.66213 | 2104681.30747 | 37.7592999422487 | -122.428022000737 | (37.7592999422487, -122.428022000737) | ||||
38653 | 38653 | 176017 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6009623.1629099995 | 2089154.9429900001 | 37.7169648982982 | -122.408684805076 | (37.7169648982982, -122.408684805076) | ||||
40650 | 40650 | 189425 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 736 Arkansas St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 7ft | 6012997.735719999 | 2103581.94425 | 37.756766863219106 | -122.39803198109301 | (37.7567668632191, -122.398031981093) | |||
47368 | 47368 | 248653 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1001 San Jose Ave | 48 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6005296.42687 | 2097177.8941099998 | 37.738750871460205 | -122.424210521903 | (37.7387508714602, -122.424210521903) | ||||
47950 | 47950 | 176025 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6009634.04356 | 2089276.3567700002 | 37.7172988849001 | -122.408655756084 | (37.7172988849001, -122.408655756084) | ||||
49696 | 49696 | 248657 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 111 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6005025.16759 | 2096929.69692 | 37.7380540578596 | -122.425130754104 | (37.7380540578596, -122.425130754104) | ||||
54155 | 54155 | 222119 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 4053 20th St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 3ft | 6003326.69183 | 2104161.6671 | 37.7578152622781 | -122.431519370624 | (37.7578152622781, -122.431519370624) | |||
54175 | 54175 | 248651 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1201 San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6004132.59499 | 2095830.66152 | 37.7349858929719 | -122.42813852050301 | (37.7349858929719, -122.428138520503) | ||||
54591 | 54591 | 248654 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 81 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005089.97805 | 2097022.6793 | 37.7383130275105 | -122.42491328541901 | (37.7383130275105, -122.424913285419) | ||||
55194 | 55194 | 248652 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1001 San Jose Ave | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005286.42848 | 2097142.8356 | 37.7386540441353 | -122.42424259893801 | (37.7386540441353, -122.424242598938) | ||||
62845 | 62845 | 176023 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6009654.67743 | 2089334.9097900002 | 37.71746081504929 | -122.40858856232 | (37.7174608150493, -122.40858856232) | ||||
65371 | 65371 | 222118 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 4053 20th St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6003329.88306 | 2104158.35572 | 37.7578063508916 | -122.431508097635 | (37.7578063508916, -122.431508097635) | |||
66336 | 66336 | 189432 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Davidson Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 6ft | 6014722.019230001 | 2099603.1392 | 37.745937791909206 | -122.391790529623 | (37.7459377919092, -122.391790529623) | |||
74105 | 74105 | 176021 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6009620.695040001 | 2089243.5370200002 | 37.7172080210075 | -122.40869958183701 | (37.7172080210075, -122.408699581837) | ||||
139883 | 139883 | 222942 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 671 Church St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 3ft | 6004320.06266 | 2105000.56533 | 37.760174930454 | -122.428143663721 | (37.760174930454, -122.428143663721) | |||
155641 | 155641 | 176020 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6009615.5207400005 | 2089232.9452 | 37.7171786482456 | -122.408716720218 | (37.7171786482456, -122.408716720218) | ||||
156791 | 156791 | 248646 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Church St | 45 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6004337.8277 | 2104713.595 | 37.759387983176 | -122.42806177235501 | (37.759387983176, -122.428061772355) | ||||
157188 | 157188 | 176019 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6009612.43081 | 2089172.96988 | 37.717013795323 | -122.408723171949 | (37.717013795323, -122.408723171949) | ||||
157313 | 157313 | 176059 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 265 Ottawa Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5998208.53283 | 2089432.6135599997 | 37.7170813919775 | -122.448159469808 | (37.7170813919775, -122.448159469808) | ||||
162363 | 162363 | 176024 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6009648.362380001 | 2089313.42999 | 37.7174014822691 | -122.40860887622 | (37.7174014822691, -122.40860887622) | ||||
163343 | 163343 | 249722 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6000190.26691 | 2117349.57001 | 37.7938476262185 | -122.443313617731 | (37.7938476262185, -122.443313617731) | ||||
169087 | 169087 | 248655 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 107 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005056.20315 | 2096946.76695 | 37.7381026814961 | -122.425024662861 | (37.7381026814961, -122.425024662861) | ||||
169864 | 169864 | 176022 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6009662.72679 | 2089352.75305 | 37.7175102597674 | -122.408561997261 | (37.7175102597674, -122.408561997261) | ||||
170804 | 170804 | 249742 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6000223.59296 | 2117195.73646 | 37.7934271400971 | -122.44318725311199 | (37.7934271400971, -122.443187253112) | ||||
176014 | 176014 | 248656 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 110 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005044.37292 | 2096931.03803 | 37.7380588251561 | -122.42506444708 | (37.7380588251561, -122.42506444708) | ||||
185881 | 185881 | 176018 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6009605.36223 | 2089158.99044 | 37.7169750147514 | -122.40874661906 | (37.7169750147514, -122.40874661906) | ||||
189033 | 189033 | 249723 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6000201.87433 | 2117349.10426 | 37.7938470092862 | -122.443273421624 | (37.7938470092862, -122.443273421624) | ||||
90871 | 90871 | 111272 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X BOSWORTH ST | 11 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 8 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
95291 | 95291 | 101437 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 31X College Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004315.3 | 2095877.6 | 37.7351251110849 | -122.427510187339 | (37.7351251110849, -122.427510187339) | |||||
95546 | 95546 | 104524 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 43X BONVIEW ST | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6007716.0 | 2099172.0 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | |||||
99739 | 99739 | 111264 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X BOSWORTH ST | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 10 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
103229 | 103229 | 101442 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 31X College Ave | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004315.3 | 2095877.6 | 37.7351251110849 | -122.427510187339 | (37.7351251110849, -122.427510187339) | |||||
111135 | 111135 | 111530 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900x BOSWORTH ST | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 8 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
122172 | 122172 | 101448 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 31X College Ave | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004315.3 | 2095877.6 | 37.7351251110849 | -122.427510187339 | (37.7351251110849, -122.427510187339) | |||||
120714 | 120714 | 104436 | Private 5 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 SAN FERNANDO WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 5992040.0 | 2096369.0 | 37.7357724272627 | -122.469985704629 | (37.7357724272627, -122.469985704629) | ||||
16097 | 16097 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X Portola Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
78769 | 78769 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
81752 | 81752 | 116834 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
84676 | 84676 | 105867 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 3555 Cesar Chavez St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | |||||
87953 | 87953 | 105869 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 3555 Cesar Chavez St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | |||||
95921 | 95921 | 116835 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
110125 | 110125 | 116836 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
112089 | 112089 | 104435 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X PORTOLA DR | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 5991823.0 | 2096240.0 | 37.73540567927029 | -122.47072655808 | (37.7354056792703, -122.47072655808) | ||||
112586 | 112586 | 105870 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 3555 Cesar Chavez St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | |||||
114433 | 114433 | 116837 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
120773 | 120773 | 115697 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1425x LAGUNA ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6004559.0 | 2113815.0 | 37.7843907406582 | -122.4279454018 | (37.7843907406582, -122.4279454018) | ||||
123839 | 123839 | 114250 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 131 FONT BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
124187 | 124187 | 104433 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X PORTOLA DR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 5991823.0 | 2096240.0 | 37.73540567927029 | -122.47072655808 | (37.7354056792703, -122.47072655808) | ||||
124994 | 124994 | 104434 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X PORTOLA DR | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 5991823.0 | 2096240.0 | 37.73540567927029 | -122.47072655808 | (37.7354056792703, -122.47072655808) | ||||
138562 | 138562 | 105871 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 3555 Cesar Chavez St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | |||||
140647 | 140647 | 105160 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600X OAKDALE AVE | 1 | Front Yard : Yard 7 | Tree 1 | Arts Commission 19 | 13 | Permit Number 770204 | 6015006.0 | 2095503.0 | 37.734695414582795 | -122.390522107646 | (37.7346954145828, -122.390522107646) | |||
140956 | 140956 | 105868 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 3555 Cesar Chavez St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) |
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");