trees
3,965 rows where qSpecies_id = 70
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );