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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39984 | 39984 | 129551 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6012074.07881 | 2115564.48535 | 37.789616701801 | -122.40206871312 | (37.789616701801, -122.40206871312) | |||
| 40379 | 40379 | 129554 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6012057.79655 | 2115657.86651 | 37.7898721955983 | -122.40213161617599 | (37.7898721955983, -122.402131616176) | |||
| 42762 | 42762 | 226645 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3626 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 1ft | 6005580.70423 | 2101999.04422 | 37.752004698476206 | -122.42357029633301 | (37.7520046984762, -122.423570296333) | |||
| 45848 | 45848 | 129548 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1 Saroyan Pl | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6011012.0164 | 2118485.6729900003 | 37.7975782452004 | -122.405949226574 | (37.7975782452004, -122.405949226574) | |||
| 48051 | 48051 | 177031 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 263 Maynard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 2ft | 6005122.72167 | 2093818.5342400002 | 37.729517010390204 | -122.42457221572901 | (37.7295170103902, -122.424572215729) | |||
| 65210 | 65210 | 226642 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 14 Cumberland St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6005484.04077 | 2104618.2918599998 | 37.759191085608 | -122.42409082483101 | (37.759191085608, -122.424090824831) | |||
| 66325 | 66325 | 249500 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1765 California St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6005972.54693 | 2115883.04317 | 37.7901489421804 | -122.42320206534401 | (37.7901489421804, -122.423202065344) | |||
| 133672 | 133672 | 249499 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1765 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6005919.33859 | 2115875.5653 | 37.7901254069127 | -122.423385630445 | (37.7901254069127, -122.423385630445) | |||
| 135694 | 135694 | 129558 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 300 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6012591.8685800005 | 2116885.11843 | 37.793271734566005 | -122.400370000791 | (37.793271734566, -122.400370000791) | |||
| 150604 | 150604 | 177029 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 123 Seneca Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6000050.7624699995 | 2090072.63848 | 37.7189438978236 | -122.441837691751 | (37.7189438978236, -122.441837691751) | |||
| 159256 | 159256 | 249501 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1765 California St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6006000.97948 | 2115886.86804 | 37.790161048840794 | -122.42310396280001 | (37.7901610488408, -122.4231039628) | |||
| 161411 | 161411 | 129557 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 300 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6012628.75569 | 2116888.8810400004 | 37.7932841227067 | -122.40024263249201 | (37.7932841227067, -122.400242632492) | |||
| 166908 | 166908 | 129552 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6012061.46033 | 2115633.25932 | 37.789804834569296 | -122.402117209065 | (37.7898048345693, -122.402117209065) | |||
| 180697 | 180697 | 129556 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 216 Post St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6011025.30596 | 2115257.2463 | 37.7887145046082 | -122.405675728365 | (37.7887145046082, -122.405675728365) | |||
| 182512 | 182512 | 129555 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 216 Post St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6011031.64459 | 2115258.30549 | 37.7887177673445 | -122.40565387214599 | (37.7887177673445, -122.405653872146) | |||
| 29825 | 29825 | 188590 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 762 De Haro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 2ft | 6012084.87947 | 2104884.86073 | 37.7602934997697 | -122.401280549067 | (37.7602934997697, -122.401280549067) | |||
| 31528 | 31528 | 188591 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 762 De Haro St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 2ft | 6012098.14806 | 2104884.14995 | 37.7602922883855 | -122.401234609004 | (37.7602922883855, -122.401234609004) | |||
| 49332 | 49332 | 125294 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 350 Green St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 2ft | 6011239.45333 | 2119379.16325 | 37.800044269893 | -122.40522518060499 | (37.800044269893, -122.405225180605) | |||
| 53319 | 53319 | 250582 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2201 Golden Gate Ave | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 20 | Width 4ft | 5997524.78366 | 2111231.6493599997 | 37.776897077482296 | -122.45209477536301 | (37.7768970774823, -122.452094775363) | |||
| 63523 | 63523 | 125293 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 350 Green St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 2ft | 6011255.59442 | 2119381.50562 | 37.800051603848296 | -122.40516949099501 | (37.8000516038483, -122.405169490995) | |||
| 82411 | 82411 | 107622 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 191 HAIGHT ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | 6005238.1 | 2109520.1 | 37.7726363924224 | -122.425290219951 | (37.7726363924224, -122.425290219951) | ||||
| 130090 | 130090 | 250583 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2201 Golden Gate Ave | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 25 | Width 4ft | 5997549.22583 | 2111234.92705 | 37.7769074772273 | -122.45201045941799 | (37.7769074772273, -122.452010459418) | |||
| 161947 | 161947 | 125292 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 350 Green St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 2ft | 6011272.94246 | 2119383.82344 | 37.8000589378412 | -122.405109623112 | (37.8000589378412, -122.405109623112) | |||
| 174453 | 174453 | 203702 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2072 15th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 10ft | 5991651.27757 | 2101417.16458 | 37.7496109163211 | -122.47169742658899 | (37.7496109163211, -122.471697426589) | |||
| 40080 | 40080 | 175138 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 67 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6004374.522580001 | 2093135.8569099999 | 37.7276002475407 | -122.427110209575 | (37.7276002475407, -122.427110209575) | |||
| 31166 | 31166 | 125541 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 65 Heather Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 5997339.5515 | 2114115.46943 | 37.7848046777406 | -122.45294375606501 | (37.7848046777406, -122.452943756065) | ||||
| 33683 | 33683 | 221802 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 325 Day St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 3ft | 6003816.248819999 | 2098634.77002 | 37.7426674306639 | -122.42943214577 | (37.7426674306639, -122.42943214577) | |||
| 34188 | 34188 | 221823 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 588 Ogden Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 4ft | 6007760.27568 | 2096148.55485 | 37.7360633428545 | -122.41561880828199 | (37.7360633428545, -122.415618808282) | |||
| 59894 | 59894 | 221824 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 588 Ogden Ave | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 6007730.82531 | 2096150.2700599998 | 37.736066396937204 | -122.415720751814 | (37.7360663969372, -122.415720751814) | |||
| 130119 | 130119 | 203536 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 347 Hearst Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 5999101.320719999 | 2094349.11818 | 37.730631973677795 | -122.445426858158 | (37.7306319736778, -122.445426858158) | |||
| 54248 | 54248 | 130425 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 842 Sansome St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012127.88855 | 2118699.30676 | 37.7982271771027 | -122.402103014136 | (37.7982271771027, -122.402103014136) | |||
| 130082 | 130082 | 130424 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 842 Sansome St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012129.23244 | 2118685.48448 | 37.7981892994573 | -122.40209739158999 | (37.7981892994573, -122.40209739159) | |||
| 151153 | 151153 | 130426 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 842 Sansome St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012124.42235 | 2118721.37553 | 37.7982875791671 | -122.40211656062401 | (37.7982875791671, -122.402116560624) | |||
| 170492 | 170492 | 192800 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 600 Illinois St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6015940.7807599995 | 2106258.15422 | 37.7642786394618 | -122.388040508659 | (37.7642786394618, -122.388040508659) | |||
| 33874 | 33874 | 196602 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 608 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6013520.1448 | 2104276.81958 | 37.758703921979794 | -122.396273986373 | (37.7587039219798, -122.396273986373) | |||
| 57091 | 57091 | 179247 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 353 Prague St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6003781.052759999 | 2089121.49913 | 37.7165441288874 | -122.42887576852199 | (37.7165441288874, -122.428875768522) | |||
| 71563 | 71563 | 196601 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 598 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 6013516.47989 | 2104326.37457 | 37.7588397852535 | -122.39629013460501 | (37.7588397852535, -122.396290134605) | |||
| 95159 | 95159 | 96547 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 110127 | 110127 | 96546 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 110892 | 110892 | 96548 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 146412 | 146412 | 239773 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 417 Eureka St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6001524.1364 | 2103380.5723200003 | 37.755568234207296 | -122.43769740552601 | (37.7555682342073, -122.437697405526) | |||
| 150261 | 150261 | 136061 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3311 Pacific Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 5ft | 5998344.32344 | 2116484.47626 | 37.7913668733358 | -122.44963835901699 | (37.7913668733358, -122.449638359017) | |||
| 158526 | 158526 | 239766 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1661 Noe St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 4ft | 6003395.97584 | 2098595.19502 | 37.7425349632095 | -122.43088250404101 | (37.7425349632095, -122.430882504041) | |||
| 167574 | 167574 | 196603 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 618 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6013523.1670699995 | 2104217.2762 | 37.7585405969979 | -122.39625936070101 | (37.7585405969979, -122.396259360701) | |||
| 174712 | 174712 | 239763 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4233 Cesar Chavez St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 6002389.599719999 | 2100306.5087200003 | 37.7471767573086 | -122.43448458290199 | (37.7471767573086, -122.434484582902) | |||
| 180105 | 180105 | 238990 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1017 Guerrero St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6005766.99533 | 2102918.3127900003 | 37.7545393108464 | -122.422991404546 | (37.7545393108464, -122.422991404546) | |||
| 45124 | 45124 | 130311 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 240 Vallejo St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 10ft | 6012262.6273300005 | 2119165.06793 | 37.799513564651704 | -122.401669529244 | (37.7995135646517, -122.401669529244) | |||
| 49406 | 49406 | 130245 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1845 Leavenworth St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 6007759.64505 | 2118718.9798 | 37.7980364128955 | -122.417219873113 | (37.7980364128955, -122.417219873113) | |||
| 55009 | 55009 | 130388 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 795 Pine St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 6010180.29895 | 2116128.00767 | 37.7910581171895 | -122.40866079585399 | (37.7910581171895, -122.408660795854) | |||
| 71726 | 71726 | 130310 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 240 Vallejo St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 10ft | 6012270.9402 | 2119166.66602 | 37.799518416493896 | -122.401640875949 | (37.7995184164939, -122.401640875949) | |||
| 169260 | 169260 | 177163 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 189 Velasco Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 6ft | 6007991.7614400005 | 2086069.6109099998 | 37.70840170934729 | -122.41410563508002 | (37.7084017093473, -122.41410563508) | |||
| 175864 | 175864 | 200451 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 8ft | 6014956.18254 | 2103836.3549900004 | 37.757574303320204 | -122.391276680392 | (37.7575743033202, -122.391276680392) | |||
| 182544 | 182544 | 200450 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 8ft | 6014955.45065 | 2103853.5745099997 | 37.7576215438129 | -122.391280415259 | (37.7576215438129, -122.391280415259) | |||
| 23836 | 23836 | 204823 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1331 09th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5993302.77838 | 2106404.87542 | 37.7634012905668 | -122.466348974927 | (37.7634012905668, -122.466348974927) | |||
| 35862 | 35862 | 204983 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 770 Myra Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 5997269.92545 | 2098069.6489 | 37.7407429372348 | -122.452026562677 | (37.7407429372348, -122.452026562677) | |||
| 49342 | 49342 | 188108 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 211 Terry A Francois Blvd | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6015796.42981 | 2110627.97034 | 37.77626919959339 | -122.388844874016 | (37.7762691995934, -122.388844874016) | |||
| 73097 | 73097 | 221081 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 123 Laidley St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6003713.0407 | 2097628.2927099997 | 37.739898031361605 | -122.429717239859 | (37.7398980313616, -122.429717239859) | |||
| 137925 | 137925 | 125690 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 942 Grant Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6010834.35635 | 2117791.64759 | 37.7956626820416 | -122.406515050327 | (37.7956626820416, -122.406515050327) | |||
| 151461 | 151461 | 125689 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 36 Spofford St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6010574.2812 | 2117423.5888099996 | 37.794637528646 | -122.407389000723 | (37.794637528646, -122.407389000723) | |||
| 164867 | 164867 | 205018 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 259 Flood Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5999037.480380001 | 2094055.6847700002 | 37.7298226296873 | -122.445626469893 | (37.7298226296873, -122.445626469893) | |||
| 165208 | 165208 | 188107 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 211 Terry A Francois Blvd | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6015791.03065 | 2110625.94515 | 37.7762633396153 | -122.38886340994101 | (37.7762633396153, -122.388863409941) | |||
| 171340 | 171340 | 175419 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 239 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6003841.68045 | 2092281.6629700002 | 37.7252246748743 | -122.42889137802901 | (37.7252246748743, -122.428891378029) | |||
| 104278 | 104278 | 117387 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 108949 | 108949 | 117383 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 113644 | 113644 | 117385 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 117100 | 117100 | 117384 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 119725 | 119725 | 117382 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 135050 | 135050 | 244933 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 276 Page St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 0ft | 6005244.6732 | 2109942.1819 | 37.773795698453604 | -122.425297523476 | (37.7737956984536, -122.425297523476) | |||
| 139331 | 139331 | 117386 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 31275 | 31275 | 195449 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014736.842019999 | 2117083.55492 | 37.7939359738125 | -122.392962080059 | (37.7939359738125, -122.392962080059) | |||
| 32033 | 32033 | 235482 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 106 Chattanooga St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 6004702.50004 | 2102988.75016 | 37.7546725903948 | -122.42667772741699 | (37.7546725903948, -122.426677727417) | |||
| 32945 | 32945 | 178518 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 62 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008249.62715 | 2086262.35093 | 37.708945414261606 | -122.41322803793899 | (37.7089454142616, -122.413228037939) | |||
| 38524 | 38524 | 124392 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3900 Washington St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 5996085.26261 | 2115570.92527 | 37.788729010018294 | -122.45738849109199 | (37.7887290100183, -122.457388491092) | |||
| 40643 | 40643 | 195447 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6014706.202819999 | 2117116.39491 | 37.794024442814106 | -122.393070394401 | (37.7940244428141, -122.393070394401) | |||
| 51822 | 51822 | 195451 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 5ft | 6014767.70739 | 2117048.87622 | 37.793842468603 | -122.392852854701 | (37.793842468603, -122.392852854701) | |||
| 58740 | 58740 | 195446 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014688.3614 | 2117131.68733 | 37.794065441128 | -122.393133198563 | (37.794065441128, -122.393133198563) | |||
| 59798 | 59798 | 195450 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6014751.24936 | 2117067.54594 | 37.793892817153704 | -122.392911108287 | (37.7938928171537, -122.392911108287) | |||
| 74677 | 74677 | 195448 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014719.29527 | 2117100.4128400004 | 37.793981287051295 | -122.393023974076 | (37.7939812870513, -122.393023974076) | |||
| 130790 | 130790 | 124395 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3900 Washington St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 5996032.15972 | 2115565.17728 | 37.7887101773731 | -122.45757180221001 | (37.7887101773731, -122.45757180221) | |||
| 134604 | 134604 | 135302 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 840 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 2ft | 6010328.26528 | 2116562.4227 | 37.792259202258 | -122.408179486788 | (37.792259202258, -122.408179486788) | |||
| 146601 | 146601 | 178617 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1686 Alemany Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 3ft | 6001466.5158400005 | 2092244.27913 | 37.72498730330771 | -122.43709939413999 | (37.7249873033077, -122.43709939414) | |||
| 147317 | 147317 | 124393 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3900 Washington St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 5996070.40089 | 2115569.6533 | 37.7887246639076 | -122.457439818112 | (37.7887246639076, -122.457439818112) | |||
| 147550 | 147550 | 135303 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 840 California St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 2ft | 6010295.40817 | 2116554.0512599996 | 37.79223437647521 | -122.40829258284799 | (37.7922343764752, -122.408292582848) | |||
| 148359 | 148359 | 124394 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3900 Washington St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 2ft | 5996045.97336 | 2115566.9988599997 | 37.7887159724195 | -122.45752414117099 | (37.7887159724195, -122.457524141171) | |||
| 157502 | 157502 | 178616 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1686 Alemany Blvd | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | Width 4ft | 6001474.37484 | 2092261.25737 | 37.7250343684236 | -122.437073441507 | (37.7250343684236, -122.437073441507) | |||
| 163842 | 163842 | 238601 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4808 25th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 20 | Width 10ft | 5999995.98595 | 2101090.80522 | 37.7491940814535 | -122.442817794501 | (37.7491940814535, -122.442817794501) | |||
| 180318 | 180318 | 238602 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4808 25th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 10ft | 5999965.12286 | 2101089.08454 | 37.7491875973318 | -122.442924395649 | (37.7491875973318, -122.442924395649) | |||
| 182549 | 182549 | 134900 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 Union St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6011410.78161 | 2119701.10617 | 37.8009378236702 | -122.404654992453 | (37.8009378236702, -122.404654992453) | |||
| 186167 | 186167 | 195445 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014671.32996 | 2117148.01113 | 37.79410931633421 | -122.393193272358 | (37.7941093163342, -122.393193272358) | |||
| 27120 | 27120 | 135723 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1910 Baker St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 5999974.03757 | 2115574.89722 | 37.7889625079578 | -122.44393422098699 | (37.7889625079578, -122.443934220987) | |||
| 30789 | 30789 | 236735 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2235 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | Width 8ft | 6002728.24168 | 2098985.0046599996 | 37.7435674334864 | -122.433219176525 | (37.7435674334864, -122.433219176525) | |||
| 31993 | 31993 | 135726 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1910 Baker St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5999972.00363 | 2115592.60206 | 37.789011004802106 | -122.443942530717 | (37.7890110048021, -122.443942530717) | |||
| 33287 | 33287 | 118775 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 630 45th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 27 | Width 2ft | 5981986.088380001 | 2111427.82901 | 37.7765333919608 | -122.50586147692101 | (37.7765333919608, -122.505861476921) | |||
| 33419 | 33419 | 218015 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990772.5777900005 | 2099709.35635 | 37.7448708407289 | -122.474611345145 | (37.7448708407289, -122.474611345145) | |||
| 40197 | 40197 | 236681 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 756 Grand View Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 6000049.04538 | 2100790.98488 | 37.7483738718507 | -122.442612790472 | (37.7483738718507, -122.442612790472) | |||
| 40900 | 40900 | 196108 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 553 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6014419.65969 | 2104542.9303 | 37.759484616234104 | -122.393181648629 | (37.7594846162341, -122.393181648629) | |||
| 41984 | 41984 | 135853 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 12 Filbert St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | 6012286.0131 | 2120198.4327700003 | 37.8023522396158 | -122.40166127704799 | (37.8023522396158, -122.401661277048) | ||||
| 42692 | 42692 | 139101 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2533 POST ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 6000038.1797 | 2113670.6976 | 37.78373772905571 | -122.443575453886 | (37.7837377290557, -122.443575453886) | |||
| 43845 | 43845 | 236752 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 420 Collingwood St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 6002107.159440001 | 2103370.74755 | 37.755574390960604 | -122.435680430326 | (37.7555743909606, -122.435680430326) | ||||
| 48400 | 48400 | 236754 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 456 Collingwood St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6002114.12722 | 2103211.5772 | 37.755137743137496 | -122.435644946673 | (37.7551377431375, -122.435644946673) |
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");