Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100426 | 100426 | 199 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1621X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5990403.2095800005 | 2114714.97277 | 37.7860508060194 | -122.476984794344 | (37.7860508060194, -122.476984794344) | |||
| 82334 | 82334 | 294 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3451X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 81565 | 81565 | 443 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700x 23rd Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988815.988030001 | 2110428.99683 | 37.774190512498706 | -122.482161976658 | (37.7741905124987, -122.482161976658) | ||||
| 83214 | 83214 | 448 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700x 23rd Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988818.05287 | 2110350.21953 | 37.773974331987795 | -122.482149061597 | (37.7739743319878, -122.482149061597) | ||||
| 11420 | 11420 | 745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2201X 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6 | 5985120.8379 | 2099719.0966 | 37.7445684872167 | -122.49415444151501 | (37.7445684872167, -122.494154441515) | |||
| 12421 | 12421 | 748 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2301X 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6 | 5985137.3758 | 2099321.1031 | 37.7434766724968 | -122.49406793054101 | (37.7434766724968, -122.494067930541) | |||
| 10993 | 10993 | 764 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.76418358274471 | -122.496433785178 | (37.7641835827447, -122.496433785178) | |||
| 11295 | 11295 | 773 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1500X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3 | 5984696.2443 | 2104420.7984 | 37.7574532129065 | -122.495969365063 | (37.7574532129065, -122.495969365063) | |||
| 12609 | 12609 | 774 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1500X 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3 | 5984689.126 | 2104618.0173 | 37.7579943042171 | -122.496008531807 | (37.7579943042171, -122.496008531807) | |||
| 115888 | 115888 | 775 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x10 | 5984704.195086701 | 2104278.9815788995 | 37.7570642890053 | -122.495931406805 | (37.7570642890053, -122.495931406805) | |||
| 10745 | 10745 | 776 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3 | 5984705.3515 | 2104090.9487 | 37.7565480706746 | -122.49591353675899 | (37.7565480706746, -122.495913536759) | |||
| 21467 | 21467 | 1367 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 33 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | Permit Number 776000 | 5999068.70954 | 2100015.2299099998 | 37.7461879050483 | -122.445946969396 | (37.7461879050483, -122.445946969396) | ||
| 17186 | 17186 | 1368 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 33 Amethyst Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | Permit Number 776000 | 5999092.87122 | 2100014.72745 | 37.746187905058896 | -122.445863385507 | (37.7461879050589, -122.445863385507) | ||
| 101797 | 101797 | 1506 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 345 Arguello Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5995528.42515 | 2113903.2607299997 | 37.7841180535654 | -122.45919424672701 | (37.7841180535654, -122.459194246727) | |||
| 21099 | 21099 | 1649 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1357X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6005247.73797 | 2100448.62508 | 37.7477288052344 | -122.424611464856 | (37.7477288052344, -122.424611464856) | |||
| 13683 | 13683 | 1710 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 5 Bass Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016578.92227 | 2095125.73941 | 37.73374666585679 | -122.385057651709 | (37.7337466658568, -122.385057651709) | |||
| 11153 | 11153 | 1849 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2401 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6011118.84502 | 2087065.06419 | 37.7113101708062 | -122.40336798796301 | (37.7113101708062, -122.403367987963) | |||
| 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) | |||
| 18902 | 18902 | 2171 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 980X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6001393.407000001 | 2109056.2142 | 37.771144720167705 | -122.43855614944799 | (37.7711447201677, -122.438556149448) | |||
| 23339 | 23339 | 2430 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 222X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6004865.54257 | 2109535.77801 | 37.7726583856046 | -122.42658005292499 | (37.7726583856046, -122.426580052925) | |||
| 79387 | 79387 | 3431 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 7050X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | |||
| 13841 | 13841 | 3685 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout 5 | Tree 1 | Port 9 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767871999 | (37.744924332395, -122.38470767872) | |||
| 118559 | 118559 | 3686 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
| 140153 | 140153 | 3687 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 128521 | 128521 | 3688 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 18 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 99473 | 99473 | 3689 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 127726 | 127726 | 3690 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 127580 | 127580 | 3691 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 104843 | 104843 | 3692 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6017817.275253 | 2098336.256691 | 37.742630528905295 | -122.380999383309 | (37.7426305289053, -122.380999383309) | |||
| 86341 | 86341 | 3693 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6017817.275253 | 2098336.256691 | 37.742630528905295 | -122.380999383309 | (37.7426305289053, -122.380999383309) | |||
| 82822 | 82822 | 3694 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6017199.673908999 | 2098835.752969 | 37.7439679357533 | -122.383169649574 | (37.7439679357533, -122.383169649574) | |||
| 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) | |||
| 77349 | 77349 | 3742 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 450X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6016957.733924 | 2099023.86587 | 37.74447108289971 | -122.38401932754 | (37.7444710828997, -122.38401932754) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 87721 | 87721 | 3827 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 130 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016793.8666003 | 2095959.0590849 | 37.736046682619 | -122.384372537421 | (37.736046682619, -122.384372537421) | |||
| 118531 | 118531 | 3830 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 160 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016559.291912099 | 2096123.3914367 | 37.7364849325959 | -122.38519501127199 | (37.7364849325959, -122.385195011272) | |||
| 91258 | 91258 | 3842 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 210X Cashmere St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6016102.822511401 | 2096206.9126158 | 37.7366890027211 | -122.386779056577 | (37.7366890027211, -122.386779056577) | |||
| 81922 | 81922 | 3865 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 220 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X4 | 6016069.3729239 | 2096169.6764515 | 37.7365849077155 | -122.386892111244 | (37.7365849077155, -122.386892111244) | |||
| 105936 | 105936 | 3866 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 220 Cashmere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6016069.3729239 | 2096169.6764515 | 37.7365849077155 | -122.386892111244 | (37.7365849077155, -122.386892111244) | |||
| 110095 | 110095 | 3868 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 280 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6015983.4965847 | 2095931.8290461998 | 37.7359270715178 | -122.387172440077 | (37.7359270715178, -122.387172440077) | |||
| 17350 | 17350 | 4171 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3795 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005278.26135 | 2100471.01085 | 37.7477919952017 | -122.42450750861099 | (37.7477919952017, -122.424507508611) | |||
| 58 | 58 | 4749 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1255 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 8 | 3X3 | 6007516.58505 | 2121541.63395 | 37.805773032263296 | -122.41826116482599 | (37.8057730322633, -122.418261164826) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 19070 | 19070 | 4884 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 639X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6005016.1788 | 2104614.4519599997 | 37.7591541153895 | -122.425708644037 | (37.7591541153895, -122.425708644037) | |||
| 18111 | 18111 | 4885 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 639X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 4X4 | 6005014.011 | 2104638.98178 | 37.7592213459953 | -122.42571788726299 | (37.7592213459953, -122.425717887263) | |||
| 23331 | 23331 | 5163 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 288 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6001824.579 | 2109378.5545 | 37.7720543041481 | -122.437087794368 | (37.7720543041481, -122.437087794368) | ||||
| 7320 | 7320 | 5190 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 518 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001706.5859 | 2110230.9953 | 37.7743881862019 | -122.43755699782899 | (37.7743881862019, -122.437556997829) | |||
| 6466 | 6466 | 5201 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 730 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x6 | 6001603.6657 | 2110963.249 | 37.7763929190422 | -122.43796547839199 | (37.7763929190422, -122.437965478392) | |||
| 4407 | 4407 | 5225 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1034 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001461.1836 | 2111997.0255 | 37.779223304768 | -122.43853244967698 | (37.779223304768, -122.438532449677) | |||
| 105809 | 105809 | 5234 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001436.83253 | 2112303.93811 | 37.78006462380971 | -122.438638687165 | (37.7800646238097, -122.438638687165) | |||
| 7634 | 7634 | 5240 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100 Divisadero St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001405.3119 | 2112421.3803 | 37.780385297097205 | -122.43875614904499 | (37.7803852970972, -122.438756149045) | |||
| 8047 | 8047 | 5281 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1350 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6001314.4457 | 2113067.2583 | 37.782153543884604 | -122.439116800935 | (37.7821535438846, -122.439116800935) | |||
| 5878 | 5878 | 5285 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1363 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001249.1303 | 2113085.1947 | 37.7821990759369 | -122.439344048338 | (37.7821990759369, -122.439344048338) | |||
| 5395 | 5395 | 5286 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1363 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001243.7155 | 2113125.1285 | 37.78230841581821 | -122.439365644426 | (37.7823084158182, -122.439365644426) | |||
| 8859 | 8859 | 5308 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1722 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6001127.4861 | 2114346.0125 | 37.785654035319396 | -122.439855308268 | (37.7856540353194, -122.439855308268) | |||
| 8611 | 8611 | 5309 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1736 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001119.1558 | 2114392.6005 | 37.7857814798006 | -122.439887470169 | (37.7857814798006, -122.439887470169) | |||
| 8236 | 8236 | 5312 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1750 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001109.2828 | 2114487.0108 | 37.7860401441829 | -122.43992839962799 | (37.7860401441829, -122.439928399628) | |||
| 8899 | 8899 | 5319 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1844 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001069.8732 | 2114771.5539 | 37.786819182767296 | -122.44008515695101 | (37.7868191827673, -122.440085156951) | |||
| 100701 | 100701 | 5321 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1861X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001005.43894 | 2114739.90905 | 37.7867286257608 | -122.440305813645 | (37.7867286257608, -122.440305813645) | |||
| 22010 | 22010 | 5354 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 214 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 6 | 6004794.21046 | 2107092.80643 | 37.7659465419134 | -122.426652801811 | (37.7659465419134, -122.426652801811) | |||
| 21269 | 21269 | 5395 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 347 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/2014 12:00:00 AM | 3 | 3x3 | 6004924.31069 | 2106310.22613 | 37.763805117627896 | -122.426147093211 | (37.7638051176279, -122.426147093211) | ||
| 18464 | 18464 | 5398 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 347 Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004916.74294 | 2106419.98328 | 37.7641060568743 | -122.426181082194 | (37.7641060568743, -122.426181082194) | |||
| 17176 | 17176 | 5399 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 347 Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6004915.02967 | 2106451.3331299997 | 37.764192039253004 | -122.426189239948 | (37.764192039253, -122.426189239948) | |||
| 10113 | 10113 | 5402 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 368 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 4X4 | 6004841.2181400005 | 2106223.26914 | 37.763561657659295 | -122.426428293246 | (37.7635616576593, -122.426428293246) | |||
| 17953 | 17953 | 5410 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X6 | 6004853.94973 | 2105972.8018799997 | 37.762874653875606 | -122.426366424394 | (37.7628746538756, -122.426366424394) | |||
| 97593 | 97593 | 5413 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 430X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 39 | 6 | 6004853.970832599 | 2105864.857711 | 37.7625782660478 | -122.42635866544599 | (37.7625782660478, -122.426358665446) | |||
| 127236 | 127236 | 5415 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 430X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 6 | 6004853.970832599 | 2105864.857711 | 37.7625782660478 | -122.42635866544599 | (37.7625782660478, -122.426358665446) | |||
| 102345 | 102345 | 5417 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 430X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/05/2013 12:00:00 AM | 24 | 6 | 6004853.970832599 | 2105864.857711 | 37.7625782660478 | -122.42635866544599 | (37.7625782660478, -122.426358665446) | ||
| 139842 | 139842 | 5418 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 430X Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 6 | 6004853.970832599 | 2105864.857711 | 37.7625782660478 | -122.42635866544599 | (37.7625782660478, -122.426358665446) | |||
| 84185 | 84185 | 5423 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 460X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004889.2026724005 | 2105697.5669461996 | 37.7621209168257 | -122.42622490044901 | (37.7621209168257, -122.426224900449) | |||
| 19363 | 19363 | 5428 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 465 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 4X4 | 6004960.54849 | 2105613.38762 | 37.7618938127809 | -122.425972149892 | (37.7618938127809, -122.425972149892) | |||
| 16932 | 16932 | 5429 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 465 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4X4 | 6004961.54975 | 2105631.51156 | 37.7619436334085 | -122.42596997713001 | (37.7619436334085, -122.42596997713) | |||
| 117968 | 117968 | 5435 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004896.4850004995 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | |||
| 105145 | 105145 | 5452 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 545 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 6X6 | 6004979.03792 | 2105185.23092 | 37.760719240803205 | -122.42587772411801 | (37.7607192408032, -122.425877724118) | |||
| 97092 | 97092 | 5467 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 600X Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||||
| 21846 | 21846 | 5476 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 635 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6005015.06111 | 2104677.01858 | 37.7593258454205 | -122.425716962778 | (37.7593258454205, -122.425716962778) | |||
| 17534 | 17534 | 5492 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 719 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 8 | 6005040.753830001 | 2104151.1903 | 37.7578834965409 | -122.425590680889 | (37.7578834965409, -122.425590680889) | |||
| 19346 | 19346 | 5493 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 719 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 8 | 6005041.71749 | 2104164.91103 | 37.7579212248917 | -122.425588324648 | (37.7579212248917, -122.425588324648) | |||
| 125605 | 125605 | 5498 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 751 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1995 12:00:00 AM | 24 | 5 | 6005034.157584201 | 2103994.6658118 | 37.7574533443492 | -122.42560235358201 | (37.7574533443492, -122.425602353582) | ||
| 19322 | 19322 | 5502 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 769 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 7x9 | 6005055.62871 | 2103865.722 | 37.7571005081006 | -122.42551892126998 | (37.7571005081006, -122.42551892127) | |||
| 21950 | 21950 | 5509 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 807 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 5X5 | 6005073.51013 | 2103628.5671599996 | 37.7564503468259 | -122.42544020362301 | (37.7564503468259, -122.425440203623) | |||
| 21468 | 21468 | 5532 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005017.6668300005 | 2103067.07529 | 37.7549054662318 | -122.42559336895599 | (37.7549054662318, -122.425593368956) | |||
| 18289 | 18289 | 5540 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900X Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005033.64005 | 2102782.9896400003 | 37.7541263358861 | -122.425517912248 | (37.7541263358861, -122.425517912248) | |||
| 19012 | 19012 | 5575 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1040 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6005061.37186 | 2102302.0381 | 37.752807321807 | -122.425387784834 | (37.752807321807, -122.425387784834) | |||
| 20767 | 20767 | 5601 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1120-1122 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/2016 12:00:00 AM | 3 | 6X6 | 6005089.20528 | 2101804.2581 | 37.7514421059774 | -122.425256113291 | (37.7514421059774, -122.425256113291) | ||
| 18513 | 18513 | 5608 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1148 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005093.57807 | 2101711.52687 | 37.7511877345454 | -122.425234393764 | (37.7511877345454, -122.425234393764) | |||
| 17430 | 17430 | 5647 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005148.44163 | 2100733.93457 | 37.7485065911205 | -122.42497512280899 | (37.7485065911205, -122.424975122809) |
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");