Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlantDate, PlotSize, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
131 | 131 | 237033 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 7 | : 4 | Tree 1 | DPW 2 | 6 | Width 4ft | 6005718.98472 | 2109769.85153 | 37.7733493059578 | -122.423644547079 | (37.7733493059578, -122.423644547079) | |||
4328 | 4328 | 28085 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2255 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6002770.4091 | 2114749.1272 | 37.786854268374796 | -122.43420010239201 | (37.7868542683748, -122.434200102392) | |||
8875 | 8875 | 2624 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1822 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004615.6699 | 2115060.0567 | 37.7878125608959 | -122.427838089219 | (37.7878125608959, -122.427838089219) | |||
11481 | 11481 | 28255 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3476 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2003 12:00:00 AM | 6 | 3x3 | 6012058.005419999 | 2089554.66958 | 37.7181985388057 | -122.400296740219 | (37.7181985388057, -122.400296740219) | ||
12793 | 12793 | 13368 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 900 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X50 | 6009218.46856 | 2090025.7710400003 | 37.719333336630896 | -122.410145089137 | (37.7193333366309, -122.410145089137) | |||
18995 | 18995 | 19331 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/05/2000 12:00:00 AM | 6 | 3x3 | 5993203.76699 | 2089824.45321 | 37.7178699121392 | -122.465486857851 | (37.7178699121392, -122.465486857851) | ||
19308 | 19308 | 4173 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3807X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/1995 12:00:00 AM | 6 | 3X3 | 6005111.29038 | 2100461.84082 | 37.7477573856943 | -122.42508423394301 | (37.7477573856943, -122.425084233943) | ||
20721 | 20721 | 10215 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1335 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/24/2000 12:00:00 AM | 6 | 3X3 | 6005858.33864 | 2101181.45988 | 37.749775467064 | -122.42255210370199 | (37.749775467064, -122.422552103702) | ||
21265 | 21265 | 27509 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1335 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/24/2000 12:00:00 AM | 6 | 3X3 | 6005856.94451 | 2101204.3999 | 37.749838376446206 | -122.42255855456001 | (37.7498383764462, -122.42255855456) | ||
22029 | 22029 | 25409 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3763-3767 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 6 | 3x3 | 6005453.81691 | 2100480.39517 | 37.7478276749239 | -122.42390111285 | (37.7478276749239, -122.42390111285) | ||
83473 | 83473 | 14411 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2001X Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/2001 12:00:00 AM | 6 | 3X3 | 6009024.63169 | 2120105.21371 | 37.801913752234704 | -122.41294070113399 | (37.8019137522347, -122.412940701134) | ||
88204 | 88204 | 14623 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Matthew Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018016.8978124 | 2094239.2837711999 | 37.7313920698281 | -122.38002451510201 | (37.7313920698281, -122.380024515102) | ||
92706 | 92706 | 4122 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3435 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6006760.09222 | 2100373.98133 | 37.7476091457032 | -122.419376518884 | (37.7476091457032, -122.419376518884) | ||
95273 | 95273 | 4120 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3435 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6006760.09222 | 2100373.98133 | 37.7476091457032 | -122.419376518884 | (37.7476091457032, -122.419376518884) | ||
97015 | 97015 | 10703 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130X Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5993684.4832438 | 2089860.5757616002 | 37.717996809726 | -122.46382786766 | (37.717996809726, -122.46382786766) | |||
103844 | 103844 | 23488 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/09/2004 12:00:00 AM | 6 | 9 | 6005837.0202043 | 2118942.4447679003 | 37.79854163961021 | -122.42388861727899 | (37.7985416396102, -122.423888617279) | ||
105042 | 105042 | 94562 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 251X OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6005545.0 | 2110135.0 | 37.774342092866995 | -122.424272360307 | (37.774342092867, -122.424272360307) | |||
110120 | 110120 | 101655 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200X Vasquez Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994672.4771300005 | 2099264.801 | 37.7438754024487 | -122.461094099214 | (37.7438754024487, -122.461094099214) | |||
113062 | 113062 | 4198 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3885X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6004619.1213 | 2100435.76727 | 37.7476579790206 | -122.42678427332199 | (37.7476579790206, -122.426784273322) | ||
114197 | 114197 | 11071 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1769 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6007332.0 | 2118349.0 | 37.7969964730533 | -122.418673401001 | (37.7969964730533, -122.418673401001) | |||
116783 | 116783 | 14410 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2001X Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/2001 12:00:00 AM | 6 | 3X3 | 6009024.63169 | 2120105.21371 | 37.801913752234704 | -122.41294070113399 | (37.8019137522347, -122.412940701134) | ||
120512 | 120512 | 23489 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/09/2004 12:00:00 AM | 6 | 9 | 6005837.0202043 | 2118942.4447679003 | 37.79854163961021 | -122.42388861727899 | (37.7985416396102, -122.423888617279) | ||
124893 | 124893 | 29668 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500 Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/09/2004 12:00:00 AM | 6 | 6005837.0202043 | 2118942.4447679003 | 37.79854163961021 | -122.42388861727899 | (37.7985416396102, -122.423888617279) | |||
126683 | 126683 | 10217 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1351 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2002 12:00:00 AM | 6 | 3X3 | 6005868.4867153 | 2101104.801102 | 37.7495655521395 | -122.422511564697 | (37.7495655521395, -122.422511564697) | ||
141655 | 141655 | 1576 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 605 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1999 12:00:00 AM | 6 | 3x3 | 5995596.544419999 | 2112077.2508400003 | 37.779108233448 | -122.45882633362 | (37.779108233448, -122.45882633362) | ||
145234 | 145234 | 14624 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Matthew Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018000.3078284 | 2094247.4364445 | 37.7314135402286 | -122.38008243669701 | (37.7314135402286, -122.380082436697) |
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");