Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35348 | 35348 | 194039 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900x Carolina St | 74 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6012510.33858 | 2102789.20195 | 37.754563007990896 | -122.399661931254 | (37.7545630079909, -122.399661931254) | ||||
| 64729 | 64729 | 194038 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900x Carolina St | 53 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6012502.8583 | 2102970.8089 | 37.7550612440971 | -122.39970055084 | (37.7550612440971, -122.39970055084) | ||||
| 103516 | 103516 | 111419 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200x SAN MARCOS AVE | 4 | Median : Yard 3 | Tree 1 | Private 1 | 10 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
| 112509 | 112509 | 111420 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200x SAN MARCOS AVE | 5 | Median : Yard 3 | Tree 1 | Private 1 | 15 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
| 118289 | 118289 | 114805 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 210X GELLERT DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 3x3 | 5985389.0 | 2094462.0 | 37.73014959142171 | -122.492840061243 | (37.7301495914217, -122.492840061243) | |||
| 151195 | 151195 | 247574 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 350x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6008213.28818 | 2095041.8138700002 | 37.7330499269008 | -122.413974287302 | (37.7330499269008, -122.413974287302) | ||||
| 27253 | 27253 | 124144 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4100x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5994110.98895 | 2112812.2270400003 | 37.7810407796467 | -122.464018802579 | (37.7810407796467, -122.464018802579) | ||||
| 31237 | 31237 | 124292 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4401x Cornwall St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 7ft | 5993800.52883 | 2114192.89776 | 37.7848138297402 | -122.465193144089 | (37.7848138297402, -122.465193144089) | |||
| 34159 | 34159 | 124136 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3600x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 5995735.89711 | 2112868.88763 | 37.7812898666102 | -122.458401576021 | (37.7812898666102, -122.458401576021) | ||||
| 39703 | 39703 | 119297 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6700x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5986078.135009999 | 2112521.2781700003 | 37.7797756964263 | -122.491786625446 | (37.7797756964263, -122.491786625446) | ||||
| 47826 | 47826 | 251024 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5000x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 10ft | 5991467.9002 | 2112710.9046 | 37.7806098961229 | -122.473155080103 | (37.7806098961229, -122.473155080103) | |||
| 49072 | 49072 | 119929 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6400x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 5987119.54861 | 2112558.01872 | 37.779937387281706 | -122.48818666733801 | (37.7799373872817, -122.488186667338) | ||||
| 53667 | 53667 | 124132 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3500x Geary Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5996095.590340001 | 2112883.06277 | 37.7813494516321 | -122.457158247488 | (37.7813494516321, -122.457158247488) | ||||
| 59521 | 59521 | 124131 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3500x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 5996150.62067 | 2112883.69082 | 37.7813543363463 | -122.456967916029 | (37.7813543363463, -122.456967916029) | ||||
| 60241 | 60241 | 218256 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400x Portola Dr | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5992828.86641 | 2097235.35096 | 37.7381967802678 | -122.46732128416599 | (37.7381967802678, -122.467321284166) | ||||
| 71855 | 71855 | 218257 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400x Portola Dr | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5992819.23319 | 2097230.95625 | 37.738184157378704 | -122.467354271301 | (37.7381841573787, -122.467354271301) | ||||
| 74520 | 74520 | 124138 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3600x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 5995685.115 | 2112866.393 | 37.781280098604796 | -122.45857707539899 | (37.7812800986048, -122.458577075399) | ||||
| 132349 | 132349 | 119288 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6600x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 5986322.21079 | 2112527.80703 | 37.7798078851153 | -122.490942752545 | (37.7798078851153, -122.490942752545) | ||||
| 135213 | 135213 | 218258 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400x Portola Dr | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5992819.36042 | 2097222.3722200003 | 37.7381605951349 | -122.467353207399 | (37.7381605951349, -122.467353207399) | ||||
| 150369 | 150369 | 232589 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5200x Diamond Heights Blvd | 44 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6001728.28871 | 2098778.49055 | 37.7429436178674 | -122.436661981881 | (37.7429436178674, -122.436661981881) | ||||
| 153921 | 153921 | 231443 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10x Benton Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6004814.81075 | 2095028.31001 | 37.7328213911887 | -122.425722767894 | (37.7328213911887, -122.425722767894) | ||||
| 156604 | 156604 | 119932 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6400x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 5987027.58334 | 2112559.15504 | 37.7799351415473 | -122.488504895539 | (37.7799351415473, -122.488504895539) | ||||
| 160258 | 160258 | 124147 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4500x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 5992867.120709999 | 2112765.78915 | 37.780841509198105 | -122.468318544662 | (37.7808415091981, -122.468318544662) | ||||
| 162690 | 162690 | 124140 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3700x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 5995346.94367 | 2112856.3972099996 | 37.78123321166729 | -122.45974624981501 | (37.7812332116673, -122.459746249815) | ||||
| 166635 | 166635 | 232588 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5200x Diamond Heights Blvd | 43 | Median : Yard 3 | Tree 1 | DPW 2 | 59 | 6001719.64568 | 2098775.96763 | 37.742936199339795 | -122.436691686488 | (37.7429361993398, -122.436691686488) | ||||
| 167931 | 167931 | 124291 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4401x Cornwall St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 9ft | 5993813.763719999 | 2114194.95027 | 37.7848202285685 | -122.465147505193 | (37.7848202285685, -122.465147505193) | |||
| 176894 | 176894 | 218255 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400x Portola Dr | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 5992834.72812 | 2097242.26115 | 37.7382160923013 | -122.467301519773 | (37.7382160923013, -122.467301519773) | ||||
| 177514 | 177514 | 177792 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 290x Rolph St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6001464.09036 | 2088085.72956 | 37.7135687209947 | -122.43681022251499 | (37.7135687209947, -122.436810222515) | |||
| 178177 | 178177 | 119934 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6400x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 5986945.272609999 | 2112550.81697 | 37.7799074444019 | -122.488789028183 | (37.7799074444019, -122.488789028183) | ||||
| 181114 | 181114 | 124134 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3500x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5996034.43033 | 2112879.7174 | 37.7813367535062 | -122.457369587843 | (37.7813367535062, -122.457369587843) | ||||
| 188991 | 188991 | 218259 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400x Portola Dr | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5992809.1507 | 2097219.8287299997 | 37.7381530219397 | -122.46738832232 | (37.7381530219397, -122.46738832232) | ||||
| 3 | 3 | 119263 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Lakeshore Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x30 | |||||||||
| 11659 | 11659 | 106061 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 12X Canyon Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 6003256.93175 | 2086330.4794599998 | 37.7088509162175 | -122.430488359046 | (37.7088509162175, -122.430488359046) | ||||
| 28399 | 28399 | 211132 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 5994073.5471 | 2101557.9336599996 | 37.750137280527 | -122.463331413139 | (37.750137280527, -122.463331413139) | |||
| 29552 | 29552 | 211129 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 8ft | 5994111.36343 | 2101512.4621099997 | 37.7500146058056 | -122.463197343983 | (37.7500146058056, -122.463197343983) | |||
| 29681 | 29681 | 211122 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 8ft | 5994167.1459 | 2101393.52573 | 37.749691250071 | -122.462995818511 | (37.749691250071, -122.462995818511) | |||
| 31535 | 31535 | 194476 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900x Carolina St | 43 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6012491.75598 | 2103075.9348299997 | 37.755349278054 | -122.39974632722799 | (37.755349278054, -122.399746327228) | ||||
| 32328 | 32328 | 211103 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 5993592.96046 | 2100932.97127 | 37.7483935940092 | -122.464947913926 | (37.7483935940092, -122.464947913926) | ||||
| 34409 | 34409 | 211112 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 44 | Width 8ft | 5994184.95875 | 2101126.7807299998 | 37.748959862029096 | -122.46291487144501 | (37.7489598620291, -122.462914871445) | |||
| 36172 | 36172 | 194506 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6016624.93937 | 2096021.7822099999 | 37.7362095654157 | -122.38496096110501 | (37.7362095654157, -122.384960961105) | ||||
| 36297 | 36297 | 211100 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 198x San Anselmo Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 41 | 5993653.9743 | 2096326.24073 | 37.735748188020395 | -122.464402505688 | (37.7357481880204, -122.464402505688) | ||||
| 36701 | 36701 | 194508 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6016611.71691 | 2096022.49532 | 37.7362107920965 | -122.385006726687 | (37.7362107920965, -122.385006726687) | ||||
| 36932 | 36932 | 211104 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 5993600.40313 | 2100945.49901 | 37.7484284211296 | -122.464923087237 | (37.7484284211296, -122.464923087237) | ||||
| 37375 | 37375 | 211161 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Idora Ave | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 41 | Width 9ft | 5995684.4738300005 | 2099331.0800900003 | 37.7441155729727 | -122.45759966680599 | (37.7441155729727, -122.457599666806) | |||
| 37384 | 37384 | 211111 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 8ft | 5994189.10111 | 2101103.38332 | 37.7488958572711 | -122.462898850009 | (37.7488958572711, -122.462898850009) | |||
| 39942 | 39942 | 194507 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6016618.68245 | 2096023.0251200001 | 37.7362126321093 | -122.384982680622 | (37.7362126321093, -122.384982680622) | ||||
| 39986 | 39986 | 211113 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 5994180.049769999 | 2101148.49465 | 37.7490192001903 | -122.462933421744 | (37.7490192001903, -122.462933421744) | |||
| 40010 | 40010 | 113539 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | ||||
| 41584 | 41584 | 246869 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 3090x Market St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 5999937.78249 | 2105312.2028200002 | 37.7607816895477 | -122.443322229632 | (37.7607816895477, -122.443322229632) | ||||
| 43629 | 43629 | 211101 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 5993549.05492 | 2100852.54328 | 37.7481702275711 | -122.465093896362 | (37.7481702275711, -122.465093896362) | ||||
| 49014 | 49014 | 194514 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6016024.76116 | 2095911.2144799998 | 37.7358727531167 | -122.387028333393 | (37.7358727531167, -122.387028333393) | ||||
| 49204 | 49204 | 211120 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 5994172.8828300005 | 2101376.40838 | 37.7496445806313 | -122.46297473838699 | (37.7496445806313, -122.462974738387) | |||
| 50547 | 50547 | 211162 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Idora Ave | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995762.15632 | 2099312.39681 | 37.744068735376295 | -122.457329708294 | (37.7440687353763, -122.457329708294) | |||
| 52412 | 52412 | 211125 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5994142.00989 | 2101462.2847 | 37.7498785968185 | -122.463087727432 | (37.7498785968185, -122.463087727432) | |||
| 52933 | 52933 | 233310 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200x Diamond Heights Blvd | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6001169.81934 | 2099234.0052400003 | 37.7441626003404 | -122.438625642562 | (37.7441626003404, -122.438625642562) | ||||
| 53598 | 53598 | 95407 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2X Cranleigh Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 80 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | ||||
| 53815 | 53815 | 211102 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 43 | 5993572.08024 | 2100898.12462 | 37.7482967100214 | -122.465017586199 | (37.7482967100214, -122.465017586199) | ||||
| 53902 | 53902 | 194511 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 6016041.40389 | 2096043.15017 | 37.73623594344121 | -122.386979991251 | (37.7362359434412, -122.386979991251) | ||||
| 55031 | 55031 | 233309 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200x Diamond Heights Blvd | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 52 | 6001152.90645 | 2099246.96263 | 37.744197216131 | -122.438685051778 | (37.744197216131, -122.438685051778) | ||||
| 56070 | 56070 | 211118 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | Width 8ft | 5994177.42572 | 2101348.8746700003 | 37.74956924173021 | -122.46295703165701 | (37.7495692417302, -122.462957031657) | |||
| 56372 | 56372 | 194513 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6016035.53821 | 2096012.28902 | 37.7361508801593 | -122.38699811976299 | (37.7361508801593, -122.386998119763) | ||||
| 56493 | 56493 | 211115 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | Width 8ft | 5994174.89833 | 2101193.52417 | 37.749142543105 | -122.46295450185801 | (37.749142543105, -122.462954501858) | |||
| 56595 | 56595 | 211131 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5994094.61365 | 2101539.2804900003 | 37.7500872773246 | -122.463257210957 | (37.7500872773246, -122.463257210957) | |||
| 56699 | 56699 | 233312 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200x Diamond Heights Blvd | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 39 | 6001396.29408 | 2099056.86784 | 37.743689103685206 | -122.437829859455 | (37.7436891036852, -122.437829859455) | ||||
| 57778 | 57778 | 124704 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2x Cherry St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5996074.417169999 | 2115943.0366 | 37.789750104458 | -122.457452946984 | (37.789750104458, -122.457452946984) | ||||
| 57952 | 57952 | 211135 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 44 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5993997.61305 | 2101611.2464400004 | 37.750279288862295 | -122.463597864272 | (37.7502792888623, -122.463597864272) | |||
| 58460 | 58460 | 194518 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 15x Reuel Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6017388.67134 | 2096078.81136 | 37.7364083704432 | -122.382324365581 | (37.7364083704432, -122.382324365581) | ||||
| 60973 | 60973 | 211136 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 45 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | Width 8ft | 5993981.68965 | 2101619.35066 | 37.750300623474295 | -122.463653516122 | (37.7503006234743, -122.463653516122) | |||
| 66999 | 66999 | 194498 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 180x Bay Shore Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6011165.80817 | 2099547.49243 | 37.7455869411819 | -122.40408357310899 | (37.7455869411819, -122.404083573109) | ||||
| 68100 | 68100 | 194503 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6016679.95616 | 2095990.1573599998 | 37.7361257728833 | -122.38476854124399 | (37.7361257728833, -122.384768541244) | ||||
| 68846 | 68846 | 194512 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6016031.3750599995 | 2096031.1694 | 37.736202491347 | -122.387013830018 | (37.736202491347, -122.387013830018) | ||||
| 69972 | 69972 | 194504 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6016665.2898 | 2096001.51106 | 37.7361561367049 | -122.38482004001001 | (37.7361561367049, -122.38482004001) | ||||
| 72424 | 72424 | 233311 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200x Diamond Heights Blvd | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 6001230.81416 | 2099188.16664 | 37.7440402079991 | -122.43841145284401 | (37.7440402079991, -122.438411452844) | ||||
| 73631 | 73631 | 211163 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Idora Ave | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 5995808.0564 | 2099301.9235400003 | 37.744042614569295 | -122.45717023961001 | (37.7440426145693, -122.45717023961) | |||
| 73708 | 73708 | 211133 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 40 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 8ft | 5994061.05133 | 2101566.69435 | 37.750160615241704 | -122.46337525958 | (37.7501606152417, -122.46337525958) | |||
| 76136 | 76136 | 111405 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 10 | Median : Yard 3 | Tree 1 | Private 1 | 50 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | ||||
| 76494 | 76494 | 233314 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200x Diamond Heights Blvd | 60 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6001944.7696 | 2098445.7713 | 37.742042348782 | -122.43588965038299 | (37.742042348782, -122.435889650383) | ||||
| 76566 | 76566 | 247029 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 550x Valley St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6002358.84031 | 2099162.32643 | 37.744033355159296 | -122.434509149673 | (37.7440333551593, -122.434509149673) | ||||
| 76712 | 76712 | 211127 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 8ft | 5994124.86854 | 2101482.0693200002 | 37.7499319329208 | -122.46314843794701 | (37.7499319329208, -122.463148437947) | |||
| 79568 | 79568 | 116501 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 71X PARKRIDGE DR | 2 | Median : Yard 3 | Tree 1 | Private 1 | 40 | 3x3 | 5999012.0 | 2102131.0 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | |||
| 82501 | 82501 | 111413 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 8 | Median : Yard 3 | Tree 1 | Private 1 | 42 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
| 83529 | 83529 | 111403 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 8 | Median : Yard 3 | Tree 1 | Private 1 | 28 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | ||||
| 84668 | 84668 | 116500 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 71X PARKRIDGE DR | 1 | Median : Yard 3 | Tree 1 | Private 1 | 45 | 3x3 | 5999012.0 | 2102131.0 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | |||
| 84882 | 84882 | 108688 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1x MONTEZUMA ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6007361.0 | 2099793.0 | 37.7460477277002 | -122.417257445993 | (37.7460477277002, -122.417257445993) | ||||
| 88481 | 88481 | 113536 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
| 89670 | 89670 | 114428 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 34x HIGUERA AVE | 2 | Median : Yard 3 | Tree 1 | Private 1 | 56 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 89796 | 89796 | 111400 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 5 | Median : Yard 3 | Tree 1 | Private 1 | 54 | Permit Number 779360 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | |||
| 95665 | 95665 | 106062 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 140X CANYON DR | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6002713.0 | 2086188.2 | 37.708429419739794 | -122.432358106226 | (37.7084294197398, -122.432358106226) | ||||
| 95691 | 95691 | 111404 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 9 | Median : Yard 3 | Tree 1 | Private 1 | 48 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | ||||
| 95918 | 95918 | 111398 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 3 | Median : Yard 3 | Tree 1 | Private 1 | 4 | Permit Number 779360 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | |||
| 96206 | 96206 | 111407 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 2 | Median : Yard 3 | Tree 1 | Private 1 | 12 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
| 96850 | 96850 | 113535 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12/05/2015 12:49:00 PM | 3 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||
| 97142 | 97142 | 105761 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2400X CASTRO ST | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | ||||
| 98788 | 98788 | 111423 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200x SAN MARCOS AVE | 8 | Median : Yard 3 | Tree 1 | Private 1 | 50 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
| 99590 | 99590 | 111406 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 40 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
| 100517 | 100517 | 104502 | Private 5 | Pinus radiata :: Monterey Pine 3 | 30X SATURN ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6000456.0 | 2106003.0 | 37.7627079858093 | -122.44157952536999 | (37.7627079858093, -122.44157952537) | ||||
| 101535 | 101535 | 116502 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 71X PARKRIDGE DR | 3 | Median : Yard 3 | Tree 1 | Private 1 | 28 | 3x3 | 5999012.0 | 2102131.0 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | |||
| 103385 | 103385 | 111415 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 10 | Median : Yard 3 | Tree 1 | Private 1 | 48 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
| 103732 | 103732 | 113537 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
| 104683 | 104683 | 111397 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 2 | Median : Yard 3 | Tree 1 | Private 1 | 36 | Permit Number 779360 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) |
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");