home / trees

Street_Tree_List

Data source: data.sfgov.org

504 rows where qSpecies = 76

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
412 100461 Undocumented 3 Leptospermum scoparium :: New Zealand Tea Tree 76 236 Wawona St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5992450.0 2097712.0 37.7394836593705 -122.468665877071 (37.7394836593705, -122.468665877071) 1 8 4 59 40
7253 108372 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 575 Paris St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   1 3x3   6001633.30512 2090300.73335 37.7196602437916 -122.436383787393 (37.7196602437916, -122.436383787393) 9 7 6 28861 5
7370 108494 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 734 11th Ave 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2 FUF 2 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773785 5992601.40555 2110422.43493 37.7743919431152 -122.469067180848 (37.7743919431152, -122.469067180848) 11 6 2 54 11
7373 108497 Permitted Site 2 Leptospermum scoparium :: New Zealand Tea Tree 76 1339 12th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773641 5992378.78756 2106335.85187 37.7631584124216 -122.46953970622101 (37.7631584124216, -122.469539706221) 1 8 11 56 12
8140 109233 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 2570 33rd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     40 3x9   5986169.5717 2097728.0842 37.7391630116047 -122.490381738824 (37.7391630116047, -122.490381738824) 1 8 3 29491 35
10744 112294 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 2606 21st Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x2   5989896.9401 2097604.9354 37.7390418709124 -122.47748532406099 (37.7390418709124, -122.477485324061) 1 8 3 29491 35
14006 115788 Permitted Site 2 Leptospermum scoparium :: New Zealand Tea Tree 76 3628 16th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/09/2016 12:00:00 AM 3   Permit Number 777599 6002731.19846 2106518.35077 37.764252377203 -122.433747267607 (37.764252377203, -122.433747267607) 15 5 5 28862 3
14871 116712 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1400 Baker St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6000214.6483 2113835.6397 37.784200680215605 -122.44297678993999 (37.7842006802156, -122.44297678994) 15 6 11 29490 13
14872 116713 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1400 Baker St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6000212.5605 2113848.1665 37.78423495653821 -122.44298491286699 (37.7842349565382, -122.442984912867) 15 6 11 29490 13
15877 117755 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 406 39th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 4ft   5983780.251180001 2113048.87393 37.781089749801204 -122.499774894099 (37.7810897498012, -122.499774894099) 11 6 2 55 26
15970 117857 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 600 39th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   5983829.36907 2111677.06691 37.777326048802294 -122.499503563368 (37.7773260488023, -122.499503563368) 11 6 2 55 26
15971 117858 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 600 39th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   5983830.55841 2111665.32715 37.777293884605704 -122.499498581311 (37.7772938846057, -122.499498581311) 11 6 2 55 26
16062 117964 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 4545 Anza St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   5984595.13139 2111732.58098 37.7775233740539 -122.496858681509 (37.7775233740539, -122.496858681509) 11 6 2 55 26
16063 117965 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 4545 Anza St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   5984581.6879 2111733.75019 37.7775257966351 -122.496905272636 (37.7775257966351, -122.496905272636) 11 6 2 55 26
16064 117966 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 4545 Anza St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   5984567.33243 2111733.70358 37.7775248274666 -122.496954928801 (37.7775248274666, -122.496954928801) 11 6 2 55 26
16065 117967 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 4545 Anza St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   5984550.3085 2111733.18458 37.7775224048599 -122.497013781042 (37.7775224048599, -122.497013781042) 11 6 2 55 26
16077 117979 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 430 38th Ave 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     8 Width 4ft   5984095.97176 2112889.786 37.7806714622872 -122.498670920289 (37.7806714622872, -122.498670920289) 11 6 2 55 26
16168 118098 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 3619 Balboa St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   5984331.597680001 2111046.0676700003 37.7756229611607 -122.497719616092 (37.7756229611607, -122.497719616092) 11 6 2 55 26
16524 118539 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 8250 Geary Blvd 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     4     5981337.09939 2112389.25007 37.7791349496719 -122.508177852958 (37.7791349496719, -122.508177852958) 11 6 2 55 26
16525 118540 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 8250 Geary Blvd 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6     5981337.117190001 2112394.76177 37.7791500842164 -122.50817820058701 (37.7791500842164, -122.508178200587) 11 6 2 55 26
16526 118541 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 8250 Geary Blvd 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6     5981337.423690001 2112399.66579 37.779163567264 -122.50817750438699 (37.779163567264, -122.508177504387) 11 6 2 55 26
16547 118577 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 7900 Geary Blvd 6 Sidewalk: Property side : Yard 5 Tree 1 Private 2     8 Width 10ft   5982502.68903 2112449.1000200002 37.7793678960656 -122.504150104536 (37.7793678960656, -122.504150104536) 11 6 2 55 26
16549 118580 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 7900 Geary Blvd 5 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 10ft   5982502.32297 2112445.62468 37.7793583322752 -122.504151113367 (37.7793583322752, -122.504151113367) 11 6 2 55 26
16555 118586 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 110 Point Lobos Ave 5 Sidewalk: Property side : Yard 5 Tree 1 Private 2     4 Width 4ft   5982415.39383 2112637.72046 37.779880658188794 -122.50446606808501 (37.7798806581888, -122.504466068085) 11 6 2 55 26
16826 119126 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 601 46th Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 5ft   5981603.35382 2111608.79109 37.777007725640104 -122.507198870746 (37.7770077256401, -122.507198870746) 11 6 2 55 26
17022 119479 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 426 33rd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   5985644.21808 2112952.33317 37.7809338791525 -122.493319479205 (37.7809338791525, -122.493319479205) 11 6 2 55 26
17024 119480 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 426 33rd Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   5985643.02597 2112973.39807 37.7809916475781 -122.493325155639 (37.7809916475781, -122.493325155639) 11 6 2 55 26
17025 119481 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 426 33rd Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   5985644.19758 2112999.51907 37.781063436855604 -122.493323027528 (37.7810634368556, -122.493323027528) 11 6 2 55 26
17026 119482 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 426 33rd Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   5985642.69106 2113025.08426 37.781133543390204 -122.49333012331499 (37.7811335433902, -122.493330123315) 11 6 2 55 26
17494 120006 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 658 29th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   5986941.43179 2111450.92852 37.7768872385676 -122.488721446125 (37.7768872385676, -122.488721446125) 11 6 2 55 26
17775 120286 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 157 24th Ave 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     4     5988329.9195 2114925.99705 37.786509724826004 -122.48417321294501 (37.786509724826, -122.484173212945) 11 6 1 55 33
19005 121606 Undocumented 3 Leptospermum scoparium :: New Zealand Tea Tree 76 99X Lamartine St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6002710.0 2094292.0 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569) 9 7 5 28861 25
19006 121607 Undocumented 3 Leptospermum scoparium :: New Zealand Tea Tree 76 99X Lamartine St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6002710.0 2094292.0 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569) 9 7 5 28861 25
19007 121608 Undocumented 3 Leptospermum scoparium :: New Zealand Tea Tree 76 99X Lamartine St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6002710.0 2094292.0 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569) 9 7 5 28861 25
20285 122909 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 2x 12th Ave 3 Median : Yard 11 Tree 1 DPW 1     6     5992095.78801 2114872.2732700002 37.7865807540814 -122.471140447624 (37.7865807540814, -122.471140447624) 11 6 1 54 11
20936 123520 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 2808 Fulton St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 5ft   5994672.01997 2110241.5879900004 37.774014807441795 -122.461891472498 (37.7740148074418, -122.461891472498) 11 6 2 54 11
20937 123521 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 2808 Fulton St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 5ft   5994656.80881 2110239.6852599997 37.7740087073423 -122.46194395210199 (37.7740087073423, -122.461943952102) 11 6 2 54 11
27367 129487 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 3310 Baker St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9 Width 6ft   5999338.381580001 2120194.27566 37.8016098133151 -122.446465960942 (37.8016098133151, -122.446465960942) 13 9 1 57 17
27368 129488 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 3320 Baker St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   5999321.62812 2120233.7842099997 37.801717336245105 -122.44652677938801 (37.8017173362451, -122.446526779388) 13 9 1 57 17
27369 129489 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 2120 Jefferson St 1 Front Yard : Yard 4 Tree 1 Private 2     12     5999042.28702 2121160.24008 37.80424517403429 -122.44756015169901 (37.8042451740343, -122.447560151699) 13 9 1 57 17
27371 129490 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 2536 Baker St 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     5 Width 4ft   5999691.42103 2117587.23687 37.794471737733105 -122.44505675927401 (37.7944717377331, -122.445056759274) 13 9 1 57 27
27372 129491 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 2536 Baker St 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     9 Width 4ft   5999689.18555 2117591.31365 37.794482803901296 -122.445064787505 (37.7944828039013, -122.445064787505) 13 9 1 57 27
27373 129492 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 2536 Baker St 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     9 Width 4ft   5999690.83284 2117600.09007 37.794506995647 -122.445059718941 (37.794506995647, -122.445059718941) 13 9 1 57 27
27374 129493 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 660 Bay St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 2ft   6007573.98162 2121316.69576 37.8051586397294 -122.418046578505 (37.8051586397294, -122.418046578505) 5 1 1 308 32
27375 129494 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 14 Havens St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     14     6007592.27134 2119390.32661 37.7998703454969 -122.417846649312 (37.7998703454969, -122.417846649312) 5 1 1 28858 32
27376 129495 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1136 Havens St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9 Width 7ft   6007480.35855 2119354.0245 37.7997643702969 -122.418231335218 (37.7997643702969, -122.418231335218) 5 1 1 28858 32
27377 129496 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1101 Greenwich St 2 Front Yard : Yard 4 Tree 1 Private 2     7     6007491.98236 2119862.03748 37.8011599004699 -122.418227149773 (37.8011599004699, -122.418227149773) 5 1 1 28858 32
27378 129497 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 855 Chestnut St 6 Sidewalk: Property side : Yard 5 Tree 1 Private 2     16 Width 6ft   6007750.73846 2120580.85704 37.803148159410604 -122.417382708871 (37.8031481594106, -122.417382708871) 5 1 1 308 32
27379 129498 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 855 Chestnut St 7 Sidewalk: Property side : Yard 5 Tree 1 Private 2     20 Width 6ft   6007778.02269 2120584.45961 37.803159586216395 -122.417288546245 (37.8031595862164, -122.417288546245) 5 1 1 308 32
36606 1384 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 2550X Diamond St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     20 3X2   6002245.07965 2096962.3294799998 37.737986217166096 -122.43474521929 (37.7379862171661, -122.43474521929) 2 7 5 63 7
37297 139032 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1535 Broderick St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 0ft   6000626.6398 2114005.4469999997 37.784690408082 -122.441563639416 (37.784690408082, -122.441563639416) 15 6 11 29490 13
37298 139033 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1535 BRODERICK ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 0ft   6000628.7276 2113990.1365 37.784648488341496 -122.441555317265 (37.7846484883415, -122.441555317265) 15 6 11 29490 13
37300 139035 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1501 BRODERICK ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 0ft   6000637.7747 2113910.8003 37.7844311670031 -122.441518322309 (37.7844311670031, -122.441518322309) 15 6 11 29490 13
37301 139036 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1501 BRODERICK ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 0ft   6000642.6462 2113889.2265 37.784372208438604 -122.441499920001 (37.7843722084386, -122.441499920001) 15 6 11 29490 13
37302 139037 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1501 BRODERICK ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 0ft   6000646.8218 2113873.9159999997 37.7843304076342 -122.441484374883 (37.7843304076342, -122.441484374883) 15 6 11 29490 13
37303 139038 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1501 BRODERICK ST 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 0ft   6000648.2136 2113864.1729 37.7843037348812 -122.441478860369 (37.7843037348812, -122.441478860369) 15 6 11 29490 13
44449 16302 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 747 Monterey Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   11/18/1992 12:00:00 AM 3 3X3   5997139.1851 2094676.1292299998 37.73141766098679 -122.452233809638 (37.7314176609868, -122.452233809638) 9 7 4 59 40
48151 176988 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 184 Mount Vernon Ave 4 Side Yard : Yard 27 Tree 1 Private 2     12     5998975.21291 2089361.52774 37.7169300054919 -122.445504324886 (37.7169300054919, -122.445504324886) 9 7 6 28861 25
48152 176989 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 184 Mount Vernon Ave 9 Side Yard : Yard 27 Tree 1 Private 2     14     5998947.7718 2089388.6360799999 37.717002872174504 -122.445601123393 (37.7170028721745, -122.445601123393) 9 7 6 28861 25
48153 176990 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 763 Morse St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   5998584.85135 2087137.0809 37.7107998882796 -122.446693649496 (37.7107998882796, -122.446693649496) 9 7 6 28861 5
48154 176991 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 763 Morse St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   5998612.37791 2087142.9006400001 37.710817440355704 -122.446598930212 (37.7108174403557, -122.446598930212) 9 7 6 28861 5
48155 176992 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 763 Morse St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   5998628.254290001 2087146.50399 37.7108282412039 -122.446544317082 (37.7108282412039, -122.446544317082) 9 7 6 28861 5
48156 176993 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 763 Morse St 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   5998644.90157 2087151.5668400002 37.7108430935156 -122.44648714447099 (37.7108430935156, -122.446487144471) 9 7 6 28861 5
48157 176994 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 763 Morse St 12 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   5998658.093780001 2087156.70124 37.7108579449184 -122.446441918457 (37.7108579449184, -122.446441918457) 9 7 6 28861 5
48158 176995 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 763 Morse St 15 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   5998691.25418 2087172.2379400001 37.7109024991335 -122.44632842581301 (37.7109024991335, -122.446328425813) 9 7 6 28861 5
48159 176996 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 763 Morse St 16 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   5998705.41323 2087176.369 37.7109146507487 -122.44627978598999 (37.7109146507487, -122.44627978599) 9 7 6 28861 5
48160 176997 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 131 Farragut Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 6ft   5997268.75573 2087384.8014900002 37.7114048037631 -122.451260209013 (37.7114048037631, -122.451260209013) 9 7 6 28861 25
48161 176998 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 87 Seneca Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 1ft   6000227.51825 2089886.7347900001 37.7184435186304 -122.441213386902 (37.7184435186304, -122.441213386902) 9 7 6 28861 25
48162 176999 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 906 Edinburgh St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 6ft   6001595.86635 2088796.01268 37.7155264893371 -122.436405562669 (37.7155264893371, -122.436405562669) 9 7 6 28861 5
48166 177000 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 759 Edinburgh St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 Width 2ft   6002010.1952 2089376.96729 37.717145196164395 -122.435014983257 (37.7171451961644, -122.435014983257) 9 7 6 28861 5
48167 177001 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 154 Gillette Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   6013011.29164 2086676.67622 37.7103492505861 -122.396799956671 (37.7103492505861, -122.396799956671) 10 3 8 309 1
48168 177002 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 721 Goettingen St 2 Sidewalk: Curb side : Pot 3 Tree 1 Private 2     2 Width 4ft   6010761.087830001 2091324.0286400001 37.7229844303778 -122.404904160394 (37.7229844303778, -122.404904160394) 10 3 7 309 28
48169 177003 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 746 Olmstead St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 2ft   6009476.70201 2090586.0760400002 37.720886288652004 -122.409291987754 (37.720886288652, -122.409291987754) 9 3 7 309 28
48170 177004 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 746 Olmstead St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 2ft   6009463.77429 2090581.8029200002 37.720873831251104 -122.40933637376999 (37.7208738312511, -122.40933637377) 9 3 7 309 28
48171 177005 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 362 Arleta Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   6009172.07817 2088408.58756 37.714890285531794 -122.410191328669 (37.7148902855318, -122.410191328669) 9 7 8 309 39
48172 177006 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 271 Teddy Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6009831.15293 2088401.27476 37.7149071271443 -122.40791276406 (37.7149071271443, -122.40791276406) 9 7 8 309 39
48173 177007 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 216 Saint Charles Ave 1 : 14 Tree 1 Private 2     5 Width 3ft   5992028.26989 2086999.54978 37.710045543251205 -122.469344489883 (37.7100455432512, -122.469344489883) 9 8 4 64 24
48174 177008 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 67 Capistrano Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9     6001385.71309 2093783.96595 37.7292103388668 -122.43748892737301 (37.7292103388668, -122.437488927373) 9 7 6 28861 25
48175 177009 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 425 Cayuga Ave 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 6ft   6002141.25462 2093891.34658 37.729548108055 -122.434884635528 (37.729548108055, -122.434884635528) 9 7 6 28861 25
48176 177010 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 78 Lamartine St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   6002632.11132 2094355.1655700002 37.73084950708879 -122.433220824095 (37.7308495070888, -122.433220824095) 9 7 5 28861 25
48177 177011 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 78 Lamartine St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6002637.06105 2094341.00901 37.73081091718 -122.433202700959 (37.73081091718, -122.433202700959) 9 7 5 28861 25
48178 177012 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 78 Lamartine St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   6002642.0398 2094328.25695 37.730776185352504 -122.433184577831 (37.7307761853525, -122.433184577831) 9 7 5 28861 25
48179 177013 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 78 Lamartine St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   6002644.59595 2094315.3545 37.7307409031583 -122.433174819278 (37.7307409031583, -122.433174819278) 9 7 5 28861 25
48180 177014 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 81 Lamartine St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 Width 2ft   6002672.79218 2094323.6061200001 37.7307651596849 -122.433077929925 (37.7307651596849, -122.433077929925) 9 7 5 28861 25
48181 177015 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 81 Lamartine St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 Width 2ft   6002665.86181 2094349.24813 37.730835173699106 -122.433103720676 (37.7308351736991, -122.433103720676) 9 7 5 28861 25
48182 177016 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 81 Lamartine St 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 Width 2ft   6002658.8277900005 2094369.8725599998 37.7308914046921 -122.433129511441 (37.7308914046921, -122.433129511441) 9 7 5 28861 25
48183 177017 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 345 Mount Vernon Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9 Width 2ft   5998458.65026 2089723.00143 37.7178930256111 -122.447315825681 (37.7178930256111, -122.447315825681) 9 7 6 28861 25
48184 177018 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 401 Ocean Ave 21 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 8ft   5999065.383280001 2091517.8288599998 37.722855860592105 -122.44534760363399 (37.7228558605921, -122.445347603634) 9 7 6 28861 25
48185 177019 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 25 Madrid St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     4     6004214.26597 2093378.8456299999 37.728258376811496 -122.427681523704 (37.7282583768115, -122.427681523704) 9 7 6 28861 5
48186 177020 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 235 Vienna St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7     6004327.3137300005 2092022.6110200002 37.724540851055 -122.42719414780599 (37.724540851055, -122.427194147806) 9 7 6 28861 5
48187 177021 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1538 Burrows St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 4ft   6006775.37088 2092172.2563099999 37.72508988269 -122.41874212587 (37.72508988269, -122.41874212587) 9 7 7 309 5
48188 177022 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1628 Burrows St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   6006681.726369999 2092138.2756599998 37.724991306183796 -122.419063436538 (37.7249913061838, -122.419063436538) 9 7 7 309 5
48189 177023 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1628 Burrows St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   6006643.54009 2092125.7831400002 37.7249548539585 -122.419194556805 (37.7249548539585, -122.419194556805) 9 7 7 309 5
48190 177024 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 11 Athens St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2     6005372.1534 2093185.8595 37.7277939084451 -122.42366493918301 (37.7277939084451, -122.423664939183) 9 7 6 28861 5
48191 177025 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 300 Hamilton St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6009309.80145 2092849.9581799998 37.727093081168604 -122.410028653892 (37.7270930811686, -122.410028653892) 9 3 7 309 28
48192 177026 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 501 Sweeny St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 6ft   6008206.81715 2094351.9900900002 37.7311554564421 -122.41394787781601 (37.7311554564421, -122.413947877816) 9 3 7 309 28
48193 177027 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 127 Naples St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 4ft   6004458.22384 2092761.54245 37.726577195866206 -122.426794207588 (37.7265771958662, -122.426794207588) 9 7 6 28861 5
48194 177028 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 164 Baltimore Way 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     7 Width 6ft   6002357.56159 2086195.5289200002 37.7084293823926 -122.433587065817 (37.7084293823926, -122.433587065817) 9 7 6 28861 5
53850 182865 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1845 23rd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 0ft   5989054.8495 2102750.5341 37.75312143070521 -122.480773464165 (37.7531214307052, -122.480773464165) 1 8 3 56 35
53854 182869 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 76 1847 26th Ave 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     1 Width 0ft   5988126.7611 2102732.0567 37.753016709320995 -122.48398158304701 (37.753016709321, -122.483981583047) 1 8 3 56 35

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" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 29.31ms · Data source: data.sfgov.org