Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 28660 | 28660 | 142575 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2251 MASON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6008927.1192 | 2120859.172 | 37.803978459247205 | -122.41333149055401 | (37.8039784592472, -122.413331490554) | |||
| 130376 | 130376 | 84614 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2034 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50834 | 6000478.89565 | 2121006.72285 | 37.8039056520943 | -122.442577640443 | (37.8039056520943, -122.442577640443) | |
| 92502 | 92502 | 101350 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 600 Chestnut St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 102408 | 102408 | 101353 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 600 Chestnut St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 189123 | 189123 | 84613 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2029-22031 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50833 | 6000517.3597800005 | 2120966.99196 | 37.8037987541811 | -122.442441679147 | (37.8037987541811, -122.442441679147) | |
| 150955 | 150955 | 142587 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2320 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6008491.26 | 2120799.1265 | 37.8037891087643 | -122.414835562646 | (37.8037891087643, -122.414835562646) | |||
| 115563 | 115563 | 101359 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201X Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 5x5 | Permit Number 32655 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.41329507143601 | (37.803771736238, -122.413295071436) | ||
| 162169 | 162169 | 101345 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 600 Chestnut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 22 | Permit Number 32655 | 6008773.8267 | 2120774.1665 | 37.803736447762795 | -122.413855954453 | (37.8037364477628, -122.413855954453) | ||
| 120267 | 120267 | 27626 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2310X Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008495.093859999 | 2120769.31703 | 37.8037074748624 | -122.41482018433399 | (37.8037074748624, -122.414820184334) | |||
| 184446 | 184446 | 142580 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 650 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6008660.8 | 2120758.6253 | 37.8036874273397 | -122.414245990591 | (37.8036874273397, -122.414245990591) | |||
| 48721 | 48721 | 33958 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 15 | Permit Number 37913 | 6008590.6293 | 2120749.6774 | 37.8036589168384 | -122.414488187223 | (37.8036589168384, -122.414488187223) | ||
| 46474 | 46474 | 129453 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6007720.64474 | 2120576.4205400003 | 37.8031342846895 | -122.417486534671 | (37.8031342846895, -122.417486534671) | |||
| 49285 | 49285 | 129456 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6007719.74229 | 2120576.43903 | 37.803134284681 | -122.41748965894199 | (37.803134284681, -122.417489658942) | |||
| 65391 | 65391 | 129455 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007721.09596 | 2120576.41129 | 37.8031342846798 | -122.41748497255199 | (37.8031342846798, -122.417484972552) | |||
| 35185 | 35185 | 129454 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007720.06236 | 2120575.53372 | 37.8031318169374 | -122.41748848713002 | (37.8031318169374, -122.41748848713) | |||
| 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) | |||
| 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) | |||
| 28468 | 28468 | 129406 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3545 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000708.230719999 | 2120533.5731200003 | 37.8026195792908 | -122.44175003663099 | (37.8026195792908, -122.441750036631) | |||
| 152638 | 152638 | 129450 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1257 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 6ft | 6006338.43207 | 2120038.90392 | 37.8015805322681 | -122.42223151426799 | (37.8015805322681, -122.422231514268) | |||
| 31094 | 31094 | 87873 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2341 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50845 | 6000097.31037 | 2119864.70248 | 37.8007482115146 | -122.443816038389 | (37.8007482115146, -122.443816038389) | |
| 123726 | 123726 | 35235 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1077 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 6 | Permit Number 38732 | 6007771.26508 | 2119552.1201 | 37.8003246614186 | -122.417238733675 | (37.8003246614186, -122.417238733675) | |
| 54446 | 54446 | 129451 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1147 Filbert St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6007395.89235 | 2119499.90916 | 37.80016017810029 | -122.418533970572 | (37.8001601781003, -122.418533970572) | |||
| 185179 | 185179 | 61519 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1161 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1984 12:00:00 AM | 7 | Permit Number 21475 | 6007368.68612 | 2119491.86468 | 37.8001365583177 | -122.418627544125 | (37.8001365583177, -122.418627544125) | ||
| 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) | |||
| 108210 | 108210 | 122590 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 MacOndray Ln | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6008161.0 | 2119143.0 | 37.7992232381339 | -122.415861106147 | (37.7992232381339, -122.415861106147) | |||||
| 156039 | 156039 | 31965 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 35367 | 6008195.50256 | 2118963.54127 | 37.7987324288073 | -122.41572900131099 | (37.7987324288073, -122.415729001311) | |||
| 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) | |
| 5887 | 5887 | 94203 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008148.35783 | 2118956.03523 | 37.7987091687558 | -122.415891605907 | (37.7987091687558, -122.415891605907) | |
| 156333 | 156333 | 129391 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1851 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004117.78483 | 2119036.12679 | 37.798701658520706 | -122.42984439412399 | (37.7987016585207, -122.429844394124) | |||
| 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) | |||
| 27723 | 27723 | 129402 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3000 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999090.32735 | 2119096.86414 | 37.7985824452762 | -122.44724531075 | (37.7985824452762, -122.44724531075) | |||
| 98308 | 98308 | 107371 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 448 BROADWAY | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011394.4 | 2118786.8 | 37.798426445485 | -122.404647279275 | (37.798426445485, -122.404647279275) | ||||
| 184974 | 184974 | 42710 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1600 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53744 | 6005271.11771 | 2118900.89126 | 37.7983955805457 | -122.42584385893 | (37.7983955805457, -122.42584385893) |
| 180480 | 180480 | 143382 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1600 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6005275.1713 | 2118900.2974 | 37.798394179030794 | -122.425829789965 | (37.7983941790308, -122.425829789965) | |||
| 176903 | 176903 | 129458 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 731 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012131.08094 | 2118327.87745 | 37.7972074996935 | -122.40206584156401 | (37.7972074996935, -122.402065841564) | |||
| 146952 | 146952 | 129404 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2844 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000064.89028 | 2118400.48534 | 37.7967260116595 | -122.44382296947799 | (37.7967260116595, -122.443822969478) | |||
| 46359 | 46359 | 129457 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 822 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010137.05679 | 2118184.23209 | 37.7967015887668 | -122.408955554965 | (37.7967015887668, -122.408955554965) | |||
| 44629 | 44629 | 129403 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2844 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000067.16914 | 2118384.00921 | 37.7966809025571 | -122.443813899808 | (37.7966809025571, -122.443813899808) | |||
| 162829 | 162829 | 51087 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2031REVISED Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2004 12:00:00 AM | 8 | Permit Number 47544 | 6006859.53299 | 2118230.7659 | 37.7966452201661 | -122.42029985774799 | (37.7966452201661, -122.420299857748) | ||
| 3230 | 3230 | 1713 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 555 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 5x6 | 6012507.60717 | 2118114.90232 | 37.796643729085005 | -122.40074798855 | (37.796643729085, -122.40074798855) | |||
| 3485 | 3485 | 1714 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 555 Battery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 5x9 | 6012511.35044 | 2118080.94057 | 37.796550687018204 | -122.400732648813 | (37.7965506870182, -122.400732648813) | |||
| 59034 | 59034 | 129459 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 458 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011895.81451 | 2118092.21584 | 37.7965472956624 | -122.402863344166 | (37.7965472956624, -122.402863344166) | |||
| 148459 | 148459 | 129460 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 468 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011856.71365 | 2118087.11906 | 37.7965311177706 | -122.402998283841 | (37.7965311177706, -122.402998283841) | |||
| 148356 | 148356 | 129461 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 468 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011829.8803199995 | 2118083.5136599997 | 37.796519719768895 | -122.403090879839 | (37.7965197197689, -122.403090879839) | |||
| 7931 | 7931 | 1715 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 555 Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 5x6 | 6012518.40757 | 2118034.67495 | 37.796424046287996 | -122.400704977573 | (37.796424046288, -122.400704977573) | |||
| 1485 | 1485 | 115988 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 499 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777967 | 6011781.45666 | 2118040.71778 | 37.7963995082912 | -122.40325542520901 | (37.7963995082912, -122.403255425209) | |
| 41714 | 41714 | 115987 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 499 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011766.1004 | 2118039.4815599998 | 37.7963952562896 | -122.40330847443 | (37.7963952562896, -122.40330847443) | |||
| 7798 | 7798 | 1716 | Landmark tree 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 555 Battery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x15 | 6012528.51285 | 2117974.4106400004 | 37.796259138493205 | -122.400665775228 | (37.7962591384932, -122.400665775228) | |||
| 69 | 69 | 19206 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 630 Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6012230.08543 | 2117977.14861 | 37.7962500076802 | -122.40169859442699 | (37.7962500076802, -122.401698594427) | |||
| 7985 | 7985 | 1718 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 555 Battery St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 9x6 | 6012538.2564900005 | 2117884.3369 | 37.7960123609319 | -122.400625729299 | (37.7960123609319, -122.400625729299) | |||
| 134345 | 134345 | 32357 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 716 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 3 | Permit Number 36911 | 6011755.33078 | 2117880.08122 | 37.7959569797808 | -122.40333452058998 | (37.7959569797808, -122.40333452059) | ||
| 178509 | 178509 | 106106 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 708 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6011765.54028 | 2117816.6633 | 37.7957834196109 | -122.403294730072 | (37.7957834196109, -122.403294730072) | ||||
| 148228 | 148228 | 129462 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 584 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011873.80865 | 2117764.68671 | 37.7956467505394 | -122.402916441935 | (37.7956467505394, -122.402916441935) | |||
| 173778 | 173778 | 71255 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1392 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 1 | 6007494.44606 | 2117816.87319 | 37.795544530015604 | -122.418073553678 | (37.7955445300156, -122.418073553678) | ||
| 136784 | 136784 | 129423 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6003338.49011 | 2117887.74598 | 37.795504340202896 | -122.432458934629 | (37.7955043402029, -122.432458934629) | |||
| 178008 | 178008 | 129422 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6003322.87221 | 2117886.8736900003 | 37.7955010594859 | -122.432512912861 | (37.7955010594859, -122.432512912861) | |||
| 24380 | 24380 | 129424 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6003346.86179 | 2117886.37825 | 37.7955010594853 | -122.43242986946699 | (37.7955010594853, -122.432429869467) | |||
| 38881 | 38881 | 129421 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6003307.9218 | 2117884.58152 | 37.795493917972 | -122.43256447998999 | (37.795493917972, -122.43256447999) | |||
| 148134 | 148134 | 129420 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6003293.360640001 | 2117882.88889 | 37.795488444692296 | -122.43261474308599 | (37.7954884446923, -122.432614743086) | |||
| 156068 | 156068 | 129419 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6003276.06747 | 2117879.65532 | 37.795478585430104 | -122.43267434925899 | (37.7954785854301, -122.432674349259) | |||
| 30187 | 30187 | 97675 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2562 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6000810.80569 | 2117928.4487099997 | 37.7954724412642 | -122.441208053918 | (37.7954724412642, -122.441208053918) | ||||
| 71525 | 71525 | 97676 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2562 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6000785.23545 | 2117926.05562 | 37.7954644138979 | -122.441296359259 | (37.7954644138979, -122.441296359259) | ||||
| 47633 | 47633 | 129418 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003255.2303 | 2117874.11084 | 37.795462179980895 | -122.432746053085 | (37.7954621799809, -122.432746053085) | |||
| 52761 | 52761 | 129417 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003236.15275 | 2117871.33798 | 37.795453484440706 | -122.432811866398 | (37.7954534844407, -122.432811866398) | |||
| 98803 | 98803 | 104725 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2747 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2013 12:00:00 AM | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.794880464642894 | -122.44436863671899 | (37.7948804646429, -122.444368636719) | ||
| 118595 | 118595 | 104724 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2747 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.794880464642894 | -122.44436863671899 | (37.7948804646429, -122.444368636719) | |||
| 95348 | 95348 | 97442 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1900@Gough Pacific Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004943.9 | 2117474.7 | 37.794461125583794 | -122.42687450783701 | (37.7944611255838, -122.426874507837) | |||||
| 65596 | 65596 | 129426 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003248.10705 | 2117506.03033 | 37.7944511216749 | -122.432744393832 | (37.7944511216749, -122.432744393832) | |||
| 163894 | 163894 | 129427 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003257.40294 | 2117505.83832 | 37.794451121666604 | -122.43271221522 | (37.7944511216666, -122.43271221522) | |||
| 45037 | 45037 | 129425 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003239.07369 | 2117504.42466 | 37.794446200597 | -122.432775535577 | (37.794446200597, -122.432775535577) | |||
| 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) | |||
| 150569 | 150569 | 129445 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 24 Priest St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008315.59279 | 2117230.60537 | 37.793980966003 | -122.415190714801 | (37.793980966003, -122.415190714801) | |||
| 27806 | 27806 | 129444 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1338 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008418.059880001 | 2116953.62618 | 37.793226207275794 | -122.414816555443 | (37.7932262072758, -122.414816555443) | |||
| 167387 | 167387 | 129428 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2250 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6003926.506990001 | 2116660.0257099997 | 37.7921666602192 | -122.430336659605 | (37.7921666602192, -122.430336659605) | |||
| 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) | ||
| 55487 | 55487 | 129414 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2501 Jackson St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001550.43955 | 2116611.49961 | 37.791898545338896 | -122.438554394686 | (37.7918985453389, -122.438554394686) | |||
| 173107 | 173107 | 54086 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2405 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1972 12:00:00 AM | 7 | Permit Number 9810 | 6003110.67405 | 2116498.63256 | 37.791677270739896 | -122.433147915142 | (37.7916772707399, -122.433147915142) | ||
| 43089 | 43089 | 46211 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2244 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2003 12:00:00 AM | 3 | Permit Number 46882 | 6003263.56021 | 2116449.57494 | 37.7915512424562 | -122.43261542476299 | (37.7915512424562, -122.432615424763) | ||
| 75466 | 75466 | 129435 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6004184.0136 | 2116319.13373 | 37.7912452400168 | -122.429421362005 | (37.7912452400168, -122.429421362005) | |||
| 130371 | 130371 | 129434 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6004173.55874 | 2116318.162 | 37.7912419799702 | -122.429457466206 | (37.7912419799702, -122.429457466206) | |||
| 69337 | 69337 | 129433 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004155.37388 | 2116318.23991 | 37.791241164293496 | -122.429520390877 | (37.7912411642935, -122.429520390877) | |||
| 159374 | 159374 | 129432 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004124.61142 | 2116315.60844 | 37.7912321971464 | -122.429626640374 | (37.7912321971464, -122.429626640374) | |||
| 186133 | 186133 | 129431 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6004108.39045 | 2116309.70837 | 37.7912150785667 | -122.42968234348301 | (37.7912150785667, -122.429682343483) | |||
| 169241 | 169241 | 129430 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6004093.9756 | 2116304.66162 | 37.791200405233496 | -122.42973185833401 | (37.7912004052335, -122.429731858334) | |||
| 114102 | 114102 | 129429 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6004071.91056 | 2116304.52286 | 37.7911987747643 | -122.429808192813 | (37.7911987747643, -122.429808192813) | |||
| 61686 | 61686 | 105315 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2101 Laguna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | |||||
| 82615 | 82615 | 105316 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2101 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | ||||
| 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) | |||||
| 147603 | 147603 | 129408 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2199 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003263.17406 | 2116138.42129 | 37.7906968721156 | -122.432594525436 | (37.7906968721156, -122.432594525436) | |||
| 55145 | 55145 | 129409 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2199 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003265.25593 | 2116107.39334 | 37.7906117953446 | -122.43258510502399 | (37.7906117953446, -122.432585105024) | |||
| 183006 | 183006 | 129410 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2199 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003271.2174 | 2116075.89812 | 37.7905256555748 | -122.43256222807301 | (37.7905256555748, -122.432562228073) | |||
| 8677 | 8677 | 18861 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2200 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | 6004226.06461 | 2116051.48796 | 37.790512733214 | -122.42925677349 | (37.790512733214, -122.42925677349) | |||
| 6585 | 6585 | 44092 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2200 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2000 12:00:00 AM | 8 | 3x3 | Permit Number 43607 | 6004180.10381 | 2116042.60341 | 37.790485736467296 | -122.429415161181 | (37.7904857364673, -122.429415161181) | |
| 5858 | 5858 | 18862 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2200 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3PL | 6004143.20725 | 2116038.00121 | 37.790471010977505 | -122.42954249260201 | (37.7904710109775, -122.429542492602) | |||
| 164372 | 164372 | 111668 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2200 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3PL | 6004109.02078 | 2116034.23701 | 37.790458739741 | -122.429660507029 | (37.790458739741, -122.429660507029) | |||
| 40498 | 40498 | 129411 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2111 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003275.408009999 | 2116033.9816799997 | 37.790410801365105 | -122.43254473354901 | (37.7904108013651, -122.432544733549) | |||
| 54469 | 54469 | 57397 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1190 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1976 12:00:00 AM | 11 | Permit Number 16237 | 6008290.06558 | 2115917.44184 | 37.7903739066804 | -122.41518604372601 | (37.7903739066804, -122.415186043726) | ||
| 64750 | 64750 | 129447 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1190 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008246.65377 | 2115911.69756 | 37.7903556945065 | -122.41533583927799 | (37.7903556945065, -122.415335839278) | |||
| 42869 | 42869 | 129448 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1190 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008230.449580001 | 2115909.44994 | 37.79034861235171 | -122.415391745646 | (37.7903486123517, -122.415391745646) |
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");