3,965 rows where qSpecies_id = 70

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)
20221 187212 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2401 Sunset Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     25 Width 0ft   5984988.5085 2098705.0047 37.741776320928 -122.494537260078 (37.741776320928, -122.494537260078) 1 8 3 29491 35
20230 203896 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3804 19th Ave 2 : Tree Private 2     6 Width 3ft   5990596.84308 2090479.69294 37.7195183388684 -122.474545542655 (37.7195183388684, -122.474545542655) 9 8 4 64 40
20303 101420 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2200 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     10     6000374.3516 2116185.0207 37.7906605745677 -122.442593016179 (37.7906605745677, -122.442593016179) 13 6 1 29490 27
20332 203978 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1562 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5992223.47194 2096717.87979 37.7367409676228 -122.469376762928 (37.7367409676228, -122.469376762928) 1 8 4 59 40
20338 30322 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 720 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/17/1956 12:00:00 AM     Permit Number 16 6011772.9424544 2117800.56968196 37.7957396438077 -122.403267984357 (37.7957396438077, -122.403267984357) 3 1 10 28860 4
20381 186821 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200 Sunset Blvd 105 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984828.6477 2106722.4547 37.7637806720109 -122.495681237536 (37.7637806720109, -122.495681237536) 1 8 3 56 35
20406 188744 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 250x Executive Park Blvd 12 Median : Yard Tree DPW 1     20 Width 8ft   6014566.93251 2086961.44697 37.7112176404424 -122.391443188965 (37.7112176404424, -122.391443188965) 10 3 8 58 1
20469 114842 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2670 LEAVENWORTH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007398 2121652 37.8060693936166 -122.418679378695 (37.8060693936166, -122.418679378695) 5 1 1 308 23
20506 250806 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 279 31st Ave 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 4ft   5986182.48717 2114056.18318 37.7839962033991 -122.491538643706 (37.7839962033991, -122.491538643706) 11 6 1 55 33
20526 125225 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1606 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6005725.27471 2118266.64899 37.7966797667037 -122.424227203437 (37.7966797667037, -122.424227203437) 13 9 1 28858 17
20738 18077 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2946 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     16 3X3   5999820.6048 2114741.0687 37.7866642791044 -122.444405127725 (37.7866642791044, -122.444405127725) 15 6 1 29490 31
20826 203829 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 200x Terrace Dr 41 Median : Yard Tree DPW 1     18     5993865.8273 2096513.9581 37.7362758229773 -122.463683673072 (37.7362758229773, -122.463683673072) 1 8 4 59 40
20901 181396 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1500 Sunset Blvd 29 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984914.2437 2104590.3992 37.757931655251 -122.495227954147 (37.757931655251, -122.495227954147) 1 8 3 56 35
20956 188641 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 151 Helena St 9 Sidewalk: Curb side : Yard Tree Private 2     8     6011091.32099 2096197.80071 37.7363852434915 -122.404105441008 (37.7363852434915, -122.404105441008) 10 3 8 58 1
21042 67608 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 261 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/1992 12:00:00 AM 10   Permit Number 31186 5988028.8714 2114260.18154 37.7846640526933 -122.485165880985 (37.7846640526933, -122.485165880985) 11 6 2 55 26
21150 187379 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2200 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5985060.734 2100052.5124 37.7454804393236 -122.494386838151 (37.7454804393236, -122.494386838151) 1 8 3 29491 35
21164 220127 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 420 Dolores St 3 Sidewalk: Curb side : Yard Tree Private 2     19 Width 6ft   6004864.42666 2105831.25856 37.762486601794 -122.426320110198 (37.762486601794, -122.426320110198) 8 4 5 28859 3
21198 173686 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2211 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2017 12:00:00 AM 3     6011691 2097676 37.7404775538831 -122.402135979323 (37.7404775538831, -122.402135979323) 10 3 8 58 1
21202 124066 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 501 Funston Ave 6 Sidewalk: Curb side : Yard Tree Private 2     23 Width 4ft   5991886.30964 2111587.55564 37.7775497038674 -122.471625731033 (37.7775497038674, -122.471625731033) 11 6 2 54 11
21220 182980 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2500 20th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     23 Width 0ft   5990206.2576 2097911.7147 37.739902151809 -122.47643826121 (37.739902151809, -122.47643826121) 1 8 3 29491 35
21247 203924 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 828 Quintara St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5990829.70497 2101134.74222 37.7487878900543 -122.474517815648 (37.7487878900543, -122.474517815648) 1 8 4 29491 12
21261 55934 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2665 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/1973 12:00:00 AM 9   Permit Number 11998 5986719.3111 2097252.7279 37.7378899014651 -122.488446087215 (37.7378899014651, -122.488446087215) 1 8 3 29491 35
21344 220226 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 62 Carmel St 5 Sidewalk: Curb side : Yard Tree Private 2     16 Width 4ft   5998587.28318 2105401.77798 37.7609505363472 -122.447999434541 (37.7609505363472, -122.447999434541) 15 5 11 29492 12
21431 124977 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3751 Broderick St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5999590.28353 2121474.47758 37.8051392872022 -122.445686385433 (37.8051392872022, -122.445686385433) 13 9 1 57 17
21435 1649 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1357X Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2     21 3x3   6005247.73797 2100448.62508 37.7477288052344 -122.424611464856 (37.7477288052344, -122.424611464856) 2 7 5 28859 22
21465 104273 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3675 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997210.1 2115656.5 37.7890285184352 -122.453502918425 (37.7890285184352, -122.453502918425) 11 6 1 54 31
21537 220207 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 108 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008584.43652 2099064.66412 37.7441166332796 -122.41297546067 (37.7441166332796, -122.41297546067) 2 7 7 28859 2
21553 6948 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 583 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6004650.95912 2110501.84562 37.7752988382968 -122.427391153284 (37.7752988382968, -122.427391153284) 7 9 11 28852 10
21562 220223 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 62 Carmel St 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 4ft   5998639.38293 2105406.49302 37.7609664606466 -122.447819584529 (37.7609664606466, -122.447819584529) 15 5 11 29492 12
21595 26448 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1817 Eddy St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6001669.86946 2112366.99146 37.7802510063553 -122.437837026039 (37.7802510063553, -122.437837026039) 15 5 11 29490 41
21622 175038 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 137 Desmond St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6010492.95199 2086616.94014 37.7100447347569 -122.405499703176 (37.7100447347569, -122.405499703176) 9 7 8 309 39
21920 184111 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1604 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5986875.3953 2104311.06 37.7572792915924 -122.488425026161 (37.7572792915924, -122.488425026161) 1 8 3 56 35
21969 125176 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2519 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6001330.49234 2117251.0663 37.7936421149431 -122.439361275412 (37.7936421149431, -122.439361275412) 13 9 1 29490 27
22035 185597 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2200 Quintara St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   5986575.4427 2100993.2848 37.748152076203 -122.489218440489 (37.748152076203, -122.489218440489) 1 8 3 29491 35
22058 5492 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 719 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     1 8   6005040.75383 2104151.1903 37.7578834965409 -122.425590680889 (37.7578834965409, -122.425590680889) 2 4 5 28859 19
22096 124305 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 169 Jordan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     17 Width 4ft   5996209.82243 2113206.80783 37.7822449293206 -122.456786484191 (37.7822449293206, -122.456786484191) 11 6 1 54 31
22201 121023 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 200 Executive Park Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2           6014230 2086988 37.7112718434151 -122.392609576957 (37.7112718434151, -122.392609576957) 10 3 8 58 1
22211 8278 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X Galvez Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6015786.61194 2097763.1602 37.7409446293456 -122.387980907347 (37.7409446293456, -122.387980907347) 10 3 8 58 1
22212 246119 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1420 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 0ft   5998881.3947 2108355.4265 37.7690773199884 -122.447194813606 (37.7690773199884, -122.447194813606) 15 5 11 29492 9
22235 125135 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2655 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6000111.60795 2117732.00363 37.7948932023106 -122.44361327005 (37.7948932023106, -122.44361327005) 13 9 1 57 27
22272 5913 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1245 Eddy St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004490.90647 2112892.55275 37.7818540774754 -122.428115221825 (37.7818540774754, -122.428115221825) 7 9 11 29490 41
22279 187708 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 51 Executive Park Blvd 7 Sidewalk: Curb side : Yard Tree Private 2     13 Width 4ft   6013663.58022 2087013.01188 37.7113090475516 -122.394569030961 (37.7113090475516, -122.394569030961) 10 3 8 58 1
22295 99908 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 10 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
22316 185668 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2101 Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 0ft   5984929.7381 2100287.489 37.7461179540332 -122.494857116456 (37.7461179540332, -122.494857116456) 1 8 3 29491 35
22336 98569 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301X Francisco St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
22338 203950 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600 17th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5991063.90943 2098465.7038 37.7414729672935 -122.473513287329 (37.7414729672935, -122.473513287329) 1 8 4 29491 40
22371 17865 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2121 Pine St 10 Sidewalk: Curb side : Cutout Tree DPW 1   08/31/2016 12:00:00 AM 18 4X4   6003789.962559 2115237.891116 37.7882541043801 -122.430707576303 (37.7882541043801, -122.430707576303) 13 9 11 29490 27
22388 98555 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2360 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5991737.8 2099355.8 37.7439559460975 -122.471248063337 (37.7439559460975, -122.471248063337) 1 8 4 29491 40
22416 38478 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 201 El Camino Del Mar 3 Sidewalk: Curb side : Cutout Tree Private 2   08/25/1998 12:00:00 AM 21   Permit Number 40477 5987978.37889 2115306.2666 37.7875333623487 -122.485417356275 (37.7875333623487, -122.485417356275) 11 6 1 55 33
22458 125100 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3298 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5999060.86441 2115983.22168 37.7900315275801 -122.4471230632 (37.7900315275801, -122.4471230632) 13 6 1 29490 31
22625 188658 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 Cargo Way 124 Sidewalk: Curb side : Yard Tree Private 2     10     6016703.96276 2099238.37904 37.7450460592258 -122.384911766374 (37.7450460592258, -122.384911766374) 10 3 8 58 1
22704 188665 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2175X Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     37     6011669.71313 2097723.45025 37.7406066539877 -122.402212916691 (37.7406066539877, -122.402212916691) 10 3 8 58 1
22707 184072 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600 Sunset Blvd 73 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984928.5463 2103997.684 37.7563050611127 -122.495134783659 (37.7563050611127, -122.495134783659) 1 8 3 56 35
22759 220218 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 89 Chattanooga St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6004730.92104 2103164.34461 37.7551563384039 -122.426591942883 (37.7551563384039, -122.426591942883) 2 4 5 28862 22
22904 95659 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 499@Cervantes Marina Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6000674 2121505 37.805284907113 -122.441938257064 (37.805284907113, -122.441938257064) 13 9 1 57 17
22959 124866 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 12 Rico Way 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001683.07545 2121358.73098 37.8049407402829 -122.438435744435 (37.8049407402829, -122.438435744435) 13 9 1 57 17
22983 125092 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2145 Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   5999827.24336 2116322.83843 37.7910077839349 -122.444495883591 (37.7910077839349, -122.444495883591) 13 6 1 29490 27
23008 203710 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1350 Ulloa St 4 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   5991762.04169 2098443.18108 37.7414515301631 -122.471097768574 (37.7414515301631, -122.471097768574) 1 8 4 29491 40
23078 203707 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2198 17th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   5991036.98423 2100539.076 37.7471643529643 -122.473757603451 (37.7471643529643, -122.473757603451) 1 8 4 29491 40
23204 125307 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 10 Jackson St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6013381 2118288 37.7971676890736 -122.397737980255 (37.7971676890736, -122.397737980255) 3 1 10 28860 6
23222 53937 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 174 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1972 12:00:00 AM 12 3x4 Permit Number 9651 5993070.40109 2114326.65829 37.7851389689099 -122.467728857293 (37.7851389689099, -122.467728857293) 11 6 2 54 11
23323 203284 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 436 Joost Ave 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 7ft   5999187.02892 2095000.6796 37.73242590082 -122.445177379037 (37.73242590082, -122.445177379037) 9 7 4 59 40
23390 22618 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1001 Turk St 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 3x5   6005224.1346872 2112659.8569034 37.7812566094766 -122.425562024881 (37.7812566094766, -122.425562024881) 7 9 11 28852 41
23392 203897 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3804 19th Ave 3 : Tree Private 2     3 Width 3ft   5990591.46397 2090484.77315 37.7195319761952 -122.474564506644 (37.7195319761952, -122.474564506644) 9 8 4 64 40
23415 125278 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200 Greenwich St 4 Front Yard : Yard Tree Private 2     16     6006716.82854 2119779.13638 37.8008886127761 -122.420903634692 (37.8008886127761, -122.420903634692) 5 1 1 28858 32
23492 99901 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
23506 247295 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1416 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     17 Width 0ft   5999264.8582 2108759.0964 37.7702075983445 -122.445897477638 (37.7702075983445, -122.445897477638) 15 5 11 29492 9
23626 99853 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 755 Marina Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       3x12 Permit Number 768797 5999383.5 2121460.3 37.8050885512442 -122.446400961387 (37.8050885512442, -122.446400961387) 13 9 1 57 17
23652 6630 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1415 Evans Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1     16 3x3   6016668.82436 2097716.7125 37.7408659294107 -122.384927277883 (37.7408659294107, -122.384927277883) 10 3 8 58 1
23699 124946 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3636 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 6ft   5997401.33489 2115425.81933 37.7884060911058 -122.452824617461 (37.7884060911058, -122.452824617461) 11 6 1 54 31
23702 124834 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 60 Retiro Way 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6001777.19779 2121403.36061 37.8050686346845 -122.438113223249 (37.8050686346845, -122.438113223249) 13 9 1 57 17
23718 124908 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3837 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5996520.53305 2115587.04423 37.7887982593656 -122.455883692899 (37.7887982593656, -122.455883692899) 11 6 1 54 31
23786 221392 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 19 Short St 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   6000060.07492 2104157.98703 37.7576194699753 -122.442816392471 (37.7576194699753, -122.442816392471) 2 4 5 28862 3
23787 50103 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1530 Portola Dr 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46829 5992435.00755539 2096888.46432184 37.7372215720402 -122.468657807095 (37.7372215720402, -122.468657807095) 1 8 4 59 40
23795 220224 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 62 Carmel St 3 Sidewalk: Curb side : Yard Tree Private 2     13 Width 4ft   5998625.21868 2105405.54522 37.7609630486351 -122.447868504035 (37.7609630486351, -122.447868504035) 15 5 11 29492 12
23841 203991 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 61 Westwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5995098.20375 2093017.11176 37.7267452692552 -122.45916973021 (37.7267452692552, -122.45916973021) 9 7 4 28861 40
23871 184829 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984677.5396 2106895.0631 37.7642457559536 -122.496216602354 (37.7642457559536, -122.496216602354) 1 8 3 56 35
23875 182346 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1518 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5988091.9469 2104953.0189 37.7591128448339 -122.484264846545 (37.7591128448339, -122.484264846545) 1 8 3 56 35
23932 141128 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1730 Ellis St 3 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 0ft   6002572.3595 2113034.093 37.782133976563 -122.434762619209 (37.782133976563, -122.434762619209) 15 5 11 29490 41
23973 125308 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 10 Jackson St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6013381 2118288 37.7971676890736 -122.397737980255 (37.7971676890736, -122.397737980255) 3 1 10 28860 6
23987 220316 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 219 Diamond St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001764.77841 2104599.31255 37.7589282803322 -122.436952438626 (37.7589282803322, -122.436952438626) 2 4 5 28862 3
24026 125179 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2401 Broadway 2 Sidewalk: Curb side : Yard Tree Private 2     24 Width 4ft   6002026.35862 2117343.77621 37.793936248109 -122.436960163797 (37.793936248109, -122.436960163797) 13 9 1 29490 27
24057 175026 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 11 Raymond Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6011082.6747 2087261.47183 37.7118474464748 -122.403506811807 (37.7118474464748, -122.403506811807) 9 7 8 309 39
24079 220307 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 114 Hancock St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6003496.4505 2105093.35796 37.760383083023 -122.430998769296 (37.760383083023, -122.430998769296) 2 4 5 28862 3
24114 116895 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 998X KIRKHAM ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991857 2105283 37.7602373900467 -122.471267663471 (37.7602373900467, -122.471267663471) 1 8 4 56 12
24150 203998 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 55 Merced Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5995084.78347 2099948.84972 37.7457773474569 -122.459717986591 (37.7457773474569, -122.459717986591) 1 8 4 59 40
24174 123143 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 582 10th Ave 1 Sidewalk: Property side : Yard Tree Private 2     18 Width 5ft   5992871.73325 2111517.59924 37.7774145847454 -122.468211760136 (37.7774145847454, -122.468211760136) 11 6 2 54 11
24181 203963 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 95 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5993055.09065 2098419.62465 37.7414615549015 -122.466625177429 (37.7414615549015, -122.466625177429) 1 8 4 59 40
24282 188748 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 150 Executive Park Blvd 5 Sidewalk: Curb side : Yard Tree Private 2     18 Width 3ft   6013906.67984 2086991.4991 37.7112634896854 -122.393727305964 (37.7112634896854, -122.393727305964) 10 3 8 58 1
24289 30297 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2734 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/1956 12:00:00 AM 9   Permit Number 140 6003569.97515 2117774.33074 37.7952060548567 -122.43164985595 (37.7952060548567, -122.43164985595) 13 9 1 29490 27
24319 106459 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 125 HANCOCK ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003462.6 2105028.1 37.7602019821643 -122.431111184527 (37.7602019821643, -122.431111184527) 2 4 5 28862 3
24362 125167 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2647 Vallejo St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6001006.56911 2117558.99371 37.7944691638671 -122.440504169841 (37.7944691638671, -122.440504169841) 13 9 1 57 27
24387 186825 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200 Sunset Blvd 100 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984841.1725 2106636.9913 37.7635467469683 -122.4956316146 (37.7635467469683, -122.4956316146) 1 8 3 56 35
24398 23561 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2930 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6005650.5577 2120458.20498 37.8026930017358 -122.424641718951 (37.8026930017358, -122.424641718951) 5 9 1 28858 32
24417 125274 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1255 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6007531.27909 2121531.59091 37.8057462837276 -122.418209601296 (37.8057462837276, -122.418209601296) 5 1 1 308 32
24454 111167 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100X Magnolia St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003205.80331 2119813.99508 37.8007857959727 -122.433055745441 (37.8007857959727, -122.433055745441) 13 9 1 57 17
24470 125260 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 962 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6008372 2119361 37.7998336716629 -122.415146410717 (37.7998336716629, -122.415146410717) 5 1 10 308 32
24486 124784 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3055 Scott St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6000935.85485 2118878.39953 37.7980878784058 -122.440843541621 (37.7980878784058, -122.440843541621) 13 9 1 57 17
24488 220241 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 10x Benton Ave 3 Median : Yard Tree DPW 1     42     6004791.23434 2095030.36311 37.7328256962469 -122.425804423654 (37.7328256962469, -122.425804423654) 2 7 7 28861 2
24647 186862 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2700 Sunset Blvd 11 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5985163.1298 2096349.2748 37.7353183364912 -122.493759932025 (37.7353183364912, -122.493759932025) 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)
);