438 rows where qSpecies_id = 63 sorted by YCoord 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)
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
187217 132182 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 601 Beach St 1 Sidewalk: Property side : Yard Tree Private 2     24 Width 5ft   6007241.65576 2121894.78138 37.8067272057567 -122.419237667598 (37.8067272057567, -122.419237667598) 5 1 1 28858 32
117514 132181 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1302 Columbus Ave 4 Sidewalk: Property side : Yard Tree Private 2     21     6007227.55341 2121889.28804 37.8067113282286 -122.419286081687 (37.8067113282286, -122.419286081687) 5 1 1 28858 32
146172 132180 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1302 Columbus Ave 3 Sidewalk: Property side : Yard Tree Private 2     26     6007242.78631 2121872.67886 37.8066665815484 -122.419232186229 (37.8066665815484, -122.419232186229) 5 1 1 28858 32
193997 132179 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1302 Columbus Ave 2 Sidewalk: Property side : Yard Tree Private 2     33     6007259.69894 2121860.76679 37.8066348265036 -122.419172811197 (37.8066348265036, -122.419172811197) 5 1 1 28858 32
80305 111179 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 400 NORTH POINT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 9x6   6008572 2121805 37.806555520543 -122.414627380808 (37.806555520543, -122.414627380808) 3 1 10 308 23
115540 23580 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3100X Van Ness Ave 3 Median : Cutout Tree DPW 1     24 9   6005507.77084 2121129.71298 37.8045287248816 -122.425183644115 (37.8045287248816, -122.425183644115) 5 1 1 28858 32
142225 23579 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3100X Van Ness Ave 2 Median : Cutout Tree DPW 1     42 3x3   6005511.92719 2121098.11811 37.8044422083102 -122.425167011149 (37.8044422083102, -122.425167011149) 5 1 1 28858 32
103192 132176 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2745 Larkin St 2 Sidewalk: Property side : Yard Tree Private 2     14     6006527.83964 2120663.1294 37.8033051783476 -122.421620437537 (37.8033051783476, -122.421620437537) 5 9 1 28858 32
103781 108605 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1140x CHESTNUT ST 2 Unaccepted Street : Yard Tree Private 2           6006369.1 2120452.7 37.8027184407042 -122.422154803739 (37.8027184407042, -122.422154803739) 5 9 1 28858 32
17203 107449 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1130x CHESTNUT ST 1 Unaccepted Street : Yard Tree Private 2     60     6006351.9 2120450.9 37.8027125282147 -122.422214196597 (37.8027125282147, -122.422214196597) 5 9 1 28858 32
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
85334 256616 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1541X Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011315 2120446 37.8029777664724 -122.405038917948 (37.8029777664724, -122.405038917948) 3 1 10 308 23
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
185949 107450 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1140x Chestnut St 1 Unaccepted Street : Yard Tree Private 2     60     6006380.05181 2120425.48408 37.8026443304364 -122.422114970234 (37.8026443304364, -122.422114970234) 5 9 1 28858 32
71037 132174 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1111 Chestnut St 1 Front Yard : Yard Tree Private 2     52     6006441.86345 2120416.15353 37.8026221972261 -122.42190040729 (37.8026221972261, -122.42190040729) 5 9 1 28858 32
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
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
73714 132189 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 43 Median : Yard Tree DPW 1     12 Width 8ft   6011411.36798 2120233.14388 37.8023987021982 -122.404690439238 (37.8023987021982, -122.404690439238) 3 1 10 308 23
61019 132188 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 42 Median : Yard Tree DPW 1     17 Width 8ft   6011420.08981 2120201.09522 37.8023111918729 -122.404657999787 (37.8023111918729, -122.404657999787) 3 1 10 308 23
70483 132187 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 40 Median : Yard Tree DPW 1     14 Width 8ft   6011421.2833 2120182.68985 37.8022607219264 -122.404652573264 (37.8022607219264, -122.404652573264) 3 1 10 308 23
140100 132186 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 34 Median : Yard Tree DPW 1     20 Width 8ft   6011427.66353 2120140.51179 37.8021452678603 -122.404627523539 (37.8021452678603, -122.404627523539) 3 1 10 308 23
114548 132185 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 32 Median : Yard Tree DPW 1     31 Width 8ft   6011428.32338 2120121.70557 37.8020936674502 -122.404623915473 (37.8020936674502, -122.404623915473) 3 1 10 308 23
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
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
51624 16371 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 4 Median : Cutout Tree DPW 1     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
68881 16368 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 1 Median : Cutout Tree DPW 1     26 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
113826 16372 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 5 Median : Cutout Tree DPW 1     12 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
140332 16374 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 7 Median : Cutout Tree DPW 1     12 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
144960 16370 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 3 Median : Cutout Tree DPW 1     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
50112 109625 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 312x FILBERT ST 1 Unaccepted Street : Yard Tree Private 2     14     6011362.9 2120079.8 37.801974948341 -122.40484736081 (37.801974948341, -122.40484736081) 3 1 10 308 23
47375 132184 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 25 Median : Yard Tree DPW 1     29 Width 8ft   6011444.3716 2120015.20461 37.8018021387065 -122.404560879294 (37.8018021387065, -122.404560879294) 3 1 10 308 23
190898 132183 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 23 Median : Yard Tree DPW 1     26 Width 8ft   6011446.11989 2119998.19994 37.8017555457373 -122.404553631656 (37.8017555457373, -122.404553631656) 3 1 10 308 23
90211 96976 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 390X Filbert St 1 Median : Yard Tree Rec/Park 5     28     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116) 3 1 10 308 23
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
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
146463 107487 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 12 Median : Cutout Tree DPW 1     23     6011454.1798 2119912.99001 37.801522030487 -122.40451973891 (37.801522030487, -122.40451973891) 3 1 10 308 23
55393 16363 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300X Montgomery St 16 Median : Cutout Tree DPW 1     12 8   6011500.9168661 2119743.0722499 37.8010580895294 -122.404346040012 (37.8010580895294, -122.404346040012) 3 1 10 308 23
164190 16364 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300X Montgomery St 17 Median : Cutout Tree DPW 1     12 8   6011500.9168661 2119743.0722499 37.8010580895294 -122.404346040012 (37.8010580895294, -122.404346040012) 3 1 10 308 23
108098 132177 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1048 Union St 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   6007888.26555 2119276.18895 37.7995736051877 -122.416814304957 (37.7995736051877, -122.416814304957) 5 1 1 308 32
97489 38524 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3031 Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/15/1998 12:00:00 AM 4   Permit Number 40508 6001948.5977 2118592.4425 37.7973603403586 -122.437318675826 (37.7973603403586, -122.437318675826) 13 9 1 57 17
163885 115556 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 3897 CLAY ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996199 2115222 37.7877774871206 -122.456969730492 (37.7877774871206, -122.456969730492) 11 6 1 54 31
60584 115235 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 58 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2016 12:00:00 AM 3 4x6 Permit Number 777338 5989295.30249 2114868.10873 37.7864069399285 -122.480829025898 (37.7864069399285, -122.480829025898) 11 6 1 55 33
192071 132173 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 91 Mayfair Dr 3 Sidewalk: Property side : Yard Tree Private 2     15 Width 6ft   5997717.35609 2114490.42899 37.7858558611085 -122.45166373929 (37.7858558611085, -122.45166373929) 15 6 1 54 31
95203 141265 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 52 JORDAN AVE 2 Sidewalk: Curb side : Yard Tree Private 2     12 Width 0ft   5996227.2891 2114192.1724 37.7849514808139 -122.456797345759 (37.7849514808139, -122.456797345759) 11 6 1 54 31
19898 98265 Property Tree 8 Pinus pinea :: Italian Stone Pine 63 755 O'Farrell St   Back Yard : Yard Tree Private 2         Backyard tree; not significant 6007700 2113968.3 37.7849888609023 -122.417089467607 (37.7849888609023, -122.417089467607) 7 10 9 28858 36
99612 258091 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1500x Steiner St 1 Sidewalk: Property side : Yard Tree DPW 1       15x50   6002808 2113496 37.7834156319858 -122.433980438269 (37.7834156319858, -122.433980438269) 13 9 11 29490 41
97194 24742 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 50X Point Lobos Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 12x12   5982568.63637 2112600.93828 37.7797886774071 -122.503933218017 (37.7797886774071, -122.503933218017) 11 6 2 55 26
157105 54486 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 535 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/11/1972 12:00:00 AM 8   Permit Number 10278 5983764.83173 2112189.27219 37.7787286289905 -122.499764682948 (37.7787286289905, -122.499764682948) 11 6 2 55 26
25732 116996 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 606x FULTON ST   Front Yard : Yard Tree Private 2   09/29/2016 12:00:00 AM 3     6004628 2111737 37.7786889706302 -122.427558590519 (37.7786889706302, -122.427558590519) 7 9 11 28852 41
181774 118274 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 801 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     31 Width 3ft   5984451.13428 2110349.39905 37.7737171157491 -122.497254676861 (37.7737171157491, -122.497254676861) 11 6 2 55 26
77265 20512 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1211X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 60   5984783.6901595 2107169.3790132 37.7650051676015 -122.495869700491 (37.7650051676015, -122.495869700491) 11 6 2 55 8
111313 20511 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1211X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 60   5984783.6901595 2107169.3790132 37.7650051676015 -122.495869700491 (37.7650051676015, -122.495869700491) 11 6 2 55 8
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
162189 184737 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984694.2473 2106265.1087 37.7625170568543 -122.496112336517 (37.7625170568543, -122.496112336517) 1 8 3 56 35
125583 184742 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5984665.3886 2106227.5165 37.7624121488276 -122.496209373012 (37.7624121488276, -122.496209373012) 1 8 3 56 35
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
63026 186711 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984852.6024 2106104.2938 37.762084778312 -122.495552790494 (37.762084778312, -122.495552790494) 1 8 3 56 35
96185 234523 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90 Woodland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     32 Width 5ft   5997132.36622 2105999.93621 37.7625096541183 -122.45307450849 (37.7625096541183, -122.45307450849) 15 5 11 29492 12
92020 110148 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 90 WOODLAND AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     38 4x9   5997155.9 2105983.7 37.7624664223167 -122.452991942132 (37.7624664223167, -122.452991942132) 15 5 11 29492 12
193846 110147 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 90 WOODLAND AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     46 4x15   5997155.9 2105983.7 37.7624664223167 -122.452991942132 (37.7624664223167, -122.452991942132) 15 5 11 29492 12
110265 234522 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90 Woodland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     41 Width 5ft   5997143.66994 2105974.54542 37.7624405852729 -122.453033580335 (37.7624405852729, -122.453033580335) 15 5 11 29492 12
69152 184781 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 42 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984718.1696 2105899.6288 37.7615149526664 -122.496002635394 (37.7615149526664, -122.496002635394) 1 8 3 56 35
52616 184782 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 43 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984677.5396 2105882.9212 37.7614666984861 -122.496141923024 (37.7614666984861, -122.496141923024) 1 8 3 56 35
68325 184784 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984713.613 2105863.1758 37.7614145960538 -122.496015705201 (37.7614145960538, -122.496015705201) 1 8 3 56 35
100087 194438 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1051 18th St 1 Side Yard : Yard Tree Private 2     11     6014405.25344 2105708.40792 37.7626839643245 -122.39331303148 (37.7626839643245, -122.39331303148) 10 3 8 28856 29
178211 186688 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1401 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984691.4289 2105282.7412 37.7598195855983 -122.496049606755 (37.7598195855983, -122.496049606755) 1 8 3 56 35
120848 194447 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 680 De Haro St 4 Sidewalk: Property side : Yard Tree Private 2     1     6012074.20817 2105270.47212 37.761351707727 -122.401344555627 (37.761351707727, -122.401344555627) 10 3 8 28856 29
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
165845 234524 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 671 Church St 22 Front Yard : Yard Tree Private 2     11 Width 3ft   6004318.84944 2105025.54229 37.7602434426069 -122.4281496397 (37.7602434426069, -122.4281496397) 2 4 5 28862 3
170849 186531 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 2 unknown : Yard Tree Private 2     9 Width 0ft   5984751.3064 2104919.289 37.7588251541556 -122.495815712177 (37.7588251541556, -122.495815712177) 1 8 3 56 35
78908 194452 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 20th St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6011998.43391 2104639.55141 37.7596151114626 -122.401562284167 (37.7596151114626, -122.401562284167) 10 3 8 28856 29
74337 211057 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 447 Lawton St 2 Sidewalk: Curb side : Pot Tree Private 2     9 Width 3ft   5992810.26786 2104540.37946 37.7582534434534 -122.467916772063 (37.7582534434534, -122.467916772063) 1 8 4 56 12
179563 211058 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 447 Lawton St 3 Sidewalk: Curb side : Pot Tree Private 2     15 Width 3ft   5992805.57319 2104540.3462 37.7582530810297 -122.467933005722 (37.7582530810297, -122.467933005722) 1 8 4 56 12
132701 186592 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 63 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984742.0945 2104511.4521 37.757704808066 -122.495817486185 (37.757704808066, -122.495817486185) 1 8 3 56 35
93032 186593 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 64 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984773.0801 2104494.2844 37.7576594849516 -122.495709060541 (37.7576594849516, -122.495709060541) 1 8 3 56 35
103634 186594 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984719.4834 2104488.841 37.7576414000341 -122.495894015518 (37.7576414000341, -122.495894015518) 1 8 3 56 35
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
118830 211056 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 17th Ave 2 Sidewalk: Property side : Yard Tree Private 2     20     5990908.64637 2104472.93122 37.7579582535812 -122.474488420401 (37.7579582535812, -122.474488420401) 1 8 4 56 12
173494 181382 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1500 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984896.9779 2104470.096 37.7576003251998 -122.49527879388 (37.7576003251998, -122.49527879388) 1 8 3 56 35
54785 186417 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1601 Sunset Blvd 5 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984727.1251 2104191.8612 37.7568264235859 -122.495845680799 (37.7568264235859, -122.495845680799) 1 8 3 56 35
164309 233330 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 4053 20th St 9 Front Yard : Yard Tree Private 2     16 Width 3ft   6003355.15759 2104159.05112 37.7578096927712 -122.431420737491 (37.7578096927712, -122.431420737491) 2 4 5 28862 3
120346 98601 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 301 Twin Peaks Blvd 1 Sidewalk: Property side : Cutout Tree Private 2     24 3x3   5998661.2 2104103.7 37.757390562446 -122.447650343479 (37.757390562446, -122.447650343479) 15 5 5 63 3
167835 184087 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 Sunset Blvd 88 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5984947.9817 2104096.3091 37.7565769961358 -122.495074842554 (37.7565769961358, -122.495074842554) 1 8 3 56 35
173903 184079 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 Sunset Blvd 80 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984934.15 2104045.1938 37.7564358379272 -122.49511890768 (37.7564358379272, -122.49511890768) 1 8 3 56 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
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
81035 194456 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 22nd St 12 Front Yard : Yard Tree Private 2     2     6013384.43791 2103815.09856 37.7574285843868 -122.396710957944 (37.7574285843868, -122.396710957944) 10 3 8 28856 29
128353 194455 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 22nd St 11 Front Yard : Yard Tree Private 2     8     6013406.26386 2103790.51305 37.757362292666 -122.396633751156 (37.757362292666, -122.396633751156) 10 3 8 28856 29
133127 194437 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1021 Minnesota St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6015301.57899 2103740.56291 37.7573304413508 -122.390075457711 (37.7573304413508, -122.390075457711) 10 3 8 28856 29
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
105080 173727 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 958 Carolina St 1 Sidewalk: Curb side : Cutout Tree DPW 1     9 3x3   6012430 2103470 37.7564278519739 -122.399987571177 (37.7564278519739, -122.399987571177) 10 3 8 28856 29
186214 234513 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 998 York St 4 Sidewalk: Curb side : Yard Tree Private 2     5 Width 7ft   6009942.57021 2103461.5506 37.7562656557487 -122.408589420289 (37.7562656557487, -122.408589420289) 2 4 7 28859 19
145433 234514 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 998 York St 10 Sidewalk: Curb side : Yard Tree Private 2     1 Width 7ft   6009944.54234 2103430.26244 37.7561798559202 -122.408580392894 (37.7561798559202, -122.408580392894) 2 4 7 28859 19
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
95523 194440 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 33 Median : Yard Tree DPW 1     6     6012485.2688 2103286.14111 37.7559260969364 -122.399783521388 (37.7559260969364, -122.399783521388) 10 3 8 28856 29
152112 186248 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1701 Sunset Blvd 12 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984775.1177 2103139.467 37.7539396511246 -122.495602086568 (37.7539396511246, -122.495602086568) 1 8 3 56 35
170052 194441 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 39 Median : Yard Tree DPW 1     18     6012501.46554 2103105.94469 37.7554322198433 -122.399714855461 (37.7554322198433, -122.399714855461) 10 3 8 28856 29
126322 186253 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1701 Sunset Blvd 64 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984779.1353 2103090.988 37.7538067764424 -122.495584617514 (37.7538067764424, -122.495584617514) 1 8 3 56 35
170803 186254 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1701 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984796.5449 2103072.2391 37.7537563165951 -122.495523029283 (37.7537563165951, -122.495523029283) 1 8 3 56 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)
);