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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||||
| 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 | ||||||||
| 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) | |||
| 139020 | 139020 | 1856 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2500 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010837.5147418 | 2086759.4488696998 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | |||
| 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) | ||
| 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) | |||
| 151573 | 151573 | 55192 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 220 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1972 12:00:00 AM | 19 | Permit Number 11103 | 6012714.42141 | 2087449.1506599998 | 37.712453784683 | -122.39788016024201 | (37.712453784683, -122.397880160242) | ||
| 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) | ||
| 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) | |||
| 125100 | 125100 | 1818 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2100 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 3 | 6 | 6012027.2003656 | 2087907.9406618 | 37.7136752340099 | -122.400287624748 | (37.7136752340099, -122.400287624748) | ||
| 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) | ||
| 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) | |||
| 154010 | 154010 | 176354 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2010 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012259.72044 | 2088213.82331 | 37.71452808988 | -122.39950540785 | (37.71452808988, -122.39950540785) | |||
| 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) | |||
| 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) | |||
| 153602 | 153602 | 176351 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2004 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6012309.13174 | 2088349.6690200001 | 37.7149038491123 | -122.399344152214 | (37.7149038491123, -122.399344152214) | |||
| 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) | ||
| 127141 | 127141 | 1761 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2000X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/1991 12:00:00 AM | 18 | 3x3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
| 139000 | 139000 | 1768 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2000X Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/1991 12:00:00 AM | 24 | 3X3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
| 143575 | 143575 | 1765 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2000X Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/1991 12:00:00 AM | 36 | 3X3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
| 179691 | 179691 | 209048 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 700 Junipero Serra Blvd | 104 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5991233.86776 | 2091994.8214 | 37.7237153966338 | -122.472454001045 | (37.7237153966338, -122.472454001045) | |||
| 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) | |||
| 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) | |||
| 165546 | 165546 | 199997 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1180 Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6016965.5966 | 2092340.1265 | 37.7261193032287 | -122.383526931977 | (37.7261193032287, -122.383526931977) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 125721 | 125721 | 12093 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1261X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | |||
| 140266 | 140266 | 12081 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1261X La Salle Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/1992 12:00:00 AM | 18 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 127449 | 127449 | 10848 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1139X Hudson Ave | 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6018102.76401 | 2094614.84701 | 37.7324280296634 | -122.379753739799 | (37.7324280296634, -122.379753739799) | |||
| 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) | |||
| 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) | |||
| 139770 | 139770 | 8304 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 29 Garlington Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016787.0658034 | 2094691.4882738998 | 37.732565809963106 | -122.384307797551 | (37.7325658099631, -122.384307797551) | |||
| 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) | |||
| 124338 | 124338 | 96807 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1520X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x100 | 5993467.0 | 2095277.3 | 37.732857277474295 | -122.464972786509 | (37.7328572774743, -122.464972786509) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 159676 | 159676 | 224286 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1201 San Jose Ave | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6004321.04258 | 2095921.8104 | 37.735246827671 | -122.427493481761 | (37.735246827671, -122.427493481761) | ||||
| 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) | |||
| 186600 | 186600 | 224287 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1201 San Jose Ave | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | 6004351.28385 | 2095952.40857 | 37.7353325537541 | -122.42739110562799 | (37.7353325537541, -122.427391105628) | ||||
| 152947 | 152947 | 224288 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1201 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6004376.514219999 | 2095976.51877 | 37.7354001818557 | -122.427305591801 | (37.7354001818557, -122.427305591801) | ||||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 135113 | 135113 | 224294 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 321 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006569.1031 | 2097310.46847 | 37.739186669434204 | -122.419819602701 | (37.7391866694342, -122.419819602701) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 140227 | 140227 | 16472 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 133098 | 133098 | 191799 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 24 | Width 4ft | 6018564.11417 | 2097173.23037 | 37.739478284492996 | -122.37833627789499 | (37.739478284493, -122.378336277895) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 127345 | 127345 | 28139 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 525X EUGENIA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6007058.0 | 2097880.0 | 37.740778006453795 | -122.418169580752 | (37.7407780064538, -122.418169580752) | |||
| 122570 | 122570 | 22179 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3955X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/1992 12:00:00 AM | 12 | 3X3 | 6015698.56805 | 2097858.21385 | 37.741200749075105 | -122.38829196576599 | (37.7412007490751, -122.388291965766) | ||
| 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) | |||
| 131151 | 131151 | 182112 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2459 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5987955.245 | 2098571.9757 | 37.7415842472625 | -122.484269637726 | (37.7415842472625, -122.484269637726) | |||
| 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) | |||
| 155363 | 155363 | 224295 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 5 Powhattan Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 56 | Width 3ft | 6007477.43589 | 2098211.1030599996 | 37.7417107417539 | -122.416742776477 | (37.7417107417539, -122.416742776477) | |||
| 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) | |||
| 134928 | 134928 | 185534 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2201 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984898.5449 | 2100072.3399 | 37.7455253871304 | -122.494949115857 | (37.7455253871304, -122.494949115857) | |||
| 157873 | 157873 | 191803 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 180x Bay Shore Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 6011162.1503800005 | 2099563.42906 | 37.7456304953456 | -122.404097342621 | (37.7456304953456, -122.404097342621) | ||||
| 146005 | 146005 | 191802 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 180x Bay Shore Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6011170.05761 | 2099578.4094700003 | 37.745672070114395 | -122.404071054532 | (37.7456720701144, -122.404071054532) | ||||
| 138115 | 138115 | 224299 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1413 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 5ft | 6003312.01278 | 2099871.95093 | 37.746035880956505 | -122.43126393889999 | (37.7460358809565, -122.4312639389) | |||
| 136930 | 136930 | 224292 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3888 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6004641.37531 | 2100769.79857 | 37.748576409973296 | -122.426731103972 | (37.7485764099733, -122.426731103972) | |||
| 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) | |||
| 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) | |||
| 189076 | 189076 | 224298 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 470 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6000648.58117 | 2101290.67644 | 37.749780062602206 | -122.440575450118 | (37.7497800626022, -122.440575450118) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 123215 | 123215 | 39152 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1201 Guerrero St | 1 | 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) | ||
| 145943 | 145943 | 39151 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1201 Guerrero St | 3 | 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) | ||
| 184067 | 184067 | 191795 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2250 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6012108.91907 | 2101904.50228 | 37.7521114309111 | -122.400987997805 | (37.7521114309111, -122.400987997805) | ||||
| 181422 | 181422 | 209047 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 901 Noriega St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 5991111.79749 | 2103120.98949 | 37.754257946265795 | -122.47368722428301 | (37.7542579462658, -122.473687224283) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");