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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 155770 | 155770 | 191267 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 538 Delancey St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6015157.461180001 | 2113744.4936599997 | 37.7847910341296 | -122.391273164948 | (37.7847910341296, -122.391273164948) | ||||
| 155567 | 155567 | 247480 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 309 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002710.1595 | 2109648.0677 | 37.772844618769895 | -122.434043773953 | (37.7728446187699, -122.434043773953) | |||
| 155061 | 155061 | 191334 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1108 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014881.31548 | 2110022.28226 | 37.7745553516884 | -122.391968167293 | (37.7745553516884, -122.391968167293) | |||
| 154729 | 154729 | 176975 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 248 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002517.77047 | 2092300.43042 | 37.7252011818667 | -122.43346933824301 | (37.7252011818667, -122.433469338243) | |||
| 154559 | 154559 | 250620 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987116.07946 | 2115204.5954 | 37.7872039277514 | -122.48839322528099 | (37.7872039277514, -122.488393225281) | |||
| 154442 | 154442 | 191335 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1108 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014898.40719 | 2110003.75259 | 37.774505422222 | -122.391907747266 | (37.774505422222, -122.391907747266) | |||
| 154293 | 154293 | 46268 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2436 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2002 12:00:00 AM | 3 | Permit Number 44552 | 5986405.9288 | 2102348.8049 | 37.7518640711658 | -122.489904286753 | (37.7518640711658, -122.489904286753) | ||
| 154095 | 154095 | 248214 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 67 Fair Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 6006956.2223 | 2099478.83098 | 37.7451623091856 | -122.41863484214 | (37.7451623091856, -122.41863484214) | |||
| 153075 | 153075 | 227592 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6005300.21046 | 2107796.96547 | 37.767908588337896 | -122.424952753964 | (37.7679085883379, -122.424952753964) | |||
| 152929 | 152929 | 227636 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3232 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008200.59079 | 2100972.6589 | 37.749334006979396 | -122.414437698959 | (37.7493340069794, -122.414437698959) | |||
| 152769 | 152769 | 129415 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1914 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999481.122280001 | 2115602.98861 | 37.7890115102163 | -122.44564165674 | (37.7890115102163, -122.44564165674) | |||
| 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) | |||
| 152536 | 152536 | 176979 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Winding Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6002427.23589 | 2086817.03836 | 37.7101398650242 | -122.433390645786 | (37.7101398650242, -122.433390645786) | |||
| 152338 | 152338 | 227651 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4118 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001694.86954 | 2103534.27623 | 37.75599997444 | -122.43711796243 | (37.75599997444, -122.43711796243) | |||
| 151998 | 151998 | 129437 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010035.0094 | 2115756.1647799998 | 37.790028987884895 | -122.409137245009 | (37.7900289878849, -122.409137245009) | |||
| 151835 | 151835 | 176944 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 19 Lois Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012329.67576 | 2087861.6330900001 | 37.7135649447506 | -122.39923890456801 | (37.7135649447506, -122.399238904568) | |||
| 151159 | 151159 | 227625 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4283 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002039.82763 | 2101169.8407900003 | 37.749527401673 | -122.435755824069 | (37.749527401673, -122.435755824069) | |||
| 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) | |||
| 150887 | 150887 | 183441 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2434 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989549.5958 | 2098772.4148 | 37.742227304861395 | -122.47877163063801 | (37.7422273048614, -122.478771630638) | |||
| 150746 | 150746 | 176967 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Craut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004019.42662 | 2094104.5358400003 | 37.7302399367234 | -122.428406793639 | (37.7302399367234, -122.428406793639) | |||
| 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) | |||
| 150169 | 150169 | 176933 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 56 Lois Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012542.43425 | 2087752.49307 | 37.7132771230101 | -122.398495876584 | (37.7132771230101, -122.398495876584) | |||
| 150126 | 150126 | 176941 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 19 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012299.34717 | 2087880.5993299999 | 37.7136153319601 | -122.39934506233999 | (37.7136153319601, -122.39934506234) | |||
| 149816 | 149816 | 191313 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015141.50158 | 2107991.42305 | 37.76899350256671 | -122.39092615881799 | (37.7689935025667, -122.390926158818) | |||
| 149495 | 149495 | 114219 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 31 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012347.17965 | 2087849.72367 | 37.713533219358396 | -122.399177569 | (37.7135332193584, -122.399177569) | |||
| 149339 | 149339 | 191293 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014546.37169 | 2110379.31646 | 37.775517086679 | -122.393151800112 | (37.775517086679, -122.393151800112) | |||
| 148905 | 148905 | 99379 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | |
| 148811 | 148811 | 247957 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6010434.9927199995 | 2098878.7541 | 37.743709870826 | -122.40656351750602 | (37.743709870826, -122.406563517506) | ||||
| 148773 | 148773 | 176956 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 99 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012750.523080001 | 2087747.4076 | 37.713274749713605 | -122.39777628854799 | (37.7132747497136, -122.397776288548) | |||
| 148569 | 148569 | 200000 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 Griffith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6017688.3023 | 2092371.2757 | 37.726244750724 | -122.381030719301 | (37.726244750724, -122.381030719301) | |||
| 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) | |||
| 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) | |||
| 148210 | 148210 | 191351 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015099.52293 | 2107709.56267 | 37.7682172464566 | -122.391051658332 | (37.7682172464566, -122.391051658332) | |||
| 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) | |||
| 148096 | 148096 | 176961 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 41 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011207.15899 | 2087778.71194 | 37.7132746363936 | -122.403112916852 | (37.7132746363936, -122.403112916852) | |||
| 148062 | 148062 | 176958 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 214 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012631.12356 | 2087648.5603099999 | 37.7129966847253 | -122.39818204648701 | (37.7129966847253, -122.398182046487) | |||
| 147671 | 147671 | 207068 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 539 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991225.79939 | 2097692.69128 | 37.739359846476205 | -122.472897178881 | (37.7393598464762, -122.472897178881) | |||
| 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) | |||
| 147585 | 147585 | 31733 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2495 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 3 | 3x3 | Permit Number 35227 | 5990132.7438 | 2098427.0161 | 37.7413127725673 | -122.476730077237 | (37.7413127725673, -122.476730077237) |
| 147095 | 147095 | 207059 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2454 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5992059.72364 | 2098724.92514 | 37.7422423409243 | -122.470089007101 | (37.7422423409243, -122.470089007101) | |||
| 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) | |||
| 146728 | 146728 | 246318 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6006836.8702 | 2108926.9706 | 37.7710979938489 | -122.419717800254 | (37.7710979938489, -122.419717800254) | |||
| 146723 | 146723 | 48452 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5996026.36682 | 2113840.43033 | 37.7839741521628 | -122.457467011011 | (37.7839741521628, -122.457467011011) | ||
| 145327 | 145327 | 102558 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 145313 | 145313 | 64085 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2010 12:00:00 AM | Permit Number 54033 | 5990603.92265969 | 2099084.38866457 | 37.7431450674581 | -122.475148901667 | (37.7431450674581, -122.475148901667) | |||
| 145061 | 145061 | 31775 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 145001 | 145001 | 89060 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 744 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990392.548057 | 2110303.8535700003 | 37.7739384762903 | -122.476699287319 | (37.7739384762903, -122.476699287319) | ||
| 144733 | 144733 | 96627 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 2 | 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) | |||
| 144570 | 144570 | 102556 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 144534 | 144534 | 102567 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2013 12:00:00 AM | 3x3 | Permit Number 769962 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||
| 144383 | 144383 | 89434 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2750X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990083.37165 | 2111991.81654 | 37.7785552188238 | -122.47789218978001 | (37.7785552188238, -122.47789218978) | ||
| 144085 | 144085 | 4551 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1991 12:00:00 AM | 24 | 3X3 | 6004735.0847094 | 2113637.0202701 | 37.783912012698394 | -122.427323526754 | (37.7839120126984, -122.427323526754) | ||
| 143981 | 143981 | 116237 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 639 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5990321.779490001 | 2111019.87703 | 37.775900374977 | -122.47699641585 | (37.775900374977, -122.47699641585) | |||
| 143244 | 143244 | 34271 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 118 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.48837581666099 | (37.7872024288867, -122.488375816661) | ||
| 143200 | 143200 | 109857 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 521 CLIPPER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x6 | 6001683.3 | 2100835.6 | 37.748589397757 | -122.436964779583 | (37.748589397757, -122.436964779583) | |||
| 142878 | 142878 | 89076 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 550 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990345.59029 | 2111614.5302 | 37.777534510056704 | -122.476957509799 | (37.7775345100567, -122.476957509799) | ||
| 142751 | 142751 | 89422 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2400X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991198.491359999 | 2112030.01361 | 37.7787247544447 | -122.474037391358 | (37.7787247544447, -122.474037391358) | ||
| 142142 | 142142 | 99394 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 141554 | 141554 | 89689 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2405 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991196.08416 | 2111975.00544 | 37.7785735776786 | -122.47404170417101 | (37.7785735776786, -122.474041704171) | ||
| 140608 | 140608 | 92050 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 140359 | 140359 | 89421 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2300 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991477.6623 | 2112038.61858 | 37.778764548514 | -122.47307226747 | (37.778764548514, -122.47307226747) | ||
| 140061 | 140061 | 89688 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2405 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991173.67465 | 2111973.9047 | 37.7785692572369 | -122.474119146124 | (37.7785692572369, -122.474119146124) | ||
| 139838 | 139838 | 89690 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2351 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5991335.21973 | 2111978.62727 | 37.7785915807726 | -122.473560650038 | (37.7785915807726, -122.473560650038) | ||
| 138922 | 138922 | 89104 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 627 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990323.547333 | 2111099.7078 | 37.77611967086071 | -122.476996135109 | (37.7761196708607, -122.476996135109) | ||
| 138916 | 138916 | 89082 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 466 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990324.88294 | 2112207.2474 | 37.7791607464072 | -122.477072465426 | (37.7791607464072, -122.477072465426) | ||
| 138679 | 138679 | 89683 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2439X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991013.77238 | 2111967.7388400002 | 37.778543063369604 | -122.474671853461 | (37.7785430633696, -122.474671853461) | ||
| 138646 | 138646 | 4517 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20X Cleary Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.42642640211099 | (37.7846101140023, -122.426426402111) | |||
| 138266 | 138266 | 109806 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775061 | 5992117.2 | 2106823.9 | 37.764483341532 | -122.47047998805401 | (37.764483341532, -122.470479988054) |
| 138206 | 138206 | 176957 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 208 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012704.399540001 | 2087660.6669400001 | 37.7130340083786 | -122.397929627449 | (37.7130340083786, -122.397929627449) | |||
| 137702 | 137702 | 105030 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015079.85403 | 2108063.37025 | 37.769187632923604 | -122.391144425184 | (37.7691876329236, -122.391144425184) | |||
| 137572 | 137572 | 129440 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 754 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008519.418319999 | 2114901.84945 | 37.7875982238142 | -122.414320608106 | (37.7875982238142, -122.414320608106) | |||
| 137511 | 137511 | 191306 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015160.53731 | 2107657.60104 | 37.7680779567607 | -122.39083698203899 | (37.7680779567607, -122.390836982039) | |||
| 137045 | 137045 | 57079 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 627 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 2 | Permit Number 14346 | 5990318.78395 | 2111097.03664 | 37.7761120602541 | -122.477012417523 | (37.7761120602541, -122.477012417523) | ||
| 136981 | 136981 | 37644 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2732 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40059 | 5990120.460530001 | 2111993.16181 | 37.7785610650821 | -122.47776398494499 | (37.7785610650821, -122.477763984945) | |
| 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) | |||
| 136667 | 136667 | 191345 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015084.02733 | 2107988.1043 | 37.7689812007549 | -122.391124728238 | (37.7689812007549, -122.391124728238) | |||
| 136471 | 136471 | 176966 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 327 Craut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 7ft | 6004069.61366 | 2093704.49695 | 37.7291443592041 | -122.42820479154301 | (37.7291443592041, -122.428204791543) | |||
| 136463 | 136463 | 244199 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 677 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003772.3734 | 2110028.492 | 37.7739493963127 | -122.430396601984 | (37.7739493963127, -122.430396601984) | |||
| 136250 | 136250 | 250532 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 79 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5987685.24066 | 2115481.63254 | 37.787997784513294 | -122.486444423174 | (37.7879977845133, -122.486444423174) | |||
| 136118 | 136118 | 250773 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 259 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5985865.92055 | 2114194.89594 | 37.7843585636424 | -122.492644052605 | (37.7843585636424, -122.492644052605) | |||
| 135780 | 135780 | 129443 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Cyril Magnin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6010100.50138 | 2114305.77616 | 37.7860502369758 | -122.408808278389 | (37.7860502369758, -122.408808278389) | |||
| 135774 | 135774 | 39858 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 514 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 5 | Permit Number 41164 | 5992538.39814 | 2111929.42262 | 37.7785260826754 | -122.469394849438 | (37.7785260826754, -122.469394849438) | |
| 135315 | 135315 | 191324 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015118.87024 | 2108392.34888 | 37.770093100956004 | -122.391032465874 | (37.770093100956, -122.391032465874) | |||
| 134947 | 134947 | 191301 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015174.991090001 | 2107387.31726 | 37.7673366186106 | -122.39076809667499 | (37.7673366186106, -122.390768096675) | |||
| 134902 | 134902 | 181607 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1255 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5987053.8771 | 2106742.5422 | 37.7639658865787 | -122.487986427971 | (37.7639658865787, -122.487986427971) | |||
| 134501 | 134501 | 191255 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1901 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011611.18002 | 2106494.85248 | 37.764687737485 | -122.403032107369 | (37.764687737485, -122.403032107369) | |||
| 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) | ||
| 134094 | 134094 | 191283 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6014423.24539 | 2110620.23478 | 37.7761717535676 | -122.39359459213999 | (37.7761717535676, -122.39359459214) | |||
| 133916 | 133916 | 176946 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 33 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012391.32203 | 2087821.98143 | 37.7134595046344 | -122.39902305019699 | (37.7134595046344, -122.399023050197) | |||
| 133580 | 133580 | 129395 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3383 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998662.1100699995 | 2115556.58452 | 37.7888373034598 | -122.44847197610399 | (37.7888373034598, -122.448471976104) | |||
| 133441 | 133441 | 227626 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1455 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6003318.57968 | 2099748.35087 | 37.7456968761174 | -122.43123241046601 | (37.7456968761174, -122.431232410466) | |||
| 133413 | 133413 | 250533 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 69 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5987683.92995 | 2115503.12844 | 37.7880567296852 | -122.48645053678601 | (37.7880567296852, -122.486450536786) | |||
| 132763 | 132763 | 48667 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3362 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2012 12:00:00 AM | 1 | Permit Number 768676 | 5998753.52645 | 2115612.95888 | 37.788997318923705 | -122.44815975037599 | (37.7889973189237, -122.448159750376) | ||
| 132516 | 132516 | 246316 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006848.8767 | 2108962.1326 | 37.7711952166815 | -122.41967876451 | (37.7711952166815, -122.41967876451) | |||
| 132161 | 132161 | 176945 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 31 Lois Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012378.545530001 | 2087831.41605 | 37.7134846982415 | -122.399067872395 | (37.7134846982415, -122.399067872395) | |||
| 131733 | 131733 | 191263 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 728 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012693.0382199995 | 2104091.70249 | 37.7581495726586 | -122.399121524154 | (37.7581495726586, -122.399121524154) | |||
| 131574 | 131574 | 31728 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2460 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990177.7474 | 2098625.5077 | 37.7418603894955 | -122.476588969759 | (37.7418603894955, -122.476588969759) |
| 131490 | 131490 | 191310 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015152.46863 | 2107768.27489 | 37.7683813952045 | -122.390872626697 | (37.7683813952045, -122.390872626697) | |||
| 131229 | 131229 | 200112 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1560 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014792.7183 | 2092559.9355 | 37.726602519263004 | -122.391053863847 | (37.726602519263, -122.391053863847) |
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");