trees
3,965 rows where qSpecies_id = 70 sorted by SiteOrder descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4760 | 20025 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
| 7677 | 258687 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 9 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
| 16737 | 5399 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 347 Dolores St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6004915.02967 | 2106451.33313 | 37.764192039253 | -122.426189239948 | (37.764192039253, -122.426189239948) | 8 | 4 | 5 | 28859 | 19 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 25108 | 97979 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 9 | Front Yard : Yard | Tree | Private 2 | 17 | 3x105 | Permit Number 767976 | 6008557.48708 | 2094193.99719 | 37.730741330332 | -122.412724380735 | (37.730741330332, -122.412724380735) | 9 | 3 | 7 | 309 | 28 | ||
| 30715 | 73286 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
| 34524 | 9420 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6005985.41292 | 2112474.48884 | 37.7807906194317 | -122.422915195091 | (37.7807906194317, -122.422915195091) | 7 | 9 | 11 | 28852 | 41 | |||
| 36288 | 125048 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3101 Van Ness Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6005420.68062 | 2121375.93261 | 37.8051998601557 | -122.425502561696 | (37.8051998601557, -122.425502561696) | 13 | 1 | 1 | 28858 | 17 | |||
| 51441 | 17864 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2121 Pine St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003749.9172 | 2115228.4651 | 37.7882259541053 | -122.430845453567 | (37.7882259541053, -122.430845453567) | 13 | 9 | 11 | 29490 | 27 | |||
| 61143 | 140355 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1314 ELLIS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 6004287.9942 | 2113284.5981 | 37.7829190539607 | -122.428845162049 | (37.7829190539607, -122.428845162049) | 7 | 9 | 11 | 29490 | 41 | |||
| 64568 | 188646 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Cargo Way | 9 | Median : Yard | Tree | DPW 1 | 5 | 6018092.67534 | 2098102.14022 | 37.7420028892302 | -122.380030855133 | (37.7420028892302, -122.380030855133) | 10 | 3 | 8 | 58 | 1 | ||||
| 65057 | 142547 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301 FRANCISCO ST | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 20 | Width 0ft | 6009612.5597 | 2121193.6724 | 37.8049353736756 | -122.410983109438 | (37.8049353736756, -122.410983109438) | 3 | 1 | 10 | 308 | 23 | |||
| 68608 | 20475 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1203X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.495883339617 | (37.7652050441375, -122.495883339617) | 11 | 6 | 2 | 55 | 8 | |||
| 73716 | 5540 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900X Dolores St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6005033.64005 | 2102782.98964 | 37.7541263358861 | -122.425517912248 | (37.7541263358861, -122.425517912248) | 2 | 4 | 5 | 28862 | 22 | |||
| 75871 | 125324 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 640 Davis St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6013147.44886 | 2118845.30288 | 37.798684901431 | -122.398585258406 | (37.798684901431, -122.398585258406) | 3 | 1 | 10 | 28860 | 6 | |||
| 83674 | 187567 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 136 Alpha St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 10ft | 6010892.9605 | 2088110.22572 | 37.7141673547183 | -122.404222218893 | (37.7141673547183, -122.404222218893) | 9 | 7 | 8 | 309 | 39 | |||
| 84479 | 247552 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 815 Buena Vista Ave West | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 4ft | 6000078.15418 | 2108371.82358 | 37.7691906501663 | -122.443056484487 | (37.7691906501663, -122.443056484487) | 15 | 5 | 11 | 29492 | 9 | |||
| 85556 | 24193 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
| 92627 | 220130 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 Dolores St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 6004868.33246 | 2105707.16087 | 37.7621460797944 | -122.426297765642 | (37.7621460797944, -122.426297765642) | 8 | 4 | 5 | 28862 | 3 | |||
| 94286 | 188759 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Executive Park Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 6013862.38947 | 2087046.45952 | 37.7114119389729 | -122.393884230478 | (37.7114119389729, -122.393884230478) | 10 | 3 | 8 | 58 | 1 | |||
| 96341 | 186860 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985194.9901 | 2096324.7493 | 37.7352528599252 | -122.493647974184 | (37.7352528599252, -122.493647974184) | 1 | 8 | 3 | 29491 | 35 | |||
| 98732 | 188613 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 9 | : | Tree | Private 2 | 12 | Width 3ft | 6015951.71912 | 2098695.10264 | 37.7435126980454 | -122.387475021249 | (37.7435126980454, -122.387475021249) | 10 | 3 | 8 | 58 | 1 | |||
| 109637 | 124789 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1650 Green St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005117.88807 | 2118527.84721 | 37.7973626363209 | -122.426347506236 | (37.7973626363209, -122.426347506236) | 13 | 9 | 1 | 57 | 17 | |||
| 110931 | 99607 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
| 117469 | 120988 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
| 121249 | 6161 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000X Ellis St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005784.15339 | 2113483.65709 | 37.7835501893678 | -122.423683223851 | (37.7835501893678, -122.423683223851) | 7 | 9 | 11 | 28858 | 41 | |||
| 122580 | 117041 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2220x SUTTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
| 123125 | 187700 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Executive Park Blvd | 9 | Median : Yard | Tree | DPW 1 | 18 | Width 8ft | 6014134.28387 | 2086999.7269 | 37.7112987269389 | -122.392941218475 | (37.7112987269389, -122.392941218475) | 10 | 3 | 8 | 58 | 1 | |||
| 129720 | 124924 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 125 Maple St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 5ft | 5996579.25208 | 2115658.32685 | 37.7889973521854 | -122.455685689147 | (37.7889973521854, -122.455685689147) | 11 | 6 | 1 | 54 | 31 | |||
| 137229 | 5240 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Divisadero St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001405.3119 | 2112421.3803 | 37.7803852970972 | -122.438756149045 | (37.7803852970972, -122.438756149045) | 15 | 5 | 11 | 29490 | 41 | |||
| 137680 | 98571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301X Francisco St | 9 | 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 | |||
| 149631 | 125314 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 550 Davis St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013200.68159 | 2118482.22968 | 37.7976909545355 | -122.398375566176 | (37.7976909545355, -122.398375566176) | 3 | 1 | 10 | 28860 | 6 | |||
| 151581 | 124948 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Laurel St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 5997991.55442 | 2116298.21471 | 37.7908352606788 | -122.450845490231 | (37.7908352606788, -122.450845490231) | 13 | 6 | 1 | 54 | 31 | |||
| 155500 | 22124 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 12 | 3X3 | 6015845.49183 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | 10 | 3 | 8 | 58 | 1 | ||
| 157924 | 106248 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 De Haro St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 770844 | 6012033.91664 | 2105711.77198 | 37.7625611708892 | -122.401514924078 | (37.7625611708892, -122.401514924078) | 8 | 3 | 8 | 28856 | 29 | |||
| 162002 | 188741 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 9 | Median : Yard | Tree | DPW 1 | 19 | Width 8ft | 6014489.73327 | 2086967.85233 | 37.7112309432358 | -122.391710458464 | (37.7112309432358, -122.391710458464) | 10 | 3 | 8 | 58 | 1 | |||
| 165399 | 101010 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||||
| 165773 | 220154 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 9 | Front Yard : Yard | Tree | Private 2 | 7 | 6004158.18023 | 2095867.64857 | 37.7350888986179 | -122.428052698177 | (37.7350888986179, -122.428052698177) | 2 | 7 | 5 | 28861 | 2 | ||||
| 169725 | 138345 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2250 Sutter St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001736.79 | 2114308.7957 | 37.7855865118356 | -122.437744629649 | (37.7855865118356, -122.437744629649) | 13 | 6 | 1 | 29490 | 27 | |||
| 175538 | 125196 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2809 Buchanan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6003494.47774 | 2117974.44495 | 37.7957512373899 | -122.431925384849 | (37.7957512373899, -122.431925384849) | 13 | 9 | 1 | 57 | 17 | |||
| 175810 | 257902 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5701x 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014158 | 2092336 | 37.7259523956068 | -122.393232416121 | (37.7259523956068, -122.393232416121) | 10 | 3 | 8 | 58 | 1 | ||||
| 176169 | 187758 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6017560.01516 | 2093300.23406 | 37.7287884075452 | -122.381538779893 | (37.7287884075452, -122.381538779893) | 10 | 3 | 8 | 58 | 1 | ||||
| 180279 | 138356 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2499 Bush St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6001809.4503 | 2114617.5062 | 37.7864382831272 | -122.437515361807 | (37.7864382831272, -122.437515361807) | 13 | 6 | 1 | 29490 | 27 | |||
| 182961 | 6739 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300X Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 184283 | 99907 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 9 | 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 | ||||
| 189327 | 24933 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | |||
| 49117 | 186616 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 87 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984717.3898 | 2104397.9779 | 37.7573917926116 | -122.495894553165 | (37.7573917926116, -122.495894553165) | 1 | 8 | 3 | 56 | 35 | |||
| 105641 | 186614 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 85 | Sidewalk: Property side : Yard | Tree | Private 2 | 57 | Width 0ft | 5984775.1737 | 2104397.9779 | 37.7573951766754 | -122.495694716519 | (37.7573951766754, -122.495694716519) | 1 | 8 | 3 | 56 | 35 | |||
| 107805 | 186613 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 84 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984762.1933 | 2104405.0962 | 37.7574139613926 | -122.495740132277 | (37.7574139613926, -122.495740132277) | 1 | 8 | 3 | 56 | 35 | |||
| 174482 | 186612 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 83 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984740.0009 | 2104413.4707 | 37.7574356557736 | -122.49581749901 | (37.7574356557736, -122.49581749901) | 1 | 8 | 3 | 56 | 35 | |||
| 97610 | 186611 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 82 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984721.577 | 2104411.7958 | 37.7574299779546 | -122.49588109169 | (37.7574299779546, -122.49588109169) | 1 | 8 | 3 | 56 | 35 | |||
| 143857 | 186610 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 81 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984720.7396 | 2104420.1703 | 37.7574529229595 | -122.495884605472 | (37.7574529229595, -122.495884605472) | 1 | 8 | 3 | 56 | 35 | |||
| 83227 | 186802 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 80 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984846.4625 | 2106932.8738 | 37.7643594669603 | -122.495635143928 | (37.7643594669603, -122.495635143928) | 1 | 8 | 3 | 56 | 35 | |||
| 166048 | 186609 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 80 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984732.0451 | 2104419.3328 | 37.7574512855375 | -122.495845445346 | (37.7574512855375, -122.495845445346) | 1 | 8 | 3 | 56 | 35 | |||
| 7087 | 261756 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 310 30th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6004309 | 2098427 | 37.7421248276758 | -122.427713553768 | (37.7421248276758, -122.427713553768) | 2 | 7 | 5 | 63 | 22 | ||||
| 10444 | 20024 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
| 12066 | 258686 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 8 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
| 30332 | 125323 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 640 Davis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6013152.59529 | 2118825.24429 | 37.7986301120473 | -122.398566041686 | (37.7986301120473, -122.398566041686) | 3 | 1 | 10 | 28860 | 6 | |||
| 31259 | 187699 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Executive Park Blvd | 8 | Median : Yard | Tree | DPW 1 | 24 | Width 8ft | 6014113.89856 | 2087000.13929 | 37.7112987269205 | -122.393011704639 | (37.7112987269205, -122.393011704639) | 10 | 3 | 8 | 58 | 1 | |||
| 33600 | 101137 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1477 Grove St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000842.8876 | 2110669.9339 | 37.7755442571847 | -122.440576174035 | (37.7755442571847, -122.440576174035) | 15 | 5 | 11 | 29492 | 10 | |||
| 34187 | 220283 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Clarendon Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 2ft | 5998403.60495 | 2104683.44106 | 37.7589676616433 | -122.448582957854 | (37.7589676616433, -122.448582957854) | 15 | 5 | 4 | 28862 | 38 | |||
| 42304 | 6160 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000X Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006064.53658 | 2113525.24895 | 37.7836802135181 | -122.422716161482 | (37.7836802135181, -122.422716161482) | 7 | 9 | 11 | 28858 | 41 | |||
| 43119 | 125313 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 550 Davis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013202.9728 | 2118462.79402 | 37.7976377164748 | -122.398366273498 | (37.7976377164748, -122.398366273498) | 3 | 1 | 10 | 28860 | 6 | |||
| 44855 | 220129 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 Dolores St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 6004868.0084 | 2105745.84567 | 37.7622522807502 | -122.426301640812 | (37.7622522807502, -122.426301640812) | 8 | 4 | 5 | 28862 | 3 | |||
| 45455 | 249872 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 230 Greenwich St | 8 | Back Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011683.12279 | 2120489.80597 | 37.8031186185004 | -122.403768099014 | (37.8031186185004, -122.403768099014) | 3 | 1 | 10 | 28860 | 6 | |||
| 45732 | 124788 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1650 Green St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005141.03726 | 2118532.17196 | 37.7973758194907 | -122.426267712085 | (37.7973758194907, -122.426267712085) | 13 | 9 | 1 | 57 | 17 | |||
| 48323 | 24932 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/22/1996 12:00:00 AM | 18 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | ||
| 49929 | 448 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700x 23rd Ave | 8 | Median : Cutout | Tree | DPW 1 | 3 | 5988818.05287 | 2110350.21953 | 37.7739743319878 | -122.482149061597 | (37.7739743319878, -122.482149061597) | 11 | 6 | 2 | 55 | 26 | ||||
| 51410 | 187757 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6017577.45499 | 2093289.42876 | 37.7287597011768 | -122.38147773753 | (37.7287597011768, -122.38147773753) | 10 | 3 | 8 | 58 | 1 | ||||
| 55998 | 99606 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | ||||
| 67999 | 125180 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2401 Broadway | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 6002052.24268 | 2117347.57467 | 37.7939481488482 | -122.436870874613 | (37.7939481488482, -122.436870874613) | 13 | 9 | 1 | 29490 | 27 | |||
| 70426 | 115147 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
| 74425 | 125047 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3101 Van Ness Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6005418.05896 | 2121421.58215 | 37.8053250538732 | -122.425514885098 | (37.8053250538732, -122.425514885098) | 13 | 1 | 1 | 28858 | 17 | |||
| 74773 | 120987 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
| 74776 | 5398 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 347 Dolores St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004916.74294 | 2106419.98328 | 37.7641060568743 | -122.426181082194 | (37.7641060568743, -122.426181082194) | 8 | 4 | 5 | 28859 | 19 | |||
| 75367 | 124947 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Laurel St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 5ft | 5997995.69319 | 2116277.08238 | 37.7907774738528 | -122.450829645974 | (37.7907774738528, -122.450829645974) | 13 | 6 | 1 | 54 | 31 | |||
| 78454 | 118056 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 494 36th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 5984738.41738 | 2112623.76679 | 37.7799787079086 | -122.49642879092 | (37.7799787079086, -122.49642879092) | 11 | 6 | 2 | 55 | 26 | |||
| 79561 | 11788 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
| 86376 | 187709 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 51 Executive Park Blvd | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6013649.01686 | 2087002.29435 | 37.7112788096526 | -122.394618615964 | (37.7112788096526, -122.394618615964) | 10 | 3 | 8 | 58 | 1 | |||
| 95651 | 73287 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
| 103549 | 188694 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 8 | : | Tree | Private 2 | 14 | Width 3ft | 6017109.80778 | 2097388.18297 | 37.7399882351628 | -122.38337964268 | (37.7399882351628, -122.38337964268) | 10 | 3 | 8 | 58 | 1 | |||
| 107088 | 188661 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400x Cargo Way | 8 | Median : Yard | Tree | DPW 1 | 20 | 6016926.49281 | 2099019.67279 | 37.7444578423491 | -122.384127062023 | (37.7444578423491, -122.384127062023) | 10 | 3 | 8 | 58 | 1 | ||||
| 108199 | 22617 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/25/1997 12:00:00 AM | 6 | 3x5 | 6005634.7978 | 2112724.8918 | 37.7814583745998 | -122.424145957729 | (37.7814583745998, -122.424145957729) | 7 | 9 | 11 | 28852 | 41 | ||
| 109855 | 188640 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Helena St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6011049.32488 | 2096197.75265 | 37.7363827649403 | -122.404250636558 | (37.7363827649403, -122.404250636558) | 10 | 3 | 8 | 58 | 1 | ||||
| 115794 | 200532 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 8 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016155.8972 | 2095677.4311 | 37.7352380915724 | -122.386558643793 | (37.7352380915724, -122.386558643793) | 10 | 3 | 8 | 58 | 1 | |||
| 122288 | 186537 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 8 | unknown : Yard | Tree | Private 2 | 14 | Width 0ft | 5984743.3507 | 2104891.2345 | 37.7587476583889 | -122.495841156765 | (37.7587476583889, -122.495841156765) | 1 | 8 | 3 | 56 | 35 | |||
| 127702 | 188645 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Cargo Way | 8 | Median : Yard | Tree | DPW 1 | 25 | 6018140.58939 | 2098064.90862 | 37.7419033019107 | -122.379862595596 | (37.7419033019107, -122.379862595596) | 10 | 3 | 8 | 58 | 1 | ||||
| 129003 | 221377 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 653 Sanchez St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003704.10349 | 2104521.34793 | 37.7588242440533 | -122.430239784651 | (37.7588242440533, -122.430239784651) | 2 | 4 | 5 | 28862 | 3 | |||
| 137747 | 17863 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2121 Pine St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003725.8407 | 2115226.9911 | 37.7882205427126 | -122.430928648944 | (37.7882205427126, -122.430928648944) | 13 | 9 | 11 | 29490 | 27 | |||
| 138324 | 188758 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Executive Park Blvd | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 6013886.48106 | 2087045.97193 | 37.7114119389952 | -122.39380092899 | (37.7114119389952, -122.39380092899) | 10 | 3 | 8 | 58 | 1 | |||
| 138519 | 22123 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 12 | 3X3 | 6015845.49183 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | 10 | 3 | 8 | 58 | 1 | ||
| 143417 | 187775 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Lane St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6017053.32881 | 2096987.93599 | 37.7388861160087 | -122.383547068563 | (37.7388861160087, -122.383547068563) | 10 | 3 | 8 | 58 | 1 | |||
| 144556 | 188612 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 8 | : | Tree | Private 2 | 21 | Width 3ft | 6015945.00901 | 2098671.48737 | 37.7434474837177 | -122.387496576211 | (37.7434474837177, -122.387496576211) | 10 | 3 | 8 | 58 | 1 | |||
| 145004 | 101009 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||||
| 145632 | 247527 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 8 | Side Yard : Yard | Tree | Private 2 | 2 | 6000059.53834 | 2108484.86365 | 37.7694999683797 | -122.443128995021 | (37.7694999683797, -122.443128995021) | 15 | 5 | 11 | 29492 | 9 | ||||
| 147469 | 257901 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5701x 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014158 | 2092336 | 37.7259523956068 | -122.393232416121 | (37.7259523956068, -122.393232416121) | 10 | 3 | 8 | 58 | 1 | ||||
| 152216 | 188676 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1298 Fairfax Ave | 8 | : | Tree | Private 2 | 19 | Width 4ft | 6017117.52195 | 2097116.26843 | 37.7392420388994 | -122.383334047038 | (37.7392420388994, -122.383334047038) | 10 | 3 | 8 | 58 | 1 | |||
| 158637 | 97978 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767976 | 6008558.53631 | 2094188.79818 | 37.7307271138572 | -122.412720385963 | (37.7307271138572, -122.412720385963) | 9 | 3 | 7 | 309 | 28 |
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) );