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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1773 | 1773 | 251685 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 66 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996558.0 | 2090330.0 | 37.719450911009005 | -122.453929311088 | (37.719450911009, -122.453929311088) | ||||
| 1779 | 1779 | 251684 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 62 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996557.0 | 2090306.0 | 37.719384955305294 | -122.453931035382 | (37.7193849553053, -122.453931035382) | ||||
| 11700 | 11700 | 109233 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2570 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x9 | 5986169.5717 | 2097728.0842 | 37.7391630116047 | -122.490381738824 | (37.7391630116047, -122.490381738824) | |||
| 11855 | 11855 | 112294 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2606 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x2 | 5989896.9401 | 2097604.9354 | 37.7390418709124 | -122.47748532406099 | (37.7390418709124, -122.477485324061) | |||
| 11989 | 11989 | 26837 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1100X Duncan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2x2 | ||||||||
| 17282 | 17282 | 27708 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 720 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 5992097.16127 | 2089870.17428 | 37.717931565159795 | -122.46931519623301 | (37.7179315651598, -122.469315196233) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 25103 | 25103 | 226578 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 124 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5998059.2298099995 | 2106534.17954 | 37.76402962709221 | -122.44990734536199 | (37.7640296270922, -122.449907345362) | |||
| 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) | |||
| 25933 | 25933 | 207216 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Judson Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 1ft | 5997629.9182 | 2093521.5482700001 | 37.7282755556595 | -122.450454058505 | (37.7282755556595, -122.450454058505) | |||
| 26310 | 26310 | 139038 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000648.2136 | 2113864.1729 | 37.7843037348812 | -122.441478860369 | (37.7843037348812, -122.441478860369) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 27919 | 27919 | 207196 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 580 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997574.55439 | 2094416.3667 | 37.7307293459771 | -122.450709941708 | (37.7307293459771, -122.450709941708) | |||
| 28331 | 28331 | 207313 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Ridgewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996777.96593 | 2094453.90027 | 37.730786773973605 | -122.45346656615101 | (37.7307867739736, -122.453466566151) | |||
| 28926 | 28926 | 207301 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 145 Hazelwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996452.48883 | 2094524.36789 | 37.7309615985977 | -122.454596874545 | (37.7309615985977, -122.454596874545) | |||
| 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) | |||
| 29485 | 29485 | 139037 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000646.8218 | 2113873.9159999997 | 37.7843304076342 | -122.441484374883 | (37.7843304076342, -122.441484374883) | |||
| 31001 | 31001 | 176999 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 906 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6001595.86635 | 2088796.01268 | 37.7155264893371 | -122.436405562669 | (37.7155264893371, -122.436405562669) | |||
| 31099 | 31099 | 226629 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 54 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001984.40508 | 2105553.3896 | 37.761560425102 | -122.43626114684099 | (37.761560425102, -122.436261146841) | |||
| 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) | |||
| 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) | |||
| 33252 | 33252 | 129488 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3320 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999321.62812 | 2120233.7842099997 | 37.801717336245105 | -122.44652677938801 | (37.8017173362451, -122.446526779388) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 38348 | 38348 | 119479 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985644.21808 | 2112952.33317 | 37.7809338791525 | -122.493319479205 | (37.7809338791525, -122.493319479205) | |||
| 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) | |||
| 40972 | 40972 | 185610 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2251 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986429.217999999 | 2100931.4203 | 37.7479736765682 | -122.48971952481001 | (37.7479736765682, -122.48971952481) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 44325 | 44325 | 207349 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 618 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5997332.96655 | 2095282.6428599998 | 37.733094101592705 | -122.451607607218 | (37.7330941015927, -122.451607607218) | |||
| 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) | |||
| 44944 | 44944 | 176990 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998584.85135 | 2087137.0809 | 37.7107998882796 | -122.446693649496 | (37.7107998882796, -122.446693649496) | |||
| 45169 | 45169 | 183658 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1487 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981219.3285 | 2104945.9280000003 | 37.7586908149842 | -122.508032687607 | (37.7586908149842, -122.508032687607) | |||
| 48941 | 48941 | 177000 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 759 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002010.1952 | 2089376.96729 | 37.717145196164395 | -122.435014983257 | (37.7171451961644, -122.435014983257) | |||
| 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) | |||
| 49999 | 49999 | 207214 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Judson Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997600.50896 | 2093520.6605599998 | 37.7282714349614 | -122.450555663017 | (37.7282714349614, -122.450555663017) | |||
| 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) | |||
| 51460 | 51460 | 226589 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1100 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999827.96585 | 2100023.61803 | 37.7462542624189 | -122.443322166684 | (37.7462542624189, -122.443322166684) | |||
| 51665 | 51665 | 185263 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2157 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986253.2809 | 2097519.1429 | 37.738594203049004 | -122.4900769498 | (37.738594203049, -122.4900769498) | |||
| 51759 | 51759 | 207273 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2486 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991107.555 | 2098499.64463 | 37.741568687546604 | -122.473364852413 | (37.7415686875466, -122.473364852413) | |||
| 52054 | 52054 | 226616 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005523.88104 | 2097105.4034 | 37.7385646686269 | -122.42341893953899 | (37.7385646686269, -122.423418939539) | |||
| 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) | |||
| 53847 | 53847 | 207299 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 111 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996293.5704 | 2094296.85345 | 37.7303277824929 | -122.455129844261 | (37.7303277824929, -122.455129844261) | |||
| 54753 | 54753 | 207286 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 80 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993623.31026 | 2093437.41863 | 37.7278144273955 | -122.464298855206 | (37.7278144273955, -122.464298855206) | |||
| 55280 | 55280 | 184220 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3437 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5984130.1355 | 2104934.7045 | 37.758831082518896 | -122.49796511397498 | (37.7588310825189, -122.497965113975) | |||
| 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) | |||
| 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) | |||
| 57295 | 57295 | 207143 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1617 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991127.14012 | 2104370.55559 | 37.7576898140615 | -122.473725315989 | (37.7576898140615, -122.473725315989) | |||
| 57399 | 57399 | 176993 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Morse St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998644.90157 | 2087151.5668400002 | 37.7108430935156 | -122.44648714447099 | (37.7108430935156, -122.446487144471) | |||
| 57514 | 57514 | 226606 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2560 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6002251.74918 | 2096967.99127 | 37.7380021417799 | -122.434722564214 | (37.7380021417799, -122.434722564214) | |||
| 57932 | 57932 | 226588 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 350 Treat Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008565.829469999 | 2106391.50298 | 37.7642334332393 | -122.41355789668002 | (37.7642334332393, -122.41355789668) | |||
| 58147 | 58147 | 207303 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 59 Hazelwood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996585.5854400005 | 2094033.89672 | 37.7296225152507 | -122.45410132920601 | (37.7296225152507, -122.454101329206) | |||
| 58753 | 58753 | 185611 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2241 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986448.3245 | 2100932.1027 | 37.747976665787895 | -122.489653506406 | (37.7479766657879, -122.489653506406) | |||
| 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) | |||
| 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) | |||
| 60108 | 60108 | 207212 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Judson Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997571.11535 | 2093520.52293 | 37.728269374612495 | -122.450657267541 | (37.7282693746125, -122.450657267541) | |||
| 60300 | 60300 | 182865 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1845 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989054.8495 | 2102750.5341 | 37.75312143070521 | -122.480773464165 | (37.7531214307052, -122.480773464165) | |||
| 60876 | 60876 | 226631 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6002644.82708 | 2096800.8937799998 | 37.737565638743895 | -122.43335156393299 | (37.7375656387439, -122.433351563933) | |||
| 61063 | 61063 | 207293 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 965 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994659.04342 | 2093888.37752 | 37.729112296585996 | -122.460750997386 | (37.729112296586, -122.460750997386) | |||
| 61927 | 61927 | 184535 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1914 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981673.4595 | 2102023.0319999997 | 37.7506921190217 | -122.506245385817 | (37.7506921190217, -122.506245385817) | |||
| 61977 | 61977 | 226613 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 322 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006488.43942 | 2097246.62658 | 37.7390068293023 | -122.42009397237601 | (37.7390068293023, -122.420093972376) | |||
| 62171 | 62171 | 207300 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 145 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996448.99813 | 2094535.9636799998 | 37.730993237639105 | -122.45460977981199 | (37.7309932376391, -122.454609779812) | |||
| 62397 | 62397 | 207195 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 574 Hearst Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997610.81771 | 2094416.06797 | 37.7307306014402 | -122.450584552831 | (37.7307306014402, -122.450584552831) | |||
| 62758 | 62758 | 207140 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1682 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990920.30999 | 2103955.3917900003 | 37.7565379030086 | -122.474410316087 | (37.7565379030086, -122.474410316087) | |||
| 62912 | 62912 | 177003 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 746 Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009476.70201 | 2090586.0760400002 | 37.720886288652004 | -122.409291987754 | (37.720886288652, -122.409291987754) | |||
| 63341 | 63341 | 207360 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 374 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997612.78816 | 2093589.9194 | 37.7284623061695 | -122.450518204475 | (37.7284623061695, -122.450518204475) | |||
| 63394 | 63394 | 119482 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985642.69106 | 2113025.08426 | 37.781133543390204 | -122.49333012331499 | (37.7811335433902, -122.493330123315) | |||
| 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) | |||
| 67812 | 67812 | 207165 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995466.11989 | 2100230.17484 | 37.746571717707205 | -122.458419748693 | (37.7465717177072, -122.458419748693) | |||
| 67877 | 67877 | 207215 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Judson Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997615.0933300005 | 2093521.35715 | 37.7282741823893 | -122.450505294682 | (37.7282741823893, -122.450505294682) | |||
| 67977 | 67977 | 117858 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 600 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5983830.55841 | 2111665.32715 | 37.777293884605704 | -122.499498581311 | (37.7772938846057, -122.499498581311) | |||
| 68943 | 68943 | 207150 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 830 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5991404.13851 | 2102515.6148 | 37.752612672541105 | -122.47263211090099 | (37.7526126725411, -122.472632110901) | |||
| 68986 | 68986 | 185609 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2261 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986412.841 | 2100929.3732 | 37.747967099583 | -122.489776004492 | (37.747967099583, -122.489776004492) | |||
| 69001 | 69001 | 176998 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 87 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6000227.51825 | 2089886.7347900001 | 37.7184435186304 | -122.441213386902 | (37.7184435186304, -122.441213386902) | |||
| 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) | |||
| 70323 | 70323 | 207350 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 618 Mangels Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997300.95019 | 2095282.96772 | 37.7330931600175 | -122.451718319154 | (37.7330931600175, -122.451718319154) | |||
| 70570 | 70570 | 207314 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1570 07th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994021.19813 | 2104903.51705 | 37.759320377550395 | -122.46375523571999 | (37.7593203775504, -122.46375523572) | |||
| 70729 | 70729 | 177010 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002632.11132 | 2094355.1655700002 | 37.73084950708879 | -122.433220824095 | (37.7308495070888, -122.433220824095) | |||
| 71287 | 71287 | 207201 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998416.44412 | 2094074.8160299999 | 37.7298396835571 | -122.447774830644 | (37.7298396835571, -122.447774830644) | |||
| 71533 | 71533 | 117965 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4545 Anza St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5984581.6879 | 2111733.75019 | 37.7775257966351 | -122.496905272636 | (37.7775257966351, -122.496905272636) | |||
| 72391 | 72391 | 176996 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Morse St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5998705.41323 | 2087176.369 | 37.7109146507487 | -122.44627978598999 | (37.7109146507487, -122.44627978599) | |||
| 73666 | 73666 | 184518 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4108 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982209.6889 | 2101522.5062 | 37.7493493689338 | -122.504354014902 | (37.7493493689338, -122.504354014902) |
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");