Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11670 | 11670 | 102444 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 430X Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001528.5407 | 2088896.6516 | 37.715798995606704 | -122.436645469419 | (37.7157989956067, -122.436645469419) | |||
68221 | 68221 | 174976 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 842 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6001033.7824 | 2088915.45345 | 37.715822492195294 | -122.438356925152 | (37.7158224921953, -122.438356925152) | |||
79402 | 79402 | 105345 | Acacia melanoxylon :: Blackwood Acacia 5 | 466 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5989603.4 | 2089229.6 | 37.7160282834266 | -122.477888136934 | (37.7160282834266, -122.477888136934) | ||||||
68992 | 68992 | 203874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Sargent St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 5993391.13026 | 2089210.0639099998 | 37.716193751229895 | -122.464794638879 | (37.7161937512299, -122.464794638879) | |||
69568 | 69568 | 175027 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1277 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6011799.53488 | 2088981.40633 | 37.7166100572882 | -122.401149908137 | (37.7166100572882, -122.401149908137) | |||
9677 | 9677 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9996 | 9996 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
109591 | 109591 | 115677 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x Junipero Serra Blvd | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5991123.2 | 2089585.5 | 37.717093588438 | -122.472660975441 | (37.717093588438, -122.472660975441) | ||||
9667 | 9667 | 11795 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | ||||
99816 | 99816 | 11794 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | |||
114205 | 114205 | 114109 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | ||||
120454 | 120454 | 11793 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | |||
112455 | 112455 | 11817 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
122991 | 122991 | 11815 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
79124 | 79124 | 11774 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 2x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
91193 | 91193 | 11791 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
92042 | 92042 | 11788 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
102978 | 102978 | 11789 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
111936 | 111936 | 11787 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
121435 | 121435 | 11773 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
155676 | 155676 | 188722 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 67 Jennings Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012907.82508 | 2089194.6710700002 | 37.7172574063701 | -122.397334024441 | (37.7172574063701, -122.397334024441) | |||
95899 | 95899 | 104723 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 133X Juan Bautista Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770293 | 5989605.82194 | 2089746.43988 | 37.71744753798011 | -122.47791752727699 | (37.7174475379801, -122.477917527277) | ||||
54078 | 54078 | 175055 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 6ft | 5989631.25858 | 2089762.2141 | 37.717492326377396 | -122.47783075799299 | (37.7174923263774, -122.477830757993) | |||
146940 | 146940 | 175054 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 5989611.995 | 2089764.5445599998 | 37.717497607213 | -122.477897512877 | (37.717497607213, -122.477897512877) | |||
130572 | 130572 | 175056 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 6ft | 5989706.768680001 | 2089771.1957900003 | 37.7175213699925 | -122.47757041324199 | (37.7175213699925, -122.477570413242) | |||
51655 | 51655 | 203864 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 Capitol Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5995082.38491 | 2089680.1586900002 | 37.717581884482 | -122.458982907738 | (37.717581884482, -122.458982907738) | |||
152170 | 152170 | 188724 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 961 Le Conte Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6013382.05808 | 2089359.66984 | 37.7177368520568 | -122.395706366661 | (37.7177368520568, -122.395706366661) | ||||
154246 | 154246 | 203865 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5995933.09889 | 2089739.9095599998 | 37.717794812463296 | -122.456046712088 | (37.7177948124633, -122.456046712088) | |||
67831 | 67831 | 188723 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 961 Le Conte Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6013346.445730001 | 2089388.2762799999 | 37.717813418545205 | -122.39583146685499 | (37.7178134185452, -122.395831466855) | ||||
168689 | 168689 | 203856 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1025 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5991221.72934 | 2089959.84815 | 37.7181271596151 | -122.47234768412399 | (37.7181271596151, -122.472347684124) | |||
156135 | 156135 | 200237 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 919 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 6014571.1757 | 2089512.0366 | 37.7182212977035 | -122.39160673351002 | (37.7182212977035, -122.39160673351) | |||
41859 | 41859 | 203857 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1025 Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5991224.82027 | 2090017.2317599999 | 37.718284899813206 | -122.47234118110201 | (37.7182848998132, -122.472341181102) | |||
31911 | 31911 | 174980 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 635 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002900.06306 | 2089775.8785599999 | 37.7182910061937 | -122.431967604438 | (37.7182910061937, -122.431967604438) | |||
135029 | 135029 | 174981 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 635 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002909.51396 | 2089790.5198400002 | 37.718331743700105 | -122.431935981587 | (37.7183317437001, -122.431935981587) | |||
163854 | 163854 | 203872 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 Granada Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995594.11167 | 2089942.67302 | 37.7183320899249 | -122.457233092344 | (37.7183320899249, -122.457233092344) | |||
164225 | 164225 | 203871 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 Granada Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995594.53815 | 2089951.54412 | 37.718356472363794 | -122.45723225957799 | (37.7183564723638, -122.457232259578) | |||
163702 | 163702 | 203870 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 Granada Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995594.9546 | 2089959.9355900001 | 37.718379537275894 | -122.45723142680401 | (37.7183795372759, -122.457231426804) | |||
51801 | 51801 | 203869 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 Granada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5995595.19547 | 2089971.4511099998 | 37.7184111700071 | -122.45723142680401 | (37.7184111700071, -122.457231426804) | |||
57390 | 57390 | 203868 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 Granada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995595.3460099995 | 2089978.64807 | 37.7184309398048 | -122.457231426799 | (37.7184309398048, -122.457231426799) | |||
153003 | 153003 | 203858 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1025 Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5991229.23047 | 2090077.70959 | 37.718451212329505 | -122.47233034336901 | (37.7184512123295, -122.472330343369) | |||
35992 | 35992 | 203867 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5995596.425009999 | 2089995.66595 | 37.7184777288524 | -122.45722892757401 | (37.7184777288524, -122.457228927574) | |||
108061 | 108061 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5989494.0 | 2090180.0 | 37.7186314952818 | -122.47833572411999 | (37.7186314952818, -122.47833572412) | |||||
89406 | 89406 | 114379 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 443X ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5988110.0 | 2090275.0 | 37.718811899837206 | -122.483126550771 | (37.7188118998372, -122.483126550771) | ||||
76095 | 76095 | 203859 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1025 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5991237.16543 | 2090216.1679099998 | 37.718831844103704 | -122.472313003552 | (37.7188318441037, -122.472313003552) | |||
160004 | 160004 | 121403 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1089 Gilman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6015119.7462 | 2089795.6867 | 37.719030579981705 | -122.38973034355601 | (37.7190305799817, -122.389730343556) | |||
55494 | 55494 | 188725 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3311 Jennings St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6013382.39836 | 2089856.6205900002 | 37.7191013987931 | -122.395739991411 | (37.7191013987931, -122.395739991411) | ||||
105643 | 105643 | 104976 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 348 STRATFORD DR | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Permit Number 771068 | 5990941.2 | 2090341.4 | 37.7191585669518 | -122.473345157269 | (37.7191585669518, -122.473345157269) | |||
184381 | 184381 | 203860 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1025 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5991248.87422 | 2090355.17031 | 37.719214188172 | -122.472282658627 | (37.719214188172, -122.472282658627) | |||
154993 | 154993 | 203861 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1025 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5991252.63127 | 2090414.4123799999 | 37.7193770697644 | -122.472273988268 | (37.7193770697644, -122.472273988268) | |||
72260 | 72260 | 188721 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1062 Key Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 41 | Width 5ft | 6013117.817000001 | 2089964.07481 | 37.7193817246629 | -122.396662082497 | (37.7193817246629, -122.396662082497) | |||
130262 | 130262 | 200159 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1043 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 6013947.408 | 2089985.5634 | 37.719486864857004 | -122.39379597620301 | (37.719486864857, -122.393795976203) | |||
178098 | 178098 | 203895 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3804 19th Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5990601.6715400005 | 2090472.14101 | 37.719497882902004 | -122.474528301759 | (37.719497882902, -122.474528301759) | |||
135616 | 135616 | 203898 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3804 19th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 5990605.806480001 | 2090479.00693 | 37.7195169745995 | -122.47451450973401 | (37.7195169745995, -122.474514509734) | |||
169189 | 169189 | 203896 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3804 19th Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5990596.84308 | 2090479.6929400002 | 37.7195183388684 | -122.474545542655 | (37.7195183388684, -122.474545542655) | |||
83097 | 83097 | 203899 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3804 19th Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5990601.43491 | 2090484.5627400002 | 37.719531976188705 | -122.474530025745 | (37.7195319761887, -122.474530025745) | |||
187365 | 187365 | 203897 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3804 19th Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5990591.46397 | 2090484.77315 | 37.7195319761952 | -122.474564506644 | (37.7195319761952, -122.474564506644) | |||
170825 | 170825 | 203900 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3804 19th Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 2ft | 5990599.120069999 | 2090493.0550400002 | 37.7195551598198 | -122.474538646659 | (37.7195551598198, -122.474538646659) | |||
144555 | 144555 | 116959 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1090x KEY AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013239.0 | 2090033.0 | 37.719577723269 | -122.396248023097 | (37.719577723269, -122.396248023097) | ||||
142221 | 142221 | 104943 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 830X Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | ||||||
1175 | 1175 | 2161 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x100 | 6009743.36579 | 2090187.72527 | 37.71980743673429 | -122.408342124702 | (37.7198074367343, -122.408342124702) | |||
169832 | 169832 | 203866 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 90 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996236.4849 | 2090473.9124900002 | 37.7198276211289 | -122.455051057381 | (37.7198276211289, -122.455051057381) | |||
854 | 854 | 203901 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3794 19th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 12 | Width 3ft | 5990470.121669999 | 2090714.3108400002 | 37.720155198286 | -122.475000685058 | (37.720155198286, -122.475000685058) | |||
85780 | 85780 | 396 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3790X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 2 | 5990481.42225 | 2090722.77019 | 37.7201790804753 | -122.474962240321 | (37.7201790804753, -122.474962240321) | |||
36772 | 36772 | 175020 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500x Mansell St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6010396.843230001 | 2090323.76583 | 37.7202175482911 | -122.40609285101401 | (37.7202175482911, -122.406092851014) | |||
61027 | 61027 | 203863 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 68 Williar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997075.35009 | 2090631.23429 | 37.720307679246 | -122.45216275513201 | (37.720307679246, -122.452162755132) | |||
186416 | 186416 | 203873 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 178 Tara St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 5997913.09605 | 2090617.6625599999 | 37.7203183685688 | -122.449265978542 | (37.7203183685688, -122.449265978542) | |||
41350 | 41350 | 203862 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 951 Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 5991278.5837 | 2090872.19555 | 37.7206355315929 | -122.472217633157 | (37.7206355315929, -122.472217633157) | |||
85625 | 85625 | 382 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3721X 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | |||
188663 | 188663 | 174970 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 5999272.73496 | 2090903.68447 | 37.7211813957975 | -122.44458671600901 | (37.7211813957975, -122.444586716009) | |||
45609 | 45609 | 369 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3690X 19th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 25 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | ||
98662 | 98662 | 358 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3690X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | |||
62472 | 62472 | 174971 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 4ft | 5999223.81864 | 2090928.80368 | 37.7212475759866 | -122.444757609674 | (37.7212475759866, -122.444757609674) | |||
115881 | 115881 | 11755 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 901X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X4 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | |||
144074 | 144074 | 92957 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
145041 | 145041 | 92956 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
98300 | 98300 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1107 Bowdoin St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | ||
126969 | 126969 | 114947 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 146 STRATFORD DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990875.0 | 2091468.0 | 37.7222480982686 | -122.47365612145599 | (37.7222480982686, -122.473656121456) | ||||
142135 | 142135 | 339 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3590X 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | |||
135035 | 135035 | 175071 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 327 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6003750.622719999 | 2091634.49721 | 37.7234425468108 | -122.429160031623 | (37.7234425468108, -122.429160031623) | |||
174244 | 174244 | 203854 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1209 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995041.91528 | 2091943.51422 | 37.723794192530704 | -122.4592866043 | (37.7237941925307, -122.4592866043) | |||
18488 | 18488 | 98514 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1209 Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995023.6 | 2091955.9 | 37.7238271478872 | -122.45935081328001 | (37.7238271478872, -122.45935081328) | ||||
145989 | 145989 | 98513 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 De Montfort Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 775766 | 5995016.6 | 2091971.4 | 37.723869304698404 | -122.459376132933 | (37.7238693046984, -122.459376132933) | ||
72463 | 72463 | 174982 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 323 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002277.67573 | 2091830.36717 | 37.7238968690373 | -122.434265730182 | (37.7238968690373, -122.434265730182) | |||
49944 | 49944 | 203855 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 330 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5994200.98333 | 2092085.6479 | 37.7241360734166 | -122.46220384764999 | (37.7241360734166, -122.46220384765) | |||
128477 | 128477 | 324 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3470X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2008 12:00:00 AM | 20 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
120154 | 120154 | 30291 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 861 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1956 12:00:00 AM | Permit Number 134 | 6009266.77435284 | 2092132.72070272 | 37.725121286809 | -122.410126783708 | (37.725121286809, -122.410126783708) | |||
128011 | 128011 | 30290 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 861 Bowdoin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1956 12:00:00 AM | Permit Number 134 | 6009266.77435284 | 2092132.72070272 | 37.725121286809 | -122.410126783708 | (37.725121286809, -122.410126783708) | |||
179049 | 179049 | 175068 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Woolsey St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6011564.90281 | 2092154.99462 | 37.7253109908919 | -122.402183913575 | (37.7253109908919, -122.402183913575) | ||||
53119 | 53119 | 175069 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Woolsey St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6011573.1556 | 2092162.2260200002 | 37.7253313074768 | -122.402155892479 | (37.7253313074768, -122.402155892479) | ||||
181186 | 181186 | 175070 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Woolsey St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6011561.993480001 | 2092186.33195 | 37.725396874350096 | -122.40219617312599 | (37.7253968743501, -122.402196173126) | ||||
182634 | 182634 | 174969 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 445 Wayland St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 6010264.89767 | 2092223.3382299999 | 37.7254259988853 | -122.40668274244 | (37.7254259988853, -122.40668274244) | |||
179031 | 179031 | 203988 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 665 Faxon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 3ft | 5994873.24978 | 2092595.62975 | 37.72557504624321 | -122.459916865398 | (37.7255750462432, -122.459916865398) | |||
35032 | 35032 | 203989 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 665 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 3ft | 5994872.64121 | 2092622.4417599998 | 37.725648630558 | -122.45992091053999 | (37.725648630558, -122.45992091054) | |||
171221 | 171221 | 112905 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2401 Keith St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6014331.87009 | 2092225.76664 | 37.725659374776605 | -122.39262364628901 | (37.7256593747766, -122.392623646289) | ||||
160400 | 160400 | 174968 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 479 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010452.97005 | 2092347.5292200001 | 37.7257775222972 | -122.406041335159 | (37.7257775222972, -122.406041335159) | |||
18211 | 18211 | 11709 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.83406 | 2092750.4086799999 | 37.7257930014245 | -122.472332875878 | (37.7257930014245, -122.472332875878) | ||
88947 | 88947 | 4806 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
91586 | 91586 | 4807 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
108562 | 108562 | 4809 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
111013 | 111013 | 4808 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) |
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");