Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1444 | 1444 | 187918 | Undocumented 2 | Betula pendula :: European White Birch 146 | 48 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013111.47563 | 2115056.38033 | 37.7882794108076 | -122.398443735705 | (37.7882794108076, -122.398443735705) | |||
| 2561 | 2561 | 125719 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3633 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | Permit Number 780396 | 5999650.86982 | 2121041.96427 | 37.803955181350105 | -122.44544560095801 | (37.8039551813501, -122.445445600958) | ||
| 8151 | 8151 | 2604 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 1760 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005055.9243 | 2115124.595 | 37.7880146622895 | -122.426319487223 | (37.7880146622895, -122.426319487223) | |||
| 15106 | 15106 | 104458 | DPW Maintained 3 | Betula pendula :: European White Birch 146 | 1601X Kansas St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011832.95066 | 2100589.70632 | 37.748485888729206 | -122.40184993054501 | (37.7484858887292, -122.401849930545) | |||
| 22217 | 22217 | 16060 | DPW Maintained 3 | Betula pendula :: European White Birch 146 | 231 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2002 12:00:00 AM | 6 | 3x3 | 6000534.94715 | 2094624.2406099997 | 37.7314691327835 | -122.440490331957 | (37.7314691327835, -122.440490331957) | ||
| 23904 | 23904 | 122926 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2 11th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5992433.415569999 | 2114874.23335 | 37.7866056586788 | -122.46997249221701 | (37.7866056586788, -122.469972492217) | |||
| 25121 | 25121 | 221244 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3961 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004104.16813 | 2101283.0183099997 | 37.7499552046892 | -122.428625337904 | (37.7499552046892, -122.428625337904) | |||
| 26443 | 26443 | 83812 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1401 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 4 | 6008431.92619 | 2117409.9703900004 | 37.794479995297706 | -122.41480088836201 | (37.7944799952977, -122.414800888362) | ||
| 29144 | 29144 | 205629 | Undocumented 2 | Betula pendula :: European White Birch 146 | 714 Detroit St | 18 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999458.60233 | 2095454.85434 | 37.7336884554611 | -122.444271115125 | (37.7336884554611, -122.444271115125) | ||||
| 29156 | 29156 | 221241 | Undocumented 2 | Betula pendula :: European White Birch 146 | 4239 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002260.12391 | 2101180.90395 | 37.749570289451206 | -122.434994824965 | (37.7495702894512, -122.434994824965) | |||
| 29355 | 29355 | 221258 | Undocumented 2 | Betula pendula :: European White Birch 146 | 415 Roosevelt Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6000035.965009999 | 2106651.69719 | 37.7644652074247 | -122.443078862299 | (37.7644652074247, -122.443078862299) | |||
| 30460 | 30460 | 188821 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1360 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6011964.420059999 | 2102037.47464 | 37.7524684824455 | -122.40149704467 | (37.7524684824455, -122.40149704467) | |||
| 31957 | 31957 | 43034 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 2488 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2000 12:00:00 AM | 4 | Permit Number 42894 | 6000712.8749 | 2114163.5032 | 37.7851293023636 | -122.441276640017 | (37.7851293023636, -122.441276640017) | ||
| 33734 | 33734 | 53406 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 1911 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1969 12:00:00 AM | 10 | Permit Number 6305 | 6003659.05239 | 2119321.24643 | 37.7994585351485 | -122.431452119331 | (37.7994585351485, -122.431452119331) | ||
| 35252 | 35252 | 221239 | Undocumented 2 | Betula pendula :: European White Birch 146 | 207 Montcalm St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 5ft | 6010023.25186 | 2099680.69535 | 37.745888782448 | -122.40804376831001 | (37.745888782448, -122.40804376831) | |||
| 35290 | 35290 | 246664 | Undocumented 2 | Betula pendula :: European White Birch 146 | 199 Ripley St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6009278.25591 | 2099147.59865 | 37.7443832759831 | -122.410582232494 | (37.7443832759831, -122.410582232494) | |||
| 36232 | 36232 | 246668 | Undocumented 2 | Betula pendula :: European White Birch 146 | 199 Ripley St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6009255.34183 | 2099144.3837900003 | 37.744373163998794 | -122.410661237926 | (37.7443731639988, -122.410661237926) | |||
| 37014 | 37014 | 221226 | Undocumented 2 | Betula pendula :: European White Birch 146 | 88 Crescent Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6005769.38033 | 2095838.80012 | 37.7351007121151 | -122.422480144438 | (37.7351007121151, -122.422480144438) | |||
| 38387 | 38387 | 221259 | Undocumented 2 | Betula pendula :: European White Birch 146 | 415 Roosevelt Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6000035.50507 | 2106652.6628099997 | 37.7644678325525 | -122.443080522454 | (37.7644678325525, -122.443080522454) | |||
| 38830 | 38830 | 119928 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3750 Anza St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 5986949.49746 | 2111884.4903599997 | 37.7780781472848 | -122.488725421171 | (37.7780781472848, -122.488725421171) | |||
| 38975 | 38975 | 188826 | Undocumented 2 | Betula pendula :: European White Birch 146 | 30 Apparel Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 10ft | 6011479.87001 | 2097597.73226 | 37.7402508605846 | -122.402860485238 | (37.7402508605846, -122.402860485238) | |||
| 40662 | 40662 | 83810 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1401 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 4 | 6008433.54799 | 2117383.58824 | 37.7944076475381 | -122.414793408706 | (37.7944076475381, -122.414793408706) | ||
| 40955 | 40955 | 182042 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1329 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5987076.1241 | 2106191.7238 | 37.7624547889055 | -122.487869010507 | (37.7624547889055, -122.487869010507) | |||
| 41311 | 41311 | 205623 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1664 09th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 6ft | 5993427.80245 | 2104143.27983 | 37.7571987518308 | -122.46575223428002 | (37.7571987518308, -122.46575223428) | |||
| 41732 | 41732 | 125725 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2800 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | Width 4ft | 6003533.81623 | 2118024.94741 | 37.7958921341649 | -122.431792874238 | (37.7958921341649, -122.431792874238) | |||
| 42400 | 42400 | 249672 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2400 Baker St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 5999740.71389 | 2117125.7737 | 37.7932074950865 | -122.444853013365 | (37.7932074950865, -122.444853013365) | ||||
| 42468 | 42468 | 221234 | Undocumented 2 | Betula pendula :: European White Birch 146 | 100 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999851.0867800005 | 2106942.56431 | 37.765253313001104 | -122.443739201223 | (37.7652533130011, -122.443739201223) | |||
| 43130 | 43130 | 188825 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1888 Illinois St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6016272.37699 | 2100354.77616 | 37.7480875745024 | -122.38648195390199 | (37.7480875745024, -122.386481953902) | |||
| 43430 | 43430 | 246655 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009062.9897 | 2099201.46712 | 37.7445191158731 | -122.411330385684 | (37.7445191158731, -122.411330385684) | ||||
| 43580 | 43580 | 205622 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1664 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 6ft | 5993427.025909999 | 2104158.61423 | 37.757240811325396 | -122.46575603393299 | (37.7572408113254, -122.465756033933) | |||
| 44131 | 44131 | 246656 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009063.73811 | 2099209.72554 | 37.744541833651205 | -122.411328381118 | (37.7445418336512, -122.411328381118) | ||||
| 44741 | 44741 | 96983 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 2800X Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | Permit Number 25529 | 6003522.3427099995 | 2118089.29041 | 37.796068153086 | -122.431837171257 | (37.796068153086, -122.431837171257) | |||
| 48421 | 48421 | 221233 | Undocumented 2 | Betula pendula :: European White Birch 146 | 959 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5999213.29336 | 2106736.99218 | 37.764652465156296 | -122.445930382297 | (37.7646524651563, -122.445930382297) | |||
| 48449 | 48449 | 188813 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2005 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6011398.91522 | 2106483.38138 | 37.764644384756295 | -122.403765472117 | (37.7646443847563, -122.403765472117) | |||
| 48977 | 48977 | 118192 | Undocumented 2 | Betula pendula :: European White Birch 146 | 870 34th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 5985454.65215 | 2109961.46121 | 37.7727107105884 | -122.49375480907801 | (37.7727107105884, -122.493754809078) | |||
| 49863 | 49863 | 201921 | Undocumented 2 | Betula pendula :: European White Birch 146 | 251 Elmira St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6011262.31723 | 2095298.9065900003 | 37.7339266228979 | -122.403451011558 | (37.7339266228979, -122.403451011558) | |||
| 50476 | 50476 | 205624 | Undocumented 2 | Betula pendula :: European White Birch 146 | 76 Dorado Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5994666.363480001 | 2093043.17057 | 37.726791984541 | -122.460664466391 | (37.726791984541, -122.460664466391) | |||
| 50665 | 50665 | 125722 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2800 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 43 | Width 4ft | 6003540.897890001 | 2117978.1784900003 | 37.79576412017221 | -122.431765029446 | (37.7957641201722, -122.431765029446) | |||
| 52192 | 52192 | 188820 | Undocumented 2 | Betula pendula :: European White Birch 146 | 542 Rhode Island St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6011747.11762 | 2105836.05521 | 37.762886417896105 | -122.402515603339 | (37.7628864178961, -122.402515603339) | |||
| 53073 | 53073 | 45069 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 2342 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 1 | Permit Number 43950 | 5987976.057999999 | 2099354.9145 | 37.7437352024597 | -122.484255080791 | (37.7437352024597, -122.484255080791) | |
| 53629 | 53629 | 246663 | Undocumented 2 | Betula pendula :: European White Birch 146 | 199 Ripley St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6009284.026980001 | 2099145.63944 | 37.7443782199713 | -122.410562138936 | (37.7443782199713, -122.410562138936) | |||
| 54013 | 54013 | 205631 | Undocumented 2 | Betula pendula :: European White Birch 146 | 575 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997625.37586 | 2095236.46508 | 37.732984049775 | -122.450593347312 | (37.732984049775, -122.450593347312) | ||||
| 54582 | 54582 | 175567 | Undocumented 2 | Betula pendula :: European White Birch 146 | 11 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6005362.505369999 | 2093198.294 | 37.7278275062278 | -122.42369917638399 | (37.7278275062278, -122.423699176384) | ||||
| 55826 | 55826 | 188822 | Undocumented 2 | Betula pendula :: European White Birch 146 | 634 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6013248.11041 | 2104140.8064099997 | 37.7583153186119 | -122.397205274799 | (37.7583153186119, -122.397205274799) | |||
| 56150 | 56150 | 249670 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2400 Baker St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5999738.32822 | 2117112.31021 | 37.7931703917478 | -122.444860299664 | (37.7931703917478, -122.444860299664) | ||||
| 56202 | 56202 | 221255 | Undocumented 2 | Betula pendula :: European White Birch 146 | 190 Storrie St | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | Width 3ft | 6000864.196380001 | 2105365.8102700002 | 37.7609816672784 | -122.44012202902901 | (37.7609816672784, -122.440122029029) | |||
| 56381 | 56381 | 221254 | Undocumented 2 | Betula pendula :: European White Birch 146 | 190 Storrie St | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 3ft | 6000848.026869999 | 2105351.68108 | 37.760941951434205 | -122.440176938936 | (37.7609419514342, -122.440176938936) | |||
| 57887 | 57887 | 125718 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2640 Baker St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5999647.29192 | 2117942.60515 | 37.7954449660715 | -122.445235012993 | (37.7954449660715, -122.445235012993) | |||
| 58884 | 58884 | 139003 | Undocumented 2 | Betula pendula :: European White Birch 146 | 100 COLE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997839.6299 | 2110249.6827 | 37.7742188812286 | -122.45093480729099 | (37.7742188812286, -122.450934807291) | |||
| 59668 | 59668 | 246653 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009062.80504 | 2099192.42716 | 37.7444942837766 | -122.411330385709 | (37.7444942837766, -122.411330385709) | ||||
| 60408 | 60408 | 125724 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2800 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | Width 4ft | 6003536.06003 | 2118009.60299 | 37.7958501295278 | -122.43178401413601 | (37.7958501295278, -122.431784014136) | |||
| 60715 | 60715 | 221246 | Undocumented 2 | Betula pendula :: European White Birch 146 | 233 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6001130.702740001 | 2104859.07812 | 37.759605473426 | -122.439163982134 | (37.759605473426, -122.439163982134) | |||
| 61306 | 61306 | 205626 | Undocumented 2 | Betula pendula :: European White Birch 146 | 218 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5999958.486330001 | 2094391.5460599998 | 37.7307973661877 | -122.442466560705 | (37.7307973661877, -122.442466560705) | ||||
| 61674 | 61674 | 175564 | Undocumented 2 | Betula pendula :: European White Birch 146 | 86 San Gabriel Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6000983.71045 | 2093588.2828799998 | 37.7286501745611 | -122.43886466438101 | (37.7286501745611, -122.438864664381) | ||||
| 61739 | 61739 | 82352 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 195 Dublin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 13 | 3x3 | Permit Number 50648 | 6004202.82726 | 2089290.65992 | 37.717032471538296 | -122.42742995003401 | (37.7170324715383, -122.427429950034) | |
| 61801 | 61801 | 188816 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1900 19th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012020.70996 | 2105140.34422 | 37.760991420451106 | -122.40152043874501 | (37.7609914204511, -122.401520438745) | ||||
| 62632 | 62632 | 221250 | Undocumented 2 | Betula pendula :: European White Birch 146 | 382 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001780.48006 | 2103636.43597 | 37.756285346418 | -122.43682920632 | (37.756285346418, -122.43682920632) | |||
| 62636 | 62636 | 205630 | Undocumented 2 | Betula pendula :: European White Birch 146 | 617 Gennessee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5997440.96339 | 2095398.8468099998 | 37.7334193540061 | -122.45124261286502 | (37.7334193540061, -122.451242612865) | ||||
| 64855 | 64855 | 175566 | Undocumented 2 | Betula pendula :: European White Birch 146 | 35 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6005107.680380001 | 2093296.81097 | 37.728083624141505 | -122.424587117508 | (37.7280836241415, -122.424587117508) | ||||
| 64950 | 64950 | 246654 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009056.91969 | 2099197.55038 | 37.744508020922396 | -122.41135109798599 | (37.7445080209224, -122.411351097986) | ||||
| 65213 | 65213 | 104131 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2800X Buchanan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | 6003522.94878 | 2118100.93382 | 37.7961001572485 | -122.431835905912 | (37.7961001572485, -122.431835905912) | ||||
| 67141 | 67141 | 83807 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1401 Jones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 4 | 4x4 | 6008437.72882 | 2117343.11767 | 37.794296760229294 | -122.414776076964 | (37.7942967602293, -122.414776076964) | |
| 67471 | 67471 | 221242 | Undocumented 2 | Betula pendula :: European White Birch 146 | 248 Bonview St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006837.39419 | 2097609.11075 | 37.740021785279296 | -122.41891314632099 | (37.7400217852793, -122.418913146321) | |||
| 67601 | 67601 | 246669 | Undocumented 2 | Betula pendula :: European White Birch 146 | 199 Ripley St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6009251.14163 | 2099145.6532400004 | 37.7443764141382 | -122.410675851027 | (37.7443764141382, -122.410675851027) | |||
| 67625 | 67625 | 32227 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 1539 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2014 12:00:00 AM | 9 | Permit Number 772963 | 6008763.03065 | 2099819.3377099996 | 37.7461988237316 | -122.412411252099 | (37.7461988237316, -122.412411252099) | |
| 68267 | 68267 | 125721 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2652 Broderick St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 4ft | 6000166.8392900005 | 2117732.47906 | 37.794897657557605 | -122.443422196501 | (37.7948976575576, -122.443422196501) | |||
| 69573 | 69573 | 221253 | Undocumented 2 | Betula pendula :: European White Birch 146 | 190 Storrie St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 39 | Width 3ft | 6000832.842619999 | 2105336.18629 | 37.760898542056296 | -122.44022834328001 | (37.7608985420563, -122.44022834328) | |||
| 69627 | 69627 | 175568 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1053 Silver Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6007891.0439 | 2093708.2298400002 | 37.7293700899505 | -122.414994016859 | (37.7293700899505, -122.414994016859) | |||
| 70566 | 70566 | 246665 | Undocumented 2 | Betula pendula :: European White Birch 146 | 199 Ripley St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6009271.741280001 | 2099145.49563 | 37.74437713631279 | -122.41060461033399 | (37.7443771363128, -122.410604610334) | |||
| 70995 | 70995 | 246659 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009067.50483 | 2099233.3158299997 | 37.74460681865239 | -122.411317022686 | (37.7446068186524, -122.411317022686) | ||||
| 71083 | 71083 | 175563 | Undocumented 2 | Betula pendula :: European White Birch 146 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5988277.07749 | 2089797.21556 | 37.71750974536221 | -122.482514046798 | (37.7175097453622, -122.482514046798) | ||||
| 73048 | 73048 | 122925 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2 11th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5992432.258780001 | 2114882.3832400003 | 37.7866279691571 | -122.469977088017 | (37.7866279691571, -122.469977088017) | |||
| 76474 | 76474 | 246667 | Undocumented 2 | Betula pendula :: European White Birch 146 | 199 Ripley St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6009260.09714 | 2099144.41836 | 37.7443735255327 | -122.410644797435 | (37.7443735255327, -122.410644797435) | |||
| 76684 | 76684 | 249671 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2400 Baker St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5999749.22169 | 2117118.60729 | 37.7931883035453 | -122.444823060562 | (37.7931883035453, -122.444823060562) | ||||
| 76713 | 76713 | 188823 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1601 Kansas St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6011832.95066 | 2100589.70632 | 37.748485888729206 | -122.40184993054501 | (37.7484858887292, -122.401849930545) | |||
| 76950 | 76950 | 175565 | Undocumented 2 | Betula pendula :: European White Birch 146 | 25 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004860.3058400005 | 2093398.9079599997 | 37.728349986252496 | -122.425449562862 | (37.7283499862525, -122.425449562862) | |||
| 82639 | 82639 | 108970 | Undocumented 2 | Betula pendula :: European White Birch 146 | 328 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007774.7 | 2105725.6 | 37.7623605634411 | -122.416247029237 | (37.7623605634411, -122.416247029237) | ||||
| 83336 | 83336 | 91234 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 829 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52047: Correct address is 829: Replanted w/ Birch | 5988302.4 | 2089565.8 | 37.7168758094884 | -122.482409573013 | (37.7168758094884, -122.482409573013) | ||
| 86772 | 86772 | 39511 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 1240 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40963 | 6003838.6793187 | 2101050.95866079 | 37.7493029945716 | -122.429526863798 | (37.7493029945716, -122.429526863798) | ||
| 88879 | 88879 | 98509 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1194 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995108.2 | 2091844.9 | 37.7235272322276 | -122.45905033357201 | (37.7235272322276, -122.459050333572) | ||||
| 89432 | 89432 | 48967 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 3620 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2002 12:00:00 AM | Permit Number 46154 | 6006101.38799392 | 2101441.68758323 | 37.7505037014367 | -122.421730108749 | (37.7505037014367, -122.421730108749) | ||
| 89947 | 89947 | 49006 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 698 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2003 12:00:00 AM | 3x3 | Permit Number 46234 | 6012086.71904348 | 2105158.36746792 | 37.7610445912521 | -122.401293407307 | (37.7610445912521, -122.401293407307) | ||
| 91565 | 91565 | 114074 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 18x HIGUERA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5988029.0 | 2090212.0 | 37.718634203797706 | -122.483401916227 | (37.7186342037977, -122.483401916227) | ||||
| 93539 | 93539 | 62831 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 211 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52238 | 6004171.80944378 | 2107611.92188251 | 37.7673367003875 | -122.42884257100701 | (37.7673367003875, -122.428842571007) | ||
| 96627 | 96627 | 104900 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 317 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 96786 | 96786 | 98508 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1194 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995108.2 | 2091844.9 | 37.7235272322276 | -122.45905033357201 | (37.7235272322276, -122.459050333572) | ||||
| 104403 | 104403 | 114100 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 21x ACEVEDO AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5988027.0 | 2090598.0 | 37.7196939458216 | -122.48343711113998 | (37.7196939458216, -122.48343711114) | ||||
| 105166 | 105166 | 61454 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 2099 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52238 | 6004149.19944272 | 2107648.18855863 | 37.7674350001746 | -122.428923361715 | (37.7674350001746, -122.428923361715) | ||
| 106735 | 106735 | 115060 | Undocumented 2 | Betula pendula :: European White Birch 146 | 26 CRESCENT AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6005316.0 | 2095906.0 | 37.735259640844 | -122.42405242211201 | (37.735259640844, -122.424052422112) | ||||
| 106889 | 106889 | 51462 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 185 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52416 | 6008134.54091368 | 2097771.36958265 | 37.740540267518504 | -122.414439611243 | (37.7405402675185, -122.414439611243) | ||
| 106955 | 106955 | 89285 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 160 Vicksburg St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2008 12:00:00 AM | 3x3 | Permit Number 51893 | 6004103.0 | 2102285.0 | 37.752706346041606 | -122.42870079588499 | (37.7527063460416, -122.428700795885) | ||
| 112009 | 112009 | 46437 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 522 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53513 | 6007833.888799599 | 2104879.83427727 | 37.760041614008706 | -122.41598242022499 | (37.7600416140087, -122.415982420225) |
| 112395 | 112395 | 49007 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 698 De Haro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2003 12:00:00 AM | 3x3 | Permit Number 46234 | 6012086.71904348 | 2105158.36746792 | 37.7610445912521 | -122.401293407307 | (37.7610445912521, -122.401293407307) | ||
| 117392 | 117392 | 114037 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1669 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6009356.0 | 2099744.0 | 37.7460252212812 | -122.410355511001 | (37.7460252212812, -122.410355511001) | |||
| 118495 | 118495 | 89283 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 160 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2008 12:00:00 AM | 3x3 | Permit Number 51893 | 6004103.0 | 2102285.0 | 37.752706346041606 | -122.42870079588499 | (37.7527063460416, -122.428700795885) | ||
| 118949 | 118949 | 114101 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 21x ACEVEDO AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988027.0 | 2090598.0 | 37.7196939458216 | -122.48343711113998 | (37.7196939458216, -122.48343711114) | ||||
| 119334 | 119334 | 114073 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 18x HIGUERA AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5988029.0 | 2090212.0 | 37.718634203797706 | -122.483401916227 | (37.7186342037977, -122.483401916227) | ||||
| 123403 | 123403 | 89284 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 160 Vicksburg St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2008 12:00:00 AM | 3x3 | Permit Number 51893 | 6004103.0 | 2102285.0 | 37.752706346041606 | -122.42870079588499 | (37.7527063460416, -122.428700795885) | ||
| 124109 | 124109 | 246657 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009066.271869999 | 2099220.25657 | 37.7445708916489 | -122.411320363658 | (37.7445708916489, -122.411320363658) | ||||
| 124402 | 124402 | 108176 | Undocumented 2 | Betula pendula :: European White Birch 146 | 308 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007706.3 | 2105989.2 | 37.7630805015474 | -122.41650227301201 | (37.7630805015474, -122.416502273012) |
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");