trees
3,965 rows where qSpecies_id = 70 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
103924 | 30856 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
114042 | 188718 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 614 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009528.36406 | 2111634.33045 | 37.7786830195371 | -122.410599009337 | (37.7786830195371, -122.410599009337) | 8 | 2 | 9 | 28853 | 34 | |||
116029 | 104640 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 112 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2.5x2.5 | 6009509.89326 | 2111697.52669 | 37.7788555059216 | -122.410667371323 | (37.7788555059216, -122.410667371323) | 8 | 2 | 9 | 28853 | 34 | |||
117900 | 30855 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
122222 | 116087 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 98x WOODWARD ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006422 | 2107919 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | 8 | 4 | 7 | 28853 | 19 | ||||
175626 | 104641 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 112 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2.5x2.5 | 6009525.15876 | 2111682.07782 | 37.7788139428406 | -122.410613470452 | (37.7788139428406, -122.410613470452) | 8 | 2 | 9 | 28853 | 34 | |||
175870 | 30854 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
176729 | 15277 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1563X Mission St | 2 | Median : Cutout | Tree | DPW 1 | 10/28/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777705 | 6007250.56082 | 2109703.40074 | 37.7732531819334 | -122.418341887077 | (37.7732531819334, -122.418341887077) | 8 | 2 | 9 | 28853 | 19 | |
182952 | 30857 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
186981 | 30853 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
65092 | 188710 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 182 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015012.51159 | 2115904.85579 | 37.7907148477575 | -122.391925766986 | (37.7907148477575, -122.391925766986) | 6 | 2 | 9 | 28855 | 6 | |||
88710 | 188712 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 182 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6015047.01523 | 2115868.01492 | 37.7906156066842 | -122.39180380811 | (37.7906156066842, -122.39180380811) | 6 | 2 | 9 | 28855 | 6 | |||
141202 | 188715 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 221 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6014787.2921 | 2115709.23152 | 37.7901652027998 | -122.392691330139 | (37.7901652027998, -122.392691330139) | 6 | 2 | 9 | 28855 | 6 | |||
148650 | 42069 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 10 | 3x3 | Permit Number 42381 | 6015269 | 2115673 | 37.7900924610766 | -122.391022110897 | (37.7900924610766, -122.391022110897) | 6 | 2 | 9 | 28855 | 6 |
154289 | 188713 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 221 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6014826.65865 | 2115671.24883 | 37.7900630973959 | -122.392552465835 | (37.7900630973959, -122.392552465835) | 6 | 2 | 9 | 28855 | 6 | |||
157823 | 188714 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 221 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6014809.60929 | 2115691.05583 | 37.7901165359975 | -122.392612841812 | (37.7901165359975, -122.392612841812) | 6 | 2 | 9 | 28855 | 6 | |||
168226 | 188709 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 182 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6014993.3762 | 2115925.05204 | 37.7907692396516 | -122.391993387893 | (37.7907692396516, -122.391993387893) | 6 | 2 | 9 | 28855 | 6 | |||
175152 | 188711 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 182 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6015034.4377 | 2115884.60313 | 37.7906604558597 | -122.391848486415 | (37.7906604558597, -122.391848486415) | 6 | 2 | 9 | 28855 | 6 | |||
190117 | 188716 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 221 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6014770.59198 | 2115729.03116 | 37.7902186405175 | -122.39275049743 | (37.7902186405175, -122.39275049743) | 6 | 2 | 9 | 28855 | 6 | |||
191472 | 34879 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 211 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38492 | 6014657.62995196 | 2115836.08195439 | 37.7905063026103 | -122.393148834356 | (37.7905063026103, -122.393148834356) | 6 | 2 | 9 | 28855 | 6 | ||||
8962 | 116061 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2100x 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 3x3 | 6011385.89017 | 2105128.48272 | 37.7609234092204 | -122.403715181115 | (37.7609234092204, -122.403715181115) | 10 | 3 | 8 | 28856 | 29 | ||
25600 | 188606 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 19th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 4ft | 6014179.73832 | 2105282.17122 | 37.761501079734 | -122.3940631731 | (37.761501079734, -122.3940631731) | 10 | 3 | 8 | 28856 | 29 | |||
27485 | 173729 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 994 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | 6012439 | 2103318 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | 10 | 3 | 8 | 28856 | 29 | |||
31158 | 117161 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1383X VERMONT ST | 1 | Front Yard : Cutout | Tree | Private 2 | 6011571 | 2102081 | 37.7525660338429 | -122.402860625738 | (37.7525660338429, -122.402860625738) | 10 | 3 | 8 | 28856 | 29 | |||||
32089 | 106242 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 De Haro St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Permit Number 770844 | 6012041.04445 | 2105749.16688 | 37.7626642466674 | -122.401492899679 | (37.7626642466674, -122.401492899679) | 8 | 3 | 8 | 28856 | 29 | |||
35903 | 105966 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 290X Arkansas St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012903.22107 | 2105890.09903 | 37.7630992845925 | -122.398520809474 | (37.7630992845925, -122.398520809474) | 14 | 3 | 8 | 28856 | 29 | |||||
39243 | 110886 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
42027 | 188598 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1050 Wisconsin St | 4 | : | Tree | Private 2 | 18 | Width 5ft | 6012781.12633 | 2102535.65122 | 37.7538819037331 | -122.398707676819 | (37.7538819037331, -122.398707676819) | 10 | 3 | 8 | 28856 | 29 | |||
46769 | 87049 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 139 Welsh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2007 12:00:00 AM | 13 | 3x3 | Permit Number 49986 | 6013117.93675 | 2111529.65612 | 37.7785962007824 | -122.398173856333 | (37.7785962007824, -122.398173856333) | 6 | 2 | 9 | 28856 | 34 | |
54214 | 188603 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 22nd St | 6 | : | Tree | Private 2 | 11 | Width 3ft | 6012672.24718 | 2103750.00011 | 37.7572101741252 | -122.399169443623 | (37.7572101741252, -122.399169443623) | 10 | 3 | 8 | 28856 | 29 | |||
57020 | 188589 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 De Haro St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6012060.54912 | 2105668.61761 | 37.7624441646018 | -122.401419778502 | (37.7624441646018, -122.401419778502) | 8 | 3 | 8 | 28856 | 29 | |||
57615 | 188567 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500 24th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6016949.54535 | 2102644.83882 | 37.7544130748234 | -122.384299775913 | (37.7544130748234, -122.384299775913) | 3 | 8 | 28856 | 29 | |||||
59675 | 110867 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
61626 | 188578 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 601 Wisconsin St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 3ft | 6012716.69454 | 2104629.3744 | 37.7596272199442 | -122.399077449262 | (37.7596272199442, -122.399077449262) | 10 | 3 | 8 | 28856 | 29 | |||
64261 | 110884 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
64983 | 188602 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 22nd St | 5 | : | Tree | Private 2 | 19 | Width 4ft | 6012654.45506 | 2103749.21947 | 37.7572070391022 | -122.39923092128 | (37.7572070391022, -122.39923092128) | 10 | 3 | 8 | 28856 | 29 | |||
66534 | 188607 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 19th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 4ft | 6014156.72226 | 2105282.84935 | 37.7615016624873 | -122.394142824244 | (37.7615016624873, -122.394142824244) | 10 | 3 | 8 | 28856 | 29 | |||
67776 | 188594 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Jack Balestreri Way | 2 | Front Yard : Yard | Tree | Private 2 | 16 | 6012410.71719 | 2104764.5597 | 37.7599813531633 | -122.400145172978 | (37.7599813531633, -122.400145172978) | 10 | 3 | 8 | 28856 | 29 | ||||
70795 | 106249 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 De Haro St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Permit Number 770844 | 6012059.45728 | 2105702.6288 | 37.7625374908356 | -122.401425945147 | (37.7625374908356, -122.401425945147) | 8 | 3 | 8 | 28856 | 29 | |||
73680 | 117162 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1383X VERMONT ST | 2 | Front Yard : Cutout | Tree | Private 2 | DPW | 6011571 | 2102081 | 37.7525660338429 | -122.402860625738 | (37.7525660338429, -122.402860625738) | 10 | 3 | 8 | 28856 | 29 | ||||
74538 | 188584 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 28 | Median : Yard | Tree | DPW 1 | 11 | 6012486.48206 | 2103413.8081 | 37.756276710206 | -122.399788289593 | (37.756276710206, -122.399788289593) | 10 | 3 | 8 | 28856 | 29 | ||||
76510 | 188600 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 22nd St | 2 | : | Tree | Private 2 | 19 | Width 5ft | 6012542.53813 | 2103744.35344 | 37.7571874401736 | -122.399617634271 | (37.7571874401736, -122.399617634271) | 10 | 3 | 8 | 28856 | 29 | |||
82161 | 122795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 241 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6014055.37556 | 2105891.1297 | 37.7631662338691 | -122.39453593861 | (37.7631662338691, -122.39453593861) | 14 | 3 | 8 | 28856 | 29 | |||
83191 | 3743 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 906 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 18 | 18 | 6012418 | 2103694 | 37.7570422378388 | -122.400044801952 | (37.7570422378388, -122.400044801952) | 10 | 3 | 8 | 28856 | 29 | |||
83416 | 188587 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 55 | Median : Yard | Tree | DPW 1 | 16 | 6012500.08207 | 2102956.31087 | 37.7550212809088 | -122.399709133985 | (37.7550212809088, -122.399709133985) | 10 | 3 | 8 | 28856 | 29 | ||||
90425 | 173719 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 922 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 3x3 | 6012422 | 2103621 | 37.7568420188621 | -122.400025841962 | (37.7568420188621, -122.400025841962) | 10 | 3 | 8 | 28856 | 29 | |||
95645 | 188575 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Arkansas St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012879.97943 | 2105702.58082 | 37.7625831062431 | -122.398588035523 | (37.7625831062431, -122.398588035523) | 14 | 3 | 8 | 28856 | 29 | |||
97007 | 188592 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 762 De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 2ft | 6012104.77982 | 2104872.77211 | 37.7602614173393 | -122.401210873179 | (37.7602614173393, -122.401210873179) | 10 | 3 | 8 | 28856 | 29 | |||
101226 | 188582 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 19 | Median : Yard | Tree | DPW 1 | 5 | 6012479.86277 | 2103522.41115 | 37.7565745414011 | -122.3998188072 | (37.7565745414011, -122.3998188072) | 10 | 3 | 8 | 28856 | 29 | ||||
102456 | 121583 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 328 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6014282 | 2105497 | 37.7620966358803 | -122.393724526489 | (37.7620966358803, -122.393724526489) | 10 | 3 | 8 | 28856 | 29 | |||
106539 | 110882 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
106978 | 188593 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 20th St | 1 | Side Yard : Yard | Tree | Private 2 | 27 | 6010961.38996 | 2104652.9831 | 37.759594070921 | -122.405149865099 | (37.759594070921, -122.405149865099) | 10 | 3 | 8 | 28856 | 29 | ||||
107095 | 188601 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 22nd St | 3 | : | Tree | Private 2 | 11 | Width 3ft | 6012564.34837 | 2103745.33804 | 37.7571913593991 | -122.399542274663 | (37.7571913593991, -122.399542274663) | 10 | 3 | 8 | 28856 | 29 | |||
108941 | 188566 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 901 Iowa St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 6014791.61868 | 2102890.82424 | 37.7549689439879 | -122.391779701799 | (37.7549689439879, -122.391779701799) | 10 | 3 | 8 | 28856 | 29 | ||||
109408 | 188585 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 36 | Median : Yard | Tree | DPW 1 | 10 | 6012499.61765 | 2103177.92943 | 37.755629771207 | -122.399726300248 | (37.755629771207, -122.399726300248) | 10 | 3 | 8 | 28856 | 29 | ||||
116637 | 3745 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900 Carolina St | 4 | Median : Cutout | Tree | DPW 1 | 6 | 18 | 6012461.71984 | 2103674.63492 | 37.7569915030708 | -122.399892241358 | (37.7569915030708, -122.399892241358) | 10 | 3 | 8 | 28856 | 29 | |||
118371 | 188588 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 57 | Median : Yard | Tree | DPW 1 | 13 | 6012513.0739 | 2102944.23906 | 37.754988858573 | -122.399663356681 | (37.754988858573, -122.399663356681) | 10 | 3 | 8 | 28856 | 29 | ||||
119861 | 110871 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
120063 | 188605 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1133 19th St | 2 | : | Tree | Private 2 | 21 | Width 4ft | 6014119.83156 | 2105240.70267 | 37.7613838863743 | -122.394267463999 | (37.7613838863743, -122.394267463999) | 10 | 3 | 8 | 28856 | 29 | |||
120144 | 188583 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 20 | Median : Yard | Tree | DPW 1 | 5 | 6012480.57258 | 2103516.62994 | 37.7565587070348 | -122.399815946472 | (37.7565587070348, -122.399815946472) | 10 | 3 | 8 | 28856 | 29 | ||||
122333 | 188597 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1050 Wisconsin St | 3 | : | Tree | Private 2 | 15 | Width 5ft | 6012781.38051 | 2102548.17796 | 37.7539163136043 | -122.398707676835 | (37.7539163136043, -122.398707676835) | 10 | 3 | 8 | 28856 | 29 | |||
125545 | 188586 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 45 | Median : Yard | Tree | DPW 1 | 18 | 6012501.01622 | 2103043.06832 | 37.7552595500099 | -122.399711994725 | (37.7552595500099, -122.399711994725) | 10 | 3 | 8 | 28856 | 29 | ||||
131975 | 188576 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 221 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012925.63682 | 2105961.69181 | 37.7632971112832 | -122.398448304248 | (37.7632971112832, -122.398448304248) | 14 | 3 | 8 | 28856 | 29 | |||
136428 | 188579 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1900 18th St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6011941.53621 | 2105635.92971 | 37.7623477698519 | -122.401829104925 | (37.7623477698519, -122.401829104925) | 8 | 3 | 8 | 28856 | 29 | |||
139858 | 188580 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 6 | Median : Yard | Tree | DPW 1 | 11 | 6012471.14702 | 2103650.00365 | 37.7569243965657 | -122.399857908838 | (37.7569243965657, -122.399857908838) | 10 | 3 | 8 | 28856 | 29 | ||||
140579 | 109579 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 290x ARKANSAS ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012903 | 2105890 | 37.7630990003622 | -122.398521567136 | (37.7630990003622, -122.398521567136) | 14 | 3 | 8 | 28856 | 29 | |||
143828 | 188599 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1099 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6012848.11967 | 2102532.63168 | 37.753877345082 | -122.398475784828 | (37.753877345082, -122.398475784828) | 10 | 3 | 8 | 28856 | 29 | ||||
144610 | 188568 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 24th St | 24 | : Yard | Tree | Private 2 | 38 | 6017120.70508 | 2102612.37668 | 37.7543334029878 | -122.383705595635 | (37.7543334029878, -122.383705595635) | 10 | 3 | 8 | 28856 | 29 | ||||
146761 | 188595 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/05/2017 12:00:00 AM | 3 | Width 7ft | 6011997.61193 | 2102271.8897 | 37.7531139870419 | -122.401398733477 | (37.7531139870419, -122.401398733477) | 10 | 3 | 8 | 28856 | 29 | ||
149578 | 3765 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1074 Carolina St | 3 | Median : Cutout | Tree | DPW 1 | 15 | 18 | 6012456.6037355 | 2102966.9856684 | 37.7550481677782 | -122.399860245008 | (37.7550481677782, -122.399860245008) | 10 | 3 | 8 | 28856 | 29 | |||
149615 | 188590 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 762 De Haro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 2ft | 6012084.87947 | 2104884.86073 | 37.7602934997697 | -122.401280549067 | (37.7602934997697, -122.401280549067) | 10 | 3 | 8 | 28856 | 29 | |||
150374 | 87050 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 139 Welsh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | Permit Number 49986 | 6013132.69582 | 2111542.77268 | 37.7786330379242 | -122.398123719151 | (37.7786330379242, -122.398123719151) | 6 | 2 | 9 | 28856 | 34 | ||
150456 | 188591 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 762 De Haro St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 2ft | 6012098.14806 | 2104884.14995 | 37.7602922883855 | -122.401234609004 | (37.7602922883855, -122.401234609004) | 10 | 3 | 8 | 28856 | 29 | |||
152080 | 110880 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
157395 | 188569 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 24th St | 26 | : Yard | Tree | Private 2 | 5 | 6017110.36972 | 2102585.17266 | 37.7542581351188 | -122.383739444343 | (37.7542581351188, -122.383739444343) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||
161329 | 3758 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1056 Carolina St | 3 | Median : Cutout | Tree | DPW 1 | 15 | 18 | 6012452.0863519 | 2103047.5184298 | 37.7552690413169 | -122.399881522302 | (37.7552690413169, -122.399881522302) | 10 | 3 | 8 | 28856 | 29 | |||
161741 | 188581 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 18 | Median : Yard | Tree | DPW 1 | 5 | 6012475.30485 | 2103528.81943 | 37.7565918830377 | -122.39983502019 | (37.7565918830377, -122.39983502019) | 10 | 3 | 8 | 28856 | 29 | ||||
163150 | 106241 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 De Haro St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Permit Number 770844 | 6012039.11056 | 2105754.27928 | 37.7626781762725 | -122.401499947673 | (37.7626781762725, -122.401499947673) | 8 | 3 | 8 | 28856 | 29 | |||
163747 | 35381 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 531 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 3 | Permit Number 38837 | 6011249.26692 | 2105860.5302 | 37.7629258144837 | -122.404239227767 | (37.7629258144837, -122.404239227767) | 8 | 3 | 8 | 28856 | 29 | |
166203 | 106317 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1133 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 4x4 | 6012240.80146 | 2103138.9754 | 37.7555083807236 | -122.400618637234 | (37.7555083807236, -122.400618637234) | 10 | 3 | 8 | 28856 | 29 | |||
167896 | 188570 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 328 Pennsylvania Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 4ft | 6014297.15986 | 2105489.98381 | 37.7620782133638 | -122.393671602866 | (37.7620782133638, -122.393671602866) | 10 | 3 | 8 | 28856 | 29 | |||
178025 | 188577 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 601 Wisconsin St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 6012719.59106 | 2104609.18405 | 37.7595719430959 | -122.399066014392 | (37.7595719430959, -122.399066014392) | 10 | 3 | 8 | 28856 | 29 | |||
181170 | 188604 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 651 Missouri St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6013619.15736 | 2103860.82148 | 37.7575671905977 | -122.395902402686 | (37.7575671905977, -122.395902402686) | 10 | 3 | 8 | 28856 | 29 | ||||
184450 | 188717 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 139 Welsh St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6013144.74894 | 2111553.30162 | 37.7786626193181 | -122.398082761329 | (37.7786626193181, -122.398082761329) | 6 | 2 | 9 | 28856 | 34 | |||
192134 | 3768 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1098 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.399831953417 | (37.754754478768, -122.399831953417) | 10 | 3 | 8 | 28856 | 29 | |||
192235 | 188596 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Rhode Island St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 7ft | 6011998.11194 | 2102296.49626 | 37.7531815791825 | -122.401398733471 | (37.7531815791825, -122.401398733471) | 10 | 3 | 8 | 28856 | 29 | |||
192871 | 173728 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 994 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | 6012439 | 2103318 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | 10 | 3 | 8 | 28856 | 29 | |||
8099 | 125296 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 510 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6010613.51109 | 2116010.55836 | 37.7907598831005 | -122.407153607672 | (37.7907598831005, -122.407153607672) | 5 | 1 | 10 | 28857 | 6 | |||
28763 | 30315 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1955 12:00:00 AM | Permit Number 12 | 6009097.70753924 | 2116729.99483623 | 37.7926503347532 | -122.412449106972 | (37.7926503347532, -122.412449106972) | 3 | 1 | 10 | 28857 | 21 | |||
32274 | 125245 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1360 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008932.39466 | 2117598.66545 | 37.7950262129353 | -122.413082548334 | (37.7950262129353, -122.413082548334) | 3 | 1 | 10 | 28857 | 21 | |||
35573 | 125242 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1182 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009131.5618 | 2116725.13893 | 37.7926389014101 | -122.412331626128 | (37.7926389014101, -122.412331626128) | 3 | 1 | 10 | 28857 | 21 | |||
52641 | 30419 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 599 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/1956 12:00:00 AM | Permit Number 74 | 6011244.65303661 | 2117958.27162773 | 37.7961431366669 | -122.405107081517 | (37.7961431366669, -122.405107081517) | 3 | 1 | 10 | 28857 | 4 | |||
58946 | 30316 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1955 12:00:00 AM | Permit Number 12 | 6009097.70753924 | 2116729.99483623 | 37.7926503347532 | -122.412449106972 | (37.7926503347532, -122.412449106972) | 3 | 1 | 10 | 28857 | 21 | |||
68481 | 30420 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 599 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/1956 12:00:00 AM | Permit Number 74 | 6011244.65303661 | 2117958.27162773 | 37.7961431366669 | -122.405107081517 | (37.7961431366669, -122.405107081517) | 3 | 1 | 10 | 28857 | 4 | |||
129651 | 57519 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1360 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1976 12:00:00 AM | 20 | Permit Number 16376 | 6008935.45982 | 2117576.86679 | 37.7949665312373 | -122.413070400293 | (37.7949665312373, -122.413070400293) | 3 | 1 | 10 | 28857 | 21 | ||
144302 | 125243 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1104 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009053.21335 | 2116742.15684 | 37.7926812316006 | -122.412603919261 | (37.7926812316006, -122.412603919261) | 3 | 1 | 10 | 28857 | 21 | |||
144741 | 125246 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1360 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008930.33256 | 2117617.25148 | 37.7950771298478 | -122.413090998371 | (37.7950771298478, -122.413090998371) | 3 | 1 | 10 | 28857 | 21 | |||
146909 | 125241 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1182 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009140.01829 | 2116726.36565 | 37.7926427442163 | -122.41230245299 | (37.7926427442163, -122.41230245299) | 3 | 1 | 10 | 28857 | 21 | |||
165575 | 125244 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1340 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008943.92506 | 2117535.50135 | 37.7948534271028 | -122.413038182973 | (37.7948534271028, -122.413038182973) | 3 | 1 | 10 | 28857 | 21 |
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) );