861 rows where qSpecies_id = 18 sorted by rowid descending

View and edit SQL

rowid ▲ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
194392 162798 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 107 Grafton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2020 12:00:00 AM 3 4x6   5996432.70685 2090525.92628 37.7199816938867 -122.454376546047 (37.7199816938867, -122.454376546047) 9 8 6 28861 24
194388 162793 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 201 Grafton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2020 12:00:00 AM 3 4x6   5996142.86432 2090531.62526 37.7199807154151 -122.455378837768 (37.7199807154151, -122.455378837768) 9 8 6 28861 24
194237 31775 Permitted Site 7 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2000 Ulloa St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35250 5989839.49734774 2098377.72398218 37.7411604150808 -122.477740406961 (37.7411604150808, -122.477740406961) 1 8 3 29491 35
194062 96627 Permitted Site 7 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 145 Sutro Heights Ave 2 Sidewalk: Property side : Yard Tree Private 2   06/10/2011 12:00:00 AM     Permit Number 767986 5981103.1 2111247.3 37.7759857009664 -122.50890252539 (37.7759857009664, -122.50890252539) 11 6 2 55 26
193848 207090 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1400 Ulloa St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5991605.432 2098443.60055 37.7414436224199 -122.47163929621 (37.7414436224199, -122.47163929621) 1 8 4 29491 40
193551 207093 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2469 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5992014.45058 2098646.31177 37.742023871309 -122.470239822518 (37.742023871309, -122.470239822518) 1 8 4 29491 40
193451 207096 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 447 Lansdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5996040.3151 2096410.52388 37.7361168767915 -122.456158138087 (37.7361168767915, -122.456158138087) 9 7 4 59 40
192991 114221 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 28 Lois Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6012377.24762 2087856.00195 37.7135521339029 -122.399074083116 (37.7135521339029, -122.399074083116) 10 3 8 309 1
192933 191260 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1058 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6012165.085 2103460.39568 37.7563867072014 -122.400903071241 (37.7563867072014, -122.400903071241) 10 3 8 28856 29
192764 106106 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 708 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2     14     6011765.54028 2117816.6633 37.7957834196109 -122.403294730072 (37.7957834196109, -122.403294730072) 3 1 10 28860 4
192751 64085 Permitted Site 7 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 850 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2010 12:00:00 AM     Permit Number 54033 5990603.92265969 2099084.38866457 37.7431450674581 -122.475148901667 (37.7431450674581, -122.475148901667) 1 8 4 29491 40
192681 102558 Undocumented 4 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1755X 04th St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015173.7 2107354.9 37.7672475362702 -122.390770296702 (37.7672475362702, -122.390770296702) 14 3 9 310 20
191961 227654 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 210 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004930.05045 2104005.07306 37.7574760371124 -122.425963138682 (37.7574760371124, -122.425963138682) 2 4 5 28862 3
191951 176948 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 43 Lois Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6012470.82697 2087771.09267 37.7133242043273 -122.398744682131 (37.7133242043273, -122.398744682131) 10 3 8 309 1
191886 129392 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 31 Casa Way 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001624.74168 2121508.73342 37.8053492888098 -122.438648369353 (37.8053492888098, -122.438648369353) 13 9 1 57 17
191762 227619 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1193 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008092.35309 2100991.6752 37.7493801403813 -122.414813334067 (37.7493801403813, -122.414813334067) 2 4 7 28859 19
191686 89060 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 744 18th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/03/2008 12:00:00 AM 3 3x3   5990392.548057 2110303.85357 37.7739384762903 -122.476699287319 (37.7739384762903, -122.476699287319) 11 6 2 55 26
191557 207082 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1963 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5992234.50744 2102126.7079 37.7515928656239 -122.469732265838 (37.7515928656239, -122.469732265838) 1 8 4 29491 12
191047 99399 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1590 Yosemite Ave 22 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980856 -122.390639783135 (37.726418980856, -122.390639783135) 10 3 8 58 1
191003 207066 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 71 Wawona St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5993124.54928 2098622.04482 37.7420213577054 -122.466399723691 (37.7420213577054, -122.466399723691) 1 8 4 59 40
190961 187585 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 748 University St 1 Front Yard : Yard Tree Private 2     19     6008708.47344 2090752.442 37.7213000235466 -122.411959282496 (37.7213000235466, -122.411959282496) 9 7 7 309 18
190849 25182 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 3226 Market St 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/18/1996 12:00:00 AM 3 3X3   5999429.9273 2104670.84771 37.7589917140099 -122.4450325603 (37.7589917140099, -122.4450325603) 2 4 5 28862 3
190811 207059 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2454 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5992059.72364 2098724.92514 37.7422423409243 -122.470089007101 (37.7422423409243, -122.470089007101) 1 8 4 29491 40
190708 129438 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 715 Bush St 3 Sidewalk: Curb side : Pot Tree Private 2     3 Width 4ft   6010041.47641 2115755.35321 37.7900271217973 -122.409114812309 (37.7900271217973, -122.409114812309) 5 1 10 28857 21
190301 227657 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 117 States St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001570.04877 2106180.8326 37.7632596788053 -122.437739171852 (37.7632596788053, -122.437739171852) 15 5 5 28862 3
189800 191249 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2300 18th St 3 Sidewalk: Curb side : Pot Tree Private 2     6 Width 10ft   6010915.57021 2105542.63703 37.7620342994705 -122.405370986778 (37.7620342994705, -122.405370986778) 8 3 8 28856 29
189467 176976 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 100 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6002487.99329 2086859.86644 37.7102609083974 -122.433183714473 (37.7102609083974, -122.433183714473) 9 7 6 28861 5
189316 191272 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 659 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6014208.1321 2110827.64494 37.7767292999414 -122.394353258399 (37.7767292999414, -122.394353258399) 6 2 9 28856 20
188836 207073 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 230 Pacheco St 1 Sidewalk: Curb side : Yard Tree Private 2     9 Width 6ft   5994505.45248 2100370.55426 37.746901910105 -122.461751786336 (37.746901910105, -122.461751786336) 1 8 4 29491 40
188829 102556 Undocumented 4 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1755X 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015173.7 2107354.9 37.7672475362702 -122.390770296702 (37.7672475362702, -122.390770296702) 14 3 9 310 20
188798 227662 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 32 Harry St 10 Sidewalk: Property side : Yard Tree Private 2     4 Width 10ft   6003182.99622 2097643.55659 37.7399099141156 -122.431551000691 (37.7399099141156, -122.431551000691) 2 7 5 63 7
188438 89104 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 627 18th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2008 12:00:00 AM 3 3x3   5990323.547333 2111099.7078 37.7761196708607 -122.476996135109 (37.7761196708607, -122.476996135109) 11 6 2 55 26
188409 31770 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1850 Ulloa St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM 2   Permit Number 35249 5990241.9611 2098396.6732 37.7412357933409 -122.476350230302 (37.7412357933409, -122.476350230302) 1 8 3 29491 35
188316 246314 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1660 Mission St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 0ft   6006868.6018 2109014.4469 37.7713399704187 -122.419614246796 (37.7713399704187, -122.419614246796) 8 2 9 28853 19
187695 49756 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1171 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM 1   Permit Number 46552 6011373.3818 2089351.75942 37.7176031885257 -122.402648943989 (37.7176031885257, -122.402648943989) 10 7 8 309 39
187084 89082 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 466 18th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/03/2008 12:00:00 AM 3 3x3   5990324.88294 2112207.2474 37.7791607464072 -122.477072465426 (37.7791607464072, -122.477072465426) 11 6 2 55 26
187023 18862 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2200 Sacramento St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 3X3PL   6004143.20725 2116038.00121 37.7904710109775 -122.429542492602 (37.7904710109775, -122.429542492602) 13 9 1 29490 27
187013 200105 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1528 Yosemite Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6014949.7328 2092444.2049 37.7262934578304 -122.390502982758 (37.7262934578304, -122.390502982758) 10 3 8 58 1
186370 227636 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 3232 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008200.59079 2100972.6589 37.7493340069794 -122.414437698959 (37.7493340069794, -122.414437698959) 2 4 7 28859 19
185996 50456 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 993 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/21/2003 12:00:00 AM 6   Permit Number 47101 6015538.43851 2104592.1377 37.7596818177679 -122.38931576171 (37.7596818177679, -122.38931576171) 10 3 8 28856 29
185564 117943 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 6300 Fulton St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5983766.08421 2109717.40456 37.7719416683068 -122.499577617773 (37.7719416683068, -122.499577617773) 11 6 2 55 26
184935 92050 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2323 Cesar Chavez St   Front Yard : Cutout Tree DPW 1   05/16/2009 12:00:00 AM       6012395.863444 2100936.77011 37.7494702500338 -122.399927744224 (37.7494702500338, -122.399927744224) 10 3 8 58 1
184748 102567 Undocumented 4 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1655X 04th St 7 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2013 12:00:00 AM   3x3 Permit Number 769962 6015154.2 2107704.9 37.7682074777149 -122.390862208319 (37.7682074777149, -122.390862208319) 14 3 9 310 20
184555 57079 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 627 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/22/1974 12:00:00 AM 2   Permit Number 14346 5990318.78395 2111097.03664 37.7761120602541 -122.477012417523 (37.7761120602541, -122.477012417523) 11 6 2 55 26
183963 200098 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1528 Yosemite Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015053.9581 2092365.0208 37.7260818154372 -122.390137148672 (37.7260818154372, -122.390137148672) 10 3 8 58 1
183807 102256 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1933 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2013 12:00:00 AM 1 3x3 Permit Number 58594 6000840.6 2115080.7 37.7876549629941 -122.440900572101 (37.7876549629941, -122.440900572101) 13 6 1 29490 27
183685 142580 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 650 CHESTNUT ST 5 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6008660.8 2120758.6253 37.8036874273397 -122.414245990591 (37.8036874273397, -122.414245990591) 3 1 10 308 23
183529 89683 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2439X Anza St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/08/2008 12:00:00 AM 3 3x3   5991013.77238 2111967.73884 37.7785430633696 -122.474671853461 (37.7785430633696, -122.474671853461) 11 6 2 54 26
183420 187582 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 747 University St 3 Side Yard : Yard Tree Private 2     12     6008739.08909 2090759.61849 37.7213214463175 -122.411853959308 (37.7213214463175, -122.411853959308) 9 3 7 309 28
183411 191347 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1750 04th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015093.18746 2107823.28717 37.7685291574227 -122.391081522115 (37.7685291574227, -122.391081522115) 14 3 9 310 20
182587 4551 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 85 Cleary Ct 3 Sidewalk: Curb side : Cutout Tree DPW 1   07/11/1991 12:00:00 AM 24 3X3   6004735.0847094 2113637.0202701 37.7839120126984 -122.427323526754 (37.7839120126984, -122.427323526754) 7 9 11 28858 41
182404 176938 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 10 Lois Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6012264.96042 2087928.82829 37.7137458424772 -122.399467299971 (37.7137458424772, -122.399467299971) 10 3 8 309 1
182318 207068 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 539 Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5991225.79939 2097692.69128 37.7393598464762 -122.472897178881 (37.7393598464762, -122.472897178881) 1 8 4 29491 40
181301 108995 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 55 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2015 12:00:00 AM 3 3x3 Permit Number 772985 5993924.20809 2115202.12337 37.7875920194037 -122.464838574554 (37.7875920194037, -122.464838574554) 11 6 1 54 11
181193 176929 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 110 Hester Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6012755.76956 2087791.93581 37.7133973075252 -122.397761276185 (37.7133973075252, -122.397761276185) 10 3 8 309 1
181058 183580 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2614 26th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5988349.2799 2097484.0905 37.7386201346216 -122.482827506776 (37.7386201346216, -122.482827506776) 1 8 3 29491 35
181056 191300 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 601 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015176.683 2107358.12451 37.767256555574 -122.390760204217 (37.767256555574, -122.390760204217) 14 3 9 310 20
180619 99381 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1590 Yosemite Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980856 -122.390639783135 (37.726418980856, -122.390639783135) 10 3 8 58 1
180384 4517 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 20X Cleary Ct 7 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6004999.51904 2113885.82273 37.7846101140023 -122.426426402111 (37.7846101140023, -122.426426402111) 13 9 11 28858 41
180251 129430 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2201 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6004093.9756 2116304.66162 37.7912004052335 -122.429731858334 (37.7912004052335, -122.429731858334) 13 9 1 29490 27
180161 34271 Permitted Site 7 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 118 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38073 5987121.09736721 2115203.94287654 37.7872024288867 -122.488375816661 (37.7872024288867, -122.488375816661) 11 6 1 55 33
179951 109857 Undocumented 4 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 521 CLIPPER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     40 3x6   6001683.3 2100835.6 37.748589397757 -122.436964779583 (37.748589397757, -122.436964779583) 2 4 5 28862 22
179884 94214 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 465 Missouri St 9 Sidewalk: Curb side : Cutout Tree Private 2   06/22/2010 12:00:00 AM 3 3x3 Permit Number 53589 6013545.01697 2104957.62874 37.7605746593094 -122.396235681545 (37.7605746593094, -122.396235681545) 10 3 8 28856 29
179526 207086 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2167 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5990677.28316 2100628.1103 37.7473879783661 -122.475007906598 (37.7473879783661, -122.475007906598) 1 8 4 29491 40
178669 89689 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2405 Anza St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/08/2008 12:00:00 AM 3 3x3   5991196.08416 2111975.00544 37.7785735776786 -122.474041704171 (37.7785735776786, -122.474041704171) 11 6 2 54 26
178443 89076 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 550 18th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/03/2008 12:00:00 AM 3 3x3   5990345.59029 2111614.5302 37.7775345100567 -122.476957509799 (37.7775345100567, -122.476957509799) 11 6 2 55 26
178429 207051 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1264 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5992092.81688 2106815.43538 37.764458690039 -122.470563705269 (37.764458690039, -122.470563705269) 11 8 11 56 12
178232 191253 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 654 Minnesota St 12 Sidewalk: Property side : Yard Tree Private 2     3 Width 10ft   6015148.44265 2105367.15882 37.7617882296504 -122.390718735586 (37.7617882296504, -122.390718735586) 10 3 8 28856 29
177615 191317 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1505 04th St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015134.8576 2108090.59219 37.7692654305833 -122.390956072084 (37.7692654305833, -122.390956072084) 14 3 9 310 20
177567 89690 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2351 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2008 12:00:00 AM 3 3x3   5991335.21973 2111978.62727 37.7785915807726 -122.473560650038 (37.7785915807726, -122.473560650038) 11 6 2 54 26
177495 42710 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1600 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/2010 12:00:00 AM 10 3x3 Permit Number 53744 6005271.11771 2118900.89126 37.7983955805457 -122.42584385893 (37.7983955805457, -122.42584385893) 13 9 1 57 17
176982 191363 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 955 Key Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13     6013550.52728 2089583.75311 37.7183615103672 -122.395139727222 (37.7183615103672, -122.395139727222) 10 3 8 58 1
176725 191284 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 751 04th St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6014408.26812 2110636.4725 37.7762155064684 -122.393647539722 (37.7762155064684, -122.393647539722) 6 2 9 28856 20
176678 207079 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 59 Ralston St 3 Back Yard : Yard Tree Private 2     12     5992173.18035 2088300.45859 37.7136258989769 -122.468938264287 (37.7136258989769, -122.468938264287) 9 8 6 64 24
176325 89422 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2400X Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/29/2008 12:00:00 AM 3 3x3   5991198.49136 2112030.01361 37.7787247544447 -122.474037391358 (37.7787247544447, -122.474037391358) 11 6 2 54 26
176225 227663 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 6 Unnamed 011 1 Back Yard : Yard Tree Private 2     13 Width 10ft   6002739.4908 2096074.90228 37.7355776028169 -122.432972414242 (37.7355776028169, -122.432972414242) 2 7 5 63 7
175891 176939 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 8 Lois Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6012245.82216 2087941.31791 37.7137790697309 -122.399534325569 (37.7137790697309, -122.399534325569) 10 3 8 309 1
175651 129401 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 5 Dicha Aly 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   5998309.94171 2113772.92465 37.7839197016653 -122.449561847418 (37.7839197016653, -122.449561847418) 15 6 1 54 31
175436 227601 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1100 San Jose Ave 48 Sidewalk: Property side : Yard Tree Private 2     13     6004769.19859 2096667.0685 37.7373184762576 -122.425997076417 (37.7373184762576, -122.425997076417) 2 7 5 63 7
174473 254175 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1089 Chestnut St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2018 12:00:00 AM 3 3x3   6006628.18877 2120429.73547 37.8026699959528 -122.421256591898 (37.8026699959528, -122.421256591898) 5 1 1 28858 32
174472 227626 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1455 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6003318.57968 2099748.35087 37.7456968761174 -122.431232410466 (37.7456968761174, -122.431232410466) 2 7 5 63 22
174282 89688 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2405 Anza St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/08/2008 12:00:00 AM 3 3x3   5991173.67465 2111973.9047 37.7785692572369 -122.474119146124 (37.7785692572369, -122.474119146124) 11 6 2 54 26
173534 176968 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 134 Craut St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6004019.9865 2094083.37147 37.7301818557853 -122.428403350153 (37.7301818557853, -122.428403350153) 9 7 6 28861 5
173385 129410 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2199 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6003271.2174 2116075.89812 37.7905256555748 -122.432562228073 (37.7905256555748, -122.432562228073) 13 9 1 29490 27
172750 89434 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2750X Anza St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/29/2008 12:00:00 AM 3 3x3   5990083.37165 2111991.81654 37.7785552188238 -122.47789218978 (37.7785552188238, -122.47789218978) 11 6 2 55 26
172719 191297 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 740 04th St 7 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6014617.26494 2110308.92783 37.7753277532976 -122.392901635701 (37.7753277532976, -122.392901635701) 6 2 9 310 20
172712 191251 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 654 Minnesota St 9 Sidewalk: Property side : Yard Tree Private 2     5 Width 10ft   6015148.84129 2105378.48456 37.7618193498029 -122.390718148336 (37.7618193498029, -122.390718148336) 10 3 8 28856 29
172622 129446 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1329 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6008344.2402 2117236.00141 37.7939973921104 -122.415091973713 (37.7939973921104, -122.415091973713) 5 1 10 28858 21
172563 129418 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2129 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6003255.2303 2117874.11084 37.7954621799809 -122.432746053085 (37.7954621799809, -122.432746053085) 13 9 1 29490 27
172538 176954 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 95 Lois Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6012699.50978 2087739.26695 37.7132495561051 -122.397952038554 (37.7132495561051, -122.397952038554) 10 3 8 309 1
172453 176956 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 99 Lois Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6012750.52308 2087747.4076 37.7132747497136 -122.397776288548 (37.7132747497136, -122.397776288548) 10 3 8 309 1
171921 99379 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1590 Yosemite Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM 1 3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980856 -122.390639783135 (37.726418980856, -122.390639783135) 10 3 8 58 1
171672 176933 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 56 Lois Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6012542.43425 2087752.49307 37.7132771230101 -122.398495876584 (37.7132771230101, -122.398495876584) 10 3 8 309 1
171650 129402 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 3000 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5999090.32735 2119096.86414 37.7985824452762 -122.44724531075 (37.7985824452762, -122.44724531075) 13 9 1 57 17
171588 176940 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 15 Lois Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6012273.46712 2087900.15525 37.7136675861685 -122.399435885762 (37.7136675861685, -122.399435885762) 10 3 8 309 1
170972 139749 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 85 CLEARY CT 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6004687.008 2113628.2842 37.7838853065296 -122.427489231919 (37.7838853065296, -122.427489231919) 7 9 11 28858 41
170885 109806 Permitted Site 7 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1264 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/03/2015 12:00:00 AM 3 3x3 Permit Number 775061 5992117.2 2106823.9 37.764483341532 -122.470479988054 (37.764483341532, -122.470479988054) 11 8 11 56 12
170850 227592 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 501 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6005300.21046 2107796.96547 37.7679085883379 -122.424952753964 (37.7679085883379, -122.424952753964) 8 4 5 28853 19
170603 200097 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1528 Yosemite Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015067.4938 2092354.869 37.7260546913573 -122.390089647295 (37.7260546913573, -122.390089647295) 10 3 8 58 1
170331 36895 Permitted Site 7 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 4118 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/27/1998 12:00:00 AM     Permit Number 39548 6001738.91463484 2103541.42716619 37.7560221127265 -122.436966152078 (37.7560221127265, -122.436966152078) 2 4 5 28862 3

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);