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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 62217 | 62217 | 250619 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987113.722030001 | 2115192.60557 | 37.7871708695801 | -122.48840049988002 | (37.7871708695801, -122.48840049988) | |||
| 62411 | 62411 | 176924 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 525 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002840.55904 | 2090695.62 | 37.720813038882206 | -122.43223893347799 | (37.7208130388822, -122.432238933478) | |||
| 62582 | 62582 | 207087 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1400 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991668.56365 | 2098444.306 | 37.7414492117217 | -122.471421062245 | (37.7414492117217, -122.471421062245) | |||
| 62772 | 62772 | 185051 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2715 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983667.0512 | 2096660.9577 | 37.736086492552 | -122.49895536756901 | (37.736086492552, -122.498955367569) | |||
| 62932 | 62932 | 108753 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200x Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012766.4768 | 2087726.3545799998 | 37.713217830719294 | -122.397719670851 | (37.7132178307193, -122.397719670851) | |||
| 63792 | 63792 | 64471 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2332 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 4 | Permit Number 25341 | 6003518.39121 | 2116605.0137 | 37.7919924858215 | -122.431744816269 | (37.7919924858215, -122.431744816269) | ||
| 64265 | 64265 | 129441 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6010109.81427 | 2114257.21673 | 37.7859174259901 | -122.40877263106199 | (37.7859174259901, -122.408772631062) | |||
| 64660 | 64660 | 176932 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 56 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012552.9526 | 2087748.4178 | 37.7132665190974 | -122.39845923552299 | (37.7132665190974, -122.398459235523) | |||
| 65837 | 65837 | 124124 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 61 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5996360.44357 | 2112557.14678 | 37.7804697796635 | -122.45621841836599 | (37.7804697796635, -122.456218418366) | |||
| 65976 | 65976 | 129416 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 218 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999044.58564 | 2115840.24858 | 37.789638031029206 | -122.44716909230301 | (37.7896380310292, -122.447169092303) | |||
| 66909 | 66909 | 129449 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 884 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008727.37725 | 2119383.41122 | 37.799915172210206 | -122.41391825502899 | (37.7999151722102, -122.413918255029) | |||
| 67146 | 67146 | 105243 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 616 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2014 12:00:00 AM | 2 | 3x3 | Permit Number 770335 | 6007163.0512 | 2091665.3874599999 | 37.723719949895 | -122.417366048922 | (37.723719949895, -122.417366048922) | |
| 67213 | 67213 | 51275 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 744 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 3 | Permit Number 47650 | 5990394.326 | 2110291.56377 | 37.7739048349937 | -122.476692239116 | (37.7739048349937, -122.476692239116) | |
| 67225 | 67225 | 247478 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 309 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002704.2967 | 2109689.8401 | 37.772958982719494 | -122.43406704066099 | (37.7729589827195, -122.434067040661) | |||
| 67551 | 67551 | 191285 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014337.49405 | 2110565.62241 | 37.776017035092 | -122.39388740780001 | (37.776017035092, -122.3938874078) | |||
| 67555 | 67555 | 89658 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2849X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5989742.13076 | 2111923.12979 | 37.7783468130036 | -122.479067633531 | (37.7783468130036, -122.479067633531) | ||
| 68229 | 68229 | 101282 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2001 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5989468.7375 | 2106475.7724 | 37.7633739839128 | -122.479614718585 | (37.7633739839128, -122.479614718585) | |||
| 69047 | 69047 | 227628 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4222 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6001065.76771 | 2102912.44614 | 37.754256799634796 | -122.43924903191002 | (37.7542567996348, -122.43924903191) | |||
| 69112 | 69112 | 187585 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 748 University St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6008708.47344 | 2090752.4419999998 | 37.7213000235466 | -122.411959282496 | (37.7213000235466, -122.411959282496) | ||||
| 69127 | 69127 | 191321 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015124.1638400005 | 2108316.2837099996 | 37.769884536484206 | -122.391008838006 | (37.7698845364842, -122.391008838006) | |||
| 69520 | 69520 | 176931 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 68 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012597.15839 | 2087748.03583 | 37.713267932833794 | -122.398306417307 | (37.7132679328338, -122.398306417307) | |||
| 69654 | 69654 | 227617 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6009080.60999 | 2097991.13845 | 37.7411968070922 | -122.411183978775 | (37.7411968070922, -122.411183978775) | |||
| 69772 | 69772 | 207085 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2091 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993168.90781 | 2101284.1521799997 | 37.749333387335895 | -122.466439786693 | (37.7493333873359, -122.466439786693) | |||
| 70158 | 70158 | 98192 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1020 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6008091.62981 | 2118948.72517 | 37.7986859077751 | -122.41608738562799 | (37.7986859077751, -122.416087385628) | |||
| 70505 | 70505 | 227648 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 154 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999992.54639 | 2104934.00184 | 37.7597463657249 | -122.443105663906 | (37.7597463657249, -122.443105663906) | |||
| 70657 | 70657 | 129393 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3700 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5997126.155040001 | 2115061.06795 | 37.7873888086001 | -122.45375034092 | (37.7873888086001, -122.45375034092) | |||
| 71664 | 71664 | 227629 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 62 Natick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003056.07384 | 2095532.6693400003 | 37.7341067067448 | -122.431839162348 | (37.7341067067448, -122.431839162348) | |||
| 72449 | 72449 | 227655 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003762.03013 | 2108315.13286 | 37.769244345078704 | -122.430310116133 | (37.7692443450787, -122.430310116133) | |||
| 72581 | 72581 | 89663 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2827 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5989854.97314 | 2111927.2213 | 37.7783645996222 | -122.47867757338301 | (37.7783645996222, -122.478677573383) | ||
| 73208 | 73208 | 49756 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1171 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 1 | Permit Number 46552 | 6011373.3818 | 2089351.75942 | 37.71760318852571 | -122.40264894398899 | (37.7176031885257, -122.402648943989) | |
| 73740 | 73740 | 200018 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1008 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6018250.1161 | 2092086.6599 | 37.7254942451327 | -122.37906877917801 | (37.7254942451327, -122.379068779178) | |||
| 74170 | 74170 | 129446 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1329 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008344.2402 | 2117236.00141 | 37.7939973921104 | -122.415091973713 | (37.7939973921104, -122.415091973713) | |||
| 74708 | 74708 | 129392 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 31 Casa Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001624.74168 | 2121508.73342 | 37.80534928880979 | -122.438648369353 | (37.8053492888098, -122.438648369353) | |||
| 75243 | 75243 | 129405 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3545 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000706.97602 | 2120551.39476 | 37.8026684412687 | -122.44175565829399 | (37.8026684412687, -122.441755658294) | |||
| 75435 | 75435 | 176937 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 18 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012312.20962 | 2087899.37244 | 37.7136675960583 | -122.399301921852 | (37.7136675960583, -122.399301921852) | |||
| 75814 | 75814 | 191355 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015114.26665 | 2107471.16871 | 37.7675634870034 | -122.39098399692699 | (37.7675634870034, -122.390983996927) | |||
| 76698 | 76698 | 227631 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 75 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997896.0946 | 2104612.71078 | 37.758744422037395 | -122.450333060142 | (37.7587444220374, -122.450333060142) | |||
| 76720 | 76720 | 129452 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007720.96455 | 2120575.51523 | 37.803131816931206 | -122.41748536375799 | (37.8031318169312, -122.417485363758) | |||
| 77131 | 77131 | 54664 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 360 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 1 | Permit Number 10488 | 6012252.975769999 | 2086866.6648099998 | 37.710828684568206 | -122.399434200424 | (37.7108286845682, -122.399434200424) | ||
| 77532 | 77532 | 4538 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Cleary Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | |||
| 78213 | 78213 | 37034 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 266 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48449 | 6004870.65820445 | 2098448.14678483 | 37.7422146471398 | -122.42577301954901 | (37.7422146471398, -122.425773019549) | ||
| 78569 | 78569 | 89433 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2750X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990101.1887300005 | 2111991.79472 | 37.7785561929756 | -122.477830552774 | (37.7785561929756, -122.477830552774) | ||
| 78926 | 78926 | 112621 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 226x HESTER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012667.0 | 2087636.0 | 37.712964194877294 | -122.398057164184 | (37.7129641948773, -122.398057164184) | ||||
| 79152 | 79152 | 89072 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 578 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990352.95655 | 2111441.21881 | 37.7770590720957 | -122.47691936106001 | (37.7770590720957, -122.47691936106) | ||
| 79857 | 79857 | 89670 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2643 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990382.48871 | 2111946.2204400003 | 37.778447380347096 | -122.476854108344 | (37.7784473803471, -122.476854108344) | ||
| 80995 | 80995 | 81638 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 611 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52388 | 6011631.16657043 | 2091602.57917757 | 37.7237978701092 | -122.40191602971301 | (37.7237978701092, -122.401916029713) | ||
| 81167 | 81167 | 89071 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 606 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990364.94891 | 2111219.79426 | 37.776451796946795 | -122.476861693703 | (37.7764517969468, -122.476861693703) | ||
| 81513 | 81513 | 102256 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1933 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 58594 | 6000840.6 | 2115080.7 | 37.787654962994104 | -122.440900572101 | (37.7876549629941, -122.440900572101) | |
| 81655 | 81655 | 89431 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2650 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990408.549930001 | 2112000.5588 | 37.7785980902022 | -122.476767924851 | (37.7785980902022, -122.476767924851) | ||
| 82382 | 82382 | 89086 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 406 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990312.19916 | 2112568.90758 | 37.780153029212705 | -122.47714277925199 | (37.7801530292127, -122.477142779252) | ||
| 83118 | 83118 | 38678 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1377 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/02/1998 12:00:00 AM | Permit Number 40596 | 6001182.75800309 | 2111056.33200795 | 37.776624556634495 | -122.439428187036 | (37.7766245566345, -122.439428187036) | ||
| 83557 | 83557 | 89117 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 727 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5990344.4993 | 2110412.80162 | 37.774234830642705 | -122.476873456227 | (37.7742348306427, -122.476873456227) | ||
| 83785 | 83785 | 89426 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2550X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990714.583219999 | 2112013.9673599997 | 37.7786526533285 | -122.475710228678 | (37.7786526533285, -122.475710228678) | ||
| 83916 | 83916 | 89107 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990326.6354 | 2110892.4923 | 37.775550893244294 | -122.47697030809401 | (37.7755508932443, -122.476970308094) | ||
| 84911 | 84911 | 89061 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990394.60611 | 2110329.10213 | 37.7740079212926 | -122.476694013266 | (37.7740079212926, -122.476694013266) | ||
| 85766 | 85766 | 89095 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 547 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990300.3364699995 | 2111641.2158 | 37.7776051560139 | -122.477116006748 | (37.7776051560139, -122.477116006748) | ||
| 86108 | 86108 | 89056 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 774 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990401.329059999 | 2110113.1437 | 37.7734153485371 | -122.476654976983 | (37.7734153485371, -122.476654976983) | ||
| 87075 | 87075 | 52479 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 119POWHATTAN Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48589 | 6009084.88956475 | 2097947.60140706 | 37.7410775038925 | -122.411166106845 | (37.7410775038925, -122.411166106845) | ||
| 87859 | 87859 | 89093 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501X 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990291.48047 | 2111913.4147099997 | 37.7783520252361 | -122.477166538778 | (37.7783520252361, -122.477166538778) | ||
| 88005 | 88005 | 30508 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 363 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | Permit Number 40123 | 6009708.62861324 | 2092740.2698514 | 37.72681424554771 | -122.40864217293199 | (37.7268142455477, -122.408642172932) | ||
| 88920 | 88920 | 89419 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2300X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991532.05809 | 2112041.47431 | 37.778775538782796 | -122.472884301267 | (37.7787755387828, -122.472884301267) | ||
| 88935 | 88935 | 89118 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 767 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990353.59701 | 2110151.97769 | 37.7735192073496 | -122.47682292511001 | (37.7735192073496, -122.47682292511) | ||
| 89224 | 89224 | 89437 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2840 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5989793.92088 | 2111979.6154 | 37.7785049142916 | -122.47889260671002 | (37.7785049142916, -122.47889260671) | ||
| 89255 | 89255 | 89080 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 498X 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990331.33174 | 2112032.1373799997 | 37.7786803168555 | -122.477037357467 | (37.7786803168555, -122.477037357467) | ||
| 90993 | 90993 | 108995 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772985 | 5993924.20809 | 2115202.12337 | 37.787592019403704 | -122.46483857455401 | (37.7875920194037, -122.464838574554) |
| 91083 | 91083 | 89110 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 675 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990329.58522 | 2110790.11902 | 37.7752699754793 | -122.476952622071 | (37.7752699754793, -122.476952622071) | ||
| 91285 | 91285 | 89428 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2600X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990570.85 | 2112008.13119 | 37.778628294884896 | -122.47620702578001 | (37.7786282948849, -122.47620702578) | ||
| 91731 | 91731 | 83341 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 422-24 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50786 | 6002931.20131858 | 2105783.16408091 | 37.762245079378 | -122.433002986091 | (37.762245079378, -122.433002986091) | ||
| 92272 | 92272 | 89085 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 410 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990312.707669999 | 2112537.21644 | 37.78006604363139 | -122.477138703582 | (37.7800660436314, -122.477138703582) | ||
| 92389 | 92389 | 102561 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 92892 | 92892 | 89436 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2832 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5989812.97644 | 2111980.65198 | 37.7785088669528 | -122.47882676286501 | (37.7785088669528, -122.478826762865) | ||
| 93936 | 93936 | 32892 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1235 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778801 | 5993897.25914467 | 2107077.09548698 | 37.7652813146396 | -122.464341682773 | (37.7652813146396, -122.464341682773) |
| 94418 | 94418 | 112623 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 228 HESTER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 6012539.0 | 2087662.0 | 37.7130284556779 | -122.398501400627 | (37.7130284556779, -122.398501400627) | ||||
| 94438 | 94438 | 41525 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1034 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42065 | 6018447.62591186 | 2095068.89236301 | 37.733693765900604 | -122.37859297315 | (37.7336937659006, -122.37859297315) | |||
| 94707 | 94707 | 94202 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008232.0 | 2118962.0 | 37.798730248485896 | -122.415602598872 | (37.7987302484859, -122.415602598872) | |
| 95620 | 95620 | 89692 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2337 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5991391.91305 | 2111981.89017 | 37.7786038228381 | -122.47336476609101 | (37.7786038228381, -122.473364766091) | ||
| 95689 | 95689 | 16894 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 361 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2008 12:00:00 AM | 3 | 3X3 | 6005282.37962 | 2110221.51905 | 37.7745648206797 | -122.42518697132401 | (37.7745648206797, -122.425186971324) | ||
| 95709 | 95709 | 98492 | Significant Tree 6 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Laguna St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004211.7 | 2116183.0 | 37.7908730187591 | -122.429315856087 | (37.7908730187591, -122.429315856087) | |||||
| 95736 | 95736 | 31792 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35262 | 6001241.81019665 | 2108627.72464151 | 37.7699595699392 | -122.439049813001 | (37.7699595699392, -122.439049813001) | ||
| 95924 | 95924 | 89438 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2936 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 5989471.29839 | 2111967.48674 | 37.778452873034894 | -122.480007779772 | (37.7784528730349, -122.480007779772) | ||
| 97690 | 97690 | 48988 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2002 12:00:00 AM | Permit Number 46175 | 6005014.67029629 | 2099626.41666977 | 37.7454580443014 | -122.42535889959998 | (37.7454580443014, -122.4253588996) | ||
| 99099 | 99099 | 89084 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 430 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990316.3630800005 | 2112431.39135 | 37.7797756893394 | -122.477118322615 | (37.7797756893394, -122.477118322615) | ||
| 99532 | 99532 | 89079 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 522 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 2 | 3x3 | 5990340.26635 | 2111799.54514 | 37.7780422011609 | -122.476989449392 | (37.7780422011609, -122.476989449392) | ||
| 99776 | 99776 | 65445 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 922 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1989 12:00:00 AM | Permit Number 28319 | 6007730.56095344 | 2114797.09154755 | 37.7872662397984 | -122.417042480837 | (37.7872662397984, -122.417042480837) | ||
| 100350 | 100350 | 89662 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2835 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5989829.3800099995 | 2111924.6433900003 | 37.778356035382295 | -122.478765919993 | (37.7783560353823, -122.478765919993) | ||
| 100674 | 100674 | 98153 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 466 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | Permit Number 768787 | 5991293.7 | 2112258.0 | 37.7793562570144 | -122.473724666839 | (37.7793562570144, -122.473724666839) | |||
| 100752 | 100752 | 89096 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 551 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990302.22714 | 2111615.47744 | 37.7775345952701 | -122.47710758505501 | (37.7775345952701, -122.477107585055) | ||
| 100830 | 100830 | 31795 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 141 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35265 | 6001336.75578377 | 2108526.84088843 | 37.7696879701055 | -122.438714168685 | (37.7696879701055, -122.438714168685) | ||
| 101833 | 101833 | 89054 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 788 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990404.14743 | 2110052.29751 | 37.773248445022 | -122.476640781805 | (37.773248445022, -122.476640781805) | ||
| 102328 | 102328 | 34270 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38072 | 5987122.50109111 | 2115231.37554308 | 37.7872778329962 | -122.48837297696699 | (37.7872778329962, -122.488372976967) | ||
| 102376 | 102376 | 89667 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2731 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990147.66431 | 2111935.32582 | 37.778403842194 | -122.477665649037 | (37.778403842194, -122.477665649037) | ||
| 103093 | 103093 | 89057 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 768 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990399.549819999 | 2110162.4742900003 | 37.773550693633 | -122.47666473627899 | (37.773550693633, -122.476664736279) | ||
| 103146 | 103146 | 89063 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 710 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990388.49369 | 2110501.1170799998 | 37.774479872644 | -122.476727727029 | (37.774479872644, -122.476727727029) | ||
| 103217 | 103217 | 89101 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 617 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990317.59695 | 2111167.61171 | 37.7763057711064 | -122.477021681856 | (37.7763057711064, -122.477021681856) | ||
| 103411 | 103411 | 89656 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2921 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5989570.9478400005 | 2111917.39409 | 37.7783211217462 | -122.479659392459 | (37.7783211217462, -122.479659392459) | ||
| 105058 | 105058 | 89068 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 622 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990367.60069 | 2111102.5118400003 | 37.7761299255256 | -122.476843949277 | (37.7761299255256, -122.476843949277) | ||
| 105384 | 105384 | 55357 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1001 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1972 12:00:00 AM | Permit Number 11290 | 6001956.10378782 | 2101177.25372795 | 37.749542999745 | -122.436045873593 | (37.749542999745, -122.436045873593) | |||
| 105518 | 105518 | 39927 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41199 | 6010702.15739083 | 2087798.94554582 | 37.7133019788898 | -122.404859809077 | (37.7133019788898, -122.404859809077) | |||
| 105637 | 105637 | 96626 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 105851 | 105851 | 55533 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000967.89961965 | 2104951.08442142 | 37.759848834973795 | -122.439733631625 | (37.7598488349738, -122.439733631625) |
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");