home / trees

Street_Tree_List

Data source: data.sfgov.org

423 rows where qSpecies = 98

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PermitNotes, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
754 100845 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 1 Estero Ave 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
886 101027 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1010X Portola Dr 1 Front Yard : Yard 4 Tree 1 DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
887 101028 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1010X Portola Dr 2 Front Yard : Yard 4 Tree 1 DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
890 101030 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1010X Portola Dr 4 Median : Yard 11 Tree 1 DPW 1     40     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
892 101032 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1010X Portola Dr 6 Front Yard : Yard 4 Tree 1 DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
895 101035 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1010X Portola Dr 9 Front Yard : Yard 4 Tree 1 DPW 1   09/03/2014 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
2526 102839 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 1101X Portola Dr 2 Sidewalk: Property side : Yard 5 Tree 1 DPW 1                              
5133 105838 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 39X Bonview St 1 Front Yard : Yard 4 Tree 1 DPW 1     15     6007716.90579 2099172.4114099997 37.7443637468546 -122.415982827151 (37.7443637468546, -122.415982827151) 2 7 7 28859 2
6336 107347 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1126X PORTOLA DR 1 Median : Cutout 1 Tree 1 DPW 1     68     5994964.0 2098019.0 37.7404715144277 -122.459995857341 (37.7404715144277, -122.459995857341) 1 8 4 59 40
6431 107448 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1111x Chestnut St 8 Unaccepted Street : Yard 13 Tree 1 Private 2     50     6006408.68895 2120404.8626200003 37.80258932431129 -122.42201440535801 (37.8025893243113, -122.422014405358) 5 9 1 28858 32
6432 107449 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 1130x CHESTNUT ST 1 Unaccepted Street : Yard 13 Tree 1 Private 2     60     6006351.9 2120450.9 37.802712528214705 -122.42221419659701 (37.8027125282147, -122.422214196597) 5 9 1 28858 32
6434 107450 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1140x Chestnut St 1 Unaccepted Street : Yard 13 Tree 1 Private 2     60     6006380.05181 2120425.48408 37.802644330436394 -122.42211497023399 (37.8026443304364, -122.422114970234) 5 9 1 28858 32
6458 107487 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1306x Montgomery St 12 Median : Cutout 1 Tree 1 DPW 1     23     6011454.1798 2119912.99001 37.801522030487 -122.40451973891001 (37.801522030487, -122.40451973891) 3 1 10 308 23
6464 107492 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1306x Montgomery St 21 Median : Cutout 1 Tree 1 DPW 1     26     6011443.89272 2119983.46704 37.80171496831821 -122.404560301033 (37.8017149683182, -122.404560301033) 3 1 10 308 23
7489 108605 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 1140x CHESTNUT ST 2 Unaccepted Street : Yard 13 Tree 1 Private 2           6006369.1 2120452.7 37.802718440704204 -122.42215480373899 (37.8027184407042, -122.422154803739) 5 9 1 28858 32
8482 109625 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 312x FILBERT ST 1 Unaccepted Street : Yard 13 Tree 1 Private 2     14     6011362.9 2120079.8 37.801974948341 -122.40484736081001 (37.801974948341, -122.40484736081) 3 1 10 308 23
8638 109838 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 200x MONTCALM ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     30 3x3   6009924.0 2099647.0 37.745790704819704 -122.408384592716 (37.7457907048197, -122.408384592716) 2 7 7 28859 2
8825 110143 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1130X PORTOLA DR 3 Sidewalk: Curb side : Yard 7 Tree 1 DPW 1       3x3   5994964.0 2098019.0 37.7404715144277 -122.459995857341 (37.7404715144277, -122.459995857341) 1 8 4 59 40
8829 110147 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 90 WOODLAND AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     46 4x15   5997155.9 2105983.7 37.762466422316706 -122.452991942132 (37.7624664223167, -122.452991942132) 15 5 11 29492 12
8830 110148 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 90 WOODLAND AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     38 4x9   5997155.9 2105983.7 37.762466422316706 -122.452991942132 (37.7624664223167, -122.452991942132) 15 5 11 29492 12
9030 110396 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 1x ARLETA AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x30   6011055.0 2087587.0 37.7127397354919 -122.403625353192 (37.7127397354919, -122.403625353192) 9 7 8 309 39
9031 110397 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 2200 BAY SHORE BLVD 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x30   6011234.0 2087411.0 37.7122664722191 -122.40299429708999 (37.7122664722191, -122.40299429709) 9 7 8 309 39
9776 111179 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 400 NORTH POINT ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/01/2016 12:00:00 AM 3 9x6   6008572.0 2121805.0 37.806555520543 -122.41462738080799 (37.806555520543, -122.414627380808) 3 1 10 308 23
9865 111263 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 700X BOSWORTH ST 1 Front Yard : Yard 4 Tree 1 DPW 1     36     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
9884 111280 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 700X BOSWORTH ST 18 Front Yard : Cutout 10 Tree 1 DPW 1     48     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
9885 111281 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 700X BOSWORTH ST 19 Front Yard : Yard 4 Tree 1 DPW 1     48     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
10064 111506 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 800x BOSWORTH ST 1 Front Yard : Yard 4 Tree 1 DPW 1     48     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
10076 111517 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 800x BOSWORTH ST 12 Front Yard : Yard 4 Tree 1 DPW 1     36     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
10077 111518 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 800x BOSWORTH ST 13 Front Yard : Yard 4 Tree 1 DPW 1     27     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
10078 111519 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 800x BOSWORTH ST 14 Front Yard : Yard 4 Tree 1 DPW 1     36     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
10081 111521 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 800x BOSWORTH ST 16 Front Yard : Yard 4 Tree 1 DPW 1     36     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
10082 111522 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 800x BOSWORTH ST 17 Front Yard : Yard 4 Tree 1 DPW 1     20     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
10083 111523 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 900x BOSWORTH ST 1 Front Yard : Yard 4 Tree 1 DPW 1     28     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
10084 111524 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 900x BOSWORTH ST 2 Front Yard : Yard 4 Tree 1 DPW 1     28     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
13374 115152 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 245x ARLINGTON ST 1 Median : Yard 11 Tree 1 DPW 1     30 3x3   6004671.0 2096632.0 37.737216635749604 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
13375 115153 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 245x ARLINGTON ST 2 Median : Yard 11 Tree 1 DPW 1       3x3   6004671.0 2096632.0 37.737216635749604 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
13376 115154 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 245x ARLINGTON ST 3 Median : Yard 11 Tree 1 DPW 1       3x3   6004671.0 2096632.0 37.737216635749604 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
13377 115155 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 245x ARLINGTON ST 4 Median : Yard 11 Tree 1 DPW 1       3x3   6004671.0 2096632.0 37.737216635749604 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
13378 115156 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 245x ARLINGTON ST 5 Median : Yard 11 Tree 1 DPW 1       3x3   6004671.0 2096632.0 37.737216635749604 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
13464 115235 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 58 21st Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/29/2016 12:00:00 AM 3 4x6 Permit Number 777338 5989295.302490001 2114868.10873 37.7864069399285 -122.480829025898 (37.7864069399285, -122.480829025898) 11 6 1 55 33
13782 115556 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 3897 CLAY ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5996199.0 2115222.0 37.7877774871206 -122.456969730492 (37.7877774871206, -122.456969730492) 11 6 1 54 31
15108 116956 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 380 SAN JOSE AVE 1 Front Yard : Cutout 10 Tree 1 Private 2     28 3x3   6006172.0 2100967.0 37.7492042995658 -122.421452219126 (37.7492042995658, -122.421452219126) 2 4 5 28859 19
15149 116996 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 606x FULTON ST   Front Yard : Yard 4 Tree 1 Private 2   09/29/2016 12:00:00 AM 3     6004628.0 2111737.0 37.7786889706302 -122.42755859051901 (37.7786889706302, -122.427558590519) 7 9 11 28852 41
15410 117251 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 2500x 34TH AVE 1 Side Yard : Yard 27 Tree 1 SFUSD 4       3x3   5985829.0 2097874.0 37.73954376030179 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
15411 117252 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 2500x 34TH AVE 2 Side Yard : Yard 27 Tree 1 SFUSD 4       3x3   5985829.0 2097874.0 37.73954376030179 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
15412 117253 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 2500x 34TH AVE 3 Side Yard : Yard 27 Tree 1 SFUSD 4       3x3   5985829.0 2097874.0 37.73954376030179 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
15445 117289 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 26X GLADEVIEW WAY 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2       3x3   5997876.0 2101605.0 37.7504848455829 -122.45018576131201 (37.7504848455829, -122.450185761312) 1 5 4 63 38
15786 117645 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 2901 21ST AVE 1 Back Yard : Yard 6 Tree 1 Private 2       3x3   5989904.0 2095901.0 37.734363711699 -122.477336418651 (37.734363711699, -122.477336418651) 1 8 4 64 35
16332 118274 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 801 37th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     31 Width 3ft   5984451.13428 2110349.39905 37.7737171157491 -122.497254676861 (37.7737171157491, -122.497254676861) 11 6 2 55 26
16802 119052 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 539 44th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 Width 4ft   5982216.76848 2112075.96454 37.7783265569214 -122.50511154623399 (37.7783265569214, -122.505111546234) 11 6 2 55 26
18332 120921 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 3995X Alemany Blvd 4 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
18335 120924 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 3995X Alemany Blvd 7 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
18337 120926 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 3995X Alemany Blvd 9 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
18340 120929 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 3995X Alemany Blvd 12 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
18344 120932 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 3995X Alemany Blvd 15 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
18345 120933 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 3995X Alemany Blvd 16 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
18346 120934 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 3995X Alemany Blvd 17 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
18348 120936 Significant Tree 4 Pinus pinea :: Italian Stone Pine 98 3995X Alemany Blvd 19 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
18503 121082 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 24X KEMPTON AVE 6 Side Yard : Yard 27 Tree 1 DPW 1       30x30   5992274.0 2087683.0 37.7119363308651 -122.46854490041599 (37.7119363308651, -122.468544900416) 9 8 4 64 24
18811 121406 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 10X Dorchester Way 2 Median : Cutout 1 Tree 1 DPW 1       8x30   5994075.0 2098171.0 37.740837698438895 -122.463080674317 (37.7408376984389, -122.463080674317) 1 8 4 59 40
19096 121695 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 1300x De Haro St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6012218.0 2102254.0 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
19097 121696 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 1300x De Haro St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6012218.0 2102254.0 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
19098 121697 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 1300x De Haro St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6012218.0 2102254.0 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
27570 12967 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 99X Lippard Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     30 3X3   6001957.7757889 2095598.483465 37.734225095766796 -122.43564102376301 (37.7342250957668, -122.435641023763) 2 7 5 63 7
27581 12968 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 99X Lippard Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     36 4X4   6001957.7757889 2095598.483465 37.734225095766796 -122.43564102376301 (37.7342250957668, -122.435641023763) 2 7 5 63 7
27592 12969 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 99X Lippard Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     36 3X4   6001957.7757889 2095598.483465 37.734225095766796 -122.43564102376301 (37.7342250957668, -122.435641023763) 2 7 5 63 7
27604 12970 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 99X Lippard Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     36 5X4   6001957.7757889 2095598.483465 37.734225095766796 -122.43564102376301 (37.7342250957668, -122.435641023763) 2 7 5 63 7
27646 12974 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 84 Lippard Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     24 3X3   6001901.0890899 2095580.5218873 37.734172557472604 -122.43583572272101 (37.7341725574726, -122.435835722721) 2 7 5 63 7
30209 1321 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 4050X Alemany Blvd 7 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     75 TR   5991740.4279021 2087082.0100679002 37.710255321179204 -122.470345319704 (37.7102553211792, -122.470345319704) 9 8 4 64 24
30288 132173 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 91 Mayfair Dr 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     15 Width 6ft   5997717.35609 2114490.42899 37.7858558611085 -122.45166373928998 (37.7858558611085, -122.45166373929) 15 6 1 54 31
30289 132174 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1111 Chestnut St 1 Front Yard : Yard 4 Tree 1 Private 2     52     6006441.86345 2120416.15353 37.8026221972261 -122.42190040728998 (37.8026221972261, -122.42190040729) 5 9 1 28858 32
30290 132175 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1100 Chestnut St 3 Front Yard : Yard 4 Tree 1 Private 2     49     6006452.3729 2120433.08861 37.8026692893229 -122.421865242911 (37.8026692893229, -122.421865242911) 5 9 1 28858 32
30291 132176 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 2745 Larkin St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     14     6006527.83964 2120663.1294 37.8033051783476 -122.421620437537 (37.8033051783476, -122.421620437537) 5 9 1 28858 32
30292 132177 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1048 Union St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     4 Width 3ft   6007888.26555 2119276.18895 37.7995736051877 -122.41681430495701 (37.7995736051877, -122.416814304957) 5 1 1 308 32
30293 132178 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 2449 Mason St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     36     6008741.74811 2122071.6365799997 37.807297172691 -122.41405880917101 (37.807297172691, -122.414058809171) 3 1 10 308 23
30294 132179 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1302 Columbus Ave 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     33     6007259.6989400005 2121860.7667900003 37.806634826503604 -122.419172811197 (37.8066348265036, -122.419172811197) 5 1 1 28858 32
30296 132180 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1302 Columbus Ave 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     26     6007242.786309999 2121872.67886 37.8066665815484 -122.419232186229 (37.8066665815484, -122.419232186229) 5 1 1 28858 32
30297 132181 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1302 Columbus Ave 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     21     6007227.55341 2121889.28804 37.8067113282286 -122.41928608168699 (37.8067113282286, -122.419286081687) 5 1 1 28858 32
30298 132182 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 601 Beach St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     24 Width 5ft   6007241.6557599995 2121894.78138 37.8067272057567 -122.419237667598 (37.8067272057567, -122.419237667598) 5 1 1 28858 32
30299 132183 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1306x Montgomery St 23 Median : Yard 11 Tree 1 DPW 1     26 Width 8ft   6011446.11989 2119998.19994 37.801755545737294 -122.404553631656 (37.8017555457373, -122.404553631656) 3 1 10 308 23
30300 132184 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1306x Montgomery St 25 Median : Yard 11 Tree 1 DPW 1     29 Width 8ft   6011444.3716 2120015.20461 37.8018021387065 -122.404560879294 (37.8018021387065, -122.404560879294) 3 1 10 308 23
30301 132185 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1306x Montgomery St 32 Median : Yard 11 Tree 1 DPW 1     31 Width 8ft   6011428.32338 2120121.70557 37.8020936674502 -122.40462391547301 (37.8020936674502, -122.404623915473) 3 1 10 308 23
30302 132186 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1306x Montgomery St 34 Median : Yard 11 Tree 1 DPW 1     20 Width 8ft   6011427.6635300005 2120140.5117900004 37.8021452678603 -122.404627523539 (37.8021452678603, -122.404627523539) 3 1 10 308 23
30303 132187 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1306x Montgomery St 40 Median : Yard 11 Tree 1 DPW 1     14 Width 8ft   6011421.2833 2120182.68985 37.8022607219264 -122.404652573264 (37.8022607219264, -122.404652573264) 3 1 10 308 23
30304 132188 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1306x Montgomery St 42 Median : Yard 11 Tree 1 DPW 1     17 Width 8ft   6011420.08981 2120201.09522 37.802311191872896 -122.404657999787 (37.8023111918729, -122.404657999787) 3 1 10 308 23
30305 132189 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1306x Montgomery St 43 Median : Yard 11 Tree 1 DPW 1     12 Width 8ft   6011411.367980001 2120233.14388 37.802398702198204 -122.404690439238 (37.8023987021982, -122.404690439238) 3 1 10 308 23
30307 132190 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1306x Montgomery St 44 Median : Yard 11 Tree 1 DPW 1     15 Width 8ft   6011409.46246 2120250.86119 37.802447243101 -122.40469828132 (37.802447243101, -122.40469828132) 3 1 10 308 23
32288 13401 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 344 Marietta Dr 1 Median : Cutout 1 Tree 1 DPW 1     70 5   5999579.163416 2097433.156503 37.739127283554204 -122.443996396446 (37.7391272835542, -122.443996396446) 9 7 4 59 40
39745 141265 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 52 JORDAN AVE 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     12 Width 0ft   5996227.2891 2114192.1724 37.7849514808139 -122.45679734575899 (37.7849514808139, -122.456797345759) 11 6 1 54 31
44521 16362 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1306X Montgomery St 14 Median : Cutout 1 Tree 1 DPW 1     18 8   6011452.97865 2119928.00722 37.801563196957204 -122.40452495315901 (37.8015631969572, -122.404524953159) 3 1 10 308 23
44522 16363 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1300X Montgomery St 16 Median : Cutout 1 Tree 1 DPW 1     12 8   6011500.916866099 2119743.0722499 37.8010580895294 -122.404346040012 (37.8010580895294, -122.404346040012) 3 1 10 308 23
44523 16364 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1300X Montgomery St 17 Median : Cutout 1 Tree 1 DPW 1     12 8   6011500.916866099 2119743.0722499 37.8010580895294 -122.404346040012 (37.8010580895294, -122.404346040012) 3 1 10 308 23
44527 16368 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1400X Montgomery St 1 Median : Cutout 1 Tree 1 DPW 1     26 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
44528 16369 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1400X Montgomery St 2 Median : Cutout 1 Tree 1 DPW 1     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
44530 16370 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1400X Montgomery St 3 Median : Cutout 1 Tree 1 DPW 1     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
44531 16371 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1400X Montgomery St 4 Median : Cutout 1 Tree 1 DPW 1     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
44532 16372 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1400X Montgomery St 5 Median : Cutout 1 Tree 1 DPW 1     12 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
44533 16373 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1400X Montgomery St 6 Median : Cutout 1 Tree 1 DPW 1     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
44534 16374 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1400X Montgomery St 7 Median : Cutout 1 Tree 1 DPW 1     12 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
45651 173727 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 958 Carolina St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     9 3x3   6012430.0 2103470.0 37.7564278519739 -122.39998757117701 (37.7564278519739, -122.399987571177) 10 3 8 28856 29

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 35.589ms · Data source: data.sfgov.org