trees
6,714 rows where qSpecies_id = 7
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3561 | 246211 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 725 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2019 12:00:00 AM | 3 | Width 0ft | 5999847.7223 | 2107912.6904 | 37.7679168446173 | -122.443820542416 | (37.7679168446173, -122.443820542416) | 15 | 5 | 11 | 29492 | 9 | ||
3582 | 71321 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 336 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004246.97959 | 2090473.39754 | 37.7202825081141 | -122.427361543098 | (37.7202825081141, -122.427361543098) | 9 | 7 | 6 | 28861 | 5 | |||
3609 | 68347 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 479 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32166 | 5989354.45266 | 2112083.78554 | 37.7787654076266 | -122.480420503546 | (37.7787654076266, -122.480420503546) | 11 | 6 | 2 | 55 | 26 | |
3610 | 45141 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1300 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 43998 | 6000329.1714268 | 2109256.8846269 | 37.7716351145449 | -122.442251776367 | (37.7716351145449, -122.442251776367) | 15 | 5 | 11 | 29492 | 9 | ||
3643 | 202263 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 8 Orsi Cir | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6013104.38405 | 2093156.20787 | 37.7281459291672 | -122.396932202872 | (37.7281459291672, -122.396932202872) | 10 | 3 | 8 | 58 | 1 | |||
3685 | 42239 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 526 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 5 | Permit Number 42488 | 6010182.46318 | 2111990.4424 | 37.7796974691974 | -122.408361341411 | (37.7796974691974, -122.408361341411) | 14 | 2 | 9 | 28853 | 34 | |
3695 | 217936 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2035 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/26/2004 12:00:00 AM | 4 | Width 3ft | Permit Number 47390 | 5991589.39044 | 2101578.98372 | 37.7500516488693 | -122.471923224775 | (37.7500516488693, -122.471923224775) | 1 | 8 | 4 | 29491 | 12 | |
3703 | 47931 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 421 Congo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2002 12:00:00 AM | Permit Number 45666 | 6000072.19761127 | 2095017.15680877 | 37.7325216284483 | -122.442118334295 | (37.7325216284483, -122.442118334295) | 9 | 7 | 4 | 63 | 40 | ||
3723 | 260511 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 199X Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990954 | 2091213 | 37.7215525064104 | -122.47336445039 | (37.7215525064104, -122.47336445039) | 9 | 8 | 4 | 64 | 40 | ||||
3756 | 261450 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 302 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006908 | 2095729 | 37.7348633927281 | -122.418535734777 | (37.7348633927281, -122.418535734777) | 2 | 7 | 7 | 28859 | 2 | ||||
3803 | 84348 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3332-3334 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50580 | 6007340.92664153 | 2105019.75450207 | 37.760398074706 | -122.417697261406 | (37.760398074706, -122.417697261406) | 2 | 4 | 7 | 28859 | 19 | ||
3888 | 66831 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 356 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30128 | 6001116.30976088 | 2104258.47469613 | 37.7579555437732 | -122.439170712808 | (37.7579555437732, -122.439170712808) | 2 | 4 | 5 | 28862 | 38 | ||
3895 | 78222 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1186 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009661.32539 | 2090689.78042 | 37.7211813813865 | -122.408661109741 | (37.7211813813865, -122.408661109741) | 9 | 3 | 7 | 309 | 28 | |||
3923 | 25589 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1380X Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6009160.7320011 | 2097455.9675675 | 37.7397318376167 | -122.410869155933 | (37.7397318376167, -122.410869155933) | 10 | 7 | 7 | 28859 | 2 | |||
3940 | 60357 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1265 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | Permit Number 19935 | 6016646.4135 | 2093895.0122 | 37.7303710665679 | -122.384738607351 | (37.7303710665679, -122.384738607351) | 10 | 3 | 8 | 58 | 1 | |
3972 | 73489 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 45 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000901.50106 | 2088195.84142 | 37.7138390733861 | -122.438762613813 | (37.7138390733861, -122.438762613813) | 9 | 7 | 6 | 28861 | 5 | |||
3989 | 218019 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 645 Santiago St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 5990820.54277 | 2099711.93527 | 37.7448807008818 | -122.474445681024 | (37.7448807008818, -122.474445681024) | 1 | 8 | 4 | 29491 | 40 | |||
4085 | 212397 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 35 San Rafael Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5991907.97112 | 2095768.21214 | 37.7341151819682 | -122.470398435962 | (37.7341151819682, -122.470398435962) | 9 | 8 | 4 | 59 | 40 | |||
4104 | 78658 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 650 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012076.11303 | 2105354.08238 | 37.761581389203 | -122.401343843369 | (37.761581389203, -122.401343843369) | 10 | 3 | 8 | 28856 | 29 | |||
4181 | 142314 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1685 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999759.4558 | 2110518.5336 | 37.7750667961639 | -122.444313131138 | (37.7750667961639, -122.444313131138) | 15 | 5 | 11 | 29492 | 16 | |||
4188 | 236744 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 4201 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001442.35648 | 2103342.9897 | 37.7554603910923 | -122.437977533533 | (37.7554603910923, -122.437977533533) | 2 | 4 | 5 | 28862 | 22 | |||
4223 | 54535 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 107 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1972 12:00:00 AM | 8 | Permit Number 10330 | 6009992.40019 | 2095186.16028 | 37.7335460325239 | -122.407833574281 | (37.7335460325239, -122.407833574281) | 10 | 3 | 7 | 309 | 28 | |
4248 | 261193 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 600X Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007231 | 2095349 | 37.7338381748563 | -122.417392087376 | (37.7338381748563, -122.417392087376) | 2 | 7 | 7 | 28859 | 2 | ||||
4349 | 212581 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 698 Hearst Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5996847.55389 | 2094438.38996 | 37.7307481750846 | -122.453224871536 | (37.7307481750846, -122.453224871536) | 9 | 7 | 4 | 59 | 40 | |||
4420 | 54537 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1972 12:00:00 AM | 5 | Permit Number 10332 | 6009964.96309 | 2095176.72453 | 37.7335185878995 | -122.407927767479 | (37.7335185878995, -122.407927767479) | 10 | 3 | 7 | 309 | 28 | |
4424 | 261436 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 375 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007268 | 2095787 | 37.7350429085654 | -122.417295195055 | (37.7350429085654, -122.417295195055) | 2 | 7 | 7 | 28859 | 2 | ||||
4448 | 202285 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Issleib Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6012731.44947 | 2093293.25918 | 37.7285014779546 | -122.398231071208 | (37.7285014779546, -122.398231071208) | 10 | 3 | 8 | 58 | 1 | |||
4548 | 47112 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 195 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45096 | 6007059.72881336 | 2097900.35480797 | 37.7408339935349 | -122.418165045885 | (37.7408339935349, -122.418165045885) | 2 | 7 | 7 | 28859 | 2 | ||
4609 | 236279 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 342 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007175.75737 | 2105294.6184 | 37.761143491293 | -122.418287995211 | (37.761143491293, -122.418287995211) | 2 | 4 | 7 | 28859 | 19 | |||
4679 | 236258 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009116.08466 | 2103840.92057 | 37.7572609975042 | -122.411474503866 | (37.7572609975042, -122.411474503866) | 2 | 4 | 7 | 28859 | 19 | |||
4709 | 32846 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 4290x 23RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | 3x3 | Permit Number 37198 | 6001397 | 2102325 | 37.7526626570726 | -122.438061472785 | (37.7526626570726, -122.438061472785) | 2 | 4 | 5 | 28862 | 22 | |
4741 | 236777 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 540 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003149.68066 | 2096096.4709 | 37.7356600832353 | -122.431555771598 | (37.7356600832353, -122.431555771598) | 2 | 7 | 5 | 63 | 7 | |||
4775 | 218083 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 281 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5994638.85855 | 2100259.1397 | 37.7466036724264 | -122.461282408569 | (37.7466036724264, -122.461282408569) | 1 | 8 | 4 | 29491 | 40 | |||
4777 | 261199 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 690x Benton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007331 | 2095336 | 37.7338081055982 | -122.417045435619 | (37.7338081055982, -122.417045435619) | 2 | 7 | 7 | 28859 | 2 | ||||
4779 | 73552 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1558 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000334.7955 | 2110645.229 | 37.7754474779657 | -122.4423320082 | (37.7754474779657, -122.4423320082) | 15 | 5 | 11 | 29492 | 16 | |||
4793 | 235921 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2549 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | Permit Number 782939 | 6010182.2586 | 2105017.82125 | 37.7605522464049 | -122.407870229727 | (37.7605522464049, -122.407870229727) | 10 | 4 | 8 | 28859 | 19 | ||
4827 | 60908 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 290 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/19/1983 12:00:00 AM | 11 | Permit Number 20698 | 5989656.87054 | 2113476.17839 | 37.7826060996657 | -122.479476231341 | (37.7826060996657, -122.479476231341) | 11 | 6 | 2 | 55 | 26 | |
4910 | 65716 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 98 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | 7 | 3x3 | Permit Number 28648 | 6000919.98791 | 2088014.07766 | 37.7133410423274 | -122.438685700186 | (37.7133410423274, -122.438685700186) | 9 | 7 | 6 | 28861 | 5 |
4919 | 64744 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1058 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1988 12:00:00 AM | Permit Number 25706 | 6001496.66932698 | 2109419.88262313 | 37.7721491365124 | -122.43822501871 | (37.7721491365124, -122.43822501871) | 15 | 5 | 11 | 29492 | 9 | ||
4921 | 71593 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 34 Rhine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5994443.94493 | 2086683.28618 | 37.7093164601484 | -122.46097260021 | (37.7093164601484, -122.46097260021) | 9 | 8 | 6 | 28861 | 25 | |||
4948 | 212696 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1342 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994280.27927 | 2106365.59 | 37.7633497765027 | -122.462965291019 | (37.7633497765027, -122.462965291019) | 1 | 5 | 11 | 56 | 12 | |||
4963 | 72437 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3770 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5996832.97473 | 2115019.84204 | 37.7872588007918 | -122.4547616987 | (37.7872588007918, -122.4547616987) | 11 | 6 | 1 | 54 | 31 | |||
4991 | 20043 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
5018 | 261361 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3 Bache St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007238 | 2095678 | 37.7347419306018 | -122.417391193891 | (37.7347419306018, -122.417391193891) | 2 | 7 | 7 | 28859 | 2 | ||||
5034 | 71218 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2271 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5988222.5624 | 2099870.3089 | 37.7451646891306 | -122.483440513109 | (37.7451646891306, -122.483440513109) | 1 | 8 | 3 | 29491 | 35 | |||
5057 | 72416 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3764 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5996845.41624 | 2115021.64069 | 37.7872644530409 | -122.454718783966 | (37.7872644530409, -122.454718783966) | 11 | 6 | 1 | 54 | 31 | |||
5104 | 212915 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 830 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992359.15804 | 2102812.51637 | 37.7534831218714 | -122.469351125951 | (37.7534831218714, -122.469351125951) | 1 | 8 | 4 | 56 | 12 | |||
5125 | 38779 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 534 04th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | Permit Number 40639 | 6013303.96708897 | 2111684.86517271 | 37.7790327294989 | -122.397541189965 | (37.7790327294989, -122.397541189965) | 6 | 2 | 9 | 28856 | 34 | ||
5153 | 72328 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2836 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5996013.17509 | 2111084.70561 | 37.7764069050201 | -122.457313223935 | (37.7764069050201, -122.457313223935) | 11 | 6 | 2 | 54 | 16 | |||
5196 | 72221 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1927 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987523.8589 | 2102155.7654 | 37.7513992507221 | -122.486024209623 | (37.7513992507221, -122.486024209623) | 1 | 8 | 3 | 29491 | 35 | |||
5219 | 78496 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 837 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011334.80311 | 2104438.72087 | 37.7590266229899 | -122.403843331831 | (37.7590266229899, -122.403843331831) | 10 | 3 | 8 | 28856 | 29 | |||
5231 | 45591 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1762 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 2 | Permit Number 44327 | 5985671.2041 | 2103229.2894 | 37.7542387115456 | -122.492509867059 | (37.7542387115456, -122.492509867059) | 1 | 8 | 3 | 56 | 35 | |
5242 | 42053 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 470 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42368 | 6003495.60283243 | 2099833.79882234 | 37.7459415266501 | -122.430626387026 | (37.7459415266501, -122.430626387026) | 2 | 7 | 5 | 63 | 22 | ||
5243 | 141564 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 500 LYON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000161.6495 | 2110729.8447 | 37.7756699411398 | -122.442937037183 | (37.7756699411398, -122.442937037183) | 15 | 5 | 11 | 29492 | 16 | |||
5278 | 235936 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2017 12:00:00 AM | 3 | Width 3ft | 6010180.29259 | 2103880.68421 | 37.7574298137383 | -122.40779684417 | (37.7574298137383, -122.40779684417) | 2 | 4 | 7 | 28859 | 19 | ||
5330 | 121676 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 65 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993867 | 2101351 | 37.7495571916966 | -122.464030639739 | (37.7495571916966, -122.464030639739) | 1 | 8 | 4 | 29491 | 40 | ||||
5337 | 178722 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 490 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002144.30749 | 2090601.92472 | 37.7205162706894 | -122.434638963227 | (37.7205162706894, -122.434638963227) | 9 | 7 | 6 | 28861 | 5 | |||
5398 | 71818 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1274 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5988967.2555 | 2106670.2084 | 37.7638787087739 | -122.481363401299 | (37.7638787087739, -122.481363401299) | 1 | 8 | 3 | 56 | 35 | |||
5417 | 36107 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1342 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1998 12:00:00 AM | Permit Number 39204 | 5992735.49126181 | 2106322.00548974 | 37.7631410027064 | -122.468304991085 | (37.7631410027064, -122.468304991085) | 1 | 8 | 11 | 56 | 12 | ||
5445 | 71037 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2655 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5990171.0618 | 2097314.9079 | 37.7382614326886 | -122.476516364987 | (37.7382614326886, -122.476516364987) | 1 | 8 | 3 | 29491 | 35 | |||
5448 | 140339 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1300x WEBSTER ST | 7 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6003689.95 | 2113371.7397 | 37.7831244557567 | -122.430920367043 | (37.7831244557567, -122.430920367043) | 15 | 9 | 11 | 29490 | 41 | |||
5463 | 212518 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1845 Monterey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992471.49152 | 2095369.46244 | 37.7330528811753 | -122.468421185611 | (37.7330528811753, -122.468421185611) | 9 | 8 | 4 | 59 | 40 | |||
5566 | 78781 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Laura St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | 5997342.70536 | 2086993.54413 | 37.7103347346378 | -122.450976426135 | (37.7103347346378, -122.450976426135) | 9 | 7 | 6 | 28861 | 25 | |||
5585 | 100886 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Welsh St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013501.81999 | 2111894.49362 | 37.7796193360911 | -122.396871432992 | (37.7796193360911, -122.396871432992) | 6 | 2 | 9 | 28856 | 34 | |||
5591 | 212726 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1273 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 5992975.27742 | 2106809.78649 | 37.7644941673851 | -122.467511131939 | (37.7644941673851, -122.467511131939) | 11 | 8 | 11 | 56 | 12 | |||
5593 | 78471 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 62 Colby St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6007985.29967 | 2093778.54228 | 37.7295684489024 | -122.414673138765 | (37.7295684489024, -122.414673138765) | 9 | 3 | 7 | 309 | 28 | |||
5643 | 73340 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 591 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5990617.8075 | 2111391.14287 | 37.7769369378188 | -122.475999510441 | (37.7769369378188, -122.475999510441) | 11 | 6 | 2 | 55 | 26 | |||
5648 | 59701 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3169 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1981 12:00:00 AM | 9 | Permit Number 19131 | 5999559.99552 | 2116003.4997 | 37.7901157113065 | -122.44539757625 | (37.7901157113065, -122.44539757625) | 13 | 6 | 1 | 29490 | 27 | |
5673 | 142341 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 501 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000096.9145 | 2110881.9778 | 37.7760839689842 | -122.443171899624 | (37.7760839689842, -122.443171899624) | 15 | 5 | 11 | 29492 | 16 | |||
5703 | 59347 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 505 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | 9 | Permit Number 25437 | 6000118.7378 | 2110712.049 | 37.7756186320467 | -122.443084200577 | (37.7756186320467, -122.443084200577) | 15 | 5 | 11 | 29492 | 16 | |
5714 | 259658 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 239 Stonecrest Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990787 | 2092898 | 37.7261694250404 | -122.474064598028 | (37.7261694250404, -122.474064598028) | 9 | 8 | 4 | 64 | 40 | ||||
5753 | 39480 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 890 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40940 | 6012732.47578 | 2103336.91838 | 37.7560792982424 | -122.3989321566 | (37.7560792982424, -122.3989321566) | 10 | 3 | 8 | 28856 | 29 | |
5777 | 236886 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 19 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999794.84017 | 2107740.78747 | 37.7674418258017 | -122.443991102207 | (37.7674418258017, -122.443991102207) | 15 | 5 | 5 | 29492 | 9 | |||
5783 | 78260 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 567 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011132.16494 | 2092178.53307 | 37.7253514585786 | -122.403681510512 | (37.7253514585786, -122.403681510512) | 10 | 3 | 7 | 309 | 28 | |||
5789 | 142614 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 GREENWICH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6009469.9119 | 2120131.871 | 37.8020119312896 | -122.411401700731 | (37.8020119312896, -122.411401700731) | 3 | 1 | 10 | 308 | 23 | |||
5812 | 237501 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3717 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003602.08527 | 2103592.54155 | 37.7562681837431 | -122.430526337427 | (37.7562681837431, -122.430526337427) | 2 | 4 | 5 | 28862 | 22 | |||
5815 | 43587 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2006 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | 1 | Permit Number 43248 | 5986971.0019 | 2101586.3374 | 37.7498035204361 | -122.487894195347 | (37.7498035204361, -122.487894195347) | 1 | 8 | 3 | 29491 | 35 | |
5823 | 73063 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 774 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5992292.3763 | 2110183.95951 | 37.7737192935019 | -122.470118792738 | (37.7737192935019, -122.470118792738) | 11 | 6 | 2 | 54 | 11 | |||
5829 | 70329 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 791 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988807.23069 | 2109962.85259 | 37.7729101002624 | -122.482158112101 | (37.7729101002624, -122.482158112101) | 11 | 6 | 2 | 55 | 26 | |||
5866 | 73526 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 807 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009578.52705 | 2116144.74687 | 37.7910703569642 | -122.410744096059 | (37.7910703569642, -122.410744096059) | 5 | 1 | 10 | 28857 | 21 | |||
5877 | 51423 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 655 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2004 12:00:00 AM | 2 | 3x3 | Permit Number 52282 | 6013263.01553 | 2110499.58328 | 37.7757759349387 | -122.397599704863 | (37.7757759349387, -122.397599704863) | 6 | 2 | 9 | 28856 | 34 | |
5910 | 24288 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 340 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6001280.10777 | 2086581.35963 | 37.7094275956588 | -122.437338476184 | (37.7094275956588, -122.437338476184) | 9 | 7 | 6 | 28861 | 5 | |||
6039 | 60368 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1423 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 6 | Permit Number 19946 | 6015801.9343 | 2094530.6388 | 37.7320696291014 | -122.387702446866 | (37.7320696291014, -122.387702446866) | 10 | 3 | 8 | 58 | 1 | |
6052 | 235985 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 921 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004398.25101 | 2103505.33732 | 37.7560738114594 | -122.427766708382 | (37.7560738114594, -122.427766708382) | 2 | 4 | 5 | 28862 | 22 | |||
6079 | 212891 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1439 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991128.6884 | 2105597.85808 | 37.7610597509203 | -122.47380949522 | (37.7610597509203, -122.47380949522) | 1 | 8 | 4 | 56 | 12 | |||
6135 | 236937 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 342 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008931.13659 | 2096699.45171 | 37.7376417330755 | -122.411609564953 | (37.7376417330755, -122.411609564953) | 10 | 7 | 7 | 28859 | 2 | |||
6136 | 35480 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1011 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | 4 | Permit Number 44832 | 6007756.21553 | 2093380.89962 | 37.7284637342957 | -122.415436968047 | (37.7284637342957, -122.415436968047) | 9 | 3 | 7 | 309 | 5 | |
6171 | 31268 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2555 17th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991067.84001 | 2098080.24601 | 37.7404148266578 | -122.47347158803 | (37.7404148266578, -122.47347158803) | 1 | 8 | 4 | 29491 | 40 | ||
6218 | 214210 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2 Edgehill Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994958.11276 | 2099177.21478 | 37.7436513456346 | -122.460100100459 | (37.7436513456346, -122.460100100459) | 1 | 8 | 4 | 59 | 40 | |||
6234 | 68658 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 247 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 7 | Permit Number 32565 | 5993663.87786 | 2113851.92985 | 37.7838697436255 | -122.465641127643 | (37.7838697436255, -122.465641127643) | 11 | 6 | 2 | 54 | 11 | |
6310 | 71322 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 426 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6003937.60452 | 2089980.93172 | 37.718912802856 | -122.428395868697 | (37.718912802856, -122.428395868697) | 9 | 7 | 6 | 28861 | 5 | |||
6396 | 36746 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39516 | |||||||||||||
6466 | 261198 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 690x Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007331 | 2095336 | 37.7338081055982 | -122.417045435619 | (37.7338081055982, -122.417045435619) | 2 | 7 | 7 | 28859 | 2 | ||||
6471 | 237657 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 4187 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | Permit Number 784809 | 6002500.86643 | 2104117.7916 | 37.7576479497003 | -122.434372278263 | (37.7576479497003, -122.434372278263) | 2 | 4 | 5 | 28862 | 3 | ||
6494 | 72378 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 543 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5995284.05494 | 2111855.93801 | 37.7784826006561 | -122.459891318727 | (37.7784826006561, -122.459891318727) | 11 | 6 | 2 | 54 | 11 | |||
6584 | 59702 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3161 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1981 12:00:00 AM | 10 | Permit Number 19132 | 5999572.17341 | 2116007.41636 | 37.7901271605955 | -122.445355723605 | (37.7901271605955, -122.445355723605) | 13 | 6 | 1 | 29490 | 27 | |
6595 | 236574 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2928 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009184.64361 | 2105006.14989 | 37.7604642981045 | -122.41131971344 | (37.7604642981045, -122.41131971344) | 2 | 4 | 7 | 28859 | 19 | |||
6598 | 261578 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 496 Urbano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
6629 | 61206 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 154 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1983 12:00:00 AM | 18 | Permit Number 21074 | 6011186.84016 | 2095845.15313 | 37.735422284496 | -122.403750383288 | (37.735422284496, -122.403750383288) | 10 | 3 | 8 | 58 | 1 | |
6681 | 70524 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 81 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004889.28958 | 2092935.46604 | 37.7270791147056 | -122.425316399345 | (37.7270791147056, -122.425316399345) | 9 | 7 | 6 | 28861 | 5 |
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) );