Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 168553 | 168553 | 191409 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1201 20th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 6014316.155809999 | 2104772.8809 | 37.760110260198495 | -122.39355571261999 | (37.7601102601985, -122.39355571262) | |||
| 57515 | 57515 | 67671 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1780 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1992 12:00:00 AM | 3 | Permit Number 31274 | 6014163.98928 | 2095111.2366 | 37.733572965423896 | -122.3934058406 | (37.7335729654239, -122.3934058406) | ||
| 62306 | 62306 | 52667 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226@ MARIPOSA Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2006 12:00:00 AM | 4 | Permit Number 48748 | 6013989.6640800005 | 2106012.3733900003 | 37.7634954891429 | -122.39477170574301 | (37.7634954891429, -122.394771705743) | ||
| 172268 | 172268 | 51484 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 63 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2005 12:00:00 AM | 3 | Permit Number 47795 | 6013789.90035 | 2095538.1570700002 | 37.7347244096963 | -122.394729070715 | (37.7347244096963, -122.394729070715) | ||
| 2094 | 2094 | 252881 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3536 Jennings St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 6013049.3063900005 | 2089480.54762 | 37.718050242412296 | -122.39686501810199 | (37.7180502424123, -122.396865018102) | ||||
| 149732 | 149732 | 191412 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1998 Revere Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6013024.42365 | 2095944.26783 | 37.7357969159791 | -122.39740407446001 | (37.7357969159791, -122.39740407446) | ||||
| 177917 | 177917 | 177001 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 154 Gillette Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6013011.29164 | 2086676.67622 | 37.7103492505861 | -122.396799956671 | (37.7103492505861, -122.396799956671) | |||
| 39694 | 39694 | 191411 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 462 Thornton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6012808.38143 | 2094403.0124599999 | 37.7315529172119 | -122.39804293216001 | (37.7315529172119, -122.39804293216) | |||
| 52623 | 52623 | 40627 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1118 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1999 12:00:00 AM | 7 | Permit Number 41628 | 6012181.11201 | 2103196.50544 | 37.755663016446 | -122.40082910469 | (37.755663016446, -122.40082910469) | ||
| 33451 | 33451 | 191410 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 777 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011870.78856 | 2104734.77484 | 37.7598694505299 | -122.402010442428 | (37.7598694505299, -122.402010442428) | |||
| 37571 | 37571 | 249979 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 13 Napier Ln | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6011649.02488 | 2120183.7348700003 | 37.802276317051 | -122.403864545927 | (37.802276317051, -122.403864545927) | |||
| 134174 | 134174 | 71938 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 384 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 4 | 6011634.93944 | 2119088.82833 | 37.7992691828709 | -122.403836198406 | (37.7992691828709, -122.403836198406) | ||
| 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) | |
| 67090 | 67090 | 177002 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 721 Goettingen St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6010761.087830001 | 2091324.0286400001 | 37.7229844303778 | -122.404904160394 | (37.7229844303778, -122.404904160394) | |||
| 167267 | 167267 | 227704 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 752 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010109.25034 | 2104766.0690599997 | 37.7598569040934 | -122.408104977977 | (37.7598569040934, -122.408104977977) | |||
| 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) | ||||
| 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) | |||
| 54128 | 54128 | 247978 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6009784.19004 | 2099413.44589 | 37.7451415861154 | -122.40885156275299 | (37.7451415861154, -122.408851562753) | ||||
| 43818 | 43818 | 68271 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 432 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2014 12:00:00 AM | 8 | Permit Number 771022 | 6009763.0481199995 | 2092384.22175 | 37.7258396600504 | -122.408428941659 | (37.7258396600504, -122.408428941659) | |
| 62912 | 62912 | 177003 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 746 Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009476.70201 | 2090586.0760400002 | 37.720886288652004 | -122.409291987754 | (37.720886288652, -122.409291987754) | |||
| 24966 | 24966 | 177004 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 746 Olmstead St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009463.77429 | 2090581.8029200002 | 37.720873831251104 | -122.40933637376999 | (37.7208738312511, -122.40933637377) | |||
| 176985 | 176985 | 34479 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 756 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 6 | 2x3 | Permit Number 38206 | 6009344.310190001 | 2119468.83873 | 37.800184363566 | -122.411789466237 | (37.800184363566, -122.411789466237) |
| 31691 | 31691 | 37790 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 310 Hamilton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 6 | Permit Number 40120 | 6009327.0324 | 2092792.3248 | 37.7269357978389 | -122.40996501967899 | (37.7269357978389, -122.409965019679) | |
| 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) | |||
| 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) | |||
| 148774 | 148774 | 68284 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 665 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2012 12:00:00 AM | 2 | Permit Number 769020 | 6009000.66847 | 2092983.8736400001 | 37.727443453448 | -122.411106781849 | (37.727443453448, -122.411106781849) | |
| 23484 | 23484 | 226621 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2498 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008827.83459 | 2103955.23814 | 37.7575587153899 | -122.412479469249 | (37.7575587153899, -122.412479469249) | |||
| 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) | |
| 67340 | 67340 | 246731 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Ripley St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6008584.453369999 | 2099107.91594 | 37.7442353941634 | -122.41297845991001 | (37.7442353941634, -122.41297845991) | |||
| 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) | |||
| 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) | |||
| 27878 | 27878 | 226609 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4005 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008395.3202599995 | 2096426.5831400002 | 37.736862424666704 | -122.413442851824 | (37.7368624246667, -122.413442851824) | |||
| 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) | |||
| 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) | |||
| 70030 | 70030 | 177026 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Sweeny St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6008206.81715 | 2094351.9900900002 | 37.7311554564421 | -122.41394787781601 | (37.7311554564421, -122.413947877816) | |||
| 70286 | 70286 | 42982 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 469 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 7 | Permit Number 42866 | 6008125.46012 | 2091747.89633 | 37.724000603132 | -122.414044988394 | (37.724000603132, -122.414044988394) | |
| 188359 | 188359 | 226618 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007884.76815 | 2100264.95114 | 37.7473730532316 | -122.415479726319 | (37.7473730532316, -122.415479726319) | |||
| 165558 | 165558 | 226619 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 220 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007856.36673 | 2100270.38915 | 37.747386388365705 | -122.415578321691 | (37.7473863883657, -122.415578321691) | |||
| 35498 | 35498 | 129498 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 855 Chestnut St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 6ft | 6007778.02269 | 2120584.45961 | 37.803159586216395 | -122.417288546245 | (37.8031595862164, -122.417288546245) | |||
| 5541 | 5541 | 81381 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 822 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2003 12:00:00 AM | 3x3 | 6007769.502 | 2114456.07002 | 37.7863320683098 | -122.41688358241899 | (37.7863320683098, -122.416883582419) | ||
| 162033 | 162033 | 129497 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 855 Chestnut St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 6007750.73846 | 2120580.85704 | 37.803148159410604 | -122.417382708871 | (37.8031481594106, -122.417382708871) | |||
| 179233 | 179233 | 129494 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 14 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6007592.27134 | 2119390.32661 | 37.7998703454969 | -122.417846649312 | (37.7998703454969, -122.417846649312) | ||||
| 166031 | 166031 | 129493 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 660 Bay St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6007573.98162 | 2121316.69576 | 37.8051586397294 | -122.418046578505 | (37.8051586397294, -122.418046578505) | |||
| 76063 | 76063 | 43217 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 45 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 4 | Permit Number 43007 | 6007564.041619999 | 2093733.91416 | 37.7294222326375 | -122.416126315492 | (37.7294222326375, -122.416126315492) | |
| 29934 | 29934 | 129496 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1101 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6007491.98236 | 2119862.03748 | 37.8011599004699 | -122.418227149773 | (37.8011599004699, -122.418227149773) | ||||
| 67219 | 67219 | 129495 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1136 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 6007480.35855 | 2119354.0245 | 37.7997643702969 | -122.418231335218 | (37.7997643702969, -122.418231335218) | |||
| 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) | |||
| 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) | |||
| 187623 | 187623 | 226610 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 187 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007102.33802 | 2097997.69789 | 37.7411036742096 | -122.418024617936 | (37.7411036742096, -122.418024617936) | |||
| 47695 | 47695 | 41753 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1644 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 4 | Permit Number 42182 | 6006856.27196 | 2116746.53055 | 37.7925696967985 | -122.42020574908899 | (37.7925696967985, -122.420205749089) | |
| 68271 | 68271 | 177021 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1538 Burrows St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6006775.37088 | 2092172.2563099999 | 37.72508988269 | -122.41874212587 | (37.72508988269, -122.41874212587) | |||
| 172270 | 172270 | 177022 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1628 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006681.726369999 | 2092138.2756599998 | 37.724991306183796 | -122.419063436538 | (37.7249913061838, -122.419063436538) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 63970 | 63970 | 227703 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 200 Kingston St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 8ft | 6006269.2438199995 | 2098023.2428599996 | 37.7411268910989 | -122.420906974789 | (37.7411268910989, -122.420906974789) | |||
| 184863 | 184863 | 226581 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 110 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006265.98852 | 2097494.29518 | 37.739674335789 | -122.420880685817 | (37.739674335789, -122.420880685817) | |||
| 161710 | 161710 | 43171 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 369 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 42980 | 6005855.02005 | 2091989.32837 | 37.7245357402195 | -122.42191069731501 | (37.7245357402195, -122.421910697315) | |
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 75893 | 75893 | 70393 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 63 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 6 | 6005472.78201 | 2093254.0606099998 | 37.7279868534853 | -122.42332190988998 | (37.7279868534853, -122.42332190989) | ||
| 76289 | 76289 | 250091 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1620 Gough St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6005381.25743 | 2115289.65998 | 37.7884862737667 | -122.425205641527 | (37.7884862737667, -122.425205641527) | |||
| 52088 | 52088 | 177024 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 11 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6005372.1534 | 2093185.8595 | 37.7277939084451 | -122.42366493918301 | (37.7277939084451, -122.423664939183) | ||||
| 168579 | 168579 | 43185 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 62 Valmar Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 7 | Permit Number 42987 | 6005330.72095 | 2092724.62519 | 37.7265251215375 | -122.42377539032101 | (37.7265251215375, -122.423775390321) | |
| 26934 | 26934 | 227699 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 194 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005300.17225 | 2100223.67209 | 37.7471140970563 | -122.42441415180099 | (37.7471140970563, -122.424414151801) | |||
| 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) | |||
| 148538 | 148538 | 42630 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2634 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42686 | 6004473.47116 | 2118249.9245 | 37.7965630841803 | -122.428557534402 | (37.7965630841803, -122.428557534402) | |
| 138075 | 138075 | 227702 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1201 San Jose Ave | 44 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004467.63219 | 2096063.7098700001 | 37.7356447417011 | -122.426996770882 | (37.7356447417011, -122.426996770882) | ||||
| 137148 | 137148 | 177027 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 127 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6004458.22384 | 2092761.54245 | 37.726577195866206 | -122.426794207588 | (37.7265771958662, -122.426794207588) | |||
| 60961 | 60961 | 43315 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 259 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 4 | Permit Number 43078 | 6004448.9414 | 2091752.36291 | 37.72380568677679 | -122.426754460261 | (37.7238056867768, -122.426754460261) | |
| 166542 | 166542 | 227701 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1201 San Jose Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004423.64254 | 2096032.0928 | 37.7355554408308 | -122.427146608748 | (37.7355554408308, -122.427146608748) | ||||
| 172685 | 172685 | 95711 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 277 Athens St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767467 | 6004408.66119 | 2091673.84489 | 37.7235878160995 | -122.426888112994 | (37.7235878160995, -122.426888112994) |
| 188791 | 188791 | 177020 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 235 Vienna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6004327.3137300005 | 2092022.6110200002 | 37.724540851055 | -122.42719414780599 | (37.724540851055, -122.427194147806) | ||||
| 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) | |||
| 63480 | 63480 | 177019 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 25 Madrid St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6004214.26597 | 2093378.8456299999 | 37.728258376811496 | -122.427681523704 | (37.7282583768115, -122.427681523704) | ||||
| 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) | |||
| 24701 | 24701 | 226623 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 80 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6004079.6139400005 | 2102598.16626 | 37.7535649035083 | -122.428803992713 | (37.7535649035083, -122.428803992713) | |||
| 31229 | 31229 | 226622 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6004058.08528 | 2103018.40015 | 37.7547175483925 | -122.42890840132799 | (37.7547175483925, -122.428908401328) | |||
| 180537 | 180537 | 226627 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 310 Liberty St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6004024.53424 | 2103933.71517 | 37.7572288881251 | -122.42908968844401 | (37.7572288881251, -122.429089688444) | |||
| 172332 | 172332 | 226576 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 350 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003654.19113 | 2098670.4327700003 | 37.7427561757625 | -122.42999503773501 | (37.7427561757625, -122.429995037735) | |||
| 183896 | 183896 | 226577 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 370 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6003494.445309999 | 2099538.93677 | 37.745131838370206 | -122.43060935295601 | (37.7451318383702, -122.430609352956) | |||
| 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) | |||
| 49438 | 49438 | 226600 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1463 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6003321.08221 | 2099703.03715 | 37.7455725970047 | -122.431220523219 | (37.7455725970047, -122.431220523219) | |||
| 181523 | 181523 | 226601 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1518 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003286.59929 | 2099387.77612 | 37.7447050093281 | -122.431317259697 | (37.7447050093281, -122.431317259697) | |||
| 30975 | 30975 | 227700 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 276 Bemis St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6002994.65302 | 2096282.17867 | 37.7361612061647 | -122.432105019051 | (37.7361612061647, -122.432105019051) | |||
| 59995 | 59995 | 226605 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 276 Bemis St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6002989.382569999 | 2096277.75645 | 37.7361487649474 | -122.432122925433 | (37.7361487649474, -122.432122925433) | |||
| 171392 | 171392 | 227706 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 580 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002827.0352300005 | 2098917.62308 | 37.743388023245394 | -122.432872760368 | (37.7433880232454, -122.432872760368) | |||
| 116109 | 116109 | 115788 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3628 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2016 12:00:00 AM | 3 | Permit Number 777599 | 6002731.19846 | 2106518.35077 | 37.764252377203 | -122.433747267607 | (37.764252377203, -122.433747267607) | |
| 102241 | 102241 | 121608 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 99X Lamartine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002710.0 | 2094292.0 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | ||||
| 117773 | 117773 | 121606 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 99X Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002710.0 | 2094292.0 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | ||||
| 140890 | 140890 | 121607 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 99X Lamartine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002710.0 | 2094292.0 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | ||||
| 44643 | 44643 | 177014 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 81 Lamartine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6002672.79218 | 2094323.6061200001 | 37.7307651596849 | -122.433077929925 | (37.7307651596849, -122.433077929925) | |||
| 184811 | 184811 | 177015 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 81 Lamartine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002665.86181 | 2094349.24813 | 37.730835173699106 | -122.433103720676 | (37.7308351736991, -122.433103720676) | |||
| 33843 | 33843 | 177016 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 81 Lamartine St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002658.8277900005 | 2094369.8725599998 | 37.7308914046921 | -122.433129511441 | (37.7308914046921, -122.433129511441) |
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");