Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 105405 | 105405 | 98743 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 155 Masonic Ave | 5 | Sidewalk: Property side : 26 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5998843.8 | 2112455.0 | 37.7803315496091 | -122.447619999218 | (37.7803315496091, -122.447619999218) | ||||
| 73756 | 73756 | 188569 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 24th St | 26 | : Yard 23 | Tree 1 | Private 1 | 5 | 6017110.36972 | 2102585.1726599997 | 37.754258135118796 | -122.383739444343 | (37.7542581351188, -122.383739444343) | ||||
| 98922 | 98922 | 188568 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 24th St | 24 | : Yard 23 | Tree 1 | Private 1 | 38 | 6017120.705080001 | 2102612.3766799998 | 37.7543334029878 | -122.38370559563499 | (37.7543334029878, -122.383705595635) | ||||
| 32088 | 32088 | 186539 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984748.3754 | 2104879.0915 | 37.7587146113666 | -122.49582288356001 | (37.7587146113666, -122.49582288356) | |||
| 41370 | 41370 | 186537 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 14 | Width 0ft | 5984743.3507 | 2104891.2345 | 37.7587476583889 | -122.49584115676501 | (37.7587476583889, -122.495841156765) | |||
| 51500 | 51500 | 185486 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Sunset Blvd | 39 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985131.6978 | 2098522.3598 | 37.7412832067047 | -122.494028708144 | (37.7412832067047, -122.494028708144) | |||
| 55634 | 55634 | 185460 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Sunset Blvd | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985122.4012 | 2098351.0376 | 37.7408122581003 | -122.49404822844801 | (37.7408122581003, -122.494048228448) | |||
| 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) | |||
| 150157 | 150157 | 186541 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5984745.863 | 2104876.5792 | 37.7587075661518 | -122.49583138713601 | (37.7587075661518, -122.495831387136) | |||
| 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) | |||
| 164141 | 164141 | 185483 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Sunset Blvd | 36 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985132.3618 | 2098506.4228 | 37.741239486847206 | -122.494025238023 | (37.7412394868472, -122.494025238023) | |||
| 23489 | 23489 | 247849 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 152 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6009118.007540001 | 2098230.0964599997 | 37.74185503078979 | -122.41107154552401 | (37.7418550307898, -122.411071545524) | ||||
| 25663 | 25663 | 188593 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010961.38996 | 2104652.9831 | 37.759594070921004 | -122.40514986509899 | (37.759594070921, -122.405149865099) | ||||
| 31230 | 31230 | 187779 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Middle Point Rd | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 6ft | 6018271.33931 | 2096490.0449 | 37.737586251210104 | -122.379301134458 | (37.7375862512101, -122.379301134458) | |||
| 44107 | 44107 | 188705 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1998 Revere Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6013030.362000001 | 2095929.4873 | 37.7357566623473 | -122.397382506903 | (37.7357566623473, -122.397382506903) | ||||
| 49102 | 49102 | 248109 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 138 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010416.26244 | 2099462.28287 | 37.7453110660681 | -122.406669396477 | (37.7453110660681, -122.406669396477) | ||||
| 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) | ||||
| 56158 | 56158 | 247931 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1099 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010377.81236 | 2098773.8118 | 37.7434185228518 | -122.406753840137 | (37.7434185228518, -122.406753840137) | ||||
| 65626 | 65626 | 247850 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 152 Chapman St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 42 | 6009080.756440001 | 2098231.91815 | 37.7418579436943 | -122.41120047681801 | (37.7418579436943, -122.411200476818) | ||||
| 66596 | 66596 | 248070 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 20 Rutledge St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6010599.59932 | 2099402.0661 | 37.745155979779504 | -122.406031203374 | (37.7451559797795, -122.406031203374) | ||||
| 69221 | 69221 | 247529 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000073.75314 | 2108487.72588 | 37.7695086378454 | -122.44308003233499 | (37.7695086378454, -122.443080032335) | ||||
| 130643 | 130643 | 247527 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000059.53834 | 2108484.86365 | 37.769499968379705 | -122.443128995021 | (37.7694999683797, -122.443128995021) | ||||
| 132984 | 132984 | 175066 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 Thornton Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010981.076169999 | 2094029.55145 | 37.73042552801979 | -122.40433403878599 | (37.7304255280198, -122.404334038786) | ||||
| 133560 | 133560 | 247858 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 82 Bradford St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6009570.7437 | 2098077.6511 | 37.7414618274161 | -122.40949536852501 | (37.7414618274161, -122.409495368525) | ||||
| 156377 | 156377 | 247522 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6000010.6242 | 2108472.60358 | 37.7694635161602 | -122.443297305835 | (37.7694635161602, -122.443297305835) | ||||
| 159551 | 159551 | 247520 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6000003.99995 | 2108482.26842 | 37.7694896756401 | -122.443320913055 | (37.7694896756401, -122.443320913055) | ||||
| 165964 | 165964 | 175067 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 Thornton Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 6010979.40226 | 2094033.66945 | 37.730436741644894 | -122.404340115499 | (37.7304367416449, -122.404340115499) | ||||
| 172072 | 172072 | 187778 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Middle Point Rd | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 6ft | 6018276.18855 | 2096495.79876 | 37.7376023175876 | -122.37928476769899 | (37.7376023175876, -122.379284767699) | |||
| 172088 | 172088 | 125288 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 943 Green St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6008674.79926 | 2118995.08989 | 37.7988459853112 | -122.41407270821101 | (37.7988459853112, -122.414072708211) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 181546 | 181546 | 125276 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1285 Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6006714.64641 | 2119759.73621 | 37.800835221824 | -122.420909807645 | (37.800835221824, -122.420909807645) | ||||
| 182693 | 182693 | 187780 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Middle Point Rd | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 6ft | 6018250.04699 | 2096453.9006400001 | 37.7374858320104 | -122.379372242948 | (37.7374858320104, -122.379372242948) | |||
| 185208 | 185208 | 247934 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1099 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6010311.02519 | 2098743.98721 | 37.7433328939103 | -122.406982672633 | (37.7433328939103, -122.406982672633) | ||||
| 100593 | 100593 | 115407 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 46 PROSPECT AVE | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 14 | 3x3 | 6007068.0 | 2099193.0 | 37.7443837739696 | -122.41822807190901 | (37.7443837739696, -122.418228071909) | |||
| 99604 | 99604 | 106503 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3974 22nd St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | Permit Number 773286 | 6002049.0 | 2102947.0 | 37.754407578182004 | -122.435851245675 | (37.754407578182, -122.435851245675) | ||||
| 106187 | 106187 | 106504 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3974 22nd St | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | Permit Number 773286 | 6002049.0 | 2102947.0 | 37.754407578182004 | -122.435851245675 | (37.754407578182, -122.435851245675) | ||||
| 107113 | 107113 | 106505 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3975 22nd St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | Permit Number 773291 | 6002049.0 | 2102913.0 | 37.7543142223274 | -122.435848813122 | (37.7543142223274, -122.435848813122) | ||||
| 128960 | 128960 | 106506 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3975 22nd St | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | Permit Number 773291 | 6002049.0 | 2102913.0 | 37.7543142223274 | -122.435848813122 | (37.7543142223274, -122.435848813122) | ||||
| 30471 | 30471 | 188564 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Vermont St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | 6011131.87643 | 2106822.77201 | 37.7655613532939 | -122.404712987912 | (37.7655613532939, -122.404712987912) | ||||
| 34603 | 34603 | 249714 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 5999388.9274 | 2116973.5904200003 | 37.7927695576174 | -122.446059261445 | (37.7927695576174, -122.446059261445) | ||||
| 35242 | 35242 | 249713 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 5999382.51554 | 2116973.87968 | 37.792769985700296 | -122.446081467494 | (37.7927699857003, -122.446081467494) | ||||
| 35303 | 35303 | 249715 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 5999395.51836 | 2116974.38878 | 37.7927721260745 | -122.44603651397 | (37.7927721260745, -122.44603651397) | ||||
| 133552 | 133552 | 249874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | Width 0ft | 6011664.0982800005 | 2120483.35155 | 37.803099833442296 | -122.403833479743 | (37.8030998334423, -122.403833479743) | |||
| 155707 | 155707 | 203875 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992168.26739 | 2088231.33888 | 37.7134358290799 | -122.468950218092 | (37.7134358290799, -122.468950218092) | ||||
| 157520 | 157520 | 203877 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Ralston St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992177.10886 | 2088222.03993 | 37.7134108072361 | -122.468918982843 | (37.7134108072361, -122.468918982843) | ||||
| 160942 | 160942 | 249712 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | 5999372.04623 | 2116967.23886 | 37.792751153907204 | -122.44611721373998 | (37.7927511539072, -122.44611721374) | ||||
| 161892 | 161892 | 203876 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 5992169.18145 | 2088225.46502 | 37.7134197536892 | -122.468946631609 | (37.7134197536892, -122.468946631609) | ||||
| 188029 | 188029 | 249872 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Greenwich St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011683.12279 | 2120489.80597 | 37.8031186185004 | -122.403768099014 | (37.8031186185004, -122.403768099014) | |||
| 90127 | 90127 | 89023 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Hollywood Ct | 1 | unknown : Cutout 12 | Tree 1 | DPW 2 | 6000329.0 | 2088600.0 | 37.714916215224 | -122.440770357879 | (37.714916215224, -122.440770357879) | |||||
| 6171 | 6171 | 8616 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2600 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999337.0471 | 2113224.2861 | 37.78247198716561 | -122.44596898090299 | (37.7824719871656, -122.445968980903) | |||
| 6495 | 6495 | 26421 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2235X Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 6004624.1328 | 2116974.76242 | 37.793070338586205 | -122.427945300259 | (37.7930703385862, -122.427945300259) | |||
| 8054 | 8054 | 14425 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 90X Masonic Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 12 | 5998875.1013 | 2112962.0092 | 37.781725454134396 | -122.447548220181 | (37.7817254541344, -122.447548220181) | |||
| 9882 | 9882 | 173729 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
| 9888 | 9888 | 173719 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 922 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3x3 | 6012422.0 | 2103621.0 | 37.7568420188621 | -122.40002584196199 | (37.7568420188621, -122.400025841962) | |||
| 9889 | 9889 | 3743 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 906 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 18 | 6012418.0 | 2103694.0 | 37.757042237838796 | -122.400044801952 | (37.7570422378388, -122.400044801952) | |||
| 9898 | 9898 | 3765 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1074 Carolina St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 18 | 6012456.6037355 | 2102966.9856684 | 37.7550481677782 | -122.39986024500799 | (37.7550481677782, -122.399860245008) | |||
| 9903 | 9903 | 3758 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1056 Carolina St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 18 | 6012452.0863519 | 2103047.5184298 | 37.7552690413169 | -122.399881522302 | (37.7552690413169, -122.399881522302) | |||
| 9906 | 9906 | 173728 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
| 9908 | 9908 | 3768 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1098 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.39983195341699 | (37.754754478768, -122.399831953417) | |||
| 10951 | 10951 | 24278 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350X Winding Way | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000808.42529 | 2086790.5767400002 | 37.709975233345 | -122.438983668972 | (37.709975233345, -122.438983668972) | |||
| 12225 | 12225 | 24277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350X Winding Way | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000814.16949 | 2086790.4577099998 | 37.709975233345496 | -122.43896380743999 | (37.7099752333455, -122.43896380744) | |||
| 13612 | 13612 | 3695 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6017120.58643 | 2098873.01635 | 37.7440658827378 | -122.383445712243 | (37.7440658827378, -122.383445712243) | |||
| 13675 | 13675 | 18550 | Landmark tree 9 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700X Quesada Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014656.2717 | 2095062.2920900001 | 37.733465912826 | -122.391700443637 | (37.733465912826, -122.391700443637) | |||
| 13955 | 13955 | 97226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016643.51258 | 2094941.1276900002 | 37.7332433315076 | -122.38482148523899 | (37.7332433315076, -122.384821485239) | ||
| 15352 | 15352 | 97230 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 15x200 | 6016626.81073 | 2094919.21722 | 37.7331822459561 | -122.38487770274999 | (37.7331822459561, -122.38487770275) | |||
| 15525 | 15525 | 3745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900 Carolina St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 18 | 6012461.71984 | 2103674.63492 | 37.7569915030708 | -122.39989224135799 | (37.7569915030708, -122.399892241358) | |||
| 15842 | 15842 | 97227 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 15x200 | 6016638.64484 | 2094938.128 | 37.733234825728296 | -122.384838105605 | (37.7332348257283, -122.384838105605) | |||
| 16107 | 16107 | 97223 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016661.55982 | 2094959.63165 | 37.733295137843 | -122.384760378985 | (37.733295137843, -122.384760378985) | ||
| 16240 | 16240 | 97228 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 15x200 | 6016642.6726 | 2094934.5266099998 | 37.733225159799204 | -122.384823929606 | (37.7332251597992, -122.384823929606) | |||
| 16402 | 16402 | 97222 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15x200 | 6016676.72369 | 2094975.37763 | 37.733339211818105 | -122.38470904929702 | (37.7333392118181, -122.384709049297) | |||
| 16543 | 16543 | 15277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1563X Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777705 | 6007250.560819999 | 2109703.40074 | 37.7732531819334 | -122.418341887077 | (37.7732531819334, -122.418341887077) | |
| 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) | ||
| 20854 | 20854 | 11187 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Idora Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5995309.2253 | 2099420.08132 | 37.7443383854121 | -122.458903627104 | (37.7443383854121, -122.458903627104) | |||
| 21068 | 21068 | 29972 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991341.172 | 2093706.68724 | 37.7284219643784 | -122.47220779725299 | (37.7284219643784, -122.472207797253) | ||
| 21937 | 21937 | 29584 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 3 | 3X3 | 5991345.88941 | 2093701.3780900002 | 37.728407659786 | -122.47219110225299 | (37.728407659786, -122.472191102253) | ||
| 23028 | 23028 | 97224 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 6 | 15x200 | 6016653.042219999 | 2094950.9325 | 37.733270780626995 | -122.38478922115499 | (37.733270780627, -122.384789221155) | ||
| 23851 | 23851 | 200603 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 52 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6016419.7448 | 2095144.9307 | 37.733790555057 | -122.38560931762301 | (37.733790555057, -122.385609317623) | |||
| 34139 | 34139 | 200562 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016315.2256 | 2095489.7997 | 37.73473171245129 | -122.385994706933 | (37.7347317124513, -122.385994706933) | |||
| 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) | |||
| 38412 | 38412 | 200551 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6016216.4893 | 2095621.6927 | 37.735088399287 | -122.38634526793001 | (37.735088399287, -122.38634526793) | |||
| 38644 | 38644 | 200553 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016224.312999999 | 2095613.1578 | 37.7350653972301 | -122.38631762348301 | (37.7350653972301, -122.386317623483) | |||
| 42056 | 42056 | 200548 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016205.9984 | 2095634.3174 | 37.7351224834655 | -122.38638241900699 | (37.7351224834655, -122.386382419007) | |||
| 42146 | 42146 | 220273 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500x 27th St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 4ft | 6002878.6956 | 2100066.19718 | 37.746544669703106 | -122.432776165093 | (37.7465446697031, -122.432776165093) | |||
| 42702 | 42702 | 200540 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6016179.8101 | 2095650.1621 | 37.7351645401576 | -122.38647406665501 | (37.7351645401576, -122.386474066655) | |||
| 44175 | 44175 | 99145 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 302X Pacheco St | 29 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 46940 | 46940 | 200568 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 40 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016324.0126 | 2095472.2809 | 37.7346840956345 | -122.385963106208 | (37.7346840956345, -122.385963106208) | |||
| 49094 | 49094 | 200518 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6016087.5147 | 2095748.7503 | 37.7354301338826 | -122.386800041299 | (37.7354301338826, -122.386800041299) | |||
| 49943 | 49943 | 200538 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016175.1953 | 2095654.7768 | 37.7351769557335 | -122.38649034349899 | (37.7351769557335, -122.386490343499) | |||
| 51216 | 51216 | 200556 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016262.7203 | 2095558.3918 | 37.734917146653 | -122.38618101771601 | (37.734917146653, -122.386181017716) | |||
| 54812 | 54812 | 175058 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1132x Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003548.97454 | 2094354.07012 | 37.7308984688672 | -122.430051002559 | (37.7308984688672, -122.430051002559) | |||
| 55316 | 55316 | 200609 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 49 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016412.3996 | 2095168.4353 | 37.7338546875634 | -122.385636349995 | (37.7338546875634, -122.385636349995) | |||
| 55546 | 55546 | 200544 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6016191.0622 | 2095640.0073 | 37.73513727999379 | -122.38643445590401 | (37.7351372799938, -122.386434455904) | |||
| 58892 | 58892 | 200537 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6016177.7125 | 2095662.3283 | 37.735197829979 | -122.38648216691001 | (37.735197829979, -122.38648216691) | |||
| 59915 | 59915 | 200610 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 50 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016417.2964 | 2095161.5798 | 37.733836134681795 | -122.385618942498 | (37.7338361346818, -122.385618942498) | |||
| 62523 | 62523 | 220272 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500x 27th St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 4ft | 6002834.52979 | 2100065.9287400004 | 37.7465414276535 | -122.432928866369 | (37.7465414276535, -122.432928866369) | |||
| 62628 | 62628 | 200574 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016364.4111 | 2095326.6015 | 37.734286324847005 | -122.385813282871 | (37.734286324847, -122.385813282871) | |||
| 63458 | 63458 | 220274 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500x 27th St | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 4ft | 6002921.47786 | 2100071.21628 | 37.7465608772933 | -122.43262858725299 | (37.7465608772933, -122.432628587253) | |||
| 69094 | 69094 | 200554 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 0ft | 6016223.9574 | 2095601.7778 | 37.7350341303539 | -122.386318059776 | (37.7350341303539, -122.386318059776) |
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");