trees
6,714 rows where qSpecies_id = 7 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||||||||||||
| 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 | |
| 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 | |||
| 6715 | 67660 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 37 Lucy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 6 | Permit Number 31261 | 6014167.43331 | 2093890.78969 | 37.7302220581813 | -122.393308558267 | (37.7302220581813, -122.393308558267) | 10 | 3 | 8 | 58 | 1 | |
| 6743 | 237502 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3707 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003619.47904 | 2103592.43752 | 37.7562688834292 | -122.430466176382 | (37.7562688834292, -122.430466176382) | 2 | 4 | 5 | 28862 | 22 | |||
| 6773 | 72338 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 854 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988539.28579 | 2110148.33783 | 37.773403802887 | -122.483098552076 | (37.773403802887, -122.483098552076) | 11 | 6 | 2 | 55 | 26 | |||
| 6924 | 49135 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 110 Valdez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2003 12:00:00 AM | Permit Number 46262 | 5996344.49436596 | 2094285.70346417 | 37.7303000887527 | -122.454952988796 | (37.7303000887527, -122.454952988796) | 9 | 7 | 4 | 28861 | 40 | ||
| 6988 | 72005 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1963 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5987221.7723 | 2101915.2958 | 37.7507213765199 | -122.487051188188 | (37.7507213765199, -122.487051188188) | 1 | 8 | 3 | 29491 | 35 | |||
| 7158 | 261760 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 45 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007217 | 2095455 | 37.7341284399303 | -122.417447999393 | (37.7341284399303, -122.417447999393) | 2 | 7 | 7 | 28859 | 2 | ||||
| 7227 | 181941 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2338 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985894.7639 | 2098931.5489 | 37.7424513496728 | -122.49142044264 | (37.7424513496728, -122.49142044264) | 1 | 8 | 3 | 29491 | 35 | |||
| 7250 | 72385 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 686 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5995057.69186 | 2110887.03516 | 37.7758092299392 | -122.460604158861 | (37.7758092299392, -122.460604158861) | 11 | 6 | 2 | 54 | 11 | |||
| 7286 | 33084 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
| 7292 | 139423 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2683 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999790.4795 | 2113984.7901 | 37.7845860157612 | -122.444454981067 | (37.7845860157612, -122.444454981067) | 15 | 6 | 11 | 29490 | 31 | |||
| 7329 | 83337 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2815 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6000055.78832 | 2117427.57453 | 37.7940541366405 | -122.443784531525 | (37.7940541366405, -122.443784531525) | 13 | 9 | 1 | 57 | 27 | |||
| 7370 | 78746 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 355 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009102.50426 | 2088111.28549 | 37.7140700552715 | -122.410410826197 | (37.7140700552715, -122.410410826197) | 9 | 7 | 8 | 309 | 39 | |||
| 7470 | 40426 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 572 Wildwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1999 12:00:00 AM | Permit Number 41522 | 5994442.84312797 | 2093351.87569512 | 37.7276267513816 | -122.461459534939 | (37.7276267513816, -122.461459534939) | 9 | 8 | 4 | 59 | 40 | ||
| 7551 | 32829 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 4255 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37187 | 6001551.51110422 | 2101720.28734658 | 37.7510110467741 | -122.437483847043 | (37.7510110467741, -122.437483847043) | 2 | 4 | 5 | 28862 | 22 | ||
| 7579 | 72318 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 539 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 9x6 | 5995283.47328 | 2111879.02377 | 37.7785459545642 | -122.459895003637 | (37.7785459545642, -122.459895003637) | 11 | 6 | 2 | 54 | 11 | |||
| 7604 | 70169 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 5233 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5982394.50702 | 2111657.31782 | 37.7771875318175 | -122.504465669217 | (37.7771875318175, -122.504465669217) | 11 | 6 | 2 | 55 | 26 | |||
| 7618 | 235999 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 365 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6003615.09862 | 2098623.52813 | 37.7426251724083 | -122.43012686309 | (37.7426251724083, -122.43012686309) | 2 | 7 | 5 | 63 | 22 | |||
| 7792 | 81654 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1773 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6014140.03196 | 2096118.29222 | 37.7363368024053 | -122.393559125566 | (37.7363368024053, -122.393559125566) | 10 | 3 | 8 | 58 | 1 | |||
| 7843 | 202011 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 35 Wheat St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6012102.79015 | 2091227.84985 | 37.7227952498849 | -122.400259388686 | (37.7227952498849, -122.400259388686) | 10 | 3 | 8 | 58 | 1 | |||
| 7950 | 78312 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 546 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002946.84027 | 2090441.19936 | 37.7201204817617 | -122.431853395021 | (37.7201204817617, -122.431853395021) | 9 | 7 | 6 | 28861 | 5 | |||
| 8070 | 72336 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 778 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988856.36837 | 2110023.77436 | 37.7730802324948 | -122.481992604718 | (37.7730802324948, -122.481992604718) | 11 | 6 | 2 | 55 | 26 | |||
| 8216 | 261364 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 37 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007227 | 2095555 | 37.734403580666 | -122.417420510703 | (37.734403580666, -122.417420510703) | 2 | 7 | 7 | 28859 | 2 | ||||
| 8220 | 212707 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1439 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5994565.98091 | 2105717.62937 | 37.7615870971916 | -122.461930160547 | (37.7615870971916, -122.461930160547) | 1 | 5 | 11 | 56 | 12 | |||
| 8262 | 236009 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 342 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6003704.29788 | 2098672.67135 | 37.7427651599925 | -122.429821942527 | (37.7427651599925, -122.429821942527) | 2 | 7 | 5 | 63 | 22 | |||
| 8299 | 82782 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 285 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50432 | 6003797.68520335 | 2104478.00644987 | 37.758710538762 | -122.429913044242 | (37.758710538762, -122.429913044242) | 2 | 4 | 5 | 28862 | 3 | ||
| 8340 | 60789 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 252 Ewing Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1983 12:00:00 AM | 4 | Permit Number 20463 | 5998448.6899 | 2112305.4709 | 37.7798983929143 | -122.448976088075 | (37.7798983929143, -122.448976088075) | 15 | 6 | 2 | 54 | 16 | |
| 8404 | 46807 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 170 San Felipe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44891 | 5994047.88467272 | 2095052.68932043 | 37.7322740285646 | -122.462948245202 | (37.7322740285646, -122.462948245202) | 9 | 8 | 4 | 59 | 40 | ||
| 8491 | 84919 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 215 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2007 12:00:00 AM | 3 | Permit Number 49339 | 6009512.67609 | 2094567.40157 | 37.731820184958 | -122.409448471593 | (37.731820184958, -122.409448471593) | 9 | 3 | 7 | 309 | 28 | ||
| 8553 | 214289 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 46 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | 6 | Width 2ft | Permit Number 42620 | 5999770.30024 | 2093799.89409 | 37.7291620992362 | -122.443074673282 | (37.7291620992362, -122.443074673282) | 9 | 7 | 4 | 63 | 40 | |
| 8662 | 236510 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 281 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | Permit Number 783074 | 6008991.12721 | 2097033.14308 | 37.7385613420185 | -122.411425715645 | (37.7385613420185, -122.411425715645) | 10 | 7 | 7 | 28859 | 2 | ||
| 8864 | 236310 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3186 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007726.45399 | 2102693.43972 | 37.7540322344234 | -122.416199135408 | (37.7540322344234, -122.416199135408) | 2 | 4 | 7 | 28859 | 19 | |||
| 8879 | 59473 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1615 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51005 | 5999993.3242 | 2110893.3383 | 37.7761092547589 | -122.443531061203 | (37.7761092547589, -122.443531061203) | 15 | 5 | 11 | 29492 | 16 | |
| 8907 | 78209 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 602 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011148.7159 | 2091968.96247 | 37.7247769455958 | -122.403609556646 | (37.7247769455958, -122.403609556646) | 10 | 3 | 7 | 309 | 28 | |||
| 8912 | 45296 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 586 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44763 | 6008684.90239462 | 2096105.66029686 | 37.7359974954785 | -122.412418957568 | (37.7359974954785, -122.412418957568) | 10 | 7 | 7 | 28859 | 2 | ||
| 8994 | 73532 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 838 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988535.77242 | 2110247.48353 | 37.7736758249905 | -122.483117973661 | (37.7736758249905, -122.483117973661) | 11 | 6 | 2 | 55 | 26 | |||
| 9007 | 23899 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1600X Webster St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6003605.1476962 | 2114190.7261663 | 37.785368381567 | -122.431272227533 | (37.785368381567, -122.431272227533) | 13 | 9 | 11 | 29490 | 13 | |||
| 9021 | 236620 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3031 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008725.435 | 2102707.57209 | 37.7541271596615 | -122.412745405998 | (37.7541271596615, -122.412745405998) | 2 | 4 | 7 | 28859 | 19 | |||
| 9045 | 217860 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1525 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | Permit Number 784373 | 5996862.66566 | 2105957.03699 | 37.7623764033599 | -122.454004200645 | (37.7623764033599, -122.454004200645) | 15 | 5 | 11 | 29492 | 12 | ||
| 9072 | 235773 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1449 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007770.63381 | 2107353.8886 | 37.7668312365099 | -122.416376430431 | (37.7668312365099, -122.416376430431) | 8 | 4 | 7 | 28853 | 19 | |||
| 9103 | 236319 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2870 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6008996.29845 | 2103350.92649 | 37.7559088650107 | -122.411854149066 | (37.7559088650107, -122.411854149066) | 2 | 4 | 7 | 28859 | 19 | |||
| 9204 | 78231 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 924 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6008861.56541 | 2090881.25094 | 37.7216622938669 | -122.411439180279 | (37.7216622938669, -122.411439180279) | 9 | 3 | 7 | 309 | 28 | |||
| 9256 | 236946 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 147 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007380.39816 | 2097532.19381 | 37.7398411492515 | -122.417030208789 | (37.7398411492515, -122.417030208789) | 2 | 7 | 7 | 28859 | 2 | |||
| 9340 | 78715 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 190 Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008812.7369 | 2086938.04091 | 37.7108323187195 | -122.411329543927 | (37.7108323187195, -122.411329543927) | 9 | 7 | 8 | 309 | 39 | |||
| 9390 | 70849 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 342 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6002406.02923 | 2091608.42351 | 37.7232947459327 | -122.433806177538 | (37.7232947459327, -122.433806177538) | 9 | 7 | 6 | 28861 | 5 | |||
| 9402 | 72253 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 538 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002525.55388 | 2090783.37547 | 37.7210361300962 | -122.433334076631 | (37.7210361300962, -122.433334076631) | 9 | 7 | 6 | 28861 | 5 | |||
| 9410 | 79837 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2808 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006109.45612 | 2120466.37489 | 37.8027413403128 | -122.423054277046 | (37.8027413403128, -122.423054277046) | 5 | 9 | 1 | 28858 | 32 | |||
| 9446 | 56421 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 232 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2020 12:00:00 AM | 3 | 5x5 | Permit Number 12581 | 5990270.93478 | 2113836.22748 | 37.7836303428936 | -122.47737817827 | (37.7836303428936, -122.47737817827) | 11 | 6 | 2 | 55 | 26 | |
| 9472 | 78510 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 750 Eucalyptus Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988931.24396 | 2094774.45392 | 37.7312140158088 | -122.480617072624 | (37.7312140158088, -122.480617072624) | 1 | 8 | 4 | 64 | 35 | |||
| 9521 | 35167 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1998 12:00:00 AM | Permit Number 38700 | |||||||||||||
| 9652 | 178811 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 19 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6007941.79133 | 2094126.71346 | 37.7305220072776 | -122.414848183713 | (37.7305220072776, -122.414848183713) | 9 | 3 | 7 | 309 | 28 | |||
| 9776 | 236304 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 128 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006662 | 2102868 | 37.7544516263091 | -122.419892666236 | (37.7544516263091, -122.419892666236) | 2 | 4 | 7 | 28859 | 19 | |||
| 10011 | 60550 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 538 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1982 12:00:00 AM | 4 | Permit Number 20160 | 5985052.81447 | 2112190.69486 | 37.7788080303748 | -122.495309219696 | (37.7788080303748, -122.495309219696) | 11 | 6 | 2 | 55 | 26 | |
| 10074 | 60538 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 559 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1982 12:00:00 AM | 11 | Permit Number 20148 | 5985322.95349 | 2112076.73738 | 37.7785109487205 | -122.494366313855 | (37.7785109487205, -122.494366313855) | 11 | 6 | 2 | 55 | 26 | |
| 10094 | 212393 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 55 San Rafael Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5991911.35138 | 2095658.63831 | 37.7338145152114 | -122.470378772281 | (37.7338145152114, -122.470378772281) | 9 | 8 | 4 | 59 | 40 |
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) );