Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23806 | 23806 | 232314 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 99 Elsie St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6007320.806890001 | 2098778.15204 | 37.7432589210582 | -122.417324523624 | (37.7432589210582, -122.417324523624) | ||||
| 25040 | 25040 | 210510 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 13 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 6ft | 5997279.39992 | 2098558.56074 | 37.7420859128371 | -122.452029069086 | (37.7420859128371, -122.452029069086) | |||
| 26581 | 26581 | 194044 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1542 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 3ft | 6013293.95823 | 2104770.11303 | 37.760045809374205 | -122.39709083697201 | (37.7600458093742, -122.397090836972) | |||
| 30452 | 30452 | 131764 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1492 Pacific Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6007026.74159 | 2117749.85493 | 37.7953341794929 | -122.419687137974 | (37.7953341794929, -122.419687137974) | |||
| 42437 | 42437 | 131765 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1492 Pacific Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6007015.710940001 | 2117748.69184 | 37.7953303645668 | -122.41972522333599 | (37.7953303645668, -122.419725223336) | |||
| 74548 | 74548 | 210511 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 16 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 6ft | 5997410.29084 | 2098566.36293 | 37.742114832343 | -122.451577054547 | (37.742114832343, -122.451577054547) | |||
| 75022 | 75022 | 210512 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 18 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 5997479.74459 | 2098569.7593 | 37.7421281351089 | -122.45133715141199 | (37.7421281351089, -122.451337151412) | |||
| 133073 | 133073 | 210508 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 6ft | 5997156.34573 | 2098551.2278 | 37.7420587290339 | -122.452454020343 | (37.7420587290339, -122.452454020343) | |||
| 155691 | 155691 | 138261 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 29 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 0ft | 5999049.3886 | 2113169.4617 | 37.782305023527606 | -122.44696020353999 | (37.7823050235276, -122.44696020354) | |||
| 167044 | 167044 | 177804 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 670 Brunswick St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | 5998746.52485 | 2086721.86687 | 37.709669038459 | -122.446105024329 | (37.709669038459, -122.446105024329) | ||||
| 168632 | 168632 | 177803 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 670 Brunswick St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | 5998734.37003 | 2086718.8653400003 | 37.70966010280571 | -122.44614681761499 | (37.7096601028057, -122.446146817615) | ||||
| 169301 | 169301 | 138761 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 36 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 5999027.0527 | 2113220.9018 | 37.7824449885745 | -122.44704117852 | (37.7824449885745, -122.44704117852) | |||
| 170140 | 170140 | 210506 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 6ft | 5997067.619580001 | 2098546.7599 | 37.7420413775124 | -122.452760483218 | (37.7420413775124, -122.452760483218) | |||
| 173399 | 173399 | 232313 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 99 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6007317.39057 | 2098776.5375599996 | 37.743254295847 | -122.417336222008 | (37.743254295847, -122.417336222008) | ||||
| 174795 | 174795 | 210507 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 6ft | 5997086.47327 | 2098548.0515900003 | 37.7420460045079 | -122.452695386699 | (37.7420460045079, -122.452695386699) | |||
| 182272 | 182272 | 131763 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1457 Jones St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 3ft | 6008417.06699 | 2117517.79175 | 37.794775211263705 | -122.414859937834 | (37.7947752112637, -122.414859937834) | |||
| 184351 | 184351 | 210509 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 6ft | 5997270.91609 | 2098557.47378 | 37.7420824423506 | -122.452058324935 | (37.7420824423506, -122.452058324935) | |||
| 187810 | 187810 | 138265 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 33 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 5999027.3911 | 2113166.4159 | 37.7822954037862 | -122.447036085573 | (37.7822954037862, -122.447036085573) | |||
| 188549 | 188549 | 138262 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 30 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 5999046.0043 | 2113182.6602 | 37.7823410698302 | -122.44697286174801 | (37.7823410698302, -122.446972861748) | |||
| 23685 | 23685 | 131311 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3701 Jackson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 5996479.01622 | 2115904.55519 | 37.7896676762649 | -122.45605029860201 | (37.7896676762649, -122.456050298602) | |||
| 24538 | 24538 | 232518 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4518 25th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6000862.85333 | 2101145.4432599996 | 37.749393486316706 | -122.43982407823401 | (37.7493934863167, -122.439824078234) | |||
| 25128 | 25128 | 143413 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Kearny St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6011351.7699 | 2116964.7162 | 37.7934210599755 | -122.404666454604 | (37.7934210599755, -122.404666454604) | |||
| 25652 | 25652 | 193862 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90 Stevenson St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 4ft | 6012460.38897 | 2115317.66617 | 37.7889605483383 | -122.40071476487101 | (37.7889605483383, -122.400714764871) | |||
| 27368 | 27368 | 138258 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 GEARY BLVD | 26 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 0ft | 5999069.3554 | 2113186.3828 | 37.7823526251779 | -122.446892345537 | (37.7823526251779, -122.446892345537) | |||
| 28738 | 28738 | 209878 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 649 Parnassus Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5994950.47657 | 2106078.83176 | 37.7626009937499 | -122.460626532115 | (37.7626009937499, -122.460626532115) | |||
| 29521 | 29521 | 231336 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4864 17th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5997916.37939 | 2105662.1050400003 | 37.7616269560303 | -122.45033855228998 | (37.7616269560303, -122.45033855229) | |||
| 30790 | 30790 | 131310 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3701 Jackson St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 3ft | 5996519.22769 | 2115911.43003 | 37.7896888606915 | -122.45591166899099 | (37.7896888606915, -122.455911668991) | |||
| 34772 | 34772 | 131290 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3878 Clay St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 5ft | 5996291.53313 | 2115272.33104 | 37.7879209958986 | -122.456653226584 | (37.7879209958986, -122.456653226584) | |||
| 35271 | 35271 | 232573 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4490 24th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 4ft | 6000081.98126 | 2101692.80168 | 37.7508519204933 | -122.44256363892599 | (37.7508519204933, -122.442563638926) | |||
| 39321 | 39321 | 232585 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1689 Noe St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6003395.282000001 | 2098400.5130000003 | 37.7420003720285 | -122.430871012505 | (37.7420003720285, -122.430871012505) | |||
| 40221 | 40221 | 182926 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2646 Lower Great Hwy | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 5981556.704 | 2097178.5239 | 37.7373835743826 | -122.506289933268 | (37.7373835743826, -122.506289933268) | |||
| 43305 | 43305 | 250477 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 330 Seacliff Ave | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 5986717.515380001 | 2115494.0026 | 37.78797529338429 | -122.489793444531 | (37.7879752933843, -122.489793444531) | |||
| 43532 | 43532 | 143415 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 585 KEARNY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6011361.1919 | 2116895.7879 | 37.793232325979 | -122.40462899905899 | (37.793232325979, -122.404628999059) | |||
| 44758 | 44758 | 232488 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1600 Diamond St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 5ft | 6001990.949580001 | 2099370.89308 | 37.7445851395855 | -122.435796150596 | (37.7445851395855, -122.435796150596) | |||
| 46024 | 46024 | 177585 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 51 Melra Ct | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 5ft | 6008966.99196 | 2086413.05326 | 37.7093994603862 | -122.410759348591 | (37.7093994603862, -122.410759348591) | |||
| 46204 | 46204 | 213204 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 284 Thrift St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | 5994231.94544 | 2089668.7631299999 | 37.7175016712563 | -122.46192164217501 | (37.7175016712563, -122.461921642175) | ||||
| 47583 | 47583 | 193872 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 202 Jessie St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6012046.8224 | 2114654.85227 | 37.7871175424762 | -122.402099041863 | (37.7871175424762, -122.402099041863) | |||
| 50692 | 50692 | 143416 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 585 KEARNY ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6011363.9776 | 2116870.7164 | 37.7931636413378 | -122.40461759455799 | (37.7931636413378, -122.404617594558) | |||
| 51899 | 51899 | 232682 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600 Capp St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6007260.9226 | 2103771.47228 | 37.756966077429205 | -122.417885471231 | (37.7569660774292, -122.417885471231) | |||
| 52680 | 52680 | 96544 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100@ Front St Pine St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | 2 | Permit Number 767720 | 6013029.74558 | 2116576.80835 | 37.7924495959214 | -122.39883325906099 | (37.7924495959214, -122.398833259061) | ||
| 55135 | 55135 | 131289 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3851 Clay St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 6ft | 5996400.52935 | 2115242.07144 | 37.787844168616296 | -122.45627393301201 | (37.7878441686163, -122.456273933012) | |||
| 55170 | 55170 | 232477 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4377 Cesar Chavez St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6001508.16094 | 2100266.16656 | 37.747015912651 | -122.43752963430599 | (37.747015912651, -122.437529634306) | |||
| 55385 | 55385 | 177580 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 765 Morse St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 5ft | 5998269.5566300005 | 2087006.2065299999 | 37.7104225210511 | -122.44777396011801 | (37.7104225210511, -122.447773960118) | |||
| 55435 | 55435 | 131324 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400 Cherry St | 14 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 9ft | 5996252.06992 | 2114879.22587 | 37.7868393686989 | -122.456761319676 | (37.7868393686989, -122.456761319676) | |||
| 55445 | 55445 | 177587 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 48 Melra Ct | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008913.30843 | 2086433.5443799999 | 37.709452714651796 | -122.410946334729 | (37.7094527146518, -122.410946334729) | |||
| 55682 | 55682 | 124430 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 315 Cherry St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 5ft | 5996165.292669999 | 2115148.00048 | 37.7875723686265 | -122.457080995957 | (37.7875723686265, -122.457080995957) | |||
| 56240 | 56240 | 209861 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 375 Parnassus Ave | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 25 | Width 4ft | 5995951.2512300005 | 2106393.76148 | 37.7635232359295 | -122.457188018316 | (37.7635232359295, -122.457188018316) | |||
| 57363 | 57363 | 231338 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1445 Cole St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 4ft | 5998276.5397 | 2105436.41376 | 37.7610278699558 | -122.44907665056499 | (37.7610278699558, -122.449076650565) | |||
| 57879 | 57879 | 143414 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 595 Kearny St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6011359.3347 | 2116932.0022 | 37.793331657969105 | -122.404637975669 | (37.7933316579691, -122.404637975669) | |||
| 60636 | 60636 | 209868 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 375 Parnassus Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | Width 3ft | 5995877.93069 | 2106382.6373400004 | 37.763488480728896 | -122.457440804275 | (37.7634884807289, -122.457440804275) | |||
| 63270 | 63270 | 193860 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90 Stevenson St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 6012486.32053 | 2115341.153 | 37.7890264839285 | -122.40062669516001 | (37.7890264839285, -122.40062669516) | |||
| 63438 | 63438 | 231441 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 865 Corbett Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 5999823.4463 | 2102500.82816 | 37.753055824281 | -122.443515710703 | (37.753055824281, -122.443515710703) | |||
| 66177 | 66177 | 131322 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400 Cherry St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 9ft | 5996256.90517 | 2114854.47123 | 37.786771676724 | -122.45674279995501 | (37.786771676724, -122.456742799955) | |||
| 69486 | 69486 | 232476 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 709 27th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 6001883.69649 | 2099993.37759 | 37.7462882424036 | -122.436211548325 | (37.7462882424036, -122.436211548325) | |||
| 70416 | 70416 | 143419 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 565 Kearny St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6011378.3647 | 2116777.5815 | 37.7929087192764 | -122.404561254888 | (37.7929087192764, -122.404561254888) | |||
| 75602 | 75602 | 210344 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2222 15th Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 5ft | 5991737.50971 | 2099005.7982900003 | 37.7429949142736 | -122.47122357203399 | (37.7429949142736, -122.471223572034) | |||
| 76892 | 76892 | 210319 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 Parnassus Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 5995532.866769999 | 2106346.17817 | 37.7633685471514 | -122.458631622662 | (37.7633685471514, -122.458631622662) | |||
| 77380 | 77380 | 131292 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3844 Clay St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 7ft | 5996357.59442 | 2115281.49962 | 37.7879499630747 | -122.456425331178 | (37.7879499630747, -122.456425331178) | |||
| 129709 | 129709 | 131323 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400 Cherry St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 9ft | 5996254.50366 | 2114867.62545 | 37.7868076567964 | -122.456752060266 | (37.7868076567964, -122.456752060266) | |||
| 131159 | 131159 | 177586 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 44 Melra Ct | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 6ft | 6008941.6423 | 2086478.6989900002 | 37.709578288772896 | -122.41085159474702 | (37.7095782887729, -122.410851594747) | |||
| 134429 | 134429 | 232738 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 470 Alvarado St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6003332.48043 | 2102747.6052 | 37.7539329123867 | -122.431398409134 | (37.7539329123867, -122.431398409134) | |||
| 135837 | 135837 | 143418 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 575 Kearny St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6011374.2644 | 2116814.4836 | 37.7930098144506 | -122.404578041099 | (37.7930098144506, -122.404578041099) | |||
| 135910 | 135910 | 131288 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3823 Clay St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 5ft | 5996511.904 | 2115259.4673200003 | 37.7878983257953 | -122.455889857739 | (37.7878983257953, -122.455889857739) | |||
| 136541 | 136541 | 138760 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 GEARY BLVD | 35 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 0ft | 5999054.4649 | 2113219.8866 | 37.7824437672153 | -122.446946271589 | (37.7824437672153, -122.446946271589) | |||
| 136881 | 136881 | 209865 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 375 Parnassus Ave | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | Width 3ft | 5995912.69079 | 2106395.02005 | 37.7635244769849 | -122.457321476826 | (37.7635244769849, -122.457321476826) | |||
| 149349 | 149349 | 209870 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 375 Parnassus Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 29 | Width 3ft | 5995850.55369 | 2106375.97714 | 37.7634686209925 | -122.45753501005899 | (37.7634686209925, -122.457535010059) | |||
| 151787 | 151787 | 232487 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1600 Diamond St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6001990.81851 | 2099375.34399 | 37.7445973532932 | -122.435796922202 | (37.7445973532932, -122.435796922202) | |||
| 159117 | 159117 | 210296 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1620 10th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 3ft | 5993107.6826599995 | 2104438.8623 | 37.7579918738475 | -122.46688081061701 | (37.7579918738475, -122.466880810617) | |||
| 159763 | 159763 | 131581 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2164 Hyde St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 6007176.69217 | 2119762.83713 | 37.8008697692805 | -122.41931115208901 | (37.8008697692805, -122.419311152089) | |||
| 163957 | 163957 | 131582 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2164 Hyde St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 4ft | 6007173.41737 | 2119786.279 | 37.8009339503036 | -122.419324148191 | (37.8009339503036, -122.419324148191) | |||
| 166323 | 166323 | 193871 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 202 Jessie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6012061.24254 | 2114668.12612 | 37.787154794195104 | -122.402050084568 | (37.7871547941951, -122.402050084568) | |||
| 167472 | 167472 | 96545 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100@ Front St Pine St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | 2 | Permit Number 767720 | 6012972.08955 | 2116568.16592 | 37.7924226531442 | -122.399032145021 | (37.7924226531442, -122.399032145021) | ||
| 167495 | 167495 | 182403 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1520 35th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 0ft | 5985303.3969 | 2104828.602 | 37.758608470378704 | -122.49389967209801 | (37.7586084703787, -122.493899672098) | |||
| 168206 | 168206 | 231346 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 777 Cole St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 20 | Width 4ft | 5997968.16545 | 2107655.6811599997 | 37.7671037751345 | -122.450303156776 | (37.7671037751345, -122.450303156776) | |||
| 170005 | 170005 | 231337 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4864 17th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 5997898.47143 | 2105660.13743 | 37.761620528572294 | -122.450400346506 | (37.7616205285723, -122.450400346506) | |||
| 170398 | 170398 | 209867 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 375 Parnassus Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | Width 3ft | 5995893.9540800005 | 2106389.08307 | 37.7635070993978 | -122.457385851194 | (37.7635070993978, -122.457385851194) | |||
| 170677 | 170677 | 231347 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 781 Cole St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 4ft | 5997971.479719999 | 2107628.1595900003 | 37.767028397577796 | -122.45028970919701 | (37.7670283975778, -122.450289709197) | |||
| 174805 | 174805 | 210320 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 Parnassus Ave | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 5995514.84887 | 2106339.50713 | 37.7633491946228 | -122.45869345733101 | (37.7633491946228, -122.458693457331) | |||
| 175336 | 175336 | 143417 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 585 KEARNY ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6011367.6919 | 2116849.3592 | 37.7931052071704 | -122.404603238639 | (37.7931052071704, -122.404603238639) | |||
| 176151 | 176151 | 209863 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 375 Parnassus Ave | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 4ft | 5995927.29632 | 2106398.78283 | 37.763535647473795 | -122.45727123348301 | (37.7635356474738, -122.457271233483) | |||
| 176934 | 176934 | 209862 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 375 Parnassus Ave | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 4ft | 5995938.25257 | 2106401.71828 | 37.7635443367183 | -122.457233551896 | (37.7635443367183, -122.457233551896) | |||
| 180909 | 180909 | 131291 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3870 Clay St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 5ft | 5996328.52061 | 2115278.8967 | 37.7879411470213 | -122.45652573239201 | (37.7879411470213, -122.456525732392) | |||
| 181598 | 181598 | 193861 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90 Stevenson St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 6012472.19381 | 2115327.20972 | 37.788987411080704 | -122.400674592156 | (37.7889874110807, -122.400674592156) | |||
| 184579 | 184579 | 131309 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Maple St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5996544.3680300005 | 2115871.17754 | 37.7895797810398 | -122.45582177545401 | (37.7895797810398, -122.455821775454) | |||
| 187750 | 187750 | 193859 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90 Stevenson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 6012502.23298 | 2115355.06002 | 37.789065556785495 | -122.400572617131 | (37.7890655567855, -122.400572617131) | |||
| 187912 | 187912 | 231243 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 870 Treat Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 3ft | 6008548.77023 | 2103484.7360799997 | 37.7562511586886 | -122.413411316203 | (37.7562511586886, -122.413411316203) | |||
| 39478 | 39478 | 233321 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 101 Glenbrook Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | Width 10ft | 5997911.86978 | 2104120.7437299998 | 37.7573945063633 | -122.450243040706 | (37.7573945063633, -122.450243040706) | |||
| 45796 | 45796 | 233304 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 793 27th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6001400.58211 | 2099957.57673 | 37.746162481213496 | -122.437879532637 | (37.7461624812135, -122.437879532637) | ||||
| 75644 | 75644 | 233317 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 20 | Width 8ft | 6001489.22958 | 2098922.00585 | 37.7433240886333 | -122.437498855898 | (37.7433240886333, -122.437498855898) | |||
| 130754 | 130754 | 233300 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3881 Cesar Chavez St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6004689.37022 | 2100438.88173 | 37.747670502196705 | -122.42654157813601 | (37.7476705021967, -122.426541578136) | |||
| 148613 | 148613 | 211089 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1826 09th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 3ft | 5993465.35 | 2103031.19551 | 37.754147421393 | -122.465541593268 | (37.754147421393, -122.465541593268) | |||
| 154212 | 154212 | 211095 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 66 Aerial Way | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 38 | Width 4ft | 5992315.3975 | 2102577.1661799997 | 37.7528343824016 | -122.469485327309 | (37.7528343824016, -122.469485327309) | |||
| 165872 | 165872 | 233299 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 130 Ripley St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 5ft | 6008878.43402 | 2099079.16382 | 37.7441729452414 | -122.411959903051 | (37.7441729452414, -122.411959903051) | |||
| 173908 | 173908 | 211094 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 66 Aerial Way | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 39 | Width 4ft | 5992285.42513 | 2102561.07483 | 37.752788467513206 | -122.46958780504801 | (37.7527884675132, -122.469587805048) | |||
| 180357 | 180357 | 211093 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2088 15th Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 6ft | 5991644.9229 | 2101275.9651599997 | 37.749222851651 | -122.471709112392 | (37.749222851651, -122.471709112392) | |||
| 181841 | 181841 | 211099 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 501 Saint Francis Blvd | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 46 | Width 10ft | 5993137.63738 | 2096084.35497 | 37.7350542531473 | -122.46617009617201 | (37.7350542531473, -122.466170096172) | |||
| 183128 | 183128 | 233318 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | Width 8ft | 6001505.99922 | 2098909.6493900004 | 37.7432911141078 | -122.43743998627501 | (37.7432911141078, -122.437439986275) | |||
| 31025 | 31025 | 129553 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6012058.5984 | 2115646.10201 | 37.7898399378192 | -122.402128014397 | (37.7898399378192, -122.402128014397) | |||
| 34739 | 34739 | 129549 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6012078.1031 | 2115538.76346 | 37.78954630017979 | -122.40205298038401 | (37.7895463001798, -122.402052980384) | |||
| 34865 | 34865 | 129550 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6012076.26306 | 2115552.15036 | 37.7895829547447 | -122.40206028827 | (37.7895829547447, -122.40206028827) |
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");