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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51460 | 51460 | 226589 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1100 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999827.96585 | 2100023.61803 | 37.7462542624189 | -122.443322166684 | (37.7462542624189, -122.443322166684) | |||
| 51466 | 51466 | 118540 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981337.117190001 | 2112394.76177 | 37.7791500842164 | -122.50817820058701 | (37.7791500842164, -122.508178200587) | ||||
| 51665 | 51665 | 185263 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2157 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986253.2809 | 2097519.1429 | 37.738594203049004 | -122.4900769498 | (37.738594203049, -122.4900769498) | |||
| 51759 | 51759 | 207273 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2486 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991107.555 | 2098499.64463 | 37.741568687546604 | -122.473364852413 | (37.7415686875466, -122.473364852413) | |||
| 52054 | 52054 | 226616 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005523.88104 | 2097105.4034 | 37.7385646686269 | -122.42341893953899 | (37.7385646686269, -122.423418939539) | |||
| 52088 | 52088 | 177024 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 11 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6005372.1534 | 2093185.8595 | 37.7277939084451 | -122.42366493918301 | (37.7277939084451, -122.423664939183) | ||||
| 52824 | 52824 | 207200 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 580 Hearst Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997508.4902099995 | 2094418.65818 | 37.7307318559937 | -122.45093849993401 | (37.7307318559937, -122.450938499934) | |||
| 53082 | 53082 | 139036 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000642.6462 | 2113889.2265 | 37.784372208438604 | -122.441499920001 | (37.7843722084386, -122.441499920001) | |||
| 53679 | 53679 | 207188 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5999995.26886 | 2094392.10213 | 37.7308009895535 | -122.442339437931 | (37.7308009895535, -122.442339437931) | ||||
| 53847 | 53847 | 207299 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 111 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996293.5704 | 2094296.85345 | 37.7303277824929 | -122.455129844261 | (37.7303277824929, -122.455129844261) | |||
| 54071 | 54071 | 207232 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226 Thrift St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 6ft | 5994766.53745 | 2089660.64097 | 37.7175101320775 | -122.46007322780301 | (37.7175101320775, -122.460073227803) | |||
| 54128 | 54128 | 247978 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6009784.19004 | 2099413.44589 | 37.7451415861154 | -122.40885156275299 | (37.7451415861154, -122.408851562753) | ||||
| 54556 | 54556 | 207281 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 595 Darien Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993428.290469999 | 2094922.6798 | 37.731881346040794 | -122.46508086700001 | (37.7318813460408, -122.465080867) | |||
| 54753 | 54753 | 207286 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 80 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993623.31026 | 2093437.41863 | 37.7278144273955 | -122.464298855206 | (37.7278144273955, -122.464298855206) | |||
| 55280 | 55280 | 184220 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3437 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5984130.1355 | 2104934.7045 | 37.758831082518896 | -122.49796511397498 | (37.7588310825189, -122.497965113975) | |||
| 55314 | 55314 | 207344 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 543 Foerster St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 5998095.360119999 | 2095203.1187900002 | 37.7329193786311 | -122.448966095125 | (37.7329193786311, -122.448966095125) | |||
| 55980 | 55980 | 207361 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 452 Circular Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999521.461730001 | 2093554.76745 | 37.72847484721579 | -122.443917320952 | (37.7284748472158, -122.443917320952) | |||
| 56032 | 56032 | 207275 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 315 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993069.797230001 | 2099663.50314 | 37.7448777789813 | -122.46666472241999 | (37.7448777789813, -122.46666472242) | |||
| 56436 | 56436 | 207226 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 224 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995369.52282 | 2091446.6873400002 | 37.722448854419795 | -122.45811818710399 | (37.7224488544198, -122.458118187104) | |||
| 56500 | 56500 | 177008 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 67 Capistrano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6001385.71309 | 2093783.96595 | 37.7292103388668 | -122.43748892737301 | (37.7292103388668, -122.437488927373) | ||||
| 56956 | 56956 | 207310 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 40 Hazelwood Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5996630.650640001 | 2093957.49673 | 37.7294153231391 | -122.453940019643 | (37.7294153231391, -122.453940019643) | |||
| 57155 | 57155 | 207179 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5995334.19857 | 2098241.75122 | 37.741104418845794 | -122.458731986098 | (37.7411044188458, -122.458731986098) | |||
| 57295 | 57295 | 207143 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1617 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991127.14012 | 2104370.55559 | 37.7576898140615 | -122.473725315989 | (37.7576898140615, -122.473725315989) | |||
| 57399 | 57399 | 176993 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Morse St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998644.90157 | 2087151.5668400002 | 37.7108430935156 | -122.44648714447099 | (37.7108430935156, -122.446487144471) | |||
| 57514 | 57514 | 226606 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2560 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6002251.74918 | 2096967.99127 | 37.7380021417799 | -122.434722564214 | (37.7380021417799, -122.434722564214) | |||
| 57932 | 57932 | 226588 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 350 Treat Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008565.829469999 | 2106391.50298 | 37.7642334332393 | -122.41355789668002 | (37.7642334332393, -122.41355789668) | |||
| 58029 | 58029 | 207272 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 855 Ortega St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5991341.884190001 | 2102447.3188400003 | 37.7524215459225 | -122.472842415544 | (37.7524215459225, -122.472842415544) | |||
| 58147 | 58147 | 207303 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 59 Hazelwood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996585.5854400005 | 2094033.89672 | 37.7296225152507 | -122.45410132920601 | (37.7296225152507, -122.454101329206) | |||
| 58753 | 58753 | 185611 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2241 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986448.3245 | 2100932.1027 | 37.747976665787895 | -122.489653506406 | (37.7479766657879, -122.489653506406) | |||
| 59000 | 59000 | 227698 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 517 Hickory St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6004312.97566 | 2110291.73585 | 37.7747028072132 | -122.428545336007 | (37.7747028072132, -122.428545336007) | |||
| 59067 | 59067 | 207271 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 855 Ortega St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991354.98649 | 2102448.1922400002 | 37.752424702544296 | -122.47279716974899 | (37.7524247025443, -122.472797169749) | |||
| 59113 | 59113 | 207317 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2146 12th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5992616.43475 | 2100823.70057 | 37.748037210643396 | -122.46831674014 | (37.7480372106434, -122.46831674014) | |||
| 59140 | 59140 | 207326 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 43 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998477.362380001 | 2097389.2678 | 37.7389438623547 | -122.447802750104 | (37.7389438623547, -122.447802750104) | |||
| 59419 | 59419 | 207291 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 135 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993593.95913 | 2093848.0757900001 | 37.7289402994475 | -122.464430125662 | (37.7289402994475, -122.464430125662) | |||
| 59479 | 59479 | 207337 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 114 Melrose Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5999331.40158 | 2095537.8442099998 | 37.7339090681372 | -122.44471684701901 | (37.7339090681372, -122.444716847019) | |||
| 59513 | 59513 | 207233 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 422 Orizaba Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5994045.888719999 | 2089197.1437900001 | 37.7161960040241 | -122.462530559657 | (37.7161960040241, -122.462530559657) | |||
| 59665 | 59665 | 226580 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 110 Carmel St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5998192.72104 | 2105385.2518599997 | 37.7608825979841 | -122.44936285530599 | (37.7608825979841, -122.449362855306) | |||
| 59680 | 59680 | 207153 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 37 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992857.79641 | 2101696.45596 | 37.750447510654396 | -122.467545586773 | (37.7504475106544, -122.467545586773) | |||
| 59888 | 59888 | 177028 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 164 Baltimore Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6002357.56159 | 2086195.5289200002 | 37.7084293823926 | -122.433587065817 | (37.7084293823926, -122.433587065817) | |||
| 59995 | 59995 | 226605 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 276 Bemis St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6002989.382569999 | 2096277.75645 | 37.7361487649474 | -122.432122925433 | (37.7361487649474, -122.432122925433) | |||
| 60108 | 60108 | 207212 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Judson Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997571.11535 | 2093520.52293 | 37.728269374612495 | -122.450657267541 | (37.7282693746125, -122.450657267541) | |||
| 60300 | 60300 | 182865 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1845 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989054.8495 | 2102750.5341 | 37.75312143070521 | -122.480773464165 | (37.7531214307052, -122.480773464165) | |||
| 60876 | 60876 | 226631 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6002644.82708 | 2096800.8937799998 | 37.737565638743895 | -122.43335156393299 | (37.7375656387439, -122.433351563933) | |||
| 61063 | 61063 | 207293 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 965 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994659.04342 | 2093888.37752 | 37.729112296585996 | -122.460750997386 | (37.729112296586, -122.460750997386) | |||
| 61510 | 61510 | 207295 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 217 Colon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5996039.75572 | 2094297.6973299999 | 37.7303155346371 | -122.45600737215 | (37.7303155346371, -122.45600737215) | |||
| 61927 | 61927 | 184535 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1914 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981673.4595 | 2102023.0319999997 | 37.7506921190217 | -122.506245385817 | (37.7506921190217, -122.506245385817) | |||
| 61977 | 61977 | 226613 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 322 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006488.43942 | 2097246.62658 | 37.7390068293023 | -122.42009397237601 | (37.7390068293023, -122.420093972376) | |||
| 62171 | 62171 | 207300 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 145 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996448.99813 | 2094535.9636799998 | 37.730993237639105 | -122.45460977981199 | (37.7309932376391, -122.454609779812) | |||
| 62397 | 62397 | 207195 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 574 Hearst Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997610.81771 | 2094416.06797 | 37.7307306014402 | -122.450584552831 | (37.7307306014402, -122.450584552831) | |||
| 62400 | 62400 | 207257 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 545 Arch St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5992721.30272 | 2090787.38196 | 37.7204860426843 | -122.467224484748 | (37.7204860426843, -122.467224484748) | |||
| 62758 | 62758 | 207140 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1682 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990920.30999 | 2103955.3917900003 | 37.7565379030086 | -122.474410316087 | (37.7565379030086, -122.474410316087) | |||
| 62912 | 62912 | 177003 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 746 Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009476.70201 | 2090586.0760400002 | 37.720886288652004 | -122.409291987754 | (37.720886288652, -122.409291987754) | |||
| 63132 | 63132 | 207265 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 542 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5993523.314809999 | 2089466.4912400001 | 37.7169054593937 | -122.464356356062 | (37.7169054593937, -122.464356356062) | |||
| 63341 | 63341 | 207360 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 374 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997612.78816 | 2093589.9194 | 37.7284623061695 | -122.450518204475 | (37.7284623061695, -122.450518204475) | |||
| 63394 | 63394 | 119482 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985642.69106 | 2113025.08426 | 37.781133543390204 | -122.49333012331499 | (37.7811335433902, -122.493330123315) | |||
| 63480 | 63480 | 177019 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 25 Madrid St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6004214.26597 | 2093378.8456299999 | 37.728258376811496 | -122.427681523704 | (37.7282583768115, -122.427681523704) | ||||
| 63518 | 63518 | 207294 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1414 Plymouth Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995890.4022699995 | 2093395.3891200002 | 37.727829439763106 | -122.456458481978 | (37.7278294397631, -122.456458481978) | |||
| 63586 | 63586 | 207359 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 149 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5999079.1567400005 | 2093759.91373 | 37.729012890930704 | -122.445461131336 | (37.7290128909307, -122.445461131336) | |||
| 63672 | 63672 | 226582 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 383 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006413.772530001 | 2097021.64328 | 37.738384868057295 | -122.420336172385 | (37.7383848680573, -122.420336172385) | |||
| 63970 | 63970 | 227703 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 200 Kingston St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 8ft | 6006269.2438199995 | 2098023.2428599996 | 37.7411268910989 | -122.420906974789 | (37.7411268910989, -122.420906974789) | |||
| 65599 | 65599 | 207240 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1x Minerva St | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 0ft | 5996458.70543 | 2088998.7901400002 | 37.7157900266684 | -122.45417643520001 | (37.7157900266684, -122.4541764352) | |||
| 66041 | 66041 | 129492 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2536 Baker St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999690.83284 | 2117600.09007 | 37.794506995647 | -122.445059718941 | (37.794506995647, -122.445059718941) | |||
| 66099 | 66099 | 185262 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2167 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986237.8922 | 2097517.551 | 37.738588933455404 | -122.490130038774 | (37.7385889334554, -122.490130038774) | |||
| 67090 | 67090 | 177002 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 721 Goettingen St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6010761.087830001 | 2091324.0286400001 | 37.7229844303778 | -122.404904160394 | (37.7229844303778, -122.404904160394) | |||
| 67219 | 67219 | 129495 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1136 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 6007480.35855 | 2119354.0245 | 37.7997643702969 | -122.418231335218 | (37.7997643702969, -122.418231335218) | |||
| 67340 | 67340 | 246731 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Ripley St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6008584.453369999 | 2099107.91594 | 37.7442353941634 | -122.41297845991001 | (37.7442353941634, -122.41297845991) | |||
| 67812 | 67812 | 207165 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995466.11989 | 2100230.17484 | 37.746571717707205 | -122.458419748693 | (37.7465717177072, -122.458419748693) | |||
| 67877 | 67877 | 207215 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Judson Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997615.0933300005 | 2093521.35715 | 37.7282741823893 | -122.450505294682 | (37.7282741823893, -122.450505294682) | |||
| 67977 | 67977 | 117858 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 600 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5983830.55841 | 2111665.32715 | 37.777293884605704 | -122.499498581311 | (37.7772938846057, -122.499498581311) | |||
| 68141 | 68141 | 207220 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 143 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5999153.87241 | 2093460.82982 | 37.7281959413875 | -122.445181340549 | (37.7281959413875, -122.445181340549) | ||||
| 68271 | 68271 | 177021 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1538 Burrows St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6006775.37088 | 2092172.2563099999 | 37.72508988269 | -122.41874212587 | (37.72508988269, -122.41874212587) | |||
| 68354 | 68354 | 207353 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 678 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5997598.43347 | 2095021.49363 | 37.7323922472992 | -122.45067100017201 | (37.7323922472992, -122.450671000172) | |||
| 68812 | 68812 | 207209 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 342 Edna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5998785.841580001 | 2094004.8345400002 | 37.7296686369961 | -122.446492753553 | (37.7296686369961, -122.446492753553) | |||
| 68943 | 68943 | 207150 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 830 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5991404.13851 | 2102515.6148 | 37.752612672541105 | -122.47263211090099 | (37.7526126725411, -122.472632110901) | |||
| 68986 | 68986 | 185609 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2261 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986412.841 | 2100929.3732 | 37.747967099583 | -122.489776004492 | (37.747967099583, -122.489776004492) | |||
| 69001 | 69001 | 176998 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 87 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6000227.51825 | 2089886.7347900001 | 37.7184435186304 | -122.441213386902 | (37.7184435186304, -122.441213386902) | |||
| 69070 | 69070 | 207341 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 538 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998515.2216 | 2095011.0330299998 | 37.7324159597185 | -122.447500710116 | (37.7324159597185, -122.447500710116) | ||||
| 69145 | 69145 | 207269 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1477 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994263.394830001 | 2105452.9722599997 | 37.760842992730105 | -122.462957472303 | (37.7608429927301, -122.462957472303) | |||
| 69462 | 69462 | 119126 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 601 46th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5981603.35382 | 2111608.79109 | 37.777007725640104 | -122.507198870746 | (37.7770077256401, -122.507198870746) | |||
| 69603 | 69603 | 207236 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1x Minerva St | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5996258.071 | 2089000.15441 | 37.7157822655196 | -122.45487001484301 | (37.7157822655196, -122.454870014843) | |||
| 70030 | 70030 | 177026 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Sweeny St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6008206.81715 | 2094351.9900900002 | 37.7311554564421 | -122.41394787781601 | (37.7311554564421, -122.413947877816) | |||
| 70085 | 70085 | 207207 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Foerster St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5998074.45641 | 2093829.28565 | 37.7291459626917 | -122.44893943651199 | (37.7291459626917, -122.448939436512) | |||
| 70124 | 70124 | 207280 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 595 Darien Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993435.14458 | 2094919.26873 | 37.731872375313294 | -122.46505692344299 | (37.7318723753133, -122.465056923443) | |||
| 70323 | 70323 | 207350 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 618 Mangels Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997300.95019 | 2095282.96772 | 37.7330931600175 | -122.451718319154 | (37.7330931600175, -122.451718319154) | |||
| 70570 | 70570 | 207314 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1570 07th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994021.19813 | 2104903.51705 | 37.759320377550395 | -122.46375523571999 | (37.7593203775504, -122.46375523572) | |||
| 70722 | 70722 | 207218 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 147 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5999123.66307 | 2093458.3174700001 | 37.7281873186821 | -122.445285594449 | (37.7281873186821, -122.445285594449) | ||||
| 70729 | 70729 | 177010 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002632.11132 | 2094355.1655700002 | 37.73084950708879 | -122.433220824095 | (37.7308495070888, -122.433220824095) | |||
| 71088 | 71088 | 207340 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 538 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998514.78137 | 2095005.5292 | 37.732400822345205 | -122.44750183606001 | (37.7324008223452, -122.44750183606) | ||||
| 71287 | 71287 | 207201 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998416.44412 | 2094074.8160299999 | 37.7298396835571 | -122.447774830644 | (37.7298396835571, -122.447774830644) | |||
| 71533 | 71533 | 117965 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4545 Anza St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5984581.6879 | 2111733.75019 | 37.7775257966351 | -122.496905272636 | (37.7775257966351, -122.496905272636) | |||
| 72391 | 72391 | 176996 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Morse St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5998705.41323 | 2087176.369 | 37.7109146507487 | -122.44627978598999 | (37.7109146507487, -122.44627978599) | |||
| 72894 | 72894 | 207221 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 125 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5999184.61823 | 2093461.48115 | 37.7281994846941 | -122.44507509826401 | (37.7281994846941, -122.445075098264) | ||||
| 73076 | 73076 | 207146 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1440 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5991174.2447 | 2105585.9909099997 | 37.7610298052998 | -122.47365107156601 | (37.7610298052998, -122.473651071566) | |||
| 73346 | 73346 | 226593 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4301 26th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6001851.9880099995 | 2100572.11343 | 37.7478755125637 | -122.43636260477301 | (37.7478755125637, -122.436362604773) | |||
| 73643 | 73643 | 207345 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 628 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998591.38299 | 2094890.7633 | 37.732090079596794 | -122.44722875061399 | (37.7320900795968, -122.447228750614) | |||
| 73666 | 73666 | 184518 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4108 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982209.6889 | 2101522.5062 | 37.7493493689338 | -122.504354014902 | (37.7493493689338, -122.504354014902) | |||
| 73802 | 73802 | 207144 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1617 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991126.06401 | 2104353.71257 | 37.757643505256205 | -122.473727808906 | (37.7576435052562, -122.473727808906) | |||
| 73920 | 73920 | 207210 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 146 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999095.98576 | 2093806.86087 | 37.7291427575169 | -122.445406326639 | (37.7291427575169, -122.445406326639) | ||||
| 73988 | 73988 | 207312 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996777.2193 | 2094487.3918299999 | 37.730878690977704 | -122.45347156457399 | (37.7308786909777, -122.453471564574) | |||
| 74258 | 74258 | 207354 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 236 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996818.09015 | 2094943.97322 | 37.732134696764 | -122.453363219655 | (37.732134696764, -122.453363219655) |
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");