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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44944 | 44944 | 176990 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998584.85135 | 2087137.0809 | 37.7107998882796 | -122.446693649496 | (37.7107998882796, -122.446693649496) | |||
| 46658 | 46658 | 207264 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 319 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993222.99582 | 2089325.40947 | 37.716500767187 | -122.465384161548 | (37.716500767187, -122.465384161548) | |||
| 47578 | 47578 | 226625 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 311 Collingwood St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002111.00363 | 2104000.9193700003 | 37.7573049096042 | -122.43571221954299 | (37.7573049096042, -122.435712219543) | |||
| 48128 | 48128 | 207250 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 571 Arch St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992722.93824 | 2090965.0292099998 | 37.7209739131985 | -122.467231741345 | (37.7209739131985, -122.467231741345) | |||
| 50277 | 50277 | 226617 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 58 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005670.60555 | 2097390.14395 | 37.739354782382996 | -122.422931867621 | (37.739354782383, -122.422931867621) | |||
| 51445 | 51445 | 207262 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 510 Ramsell St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993010.6580300005 | 2090589.3329599998 | 37.7199589473287 | -122.466209899286 | (37.7199589473287, -122.466209899286) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 74649 | 74649 | 207296 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 217 Colon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5996041.08515 | 2094289.8634799998 | 37.7302941010767 | -122.456002210028 | (37.7302941010767, -122.456002210028) | |||
| 74830 | 74830 | 207158 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 237 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992472.8250400005 | 2097675.82148 | 37.739385640835295 | -122.468584327098 | (37.7393856408353, -122.468584327098) | |||
| 76051 | 76051 | 207298 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 111 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996286.51947 | 2094316.70178 | 37.73038187671379 | -122.45515565391099 | (37.7303818767138, -122.455155653911) | |||
| 91369 | 91369 | 177012 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002642.0398 | 2094328.25695 | 37.730776185352504 | -122.433184577831 | (37.7307761853525, -122.433184577831) | |||
| 117656 | 117656 | 117966 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4545 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5984567.33243 | 2111733.70358 | 37.7775248274666 | -122.496954928801 | (37.7775248274666, -122.496954928801) | |||
| 123823 | 123823 | 207323 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 734 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998893.471580001 | 2095962.39727 | 37.7350497898071 | -122.446261428139 | (37.7350497898071, -122.446261428139) | |||
| 125304 | 125304 | 177013 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002644.59595 | 2094315.3545 | 37.7307409031583 | -122.433174819278 | (37.7307409031583, -122.433174819278) | |||
| 129805 | 129805 | 226626 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 310 Liberty St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6004198.11867 | 2103939.92108 | 37.757255752658295 | -122.42848980825899 | (37.7572557526583, -122.428489808259) | |||
| 129828 | 129828 | 226614 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 322 Elsie St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006361.987980001 | 2097015.1421299998 | 37.738364099132795 | -122.42051475707399 | (37.7383640991328, -122.420514757074) | |||
| 130433 | 130433 | 207283 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 84 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993642.59329 | 2093470.80397 | 37.7279072068291 | -122.464234616632 | (37.7279072068291, -122.464234616632) | |||
| 130898 | 130898 | 207284 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 84 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993637.22552 | 2093458.84875 | 37.727874071330106 | -122.464252305417 | (37.7278740713301, -122.464252305417) | |||
| 131369 | 131369 | 207156 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2426 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991402.6198 | 2098893.19012 | 37.7426663442825 | -122.472373311184 | (37.7426663442825, -122.472373311184) | |||
| 131611 | 131611 | 207292 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 965 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994659.45419 | 2093917.36528 | 37.729191913559205 | -122.460751677241 | (37.7291919135592, -122.460751677241) | |||
| 131761 | 131761 | 207244 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 246 Monticello St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5991705.04474 | 2090167.4544799998 | 37.7187251566245 | -122.47069219949199 | (37.7187251566245, -122.470692199492) | |||
| 133337 | 133337 | 177023 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1628 Burrows St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006643.54009 | 2092125.7831400002 | 37.7249548539585 | -122.419194556805 | (37.7249548539585, -122.419194556805) | |||
| 133706 | 133706 | 207160 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 384 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992464.42361 | 2094258.2447 | 37.7300013456858 | -122.46836480621799 | (37.7300013456858, -122.468364806218) | |||
| 133764 | 133764 | 207351 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 662 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5997053.67683 | 2095305.7853299999 | 37.7331416469589 | -122.45257485054701 | (37.7331416469589, -122.452574850547) | |||
| 133848 | 133848 | 207319 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995627.90301 | 2100275.99182 | 37.7467068156796 | -122.45786363851299 | (37.7467068156796, -122.457863638513) | |||
| 133915 | 133915 | 226620 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 688 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007284.68348 | 2103336.34747 | 37.7557726618001 | -122.417772455244 | (37.7557726618001, -122.417772455244) | |||
| 134189 | 134189 | 226586 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 195 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006490.36158 | 2105010.39 | 37.760324461620705 | -122.420638312212 | (37.7603244616207, -122.420638312212) | |||
| 134488 | 134488 | 207256 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 545 Arch St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992721.58386 | 2090800.7544 | 37.720522776379596 | -122.467224484746 | (37.7205227763796, -122.467224484746) | |||
| 135470 | 135470 | 207277 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 236 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992402.86272 | 2097663.9953099997 | 37.7393491274725 | -122.46882536342 | (37.7393491274725, -122.46882536342) | |||
| 136074 | 136074 | 207276 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 350 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5992917.36629 | 2099685.98724 | 37.7449307166945 | -122.467193430259 | (37.7449307166945, -122.467193430259) | |||
| 137140 | 137140 | 207254 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 559 Arch St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992720.910730001 | 2090888.5643799999 | 37.720763842354 | -122.467233192875 | (37.720763842354, -122.467233192875) | |||
| 137436 | 137436 | 177005 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 362 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009172.07817 | 2088408.58756 | 37.714890285531794 | -122.410191328669 | (37.7148902855318, -122.410191328669) | |||
| 137737 | 137737 | 207316 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 540 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991234.77071 | 2097748.67502 | 37.739514082899795 | -122.47287024148899 | (37.7395140828998, -122.472870241489) | |||
| 138093 | 138093 | 207251 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 567 Arch St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5992723.294480001 | 2090942.0276900001 | 37.720910777190795 | -122.46722883836 | (37.7209107771908, -122.46722883836) | |||
| 147662 | 147662 | 207305 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 45 Hazelwood Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5996586.90838 | 2093990.0061299999 | 37.7295020780524 | -122.454093586973 | (37.7295020780524, -122.454093586973) | |||
| 147909 | 147909 | 226624 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 366 Eureka St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6001461.5255 | 2103604.00302 | 37.75617816071271 | -122.437929936033 | (37.7561781607127, -122.437929936033) | |||
| 149202 | 149202 | 207311 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 40 Hazelwood Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996623.9577 | 2093958.7514099998 | 37.729418384438894 | -122.453963248219 | (37.7294183844389, -122.453963248219) | |||
| 149640 | 149640 | 207307 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 40 Hazelwood Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5996632.29133 | 2093946.6824400001 | 37.7293857237559 | -122.453933566973 | (37.7293857237559, -122.453933566973) | |||
| 149892 | 149892 | 119481 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985644.19758 | 2112999.51907 | 37.781063436855604 | -122.493323027528 | (37.7810634368556, -122.493323027528) | |||
| 150214 | 150214 | 207343 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 543 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998102.37114 | 2095220.43245 | 37.732967318787296 | -122.448943103064 | (37.7329673187873, -122.448943103064) | |||
| 150633 | 150633 | 207151 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 223 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994241.91079 | 2105279.16697 | 37.760364530923205 | -122.46301916490299 | (37.7603645309232, -122.463019164903) | |||
| 151291 | 151291 | 246438 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 498 Duncan St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 3ft | 6003357.50799 | 2099800.56839 | 37.745842459268296 | -122.431101528529 | (37.7458424592683, -122.431101528529) | |||
| 152673 | 152673 | 226615 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 10 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005546.7514 | 2097096.0791900002 | 37.7385403572369 | -122.423339202051 | (37.7385403572369, -122.423339202051) | |||
| 153631 | 153631 | 207288 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 80 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993609.88258 | 2093413.56437 | 37.7277481554518 | -122.46434354343599 | (37.7277481554518, -122.464343543436) | |||
| 153744 | 153744 | 207155 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 606 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990983.67458 | 2099779.50243 | 37.7450756729987 | -122.473886535662 | (37.7450756729987, -122.473886535662) | |||
| 154080 | 154080 | 207315 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1570 07th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994029.69886 | 2104725.63145 | 37.7588324395785 | -122.463712925326 | (37.7588324395785, -122.463712925326) | |||
| 154647 | 154647 | 207152 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 731 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992245.611880001 | 2105887.84431 | 37.761920604463796 | -122.469967690366 | (37.7619206044638, -122.469967690366) | |||
| 155074 | 155074 | 207225 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 272 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996551.89898 | 2091549.3096 | 37.7227984982343 | -122.454038414459 | (37.7227984982343, -122.454038414459) | |||
| 155331 | 155331 | 207287 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 80 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993617.196719999 | 2093428.42881 | 37.7277893911619 | -122.464319337265 | (37.7277893911619, -122.464319337265) | |||
| 155540 | 155540 | 226607 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 205 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997675.15136 | 2106444.92247 | 37.7637625662095 | -122.45122931550699 | (37.7637625662095, -122.451229315507) | |||
| 155804 | 155804 | 226585 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 257 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007206.23744 | 2105617.20797 | 37.762030962987296 | -122.41820544911998 | (37.7620309629873, -122.41820544912) | |||
| 156004 | 156004 | 207247 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 495 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992207.674790001 | 2091176.35111 | 37.721524393612 | -122.46902820910299 | (37.721524393612, -122.469028209103) | |||
| 156794 | 156794 | 207268 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 321 Shields St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993118.56975 | 2089825.8623400002 | 37.7178688671261 | -122.46578144695299 | (37.7178688671261, -122.465781446953) | |||
| 157438 | 157438 | 177007 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 216 Saint Charles Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992028.26989 | 2086999.54978 | 37.710045543251205 | -122.469344489883 | (37.7100455432512, -122.469344489883) | |||
| 158423 | 158423 | 207267 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 800 Shields St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5991908.73686 | 2089873.18907 | 37.71792895264 | -122.469966710089 | (37.71792895264, -122.469966710089) | |||
| 158570 | 158570 | 176995 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Morse St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998691.25418 | 2087172.2379400001 | 37.7109024991335 | -122.44632842581301 | (37.7109024991335, -122.446328425813) | |||
| 159331 | 159331 | 120006 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 658 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5986941.43179 | 2111450.92852 | 37.7768872385676 | -122.488721446125 | (37.7768872385676, -122.488721446125) | |||
| 161773 | 161773 | 226598 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4222 26th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002345.605769999 | 2100643.12019 | 37.7480985156327 | -122.434660776296 | (37.7480985156327, -122.434660776296) | |||
| 162170 | 162170 | 226587 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 352 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008561.06519 | 2106374.04513 | 37.7641852304909 | -122.413573140196 | (37.7641852304909, -122.413573140196) | |||
| 162174 | 162174 | 226611 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 80 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008212.2428 | 2099629.64736 | 37.745647051868 | -122.414302395044 | (37.745647051868, -122.414302395044) | |||
| 163615 | 163615 | 207164 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Laguna Honda Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995446.92636 | 2100264.89737 | 37.7466659540754 | -122.45848863046001 | (37.7466659540754, -122.45848863046) | |||
| 163785 | 163785 | 207274 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 315 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993100.15501 | 2099667.06703 | 37.7448893164068 | -122.466560010732 | (37.7448893164068, -122.466560010732) |
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");