Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3666 | 3666 | 21602 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005338.1501 | 2114762.148 | 37.7870354220648 | -122.425317233161 | (37.7870354220648, -122.425317233161) | |||
| 4692 | 4692 | 6906 | DPW Maintained 3 | Tristania conferta :: 79 | 333 Fell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2017 09:59:00 AM | 3 | 3X3 | 6005816.7808 | 2110662.8487 | 37.7758067801978 | -122.423369750882 | (37.7758067801978, -122.423369750882) | ||
| 6685 | 6685 | 6188 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005406.4851 | 2113431.574 | 37.783385856152 | -122.42498610479299 | (37.783385856152, -122.424986104793) | |||
| 7714 | 7714 | 14450 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 5998930.2641 | 2112586.1918 | 37.7806967093816 | -122.44733032611299 | (37.7806967093816, -122.447330326113) | |||
| 13376 | 13376 | 22408 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53653 | 6013764.0013 | 2092044.0283 | 37.7251288035961 | -122.394574017561 | (37.7251288035961, -122.394574017561) | |
| 13508 | 13508 | 29427 | DPW Maintained 3 | Tristania conferta :: 79 | 2501X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015373.5361 | 2091407.2745 | 37.7234697537221 | -122.38896553930401 | (37.7234697537221, -122.388965539304) | ||
| 15369 | 15369 | 22443 | Permitted Site 1 | Tristania conferta :: 79 | 6025 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6013664.0377 | 2091536.7496 | 37.7237303604467 | -122.39488407213601 | (37.7237303604467, -122.394884072136) | |||
| 15576 | 15576 | 95306 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013860.6324 | 2092285.2447 | 37.7257965069575 | -122.39425685203001 | (37.7257965069575, -122.39425685203) | |||
| 23010 | 23010 | 15288 | DPW Maintained 3 | Tristania conferta :: 79 | 1600 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/12/1995 12:00:00 AM | 8 | 3X3 | 6006995.5283 | 2109306.0347 | 37.772147749991795 | -122.419195888407 | (37.7721477499918, -122.419195888407) | ||
| 25880 | 25880 | 121013 | Undocumented 2 | Tristania conferta :: 79 | 199X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6015189.8844 | 2115534.4395 | 37.78970761539271 | -122.39128615684099 | (37.7897076153927, -122.391286156841) | |||
| 30584 | 30584 | 142354 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6005306.3187 | 2113367.185 | 37.7832034013247 | -122.42532805791599 | (37.7832034013247, -122.425328057916) | |||
| 41164 | 41164 | 141932 | Undocumented 2 | Tristania conferta :: 79 | 1050 MCALLISTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004095.7926 | 2111864.1542 | 37.7790079875659 | -122.42940877227899 | (37.7790079875659, -122.429408772279) | |||
| 50365 | 50365 | 139231 | Undocumented 2 | Tristania conferta :: 79 | 1401 WEBSTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003635.3387 | 2113448.027 | 37.7833308271099 | -122.43111474669901 | (37.7833308271099, -122.431114746699) | |||
| 59094 | 59094 | 95310 | Permitted Site 1 | Tristania conferta :: 79 | 5411 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6014289.9952 | 2093175.8818 | 37.728265874158 | -122.392834846305 | (37.728265874158, -122.392834846305) | |||
| 60493 | 60493 | 138227 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998554.9543 | 2112632.7248 | 37.7808030238066 | -122.448632050181 | (37.7808030238066, -122.448632050181) | |||
| 68784 | 68784 | 184807 | Undocumented 2 | Tristania conferta :: 79 | 1251 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5984672.982999999 | 2106530.3427 | 37.7632440693949 | -122.49620545091001 | (37.7632440693949, -122.49620545091) | |||
| 76025 | 76025 | 139807 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005654.4625 | 2112912.0434 | 37.78197335721 | -122.424091240716 | (37.78197335721, -122.424091240716) | |||
| 135255 | 135255 | 200670 | Undocumented 2 | Tristania conferta :: 79 | 1587 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6015353.4507 | 2095562.261 | 37.734877402221606 | -122.389324978833 | (37.7348774022216, -122.389324978833) | |||
| 150708 | 150708 | 139732 | Undocumented 2 | Tristania conferta :: 79 | 1191 Gough St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6005537.4624 | 2113723.1591 | 37.784193874402206 | -122.42455372244301 | (37.7841938744022, -122.424553722443) | |||
| 155395 | 155395 | 200964 | Undocumented 2 | Tristania conferta :: 79 | 5600 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6013957.0226 | 2092532.4854 | 37.7264807375175 | -122.393940935112 | (37.7264807375175, -122.393940935112) | |||
| 160363 | 160363 | 200992 | Undocumented 2 | Tristania conferta :: 79 | 75 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6015461.3418 | 2115791.5015 | 37.7904285101106 | -122.39036490128599 | (37.7904285101106, -122.390364901286) | |||
| 163138 | 163138 | 200932 | Undocumented 2 | Tristania conferta :: 79 | 4101 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015570.0337 | 2097446.6824 | 37.740063645101294 | -122.38870767425699 | (37.7400636451013, -122.388707674257) | |||
| 163264 | 163264 | 246313 | Undocumented 2 | Tristania conferta :: 79 | 1655 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6007004.876 | 2109202.9434 | 37.771865212234005 | -122.41915623997 | (37.771865212234, -122.41915623997) | |||
| 172375 | 172375 | 140639 | Undocumented 2 | Tristania conferta :: 79 | 468 Stanyan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5996860.5832 | 2109999.5178 | 37.7734758965802 | -122.454303413235 | (37.7734758965802, -122.454303413235) | |||
| 182734 | 182734 | 143433 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010770.5411 | 2116920.4657 | 37.7932670566772 | -122.406674439368 | (37.7932670566772, -122.406674439368) |
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");