Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18608 | 18608 | 24390 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 501X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 6 | 3 | 5991485.44871 | 2094112.7680400002 | 37.7295453093597 | -122.471738611958 | (37.7295453093597, -122.471738611958) | ||
19844 | 19844 | 27797 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 3 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
27174 | 27174 | 24392 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/21/1995 12:00:00 AM | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
32415 | 32415 | 11719 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
78605 | 78605 | 11658 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
80752 | 80752 | 24398 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/01/2000 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
81627 | 81627 | 11762 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3X3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | |||
81957 | 81957 | 87701 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 8 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | |||
83233 | 83233 | 28848 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
84989 | 84989 | 24399 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/15/1995 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
86056 | 86056 | 11659 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
86430 | 86430 | 11785 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
86583 | 86583 | 11688 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
88676 | 88676 | 11697 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/21/1995 12:00:00 AM | 6 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
89108 | 89108 | 27799 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/08/2005 12:00:00 AM | 3 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
90084 | 90084 | 24402 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/01/2000 12:00:00 AM | 6 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
91670 | 91670 | 11699 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
92392 | 92392 | 24401 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 12 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
93707 | 93707 | 11654 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
95471 | 95471 | 24391 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/21/1995 12:00:00 AM | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
96335 | 96335 | 107866 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 ALEMANY BLVD | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | PUC 13 | 15 | 3x3 | 6008820.4 | 2095497.5 | 37.734335221774394 | -122.411907523711 | (37.7343352217744, -122.411907523711) | |||
96556 | 96556 | 24460 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 6 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
103241 | 103241 | 11760 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3x3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | |||
105506 | 105506 | 11693 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
105606 | 105606 | 11715 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/15/1995 12:00:00 AM | 12 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
108860 | 108860 | 24456 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
109059 | 109059 | 11648 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/28/2000 12:00:00 AM | 3 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
109450 | 109450 | 24400 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/15/1995 12:00:00 AM | 6 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
110250 | 110250 | 24414 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
115573 | 115573 | 24395 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 6 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
117628 | 117628 | 27826 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/08/2005 12:00:00 AM | 3 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
117787 | 117787 | 24405 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/28/2000 12:00:00 AM | 12 | 3X3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
122590 | 122590 | 11691 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 9 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
123921 | 123921 | 24406 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/28/2000 12:00:00 AM | 6 | 3x3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
124190 | 124190 | 11727 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/15/1995 12:00:00 AM | 12 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
125704 | 125704 | 11772 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
125742 | 125742 | 24458 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 6 | 3X3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
127364 | 127364 | 11720 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
127942 | 127942 | 24412 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
141005 | 141005 | 11653 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
142712 | 142712 | 11790 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
143977 | 143977 | 11717 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/08/2005 12:00:00 AM | 3 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
144393 | 144393 | 11724 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 12 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
144673 | 144673 | 26172 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
145860 | 145860 | 24413 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 6 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) |
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");