Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13300 | 13300 | 114607 | Undocumented 2 | Tree(s) :: 17 | 2399X 15TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | Permit Number 779471 | 5991654.0 | 2099150.0 | 37.7433860243849 | -122.471522828523 | (37.7433860243849, -122.471522828523) | |||
| 14192 | 14192 | 34922 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38517 | ||||||||||
| 14379 | 14379 | 48480 | Permitted Site 1 | Tree(s) :: 17 | 1 | Median : Cutout 11 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 14737 | 14737 | 34923 | Permitted Site 1 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38517 | ||||||||||
| 14847 | 14847 | 48470 | Permitted Site 1 | Tree(s) :: 17 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 14893 | 14893 | 97355 | Permitted Site 1 | Tree(s) :: 17 | 5 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 15211 | 15211 | 48477 | Permitted Site 1 | Tree(s) :: 17 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 15772 | 15772 | 34918 | Permitted Site 1 | Tree(s) :: 17 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38517 | ||||||||||
| 16044 | 16044 | 96231 | Permitted Site 1 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | ||||||||||||
| 16205 | 16205 | 48479 | Permitted Site 1 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 16282 | 16282 | 45663 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44359 | ||||||||||
| 16299 | 16299 | 34920 | Permitted Site 1 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38517 | ||||||||||
| 16395 | 16395 | 48487 | Permitted Site 1 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 16481 | 16481 | 112908 | Undocumented 2 | Tree(s) :: 17 | 1899X Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 16895 | 16895 | 97352 | Permitted Site 1 | Tree(s) :: 17 | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 16902 | 16902 | 203214 | Undocumented 2 | Tree(s) :: 17 | 603 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009653.0 | 2111431.0 | 37.778131708870504 | -122.410153484475 | (37.7781317088705, -122.410153484475) | ||||
| 16904 | 16904 | 203215 | Undocumented 2 | Tree(s) :: 17 | 603 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009653.0 | 2111431.0 | 37.778131708870504 | -122.410153484475 | (37.7781317088705, -122.410153484475) | ||||
| 17039 | 17039 | 97769 | Undocumented 2 | Tree(s) :: 17 | 362 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6007113.7 | 2105238.5 | 37.7609859097905 | -122.418498646119 | (37.7609859097905, -122.418498646119) | |||
| 17073 | 17073 | 112909 | Undocumented 2 | Tree(s) :: 17 | 1899X Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 17858 | 17858 | 121173 | Significant Tree 6 | Tree(s) :: 17 | 950 Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000333.0 | 2099683.0 | 37.7453477932295 | -122.44155138616101 | (37.7453477932295, -122.441551386161) | ||||
| 17986 | 17986 | 56452 | Permitted Site 1 | Tree(s) :: 17 | 1471 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5982761.8650167 | 2105117.76871339 | 37.759253411371205 | -122.50271069963001 | (37.7592534113712, -122.50271069963) | |||||
| 17989 | 17989 | 105356 | Undocumented 2 | Tree(s) :: 17 | 207-211 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006236.0 | 2101921.0 | 37.7518273734539 | -122.421298642673 | (37.7518273734539, -122.421298642673) | |||
| 18015 | 18015 | 88762 | Permitted Site 1 | Tree(s) :: 17 | 3972 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51683 | 6003154.0 | 2105365.0 | 37.7611095365426 | -122.43220254549801 | (37.7611095365426, -122.432202545498) | |||
| 18076 | 18076 | 107933 | DPW Maintained 3 | Tree(s) :: 17 | 3098X Market St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5999920.0 | 2105144.0 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | |||||
| 18394 | 18394 | 105211 | Permitted Site 1 | Tree(s) :: 17 | 223 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 11471 | 6001117.0 | 2104982.0 | 37.759942207163796 | -122.439220183407 | (37.7599422071638, -122.439220183407) | |||
| 18486 | 18486 | 106393 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 18642 | 18642 | 106966 | Undocumented 2 | Tree(s) :: 17 | 2391 47TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981720.8 | 2098834.4 | 37.7419398125124 | -122.505845312535 | (37.7419398125124, -122.505845312535) | ||||||
| 18842 | 18842 | 56690 | Permitted Site 1 | Tree(s) :: 17 | 55 Hallam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010204.858571201 | 2110471.70826771 | 37.775528634854496 | -122.408176723323 | (37.7755286348545, -122.408176723323) | |||||
| 18845 | 18845 | 56735 | Permitted Site 1 | Tree(s) :: 17 | 4601 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015154.58866017 | 2096112.48595754 | 37.736377180995206 | -122.39005094503901 | (37.7363771809952, -122.390050945039) | |||||
| 18922 | 18922 | 100994 | Undocumented 2 | Tree(s) :: 17 | 1675 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009464.0 | 2106858.0 | 37.7655647195855 | -122.410484311247 | (37.7655647195855, -122.410484311247) | ||||
| 19065 | 19065 | 99574 | Undocumented 2 | Tree(s) :: 17 | 650X Brunswick St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
| 19360 | 19360 | 105328 | Significant Tree 6 | Tree(s) :: 17 | 2051 03rd St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 771015 | 6015779.9 | 2106081.5 | 37.7637846705736 | -122.388584622631 | (37.7637846705736, -122.388584622631) | ||||
| 19505 | 19505 | 56567 | Permitted Site 1 | Tree(s) :: 17 | 309 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992136.3013071995 | 2094883.62123857 | 37.731699516032904 | -122.46954466154499 | (37.7316995160329, -122.469544661545) | |||||
| 19599 | 19599 | 106501 | Undocumented 2 | Tree(s) :: 17 | 1266 09TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5993358.0 | 2106830.8 | 37.764573953722 | -122.46618893715001 | (37.764573953722, -122.46618893715) | |||||
| 19603 | 19603 | 56564 | Permitted Site 1 | Tree(s) :: 17 | 250 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992102.77849477 | 2095182.39763056 | 37.7325179438205 | -122.46968229865699 | (37.7325179438205, -122.469682298657) | |||||
| 20862 | 20862 | 116132 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 20908 | 20908 | 100993 | Undocumented 2 | Tree(s) :: 17 | 1675 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009464.0 | 2106858.0 | 37.7655647195855 | -122.410484311247 | (37.7655647195855, -122.410484311247) | ||||
| 21195 | 21195 | 116310 | Undocumented 2 | Tree(s) :: 17 | 1599X Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6001671.10835 | 2113777.6056 | 37.7841242646501 | -122.43793380735399 | (37.7841242646501, -122.437933807354) | |||||
| 22306 | 22306 | 203218 | DPW Maintained 3 | Tree(s) :: 17 | 865x Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5997430.0 | 2091537.0 | 37.722815009603295 | -122.451002133856 | (37.7228150096033, -122.451002133856) | ||||
| 23155 | 23155 | 543 | DPW Maintained 3 | Tree(s) :: 17 | 2871 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6009625.4825 | 2102172.3236 | 37.7527079631855 | -122.409595033175 | (37.7527079631855, -122.409595033175) | |||
| 23938 | 23938 | 248425 | Undocumented 2 | Tree(s) :: 17 | 731 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998544.0431 | 2108064.7106 | 37.7682598065536 | -122.448340749888 | (37.7682598065536, -122.448340749888) | |||
| 24012 | 24012 | 184369 | Undocumented 2 | Tree(s) :: 17 | 2246 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981440.3419 | 2099772.3553 | 37.7444986652432 | -122.50688458626699 | (37.7444986652432, -122.506884586267) | |||
| 24522 | 24522 | 251177 | Undocumented 2 | Tree(s) :: 17 | 178 Bluxome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6012557.0 | 2110038.0 | 37.7744691941496 | -122.400009583897 | (37.7744691941496, -122.400009583897) | ||||
| 25334 | 25334 | 248306 | Undocumented 2 | Tree(s) :: 17 | 2445 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009304.6458 | 2106837.3362 | 37.7654990466844 | -122.411034024362 | (37.7654990466844, -122.411034024362) | |||
| 25407 | 25407 | 95032 | Tree(s) :: 17 | 211 Maynard St | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 6004772.0 | 2093802.0 | 37.729451797878205 | -122.425783519869 | (37.7294517978782, -122.425783519869) | |||||||
| 25896 | 25896 | 248494 | Undocumented 2 | Tree(s) :: 17 | 757 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5997598.3079 | 2107875.2909999997 | 37.7676855940341 | -122.45159827426501 | (37.7676855940341, -122.451598274265) | |||
| 27147 | 27147 | 181826 | Undocumented 2 | Tree(s) :: 17 | 2306 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986108.4772 | 2099513.8036 | 37.744062551154705 | -122.490724327749 | (37.7440625511547, -122.490724327749) | |||
| 28912 | 28912 | 100611 | Permitted Site 1 | Tree(s) :: 17 | 401X Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | |||||
| 29187 | 29187 | 184866 | Undocumented 2 | Tree(s) :: 17 | 1201 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984637.6691 | 2106828.2325 | 37.7640599223867 | -122.496349569481 | (37.7640599223867, -122.496349569481) | |||
| 29729 | 29729 | 181810 | Undocumented 2 | Tree(s) :: 17 | 2311 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5987920.8952 | 2099549.8455 | 37.744267219356395 | -122.484460112778 | (37.7442672193564, -122.484460112778) | |||
| 30765 | 30765 | 181792 | Undocumented 2 | Tree(s) :: 17 | 1337 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986228.617000001 | 2098198.358 | 37.740457706632 | -122.490212173345 | (37.740457706632, -122.490212173345) | |||
| 31711 | 31711 | 182932 | Undocumented 2 | Tree(s) :: 17 | 2647 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5982109.6852 | 2097079.7047 | 37.737144783675 | -122.504370733656 | (37.737144783675, -122.504370733656) | |||
| 32175 | 32175 | 183211 | Undocumented 2 | Tree(s) :: 17 | 2201 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5982626.7574 | 2100094.3318 | 37.7454525198404 | -122.50280610050699 | (37.7454525198404, -122.502806100507) | |||
| 33644 | 33644 | 246232 | Undocumented 2 | Tree(s) :: 17 | 110 Frederick St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999396.2041 | 2107735.5354 | 37.767404657023505 | -122.445369547591 | (37.7674046570235, -122.445369547591) | |||
| 34303 | 34303 | 105305 | Permitted Site 1 | Tree(s) :: 17 | 2200 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770181 | 6003396.4 | 2107048.0 | 37.7657443893248 | -122.431484339518 | (37.7657443893248, -122.431484339518) | |||
| 34918 | 34918 | 138791 | Undocumented 2 | Tree(s) :: 17 | 2520 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6000487.1483 | 2114138.3099 | 37.785047267117704 | -122.442055772364 | (37.7850472671177, -122.442055772364) | |||
| 35896 | 35896 | 142112 | Undocumented 2 | Tree(s) :: 17 | 33 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998605.4598 | 2110962.5015 | 37.776219910665105 | -122.44833701705 | (37.7762199106651, -122.44833701705) | |||
| 37399 | 37399 | 38430 | Permitted Site 1 | Tree(s) :: 17 | 200 Dorado Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 40458 | 5994627.21829039 | 2092807.09536405 | 37.7261415269154 | -122.460782687965 | (37.7261415269154, -122.460782687965) | ||||
| 37496 | 37496 | 183179 | Undocumented 2 | Tree(s) :: 17 | 2400 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984268.9269 | 2098791.9181 | 37.7419728200296 | -122.49703171133999 | (37.7419728200296, -122.49703171134) | |||
| 37693 | 37693 | 248557 | Undocumented 2 | Tree(s) :: 17 | 137 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997345.4456 | 2107752.4938 | 37.7673339403594 | -122.452464026369 | (37.7673339403594, -122.452464026369) | |||
| 38125 | 38125 | 181361 | Undocumented 2 | Tree(s) :: 17 | 2125 Rivera St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5986542.2796 | 2100252.4532 | 37.746116016151795 | -122.489278654419 | (37.7461160161518, -122.489278654419) | |||
| 38335 | 38335 | 49383 | Permitted Site 1 | Tree(s) :: 17 | 522Walbridge Carter St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46344 | 6005268.88409545 | 2086363.71271864 | 37.7090559366076 | -122.423537125807 | (37.7090559366076, -122.423537125807) | ||||
| 38895 | 38895 | 181647 | Undocumented 2 | Tree(s) :: 17 | 1810 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5990056.3621 | 2106554.5578 | 37.763624424605 | -122.47758809713899 | (37.763624424605, -122.477588097139) | |||
| 39230 | 39230 | 182566 | Undocumented 2 | Tree(s) :: 17 | 2483 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988890.9813 | 2098452.8512 | 37.7413116024246 | -122.481025496381 | (37.7413116024246, -122.481025496381) | |||
| 42252 | 42252 | 184463 | Undocumented 2 | Tree(s) :: 17 | 2149 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981371.9257 | 2100438.3719 | 37.746323331453205 | -122.507170550739 | (37.7463233314532, -122.507170550739) | |||
| 42981 | 42981 | 106868 | Undocumented 2 | Tree(s) :: 17 | 1956 GREAT HWY | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5981193.7 | 2101737.6 | 37.749880147789895 | -122.507883225183 | (37.7498801477899, -122.507883225183) | ||||||
| 43169 | 43169 | 115209 | Undocumented 2 | Tree(s) :: 17 | 115 SPRUCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | Permit Number 777466 | 5997012.0 | 2115902.0 | 37.789691238035395 | -122.454206054029 | (37.7896912380354, -122.454206054029) | ||
| 43170 | 43170 | 100638 | Permitted Site 1 | Tree(s) :: 17 | 401X Clementina St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | |||||
| 44271 | 44271 | 183442 | Undocumented 2 | Tree(s) :: 17 | 2444 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989549.5958 | 2098742.2388 | 37.742144449418795 | -122.47876942417601 | (37.7421444494188, -122.478769424176) | |||
| 44576 | 44576 | 110632 | Undocumented 2 | Tree(s) :: 17 | 1051X Mandalay Ln | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 5991736.200759999 | 2101819.33429 | 37.7507200830769 | -122.47143306251002 | (37.7507200830769, -122.47143306251) | |||||
| 45343 | 45343 | 100644 | Permitted Site 1 | Tree(s) :: 17 | 401X Clementina St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | |||||
| 45607 | 45607 | 56736 | Permitted Site 1 | Tree(s) :: 17 | 2100 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992602.18859707 | 2101147.35229749 | 37.7489250523556 | -122.468389545401 | (37.7489250523556, -122.468389545401) | |||||
| 46487 | 46487 | 182999 | Undocumented 2 | Tree(s) :: 17 | 2309 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988850.1732 | 2098290.3442 | 37.7408630283555 | -122.481154698143 | (37.7408630283555, -122.481154698143) | |||
| 46488 | 46488 | 245431 | Undocumented 2 | Tree(s) :: 17 | 2400 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009345.194 | 2106891.7791 | 37.765650808121 | -122.410897622285 | (37.765650808121, -122.410897622285) | |||
| 46599 | 46599 | 97073 | DPW Maintained 3 | Tree(s) :: 17 | 1551 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | ||
| 46710 | 46710 | 246411 | Undocumented 2 | Tree(s) :: 17 | 22 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998217.2905 | 2108458.9941 | 37.769323722170796 | -122.449499363561 | (37.7693237221708, -122.449499363561) | |||
| 48053 | 48053 | 183443 | Undocumented 2 | Tree(s) :: 17 | 2444 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989551.5745 | 2098710.5787 | 37.7420576339149 | -122.47876026756201 | (37.7420576339149, -122.478760267562) | |||
| 48159 | 48159 | 183155 | Undocumented 2 | Tree(s) :: 17 | 2322 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981458.7309 | 2099250.8498 | 37.7430678392852 | -122.50678232868299 | (37.7430678392852, -122.506782328683) | |||
| 48260 | 48260 | 244096 | Undocumented 2 | Tree(s) :: 17 | 416 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997487.1651 | 2108993.3495 | 37.7707491304172 | -122.452063378018 | (37.7707491304172, -122.452063378018) | |||
| 48435 | 48435 | 180595 | Undocumented 2 | Tree(s) :: 17 | 438 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009775.03095 | 2092351.37985 | 37.725750154132704 | -122.408385202211 | (37.7257501541327, -122.408385202211) | |||
| 48952 | 48952 | 187233 | Undocumented 2 | Tree(s) :: 17 | 2401 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984955.1932 | 2098637.2484 | 37.7415883305025 | -122.494647457647 | (37.7415883305025, -122.494647457647) | |||
| 49116 | 49116 | 100598 | Permitted Site 1 | Tree(s) :: 17 | 401x Clementina St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | |||||
| 49727 | 49727 | 244223 | Undocumented 2 | Tree(s) :: 17 | 1830 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997801.2012 | 2108901.6698 | 37.7705153847611 | -122.45097051473302 | (37.7705153847611, -122.450970514733) | |||
| 49956 | 49956 | 109525 | Permitted Site 1 | Tree(s) :: 17 | 1550 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5991168.8 | 2098442.9 | 37.74141642762039 | -122.47314895277201 | (37.7414164276204, -122.473148952772) | |||||
| 50343 | 50343 | 184817 | Undocumented 2 | Tree(s) :: 17 | 1201 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984676.4005 | 2106956.7675 | 37.764415112141 | -122.496225095071 | (37.764415112141, -122.496225095071) | |||
| 50449 | 50449 | 242820 | Undocumented 2 | Tree(s) :: 17 | 37 Poppy Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 2ft | 6002456.61791 | 2096763.3951400002 | 37.7374519967974 | -122.4339996118 | (37.7374519967974, -122.4339996118) | |||
| 51269 | 51269 | 141554 | Undocumented 2 | Tree(s) :: 17 | 54 Chabot Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997753.8599 | 2111369.0927 | 37.7772875804111 | -122.45131224982201 | (37.7772875804111, -122.451312249822) | |||
| 51320 | 51320 | 103300 | Undocumented 2 | Tree(s) :: 17 | 3240 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007996.9 | 2100607.8 | 37.748320741451 | -122.415116245427 | (37.748320741451, -122.415116245427) | ||||
| 51433 | 51433 | 102891 | Undocumented 2 | Tree(s) :: 17 | 115 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008968.0 | 2112966.0 | 37.7823080347026 | -122.41263169632201 | (37.7823080347026, -122.412631696322) | ||||
| 51723 | 51723 | 138054 | Undocumented 2 | Tree(s) :: 17 | 1801 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003424.569 | 2114942.6734 | 37.787422803486294 | -122.431950687727 | (37.7874228034863, -122.431950687727) | |||
| 51947 | 51947 | 137784 | Undocumented 2 | Tree(s) :: 17 | 2160 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999172.8862 | 2111524.455 | 37.777795314951604 | -122.44641457841601 | (37.7777953149516, -122.446414578416) | |||
| 52919 | 52919 | 105706 | Permitted Site 1 | Tree(s) :: 17 | 260 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 771166 | 6003936.4 | 2097769.3 | 37.7402978504485 | -122.42895500726002 | (37.7402978504485, -122.42895500726) | |||
| 53653 | 53653 | 247275 | Undocumented 2 | Tree(s) :: 17 | 1665 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999077.5213 | 2109368.3030000003 | 37.771869626177896 | -122.44658930936701 | (37.7718696261779, -122.446589309367) | |||
| 53920 | 53920 | 183680 | Undocumented 2 | Tree(s) :: 17 | 1315 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982728.5996 | 2106143.6537 | 37.7620682453033 | -122.502901690129 | (37.7620682453033, -122.502901690129) | |||
| 54374 | 54374 | 183137 | Undocumented 2 | Tree(s) :: 17 | 3515 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5981958.3374 | 2099418.2679 | 37.7435569304689 | -122.505067258282 | (37.7435569304689, -122.505067258282) | |||
| 55125 | 55125 | 244874 | Undocumented 2 | Tree(s) :: 17 | 1303 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000283.9747 | 2109200.4937 | 37.7714777032527 | -122.442404064945 | (37.7714777032527, -122.442404064945) | |||
| 58715 | 58715 | 56640 | Permitted Site 1 | Tree(s) :: 17 | 2016 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004277.89575757 | 2115357.17634953 | 37.7886092629589 | -122.429027916831 | (37.7886092629589, -122.429027916831) | |||||
| 59267 | 59267 | 245110 | Undocumented 2 | Tree(s) :: 17 | 135 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 6000770.1938 | 2109453.5749 | 37.772200302029205 | -122.44074036886002 | (37.7722003020292, -122.44074036886) | |||
| 60990 | 60990 | 182927 | Undocumented 2 | Tree(s) :: 17 | 2639 44th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5982723.7516 | 2097156.0189 | 37.737390419431705 | -122.502253307981 | (37.7373904194317, -122.502253307981) | |||
| 61150 | 61150 | 102859 | Undocumented 2 | Tree(s) :: 17 | 696 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009251.0 | 2115330.0 | 37.7888148901218 | -122.411819735773 | (37.7888148901218, -122.411819735773) |
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");