438 rows where qSpecies_id = 63 sorted by qLegalStatus_id

View and edit SQL

Neighborhoods (old)

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)
133 211075 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 650x Miramar Ave 6 Median : Yard Tree DPW 1     34     5995390.83549 2093912.64173 37.7292209976493 -122.458222905073 (37.7292209976493, -122.458222905073) 9 7 4 28861 40
954 20324 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
2009 201784 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 32 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015541.73553 2087974.13978 37.7140523566047 -122.388144625001 (37.7140523566047, -122.388144625001) 10 3 8 58 1
2047 20346 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 32 Sidewalk: Curb side : Cutout Tree DPW 1     18 40                      
2154 234510 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101 San Jose Ave 20 Front Yard : Yard Tree Private 2     15     6004874.94559 2096454.63294 37.7367411519672 -122.425616344829 (37.7367411519672, -122.425616344829) 2 7 5 28859 2
2394 184349 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1251 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     28 Width 0ft   5984659.3559 2106454.1603 37.7630340956965 -122.496246960605 (37.7630340956965, -122.496246960605) 1 8 3 56 35
3008 251503 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800X Bosworth St 15 Side Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
3556 20340 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 27 Sidewalk: Curb side : Cutout Tree DPW 1     48 40                      
5675 261201 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 699x Benton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007339 2095419 37.7340364554683 -122.417023656077 (37.7340364554683, -122.417023656077) 2 7 7 28859 2
5800 98837 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 9 Sidewalk: Property side : Yard Tree DPW 1                              
5956 98839 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 4 Sidewalk: Property side : Yard Tree DPW 1                              
6140 243478 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1499X Eugenia Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   6008755.36846 2097659.39973 37.7402676797185 -122.412285110476 (37.7402676797185, -122.412285110476) 10 7 7 28859 2
6278 132178 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2449 Mason St 1 Sidewalk: Property side : Yard Tree Private 2     36     6008741.74811 2122071.63658 37.807297172691 -122.414058809171 (37.807297172691, -122.414058809171) 3 1 10 308 23
7002 262493 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 2 Median : Yard Tree Private 2       10x10   5995372 2097783 37.7398469739468 -122.458568082407 (37.7398469739468, -122.458568082407) 9 7 4 59 40
7308 20330 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 18 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
7554 201736 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 5 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015525.30693 2087693.56377 37.7132810386533 -122.38818183984 (37.7132810386533, -122.38818183984) 10 3 8 58 1
7702 262097 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 10x Cuesta Ct 1 Unaccepted Street : Yard Tree DPW 1 Private     3x3   5999757 2101744 37.7509739685765 -122.443691128062 (37.7509739685765, -122.443691128062) 2 5 5 63 38
7987 20066 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 100 STAIRWAY54 13 Sidewalk: Curb side : Cutout Tree DPW 1     6 15ST                      
8061 20397 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 262X Sunset Blvd 42 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
8123 16369 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 2 Median : Cutout Tree DPW 1     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
8532 19778 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 100 STAIRWAY18 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 50ST                      
9224 132190 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 44 Median : Yard Tree DPW 1     15 Width 8ft   6011409.46246 2120250.86119 37.802447243101 -122.40469828132 (37.802447243101, -122.40469828132) 3 1 10 308 23
9305 251160 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 1 Median : Cutout Tree DPW 1 Private     3x3   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
9886 20336 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 23 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
10043 264733 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1367 De Haro St   Median : Cutout Tree DPW 1       3x3   6012260 2102130 37.7527390251575 -122.400481372119 (37.7527390251575, -122.400481372119) 10 3 8 28856 29
10438 262492 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 1 Median : Yard Tree Private 2       10x10   5995372 2097783 37.7398469739468 -122.458568082407 (37.7398469739468, -122.458568082407) 9 7 4 59 40
10520 20335 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 22 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
11326 186595 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 66 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984740.8383 2104479.6291 37.7576173573885 -122.49581948315 (37.7576173573885, -122.49581948315) 1 8 3 56 35
11808 247102 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 20 Front Yard : Yard Tree Private 2     35     6002745.76405 2098754.96889 37.7429368028052 -122.43314215589 (37.7429368028052, -122.43314215589) 2 7 5 63 22
12042 201792 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 40 Sidewalk: Property side : Yard Tree Private 2     22 Width 8ft   6015451.0989 2088156.51994 37.7145481150837 -122.388470624731 (37.7145481150837, -122.388470624731) 10 3 8 58 1
12407 115154 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 245x ARLINGTON ST 3 Median : Yard Tree DPW 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
12450 261565 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 26th St 2 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013146 2101521 37.7511162126671 -122.39737469907 (37.7511162126671, -122.39737469907) 10 3 8 28856 1
12567 211070 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500x Miramar Ave 7 Median : Yard Tree DPW 1     24     5995378.92982 2093188.43217 37.7272318087773 -122.458211668947 (37.7272318087773, -122.458211668947) 9 7 4 28861 40
12952 20300 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 50X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
13465 20460 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 495X Sunset Blvd 25 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
14391 194472 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 84 Whitney Young Cir 5 Sidewalk: Property side : Yard Tree Private 2     16     6016745.33826 2095063.00852 37.7335836232886 -122.384477928938 (37.7335836232886, -122.384477928938) 10 3 8 58 1
14475 20345 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 31 Sidewalk: Curb side : Cutout Tree DPW 1     42 40                      
15519 262098 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 10x Cuesta Ct 2 Unaccepted Street : Yard Tree DPW 1 Private     3x3   5999757 2101744 37.7509739685765 -122.443691128062 (37.7509739685765, -122.443691128062) 2 5 5 63 38
15787 12969 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 99X Lippard Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     36 3X4   6001957.7757889 2095598.483465 37.7342250957668 -122.435641023763 (37.7342250957668, -122.435641023763) 2 7 5 63 7
16186 186101 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984808.9821 2101715.6546 37.7500322370685 -122.495379978089 (37.7500322370685, -122.495379978089) 1 8 3 29491 35
16263 20326 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 14 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
16552 261549 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3101 Sunset Blvd 1 Median : Cutout Tree Private 2       3x3   5984952 2094961 37.7314941488449 -122.494387573147 (37.7314941488449, -122.494387573147) 1 8 4 64 35
17195 194439 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 32 Median : Yard Tree DPW 1     12     6012481.17054 2103301.60211 37.7559683209947 -122.3997987802 (37.7559683209947, -122.3997987802) 10 3 8 28856 29
17261 261487 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 2 Median : Cutout Tree DPW 1 Private     3x3   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
17691 107448 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1111x Chestnut St 8 Unaccepted Street : Yard Tree Private 2     50     6006408.68895 2120404.86262 37.8025893243113 -122.422014405358 (37.8025893243113, -122.422014405358) 5 9 1 28858 32
17861 201752 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 491 Jamestown Ave 4 Sidewalk: Property side : Yard Tree Private 2     25 Width 8ft   6015886.86298 2086978.1992 37.7113368105223 -122.386882306895 (37.7113368105223, -122.386882306895) 10 3 8 58 1
18973 233322 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 51 Prentiss St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008884.18383 2098343.89419 37.7421543791283 -122.411888074199 (37.7421543791283, -122.411888074199) 10 7 7 28859 2
19749 234503 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1000 San Jose Ave 39 Front Yard : Yard Tree Private 2     2     6005117.95051 2097175.77056 37.7387349615553 -122.424827458621 (37.7387349615553, -122.424827458621) 2 7 5 63 7
20177 187394 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5985039.81 2100667.7899 37.7471685994587 -122.494504537591 (37.7471685994587, -122.494504537591) 1 8 3 29491 35
20635 201770 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 18 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6015634.53236 2087578.56705 37.712971331023 -122.387796296857 (37.712971331023, -122.387796296857) 10 3 8 58 1
20818 247070 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 6 Front Yard : Yard Tree Private 2     24     6002744.91385 2098422.48032 37.7420238182333 -122.433121344697 (37.7420238182333, -122.433121344697) 2 7 5 63 22
20964 217820 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1x Junipero Serra Blvd 7 Median : Yard Tree DPW 1     3     5991627.31768 2095659.97546 37.7338017601455 -122.471360849935 (37.7338017601455, -122.471360849935) 1 8 4 59 40
21065 201733 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 2 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   6015510.4184 2087766.77172 37.7134812286504 -122.388238406274 (37.7134812286504, -122.388238406274) 10 3 8 58 1
21400 186097 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 43 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984866.2826 2101735.8043 37.7500909175156 -122.495183318527 (37.7500909175156, -122.495183318527) 1 8 3 29491 35
22210 111263 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 700X BOSWORTH ST 1 Front Yard : Yard Tree DPW 1     36     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
22573 105838 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 39X Bonview St 1 Front Yard : Yard Tree DPW 1     15     6007716.90579 2099172.41141 37.7443637468546 -122.415982827151 (37.7443637468546, -122.415982827151) 2 7 7 28859 2
22712 101030 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1010X Portola Dr 4 Median : Yard Tree DPW 1     40     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
22744 132175 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100 Chestnut St 3 Front Yard : Yard Tree Private 2     49     6006452.3729 2120433.08861 37.8026692893229 -122.421865242911 (37.8026692893229, -122.421865242911) 5 9 1 28858 32
22926 251501 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800X Bosworth St 13 Side Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
23165 201759 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 7 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6015719.97269 2087309.22701 37.712236507578 -122.387482205949 (37.712236507578, -122.387482205949) 10 3 8 58 1
25472 201732 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 1 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015480.18133 2087865.40702 37.713750386735 -122.388349797223 (37.713750386735, -122.388349797223) 10 3 8 58 1
25951 201761 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 9 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6015680.02756 2087378.65264 37.7124249245429 -122.387625110022 (37.7124249245429, -122.387625110022) 10 3 8 58 1
26810 16373 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 6 Median : Cutout Tree DPW 1     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
27135 194470 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 84 Whitney Young Cir 3 Sidewalk: Property side : Yard Tree Private 2     16     6016764.11928 2095038.85548 37.7335183423928 -122.384411315236 (37.7335183423928, -122.384411315236) 10 3 8 58 1
28006 211079 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2319 Funston Ave 1 Sidewalk: Curb side : Yard Tree Private 2     19 Width 3ft   5992294.50858 2099658.84702 37.7448202223807 -122.469345163475 (37.7448202223807, -122.469345163475) 1 8 4 29491 40
28620 211073 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 602x Miramar Ave 5 Median : Yard Tree DPW 1     26     5995385.83715 2093544.41078 37.7282096371561 -122.458213544022 (37.7282096371561, -122.458213544022) 9 7 4 28861 40
28896 101032 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1010X Portola Dr 6 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
29047 194457 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 32 Sidewalk: Property side : Yard Tree Private 2     30     6012708.71911 2101842.22219 37.7519738634013 -122.398909414543 (37.7519738634013, -122.398909414543) 10 3 8 28856 29
30931 211072 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 602x Miramar Ave 2 Median : Yard Tree DPW 1     35     5995382.34021 2093429.07469 37.7278927511259 -122.458217288807 (37.7278927511259, -122.458217288807) 9 7 4 28861 40
31868 13401 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 344 Marietta Dr 1 Median : Cutout Tree DPW 1     70 5   5999579.163416 2097433.156503 37.7391272835542 -122.443996396446 (37.7391272835542, -122.443996396446) 9 7 4 59 40
31995 201737 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 6 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6015529.27451 2087676.75764 37.7132351120852 -122.38816695425 (37.7132351120852, -122.38816695425) 10 3 8 58 1
32167 201766 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 14 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6015647.69731 2087483.94989 37.7127122597387 -122.387744196458 (37.7127122597387, -122.387744196458) 10 3 8 58 1
32405 246702 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1 Bonview St 8 Sidewalk: Curb side : Yard Tree Private 2     15     6007696.68665 2099102.86041 37.7441716385189 -122.416047816374 (37.7441716385189, -122.416047816374) 2 7 7 28859 2
32960 121406 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 10X Dorchester Way 2 Median : Cutout Tree DPW 1       8x30   5994075 2098171 37.7408376984389 -122.463080674317 (37.7408376984389, -122.463080674317) 1 8 4 59 40
33573 107492 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 21 Median : Cutout Tree DPW 1     26     6011443.89272 2119983.46704 37.8017149683182 -122.404560301033 (37.8017149683182, -122.404560301033) 3 1 10 308 23
33872 186702 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1401 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     23 Width 0ft   5984718.4366 2105146.0279 37.7594457908807 -122.495946116181 (37.7594457908807, -122.495946116181) 1 8 3 56 35
34697 194442 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 51 Median : Yard Tree DPW 1     24     6012500.2858 2102979.92319 37.7550861265451 -122.399710087265 (37.7550861265451, -122.399710087265) 10 3 8 28856 29
34962 184744 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984688.1718 2106200.1767 37.7623384159342 -122.496128558374 (37.7623384159342, -122.496128558374) 1 8 3 56 35
35868 24283 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 300X Winding Way 21 Median : Cutout Tree DPW 1     6 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117) 9 7 6 28861 5
37115 194449 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 23 Median : Yard Tree DPW 1     23     6012259.688 2102130.23115 37.7527396424455 -122.400482467314 (37.7527396424455, -122.400482467314) 10 3 8 28856 29
37367 194451 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 930 Kansas St 1 Front Yard : Yard Tree Private 2     29     6011573.12502 2104017.28324 37.7578827599862 -122.402989455212 (37.7578827599862, -122.402989455212) 10 3 8 28856 29
38128 201734 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 3 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015517.44938 2087731.03371 37.71338348853 -122.388211611887 (37.71338348853, -122.388211611887) 10 3 8 58 1
38246 111524 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x BOSWORTH ST 2 Front Yard : Yard Tree DPW 1     28     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
38282 21135 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2292X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     12     5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696 (37.7442358239277, -122.49474388696) 1 8 3 29491 35
38402 194467 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Quint St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   6012416.6749 2095223.97206 37.7337852773717 -122.399454760738 (37.7337852773717, -122.399454760738) 10 3 8 58 1
39195 201740 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 9 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015542.0778 2087585.57887 37.7129854620959 -122.388116342205 (37.7129854620959, -122.388116342205) 10 3 8 58 1
39844 185075 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2801 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985040.8539 2096108.9226 37.7346512389504 -122.494164969235 (37.7346512389504, -122.494164969235) 1 8 3 29491 35
40232 194448 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 32 Median : Yard Tree DPW 1     27     6012284.461 2102001.80848 37.7523884032163 -122.400387777686 (37.7523884032163, -122.400387777686) 10 3 8 28856 29
41307 184977 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2701 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984998.3534 2096742.4516 37.7363882534207 -122.494358589298 (37.7363882534207, -122.494358589298) 1 8 3 29491 35
41594 20767 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1692X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree DPW 1     24 60   5984807.4869191 2103677.7923597 37.7554196391607 -122.495529849669 (37.7554196391607, -122.495529849669) 1 8 3 56 35
41784 16362 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306X Montgomery St 14 Median : Cutout Tree DPW 1     18 8   6011452.97865 2119928.00722 37.8015631969572 -122.404524953159 (37.8015631969572, -122.404524953159) 3 1 10 308 23
42716 187095 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2600 Sunset Blvd 31 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5985178.0339 2097175.5923 37.7375880557056 -122.493769276198 (37.7375880557056, -122.493769276198) 1 8 3 29491 35
42925 256615 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1541x Montgomery St 1 Front Yard : Yard Tree DPW 1 DPW for City Agency         6011315 2120446 37.8029777664724 -122.405038917948 (37.8029777664724, -122.405038917948) 3 1 10 308 23
42969 186098 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 44 Sidewalk: Property side : Yard Tree Private 2     15 Width 0ft   5984859.9858 2101721.9514 37.7500525125937 -122.495204071455 (37.7500525125937, -122.495204071455) 1 8 3 29491 35
43163 201735 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 4 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015522.2781 2087714.21053 37.7133375628641 -122.388193748644 (37.7133375628641, -122.388193748644) 10 3 8 58 1
43289 194453 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2250 26th St 1 Sidewalk: Curb side : Yard Tree Private 2     9     6011877.75436 2101392.1938 37.750691845665 -122.401751398122 (37.750691845665, -122.401751398122) 10 3 8 28856 29
43298 23673 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 319 Virginia Ave 2 Median : Cutout Tree DPW 1     12 12   6006936.2458165 2098250.5638735 37.741788638282 -122.418616833275 (37.741788638282, -122.418616833275) 2 7 7 28859 2
43488 185314 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 39 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5985007.4607 2097237.2784 37.7377474483668 -122.494363565845 (37.7377474483668, -122.494363565845) 1 8 3 29491 35
45383 186433 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1601 Sunset Blvd 21 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984738.4307 2104031.9087 37.7563879005336 -122.495794783817 (37.7563879005336, -122.495794783817) 1 8 3 56 35
45510 185230 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2509 44th Ave 1 Sidewalk: Property side : Yard Tree Private 2     35 Width 0ft   5982693.8052 2098008.2989 37.7397287878455 -122.50241990404 (37.7397287878455, -122.50241990404) 1 8 3 29491 35

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