Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, qCareAssistant, PlantDate, DBH, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 360 | 360 | 6307 | DPW Maintained 3 | Tristania conferta :: 79 | 1804 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6002139.3488 | 2112974.3616 | 37.781945376326 | -122.436256362281 | (37.781945376326, -122.436256362281) | |||
| 5959 | 5959 | 23753 | DPW Maintained 3 | Tristania conferta :: 79 | 900X Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1992 12:00:00 AM | 25 | 4x4 | 6003923.4316 | 2112087.5817 | 37.7796117041387 | -122.43002098071501 | (37.7796117041387, -122.430020980715) | ||
| 6447 | 6447 | 9761 | Permitted Site 1 | Tristania conferta :: 79 | 745 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1997 12:00:00 AM | 8 | 4x4 | 6005736.7899 | 2112320.9115 | 37.7803549018091 | -122.423764380812 | (37.7803549018091, -122.423764380812) | ||
| 7255 | 7255 | 9753 | DPW Maintained 3 | Tristania conferta :: 79 | 725 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/1990 12:00:00 AM | 16 | 4x4 | 6005752.1131 | 2112212.6104 | 37.780058398475106 | -122.423703668106 | (37.7800583984751, -122.423703668106) | ||
| 7923 | 7923 | 12350 | DPW Maintained 3 | Tristania conferta :: 79 | 1280 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/1997 12:00:00 AM | 3 | 4x4 | 6004697.5402 | 2113177.8166 | 37.782649030091704 | -122.42742069293699 | (37.7826490300917, -122.427420692937) | ||
| 8453 | 8453 | 6306 | DPW Maintained 3 | Tristania conferta :: 79 | 1804 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6002160.6694 | 2112978.761 | 37.7819586673159 | -122.436182917866 | (37.7819586673159, -122.436182917866) | |||
| 8543 | 8543 | 9758 | DPW Maintained 3 | Tristania conferta :: 79 | 735 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/1997 12:00:00 AM | 18 | 4x4 | 6005747.9577 | 2112242.2179 | 37.78013945886 | -122.423720149275 | (37.78013945886, -122.423720149275) | ||
| 13604 | 13604 | 28836 | Permitted Site 1 | Tristania conferta :: 79 | 1501 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016976.7304 | 2093554.8023 | 37.729455180200794 | -122.383572968876 | (37.7294551802008, -122.383572968876) | ||
| 14144 | 14144 | 28832 | Permitted Site 1 | Tristania conferta :: 79 | 1500 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016972.3335 | 2093632.2976 | 37.7296677240114 | -122.383593562534 | (37.7296677240114, -122.383593562534) | ||
| 14603 | 14603 | 28837 | DPW Maintained 3 | Tristania conferta :: 79 | 1527 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/2005 12:00:00 AM | 6 | 4x4 | 6016961.8909 | 2093534.4666 | 37.7293985221539 | -122.38362285575701 | (37.7293985221539, -122.383622855757) | ||
| 15437 | 15437 | 28833 | Permitted Site 1 | Tristania conferta :: 79 | 1500 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016963.5397 | 2093616.3588 | 37.729623473146894 | -122.383622854715 | (37.7296234731469, -122.383622854715) | ||
| 16422 | 16422 | 28834 | Permitted Site 1 | Tristania conferta :: 79 | 1500 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2005 12:00:00 AM | 16 | 4x4 | 6016954.1963 | 2093605.3666 | 37.7295927742855 | -122.38365439115499 | (37.7295927742855, -122.383654391155) | ||
| 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) | |||
| 49649 | 49649 | 121011 | Undocumented 2 | Tristania conferta :: 79 | 199X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6015164.1782 | 2115507.7051 | 37.7896327822139 | -122.391373228803 | (37.7896327822139, -122.391373228803) | |||
| 58276 | 58276 | 122823 | Permitted Site 1 | Tristania conferta :: 79 | 1736 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 4x4 | 6010043.2132 | 2120098.5684 | 37.8019526289989 | -122.409415446027 | (37.8019526289989, -122.409415446027) | ||
| 63705 | 63705 | 121008 | Undocumented 2 | Tristania conferta :: 79 | 199X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6015113.794 | 2115458.3492 | 37.789494465808204 | -122.391544102374 | (37.7894944658082, -122.391544102374) | |||
| 68021 | 68021 | 121007 | Undocumented 2 | Tristania conferta :: 79 | 199X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6015091.1726 | 2115438.8125 | 37.789439566894295 | -122.391621004116 | (37.7894395668943, -122.391621004116) | |||
| 69366 | 69366 | 93014 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001021.4146 | 2119265.9756 | 37.7991569323377 | -122.440575294128 | (37.7991569323377, -122.440575294128) |
| 135929 | 135929 | 121010 | Undocumented 2 | Tristania conferta :: 79 | 199X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6015151.8392 | 2115494.3379 | 37.78959539413329 | -122.391414985971 | (37.7895953941333, -122.391414985971) | |||
| 162998 | 162998 | 93016 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; Tree #1 on the Scott St frontage | 6000962.9097 | 2119261.1002 | 37.7991402141254 | -122.440777390622 | (37.7991402141254, -122.440777390622) | |
| 171968 | 171968 | 93015 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001036.8533 | 2119267.6007 | 37.7991622735558 | -122.440521987709 | (37.7991622735558, -122.440521987709) |
| 171974 | 171974 | 121009 | Undocumented 2 | Tristania conferta :: 79 | 199X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6015134.359 | 2115477.8859 | 37.7895492505351 | -122.391474315503 | (37.7895492505351, -122.391474315503) | |||
| 177734 | 177734 | 121012 | Undocumented 2 | Tristania conferta :: 79 | 199X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x4 | 6015178.5737 | 2115521.0723 | 37.7896702844128 | -122.39132435625099 | (37.7896702844128, -122.391324356251) |
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");