Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
466 | 466 | 1665 | DPW Maintained 3 | Tristania conferta :: 79 | 1400X Fell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1992 12:00:00 AM | 18 | 3X3 | 6000409.8977 | 2109962.9335 | 37.7735783473195 | -122.44202322778901 | (37.7735783473195, -122.442023227789) | ||
984 | 984 | 24262 | DPW Maintained 3 | Tristania conferta :: 79 | 600X Willow St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2004 12:00:00 AM | 3 | 3X3 | 6004514.0905 | 2113119.5269 | 37.7824786038336 | -122.428051195433 | (37.7824786038336, -122.428051195433) | ||
5943 | 5943 | 9604 | Permitted Site 1 | Tristania conferta :: 79 | 1355 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003125.8375 | 2112021.5623 | 37.7793852280154 | -122.432775482637 | (37.7793852280154, -122.432775482637) | |||
7596 | 7596 | 21601 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005314.151000001 | 2114757.5524 | 37.7870214478079 | -122.42539993758999 | (37.7870214478079, -122.42539993759) | |||
8442 | 8442 | 6187 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005423.3129 | 2113433.3911 | 37.783391795987 | -122.424928016493 | (37.783391795987, -122.424928016493) | |||
8818 | 8818 | 6201 | DPW Maintained 3 | Tristania conferta :: 79 | 1135 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005283.7179 | 2113361.2024 | 37.783185697693604 | -122.42540582178002 | (37.7831856976936, -122.42540582178) | |||
13571 | 13571 | 29433 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2011 12:00:00 AM | 3 | 3x3 | 6015500.9632 | 2091579.7516 | 37.7239504043026 | -122.388537076537 | (37.7239504043026, -122.388537076537) | ||
13647 | 13647 | 30096 | Permitted Site 1 | Tristania conferta :: 79 | 6190X 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2011 12:00:00 AM | 6 | 3x3 | 6013417.4786 | 2091122.0564 | 37.722577983662504 | -122.395707348923 | (37.7225779836625, -122.395707348923) | ||
13890 | 13890 | 29426 | Permitted Site 1 | Tristania conferta :: 79 | 2501X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6015353.5854 | 2091384.7495 | 37.723406798628 | -122.389032933904 | (37.723406798628, -122.389032933904) | ||
14076 | 14076 | 22397 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1995 12:00:00 AM | 6 | 3X3 | 6013870.7534 | 2092308.3783 | 37.7258605897355 | -122.39422348311399 | (37.7258605897355, -122.394223483114) | ||
14358 | 14358 | 22405 | DPW Maintained 3 | Tristania conferta :: 79 | 5800 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/1992 12:00:00 AM | 5 | 3X3 | 6013773.1583 | 2092062.8244 | 37.7251809229772 | -122.394543678104 | (37.7251809229772, -122.394543678104) | ||
14553 | 14553 | 29440 | Permitted Site 1 | Tristania conferta :: 79 | 2301X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015660.6839 | 2091799.6156 | 37.7245629575419 | -122.38800027789101 | (37.7245629575419, -122.388000277891) | ||
15923 | 15923 | 29386 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014271.9163 | 2089934.5554 | 37.719364835170396 | -122.392670694873 | (37.7193648351704, -122.392670694873) | ||
18909 | 18909 | 6905 | Permitted Site 1 | Tristania conferta :: 79 | 333 Fell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6005791.8208 | 2110660.0754 | 37.775797756638205 | -122.42345589675699 | (37.7757977566382, -122.423455896757) | |||
19213 | 19213 | 15287 | DPW Maintained 3 | Tristania conferta :: 79 | 1600 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007004.1044 | 2109328.3326 | 37.7722094576916 | -122.41916780485 | (37.7722094576916, -122.41916780485) | ||
30658 | 30658 | 140638 | Undocumented 2 | Tristania conferta :: 79 | 472 Stanyan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5996864.7991 | 2109972.3061 | 37.7734014220919 | -122.45428686398199 | (37.7734014220919, -122.454286863982) | |||
34727 | 34727 | 200931 | Undocumented 2 | Tristania conferta :: 79 | 4101 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015563.8928 | 2097421.6465 | 37.7399945612986 | -122.388727159879 | (37.7399945612986, -122.388727159879) | |||
43857 | 43857 | 200669 | Undocumented 2 | Tristania conferta :: 79 | 1589 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6015338.0615 | 2095574.9021 | 37.7349112589219 | -122.38937906760201 | (37.7349112589219, -122.389379067602) | |||
50978 | 50978 | 138229 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998536.6795 | 2112630.6942 | 37.7807964033341 | -122.448695125032 | (37.7807964033341, -122.448695125032) | |||
55422 | 55422 | 142796 | Undocumented 2 | Tristania conferta :: 79 | 533 Larkin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6007561.1357 | 2113189.4218 | 37.782842437698896 | -122.417514674644 | (37.7828424376989, -122.417514674644) | |||
67479 | 67479 | 139806 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6005650.9929 | 2112934.249 | 37.7820341324354 | -122.424104823616 | (37.7820341324354, -122.424104823616) | |||
72699 | 72699 | 199800 | Undocumented 2 | Tristania conferta :: 79 | 2655 Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015155.3655 | 2091117.0238 | 37.7226606870185 | -122.389699459103 | (37.7226606870185, -122.389699459103) | |||
72896 | 72896 | 139932 | Undocumented 2 | Tristania conferta :: 79 | 800 GOUGH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005703.8894 | 2112554.5236 | 37.7809944860981 | -122.42389481563299 | (37.7809944860981, -122.423894815633) | |||
121378 | 121378 | 99007 | DPW Maintained 3 | Tristania conferta :: 79 | 2099X Beach St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.803316837922104 | -122.442899765771 | (37.8033168379221, -122.442899765771) | ||
132029 | 132029 | 95309 | Permitted Site 1 | Tristania conferta :: 79 | 5411 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6014280.8379999995 | 2093157.5675 | 37.728215078157604 | -122.392865222605 | (37.7282150781576, -122.392865222605) | |||
150721 | 150721 | 95600 | Undocumented 2 | Tristania conferta :: 79 | 1625 Carroll Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6014023.4144 | 2092013.9314 | 37.725060582122104 | -122.393675141136 | (37.7250605821221, -122.393675141136) | |||
152121 | 152121 | 200963 | Undocumented 2 | Tristania conferta :: 79 | 5600 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6013968.5894 | 2092562.3664 | 37.7265634275491 | -122.39390303961599 | (37.7265634275491, -122.393903039616) | |||
156891 | 156891 | 137780 | Undocumented 2 | Tristania conferta :: 79 | 1773 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001115.5375 | 2111737.5615 | 37.7784912146937 | -122.439709572654 | (37.7784912146937, -122.439709572654) | |||
160475 | 160475 | 246311 | Undocumented 2 | Tristania conferta :: 79 | 1601 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6007089.8834 | 2109370.8451 | 37.772331017243 | -122.41887410287201 | (37.772331017243, -122.418874102872) | |||
160708 | 160708 | 140352 | Undocumented 2 | Tristania conferta :: 79 | 1314 ELLIS ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004399.7686 | 2113290.1868 | 37.7829407248934 | -122.428458867439 | (37.7829407248934, -122.428458867439) | |||
161209 | 161209 | 200991 | Undocumented 2 | Tristania conferta :: 79 | 75 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015446.9463 | 2115775.0495 | 37.7903825381625 | -122.39041355919201 | (37.7903825381625, -122.390413559192) | |||
167448 | 167448 | 200913 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015728.5157 | 2097971.7279 | 37.7415140947501 | -122.388196336709 | (37.7415140947501, -122.388196336709) | |||
176512 | 176512 | 143432 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010753.9601 | 2116917.9148 | 37.793259124815705 | -122.406731631165 | (37.7932591248157, -122.406731631165) | |||
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");