Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18024 | 18024 | 28732 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/20/2005 12:00:00 AM | 12 | 3X3 | 6014623.837937901 | 2099253.7018787 | 37.7449728593106 | -122.39210559674801 | (37.7449728593106, -122.392105596748) | ||
| 39824 | 39824 | 43966 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 08/20/2005 12:00:00 AM | 9 | Permit Number 43534 | 6006884.39072 | 2112892.55093 | 37.781989200774206 | -122.41983486151199 | (37.7819892007742, -122.419834861512) | |
| 55707 | 55707 | 49807 | Permitted Site 1 | Punica granatum 'Wonderfu :: Pomegranate Tree 'Wonderful' 415 | 1164SSIPPI 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 8 | Permit Number 46601 | 6014115.89861 | 2105750.2163400003 | 37.7627826810847 | -122.394316741417 | (37.7627826810847, -122.394316741417) | |
| 60100 | 60100 | 83227 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 495 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 10 | 6013273.66902 | 2104798.74295 | 37.7601232913798 | -122.39716301566901 | (37.7601232913798, -122.397163015669) | ||
| 70411 | 70411 | 41218 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 21 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 5 | Permit Number 41926 | 6001937.22199 | 2119965.3728 | 37.8011293999489 | -122.43745640431001 | (37.8011293999489, -122.43745640431) | |
| 76062 | 76062 | 55242 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 176 Escolta Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 2 | Permit Number 11162 | 5986318.2122 | 2097305.7128 | 37.7380119721821 | -122.489836759019 | (37.7380119721821, -122.489836759019) | |
| 78971 | 78971 | 51607 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 5 | 3x3 | Permit Number 47904 | 5997656.30420255 | 2107807.08178851 | 37.7675016300781 | -122.45139275313 | (37.7675016300781, -122.45139275313) |
| 87270 | 87270 | 55694 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 363 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | Permit Number 11694 | 6006373.17544696 | 2097816.81324545 | 37.740565939404 | -122.42053296632099 | (37.740565939404, -122.420532966321) | ||
| 89252 | 89252 | 46665 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | Permit Number 44795 | 5991766.74524672 | 2105883.15111577 | 37.76188002503589 | -122.471623544222 | (37.7618800250359, -122.471623544222) | ||
| 99141 | 99141 | 48647 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1534 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | Permit Number 45940 | 5992159.363292 | 2105015.93223513 | 37.7595215776755 | -122.47020249278299 | (37.7595215776755, -122.470202492783) | ||
| 100216 | 100216 | 36253 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | Permit Number 39270 | 5991200.33310514 | 2094436.30103714 | 37.7304171492597 | -122.472747856373 | (37.7304171492597, -122.472747856373) | ||
| 104276 | 104276 | 36254 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Elmhurst Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | Permit Number 39270 | 5991200.33310514 | 2094436.30103714 | 37.7304171492597 | -122.472747856373 | (37.7304171492597, -122.472747856373) | ||
| 104897 | 104897 | 68897 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4541 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | Permit Number 32870 | 6000815.36583091 | 2105190.20249489 | 37.7604967113228 | -122.440278318326 | (37.7604967113228, -122.440278318326) | ||
| 106694 | 106694 | 33517 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 148 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2005 12:00:00 AM | Permit Number 48274 | 6007365.58443644 | 2098215.69549509 | 37.741717059847495 | -122.41712984786601 | (37.7417170598475, -122.417129847866) | |||
| 116346 | 116346 | 51680 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 10X Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47961 | 6001415.38816785 | 2088105.22450821 | 37.7136194817396 | -122.43697994924999 | (37.7136194817396, -122.43697994925) |
| 124146 | 124146 | 83176 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3301 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 6 | 3x3 | 5985317.61354 | 2111082.30707 | 37.77578021552279 | -122.494311467187 | (37.7757802155228, -122.494311467187) | |
| 140143 | 140143 | 65650 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 44 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | Permit Number 31225 | 5997164.61598032 | 2099286.96726852 | 37.7440793635931 | -122.452478506879 | (37.7440793635931, -122.452478506879) | ||
| 140283 | 140283 | 51681 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 10X Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 5 | 9x12 | Permit Number 47961 | 6001415.38816785 | 2088105.22450821 | 37.7136194817396 | -122.43697994924999 | (37.7136194817396, -122.43697994925) |
| 147720 | 147720 | 42134 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 450 Connecticut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 7 | 6x4 | Permit Number 42430 | 6013207.160130001 | 2104921.81 | 37.760457503722 | -122.397401670553 | (37.760457503722, -122.397401670553) |
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");