Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23605 | 23605 | 207223 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 137 Marston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5998550.7404 | 2093191.23092 | 37.7274212410962 | -122.447246987057 | (37.7274212410962, -122.447246987057) | |||
| 23659 | 23659 | 207211 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Judson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5997557.05916 | 2093521.06587 | 37.7282700608095 | -122.450705899268 | (37.7282700608095, -122.450705899268) | |||
| 25168 | 25168 | 118098 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3619 Balboa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5984331.597680001 | 2111046.0676700003 | 37.7756229611607 | -122.497719616092 | (37.7756229611607, -122.497719616092) | |||
| 26959 | 26959 | 176992 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Morse St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998628.254290001 | 2087146.50399 | 37.7108282412039 | -122.446544317082 | (37.7108282412039, -122.446544317082) | |||
| 27028 | 27028 | 207203 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 659 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5997731.1976 | 2094979.2607200001 | 37.732283884374 | -122.450208962681 | (37.732283884374, -122.450208962681) | |||
| 27819 | 27819 | 207168 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 520 Judson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996915.754480001 | 2093635.86285 | 37.728548535870104 | -122.45293118715 | (37.7285485358701, -122.45293118715) | |||
| 29133 | 29133 | 207198 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 580 Hearst Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997541.97184 | 2094417.04598 | 37.7307293459865 | -122.450822633076 | (37.7307293459865, -122.450822633076) | |||
| 29724 | 29724 | 207328 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 400x Marietta Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5999485.75789 | 2097034.69989 | 37.738027887567796 | -122.444290723035 | (37.7380278875678, -122.444290723035) | |||
| 32289 | 32289 | 207308 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 40 Hazelwood Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5996630.86084 | 2093949.68597 | 37.7293938887121 | -122.453938729108 | (37.7293938887121, -122.453938729108) | |||
| 33948 | 33948 | 37792 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 310 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 5 | Permit Number 40120 | 6009317.62312 | 2092827.34387 | 37.727031425442 | -122.410000018602 | (37.727031425442, -122.410000018602) | |
| 34210 | 34210 | 177025 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 300 Hamilton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009309.80145 | 2092849.9581799998 | 37.727093081168604 | -122.410028653892 | (37.7270930811686, -122.410028653892) | |||
| 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) | |||
| 34562 | 34562 | 34814 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 485 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 5 | Permit Number 38705 | 5983755.240019999 | 2112575.55408 | 37.779788683805705 | -122.49982642326599 | (37.7797886838057, -122.499826423266) | |
| 34662 | 34662 | 117967 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4545 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5984550.3085 | 2111733.18458 | 37.7775224048599 | -122.497013781042 | (37.7775224048599, -122.497013781042) | |||
| 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) | |||
| 37609 | 37609 | 207322 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 734 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998892.3170300005 | 2095965.24165 | 37.7350575338629 | -122.44626562436001 | (37.7350575338629, -122.44626562436) | |||
| 37967 | 37967 | 117755 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 406 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5983780.251180001 | 2113048.87393 | 37.781089749801204 | -122.499774894099 | (37.7810897498012, -122.499774894099) | |||
| 38221 | 38221 | 177011 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002637.06105 | 2094341.00901 | 37.73081091718 | -122.433202700959 | (37.73081091718, -122.433202700959) | |||
| 39601 | 39601 | 176994 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Morse St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998658.093780001 | 2087156.70124 | 37.7108579449184 | -122.446441918457 | (37.7108579449184, -122.446441918457) | |||
| 40455 | 40455 | 177006 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 271 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009831.15293 | 2088401.27476 | 37.7149071271443 | -122.40791276406 | (37.7149071271443, -122.40791276406) | |||
| 42179 | 42179 | 207304 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 53 Hazelwood Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5996585.7495 | 2094006.0145 | 37.72954596675461 | -122.454098749052 | (37.7295459667546, -122.454098749052) | |||
| 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) | |||
| 46244 | 46244 | 250337 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 21 25th Ave North | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5987995.71435 | 2115876.11718 | 37.7890990187437 | -122.485399212222 | (37.7890990187437, -122.485399212222) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 59008 | 59008 | 38198 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 885 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 5 | Permit Number 40325 | 6011564.90625 | 2090771.94385 | 37.721513417393496 | -122.402086713936 | (37.7215134173935, -122.402086713936) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 67611 | 67611 | 43211 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 353 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 5 | Permit Number 43002 | 6008758.60086 | 2094527.34935 | 37.73166792973 | -122.412052645639 | (37.73166792973, -122.412052645639) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 75032 | 75032 | 207204 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 655 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5997746.28105 | 2094978.11771 | 37.7322816091084 | -122.450156733641 | (37.7322816091084, -122.450156733641) | |||
| 75227 | 75227 | 185264 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2147 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986264.4244 | 2097520.2042 | 37.7385977678327 | -122.490038499473 | (37.7385977678327, -122.490038499473) | |||
| 75474 | 75474 | 207342 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 538 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998499.20735 | 2095008.2855900002 | 37.7324075007117 | -122.447555877206 | (37.7324075007117, -122.447555877206) | ||||
| 75859 | 75859 | 207224 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 49 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5998734.87043 | 2093158.9272 | 37.727343062112396 | -122.446608128468 | (37.7273430621124, -122.446608128468) | |||
| 130678 | 130678 | 116712 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1400 Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6000214.6483 | 2113835.6397 | 37.784200680215605 | -122.44297678993999 | (37.7842006802156, -122.44297678994) | |||
| 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) | |||
| 133243 | 133243 | 226583 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 65 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005675.46056 | 2097328.12115 | 37.7391847556639 | -122.422910674207 | (37.7391847556639, -122.422910674207) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 137313 | 137313 | 207334 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 27 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999906.0481 | 2095478.3381 | 37.7337784541927 | -122.44272585413799 | (37.7337784541927, -122.442725854138) | |||
| 138152 | 138152 | 226584 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 116 Franconia St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6010066.87681 | 2099747.40872 | 37.746074405213704 | -122.40789762220301 | (37.7460744052137, -122.407897622203) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 154723 | 154723 | 43162 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 221 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 5 | Permit Number 42972 | 6005660.57006 | 2092632.04042 | 37.726289518943 | -122.42262853710301 | (37.726289518943, -122.422628537103) | |
| 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) | |||
| 156798 | 156798 | 207352 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 630 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5997888.696769999 | 2095016.78994 | 37.732395942619 | -122.44966715802299 | (37.732395942619, -122.449667158023) | ||||
| 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) | |||
| 158421 | 158421 | 207171 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 240 Stillings Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999241.01629 | 2095793.3410200002 | 37.7346054437908 | -122.445047696791 | (37.7346054437908, -122.445047696791) | |||
| 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) | |||
| 158840 | 158840 | 35127 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 775 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 5 | Permit Number 38661 | 6001730.34361 | 2089436.21425 | 37.71729198082 | -122.43598653257799 | (37.71729198082, -122.435986532578) | |
| 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) | |||
| 163271 | 163271 | 32472 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 117 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 5 | Permit Number 36980 | 6000335.64895 | 2106187.4701799997 | 37.7632076377424 | -122.442009017113 | (37.7632076377424, -122.442009017113) | |
| 165783 | 165783 | 207222 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 147 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5998739.609180001 | 2093444.36182 | 37.728127069498 | -122.44661227434999 | (37.728127069498, -122.44661227435) | |||
| 168241 | 168241 | 207362 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 452 Circular Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999510.56804 | 2093546.04073 | 37.7284502642649 | -122.44395435411501 | (37.7284502642649, -122.443954354115) | |||
| 169893 | 169893 | 207213 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Judson Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5997585.68903 | 2093520.71926 | 37.728270747876394 | -122.45060690011499 | (37.7282707478764, -122.450606900115) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 175637 | 175637 | 129490 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2536 Baker St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5999691.42103 | 2117587.23687 | 37.794471737733105 | -122.44505675927401 | (37.7944717377331, -122.445056759274) | |||
| 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) | |||
| 177328 | 177328 | 226612 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 49 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008238.81555 | 2100053.8415599996 | 37.7468132873058 | -122.41424051718 | (37.7468132873058, -122.41424051718) | |||
| 179189 | 179189 | 207142 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1419 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5991123.51551 | 2105737.38087 | 37.7614425437634 | -122.473837564856 | (37.7614425437634, -122.473837564856) | |||
| 179463 | 179463 | 207199 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 580 Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997518.57205 | 2094417.76245 | 37.7307299736956 | -122.450903581047 | (37.7307299736956, -122.450903581047) | |||
| 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) | |||
| 183532 | 183532 | 227705 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1552 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6005224.91638 | 2099272.18009 | 37.744497267738105 | -122.424606707457 | (37.7444972677381, -122.424606707457) | |||
| 184226 | 184226 | 139035 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000637.7747 | 2113910.8003 | 37.7844311670031 | -122.441518322309 | (37.7844311670031, -122.441518322309) |
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");