Street_Tree_List

Data source: data.sfgov.org

171 rows where PlotSize = "Width 3ft", qSiteInfo = 1 and qSpecies = 48

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
3788 118108 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 3585 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/2017 12:00:00 AM 3 Width 3ft   5984519.42575 2111051.46948 37.7756488017479 -122.497070281467 (37.7756488017479, -122.497070281467)
4007 216655 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 161 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 02:49:00 PM 3 Width 3ft   5995318.74701 2090961.5845400002 37.7211139601174 -122.45825861266 (37.7211139601174, -122.45825861266)
4127 207021 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 400 Grafton Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2017 07:38:00 AM 3 Width 3ft   5995575.229619999 2090581.47857 37.720085014301894 -122.457344548018 (37.7200850143019, -122.457344548018)
4130 216848 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 258 Farallones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2017 02:39:00 PM 3 Width 3ft   5994378.76562 2088424.12647 37.7140926462446 -122.461323980613 (37.7140926462446, -122.461323980613)
4192 216845 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 194 Farallones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 07:48:00 AM 3 Width 3ft   5995118.95449 2088413.12295 37.714105005620205 -122.458764825742 (37.7141050056202, -122.458764825742)
5012 189150 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 351 Cargo Way 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 11:46:00 AM 3 Width 3ft   6017356.8528 2098625.87133 37.7434003277556 -122.382611554189 (37.7434003277556, -122.382611554189)
5071 203010 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 351 Cargo Way 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 11:48:00 AM 3 Width 3ft   6017339.6558 2098641.75454 37.743442989794005 -122.38267212263399 (37.743442989794, -122.382672122634)
22862 176910 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1390 Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6009561.38521 2094361.93193 37.7312587382014 -122.409265579153 (37.7312587382014, -122.409265579153)
22870 176911 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1390 Silver Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6009574.07755 2094366.6897 37.731272513113296 -122.409222034865 (37.7312725131133, -122.409222034865)
22875 176912 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1390 Silver Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6009589.47798 2094371.19963 37.7312857592085 -122.409169110679 (37.7312857592085, -122.409169110679)
22876 176913 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1390 Silver Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6009673.25426 2094402.8730900001 37.7313774208194 -122.40888171341999 (37.7313774208194, -122.40888171342)
24647 227111 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 19 Stoneman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008285.63801 2099411.47629 37.745052125166296 -122.414033173096 (37.7450521251663, -122.414033173096)
25321 227575 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 33 Buena Vista Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6001460.70601 2108045.90078 37.7683744785129 -122.43825097062 (37.7683744785129, -122.43825097062)
25567 227123 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 483 Clipper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002011.92527 2100876.5046200003 37.748720385135705 -122.43583132576201 (37.7487203851357, -122.435831325762)
25668 118581 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 104 Point Lobos Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5982478.43556 2112606.9372400003 37.7797998443253 -122.504245701476 (37.7797998443253, -122.504245701476)
26337 227551 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 571 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6003034.11181 2104925.46753 37.75989588789739 -122.432585790315 (37.7598958878974, -122.432585790315)
27138 206991 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1383 11th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5992691.10596 2106043.8640900003 37.7623747360262 -122.468438266429 (37.7623747360262, -122.468438266429)
28609 227574 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 11 Beaver St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6002707.53405 2106779.67068 37.764968555288 -122.43384779545299 (37.764968555288, -122.433847795453)
29103 227140 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 266 Rivoli St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5997729.62744 2105927.06337 37.7623437750648 -122.45100355509399 (37.7623437750648, -122.451003555094)
29931 129373 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2133 Beach St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6000002.55629 2120892.7221 37.8035654727314 -122.444217840184 (37.8035654727314, -122.444217840184)
31111 207007 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 127 Westgate Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993382.1086800005 2093854.3174299998 37.7289452232334 -122.465162955333 (37.7289452232334, -122.465162955333)
31319 176877 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 526 Lathrop Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6013098.43993 2086515.08302 37.709910397621705 -122.396487432357 (37.7099103976217, -122.396487432357)
31459 227146 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 266 Rivoli St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5997461.46496 2105891.36034 37.7622303876487 -122.45192844846599 (37.7622303876487, -122.451928448466)
32789 227562 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 4567 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6000777.25512 2104640.3736 37.7589848458951 -122.440370692454 (37.7589848458951, -122.440370692454)
33294 206990 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1383 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5992691.68575 2106051.40057 37.7623954627053 -122.46843680950501 (37.7623954627053, -122.468436809505)
33440 176906 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 769 Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006512.6379 2093630.87617 37.7290801395131 -122.419753817278 (37.7290801395131, -122.419753817278)
34085 207020 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 230 Brighton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5996253.66444 2091441.06295 37.722484173480204 -122.45506152367201 (37.7224841734802, -122.455061523672)
34279 227550 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 3957 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003307.61262 2104748.70742 37.7594260532954 -122.431627264983 (37.7594260532954, -122.431627264983)
35674 227569 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 287 Hartford St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002739.75043 2104260.6213 37.7580536824469 -122.43355632787201 (37.7580536824469, -122.433556327872)
35906 227555 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 4611 19th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6000604.66017 2104640.67953 37.7589758571809 -122.440967627376 (37.7589758571809, -122.440967627376)
35959 118588 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 150 Point Lobos Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5982305.68238 2112631.11012 37.779856054488604 -122.50484511221701 (37.7798560544886, -122.504845112217)
36351 119164 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 883 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5981372.52859 2109725.62562 37.7718235084184 -122.507857566702 (37.7718235084184, -122.507857566702)
36867 227143 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 266 Rivoli St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997579.79251 2105906.80731 37.762279577867496 -122.45152031451 (37.7622795778675, -122.45152031451)
37145 176886 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 119 Theresa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002169.33644 2093633.7193099998 37.7288423165165 -122.434769138285 (37.7288423165165, -122.434769138285)
37420 207024 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 85 Williar Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997067.34432 2090557.5942799998 37.7201050223995 -122.452185117661 (37.7201050223995, -122.452185117661)
38046 227115 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 587 Shotwell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6007890.87999 2104550.47449 37.75914047177721 -122.415761992927 (37.7591404717772, -122.415761992927)
38084 207023 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 85 Williar Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5997061.0236599995 2090546.31892 37.7200737008175 -122.452206152789 (37.7200737008175, -122.452206152789)
38228 227149 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 530 Crescent Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6007719.361409999 2095678.5372900001 37.734770477458795 -122.41572699582301 (37.7347704774588, -122.415726995823)
38388 227552 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 4058 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6002586.755890001 2105341.84005 37.7610137667981 -122.43416274071998 (37.7610137667981, -122.43416274072)
38399 129386 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 929 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009490.7484 2116033.66261 37.7907604245028 -122.411039958651 (37.7907604245028, -122.411039958651)
39635 207026 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 229 Lobos St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5994724.722630001 2088692.2453700001 37.71484874224021 -122.460147642199 (37.7148487422402, -122.460147642199)
40644 227097 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1650 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6009272.782269999 2099754.5666099996 37.7460495695343 -122.41064401410601 (37.7460495695343, -122.410644014106)
40740 129388 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2507 Larkin St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006666.99925 2119949.9372900003 37.8013547799481 -122.421088199869 (37.8013547799481, -122.421088199869)
42710 227127 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 105 Hoffman Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6000615.36032 2102512.03507 37.7531317270504 -122.44077792887501 (37.7531317270504, -122.440777928875)
43893 117895 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 635 38th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5984097.32613 2111483.29523 37.7768097259285 -122.498562310404 (37.7768097259285, -122.498562310404)
44275 227553 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 4445 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001135.34377 2105211.25899 37.760572740148 -122.439173173223 (37.760572740148, -122.439173173223)
47223 207040 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 115 Greenwood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5996029.169869999 2093727.8612799998 37.728750294270604 -122.456002788314 (37.7287502942706, -122.456002788314)
47498 119083 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 863 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5981985.30992 2109867.54201 37.7722492542332 -122.505748473333 (37.7722492542332, -122.505748473333)
48057 227570 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 287 Hartford St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002738.3349 2104276.75984 37.7580979146911 -122.43356237671101 (37.7580979146911, -122.433562376711)
48273 227563 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 4565 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6000806.394180001 2104634.53115 37.7589704630323 -122.440269497142 (37.7589704630323, -122.440269497142)
48842 207037 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2642 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5990833.84583 2097410.6031 37.738562605571104 -122.47423178898501 (37.7385626055711, -122.474231788985)
51918 176909 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1038 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6007759.6380900005 2093605.48677 37.729080594582896 -122.41544102937401 (37.7290805945829, -122.415441029374)
52110 227151 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 48 Fair Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6006822.59734 2099508.6280900002 37.7452366012942 -122.419099008325 (37.7452366012942, -122.419099008325)
52735 176874 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 526 Lathrop Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6012843.86934 2086597.3532 37.7101221250005 -122.397373047849 (37.7101221250005, -122.397373047849)
52877 118595 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 101 Point Lobos Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5982415.15882 2112561.71552 37.7796719571588 -122.504461248614 (37.7796719571588, -122.504461248614)
53500 227128 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 248 Whitney St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6004363.9622599995 2096949.7405400001 37.7380717187222 -122.427418297528 (37.7380717187222, -122.427418297528)
54346 227582 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 288 States St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6000368.64642 2106819.9498400004 37.7649461504603 -122.44194028911501 (37.7649461504603, -122.441940289115)
55786 129372 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2133 Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5999985.518069999 2120890.75849 37.80355910913379 -122.444276660352 (37.8035591091338, -122.444276660352)
56110 227546 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 4281 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6001381.6755099995 2101715.76186 37.7509889636801 -122.43807083010401 (37.7509889636801, -122.438070830104)
56440 117883 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 734 43rd Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5982620.39521 2110769.29715 37.7747625699566 -122.503618485147 (37.7747625699566, -122.503618485147)
56558 207005 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 171 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992787.45104 2098017.3287299997 37.7403415032629 -122.467521326669 (37.7403415032629, -122.467521326669)
56726 227158 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 3318 20th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008087.45284 2104471.6208599997 37.7589350063619 -122.415076566546 (37.7589350063619, -122.415076566546)
57061 227584 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 660 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6002549.44678 2108867.98451 37.7706935809695 -122.434543909369 (37.7706935809695, -122.434543909369)
57165 176885 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 191 Rey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6008580.05361 2087004.5673599998 37.7110019335603 -122.412138452652 (37.7110019335603, -122.412138452652)
57528 227572 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 841 Church St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6004362.062530001 2104151.54801 37.7578461063327 -122.42793790601499 (37.7578461063327, -122.427937906015)
58124 206995 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1584 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993720.55073 2104714.02617 37.7587827556425 -122.464781251568 (37.7587827556425, -122.464781251568)
58241 227081 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 71 Woodward St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006508.23754 2108096.29045 37.76879862578671 -122.420795571254 (37.7687986257867, -122.420795571254)
58669 118593 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 101 Point Lobos Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5982449.24993 2112557.22359 37.7796616287576 -122.504342981812 (37.7796616287576, -122.504342981812)
58837 227567 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 308 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6001758.47595 2103911.51009 37.7570393829676 -122.43692499579299 (37.7570393829676, -122.436924995793)
58875 191246 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 22 Rausch St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6009574.51886 2111002.08454 37.776949608681 -122.41039468697599 (37.776949608681, -122.410394686976)
60440 227159 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 156 Duncan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6005558.07312 2099948.5227 37.746373159994505 -122.423502792335 (37.7463731599945, -122.423502792335)
60679 207022 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 85 Williar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997053.5846 2090532.92812 37.720036506659206 -122.452230901246 (37.7200365066592, -122.452230901246)
61434 227118 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 85 29th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6005870.45988 2099040.93392 37.743898754514106 -122.42235811905701 (37.7438987545141, -122.422358119057)
62607 207043 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 73 Keystone Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5994097.83418 2093287.06293 37.7274289275879 -122.46264752636999 (37.7274289275879, -122.46264752637)
62998 176882 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 371 Wilde Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6010924.50069 2089093.90072 37.7168700890604 -122.404182392406 (37.7168700890604, -122.404182392406)
64011 176891 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 128 Craut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6004014.42285 2094241.1944400002 37.730614887467205 -122.428433829062 (37.7306148874672, -122.428433829062)
70354 207004 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 171 Wawona St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992803.19794 2098037.0989599996 37.7403966964551 -122.46746831791 (37.7403966964551, -122.46746831791)
70932 119542 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 791 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5986618.95807 2110548.82595 37.7743914964818 -122.48977060648899 (37.7743914964818, -122.489770606489)
71244 227084 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1217 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6010060.56336 2102014.9446799997 37.7523002058063 -122.408079341009 (37.7523002058063, -122.408079341009)
72063 176879 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 140 Bacon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6010956.3364 2092967.7781599998 37.7275087379234 -122.404344863032 (37.7275087379234, -122.404344863032)
73263 129389 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2507 Larkin St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006655.24817 2120043.6921200003 37.801611544485205 -122.421135524881 (37.8016115444852, -122.421135524881)
74076 120009 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 746 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5986962.570590001 2110820.51914 37.775157546008 -122.48860197556101 (37.775157546008, -122.488601975561)
74889 227564 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 4547 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6000867.43951 2104613.62235 37.7589165280041 -122.440056874944 (37.7589165280041, -122.440056874944)
75835 176894 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 68 La Grande Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6005238.00808 2092009.9005900002 37.724557410279296 -122.42404509073201 (37.7245574102793, -122.424045090732)
104217 191223 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1112 De Haro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6012178.19052 2103217.19746 37.7557196692435 -122.400840661869 (37.7557196692435, -122.400840661869)
116434 227156 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 3458 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6007201.92693 2104423.1326599997 37.758752066271704 -122.41813569949801 (37.7587520662717, -122.418135699498)
123811 191221 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 101 Mississippi St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6014015.897890001 2106592.9178299997 37.7650909952748 -122.39472162882099 (37.7650909952748, -122.394721628821)
129699 227161 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Leese St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6005575.79788 2096114.93647 37.73584799837779 -122.423169051236 (37.7358479983778, -122.423169051236)
130789 176890 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 18 Ney St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6003663.21456 2093989.9827 37.7299052360341 -122.429630099158 (37.7299052360341, -122.429630099158)
131491 227124 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 483 Clipper St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6002026.8924 2100876.99711 37.74872258759179 -122.435779604843 (37.7487225875918, -122.435779604843)
131908 227583 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 714 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002133.89525 2108814.30402 37.7705225892763 -122.435977464701 (37.7705225892763, -122.435977464701)
132341 227139 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 280 Grattan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5997445.297590001 2106455.57152 37.763778642484205 -122.452025073424 (37.7637786424842, -122.452025073424)
133135 227087 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6009571.148469999 2096096.9094 37.736023162027294 -122.409354219042 (37.7360231620273, -122.409354219042)
133333 227144 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 266 Rivoli St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5997515.89511 2105898.72706 37.7622537322474 -122.451740727559 (37.7622537322474, -122.451740727559)
133488 118589 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 150 Point Lobos Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5982275.325019999 2112634.79146 37.779864376411 -122.50495040283998 (37.779864376411, -122.50495040284)
133679 207045 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 607 Teresita Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5998977.59415 2096753.4397599997 37.737226608721706 -122.446027465895 (37.7372266087217, -122.446027465895)
133925 227125 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 483 Clipper St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6002044.61682 2100877.8681799998 37.7487259861351 -122.435718376327 (37.7487259861351, -122.435718376327)
134344 206998 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 223 Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5994252.21923 2105280.12164 37.7603677459862 -122.462983582339 (37.7603677459862, -122.462983582339)
134386 206992 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 633 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992553.594409999 2105897.35752 37.761964523762 -122.468903201544 (37.761964523762, -122.468903201544)
134651 207001 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 404 Santiago St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5991538.30054 2099790.96979 37.7451392685705 -122.47196959112301 (37.7451392685705, -122.471969591123)

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 2903.356ms · Data source: data.sfgov.org