trees
6,714 rows where qSpecies_id = 7 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 |
| 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 | |||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | |
| 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 | |
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 6844 | 235670 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 69 Elgin Park | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6005833.06667 | 2108709.07327 | 37.7704431026896 | -122.423174504696 | (37.7704431026896, -122.423174504696) | 8 | 2 | 5 | 28853 | 19 | |||
| 6903 | 38781 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 534 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | 7 | Permit Number 40639 | 6013329.04635 | 2111645.89395 | 37.7789271198304 | -122.397451696238 | (37.7789271198304, -122.397451696238) | 6 | 2 | 9 | 28856 | 34 | |
| 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 | |||
| 7033 | 214228 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 714 Detroit St | 16 | Side Yard : Yard | Tree | Private 2 | 5 | 5999467.54728 | 2095443.9032 | 37.733658896535 | -122.444239403229 | (37.733658896535, -122.444239403229) | 9 | 7 | 4 | 63 | 40 | ||||
| 7114 | 20035 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 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 | |||
| 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 | |||
| 7355 | 218024 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2439 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992321.61488 | 2098826.36929 | 37.7425360172282 | -122.469190857781 | (37.7425360172282, -122.469190857781) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 7394 | 236442 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1098 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998931 | 2106271 | 37.7633568442315 | -122.446873221995 | (37.7633568442315, -122.446873221995) | 15 | 5 | 11 | 29492 | 9 | |||
| 7481 | 236548 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1199x Eugenia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008197.38645 | 2097705.34234 | 37.7403625015365 | -122.414217644728 | (37.7403625015365, -122.414217644728) | 2 | 7 | 7 | 28859 | 2 | |||
| 7520 | 236941 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 42 Putnam St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009158.27721 | 2097193.88285 | 37.7390120723534 | -122.410859138235 | (37.7390120723534, -122.410859138235) | 10 | 7 | 7 | 28859 | 2 | |||
| 7533 | 32000 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1100 Brazil Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1995 12:00:00 AM | 4 | Permit Number 35398 | 6004681.79036 | 2090489.98431 | 37.7203526336359 | -122.425859724763 | (37.7203526336359, -122.425859724763) | 9 | 7 | 6 | 28861 | 5 | |
| 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 | |||
| 7595 | 178710 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 500 London St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001568.61805 | 2090782.47378 | 37.720979319025 | -122.43664185145 | (37.720979319025, -122.43664185145) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 7676 | 78416 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2959 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5990231.30854 | 2095554.29925 | 37.7334307457305 | -122.47617950378 | (37.7334307457305, -122.47617950378) | 1 | 8 | 4 | 64 | 35 | |||
| 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 | |||
| 7922 | 135849 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2456 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007515.30382 | 2120841.49853 | 37.8038505659037 | -122.418215928918 | (37.8038505659037, -122.418215928918) | 5 | 1 | 1 | 308 | 32 | |||
| 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 | |||
| 7976 | 20040 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
| 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 | |||
| 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 | |||
| 8287 | 196310 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 928 Clara St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6011726.41935 | 2111671.91567 | 37.7789092071182 | -122.402997684908 | (37.7789092071182, -122.402997684908) | 14 | 2 | 9 | 28856 | 34 | |||
| 8314 | 71206 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 838 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988535.53493 | 2110268.06328 | 37.7737323174457 | -122.483120303898 | (37.7737323174457, -122.483120303898) | 11 | 6 | 2 | 55 | 26 |
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) );