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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43733 | 43733 | 207159 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 345 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992101.70168 | 2094641.4985900002 | 37.7310327079752 | -122.469646658486 | (37.7310327079752, -122.469646658486) | |||
| 166192 | 166192 | 207245 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 495 Ralston St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992206.61176 | 2091125.8340200002 | 37.7213856246322 | -122.469028209083 | (37.7213856246322, -122.469028209083) | |||
| 187054 | 187054 | 207246 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 495 Ralston St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992206.82998 | 2091154.32928 | 37.7214638782474 | -122.469029527495 | (37.7214638782474, -122.469029527495) | |||
| 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) | |||
| 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) | |||
| 136966 | 136966 | 207147 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1341 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5992375.35662 | 2106303.37048 | 37.7630690288235 | -122.469549207953 | (37.7630690288235, -122.469549207953) | |||
| 117257 | 117257 | 108497 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1339 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773641 | 5992378.78756 | 2106335.85187 | 37.7631584124216 | -122.46953970622101 | (37.7631584124216, -122.469539706221) |
| 177051 | 177051 | 207148 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1210 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992391.03537 | 2107185.15973 | 37.7654910946525 | -122.469559175111 | (37.7654910946525, -122.469559175111) | |||
| 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) | |||
| 103991 | 103991 | 100461 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 236 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992450.0 | 2097712.0 | 37.7394836593705 | -122.468665877071 | (37.7394836593705, -122.468665877071) | |||||
| 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) | |||
| 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) | |||
| 34491 | 34491 | 207157 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 237 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992487.55481 | 2097691.20205 | 37.7394287228632 | -122.468534517269 | (37.7394287228632, -122.468534517269) | |||
| 57870 | 57870 | 37592 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 639 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 4 | Permit Number 40020 | 5992524.028 | 2111081.26309 | 37.776196436129396 | -122.46938280754699 | (37.7761964361294, -122.469382807547) | |
| 140281 | 140281 | 108494 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 734 11th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773785 | 5992601.40555 | 2110422.43493 | 37.7743919431152 | -122.469067180848 | (37.7743919431152, -122.469067180848) |
| 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) | |||
| 176364 | 176364 | 207259 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 531 Arch St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992719.90357 | 2090700.8696700002 | 37.720248420215 | -122.467223034109 | (37.720248420215, -122.467223034109) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 39672 | 39672 | 207255 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 551 Arch St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992722.91506 | 2090824.1387 | 37.72058706082171 | -122.467221582632 | (37.7205870608217, -122.467221582632) | |||
| 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) | |||
| 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) | |||
| 178299 | 178299 | 207249 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 581 Arch St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992725.89958 | 2091026.00542 | 37.7211415099655 | -122.467225936253 | (37.7211415099655, -122.467225936253) | |||
| 162804 | 162804 | 207261 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 274 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5992740.415519999 | 2089036.58294 | 37.715679875902296 | -122.467031197028 | (37.7156798759023, -122.467031197028) | |||
| 37229 | 37229 | 207260 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 282 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5992744.11171 | 2089090.22365 | 37.7158273737034 | -122.46702231894 | (37.7158273737034, -122.46702231894) | |||
| 174314 | 174314 | 207252 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 560 Arch St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992752.3271699995 | 2090925.11248 | 37.7208660080514 | -122.467127252727 | (37.7208660080514, -122.467127252727) | |||
| 186952 | 186952 | 207258 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 532 Arch St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992753.93277 | 2090721.89417 | 37.7203081126976 | -122.46710693523998 | (37.7203081126976, -122.46710693524) | |||
| 171030 | 171030 | 207253 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 556 Arch St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992754.265459999 | 2090897.47883 | 37.7207902446595 | -122.46711854461 | (37.7207902446595, -122.46711854461) | |||
| 24738 | 24738 | 207248 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 574 Arch St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992756.55156 | 2091026.1972 | 37.7211438059241 | -122.46711999608401 | (37.7211438059241, -122.467119996084) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 136134 | 136134 | 207263 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 582 Ramsell St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5993025.1293 | 2091125.2182900002 | 37.7214311932731 | -122.46619880075899 | (37.7214311932731, -122.466198800759) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 100854 | 100854 | 19333 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 325 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5993178.445205901 | 2089816.9668961002 | 37.7178478960527 | -122.46557383978 | (37.7178478960527, -122.46557383978) | |||
| 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) | |||
| 173504 | 173504 | 207289 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 81 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993404.50324 | 2093508.25253 | 37.727996305369395 | -122.465060411924 | (37.7279963053694, -122.465060411924) | |||
| 31710 | 31710 | 207290 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 81 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993410.050430001 | 2093515.91328 | 37.7280176597738 | -122.465041791443 | (37.7280176597738, -122.465041791443) | |||
| 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) | |||
| 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) | |||
| 65074 | 65074 | 67318 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 666 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 9 | Permit Number 30800 | 5993501.91813 | 2110961.7349 | 37.7759247065994 | -122.46599136010799 | (37.7759247065994, -122.465991360108) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 179484 | 179484 | 207285 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 84 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993629.18842 | 2093448.0222200002 | 37.7278438810755 | -122.464279303953 | (37.7278438810755, -122.464279303953) | |||
| 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) | |||
| 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) | |||
| 67927 | 67927 | 41944 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 567 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 7 | Permit Number 42302 | 5993743.34162 | 2111650.50193 | 37.7778298007164 | -122.465206260397 | (37.7778298007164, -122.465206260397) | |
| 186557 | 186557 | 207266 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 450 Bright St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 5993794.13591 | 2090181.7036599999 | 37.7188848681307 | -122.463472140835 | (37.7188848681307, -122.463472140835) | |||
| 170261 | 170261 | 207163 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1557 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993970.96623 | 2104931.68714 | 37.7593948306232 | -122.46393100551902 | (37.7593948306232, -122.463931005519) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 150333 | 150333 | 207234 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 422 Orizaba Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5994046.18721 | 2089200.86778 | 37.716206246401896 | -122.462529797908 | (37.7162062464019, -122.462529797908) | |||
| 48704 | 48704 | 207278 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 575 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994134.4568 | 2099399.45739 | 37.7442141593615 | -122.462964201952 | (37.7442141593615, -122.462964201952) | |||
| 158267 | 158267 | 207227 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 314 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 5994211.43434 | 2092004.54355 | 37.7239139822334 | -122.46216184121799 | (37.7239139822334, -122.462161841218) | |||
| 173676 | 173676 | 207279 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 186 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5994221.53046 | 2099188.36085 | 37.743639556416504 | -122.462647812372 | (37.7436395564165, -122.462647812372) | |||
| 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) | |||
| 42942 | 42942 | 207270 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994256.24514 | 2105719.06013 | 37.7615731891695 | -122.463001505824 | (37.7615731891695, -122.463001505824) | |||
| 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) | |||
| 61495 | 61495 | 41940 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 642 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767709 | 5994437.32362 | 2111135.33206 | 37.7764552768418 | -122.46276817075301 | (37.7764552768418, -122.462768170753) |
| 131950 | 131950 | 71605 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 178 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994512.31694 | 2086511.3564 | 37.7088483153534 | -122.46072384594 | (37.7088483153534, -122.46072384594) | ||
| 161558 | 161558 | 123521 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2808 Fulton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5994656.80881 | 2110239.6852599997 | 37.7740087073423 | -122.46194395210199 | (37.7740087073423, -122.461943952102) | |||
| 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) | |||
| 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) | |||
| 75063 | 75063 | 123520 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2808 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5994672.01997 | 2110241.5879900004 | 37.774014807441795 | -122.461891472498 | (37.7740148074418, -122.461891472498) | |||
| 30981 | 30981 | 71589 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 177 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 8 | 5994699.454059999 | 2086647.11862 | 37.7092318519263 | -122.460086907391 | (37.7092318519263, -122.460086907391) | ||
| 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) | |||
| 185209 | 185209 | 207231 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 250 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5994770.3606900005 | 2090247.29491 | 37.7191211640843 | -122.46010248996099 | (37.7191211640843, -122.460102489961) | |||
| 137162 | 137162 | 207228 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1018 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995061.38916 | 2090705.2918200002 | 37.720395449464796 | -122.459129669002 | (37.7203954494648, -122.459129669002) | |||
| 162797 | 162797 | 207229 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1162 Capitol Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 1ft | 5995089.6840699995 | 2091648.0085099998 | 37.7229855509323 | -122.459100089412 | (37.7229855509323, -122.459100089412) | |||
| 43666 | 43666 | 207282 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 163 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995118.51339 | 2093829.85755 | 37.7289780403896 | -122.459158347475 | (37.7289780403896, -122.459158347475) | |||
| 167231 | 167231 | 207166 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 174 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5995172.17423 | 2097043.6524099999 | 37.737805421392295 | -122.459205466579 | (37.7378054213923, -122.459205466579) | |||
| 181601 | 181601 | 207172 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995322.34396 | 2098236.54105 | 37.741089431634705 | -122.458772597671 | (37.7410894316347, -122.458772597671) | |||
| 42221 | 42221 | 207173 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5995323.713819999 | 2098239.63146 | 37.7410979958728 | -122.45876808490601 | (37.7410979958728, -122.458768084906) | |||
| 152617 | 152617 | 207174 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5995326.26295 | 2098236.71907 | 37.741090145688894 | -122.458759060198 | (37.7410901456889, -122.458759060198) | |||
| 151636 | 151636 | 207176 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995327.39898 | 2098241.1137 | 37.741102277551896 | -122.45875545032301 | (37.7411022775519, -122.458755450323) | |||
| 160296 | 160296 | 207175 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995328.909969999 | 2098238.4831 | 37.7410951414231 | -122.458750035501 | (37.7410951414231, -122.458750035501) | |||
| 130565 | 130565 | 207178 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995329.77436 | 2098242.36362 | 37.7411058460538 | -122.45874732764 | (37.7411058460538, -122.45874732764) | |||
| 76247 | 76247 | 207177 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5995331.55155 | 2098239.9871900002 | 37.7410994231129 | -122.458741010797 | (37.7410994231129, -122.458741010797) | |||
| 174436 | 174436 | 207180 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5995332.94317 | 2098244.11673 | 37.7411108417945 | -122.458736498001 | (37.7411108417945, -122.458736498001) | |||
| 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) | |||
| 164704 | 164704 | 207182 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5995335.09015 | 2098246.93081 | 37.7411186919637 | -122.458729278246 | (37.7411186919637, -122.458729278246) | |||
| 146496 | 146496 | 207181 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5995335.301969999 | 2098244.58715 | 37.7411122690279 | -122.458728376224 | (37.7411122690279, -122.458728376224) | |||
| 25493 | 25493 | 207183 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995337.35676 | 2098242.98475 | 37.7411079873364 | -122.458721155571 | (37.7411079873364, -122.458721155571) | |||
| 132193 | 132193 | 207162 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 509 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995343.73993 | 2092740.9516 | 37.7260011126479 | -122.45830094463699 | (37.7260011126479, -122.458300944637) | |||
| 131833 | 131833 | 207161 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 509 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5995344.03835 | 2092755.21065 | 37.726040281721296 | -122.45830094463498 | (37.7260402817213, -122.458300944635) | |||
| 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) | |||
| 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) | |||
| 37320 | 37320 | 207230 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 437 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995450.98225 | 2091203.60917 | 37.7217860999295 | -122.457819021351 | (37.7217860999295, -122.457819021351) | |||
| 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) | |||
| 178122 | 178122 | 207321 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995570.24881 | 2100282.2016 | 37.746720553705 | -122.458063448969 | (37.746720553705, -122.458063448969) | |||
| 177980 | 177980 | 207320 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995605.62076 | 2100279.71012 | 37.746715745033 | -122.45794095682699 | (37.746715745033, -122.457940956827) | |||
| 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) | |||
| 175015 | 175015 | 207318 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5995646.386969999 | 2100270.85159 | 37.746693763801204 | -122.457799351359 | (37.7466937638012, -122.457799351359) |
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");