200 rows where qSpecies_id = 230

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)
98308 40345 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1132 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/25/2003 12:00:00 AM     Permit Number 41475 6005084.75376098 2101750.889457 37.7512953165646 -122.425267709911 (37.7512953165646, -122.425267709911) 2 4 5 28862 22
98938 24204 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 80X Whitney Young Cir 4 Sidewalk: Curb side : Cutout Tree DPW 1   11/20/1991 12:00:00 AM 30 3x3   6016946.00997 2094945.60902 37.7332723623663 -122.383775970862 (37.7332723623663, -122.383775970862) 10 3 8 58 1
99875 12117 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1295X La Salle Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1992 12:00:00 AM 24 3X3   6016958.2682626 2094597.9426774 37.7323184171755 -122.383709392876 (37.7323184171755, -122.383709392876) 10 3 8 58 1
100966 209047 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 901 Noriega St 1 Sidewalk: Property side : Yard Tree Private 2     16 Width 4ft   5991111.79749 2103120.98949 37.7542579462658 -122.473687224283 (37.7542579462658, -122.473687224283) 1 8 4 56 12
102727 3793 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 75 Cashmere St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017167.2819088 2095817.4840533 37.7356785868328 -122.383071626706 (37.7356785868328, -122.383071626706) 10 3 8 58 1
103033 105163 Undocumented 4 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1600X OAKDALE AVE 2 Sidewalk: Curb side : Cutout Tree Arts Commission 19     17 4x4 Permit Number 770204 6015006 2095503 37.7346954145828 -122.390522107646 (37.7346954145828, -122.390522107646) 10 3 8 58 1
103773 252839 Property Tree 8 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 99 Pond St 2 Sidewalk: Property side : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
106117 16466 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2X Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6018746.8015012 2097101.6577332 37.7392918278803 -122.377699652009 (37.7392918278803, -122.377699652009) 10 3 8 58 1
106337 41059 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 220 10th St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1999 12:00:00 AM     Permit Number 41830 6008482.96704788 2109848.1149541 37.7737198300469 -122.41408905371 (37.7737198300469, -122.41408905371) 8 2 9 28853 34
107528 244112 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 418 Shrader St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   5997497.0233 2108906.982 37.7705125521566 -122.452023046285 (37.7705125521566, -122.452023046285) 15 5 11 29492 9
110006 121135 Undocumented 4 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 200 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011463 2107546 37.7675656754516 -122.403618589173 (37.7675656754516, -122.403618589173) 8 2 8 28853 20
111069 117088 Undocumented 4 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1401 HOWARD ST 4 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6008367 2109860 37.773745949403 -122.414491044326 (37.773745949403, -122.414491044326) 8 2 9 28853 34
111884 23443 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2100X Van Ness Ave 2 Median : Cutout Tree DPW 1     24 9   6005986.24007 2117685.53144 37.7950988961632 -122.423282873032 (37.7950988961632, -122.423282873032) 13 9 10 28858 32
113079 191794 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 800 Terry A Francois Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     20 Width 4ft   6016193.39876 2106582.65811 37.7651836497265 -122.387189402894 (37.7651836497265, -122.387189402894) 14 3 9 310 20
114739 191802 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 180x Bay Shore Blvd 1 Median : Yard Tree DPW 1     27     6011170.05761 2099578.40947 37.7456720701144 -122.404071054532 (37.7456720701144, -122.404071054532) 10 3 7 58 1
116050 8302 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 25 Garlington Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016780.4831368 2094683.2530579 37.732542833716 -122.384329982291 (37.732542833716, -122.384329982291) 10 3 8 58 1
117892 41056 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 220 10th St 12 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1999 12:00:00 AM     Permit Number 41830 6008482.96704788 2109848.1149541 37.7737198300469 -122.41408905371 (37.7737198300469, -122.41408905371) 8 2 9 28853 34
119430 224299 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1413 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     31 Width 5ft   6003312.01278 2099871.95093 37.7460358809565 -122.4312639389 (37.7460358809565, -122.4312639389) 2 7 5 63 22
119899 41822 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1514 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/2003 12:00:00 AM     Permit Number 46307 6001899.39673806 2111557.7304122 37.7780420286383 -122.436985033556 (37.7780420286383, -122.436985033556) 15 5 11 29490 41
120858 176353 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2168 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6012284.29807 2088275.4365 37.714698637311 -122.399424780029 (37.714698637311, -122.399424780029) 10 7 8 309 39
124872 32612 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1200 06th St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37077 5994246.31301 2107167.01801 37.7655483320884 -122.463140922317 (37.7655483320884, -122.463140922317) 11 5 11 56 12
124986 100419 Undocumented 4 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 760 Duboce Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           6002024.1 2108325.5 37.7691742163209 -122.436322258742 (37.7691742163209, -122.436322258742) 15 5 5 29492 9
125711 26152 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1500 Oakdale Ave 22 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 3x3   6015586.3934773 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626) 10 3 8 58 1
126329 66815 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 5549 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1991 12:00:00 AM 23   Permit Number 30104 5981379.76984 2111624.63021 37.7770380438887 -122.507973479037 (37.7770380438887, -122.507973479037) 11 6 2 55 26
126852 86860 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 98 Chenery St   Sidewalk: Curb side : Cutout Tree Private 2   10/17/2007 12:00:00 AM   3x3 Permit Number 49749 6004853.9 2097638.4 37.7399903195304 -122.425773341315 (37.7399903195304, -122.425773341315) 2 7 5 63 7
127857 224293 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 319 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   6006573.93081 2097319.18716 37.739210880983 -122.41980352911 (37.739210880983, -122.41980352911) 2 7 7 28859 2
128115 224291 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 3854 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6004797.3465 2100779.67423 37.7486123433069 -122.426192460407 (37.7486123433069, -122.426192460407) 2 4 5 28862 22
129088 224280 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2501 17th St 3 : Tree Private 2     23 Width 6ft   6009642.33079 2106387.76374 37.7642835542582 -122.409834305929 (37.7642835542582, -122.409834305929) 8 4 8 28859 19
130285 185534 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2201 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984898.5449 2100072.3399 37.7455253871304 -122.494949115857 (37.7455253871304, -122.494949115857) 1 8 3 29491 35
133389 32617 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1200 06th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37077 5994262.98001 2106757.29501 37.7644242998742 -122.463053545067 (37.7644242998742, -122.463053545067) 11 5 11 56 12
134546 191803 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 180x Bay Shore Blvd 3 Median : Yard Tree DPW 1     36     6011162.15038 2099563.42906 37.7456304953456 -122.404097342621 (37.7456304953456, -122.404097342621) 10 3 7 58 1
134619 49792 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 8 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/09/2003 12:00:00 AM     Permit Number 46579 6006641.33781708 2109233.21356328 37.7719278473573 -122.420415895386 (37.7719278473573, -122.420415895386) 8 2 9 28853 19
136279 40884 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 130 Santa Marina St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/1999 12:00:00 AM     Permit Number 41791 6006302.5482832 2097469.41994668 37.7396080946336 -122.420752512088 (37.7396080946336, -122.420752512088) 2 7 7 28859 2
136363 252834 Property Tree 8 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 98 Prosper St 2 Sidewalk: Property side : Cutout Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
136931 22108 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 3550 03rd St 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6015960.65745 2099048.08294 37.7444824043839 -122.387468734005 (37.7444824043839, -122.387468734005) 10 3 8 58 1
138229 224297 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 154 College Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 2ft   6004792.40418 2095928.09422 37.7352907307678 -122.42586425823 (37.7352907307678, -122.42586425823) 2 7 5 28861 2
139043 117085 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1415 Howard St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6008287.6 2109783.3 37.7735308884109 -122.414760273118 (37.7735308884109, -122.414760273118) 8 2 9 28853 34
139069 191800 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2 Newhall St 5 : Tree DPW 1   11/12/2014 12:00:00 AM 19 Width 4ft Permit Number 774049 6018580.4534 2097158.49779 37.7394387323227 -122.378278760853 (37.7394387323227, -122.378278760853) 10 3 8 58 1
139106 51638 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 3456 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/12/1991 12:00:00 AM     Permit Number 47929 6005371.85163442 2103157.01504278 37.7551724265056 -122.424374893952 (37.7551724265056, -122.424374893952) 2 4 5 28859 19
139256 32620 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1200 06th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37077 5994260.20201 2106772.57301 37.7644660892521 -122.463064261918 (37.7644660892521, -122.463064261918) 11 5 11 56 12
142229 41739 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 74 Otis St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42178 6006750.47865319 2109297.32010608 37.7721100183826 -122.420042918685 (37.7721100183826, -122.420042918685) 8 2 9 28853 19
142306 209048 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 700 Junipero Serra Blvd 104 : Tree Private 2     15 Width 0ft   5991233.86776 2091994.8214 37.7237153966338 -122.472454001045 (37.7237153966338, -122.472454001045) 9 8 4 64 40
142520 117087 Undocumented 4 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1401 HOWARD ST 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4 Permit Number 778313 6008367 2109860 37.773745949403 -122.414491044326 (37.773745949403, -122.414491044326) 8 2 9 28853 34
143463 189218 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 72 Whitney Young Cir 1 Sidewalk: Curb side : Cutout Tree Private 2     28 Width 4ft   6016946.50299 2094945.88967 37.7332731602285 -122.383774285873 (37.7332731602285, -122.383774285873) 10 3 8 58 1
143759 141612 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 36 LOYOLA TER 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 0ft   5998439.8972 2110934.038 37.7761322903738 -122.448907689979 (37.7761322903738, -122.448907689979) 15 6 2 29492 16
144005 16473 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 9X Newhall St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6018697.2048701 2097076.1109207 37.7392189485182 -122.377869364283 (37.7392189485182, -122.377869364283) 10 3 8 58 1
145277 109907 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1415 Howard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   07/17/2015 10:12:00 AM 9 4x4   6008287.6 2109783.3 37.7735308884109 -122.414760273118 (37.7735308884109, -122.414760273118) 8 2 9 28853 34
145853 224295 Undocumented 4 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 5 Powhattan Ave 2 Sidewalk: Curb side : Pot Tree Private 2     56 Width 3ft   6007477.43589 2098211.10306 37.7417107417539 -122.416742776477 (37.7417107417539, -122.416742776477) 2 7 7 28859 2
146218 8305 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 29 Garlington Ct 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6016787.0658034 2094691.4882739 37.7325658099631 -122.384307797551 (37.7325658099631, -122.384307797551) 10 3 8 58 1
146807 97965 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1626 Shrader St 2 Sidewalk: Property side : Yard Tree Private 2       4x4   5998119.3 2105007.8 37.7598420097441 -122.449589586059 (37.7598420097441, -122.449589586059) 15 5 11 29492 12
150576 199998 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1180 Thomas Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   6016948.5203 2092356.1011 37.7261622225289 -122.383587075969 (37.7261622225289, -122.383587075969) 10 3 8 58 1
152352 199996 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1180 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     33 Width 0ft   6016983.2238 2092322.4993 37.7260718766281 -122.383464768614 (37.7260718766281, -122.383464768614) 10 3 8 58 1
152813 41823 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1536 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 20   Permit Number 42209 6001796.8853 2111541.4809 37.7779915844423 -122.437338492805 (37.7779915844423, -122.437338492805) 15 5 11 29490 41
152986 32621 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1200 06th St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37077 5994249.09101 2107137.85101 37.7654684071637 -122.463129197416 (37.7654684071637, -122.463129197416) 11 5 11 56 12
155338 206338 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 240 Noriega St 4 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 5ft   5993167.12597 2103261.31068 37.7547620531391 -122.466589641618 (37.7547620531391, -122.466589641618) 1 8 4 56 12
156199 41074 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 291 10th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/27/1999 12:00:00 AM     Permit Number 41834 6008813.87859948 2109576.97435199 37.7729939222966 -122.412925200561 (37.7729939222966, -122.412925200561) 8 2 9 28853 34
158610 224288 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1201 San Jose Ave 23 Front Yard : Yard Tree Private 2     26     6004376.51422 2095976.51877 37.7354001818557 -122.427305591801 (37.7354001818557, -122.427305591801) 2 7 5 28861 2
158644 41731 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 8 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/28/2002 12:00:00 AM     Permit Number 42173 6006641.33781708 2109233.21356328 37.7719278473573 -122.420415895386 (37.7719278473573, -122.420415895386) 8 2 9 28853 19
158846 6465 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1200X Evans Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   03/10/2016 02:16:00 PM 3 3X3   6017709.26601 2097062.52601 37.7391271577772 -122.381284304132 (37.7391271577772, -122.381284304132) 10 3 8 58 1
159167 12636 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 901 Lake St 4 Sidewalk: Curb side : Cutout Tree DPW 1     100 3X3   5992666.27399 2114790.89039 37.7863902797856 -122.469160797881 (37.7863902797856, -122.469160797881) 11 6 2 54 11
159192 22179 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 3955X 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/03/1992 12:00:00 AM 12 3X3   6015698.56805 2097858.21385 37.7412007490751 -122.388291965766 (37.7412007490751, -122.388291965766) 10 3 8 58 1
159696 191797 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2501 17th St 10 : Tree Private 2     21 Width 6ft   6009965.75706 2106404.43446 37.7643474484095 -122.408716837108 (37.7643474484095, -122.408716837108) 8 4 8 28859 19
161601 191801 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 200 Jennings St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6018647.97936 2096995.63992 37.7389952784126 -122.378033981578 (37.7389952784126, -122.378033981578) 10 3 8 58 1
161994 32618 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1200 06th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37077 5994258.81301 2106788.54501 37.7645098641835 -122.463070225003 (37.7645098641835, -122.463070225003) 11 5 11 56 12
163092 91151 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 3700 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52033 5999669 2121219 37.8044423086661 -122.44539559761 (37.8044423086661, -122.44539559761) 13 9 1 57 17
164453 119946 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 378 29th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   5986868.87684 2113415.63446 37.7822775279696 -122.489116909676 (37.7822775279696, -122.489116909676) 11 6 2 55 26
168852 137658 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1518 MCALLISTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6001865.8981 2111549.7624 37.7780182464137 -122.437100346499 (37.7780182464137, -122.437100346499) 15 5 11 29490 41
169300 41058 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 220 10th St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1999 12:00:00 AM     Permit Number 41830 6008482.96704788 2109848.1149541 37.7737198300469 -122.41408905371 (37.7737198300469, -122.41408905371) 8 2 9 28853 34
169384 39152 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1201 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40824 6005810.90116687 2101975.65713529 37.751953473746 -122.422772578809 (37.751953473746, -122.422772578809) 2 4 5 28859 19
170369 224287 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1201 San Jose Ave 22 Front Yard : Yard Tree Private 2     31     6004351.28385 2095952.40857 37.7353325537541 -122.427391105628 (37.7353325537541, -122.427391105628) 2 7 5 28861 2
174051 199770 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1197 Thomas Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 0ft   6016938.605 2092287.245 37.7259726090821 -122.383616561306 (37.7259726090821, -122.383616561306) 10 3 8 58 1
174213 41882 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 760 Duboce Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 26 6x12 Permit Number 42257 6001968.48686842 2108291.49196596 37.7690776786131 -122.436512186736 (37.7690776786131, -122.436512186736) 15 5 5 29492 9
174570 1765 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2000X Bay Shore Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1   01/18/1991 12:00:00 AM 36 3X3   6012375.8565272 2088505.2474917 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859) 10 7 8 309 39
174967 1856 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2500 Bay Shore Blvd 3 Median : Cutout Tree DPW 1     12 6   6010837.5147418 2086759.4488697 37.7104552954566 -122.404318844881 (37.7104552954566, -122.404318844881) 9 7 8 309 39
176286 224298 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 470 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6000648.58117 2101290.67644 37.7497800626022 -122.440575450118 (37.7497800626022, -122.440575450118) 2 4 5 28862 22
176704 23409 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1748X Van Ness Ave 5 Median : Cutout Tree DPW 1     30 9   6006150.92127 2116485.89798 37.7918142959375 -122.422627760962 (37.7918142959375, -122.422627760962) 13 9 10 28858 21
176935 12081 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1261X La Salle Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1   12/16/1992 12:00:00 AM 18 3X3   6017141.6501925 2094501.7221284 37.732064349457 -122.383068698568 (37.732064349457, -122.383068698568) 10 3 8 58 1
177955 41881 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 760 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 26 6x9 Permit Number 42257 6001968.48686842 2108291.49196596 37.7690776786131 -122.436512186736 (37.7690776786131, -122.436512186736) 15 5 5 29492 9
178688 23886 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1750X Geary Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     19 3X3   6003218.9262 2113924.0949 37.784614384352 -122.432589384494 (37.784614384352, -122.432589384494) 13 9 11 29490 13
180922 12622 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 814 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1     140 4x5   5992940.70683 2114858.78084 37.7865925418668 -122.468216278652 (37.7865925418668, -122.468216278652) 11 6 1 54 11
181853 206337 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 240 Noriega St 3 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 5ft   5993194.55658 2103260.73418 37.7547620531274 -122.466494737945 (37.7547620531274, -122.466494737945) 1 8 4 56 12
182024 1768 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2000X Bay Shore Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1   01/28/1991 12:00:00 AM 24 3X3   6012375.8565272 2088505.2474917 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859) 10 7 8 309 39
183395 200916 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 3801 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 0ft   6015698.5199 2097861.9006 37.741210869467 -122.388292389499 (37.741210869467, -122.388292389499) 10 3 8 58 1
183841 252835 Property Tree 8 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 98 Prosper St 3 Sidewalk: Property side : Cutout Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
185341 247229 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 760 Duboce Ave 1 Sidewalk: Curb side : Yard Tree Private 2     16 Width 7ft   6002065.37798 2108297.71243 37.7691002638038 -122.436177491895 (37.7691002638038, -122.436177491895) 15 5 5 29492 9
186307 224284 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2501 17th St 8 : Tree Private 2     16 Width 6ft   6009837.11194 2106398.45896 37.7643238348958 -122.409161364832 (37.7643238348958, -122.409161364832) 8 4 8 28859 19
186720 16472 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 9X Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6018697.2048701 2097076.1109207 37.7392189485182 -122.377869364283 (37.7392189485182, -122.377869364283) 10 3 8 58 1
186911 8304 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 29 Garlington Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6016787.0658034 2094691.4882739 37.7325658099631 -122.384307797551 (37.7325658099631, -122.384307797551) 10 3 8 58 1
188558 32614 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1200 06th St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37077 5994256.73001 2106919.79501 37.7648701224233 -122.463086953252 (37.7648701224233, -122.463086953252) 11 5 11 56 12
188901 32615 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1200 06th St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37077 5994249.78501 2107086.46201 37.7653273463851 -122.463123068037 (37.7653273463851, -122.463123068037) 11 5 11 56 12
189569 252838 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 99 Pond St 1 Sidewalk: Property side : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
189589 206335 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 240 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 5ft   5993241.59075 2103263.05843 37.7547711488889 -122.466332251156 (37.7547711488889, -122.466332251156) 1 8 4 56 12
190323 224282 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2501 17th St 5 : Tree Private 2     16 Width 6ft   6009723.18225 2106391.67839 37.7642988337404 -122.40955493871 (37.7642988337404, -122.40955493871) 8 4 8 28859 19
191133 26012 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1618X Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree Arts Commission 19   01/02/1998 12:00:00 AM 3 3X3   6015044.019 2095518.8416 37.7347410214535 -122.390391768412 (37.7347410214535, -122.390391768412) 10 3 8 58 1
191417 41732 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 12 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42174 6006619.94296634 2109255.47423685 37.7719877641792 -122.420491482272 (37.7719877641792, -122.420491482272) 8 2 9 28853 19
192138 39151 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1201 Guerrero St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40824 6005810.90116687 2101975.65713529 37.751953473746 -122.422772578809 (37.751953473746, -122.422772578809) 2 4 5 28859 19
192868 224279 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2501 17th St 2 : Tree Private 2     18 Width 6ft   6009600.88418 2106385.57449 37.7642752202394 -122.409977504072 (37.7642752202394, -122.409977504072) 8 4 8 28859 19
193142 101457 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 102 Henry Adams St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6011370.61745 2107778.3214 37.7681984164403 -122.403954480835 (37.7681984164403, -122.403954480835) 8 2 8 28853 20
193175 41057 Permitted Site 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 220 10th St 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1999 12:00:00 AM     Permit Number 41830 6008482.96704788 2109848.1149541 37.7737198300469 -122.41408905371 (37.7737198300469, -122.41408905371) 8 2 9 28853 34
194190 176352 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2004 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6012299.5158 2088325.62529 37.714837293886 -122.399375702234 (37.714837293886, -122.399375702234) 10 7 8 309 39

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)
);