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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 105441 | 105441 | 26152 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1500 Oakdale Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | |||
| 105539 | 105539 | 41056 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 220 10th St | 12 | 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) | ||
| 105570 | 105570 | 100419 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 760 Duboce Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002024.1 | 2108325.5 | 37.7691742163209 | -122.43632225874201 | (37.7691742163209, -122.436322258742) | |||||
| 106299 | 106299 | 32612 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1200 06th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37077 | 5994246.31301 | 2107167.0180099998 | 37.7655483320884 | -122.46314092231701 | (37.7655483320884, -122.463140922317) | ||
| 106392 | 106392 | 8302 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 25 Garlington Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016780.483136799 | 2094683.2530579 | 37.732542833716 | -122.38432998229099 | (37.732542833716, -122.384329982291) | |||
| 109219 | 109219 | 86860 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Chenery St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2007 12:00:00 AM | 3x3 | Permit Number 49749 | 6004853.9 | 2097638.4 | 37.7399903195304 | -122.42577334131501 | (37.7399903195304, -122.425773341315) | |||
| 109646 | 109646 | 41822 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1514 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/2003 12:00:00 AM | Permit Number 46307 | 6001899.39673806 | 2111557.7304121996 | 37.778042028638296 | -122.436985033556 | (37.7780420286383, -122.436985033556) | ||
| 110348 | 110348 | 49792 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 8 Gough St | 3 | 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) | ||
| 110417 | 110417 | 41739 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 74 Otis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42178 | 6006750.47865319 | 2109297.32010608 | 37.772110018382605 | -122.420042918685 | (37.7721100183826, -122.420042918685) | ||
| 110493 | 110493 | 32620 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1200 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37077 | 5994260.20201 | 2106772.57301 | 37.7644660892521 | -122.46306426191799 | (37.7644660892521, -122.463064261918) | ||
| 111168 | 111168 | 22108 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3550 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015960.65745 | 2099048.08294 | 37.744482404383895 | -122.387468734005 | (37.7444824043839, -122.387468734005) | |||
| 111401 | 111401 | 32617 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1200 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37077 | 5994262.98001 | 2106757.29501 | 37.7644242998742 | -122.463053545067 | (37.7644242998742, -122.463053545067) | ||
| 111671 | 111671 | 109907 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1415 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/17/2015 10:12:00 AM | 9 | 4x4 | 6008287.6 | 2109783.3 | 37.773530888410896 | -122.414760273118 | (37.7735308884109, -122.414760273118) | ||
| 111673 | 111673 | 40884 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 130 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1999 12:00:00 AM | Permit Number 41791 | 6006302.5482832 | 2097469.41994668 | 37.7396080946336 | -122.420752512088 | (37.7396080946336, -122.420752512088) | |||
| 113390 | 113390 | 117085 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1415 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6008287.6 | 2109783.3 | 37.773530888410896 | -122.414760273118 | (37.7735308884109, -122.414760273118) | |||
| 113569 | 113569 | 51638 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3456 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1991 12:00:00 AM | Permit Number 47929 | 6005371.85163442 | 2103157.01504278 | 37.7551724265056 | -122.424374893952 | (37.7551724265056, -122.424374893952) | ||
| 113964 | 113964 | 8305 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 29 Garlington Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016787.0658034 | 2094691.4882738998 | 37.732565809963106 | -122.384307797551 | (37.7325658099631, -122.384307797551) | |||
| 114981 | 114981 | 117087 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1401 HOWARD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | Permit Number 778313 | 6008367.0 | 2109860.0 | 37.773745949403 | -122.414491044326 | (37.773745949403, -122.414491044326) | |||
| 115131 | 115131 | 16473 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
| 117123 | 117123 | 12636 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 901 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5992666.273990001 | 2114790.8903900003 | 37.7863902797856 | -122.46916079788099 | (37.7863902797856, -122.469160797881) | |||
| 117654 | 117654 | 41074 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 291 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/1999 12:00:00 AM | Permit Number 41834 | 6008813.87859948 | 2109576.97435199 | 37.7729939222966 | -122.412925200561 | (37.7729939222966, -122.412925200561) | ||
| 118766 | 118766 | 41058 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 220 10th St | 10 | 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) | ||
| 119167 | 119167 | 67755 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 4726 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | 30 | 4x18 | Permit Number 31695 | 5988692.74366 | 2109899.16641 | 37.77272857598221 | -122.482549464072 | (37.7727285759822, -122.482549464072) |
| 119232 | 119232 | 6465 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1200X Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:16:00 PM | 3 | 3X3 | 6017709.266009999 | 2097062.52601 | 37.739127157777205 | -122.38128430413201 | (37.7391271577772, -122.381284304132) | ||
| 119882 | 119882 | 32621 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1200 06th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37077 | 5994249.09101 | 2107137.85101 | 37.7654684071637 | -122.463129197416 | (37.7654684071637, -122.463129197416) | ||
| 120281 | 120281 | 91151 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3700 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52033 | 5999669.0 | 2121219.0 | 37.8044423086661 | -122.44539559761002 | (37.8044423086661, -122.44539559761) |
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");