Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31 | 31 | 22614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.781365013820206 | -122.424863625752 | (37.7813650138202, -122.424863625752) | |||
85 | 85 | 22613 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005358.7073 | 2112686.5825 | 37.7813375942673 | -122.42509837168001 | (37.7813375942673, -122.42509837168) | |||
1909 | 1909 | 125218 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101 Washington St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 13 | Width 4ft | 6005090.35688 | 2116771.11072 | 37.7925375271472 | -122.42631763077499 | (37.7925375271472, -122.426317630775) | |||
8575 | 8575 | 22617 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/25/1997 12:00:00 AM | 6 | 3x5 | 6005634.7978 | 2112724.8918 | 37.781458374599794 | -122.424145957729 | (37.7814583745998, -122.424145957729) | ||
10993 | 10993 | 764 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.76418358274471 | -122.496433785178 | (37.7641835827447, -122.496433785178) | |||
79616 | 79616 | 24935 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
82591 | 82591 | 24927 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 36 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
83248 | 83248 | 24932 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/22/1996 12:00:00 AM | 18 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
88695 | 88695 | 104451 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2490X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
88826 | 88826 | 22610 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
91930 | 91930 | 113799 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 695x SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4x4 | 6008062.0 | 2103972.0 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | ||||
92561 | 92561 | 104449 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2490X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
93328 | 93328 | 24934 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/28/1999 12:00:00 AM | 24 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
95715 | 95715 | 20475 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1203X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
97092 | 97092 | 5467 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 600X Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||||
98214 | 98214 | 113797 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 695x SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4x4 | 6008062.0 | 2103972.0 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | ||||
101610 | 101610 | 20510 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1211X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
107042 | 107042 | 24929 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
113430 | 113430 | 24924 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2199X Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6001667.079621499 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | |||
117968 | 117968 | 5435 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004896.4850004995 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | |||
120636 | 120636 | 22615 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
121073 | 121073 | 113798 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 695x SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4x4 | 6008062.0 | 2103972.0 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | ||||
122322 | 122322 | 105909 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1864X 14TH AVE | 1 | Median : Yard 3 | Tree 1 | Rec/Park 3 | 14 | 5991829.0 | 2102804.0 | 37.7534290869332 | -122.47118388851999 | (37.7534290869332, -122.47118388852) | ||||
123025 | 123025 | 20477 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1203X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
126289 | 126289 | 22618 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
141366 | 141366 | 24933 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
142153 | 142153 | 113800 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 695x SHOTWELL ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4x4 | 6008062.0 | 2103972.0 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) |
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");