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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 164978 | 164978 | 246941 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 269 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5998752.122880001 | 2107600.5740099996 | 37.7669972990085 | -122.447587610674 | (37.7669972990085, -122.447587610674) | |||
| 164901 | 164901 | 230299 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 590 York St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009785.6882 | 2105558.56974 | 37.762014809365 | -122.409279952113 | (37.762014809365, -122.409279952113) | |||
| 164626 | 164626 | 230310 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 322 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005451.16912 | 2101791.33905 | 37.7514270756131 | -122.424003479091 | (37.7514270756131, -122.424003479091) | |||
| 164563 | 164563 | 61691 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 61 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 4 | Permit Number 31258 | 6014147.06906 | 2093799.2682599998 | 37.7299696274983 | -122.393372558494 | (37.7299696274983, -122.393372558494) | |
| 164298 | 164298 | 66134 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3259 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 3 | Permit Number 768243 | 5999299.78945 | 2120070.84719 | 37.8012687076388 | -122.446590621369 | (37.8012687076388, -122.446590621369) | ||
| 163844 | 163844 | 123126 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 771 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992555.29457 | 2110202.5485900003 | 37.773785530078605 | -122.469210678659 | (37.7737855300786, -122.469210678659) | |||
| 161946 | 161946 | 193329 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1240 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015301.017030001 | 2102739.65572 | 37.7545821320765 | -122.390007483381 | (37.7545821320765, -122.390007483381) | |||
| 161945 | 161945 | 109493 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1246 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 6007532.32765 | 2115464.28758 | 37.789087043373996 | -122.417775637962 | (37.789087043374, -122.417775637962) | |||
| 161888 | 161888 | 217796 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 21 Sloat Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5991264.945169999 | 2095927.55542 | 37.7345154980788 | -122.472633170284 | (37.7345154980788, -122.472633170284) | |||
| 161788 | 161788 | 130997 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Leavenworth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6007578.93915 | 2119952.7888599997 | 37.8014139751467 | -122.417932677574 | (37.8014139751467, -122.417932677574) | |||
| 161633 | 161633 | 177444 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 15 Karen Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6010486.61044 | 2091547.46792 | 37.7235826018289 | -122.40586870937 | (37.7235826018289, -122.40586870937) | |||
| 161578 | 161578 | 230318 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 107 Valley St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6005160.92225 | 2099293.15868 | 37.744551255839795 | -122.424829478514 | (37.7445512558398, -122.424829478514) | |||
| 161500 | 161500 | 230295 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3500 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006165.1210199995 | 2104950.71502 | 37.7601422724637 | -122.42175893043199 | (37.7601422724637, -122.421758930432) | |||
| 161301 | 161301 | 230280 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201 Webster St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6004189.92363 | 2109488.51079 | 37.772490383253896 | -122.428913720795 | (37.7724903832539, -122.428913720795) | |||
| 161292 | 161292 | 230324 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 14 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004676.492190001 | 2103485.42894 | 37.7560348834086 | -122.426803038952 | (37.7560348834086, -122.426803038952) | |||
| 160936 | 160936 | 121810 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 106 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5989928.89895 | 2114601.72994 | 37.7857123459232 | -122.478617478776 | (37.7857123459232, -122.478617478776) | |||
| 160737 | 160737 | 193316 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 136 Hawthorne St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6013300.831040001 | 2113672.81478 | 37.784491007704396 | -122.39769151127301 | (37.7844910077044, -122.397691511273) | |||
| 160548 | 160548 | 177398 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 650 France Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6002590.58454 | 2089466.88592 | 37.7174250310079 | -122.433015275935 | (37.7174250310079, -122.433015275935) | |||
| 160542 | 160542 | 130984 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200 Beach St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 5999592.955130001 | 2120888.49408 | 37.803530487293 | -122.445634974783 | (37.803530487293, -122.445634974783) | |||
| 160433 | 160433 | 177442 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 67 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010267.21749 | 2091493.9064200001 | 37.723423260860706 | -122.40662334309799 | (37.7234232608607, -122.406623343098) | |||
| 160153 | 160153 | 193360 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 208 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014042.14131 | 2116274.34783 | 37.7916754675957 | -122.395309117238 | (37.7916754675957, -122.395309117238) | |||
| 159964 | 159964 | 193358 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 62 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014021.3474 | 2116423.46881 | 37.79208376250261 | -122.395391515812 | (37.7920837625026, -122.395391515812) | |||
| 159521 | 159521 | 120234 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 896 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5988543.40273 | 2109982.31108 | 37.7729481790861 | -122.48307213983601 | (37.7729481790861, -122.483072139836) | |||
| 158279 | 158279 | 124566 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3943 Sacramento St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5995914.73243 | 2114852.9465900003 | 37.7867478376308 | -122.457926519067 | (37.7867478376308, -122.457926519067) | |||
| 157255 | 157255 | 230354 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 531 30th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003165.5903900005 | 2098301.47872 | 37.7417154299181 | -122.431658143201 | (37.7417154299181, -122.431658143201) | |||
| 157233 | 157233 | 208838 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1450 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 5991176.37038 | 2105519.1814900003 | 37.7608464875004 | -122.47363884617799 | (37.7608464875004, -122.473638846178) | |||
| 156900 | 156900 | 102081 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 525 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52509 | 5991566.610309999 | 2111852.8346 | 37.778259586012204 | -122.472751014651 | (37.7782595860122, -122.472751014651) |
| 156758 | 156758 | 69419 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 168 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 9 | Permit Number 33524 | 6001328.44378 | 2087365.87339 | 37.7115844451475 | -122.437227553813 | (37.7115844451475, -122.437227553813) | |
| 156468 | 156468 | 230290 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 59 Ramona Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005216.74861 | 2107488.55744 | 37.76705705897071 | -122.425219491113 | (37.7670570589707, -122.425219491113) | |||
| 156259 | 156259 | 61491 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 178 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1990 12:00:00 AM | 3 | Permit Number 28869 | 5989634.7512 | 2114171.8446400003 | 37.784514919234205 | -122.47960366993601 | (37.7845149192342, -122.479603669936) | |
| 156067 | 156067 | 193372 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 61 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6013792.54079 | 2116244.01793 | 37.791578303941705 | -122.39617061288999 | (37.7915783039417, -122.39617061289) | |||
| 155904 | 155904 | 93189 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 651 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53197 | 5988441.61799 | 2111543.24899 | 37.77722815601879 | -122.483538678985 | (37.7772281560188, -122.483538678985) | |
| 155809 | 155809 | 193320 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2111 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6011400.26798 | 2105549.24377 | 37.762079528159795 | -122.403695060604 | (37.7620795281598, -122.403695060604) | |||
| 155510 | 155510 | 177423 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 270 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999939.77666 | 2092147.8586099998 | 37.7246356530907 | -122.44237022711701 | (37.7246356530907, -122.442370227117) | |||
| 155447 | 155447 | 118202 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 744 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5985103.04881 | 2110791.51915 | 37.774969236334 | -122.495032243047 | (37.774969236334, -122.495032243047) | |||
| 154873 | 154873 | 230319 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 119 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005056.96104 | 2098704.0891400003 | 37.7429279327818 | -122.425147048897 | (37.7429279327818, -122.425147048897) | |||
| 154138 | 154138 | 177445 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 15 Karen Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010506.33995 | 2091553.32971 | 37.723599800462296 | -122.405800920297 | (37.7235998004623, -122.405800920297) | |||
| 153849 | 153849 | 193344 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1133 19th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6014141.435 | 2105240.8231200003 | 37.761385417914205 | -122.394192754591 | (37.7613854179142, -122.394192754591) | |||
| 153672 | 153672 | 230305 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3689 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6005047.22841 | 2104845.66376 | 37.7597907229735 | -122.42561771539499 | (37.7597907229735, -122.425617715395) | |||
| 153633 | 153633 | 247755 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 52 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6001613.95356 | 2108514.35375 | 37.7696694492075 | -122.43775445760299 | (37.7696694492075, -122.437754457603) | |||
| 153587 | 153587 | 95071 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 319 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767740 | 5990554.377 | 2113243.49278 | 37.7820193005134 | -122.476354274932 | (37.7820193005134, -122.476354274932) | |
| 153491 | 153491 | 177399 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 908 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6003531.7567 | 2089652.07353 | 37.7179868563895 | -122.429775281212 | (37.7179868563895, -122.429775281212) | |||
| 153469 | 153469 | 131001 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 937 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007906.15602 | 2120261.72441 | 37.80228064460721 | -122.416822257668 | (37.8022806446072, -122.416822257668) | |||
| 153325 | 153325 | 43146 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 243 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774635 | 6005976.40354 | 2092622.5546099998 | 37.7262812865364 | -122.421536041574 | (37.7262812865364, -122.421536041574) | |
| 153254 | 153254 | 230343 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 65 Chenery St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004910.0558400005 | 2097921.66035 | 37.7407712613889 | -122.42559933235 | (37.7407712613889, -122.42559933235) | |||
| 153237 | 153237 | 50024 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1704 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 3 | Permit Number 46757 | 6005953.2164199995 | 2092396.45471 | 37.725659158041104 | -122.421600147046 | (37.7256591580411, -122.421600147046) | |
| 153057 | 153057 | 112790 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 20 Joice St | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 11 | 3x3 | 6010307.8181300005 | 2116296.03331 | 37.791526616311295 | -122.40823143793502 | (37.7915266163113, -122.408231437935) | |||
| 152854 | 152854 | 208839 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 131 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992959.48741 | 2098205.81206 | 37.74086896193 | -122.466940197353 | (37.74086896193, -122.466940197353) | |||
| 152466 | 152466 | 94730 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 418 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53862 | 5997217.67326 | 2114882.8026 | 37.7869045857318 | -122.45342083293001 | (37.7869045857318, -122.45342083293) |
| 151961 | 151961 | 177422 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 0 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6001061.39064 | 2091803.12496 | 37.7237529577069 | -122.438468271097 | (37.7237529577069, -122.438468271097) | |||
| 151949 | 151949 | 177427 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 145 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004319.85704 | 2094053.89798 | 37.7301178924245 | -122.427364559453 | (37.7301178924245, -122.427364559453) | |||
| 151933 | 151933 | 230309 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3668 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005328.964269999 | 2101978.057 | 37.7519328597144 | -122.424439358013 | (37.7519328597144, -122.424439358013) | |||
| 151893 | 151893 | 230300 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1225 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010064.03861 | 2101924.1335400003 | 37.7520510531386 | -122.408060919271 | (37.7520510531386, -122.408060919271) | |||
| 151720 | 151720 | 193376 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 778 Tehama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008940.991169999 | 2110196.43665 | 37.7747019546579 | -122.41252929798999 | (37.7747019546579, -122.41252929799) | |||
| 151066 | 151066 | 230349 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 222 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001969.40377 | 2096197.83075 | 37.735871425709995 | -122.43564368671801 | (37.73587142571, -122.435643686718) | |||
| 150941 | 150941 | 193359 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 208 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014052.912819999 | 2116289.5789400004 | 37.7917178877279 | -122.39527291503299 | (37.7917178877279, -122.395272915033) | |||
| 150867 | 150867 | 230315 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 131 Peralta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010141.9244099995 | 2100150.42012 | 37.7471851875523 | -122.407666527004 | (37.7471851875523, -122.407666527004) | |||
| 150105 | 150105 | 230317 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 609 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009667.55833 | 2100362.09801 | 37.74773984264029 | -122.40932179038799 | (37.7477398426403, -122.409321790388) | |||
| 149661 | 149661 | 95133 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 450@ Wayland Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2010 12:00:00 AM | 1 | 3x3 | Permit Number 54066 | 6010089.84133 | 2092358.2905700002 | 37.725786753837 | -122.407297408351 | (37.725786753837, -122.407297408351) | |
| 149654 | 149654 | 47068 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 604 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2012 12:00:00 AM | 1 | Permit Number 768780 | 6004042.80919 | 2110860.8938 | 37.7762502823647 | -122.429520495178 | (37.7762502823647, -122.429520495178) | ||
| 149083 | 149083 | 177440 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 71 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010238.57006 | 2091486.2001099999 | 37.7234004981218 | -122.406721829644 | (37.7234004981218, -122.406721829644) | |||
| 148594 | 148594 | 130972 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6002950.18497 | 2118317.4913 | 37.7966622830002 | -122.433833266913 | (37.7966622830002, -122.433833266913) | |||
| 148326 | 148326 | 208833 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1655 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990561.21502 | 2104064.77483 | 37.75681742851079 | -122.47566016868299 | (37.7568174285108, -122.475660168683) | |||
| 147958 | 147958 | 230335 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 823 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002473.18997 | 2103401.0764 | 37.7556784506177 | -122.434416752458 | (37.7556784506177, -122.434416752458) | |||
| 147780 | 147780 | 193338 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1270 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6015308.81376 | 2102546.1179299997 | 37.754051150748 | -122.389967001302 | (37.754051150748, -122.389967001302) | |||
| 147660 | 147660 | 230340 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 65 Chenery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004910.8116 | 2097869.74707 | 37.7406287620114 | -122.425593025396 | (37.7406287620114, -122.425593025396) | |||
| 147644 | 147644 | 230301 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1083 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010010.1738 | 2102926.1510900003 | 37.754799354323 | -122.40831786097999 | (37.754799354323, -122.40831786098) | |||
| 147335 | 147335 | 95762 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 417 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767499 | 6004100.3891199995 | 2090668.84671 | 37.720810876907 | -122.427882177716 | (37.720810876907, -122.427882177716) |
| 146771 | 146771 | 88351 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 700 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51333 | 6002622.22718 | 2089414.5665400003 | 37.7172831683531 | -122.432902166399 | (37.7172831683531, -122.432902166399) | |
| 146648 | 146648 | 230316 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 131 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010129.26175 | 2100145.52723 | 37.7471710439032 | -122.407709968747 | (37.7471710439032, -122.407709968747) | |||
| 146559 | 146559 | 208848 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 281 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994210.24416 | 2088699.7294 | 37.7148396860693 | -122.46192642387501 | (37.7148396860693, -122.461926423875) | |||
| 145807 | 145807 | 105847 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 790 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008900.0 | 2110136.0 | 37.774533709285706 | -122.41266682187201 | (37.7745337092857, -122.412666821872) | |||
| 145707 | 145707 | 103809 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1145 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.42020072617599 | (37.7874934070669, -122.420200726176) | ||
| 145621 | 145621 | 51877 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4200 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50819 | 6002010.54318716 | 2105309.8458945 | 37.760893198333704 | -122.436153317055 | (37.7608931983337, -122.436153317055) | ||
| 145579 | 145579 | 107674 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 133 ELSIE ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/10/2014 12:00:00 AM | 3 | 6007164.4 | 2098513.7 | 37.742523993822 | -122.41784659743799 | (37.742523993822, -122.417846597438) | |||
| 145493 | 145493 | 117275 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3431 19TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 6006713.0 | 2104938.0 | 37.760138240698794 | -122.41986317152201 | (37.7601382406988, -122.419863171522) | ||||
| 145458 | 145458 | 108842 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 420 Woolsey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010509.54502 | 2091864.19266 | 37.7244535448266 | -122.405811727659 | (37.7244535448266, -122.405811727659) | |
| 145185 | 145185 | 99291 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.38992452193199 | (37.753957014382, -122.389924521932) | ||
| 144889 | 144889 | 108925 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 209 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 770705 | 6009037.7 | 2097340.0 | 37.739406516451204 | -122.411286359806 | (37.7394065164512, -122.411286359806) | ||
| 144702 | 144702 | 112554 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 35 DOLORES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2015 12:00:00 AM | 3x3 | 6004913.0 | 2108042.0 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | |||
| 144432 | 144432 | 94054 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 185 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/2010 12:00:00 AM | 3 | 3x9 | 6005268.81764 | 2109524.34557 | 37.7726497850887 | -122.425184266439 | (37.7726497850887, -122.425184266439) | ||
| 144400 | 144400 | 103811 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1145 Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.42020072617599 | (37.7874934070669, -122.420200726176) | ||
| 144343 | 144343 | 108814 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 470 Munich St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774651 | 6003792.96606 | 2089744.94608 | 37.7182566522639 | -122.42887901198 | (37.7182566522639, -122.42887901198) | |
| 144271 | 144271 | 33553 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 238 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53983 | 6007052.33241005 | 2097631.90832878 | 37.740096482896 | -122.418171592585 | (37.740096482896, -122.418171592585) | |
| 143973 | 143973 | 89191 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 143971 | 143971 | 114720 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 465 Woolsey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788.0 | 37.724241933851296 | -122.405954818575 | (37.7242419338513, -122.405954818575) | |||
| 143836 | 143836 | 103802 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1157 Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.787518325661296 | -122.42006782447201 | (37.7875183256613, -122.420067824472) | ||
| 143719 | 143719 | 8223 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1500X Galvez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/2015 08:24:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 143622 | 143622 | 87071 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 395 Byxbee St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 143562 | 143562 | 89299 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2825 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2008 12:00:00 AM | 3x3 | Permit Number 51902 | 6000069.8 | 2117048.2 | 37.7930132732955 | -122.44370878246599 | (37.7930132732955, -122.443708782466) | ||
| 143305 | 143305 | 13238 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2322 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1998 12:00:00 AM | 3 | 3X3 | 6001219.43305 | 2119376.81704 | 37.7994725475626 | -122.439898035919 | (37.7994725475626, -122.439898035919) | ||
| 143274 | 143274 | 122379 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 466 Vernon St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/26/2016 12:00:00 AM | 3 | 3x3 | 5992521.0 | 2090937.0 | 37.7208852925782 | -122.46792773796801 | (37.7208852925782, -122.467927737968) | ||
| 142880 | 142880 | 64577 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3500 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2011 12:00:00 AM | 3 | 4x4 1/2 | Permit Number 767979 | 6006252.59051018 | 2104959.36998238 | 37.7601709691535 | -122.42145702923 | (37.7601709691535, -122.42145702923) | |
| 142629 | 142629 | 87975 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2160 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51010 | 5999212.8 | 2111613.6 | 37.778042363793396 | -122.446282917617 | (37.7780423637934, -122.446282917617) | ||
| 142320 | 142320 | 82180 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 105 Lake St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773769 | 5995179.68463591 | 2114884.08050195 | 37.78679106496129 | -122.46047184952101 | (37.7867910649613, -122.460471849521) | ||
| 142314 | 142314 | 47094 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 336 Willard North St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51142 | 5996292.61494047 | 2110619.69439374 | 37.775146151844794 | -122.456312937477 | (37.7751461518448, -122.456312937477) | ||
| 142179 | 142179 | 95565 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 497 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767357 | 6003239.0 | 2102086.6 | 37.75211264995529 | -122.43167449646799 | (37.7521126499553, -122.431674496468) | |
| 142088 | 142088 | 114593 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1 BRADFORD ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | 6x9 | 6009441.0 | 2096050.0 | 37.735887066073104 | -122.409800886333 | (37.7358870660731, -122.409800886333) | |||
| 141970 | 141970 | 94820 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1227 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53900 | 5992334.0 | 2107055.2 | 37.7651309632558 | -122.469746983482 | (37.7651309632558, -122.469746983482) | |
| 141933 | 141933 | 99876 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1295X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003506.1 | 2095452.4 | 37.733911806121895 | -122.43027755668899 | (37.7339118061219, -122.430277556689) |
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");