Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30285 | 30285 | 237226 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5997960.11385 | 2106796.79092 | 37.764745019783795 | -122.450269087756 | (37.7647450197838, -122.450269087756) | |||
33962 | 33962 | 41935 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 639 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 15 | Permit Number 42294 | 5994689.00791 | 2111165.50547 | 37.7765526175284 | -122.461899718162 | (37.7765526175284, -122.461899718162) | |
38249 | 38249 | 64864 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Parsons St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 15 | Permit Number 25882 | 5996577.342130001 | 2110690.66447 | 37.775357357934205 | -122.45533313851999 | (37.7753573579342, -122.45533313852) | |
39983 | 39983 | 237104 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3445 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6005914.842069999 | 2106060.03243 | 37.763174080447 | -122.42270336159201 | (37.763174080447, -122.422703361592) | |||
47504 | 47504 | 213455 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5993130.50239 | 2099670.13691 | 37.744899496712996 | -122.466455299074 | (37.744899496713, -122.466455299074) | |||
50046 | 50046 | 238442 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 77 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002582.7882900005 | 2108738.36652 | 37.77033957454611 | -122.434419311908 | (37.7703395745461, -122.434419311908) | |||
53799 | 53799 | 178967 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 505 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5999517.95201 | 2086983.4986400001 | 37.7104314441356 | -122.44345762526899 | (37.7104314441356, -122.443457625269) | |||
58275 | 58275 | 237306 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6008859.53771 | 2097948.3487400003 | 37.741066915300294 | -122.411945347518 | (37.7410669153003, -122.411945347518) | |||
69055 | 69055 | 239532 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007362.80754 | 2097682.06201 | 37.7402516645702 | -122.41710164643801 | (37.7402516645702, -122.417101646438) | |||
72088 | 72088 | 238396 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2221 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002719.76824 | 2107072.27368 | 37.7657726661007 | -122.43382639609301 | (37.7657726661007, -122.433826396093) | |||
75236 | 75236 | 31704 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 445 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 15 | Permit Number 35206 | 5997671.58785 | 2107448.25781 | 37.7665172660868 | -122.45131400735399 | (37.7665172660868, -122.451314007354) | |
105452 | 105452 | 37342 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 507 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 15 | Permit Number 39850 | 5999504.92576 | 2086983.7691900001 | 37.71043144412221 | -122.44350266602801 | (37.7104314441222, -122.443502666028) | |
109429 | 109429 | 44108 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 701 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2014 12:00:00 AM | 15 | 5x4 | Permit Number 770977 | 6002352.33429439 | 2108791.12474046 | 37.770471351578 | -122.435220225203 | (37.770471351578, -122.435220225203) | |
122716 | 122716 | 105428 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 701 WALLER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2014 12:00:00 AM | 15 | 5x4 | Permit Number 770977 | 6002351.0 | 2108797.0 | 37.7704874078199 | -122.435225260833 | (37.7704874078199, -122.435225260833) | |
132301 | 132301 | 238087 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 175 Montcalm St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6010138.47184 | 2099734.59131 | 37.7460432194236 | -122.407649151187 | (37.7460432194236, -122.407649151187) | |||
132539 | 132539 | 238118 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3031 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009170.72177 | 2104485.60836 | 37.759034228575395 | -122.41133108897199 | (37.7590342285754, -122.411331088972) | |||
143295 | 143295 | 107126 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1234 DIAMOND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6001925.9 | 2100390.5 | 37.747381044490794 | -122.43609402678601 | (37.7473810444908, -122.436094026786) | |||
153897 | 153897 | 238367 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 576 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002585.786069999 | 2103875.52386 | 37.756987560447 | -122.43406127383498 | (37.756987560447, -122.434061273835) | |||
156052 | 156052 | 237437 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1633 Diamond St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6002067.17233 | 2099257.65655 | 37.7442785481133 | -122.435524488761 | (37.7442785481133, -122.435524488761) | |||
156571 | 156571 | 238095 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 728 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009056.8841 | 2104842.92268 | 37.7600089470684 | -122.411750042628 | (37.7600089470684, -122.411750042628) | |||
160155 | 160155 | 238106 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 149 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006183.4276 | 2102112.77314 | 37.7523509743301 | -122.421494063899 | (37.7523509743301, -122.421494063899) | |||
165958 | 165958 | 66569 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 36 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 15 | Permit Number 29758 | 6005069.72782 | 2093317.4329799998 | 37.728138104176004 | -122.424719787291 | (37.728138104176, -122.424719787291) | |
166967 | 166967 | 238160 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 510 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001812.305240001 | 2102784.3558400003 | 37.7539475479549 | -122.43665815437001 | (37.7539475479549, -122.43665815437) | |||
169365 | 169365 | 135959 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2980 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5999366.62942 | 2117378.52806 | 37.793880135816 | -122.446165554106 | (37.793880135816, -122.446165554106) | |||
181369 | 181369 | 31513 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2513 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 15 | Permit Number 35071 | 6011012.0661 | 2102261.56789 | 37.7530306081845 | -122.40480623683399 | (37.7530306081845, -122.404806236834) | |
181976 | 181976 | 136014 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Havens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6007575.68988 | 2119392.2209400004 | 37.7998746136871 | -122.417904161874 | (37.7998746136871, -122.417904161874) | |||
182766 | 182766 | 239486 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 607 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007458.88842 | 2096087.3313 | 37.7358782902335 | -122.41665649281799 | (37.7358782902335, -122.416656492818) | |||
187377 | 187377 | 196498 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 649 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6012784.03099 | 2111475.7584 | 37.7784296058662 | -122.399325187321 | (37.7784296058662, -122.399325187321) |
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");