Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PermitNotes
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188905 | 188905 | 200550 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016212.9331 | 2095623.1152 | 37.7350921083386 | -122.386357662249 | (37.7350921083386, -122.386357662249) | |||
| 188008 | 188008 | 187747 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Dukes Ct | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016140.5122 | 2096271.0286 | 37.7368671389145 | -122.38665321539801 | (37.7368671389145, -122.386653215398) | ||||
| 187646 | 187646 | 200535 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6016168.4829 | 2095664.0064 | 37.735201926775396 | -122.386514194261 | (37.7352019267754, -122.386514194261) | |||
| 187551 | 187551 | 188647 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6018073.116719999 | 2098111.74487 | 37.7420281826481 | -122.38009915058001 | (37.7420281826481, -122.38009915058) | ||||
| 186731 | 186731 | 188739 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 8ft | 6014439.36233 | 2086971.4204900002 | 37.7112379444543 | -122.39188480373801 | (37.7112379444543, -122.391884803738) | |||
| 186558 | 186558 | 187746 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Dukes Ct | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6016141.394640001 | 2096265.75957 | 37.7368527200761 | -122.38664979707501 | (37.7368527200761, -122.386649797075) | ||||
| 180983 | 180983 | 200531 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016156.3167 | 2095682.0459 | 37.7352507861079 | -122.386557515095 | (37.7352507861079, -122.386557515095) | |||
| 178538 | 178538 | 188740 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6014461.35341 | 2086969.95596 | 37.711235143968 | -122.391808694124 | (37.711235143968, -122.391808694124) | |||
| 177749 | 177749 | 200602 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 45 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016396.2402 | 2095212.996 | 37.7339761481789 | -122.385695323117 | (37.7339761481789, -122.385695323117) | |||
| 175369 | 175369 | 188654 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6017424.39169 | 2098619.4012 | 37.7433862929421 | -122.382377569482 | (37.7433862929421, -122.382377569482) | ||||
| 174842 | 174842 | 203828 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200x Terrace Dr | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5993850.84574 | 2096478.66288 | 37.7361780477826 | -122.463732909161 | (37.7361780477826, -122.463732909161) | ||||
| 174612 | 174612 | 188734 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014314.36158 | 2086981.8522700001 | 37.71125964778079 | -122.39231757011801 | (37.7112596477808, -122.392317570118) | |||
| 173916 | 173916 | 200530 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6016148.3458 | 2095686.6607 | 37.735263016153105 | -122.386585395355 | (37.7352630161531, -122.386585395355) | |||
| 173558 | 173558 | 188762 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6014035.24999 | 2087007.2689599998 | 37.71131393444921 | -122.39328403465299 | (37.7113139344492, -122.393284034653) | |||
| 172385 | 172385 | 200555 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016252.4072 | 2095574.3949 | 37.7349605171331 | -122.386217789361 | (37.7349605171331, -122.386217789361) | |||
| 170303 | 170303 | 188764 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 8ft | 6014090.1968 | 2087004.6185400002 | 37.711309709434 | -122.393093937756 | (37.711309709434, -122.393093937756) | |||
| 169431 | 169431 | 200546 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016197.8191 | 2095632.8949 | 37.735118124804394 | -122.386410598906 | (37.7351181248044, -122.386410598906) | |||
| 169201 | 169201 | 200549 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6016205.8206 | 2095623.8265 | 37.7350936677212 | -122.386382302519 | (37.7350936677212, -122.386382302519) | |||
| 169172 | 169172 | 200560 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016311.7963 | 2095496.5134 | 37.7347499571366 | -122.38600703115401 | (37.7347499571366, -122.386007031154) | |||
| 168939 | 168939 | 188741 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 8ft | 6014489.73327 | 2086967.85233 | 37.7112309432358 | -122.39171045846399 | (37.7112309432358, -122.391710458464) | |||
| 168459 | 168459 | 188642 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Cargo Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6018846.51114 | 2097536.89048 | 37.7404923843103 | -122.377385089264 | (37.7404923843103, -122.377385089264) | ||||
| 166786 | 166786 | 188760 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 6013911.80932 | 2087014.9974599998 | 37.7113282966477 | -122.393711220721 | (37.7113282966477, -122.393711220721) | |||
| 166461 | 166461 | 188581 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012475.30485 | 2103528.81943 | 37.75659188303771 | -122.39983502019 | (37.7565918830377, -122.39983502019) | ||||
| 165803 | 165803 | 203827 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200x Terrace Dr | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993824.2375 | 2096507.58297 | 37.7362559218691 | -122.463827002518 | (37.7362559218691, -122.463827002518) | ||||
| 163769 | 163769 | 140181 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2056 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 33 | Width 0ft | 5997583.5904 | 2109565.3677 | 37.772325267986005 | -122.451771113904 | (37.772325267986, -122.451771113904) | |||
| 163246 | 163246 | 187737 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6016156.13559 | 2096195.78467 | 37.7366613992076 | -122.386593952757 | (37.7366613992076, -122.386593952757) | ||||
| 161533 | 161533 | 137824 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2188 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6003455.9057 | 2115246.8302 | 37.7882597174515 | -122.431863995218 | (37.7882597174515, -122.431863995218) | |||
| 159528 | 159528 | 7699 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 640 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1991 12:00:00 AM | 15 | 7x7 | 6008241.9422 | 2121047.1896 | 37.804456215657 | -122.415715918685 | (37.804456215657, -122.415715918685) | ||
| 159406 | 159406 | 200605 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 46 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6016398.6886 | 2095199.7747 | 37.7339399806144 | -122.385685937001 | (37.7339399806144, -122.385685937001) | |||
| 158166 | 158166 | 188643 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6018388.81738 | 2097879.37789 | 37.7414075614118 | -122.378991412446 | (37.7414075614118, -122.378991412446) | ||||
| 157079 | 157079 | 187711 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 51x Executive Park Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 6013709.84578 | 2087009.9917799998 | 37.711303326954706 | -122.394408912955 | (37.7113033269547, -122.394408912955) | |||
| 155305 | 155305 | 188580 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012471.14702 | 2103650.00365 | 37.7569243965657 | -122.399857908838 | (37.7569243965657, -122.399857908838) | ||||
| 155047 | 155047 | 187744 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Dukes Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6016140.58365 | 2096258.2267599998 | 37.736831991603296 | -122.38665207592899 | (37.7368319916033, -122.386652075929) | ||||
| 153767 | 153767 | 187700 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 8ft | 6014134.283869999 | 2086999.7269 | 37.7112987269389 | -122.392941218475 | (37.7112987269389, -122.392941218475) | |||
| 153654 | 153654 | 188652 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6017392.84765 | 2098647.1595799997 | 37.7434607693943 | -122.382488572792 | (37.7434607693943, -122.382488572792) | ||||
| 153209 | 153209 | 200532 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016155.8972 | 2095677.4311 | 37.7352380915724 | -122.386558643793 | (37.7352380915724, -122.386558643793) | |||
| 152573 | 152573 | 187713 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 51x Executive Park Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013756.4546300005 | 2087023.9293400003 | 37.71134418764721 | -122.394248794959 | (37.7113441876472, -122.394248794959) | |||
| 149419 | 149419 | 188738 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014415.87146 | 2086974.70005 | 37.7112456453465 | -122.39196622388799 | (37.7112456453465, -122.391966223888) | |||
| 147853 | 147853 | 188761 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 8ft | 6013991.40971 | 2087009.0790099998 | 37.7113164687655 | -122.39343568552 | (37.7113164687655, -122.39343568552) | |||
| 147407 | 147407 | 188588 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 57 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6012513.0739 | 2102944.23906 | 37.754988858573 | -122.399663356681 | (37.754988858573, -122.399663356681) | ||||
| 146596 | 146596 | 188586 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 45 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012501.01622 | 2103043.06832 | 37.755259550009896 | -122.399711994725 | (37.7552595500099, -122.399711994725) | ||||
| 146148 | 146148 | 8247 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1500X Galvez Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | |||
| 145878 | 145878 | 89262 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Polk St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||||
| 145485 | 145485 | 8238 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1500X Galvez Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6X3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | |||
| 144728 | 144728 | 18076 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2946 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999836.5548472 | 2114739.1098541 | 37.786659810658 | -122.444349803762 | (37.786659810658, -122.444349803762) | |||
| 144696 | 144696 | 6745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300X Fairfax Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 144451 | 144451 | 6739 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300X Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 144252 | 144252 | 24224 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 56 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/21/2016 12:00:00 AM | 18 | 3x3 | 6016378.0406117 | 2096157.2731291 | 37.736567936527706 | -122.38582404056801 | (37.7365679365277, -122.385824040568) | ||
| 144110 | 144110 | 6777 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1355 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016787.8631263 | 2097291.0360598997 | 37.7397036915046 | -122.38448604022699 | (37.7397036915046, -122.384486040227) | |||
| 143942 | 143942 | 14544 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 740 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5x5 | 5999285.75973 | 2110200.8265 | 37.7741674161959 | -122.445928888319 | (37.7741674161959, -122.445928888319) | |||
| 143817 | 143817 | 6684 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1555X Evans Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6015913.3615039 | 2098275.7507256 | 37.7423591192364 | -122.387578402998 | (37.7423591192364, -122.387578402998) | |||
| 143772 | 143772 | 6569 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1303 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017171.79019 | 2097333.44943 | 37.7398413732106 | -122.38316152235001 | (37.7398413732106, -122.38316152235) | |||
| 143490 | 143490 | 111510 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 800x BOSWORTH ST | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 20 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 143466 | 143466 | 22635 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1198 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/1997 12:00:00 AM | 24 | 3X3 | 6004485.54395 | 2112758.65374 | 37.781486120602295 | -122.428124228455 | (37.7814861206023, -122.428124228455) | ||
| 143355 | 143355 | 111556 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x BOSWORTH ST | 34 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 143273 | 143273 | 6432 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100X Evans Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | |||
| 143150 | 143150 | 24212 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 80X Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/2002 12:00:00 AM | 9 | 3x3 | 6016364.4746918 | 2096121.5533417999 | 37.736469106467 | -122.38586845516501 | (37.736469106467, -122.385868455165) | ||
| 143064 | 143064 | 12729 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5990435.001209999 | 2114760.85795 | 37.786178638116 | -122.47687815891899 | (37.786178638116, -122.476878158919) | |||
| 142876 | 142876 | 6571 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1325 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017110.864965701 | 2097380.9593528 | 37.7399684589918 | -122.383375484618 | (37.7399684589918, -122.383375484618) | |||
| 142561 | 142561 | 6729 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Fairfax Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 142342 | 142342 | 22141 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3795X 03rd St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015845.491830001 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | |||
| 142135 | 142135 | 339 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3590X 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | |||
| 141992 | 141992 | 89458 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3500X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987773.9063 | 2111900.8711599996 | 37.7781711994801 | -122.48587473348199 | (37.7781711994801, -122.485874733482) | ||
| 141903 | 141903 | 21256 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2403X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5985057.6849307995 | 2098850.8710983 | 37.7421808791716 | -122.49430882372101 | (37.7421808791716, -122.494308823721) | |||
| 141717 | 141717 | 111239 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 399x LIBERTY ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 3x3 | 6003700.0 | 2103889.0 | 37.7570877346209 | -122.430208863755 | (37.7570877346209, -122.430208863755) | |||
| 141624 | 141624 | 6868 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 159 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006613.508669999 | 2110773.53548 | 37.7761556337886 | -122.420621521067 | (37.7761556337886, -122.420621521067) | |||
| 141617 | 141617 | 22139 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3795X 03rd St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016052.83329 | 2099030.3161 | 37.744438725117604 | -122.38714876688 | (37.7444387251176, -122.38714876688) | |||
| 141559 | 141559 | 10422 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1407 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 5999387.74957 | 2108726.3420700002 | 37.7701246795762 | -122.44547004321699 | (37.7701246795762, -122.445470043217) | |||
| 141362 | 141362 | 6895 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 310 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6005919.22167 | 2110721.45895 | 37.775973490885 | -122.423019548176 | (37.775973490885, -122.423019548176) | |||
| 141304 | 141304 | 7008 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1010 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002586.66205 | 2110263.38045 | 37.774527105466 | -122.434514968983 | (37.774527105466, -122.434514968983) | |||
| 141167 | 141167 | 111532 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x BOSWORTH ST | 10 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 141102 | 141102 | 6165 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000X Ellis St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006064.53658 | 2113525.24895 | 37.7836802135181 | -122.42271616148199 | (37.7836802135181, -122.422716161482) | |||
| 140921 | 140921 | 21502 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5985062.8642150005 | 2096221.8871717 | 37.7349626975104 | -122.494097196305 | (37.7349626975104, -122.494097196305) | |||
| 140507 | 140507 | 23575 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3100X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005553.25134 | 2120985.40407 | 37.80413505895721 | -122.42501598068701 | (37.8041350589572, -122.425015980687) | |||
| 139842 | 139842 | 5418 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 430X Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 6 | 6004853.970832599 | 2105864.857711 | 37.7625782660478 | -122.42635866544599 | (37.7625782660478, -122.426358665446) | |||
| 139747 | 139747 | 8235 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1500X Galvez Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | |||
| 139725 | 139725 | 5916 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1265 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004485.54395 | 2112758.65374 | 37.781486120602295 | -122.428124228455 | (37.7814861206023, -122.428124228455) | |||
| 139429 | 139429 | 24201 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 80X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x5 | 6016364.4746918 | 2096121.5533417999 | 37.736469106467 | -122.38586845516501 | (37.736469106467, -122.385868455165) | |||
| 139321 | 139321 | 11851 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1401X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3 | 5991539.129622 | 2088082.4465586997 | 37.712990637147605 | -122.471113878415 | (37.7129906371476, -122.471113878415) | |||
| 138777 | 138777 | 22638 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/1990 12:00:00 AM | 6 | 3X3 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | ||
| 138741 | 138741 | 5911 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1245 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004490.90647 | 2112892.55275 | 37.7818540774754 | -122.42811522182501 | (37.7818540774754, -122.428115221825) | |||
| 138453 | 138453 | 6486 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Evans Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017283.44001 | 2097385.77201 | 37.739991209593605 | -122.38277912044599 | (37.7399912095936, -122.382779120446) | |||
| 137789 | 137789 | 188763 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 8ft | 6014060.27429 | 2087007.0702 | 37.711314778934295 | -122.39319752976601 | (37.7113147789343, -122.393197529766) | |||
| 137749 | 137749 | 200543 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016187.8616 | 2095644.6304 | 37.7351497969246 | -122.38644584387501 | (37.7351497969246, -122.386445843875) | |||
| 137718 | 137718 | 188648 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6018027.576669999 | 2098147.2670299998 | 37.7421232068329 | -122.380259083311 | (37.7421232068329, -122.380259083311) | ||||
| 137314 | 137314 | 200611 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6016421.2138 | 2095153.2552 | 37.7338134937512 | -122.385604818769 | (37.7338134937512, -122.385604818769) | |||
| 137306 | 137306 | 125295 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1306x Montgomery St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6011445.958380001 | 2119999.7387 | 37.801759761770604 | -122.40455429893998 | (37.8017597617706, -122.40455429894) | |||
| 137116 | 137116 | 188583 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012480.57258 | 2103516.6299400004 | 37.7565587070348 | -122.399815946472 | (37.7565587070348, -122.399815946472) | ||||
| 137062 | 137062 | 188645 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6018140.58939 | 2098064.90862 | 37.7419033019107 | -122.37986259559601 | (37.7419033019107, -122.379862595596) | ||||
| 136589 | 136589 | 188651 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6017373.9642900005 | 2098663.52344 | 37.7435046581055 | -122.38255500572399 | (37.7435046581055, -122.382555005724) | ||||
| 134402 | 134402 | 200552 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6016213.9999 | 2095615.2915 | 37.7350706850821 | -122.386353428604 | (37.7350706850821, -122.386353428604) | |||
| 133969 | 133969 | 188661 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6016926.49281 | 2099019.67279 | 37.7444578423491 | -122.384127062023 | (37.7444578423491, -122.384127062023) | ||||
| 133838 | 133838 | 188745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014589.916680001 | 2086958.4326 | 37.711210639227 | -122.39136353872101 | (37.711210639227, -122.391363538721) | |||
| 133833 | 133833 | 188653 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6017421.68385 | 2098629.86939 | 37.7434148869 | -122.382387660761 | (37.7434148869, -122.382387660761) | ||||
| 133613 | 133613 | 200541 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016186.7948 | 2095652.8098 | 37.7351721968582 | -122.386450102344 | (37.7351721968582, -122.386450102344) | |||
| 133432 | 133432 | 203808 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 335x Pacheco St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5994148.64523 | 2101441.5060099997 | 37.7498219260394 | -122.46306327486 | (37.7498219260394, -122.46306327486) | |||
| 133316 | 133316 | 203782 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 66x Santa Monica Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 5993630.457230001 | 2097428.51442 | 37.7387734012664 | -122.46456382517599 | (37.7387734012664, -122.464563825176) | ||||
| 133052 | 133052 | 203807 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 335x Pacheco St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5994179.6676199995 | 2101287.15386 | 37.7493999011887 | -122.46294480178699 | (37.7493999011887, -122.462944801787) | |||
| 131211 | 131211 | 200607 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016406.5235 | 2095183.1256 | 37.73389469904829 | -122.385657689133 | (37.7338946990483, -122.385657689133) | |||
| 130923 | 130923 | 188582 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012479.86277 | 2103522.41115 | 37.7565745414011 | -122.39981880719999 | (37.7565745414011, -122.3998188072) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");