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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
179805 | 179805 | 246827 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 400 Franconia St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6009974.418190001 | 2098730.47702 | 37.7432769560816 | -122.408145625541 | (37.7432769560816, -122.408145625541) | ||||
179804 | 179804 | 120391 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 735 24th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 5988455.47289 | 2110915.29878 | 37.775504786578004 | -122.483444705322 | (37.775504786578, -122.483444705322) | ||||
179664 | 179664 | 184874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984695.3865 | 2106820.2584 | 37.7640414086876 | -122.496149356564 | (37.7640414086876, -122.496149356564) | |||
179656 | 179656 | 125179 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2401 Broadway | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 4ft | 6002026.35862 | 2117343.77621 | 37.793936248109 | -122.436960163797 | (37.793936248109, -122.436960163797) | |||
179644 | 179644 | 184877 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984676.4005 | 2106805.4493 | 37.763999634952505 | -122.49621392986201 | (37.7639996349525, -122.496213929862) | |||
179583 | 179583 | 184846 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984679.0585 | 2106853.294 | 37.764131158732 | -122.496208267019 | (37.764131158732, -122.496208267019) | |||
179567 | 179567 | 203838 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Garcia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995240.511630001 | 2099477.4925700002 | 37.744492072368494 | -122.45914537927 | (37.7444920723685, -122.45914537927) | |||
179489 | 179489 | 124837 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 74 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001772.172780001 | 2121441.71119 | 37.805173649400295 | -122.43813336178002 | (37.8051736494003, -122.43813336178) | |||
179467 | 179467 | 124870 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 15 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6001774.83404 | 2121189.88179 | 37.804482344134996 | -122.438106101537 | (37.804482344135, -122.438106101537) | |||
179417 | 179417 | 218193 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1395 Portola Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 6ft | 5993287.55487 | 2097626.31365 | 37.739296734747796 | -122.46576377800301 | (37.7392967347478, -122.465763778003) | |||
179389 | 179389 | 124929 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 251 Maple St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5996616.75369 | 2115377.9366599997 | 37.7882296279505 | -122.455535665157 | (37.7882296279505, -122.455535665157) | |||
179386 | 179386 | 123392 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 701 03rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5995019.32935 | 2110726.33262 | 37.775365776212794 | -122.46072521493099 | (37.7753657762128, -122.460725214931) | |||
179379 | 179379 | 218114 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 84 Lopez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 5993940.18965 | 2100447.16397 | 37.7470797051661 | -122.463711957653 | (37.7470797051661, -122.463711957653) | |||
179282 | 179282 | 125250 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1073 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008472.63138 | 2118248.82998 | 37.796785583654 | -122.414719436774 | (37.796785583654, -122.414719436774) | |||
179182 | 179182 | 220252 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1421 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002022.45837 | 2099900.18777 | 37.746040248052104 | -122.43572506097901 | (37.7460402480521, -122.435725060979) | |||
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) | ||||
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) | |||
178871 | 178871 | 184858 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984642.9852 | 2106842.6618 | 37.7640998526008 | -122.49633224767 | (37.7640998526008, -122.49633224767) | |||
178801 | 178801 | 203923 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 828 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5990846.91254 | 2101136.3741200003 | 37.7487933678174 | -122.474458431617 | (37.7487933678174, -122.474458431617) | |||
178800 | 178800 | 246189 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1342 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5999553.3724 | 2108105.2897 | 37.768428879976895 | -122.444852507953 | (37.7684288799769, -122.444852507953) | |||
178789 | 178789 | 125121 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2950 Broadway | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 5ft | 5999507.62206 | 2117045.21754 | 37.7929730040528 | -122.44565372745001 | (37.7929730040528, -122.44565372745) | |||
178779 | 178779 | 117641 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3839 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000085.9118 | 2121452.90349 | 37.8051083352412 | -122.443969658797 | (37.8051083352412, -122.443969658797) | |||
178721 | 178721 | 181633 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1258 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | Width 0ft | 5985863.7631 | 2106655.7682 | 37.763658132222204 | -122.49209623052401 | (37.7636581322222, -122.492096230524) | |||
178719 | 178719 | 174989 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Madrid St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 4ft | 6001106.19823 | 2088490.6966400002 | 37.714660323495394 | -122.438076214354 | (37.7146603234954, -122.438076214354) | |||
178658 | 178658 | 125006 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3776 Fillmore St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6002042.338930001 | 2121722.74316 | 37.805960649714706 | -122.43721855518999 | (37.8059606497147, -122.43721855519) | |||
178650 | 178650 | 124785 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3055 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000941.10837 | 2118864.21184 | 37.7980492219479 | -122.44082434468201 | (37.7980492219479, -122.440824344682) | |||
178620 | 178620 | 120227 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 220 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5988073.3301800005 | 2114479.43573 | 37.7852686520197 | -122.485028162067 | (37.7852686520197, -122.485028162067) | |||
178559 | 178559 | 124779 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3060 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000978.44845 | 2118912.97952 | 37.7981852516096 | -122.440698637428 | (37.7981852516096, -122.440698637428) | |||
178538 | 178538 | 188740 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6014461.35341 | 2086969.95596 | 37.711235143968 | -122.391808694124 | (37.711235143968, -122.391808694124) | |||
178526 | 178526 | 183382 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2665 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5986718.0062 | 2097232.4085 | 37.7378340336236 | -122.488449105903 | (37.7378340336236, -122.488449105903) | |||
178510 | 178510 | 186524 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 0ft | 5984779.5703 | 2104623.8794 | 37.7580156968567 | -122.495696174096 | (37.7580156968567, -122.495696174096) | |||
178378 | 178378 | 125207 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2006 Washington St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 6004999.73752 | 2116807.3116599997 | 37.792631803077505 | -122.426633755938 | (37.7926318030775, -122.426633755938) | |||
178371 | 178371 | 94602 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2939 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/07/2010 12:00:00 AM | 9 | Permit Number 53770 | 5999468.945859999 | 2117347.95354 | 37.7938020288031 | -122.445809330858 | (37.7938020288031, -122.445809330858) | ||
178354 | 178354 | 181662 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1291 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5987065.687999999 | 2106524.6306 | 37.7633682504544 | -122.487929566047 | (37.7633682504544, -122.487929566047) | |||
178327 | 178327 | 221408 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3975 22nd St | 3 | : 4 | Tree 1 | Private 1 | 11 | 6001990.46485 | 2102928.2110200003 | 37.7543526628574 | -122.43605233056999 | (37.7543526628574, -122.43605233057) | ||||
178287 | 178287 | 125255 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008500.962 | 2116895.81249 | 37.7930721228272 | -122.414525614892 | (37.7930721228272, -122.414525614892) | |||
178206 | 178206 | 124884 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 139 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 5997523.370680001 | 2115886.76168 | 37.7896787082451 | -122.452435671465 | (37.7896787082451, -122.452435671465) | |||
178188 | 178188 | 220188 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004898.43848 | 2096540.4001099998 | 37.736977976744 | -122.425541221768 | (37.736977976744, -122.425541221768) | ||||
178141 | 178141 | 204009 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1283 Portola Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993898.99812 | 2097834.64802 | 37.7399040199511 | -122.463664812507 | (37.7399040199511, -122.463664812507) | |||
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) | |||
178090 | 178090 | 188717 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 139 Welsh St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6013144.74894 | 2111553.30162 | 37.778662619318105 | -122.39808276132901 | (37.7786626193181, -122.398082761329) | |||
178074 | 178074 | 124940 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3225 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5998833.04968 | 2116235.41982 | 37.7907109779861 | -122.447929444784 | (37.7907109779861, -122.447929444784) | |||
178064 | 178064 | 205141 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 44 Ventura Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5994106.119580001 | 2101835.51566 | 37.750901326556104 | -122.463238916037 | (37.7509013265561, -122.463238916037) | |||
178036 | 178036 | 186862 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985163.1298 | 2096349.2748 | 37.735318336491204 | -122.493759932025 | (37.7353183364912, -122.493759932025) | |||
177977 | 177977 | 125316 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 550 Davis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6013196.92255 | 2118512.0582 | 37.797772647146 | -122.398390667602 | (37.797772647146, -122.398390667602) | |||
177948 | 177948 | 125238 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 859 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6007174.46526 | 2113971.9473200003 | 37.784969297747104 | -122.41890791318501 | (37.7849692977471, -122.418907913185) | |||
177927 | 177927 | 203755 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992494.6034699995 | 2097875.9695599996 | 37.7399364549038 | -122.46852358601801 | (37.7399364549038, -122.468523586018) | |||
177882 | 177882 | 125234 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2330 Octavia St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 6004612.95687 | 2117230.04971 | 37.793770660429395 | -122.428002169785 | (37.7937706604294, -122.428002169785) | |||
177838 | 177838 | 220244 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 611 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6001903.2384 | 2099407.38476 | 37.744680354426706 | -122.436102048694 | (37.7446803544267, -122.436102048694) | |||
177815 | 177815 | 125126 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2921 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5999560.3078 | 2117361.8262400003 | 37.7938453356549 | -122.44549420930099 | (37.7938453356549, -122.445494209301) | |||
177801 | 177801 | 125144 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2455 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6000236.43033 | 2116892.06211 | 37.7925940621141 | -122.44312101533899 | (37.7925940621141, -122.443121015339) | |||
177749 | 177749 | 200602 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 45 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016396.2402 | 2095212.996 | 37.7339761481789 | -122.385695323117 | (37.7339761481789, -122.385695323117) | |||
177728 | 177728 | 124963 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3152 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 5999033.76222 | 2119654.24717 | 37.8001096370985 | -122.447481184912 | (37.8001096370985, -122.447481184912) | |||
177716 | 177716 | 203802 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 365 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994147.85172 | 2101219.85432 | 37.7492132810743 | -122.46304993880501 | (37.7492132810743, -122.463049938805) | |||
177689 | 177689 | 97972 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767976 | 6008572.265240001 | 2094125.62068 | 37.7305544125591 | -122.412668458206 | (37.7305544125591, -122.412668458206) | |
177615 | 177615 | 121885 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 50 18th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 5990230.47733 | 2114817.75454 | 37.7863229938727 | -122.477589910296 | (37.7863229938727, -122.477589910296) | |||
177577 | 177577 | 203906 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 4996 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5990638.47075 | 2093500.4401599998 | 37.727814969685 | -122.47462199853001 | (37.727814969685, -122.47462199853) | |||
177544 | 177544 | 247541 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6000212.071930001 | 2108508.7313900003 | 37.769574199310895 | -122.442603102947 | (37.7695741993109, -122.442603102947) | ||||
177310 | 177310 | 124889 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 342 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996228.817290001 | 2115003.39409 | 37.7871789661719 | -122.45685075186199 | (37.7871789661719, -122.456850751862) | |||
177303 | 177303 | 106245 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Permit Number 770844 | 6012052.957359999 | 2105766.02313 | 37.7627111948751 | -122.401452881641 | (37.7627111948751, -122.401452881641) | |||
177256 | 177256 | 121891 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 24 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5990536.83748 | 2114937.98886 | 37.7866708968722 | -122.476538780783 | (37.7866708968722, -122.476538780783) | |||
177248 | 177248 | 125314 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 550 Davis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6013200.68159 | 2118482.22968 | 37.7976909545355 | -122.398375566176 | (37.7976909545355, -122.398375566176) | |||
177243 | 177243 | 220193 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 65 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 5ft | 6003549.85445 | 2095682.63787 | 37.734546465338504 | -122.43014270374901 | (37.7345464653385, -122.430142703749) | |||
177200 | 177200 | 186934 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985194.2284 | 2095945.4652 | 37.7342114021566 | -122.493622668946 | (37.7342114021566, -122.493622668946) | |||
177194 | 177194 | 184883 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984691.969 | 2106787.6025 | 37.763951544593795 | -122.49615876703399 | (37.7639515445938, -122.496158767034) | |||
177187 | 177187 | 142667 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2310 MASON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008909.645 | 2121229.1326 | 37.804993297242206 | -122.413418141285 | (37.8049932972422, -122.413418141285) | |||
177157 | 177157 | 188629 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 27 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6016065.14365 | 2099087.45333 | 37.7445962938924 | -122.387110184288 | (37.7445962938924, -122.387110184288) | |||
177147 | 177147 | 141867 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004215.6183 | 2112571.0685 | 37.780955782445105 | -122.42904466253599 | (37.7809557824451, -122.429044662536) | |||
177120 | 177120 | 187721 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 65 Whitney Young Cir | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6017221.17911 | 2094948.917 | 37.733296652317705 | -122.38282485627899 | (37.7332966523177, -122.382824856279) | |||
177089 | 177089 | 203247 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 435 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5995610.12397 | 2095259.68006 | 37.732932237139 | -122.457562233408 | (37.732932237139, -122.457562233408) | |||
176938 | 176938 | 66480 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 127 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1991 12:00:00 AM | 30 | Permit Number 29809 | 5994252.33765 | 2114707.89192 | 37.7862539074759 | -122.46366743555599 | (37.7862539074759, -122.463667435556) | ||
176928 | 176928 | 125187 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 5ft | 6001987.81775 | 2117744.14272 | 37.7950333598619 | -122.437122197348 | (37.7950333598619, -122.437122197348) | |||
176912 | 176912 | 186896 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985175.5072 | 2096596.8223 | 37.735998760061605 | -122.493735375196 | (37.7359987600616, -122.493735375196) | |||
176885 | 176885 | 184861 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984691.2095 | 2106834.308 | 37.7640797402699 | -122.496164839998 | (37.7640797402699, -122.496164839998) | |||
176814 | 176814 | 141595 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 15 ATALAYA TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5998812.2944 | 2110989.0674 | 37.7763046766786 | -122.447623435448 | (37.7763046766786, -122.447623435448) | |||
176755 | 176755 | 113087 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 494 36th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5984726.14635 | 2112591.8256599996 | 37.77989028792871 | -122.49646888365601 | (37.7798902879287, -122.496468883656) | |||
176730 | 176730 | 116786 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Locust St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 5997586.89652 | 2115706.15245 | 37.7891864427349 | -122.4522028424 | (37.7891864427349, -122.4522028424) | |||
176663 | 176663 | 175009 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 265 Hester Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6012301.72001 | 2087735.75637 | 37.7132177542762 | -122.399326699068 | (37.7132177542762, -122.399326699068) | ||||
176537 | 176537 | 220249 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 4380 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6001446.96552 | 2100591.1446700003 | 37.747904745917104 | -122.43776451384 | (37.7479047459171, -122.43776451384) | |||
176476 | 176476 | 124980 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3715 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999618.92595 | 2121303.95434 | 37.804672711733 | -122.44557499538799 | (37.804672711733, -122.445574995388) | |||
176445 | 176445 | 203795 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1987 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 4ft | 5993770.85444 | 2101945.8628 | 37.7511849916116 | -122.46440629632299 | (37.7511849916116, -122.464406296323) | |||
176347 | 176347 | 125277 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1285 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6006721.71386 | 2119753.35883 | 37.800818109519206 | -122.420884898228 | (37.8008181095192, -122.420884898228) | ||||
176241 | 176241 | 184888 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984676.0208 | 2106738.9985 | 37.7638171575071 | -122.496210339991 | (37.7638171575071, -122.496210339991) | |||
176234 | 176234 | 203790 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1992 09th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993499.03124 | 2101963.03013 | 37.7512164561752 | -122.46534752948999 | (37.7512164561752, -122.46534752949) | |||
176228 | 176228 | 220266 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 35 Kronquist Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6002254.212169999 | 2100124.56175 | 37.746669487525104 | -122.434939731599 | (37.7466694875251, -122.434939731599) | |||
176171 | 176171 | 203785 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2050 09th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 2ft | 5993499.774119999 | 2101557.36546 | 37.750102647629795 | -122.465315496537 | (37.7501026476298, -122.465315496537) | |||
176138 | 176138 | 124915 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 Presidio Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998988.26407 | 2115868.61122 | 37.789712689144395 | -122.44736600066099 | (37.7897126891444, -122.447366000661) | |||
176108 | 176108 | 182905 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2721 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5982744.7337 | 2096592.2081 | 37.7358435812589 | -122.502139054485 | (37.7358435812589, -122.502139054485) | |||
176106 | 176106 | 125227 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2300 Octavia St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 6004627.2188 | 2117121.15907 | 37.7934724812315 | -122.42794505924 | (37.7934724812315, -122.42794505924) | |||
176074 | 176074 | 188579 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1900 18th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6011941.53621 | 2105635.92971 | 37.7623477698519 | -122.401829104925 | (37.7623477698519, -122.401829104925) | |||
176044 | 176044 | 220145 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 450 Bosworth St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003154.048330001 | 2095235.16031 | 37.73329536808561 | -122.431479202413 | (37.7332953680856, -122.431479202413) | ||||
175905 | 175905 | 187726 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 76 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6016892.38136 | 2094959.59167 | 37.73330779132829 | -122.383962354797 | (37.7333077913283, -122.383962354797) | |||
175883 | 175883 | 99558 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1142 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6011559.265430001 | 2119272.68132 | 37.799769770721 | -122.404111004226 | (37.799769770721, -122.404111004226) | |||
175874 | 175874 | 125254 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008497.00299 | 2116907.63911 | 37.7931043734065 | -122.414540150606 | (37.7931043734065, -122.414540150606) | |||
175822 | 175822 | 139798 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1789 EDDY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6001985.3284 | 2112554.2689 | 37.7807831559155 | -122.43675911994801 | (37.7807831559155, -122.436759119948) | |||
175771 | 175771 | 181565 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984872.5636 | 2106101.5491 | 37.7620784109817 | -122.495483550979 | (37.7620784109817, -122.495483550979) | |||
175725 | 175725 | 125240 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 859 O'Farrell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6007211.93246 | 2113977.1973900003 | 37.78498582279121 | -122.418778660814 | (37.7849858227912, -122.418778660814) | |||
175642 | 175642 | 123435 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 730 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5995066.3169599995 | 2110586.06385 | 37.7749833386102 | -122.46055250842699 | (37.7749833386102, -122.460552508427) | |||
175605 | 175605 | 124859 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 55 Retiro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001743.08696 | 2121405.10216 | 37.8050714765314 | -122.438231392365 | (37.8050714765314, -122.438231392365) | |||
175550 | 175550 | 203249 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 380 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5995787.9894199995 | 2095468.33628 | 37.7335153719345 | -122.456962397309 | (37.7335153719345, -122.456962397309) |
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");