Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1099 | 1099 | 250070 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 1 | : 4 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005393.47416 | 2115303.0126799997 | 37.788523627097 | -122.425164323999 | (37.788523627097, -122.425164323999) | |||
7458 | 7458 | 18926 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 2689 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001985.03027 | 2115691.49541 | 37.7893971628975 | -122.43698481780599 | (37.7893971628975, -122.436984817806) | |||
17640 | 17640 | 4490 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1602 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2002 12:00:00 AM | 3 | 3X3 | 6004561.8284 | 2099527.9975 | 37.7451622129677 | -122.426917747467 | (37.7451622129677, -122.426917747467) | ||
18805 | 18805 | 27714 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001610.45471 | 2097108.7336400002 | 37.7383521588292 | -122.436949905209 | (37.7383521588292, -122.436949905209) | |||
22608 | 22608 | 9889 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1700 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005347.08674 | 2115527.81747 | 37.78913826426621 | -122.425340821331 | (37.7891382642662, -122.425340821331) | |||
22656 | 22656 | 17785 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1798X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005398.04469 | 2115519.90556 | 37.7891194189645 | -122.42516394985701 | (37.7891194189645, -122.425163949857) | |||
22706 | 22706 | 7127 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005701.71486 | 2115022.2576200003 | 37.7877701517306 | -122.424077883603 | (37.7877701517306, -122.424077883603) | ||
30666 | 30666 | 189167 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1300x De Haro St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012264.80612 | 2102152.7525400002 | 37.7528017667079 | -122.40046634965 | (37.7528017667079, -122.40046634965) | ||||
44709 | 44709 | 125485 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6007640.9414 | 2118138.07584 | 37.796434716745 | -122.417589429708 | (37.796434716745, -122.417589429708) | ||||
60904 | 60904 | 16944 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 599X Oak St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 20 | 3x3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
80299 | 80299 | 28777 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
80980 | 80980 | 27672 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
81629 | 81629 | 27670 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
90024 | 90024 | 27668 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
90399 | 90399 | 27665 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.42375144816299 | (37.7888072668978, -122.423751448163) | |||
92549 | 92549 | 27666 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.42375144816299 | (37.7888072668978, -122.423751448163) | |||
94446 | 94446 | 27669 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
95583 | 95583 | 24521 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
100083 | 100083 | 8408 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1570 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1999 12:00:00 AM | 3 | 3X3 | 6004211.027185 | 2114032.026709 | 37.7849669496355 | -122.42916474711001 | (37.7849669496355, -122.42916474711) | ||
103041 | 103041 | 16943 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 599X Oak St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3x3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
104455 | 104455 | 24519 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
110335 | 110335 | 24520 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
111562 | 111562 | 27667 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.42375144816299 | (37.7888072668978, -122.423751448163) | |||
115405 | 115405 | 24518 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
118715 | 118715 | 27671 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
120146 | 120146 | 16406 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
121821 | 121821 | 17031 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1160X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001440.12949 | 2109757.61689 | 37.7730732545652 | -122.43844479592501 | (37.7730732545652, -122.438444795925) | |||
122812 | 122812 | 16907 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 452 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004778.478730001 | 2110233.49325 | 37.774569219476206 | -122.426930917012 | (37.7745692194762, -122.426930917012) | |||
123607 | 123607 | 16942 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 599X Oak St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 3x3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
127147 | 127147 | 17018 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1048 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001982.80486 | 2109858.7796099996 | 37.7733818753695 | -122.436574858617 | (37.7733818753695, -122.436574858617) | ||
143787 | 143787 | 16405 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
164866 | 164866 | 125484 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6007648.69076 | 2118115.73393 | 37.796373807471 | -122.41756103092699 | (37.796373807471, -122.417561030927) | ||||
174163 | 174163 | 125486 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6007645.270330001 | 2118136.8198 | 37.7964315115565 | -122.417574361577 | (37.7964315115565, -122.417574361577) | ||||
183680 | 183680 | 189166 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1300x De Haro St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012257.93832 | 2102144.48011 | 37.752778669414 | -122.40048951886999 | (37.752778669414, -122.40048951887) |
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");