Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
121915 | 121915 | 19284 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1998 12:00:00 AM | 9 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.43816511087601 | (37.786078645055, -122.438165110876) | ||
55919 | 55919 | 31468 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 523 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 9 | Permit Number 35034 | 6002955.92893 | 2102097.8639599998 | 37.752127528763204 | -122.432654202633 | (37.7521275287632, -122.432654202633) | |
154995 | 154995 | 32348 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 9 | Permit Number 37068 | 5985188.5725 | 2106987.4184 | 37.764529258945 | -122.49445591941799 | (37.764529258945, -122.494455919418) | |
168115 | 168115 | 34234 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 475 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1997 12:00:00 AM | 9 | Permit Number 38047 | 6009059.1086 | 2121116.8197 | 37.8046933049163 | -122.41289295806801 | (37.8046933049163, -122.412892958068) | ||
168067 | 168067 | 38049 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2700 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2005 12:00:00 AM | 9 | Permit Number 47797 | 6000509.1373 | 2114490.0048 | 37.78601418351771 | -122.44200495026199 | (37.7860141835177, -122.442004950262) | |
40082 | 40082 | 38526 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3031 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/1998 12:00:00 AM | 9 | Permit Number 40508 | 6001945.50794 | 2118614.30712 | 37.797420199240996 | -122.437330933595 | (37.797420199241, -122.437330933595) | ||
3793 | 3793 | 39226 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 770 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 9 | Permit Number 40869 | 5984798.64138 | 2110605.0729799997 | 37.774439483359 | -122.49607147975 | (37.774439483359, -122.49607147975) | ||
180473 | 180473 | 40818 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | 9 | Permit Number 41760 | 6001596.2583 | 2114468.8718 | 37.786018048063 | -122.438242299207 | (37.786018048063, -122.438242299207) | ||
150848 | 150848 | 42651 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1924 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 9 | Permit Number 42691 | 6004339.89147 | 2118073.8812599997 | 37.7960721541703 | -122.42900719184799 | (37.7960721541703, -122.429007191848) | |
75943 | 75943 | 44033 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 230 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/02/2000 12:00:00 AM | 9 | Permit Number 43569 | 5998819.8857 | 2109894.1205 | 37.7732986671632 | -122.447518341015 | (37.7732986671632, -122.447518341015) | |
40232 | 40232 | 50534 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1853 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | 9 | Permit Number 47173 | 6004174.32371 | 2118346.10209 | 37.7968102295769 | -122.42959951321899 | (37.7968102295769, -122.429599513219) | ||
51120 | 51120 | 66858 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 103 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1991 12:00:00 AM | 9 | Permit Number 30164 | 5998644.5770000005 | 2110362.2819 | 37.774574098301294 | -122.448158471707 | (37.7745740983013, -122.448158471707) | ||
130712 | 130712 | 67547 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1125 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 9 | Permit Number 31093 | 6011962.71401 | 2103154.98207 | 37.75553681818771 | -122.40158148021798 | (37.7555368181877, -122.401581480218) | |
149037 | 149037 | 70299 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 237 Theresa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 9 | 6001826.3531599995 | 2094025.88285 | 37.7298996296434 | -122.435982902906 | (37.7298996296434, -122.435982902906) | ||
167511 | 167511 | 103887 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5999387.5565 | 2110861.3404 | 37.7759868308232 | -122.44562426468201 | (37.7759868308232, -122.445624264682) | |||
50236 | 50236 | 103891 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5999322.5796 | 2110851.5262 | 37.7759561736689 | -122.445848329979 | (37.7759561736689, -122.445848329979) | |||
136845 | 136845 | 124750 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 566 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004650.035 | 2110687.35997 | 37.775808163060205 | -122.42740756863 | (37.7758081630602, -122.42740756863) | |||
2515 | 2515 | 124752 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2478 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | 9 | Width 5ft | 6002956.6534 | 2115870.86114 | 37.7899448329366 | -122.433635939447 | (37.7899448329366, -122.433635939447) | ||
34990 | 34990 | 124760 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1055 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007817.3795 | 2119902.3991900003 | 37.8012890341312 | -122.417103992782 | (37.8012890341312, -122.417103992782) | |||
187692 | 187692 | 138344 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001758.896000001 | 2114311.2519 | 37.785594512870205 | -122.43766832543301 | (37.7855945128702, -122.437668325433) | |||
188012 | 188012 | 138353 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001742.4732 | 2114607.6747 | 37.786407480206705 | -122.43774638091499 | (37.7864074802067, -122.437746380915) | |||
156262 | 156262 | 140103 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1720 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999438.9967 | 2110868.4473 | 37.776009281241 | -122.44544683133002 | (37.776009281241, -122.44544683133) | |||
74240 | 74240 | 141691 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996753.535 | 2112367.4021 | 37.7799713474759 | -122.45484482437 | (37.7799713474759, -122.45484482437) | |||
75611 | 75611 | 182146 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1690 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5989681.6149 | 2103872.2722 | 37.756237834999 | -122.478688039412 | (37.756237834999, -122.478688039412) | |||
68064 | 68064 | 188520 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 495 Connecticut St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013272.40757 | 2104812.59187 | 37.7601612472551 | -122.397168349564 | (37.7601612472551, -122.397168349564) | |||
61286 | 61286 | 203225 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1575 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5993973.71625 | 2104850.02282 | 37.759170760036994 | -122.463915566851 | (37.759170760037, -122.463915566851) | |||
66468 | 66468 | 203632 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1400 Monterey Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5993831.29855 | 2094857.6984 | 37.7317261536347 | -122.463682879865 | (37.7317261536347, -122.463682879865) | |||
35427 | 35427 | 203633 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 458 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997727.849830001 | 2094119.15999 | 37.7299220605503 | -122.45015856377199 | (37.7299220605503, -122.450158563772) | |||
183501 | 183501 | 203636 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 418 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997970.50252 | 2094115.71728 | 37.7299264906074 | -122.449319440552 | (37.7299264906074, -122.449319440552) | |||
165659 | 165659 | 203641 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 608 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5992400.09934 | 2090515.7050700001 | 37.7197215370907 | -122.468315017932 | (37.7197215370907, -122.468315017932) | |||
179419 | 179419 | 203660 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998582.52704 | 2094910.5588200002 | 37.732143927389295 | -122.44726079165399 | (37.7321439273893, -122.447260791654) | |||
146004 | 146004 | 203662 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 337 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5999398.70847 | 2094267.55477 | 37.7304249920009 | -122.44439288782301 | (37.7304249920009, -122.444392887823) | |||
61594 | 61594 | 203663 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 271 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5998288.8054599995 | 2093783.09686 | 37.7290313953773 | -122.44819509282699 | (37.7290313953773, -122.448195092827) | |||
30832 | 30832 | 203666 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 123 Detroit St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5999405.93855 | 2093561.74161 | 37.728487406244604 | -122.44431719010001 | (37.7284874062446, -122.4443171901) | |||
152367 | 152367 | 219998 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005981.24616 | 2097649.7003900004 | 37.7400849896219 | -122.421876240696 | (37.7400849896219, -122.421876240696) | |||
185200 | 185200 | 220017 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 78 Berkeley Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001185.230140001 | 2097348.08527 | 37.7389851844145 | -122.438437264296 | (37.7389851844145, -122.438437264296) | |||
37289 | 37289 | 220029 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4107 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6002428.99773 | 2102359.29201 | 37.7528154507744 | -122.434495098689 | (37.7528154507744, -122.434495098689) | |||
48265 | 48265 | 220667 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1337 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007176.0273400005 | 2107716.44116 | 37.767793265562894 | -122.41845879174801 | (37.7677932655629, -122.418458791748) | |||
188761 | 188761 | 220670 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 948 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009928.95694 | 2103687.06035 | 37.7568840925314 | -122.408652407882 | (37.7568840925314, -122.408652407882) | |||
157007 | 157007 | 220696 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 407 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998482.20862 | 2106820.01065 | 37.764838640103505 | -122.44846497847799 | (37.7648386401035, -122.448464978478) | |||
24822 | 24822 | 250192 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011786.88966 | 2119947.0785 | 37.8016342173021 | -122.403370805543 | (37.8016342173021, -122.403370805543) |
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");