Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 791 | 791 | 191798 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2 Newhall St | 3 | : 4 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 6 | Width 3ft | Permit Number 774049 | 6018546.987380001 | 2097184.73725 | 37.7395089360924 | -122.378396294176 | (37.7395089360924, -122.378396294176) | |
| 827 | 827 | 191800 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2 Newhall St | 5 | : 4 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 19 | Width 4ft | Permit Number 774049 | 6018580.4534 | 2097158.49779 | 37.739438732322704 | -122.37827876085301 | (37.7394387323227, -122.378278760853) | |
| 860 | 860 | 189218 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 72 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6016946.50299 | 2094945.8896700002 | 37.7332731602285 | -122.38377428587299 | (37.7332731602285, -122.383774285873) | |||
| 874 | 874 | 19854 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 100 STAIRWAY29 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 100ST | ||||||||
| 895 | 895 | 209148 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 217 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5995023.415709999 | 2107016.68952 | 37.7651803042563 | -122.46044222322901 | (37.7651803042563, -122.460442223229) | |||
| 908 | 908 | 206337 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 5993194.556580001 | 2103260.73418 | 37.7547620531274 | -122.466494737945 | (37.7547620531274, -122.466494737945) | |||
| 918 | 918 | 206336 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 5993226.58531 | 2103261.3034200002 | 37.7547654642635 | -122.46638401611 | (37.7547654642635, -122.46638401611) | |||
| 920 | 920 | 206335 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 5993241.59075 | 2103263.0584299997 | 37.7547711488889 | -122.466332251156 | (37.7547711488889, -122.466332251156) | |||
| 930 | 930 | 206338 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 5993167.1259699995 | 2103261.31068 | 37.7547620531391 | -122.466589641618 | (37.7547620531391, -122.466589641618) | |||
| 1928 | 1928 | 252837 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1929 | 1929 | 252833 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1935 | 1935 | 252836 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1939 | 1939 | 252822 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3852 17th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1945 | 1945 | 252839 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 99 Pond St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1948 | 1948 | 252834 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1955 | 1955 | 252835 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1956 | 1956 | 252838 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 99 Pond St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 3248 | 3248 | 23887 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1750X Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003189.5886 | 2113919.6305 | 37.784600462473 | -122.432690563632 | (37.784600462473, -122.432690563632) | |||
| 3434 | 3434 | 225969 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3599 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6005840.01853 | 2101965.4750599996 | 37.751927158923294 | -122.422671163153 | (37.7519271589233, -122.422671163153) | |||
| 3552 | 3552 | 253469 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 701 Stanyan St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5997178.0 | 2108423.0 | 37.7691653834469 | -122.45309160151399 | (37.7691653834469, -122.453091601514) | |||||
| 5019 | 5019 | 23410 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1748X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006148.01248 | 2116523.4539799998 | 37.7919172512266 | -122.422640495371 | (37.7919172512266, -122.422640495371) | |||
| 5869 | 5869 | 19852 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 100 STAIRWAY29 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 6066 | 6066 | 23885 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1750X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6003231.6817 | 2113926.6459999997 | 37.7846221123784 | -122.432545437068 | (37.7846221123784, -122.432545437068) | |||
| 6122 | 6122 | 23406 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1748X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6006168.03383 | 2116381.79756 | 37.7915294275986 | -122.42256115088499 | (37.7915294275986, -122.422561150885) | |||
| 6402 | 6402 | 23443 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2100X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005986.240069999 | 2117685.53144 | 37.7950988961632 | -122.423282873032 | (37.7950988961632, -122.423282873032) | |||
| 8382 | 8382 | 23409 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1748X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006150.92127 | 2116485.89798 | 37.7918142959375 | -122.42262776096202 | (37.7918142959375, -122.422627760962) | |||
| 10541 | 10541 | 1813 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2082 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/13/1991 12:00:00 AM | 12 | 3X3 | 6012099.01215 | 2087998.4540799998 | 37.713927769919 | -122.400045768207 | (37.713927769919, -122.400045768207) | ||
| 12945 | 12945 | 50773 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47304 | ||||||||||
| 13372 | 13372 | 101457 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 102 Henry Adams St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6011370.61745 | 2107778.3214 | 37.7681984164403 | -122.403954480835 | (37.7681984164403, -122.403954480835) | |||
| 14790 | 14790 | 26012 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1618X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 01/02/1998 12:00:00 AM | 3 | 3X3 | 6015044.018999999 | 2095518.8416 | 37.7347410214535 | -122.390391768412 | (37.7347410214535, -122.390391768412) | ||
| 16785 | 16785 | 22369 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 5501 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/1991 12:00:00 AM | 18 | 3x3 | 6014174.2225 | 2092865.1923 | 37.7274063523799 | -122.393213349079 | (37.7274063523799, -122.393213349079) | ||
| 17115 | 17115 | 19795 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 100 STAIRWAY20 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
| 18557 | 18557 | 12099 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1281X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/1992 12:00:00 AM | 24 | 3X3 | 6017033.141005999 | 2094557.4754692002 | 37.732211440602605 | -122.383447721977 | (37.7322114406026, -122.383447721977) | ||
| 19280 | 19280 | 1843 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2200 Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011383.0146015 | 2087402.1416029998 | 37.712250468957 | -122.40247863283399 | (37.712250468957, -122.402478632834) | |||
| 23139 | 23139 | 19365 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 500X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5993863.684719999 | 2114886.5972700003 | 37.7867221812625 | -122.46502504683998 | (37.7867221812625, -122.46502504684) | |||
| 23322 | 23322 | 23886 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1750X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6003218.9262 | 2113924.0949 | 37.784614384352004 | -122.432589384494 | (37.784614384352, -122.432589384494) | |||
| 25089 | 25089 | 224296 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 5 Powhattan Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 43 | Width 3ft | 6007487.03456 | 2098209.30712 | 37.7417063503734 | -122.416709460186 | (37.7417063503734, -122.416709460186) | |||
| 34382 | 34382 | 224289 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 166 San Carlos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6006647.346419999 | 2105145.25174 | 37.7607036068074 | -122.420104944992 | (37.7607036068074, -122.420104944992) | |||
| 36186 | 36186 | 224283 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2501 17th St | 7 | : 4 | Tree 1 | Private 1 | 25 | Width 6ft | 6009798.458330001 | 2106396.21275 | 37.7643155017769 | -122.409294898865 | (37.7643155017769, -122.409294898865) | |||
| 40478 | 40478 | 224285 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 265 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6006995.99918 | 2107893.32251 | 37.768268803682496 | -122.419094036861 | (37.7682688036825, -122.419094036861) | |||
| 40911 | 40911 | 191801 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 200 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6018647.97936 | 2096995.63992 | 37.7389952784126 | -122.37803398157801 | (37.7389952784126, -122.378033981578) | |||
| 41610 | 41610 | 137658 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1518 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6001865.8981 | 2111549.7624 | 37.7780182464137 | -122.43710034649901 | (37.7780182464137, -122.437100346499) | |||
| 46707 | 46707 | 176350 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2069 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012239.28091 | 2088001.1839700001 | 37.7139430853807 | -122.399561135264 | (37.7139430853807, -122.399561135264) | |||
| 49856 | 49856 | 199770 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1197 Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 0ft | 6016938.605 | 2092287.245 | 37.725972609082106 | -122.383616561306 | (37.7259726090821, -122.383616561306) | |||
| 50104 | 50104 | 117089 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 200X 10TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008367.0 | 2109860.0 | 37.773745949403 | -122.414491044326 | (37.773745949403, -122.414491044326) | ||||
| 50940 | 50940 | 141612 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 36 LOYOLA TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5998439.8972 | 2110934.038 | 37.776132290373795 | -122.448907689979 | (37.7761322903738, -122.448907689979) | |||
| 53686 | 53686 | 191794 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 800 Terry A Francois Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 4ft | 6016193.39876 | 2106582.6581099997 | 37.7651836497265 | -122.387189402894 | (37.7651836497265, -122.387189402894) | |||
| 56188 | 56188 | 209049 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 459 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 5999058.18767 | 2094958.3762 | 37.732302390632704 | -122.445619770845 | (37.7323023906327, -122.445619770845) | |||
| 57701 | 57701 | 200916 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3801 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 6015698.5199 | 2097861.9006 | 37.741210869467004 | -122.388292389499 | (37.741210869467, -122.388292389499) | |||
| 58211 | 58211 | 224300 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 199 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004199.46897 | 2097141.98327 | 37.738590268731706 | -122.428000728147 | (37.7385902687317, -122.428000728147) | |||
| 61117 | 61117 | 224281 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2501 17th St | 4 | : 4 | Tree 1 | Private 1 | 25 | Width 6ft | 6009683.49225 | 2106388.44143 | 37.7642877217255 | -122.40969198731301 | (37.7642877217255, -122.409691987313) | |||
| 61146 | 61146 | 117086 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1401 HOWARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6008367.0 | 2109860.0 | 37.773745949403 | -122.414491044326 | (37.773745949403, -122.414491044326) | |||
| 61488 | 61488 | 176353 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2168 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6012284.29807 | 2088275.4365 | 37.714698637311 | -122.399424780029 | (37.714698637311, -122.399424780029) | |||
| 62008 | 62008 | 191805 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 220 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6011499.25234 | 2107482.34524 | 37.767392918862704 | -122.40348871744301 | (37.7673929188627, -122.403488717443) | |||
| 66148 | 66148 | 224293 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 319 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6006573.93081 | 2097319.1871599997 | 37.739210880983 | -122.41980352911001 | (37.739210880983, -122.41980352911) | |||
| 68368 | 68368 | 224297 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 154 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 2ft | 6004792.404180001 | 2095928.09422 | 37.7352907307678 | -122.42586425822999 | (37.7352907307678, -122.42586425823) | |||
| 69955 | 69955 | 41050 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 220 10th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1999 12:00:00 AM | Permit Number 41830 | 6008482.96704788 | 2109848.1149541 | 37.7737198300469 | -122.41408905371 | (37.7737198300469, -122.41408905371) | ||
| 70466 | 70466 | 199996 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1180 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 0ft | 6016983.2238 | 2092322.4993 | 37.726071876628104 | -122.383464768614 | (37.7260718766281, -122.383464768614) | |||
| 70678 | 70678 | 224290 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3854 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004813.0494800005 | 2100782.0452400004 | 37.74861974110579 | -122.426138328431 | (37.7486197411058, -122.426138328431) | |||
| 71102 | 71102 | 176352 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2004 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012299.5158 | 2088325.62529 | 37.714837293886 | -122.399375702234 | (37.714837293886, -122.399375702234) | |||
| 71175 | 71175 | 199998 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1180 Thomas Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6016948.5203 | 2092356.1011 | 37.7261622225289 | -122.383587075969 | (37.7261622225289, -122.383587075969) | |||
| 72210 | 72210 | 16475 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
| 77201 | 77201 | 224291 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3854 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6004797.3465 | 2100779.67423 | 37.7486123433069 | -122.42619246040701 | (37.7486123433069, -122.426192460407) | |||
| 77351 | 77351 | 12094 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1261X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | |||
| 80603 | 80603 | 49791 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 8 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46579 | 6006641.33781708 | 2109233.21356328 | 37.7719278473573 | -122.42041589538601 | (37.7719278473573, -122.420415895386) | ||
| 81941 | 81941 | 99017 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1133 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768754 | 6008997.0 | 2116859.0 | 37.7929988993441 | -122.41280668476999 | (37.7929988993441, -122.41280668477) | ||||
| 83001 | 83001 | 8296 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 18 Garlington Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016769.107068701 | 2094699.6972286 | 37.7325873571063 | -122.384370457364 | (37.7325873571063, -122.384370457364) | |||
| 84145 | 84145 | 39150 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1201 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40824 | 6005810.90116687 | 2101975.65713529 | 37.751953473746 | -122.42277257880899 | (37.751953473746, -122.422772578809) | ||
| 84644 | 84644 | 8439 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1720X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003193.61701 | 2113921.75435 | 37.7846065224894 | -122.43267677846599 | (37.7846065224894, -122.432676778466) | |||
| 84693 | 84693 | 1816 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2100 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012027.2003656 | 2087907.9406618 | 37.7136752340099 | -122.400287624748 | (37.7136752340099, -122.400287624748) | |||
| 85616 | 85616 | 1762 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2000X Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 3x3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
| 86584 | 86584 | 16461 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018746.801501201 | 2097101.6577332001 | 37.739291827880294 | -122.37769965200899 | (37.7392918278803, -122.377699652009) | |||
| 86585 | 86585 | 1862 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2510 Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010780.8257042 | 2086709.3373148 | 37.710314531205896 | -122.404511250175 | (37.7103145312059, -122.404511250175) | |||
| 87252 | 87252 | 1861 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2510 Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6010780.8257042 | 2086709.3373148 | 37.710314531205896 | -122.404511250175 | (37.7103145312059, -122.404511250175) | |||
| 87451 | 87451 | 41730 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 8 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46579 | 6006641.33781708 | 2109233.21356328 | 37.7719278473573 | -122.42041589538601 | (37.7719278473573, -122.420415895386) | ||
| 87452 | 87452 | 12105 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1281X La Salle Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/1992 12:00:00 AM | 18 | 3X3 | 6017033.141005999 | 2094557.4754692002 | 37.732211440602605 | -122.383447721977 | (37.7322114406026, -122.383447721977) | ||
| 87914 | 87914 | 1852 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2401 Bay Shore Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/23/1992 12:00:00 AM | 12 | 3X3 | 6011063.3259362 | 2087019.7277799998 | 37.7111825850692 | -122.403556689346 | (37.7111825850692, -122.403556689346) | ||
| 89226 | 89226 | 41821 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1514 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2000 12:00:00 AM | Permit Number 42208 | 6001899.39673806 | 2111557.7304121996 | 37.778042028638296 | -122.436985033556 | (37.7780420286383, -122.436985033556) | |||
| 89272 | 89272 | 97967 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1626 Shrader St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998119.3 | 2105007.8 | 37.7598420097441 | -122.44958958605899 | (37.7598420097441, -122.449589586059) | |||||
| 89329 | 89329 | 16462 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6018746.801501201 | 2097101.6577332001 | 37.739291827880294 | -122.37769965200899 | (37.7392918278803, -122.377699652009) | |||
| 89952 | 89952 | 97966 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1626 Shrader St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 4x4 | 5998119.3 | 2105007.8 | 37.7598420097441 | -122.44958958605899 | (37.7598420097441, -122.449589586059) | |||
| 90238 | 90238 | 16471 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
| 90959 | 90959 | 32613 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1200 06th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37077 | 5994245.61901 | 2107184.37901 | 37.765595960874705 | -122.463144582494 | (37.7655959608747, -122.463144582494) | ||
| 91559 | 91559 | 32619 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1200 06th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37077 | 5994251.86901 | 2107069.79501 | 37.765281703209894 | -122.463114650601 | (37.7652817032099, -122.463114650601) | ||
| 91606 | 91606 | 32616 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1200 06th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37077 | 5994255.34101 | 2106936.46201 | 37.7649158056389 | -122.463092966814 | (37.7649158056389, -122.463092966814) | ||
| 91894 | 91894 | 39155 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1201 Guerrero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40824 | 6005810.90116687 | 2101975.65713529 | 37.751953473746 | -122.42277257880899 | (37.751953473746, -122.422772578809) | ||
| 93163 | 93163 | 12090 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1261X La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | |||
| 94981 | 94981 | 15024 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 845 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/1992 12:00:00 AM | 17 | 3X3 | 6015971.14204 | 2096622.00458 | 37.7378214697096 | -122.387263283018 | (37.7378214697096, -122.387263283018) | ||
| 96388 | 96388 | 16476 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
| 97437 | 97437 | 1826 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2138 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1991 12:00:00 AM | 12 | 3x3 | 6011843.4146873 | 2087682.3291292998 | 37.713045499820794 | -122.400907017094 | (37.7130454998208, -122.400907017094) | ||
| 97946 | 97946 | 16466 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018746.801501201 | 2097101.6577332001 | 37.739291827880294 | -122.37769965200899 | (37.7392918278803, -122.377699652009) | |||
| 97997 | 97997 | 121135 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 200 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011463.0 | 2107546.0 | 37.7675656754516 | -122.40361858917299 | (37.7675656754516, -122.403618589173) | ||||
| 98048 | 98048 | 24204 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 80X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/1991 12:00:00 AM | 30 | 3x3 | 6016946.00997 | 2094945.60902 | 37.73327236236629 | -122.383775970862 | (37.7332723623663, -122.383775970862) | ||
| 98871 | 98871 | 73589 | Planning Code 138.1 required 4 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 468 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/1995 12:00:00 AM | 12 | 3x3 | Permit Number 770905 | 6010928.13640467 | 2111848.51157587 | 37.7793494887795 | -122.405771720076 | (37.7793494887795, -122.405771720076) | |
| 99347 | 99347 | 12117 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1295X La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1992 12:00:00 AM | 24 | 3X3 | 6016958.2682626 | 2094597.9426773998 | 37.7323184171755 | -122.383709392876 | (37.7323184171755, -122.383709392876) | ||
| 100182 | 100182 | 40345 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1132 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2003 12:00:00 AM | Permit Number 41475 | 6005084.75376098 | 2101750.889457 | 37.7512953165646 | -122.425267709911 | (37.7512953165646, -122.425267709911) | ||
| 101035 | 101035 | 117088 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1401 HOWARD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6008367.0 | 2109860.0 | 37.773745949403 | -122.414491044326 | (37.773745949403, -122.414491044326) | ||||
| 101377 | 101377 | 105163 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1600X OAKDALE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 17 | 4x4 | Permit Number 770204 | 6015006.0 | 2095503.0 | 37.734695414582795 | -122.390522107646 | (37.7346954145828, -122.390522107646) | ||
| 102500 | 102500 | 3793 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 75 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017167.2819088 | 2095817.4840533 | 37.7356785868328 | -122.38307162670601 | (37.7356785868328, -122.383071626706) | |||
| 102959 | 102959 | 41059 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 220 10th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1999 12:00:00 AM | Permit Number 41830 | 6008482.96704788 | 2109848.1149541 | 37.7737198300469 | -122.41408905371 | (37.7737198300469, -122.41408905371) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");