Street_Tree_List

Data source: data.sfgov.org

505 rows where qSpecies = 27

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize

DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
61 226596 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1 Newburg St 4 Sidewalk: Property side : Pot 6 Tree 1 Private 1     4 Width 4ft   6002583.45295 2099992.19698 37.746324733318 -122.433791792881 (37.746324733318, -122.433791792881)
1524 251544 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 863X Ocean Ave   Side Yard : Yard 17 Tree 1 Private 1       3x3   5997430.0 2091537.0 37.722815009603295 -122.451002133856 (37.7228150096033, -122.451002133856)
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 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)
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)
3187 207331 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 432 Congo St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   07/05/2002 12:00:00 AM 8 Width 8ft Permit Number 45704 6000124.74065 2095150.49618 37.7328907415174 -122.441946248045 (37.7328907415174, -122.441946248045)
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)
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 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 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 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)
20367 29572 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 400X Junipero Serra Blvd 1 Median : Cutout 11 Tree 1 DPW 2   04/01/2007 12:00:00 AM 3 3X3   5991380.33669 2094272.13717 37.7299768148765 -122.47211360317 (37.7299768148765, -122.47211360317)
20702 16302 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 747 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/18/1992 12:00:00 AM 3 3X3   5997139.1851 2094676.1292299998 37.73141766098679 -122.452233809638 (37.7314176609868, -122.452233809638)
21729 29577 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 400X Junipero Serra Blvd 6 Median : Cutout 11 Tree 1 DPW 2   04/01/2007 12:00:00 AM 3 3X3   5991369.68485 2094223.17677 37.7298417654626 -122.47214686011002 (37.7298417654626, -122.47214686011)
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 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 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)
24450 45488 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 2934 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2001 12:00:00 AM 4   Permit Number 44266 5990009.93985 2095708.66875 37.733841765574205 -122.476956105249 (37.7338417655742, -122.476956105249)
24627 207239 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 43 Median : Cutout 11 Tree 1 DPW 2     13 Width 0ft   5996447.62341 2088998.17361 37.7157876983331 -122.45421469505199 (37.7157876983331, -122.454214695052)
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)
24738 207248 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 574 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992756.55156 2091026.1972 37.7211438059241 -122.46711999608401 (37.7211438059241, -122.467119996084)
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 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 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)
25493 207183 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5995337.35676 2098242.98475 37.7411079873364 -122.458721155571 (37.7411079873364, -122.458721155571)
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)
26283 226595 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 880 Douglass St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 3ft   6001269.3073 2101283.04072 37.749794423884794 -122.438428410468 (37.7497944238848, -122.438428410468)
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 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 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 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)
27070 118586 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 110 Point Lobos Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 4ft   5982415.39383 2112637.72046 37.779880658188794 -122.50446606808501 (37.7798806581888, -122.504466068085)
27445 207324 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 85 Sequoia Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5998176.702190001 2097175.31508 37.7383392103809 -122.44882688276199 (37.7383392103809, -122.448826882762)
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 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 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 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 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 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 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)
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)
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)
30391 207358 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 171 Staples Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5998941.871780001 2093762.1788299999 37.7290112721346 -122.445935896945 (37.7290112721346, -122.445935896945)
30605 207238 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 34 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   5996327.60089 2088999.83253 37.7157853699672 -122.454629665632 (37.7157853699672, -122.454629665632)
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)
30981 71589 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 177 Goethe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 8     5994699.454059999 2086647.11862 37.7092318519263 -122.460086907391 (37.7092318519263, -122.460086907391)
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 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 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)
31369 207346 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 628 Edna St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5998595.0741 2094889.9944099998 37.7320881793139 -122.44721593437201 (37.7320881793139, -122.447215934372)
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)
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)
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)
33118 118541 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 8250 Geary Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5981337.423690001 2112399.66579 37.779163567264 -122.50817750438699 (37.779163567264, -122.508177504387)
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)
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)
33808 207309 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5996632.84291 2093955.22047 37.72940919877011 -122.45393227647699 (37.7294091987701, -122.453932276477)
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)
33929 207241 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 46 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   5996475.13618 2088997.3163599998 37.7157869221947 -122.45411953688601 (37.7157869221947, -122.454119536886)
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)
34009 70454 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 2631 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/11/1994 12:00:00 AM 1     5982726.9666 2097193.7529 37.7374942155975 -122.502244984058 (37.7374942155975, -122.502244984058)
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)
34276 182870 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1847 26th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5988127.2852 2102724.1956 37.752995155363 -122.483979194232 (37.752995155363, -122.483979194232)
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 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 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)
35068 207355 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 430 Edna St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5998789.17566 2094262.87598 37.730377348622106 -122.446499784464 (37.7303773486221, -122.446499784464)
35186 45487 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 2934 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2001 12:00:00 AM 3   Permit Number 44266 5990011.75655 2095686.43247 37.7337808158159 -122.476948200207 (37.7337808158159, -122.476948200207)
35444 31932 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 1210 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1995 12:00:00 AM 7   Permit Number 35348 5981508.8658 2106816.8909 37.763844998562206 -122.507170151225 (37.7638449985622, -122.507170151225)
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)
36376 37433 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 1419 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/17/1998 12:00:00 AM 6   Permit Number 39907 5991189.91551 2110613.34906 37.7748344845766 -122.473963672883 (37.7748344845766, -122.473963672883)
36484 207243 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 324 Lakeview Ave 1 : 4 Tree 1 Private 1     1 Width 3ft   5996808.75565 2089668.4523599998 37.7176488300194 -122.453014817795 (37.7176488300194, -122.453014817795)
36611 207332 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 139 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 10ft   6000483.56606 2095198.0934400002 37.7330418734682 -122.44070911276 (37.7330418734682, -122.44070911276)
37207 207145 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1418 14th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 5ft   5991828.31268 2105750.01462 37.7615180292623 -122.471400907553 (37.7615180292623, -122.471400907553)
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)
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)
37568 207302 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 65 Hazelwood Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5996572.7806400005 2094082.116 37.72975417960021 -122.45414907781799 (37.7297541796002, -122.454149077818)
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)
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 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 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 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)
38449 226599 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1832 Castro St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   6002599.9125 2100157.5460099997 37.746779676940896 -122.43374669365 (37.7467796769409, -122.43374669365)
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)
39672 207255 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 551 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992722.91506 2090824.1387 37.72058706082171 -122.467221582632 (37.7205870608217, -122.467221582632)
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)
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)
40805 122909 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 2x 12th Ave 3 Median : Yard 3 Tree 1 DPW 2     6     5992095.78801 2114872.2732700002 37.7865807540814 -122.471140447624 (37.7865807540814, -122.471140447624)
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)
41674 185771 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1325 Ortega St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5989890.4756 2102411.1303 37.7522380517247 -122.47785892610399 (37.7522380517247, -122.477858926104)
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)
42221 207173 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5995323.713819999 2098239.63146 37.7410979958728 -122.45876808490601 (37.7410979958728, -122.458768084906)
42565 226630 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 17 Temple St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6000001.75416 2105889.17936 37.7623695721306 -122.443142420082 (37.7623695721306, -122.443142420082)
42650 207339 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 436 Joost Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   5999175.62485 2094995.5474599998 37.7324111582276 -122.445216436593 (37.7324111582276, -122.445216436593)
42681 207330 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 345 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5995685.60702 2098472.19978 37.7417573653183 -122.45753361969601 (37.7417573653183, -122.457533619696)
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 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 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)
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)
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)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 481.103ms · Data source: data.sfgov.org