trees
172 rows where qSpecies_id = 189 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55122 | 24349 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 85 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/24/2003 12:00:00 AM | 3 | 2x2 | 6006210.36104 | 2108383.47417 | 37.7695703700026 | -122.421846308181 | (37.7695703700026, -122.421846308181) | 8 | 4 | 7 | 28853 | 19 | ||
| 55847 | 31894 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 333 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 6 | Permit Number 779764 | 6008421.36423 | 2108725.68619 | 37.7706344442547 | -122.4142227196 | (37.7706344442547, -122.4142227196) | 8 | 2 | 9 | 28853 | 19 | |
| 82253 | 31895 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 333 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2004 12:00:00 AM | 11 | Permit Number 779764 | 6008447.6164 | 2108708.53583 | 37.770588827951 | -122.414130699173 | (37.770588827951, -122.414130699173) | 8 | 2 | 9 | 28853 | 19 | |
| 1486 | 197013 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 208 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014266.34495 | 2106050.86806 | 37.7636165666862 | -122.393817442323 | (37.7636165666862, -122.393817442323) | 14 | 3 | 8 | 28856 | 29 | |||
| 19209 | 122592 | Planning Code 138.1 required 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 72 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
| 41618 | 197019 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 586 Missouri St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6013514.03834 | 2104373.90914 | 37.7589701689629 | -122.396301910304 | (37.7589701689629, -122.396301910304) | 10 | 3 | 8 | 28856 | 29 | |||
| 61079 | 38297 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 239 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | 14 | Permit Number 40374 | 6013208.30487 | 2105936.95317 | 37.7632449272463 | -122.397468906577 | (37.7632449272463, -122.397468906577) | 14 | 3 | 8 | 28856 | 29 | |
| 74172 | 197015 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 208 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014265.7589 | 2106008.0241 | 37.7634988939735 | -122.393816470175 | (37.7634988939735, -122.393816470175) | 14 | 3 | 8 | 28856 | 29 | |||
| 121640 | 197009 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 200 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014260.56873 | 2106154.62322 | 37.7639011346557 | -122.393844683695 | (37.7639011346557, -122.393844683695) | 14 | 3 | 8 | 28856 | 29 | |||
| 127921 | 197012 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 200 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014262.54318 | 2106085.39774 | 37.7637111663611 | -122.393833008691 | (37.7637111663611, -122.393833008691) | 14 | 3 | 8 | 28856 | 29 | |||
| 140765 | 197017 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 208 Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014269.53802 | 2105972.3744 | 37.7634012177041 | -122.393800903811 | (37.7634012177041, -122.393800903811) | 14 | 3 | 8 | 28856 | 29 | |||
| 144384 | 197011 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 200 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014262.15311 | 2106107.81384 | 37.7637726943902 | -122.393835927003 | (37.7637726943902, -122.393835927003) | 14 | 3 | 8 | 28856 | 29 | |||
| 148206 | 197010 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 200 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6014261.77906 | 2106133.05094 | 37.7638419691574 | -122.393838987388 | (37.7638419691574, -122.393838987388) | 14 | 3 | 8 | 28856 | 29 | |||
| 154834 | 197016 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 208 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014268.20228 | 2105989.76799 | 37.7634489024704 | -122.393806741299 | (37.7634489024704, -122.393806741299) | 14 | 3 | 8 | 28856 | 29 | |||
| 165304 | 197018 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 208 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014270.00743 | 2105953.87788 | 37.7633504563892 | -122.3937979855 | (37.7633504563892, -122.3937979855) | 14 | 3 | 8 | 28856 | 29 | |||
| 172463 | 197014 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 208 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014267.3142 | 2106029.28035 | 37.763557345419 | -122.393812578804 | (37.763557345419, -122.393812578804) | 14 | 3 | 8 | 28856 | 29 | |||
| 31909 | 239128 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 346 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006911.82474 | 2096010.51778 | 37.7356365938626 | -122.418542467387 | (37.7356365938626, -122.418542467387) | 2 | 7 | 7 | 28859 | 2 | |||
| 41364 | 241394 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1398 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011408.32229 | 2101904.99844 | 37.7520736872555 | -122.403410815482 | (37.7520736872555, -122.403410815482) | 10 | 4 | 8 | 28859 | 19 | |||
| 53977 | 241392 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1400 Potrero Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6010755.0647 | 2100977.86196 | 37.7494914656774 | -122.405604594682 | (37.7494914656774, -122.405604594682) | 10 | 4 | 7 | 28859 | 19 | |||
| 78045 | 239129 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 319 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006586.63568 | 2096080.71636 | 37.7358110308482 | -122.419671752359 | (37.7358110308482, -122.419671752359) | 2 | 7 | 7 | 28859 | 2 | |||
| 88852 | 7587 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 3000X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.413820936867 | (37.7492862752884, -122.413820936867) | 2 | 4 | 7 | 28859 | 19 | |||
| 92123 | 239141 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 479 Andover St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007510.96611 | 2096684.13991 | 37.7375199243887 | -122.416518701402 | (37.7375199243887, -122.416518701402) | 2 | 7 | 7 | 28859 | 2 | |||
| 122207 | 239140 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 479 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007508.73883 | 2096670.31141 | 37.7374818291124 | -122.416525422908 | (37.7374818291124, -122.416525422908) | 2 | 7 | 7 | 28859 | 2 | |||
| 143119 | 241393 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 66 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005160.70352 | 2105758.78708 | 37.7623043550961 | -122.425290238962 | (37.7623043550961, -122.425290238962) | 8 | 4 | 5 | 28859 | 19 | |||
| 180621 | 241396 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 952 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010191.29772 | 2103654.45809 | 37.7568092635594 | -122.407742832678 | (37.7568092635594, -122.407742832678) | 2 | 4 | 7 | 28859 | 19 | |||
| 191270 | 241395 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2500 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011393.11733 | 2101862.71198 | 37.7519567286313 | -122.403460422082 | (37.7519567286313, -122.403460422082) | 10 | 4 | 8 | 28859 | 19 | |||
| 7333 | 262326 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 10 Roemer Way | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998623 | 2086576 | 37.7092614661016 | -122.446521459005 | (37.7092614661016, -122.446521459005) | 9 | 7 | 6 | 28861 | 5 | |||||
| 24022 | 213905 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1434 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995905.10598 | 2093569.63191 | 37.7283087127703 | -122.456420245524 | (37.7283087127703, -122.456420245524) | 9 | 7 | 4 | 28861 | 40 | |||
| 30982 | 213873 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 59 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5995622.40469 | 2093021.42815 | 37.7267872433344 | -122.457357906543 | (37.7267872433344, -122.457357906543) | 9 | 7 | 4 | 28861 | 40 | |||
| 57281 | 105023 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 761 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6002706.48951 | 2088960.92893 | 37.7160423584316 | -122.432578526497 | (37.7160423584316, -122.432578526497) | 9 | 7 | 6 | 28861 | 5 | |||
| 57990 | 213902 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 251 Wildwood Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995694.04842 | 2093291.08185 | 37.7275317623756 | -122.457129735051 | (37.7275317623756, -122.457129735051) | 9 | 7 | 4 | 28861 | 40 | |||
| 67839 | 213904 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 82 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995638.93402 | 2093163.65377 | 37.7271787101128 | -122.457311050068 | (37.7271787101128, -122.457311050068) | 9 | 7 | 4 | 28861 | 40 | |||
| 83136 | 84676 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 25 Josiah Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49727 | 5996908.75152474 | 2089951.72351373 | 37.7184323567088 | -122.452689612121 | (37.7184323567088, -122.452689612121) | 9 | 8 | 6 | 28861 | 24 | ||
| 87882 | 213906 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1434 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995899.59842 | 2093547.71862 | 37.7282482279527 | -122.456437701364 | (37.7282482279527, -122.456437701364) | 9 | 7 | 4 | 28861 | 40 | |||
| 112952 | 213872 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 59 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995621.30563 | 2093030.05014 | 37.7268108541226 | -122.457362329428 | (37.7268108541226, -122.457362329428) | 9 | 7 | 4 | 28861 | 40 | |||
| 140035 | 56918 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 757 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1974 12:00:00 AM | 8 | 3x3 | Permit Number 14160 | 6002721.67474 | 2088983.89704 | 37.716106284944 | -122.432527678806 | (37.716106284944, -122.432527678806) | 9 | 7 | 6 | 28861 | 5 | |
| 186617 | 213903 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 82 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995638.7479 | 2093177.24169 | 37.7272160085872 | -122.457312676053 | (37.7272160085872, -122.457312676053) | 9 | 7 | 4 | 28861 | 40 | |||
| 189415 | 213871 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 59 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995619.92029 | 2093040.27058 | 37.7268388374274 | -122.457367857563 | (37.7268388374274, -122.457367857563) | 9 | 7 | 4 | 28861 | 40 | |||
| 193336 | 213901 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 95 Westwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995124.96941 | 2093273.24619 | 37.7274500913228 | -122.459095741174 | (37.7274500913228, -122.459095741174) | 9 | 7 | 4 | 28861 | 40 | |||
| 34461 | 104692 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2201 SUTTER ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6001996 | 2114241 | 37.7854150975946 | -122.436842984948 | (37.7854150975946, -122.436842984948) | 13 | 6 | 11 | 29490 | 13 | ||||
| 44063 | 103330 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1600X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001400.4 | 2111522.1 | 37.7779158216762 | -122.438708684362 | (37.7779158216762, -122.438708684362) | 15 | 5 | 11 | 29490 | 41 | ||||
| 185951 | 103331 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1600X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001400.4 | 2111522.1 | 37.7779158216762 | -122.438708684362 | (37.7779158216762, -122.438708684362) | 15 | 5 | 11 | 29490 | 41 | ||||
| 4878 | 213890 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 404 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991686.41791 | 2097763.49025 | 37.7395808980372 | -122.47130973605 | (37.7395808980372, -122.47130973605) | 1 | 8 | 4 | 29491 | 40 | |||
| 7910 | 213897 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2365 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5992305.54148 | 2099333.17505 | 37.7439266478918 | -122.469283314394 | (37.7439266478918, -122.469283314394) | 1 | 8 | 4 | 29491 | 40 | |||
| 33762 | 213899 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 273 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994690.46222 | 2100307.26006 | 37.746738768579 | -122.461107457156 | (37.746738768579, -122.461107457156) | 1 | 8 | 4 | 29491 | 40 | |||
| 49440 | 213894 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 740 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990581.97816 | 2097726.13845 | 37.739414390369 | -122.47512564584 | (37.739414390369, -122.47512564584) | 1 | 8 | 4 | 29491 | 40 | |||
| 68194 | 213895 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 744 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990568.43351 | 2097726.13088 | 37.739413584555 | -122.475172476244 | (37.739413584555, -122.475172476244) | 1 | 8 | 4 | 29491 | 40 | |||
| 69711 | 213892 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 734 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990616.45042 | 2097727.17 | 37.7394192206197 | -122.475006532441 | (37.7394192206197, -122.475006532441) | 1 | 8 | 4 | 29491 | 40 | |||
| 82002 | 213900 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 273 Magellan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994701.36928 | 2100318.44631 | 37.7467701108664 | -122.461070552565 | (37.7467701108664, -122.461070552565) | 1 | 8 | 4 | 29491 | 40 | |||
| 110303 | 213889 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2595 15th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991720.61669 | 2097822.06078 | 37.739743696013 | -122.471195758689 | (37.739743696013, -122.471195758689) | 1 | 8 | 4 | 29491 | 40 | |||
| 111997 | 213888 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2595 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991720.70941 | 2097838.59924 | 37.739789111779 | -122.471196642726 | (37.739789111779, -122.471196642726) | 1 | 8 | 4 | 29491 | 40 | |||
| 134118 | 213896 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 750 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990556.3666 | 2097726.38561 | 37.7394135845816 | -122.475214216469 | (37.7394135845816, -122.475214216469) | 1 | 8 | 4 | 29491 | 40 | |||
| 147413 | 213891 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 730 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990628.53589 | 2097727.79467 | 37.7394216362019 | -122.474964792217 | (37.7394216362019, -122.474964792217) | 1 | 8 | 4 | 29491 | 40 | |||
| 162837 | 213887 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2567 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991715.1256 | 2097973.83861 | 37.7401601216784 | -122.471225799651 | (37.7401601216784, -122.471225799651) | 1 | 8 | 4 | 29491 | 40 | |||
| 183594 | 213893 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 738 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990593.74457 | 2097725.59661 | 37.7394135845647 | -122.475084923648 | (37.7394135845647, -122.475084923648) | 1 | 8 | 4 | 29491 | 40 | |||
| 31035 | 239136 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 79 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997078.63554 | 2106086.03977 | 37.7627429931264 | -122.453266558717 | (37.7627429931264, -122.453266558717) | 15 | 5 | 11 | 29492 | 12 | |||
| 34154 | 239126 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1451 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999586.93736 | 2107523.62973 | 37.766833703329 | -122.444694596886 | (37.766833703329, -122.444694596886) | 15 | 5 | 5 | 29492 | 9 | |||
| 42547 | 103328 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 242 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6001866 | 2109053 | 37.7711627667236 | -122.436921205648 | (37.7711627667236, -122.436921205648) | 15 | 5 | 11 | 29492 | 9 | |||
| 54792 | 239132 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 48 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997107.26688 | 2106225.71823 | 37.7631281556743 | -122.453177617559 | (37.7631281556743, -122.453177617559) | 15 | 5 | 11 | 29492 | 12 | |||
| 66654 | 5147 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 228 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2016 12:00:00 AM | 3 | 3x3 | 6001883.9625 | 2108955.9605 | 37.7708973412472 | -122.436852124872 | (37.7708973412472, -122.436852124872) | 15 | 5 | 11 | 29492 | 9 | ||
| 74091 | 103329 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1194X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001718.9 | 2110136.9 | 37.7741305241547 | -122.437507661432 | (37.7741305241547, -122.437507661432) | 15 | 5 | 11 | 29492 | 10 | ||||
| 75641 | 239133 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 48 Woodland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997104.10967 | 2106248.89911 | 37.7631916235237 | -122.45319021077 | (37.7631916235237, -122.45319021077) | 15 | 5 | 11 | 29492 | 12 | |||
| 91677 | 241391 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1 Scott St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6002400.13721 | 2108362.40844 | 37.769296916741 | -122.435024208514 | (37.769296916741, -122.435024208514) | 15 | 5 | 5 | 29492 | 9 | |||
| 92898 | 239134 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 28 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5997077.24933 | 2106444.80273 | 37.7637279854922 | -122.45329725527 | (37.7637279854922, -122.45329725527) | 15 | 5 | 11 | 29492 | 12 | |||
| 94094 | 31497 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1252 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2001 12:00:00 AM | 6 | Permit Number 44477 | 5995846.10209 | 2106936.0287 | 37.7650061226505 | -122.457590930801 | (37.7650061226505, -122.457590930801) | 15 | 5 | 11 | 29492 | 12 | |
| 96929 | 239127 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1451 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999589.58615 | 2107503.40425 | 37.7667783203868 | -122.444683981296 | (37.7667783203868, -122.444683981296) | 15 | 5 | 5 | 29492 | 9 | |||
| 109887 | 103326 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 224 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001907 | 2108933.4 | 37.7708367050105 | -122.436770822483 | (37.7708367050105, -122.436770822483) | 15 | 5 | 11 | 29492 | 9 | ||||
| 109953 | 103332 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 245 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001802.8 | 2109052.7 | 37.7711583507176 | -122.437139794943 | (37.7711583507176, -122.437139794943) | 15 | 5 | 11 | 29492 | 9 | ||||
| 110741 | 213884 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1253 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996733.91272 | 2107071.65151 | 37.7654294668219 | -122.454530030652 | (37.7654294668219, -122.454530030652) | 15 | 5 | 11 | 29492 | 12 | |||
| 113200 | 239131 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 62 Woodland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997117.0518 | 2106149.37077 | 37.7629190857628 | -122.453138263238 | (37.7629190857628, -122.453138263238) | 15 | 5 | 11 | 29492 | 12 | |||
| 118818 | 241397 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 132 Grattan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5997957.14127 | 2106523.41576 | 37.7639942306689 | -122.45025966195 | (37.7639942306689, -122.45025966195) | 15 | 5 | 11 | 29492 | 9 | |||
| 135315 | 239135 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 8 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5997054.7082 | 2106607.75583 | 37.7641741211633 | -122.453386983336 | (37.7641741211633, -122.453386983336) | 15 | 5 | 11 | 29492 | 12 | |||
| 136471 | 239139 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 247 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 5997487.69645 | 2106417.01096 | 37.763675193483 | -122.451875647467 | (37.763675193483, -122.451875647467) | 15 | 5 | 11 | 29492 | 9 | |||
| 139409 | 5150 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 243 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2016 12:00:00 AM | 2 | 3x3 | 6001815.3824 | 2108971.2006 | 37.7709352888143 | -122.437090436044 | (37.7709352888143, -122.437090436044) | 15 | 5 | 11 | 29492 | 9 | ||
| 139861 | 241398 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 146 Alma St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997904.83001 | 2106203.90922 | 37.7631139526706 | -122.450417555946 | (37.7631139526706, -122.450417555946) | 15 | 5 | 11 | 29492 | 9 | |||
| 141834 | 239130 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 62 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997119.03338 | 2106135.27891 | 37.7628805066659 | -122.453130392348 | (37.7628805066659, -122.453130392348) | 15 | 5 | 11 | 29492 | 12 | |||
| 143198 | 239138 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 249 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 5997503.33133 | 2106418.97592 | 37.7636814842479 | -122.451821713317 | (37.7636814842479, -122.451821713317) | 15 | 5 | 11 | 29492 | 9 | |||
| 170184 | 103325 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 200 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001895 | 2108750 | 37.7703324520775 | -122.436799199856 | (37.7703324520775, -122.436799199856) | 15 | 5 | 5 | 29492 | 9 | ||||
| 176175 | 103327 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 234 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001874 | 2108997 | 37.7710094593117 | -122.43688952378 | (37.7710094593117, -122.43688952378) | 15 | 5 | 11 | 29492 | 9 | ||||
| 181441 | 103333 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 243 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001783.9 | 2108958.2 | 37.7708978028329 | -122.437198403324 | (37.7708978028329, -122.437198403324) | 15 | 5 | 11 | 29492 | 9 | ||||
| 192153 | 239137 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 128 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997045.82374 | 2105845.81512 | 37.762081516563 | -122.453362698034 | (37.762081516563, -122.453362698034) | 15 | 5 | 11 | 29492 | 12 | |||
| 23334 | 101352 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 42166 | 101351 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 77065 | 101347 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 97106 | 101355 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 106751 | 101349 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 149873 | 101354 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 156483 | 101348 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 193768 | 101346 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 107398 | 106725 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 421 CAMBRIDGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6006955.4 | 2092560.1 | 37.7261649524701 | -122.418147266884 | (37.7261649524701, -122.418147266884) | 9 | 3 | 7 | 309 | 28 | ||||
| 36098 | 124498 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2700 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996593.30125 | 2111311.24634 | 37.7770622288898 | -122.455322791721 | (37.7770622288898, -122.455322791721) | 11 | 6 | 2 | 54 | 16 | |||
| 44979 | 39247 | Significant Tree 6 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 3524 Jackson St | 1 | Front Yard : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | 5x10 | Permit Number 772836 | 5997387.02929021 | 2116081.37513577 | 37.7902052526208 | -122.452921449726 | (37.7902052526208, -122.452921449726) | 11 | 6 | 1 | 54 | 31 | ||
| 48413 | 113168 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 3902 CLAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996089 | 2115262 | 37.7878809990319 | -122.457353202257 | (37.7878809990319, -122.457353202257) | 11 | 6 | 1 | 54 | 31 | ||||
| 60863 | 124501 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2700 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5996544.31989 | 2111306.29255 | 37.7770458165813 | -122.455491874416 | (37.7770458165813, -122.455491874416) | 11 | 6 | 2 | 54 | 16 | |||
| 65319 | 123270 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 460 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5993763.95635 | 2112364.19662 | 37.7797906029426 | -122.465186799304 | (37.7797906029426, -122.465186799304) | 11 | 6 | 2 | 54 | 11 | |||
| 88074 | 124496 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2700 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996613.10439 | 2111315.1019 | 37.7770739514615 | -122.455254565574 | (37.7770739514615, -122.455254565574) | 11 | 6 | 2 | 54 | 16 | |||
| 100964 | 68924 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1950 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 7 | Permit Number 32908 | 5992571.67801 | 2112081.68714 | 37.7789460828372 | -122.469290808374 | (37.7789460828372, -122.469290808374) | 11 | 6 | 2 | 54 | 11 | |
| 138001 | 124500 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2700 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996567.31944 | 2111309.2274 | 37.7770551946305 | -122.455412524437 | (37.7770551946305, -122.455412524437) | 11 | 6 | 2 | 54 | 16 | |||
| 146524 | 113167 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 3902 CLAY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996089 | 2115262 | 37.7878809990319 | -122.457353202257 | (37.7878809990319, -122.457353202257) | 11 | 6 | 1 | 54 | 31 | ||||
| 174690 | 124499 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2700 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996580.00237 | 2111310.88371 | 37.7770604701507 | -122.455368770216 | (37.7770604701507, -122.455368770216) | 11 | 6 | 2 | 54 | 16 |
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) );