sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
864 37366 1 50 125 Street 1 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39871          
5259 42922 1 50   1 1 1 1   07/05/2000 12:00:00 AM     Permit Number 42829          
5550 37365 1 50 125 Street 2 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39871          
12187 50191 1 50 347 Richard Av 1 1 1 1   08/20/2003 12:00:00 AM     Permit Number 46897          
90821 44385 1 50 185 Baltimore Way 2 1 1 1 1 03/22/2001 12:00:00 AM     Permit Number 43746 6002329.42862952 2086131.81061029 37.708252829485296 -122.433679745726 (37.7082528294853, -122.433679745726)
112948 44386 1 50 185 Baltimore Way 1 1 1 1 1 03/22/2001 12:00:00 AM     Permit Number 43746 6002329.42862952 2086131.81061029 37.708252829485296 -122.433679745726 (37.7082528294853, -122.433679745726)
106047 44443 1 50 287 South Hill Blvd 1 1 1 1 1 03/23/2001 12:00:00 AM     Permit Number 43774 6003431.81812286 2086404.88677332 37.7090651281705 -122.429889231519 (37.7090651281705, -122.429889231519)
160291 44444 1 50 287 South Hill Blvd 2 1 1 1 1 03/23/2001 12:00:00 AM 9   Permit Number 43774 6003411.70926 2086434.98288 37.7091466267865 -122.429960876109 (37.7091466267865, -122.429960876109)
162722 44442 1 50 287 South Hill Blvd 3 1 1 1 1 03/23/2001 12:00:00 AM 14   Permit Number 43774 6003408.0203599995 2086444.2343400002 37.7091718203864 -122.429974284999 (37.7091718203864, -122.429974284999)
58862 37345 1 50 724 Brunswick St 1 1 1 1 1 06/15/1998 12:00:00 AM 10   Permit Number 39853 5998100.18965 2086460.63765 37.7089148310191 -122.448320064445 (37.7089148310191, -122.448320064445)
152208 57958 1 50 332 Hanover St 1 1 1 1   06/24/1977 12:00:00 AM 13   Permit Number 16918 5999508.527290001 2086501.1248400002 37.7091064162873 -122.443455572131 (37.7091064162873, -122.443455572131)
155230 57965 1 50 211 Lowell St 1 1 1 1   06/24/1977 12:00:00 AM 20   Permit Number 16925 5998963.22576 2086714.9374 37.7096623843901 -122.445355572527 (37.7096623843901, -122.445355572527)
11621 76445 2 50 118X Lowell St 6 1 1 1 1 05/30/1998 12:00:00 AM 10 3x3   5998808.0264099995 2086988.0844400001 37.710403523785 -122.445911599067 (37.710403523785, -122.445911599067)
12985 76427 2 50 118X Lowell St 5 1 1 1 1 05/30/1998 12:00:00 AM 3 3x3   5998792.69271 2087037.2667900003 37.710537691825294 -122.445968130449 (37.7105376918253, -122.445968130449)
131371 177546 2 50 1200 Sunnydale Ave 1 9 1 1     9 Width 6ft   6008407.5541199995 2087041.9081400002 37.711094783172 -122.4127372923 (37.711094783172, -122.4127372923)
172708 177547 2 50 1202 Sunnydale Ave 1 9 1 1     9 Width 6ft   6008380.574519999 2087049.08192 37.7111129665536 -122.412831047535 (37.7111129665536, -122.412831047535)
84417 37376 1 50 755 Morse St 10 1 1 1 1 06/15/1998 12:00:00 AM 5 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
91068 37374 1 50 755 Morse St 8 1 1 1 1 06/15/1998 12:00:00 AM 5 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
93477 37378 1 50 755 Morse St 12 1 1 1 1 06/15/1998 12:00:00 AM 5 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
95427 37372 1 50 755 Morse St 6 1 1 1 1 06/15/1998 12:00:00 AM 5 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
106497 37368 1 50 755 Morse St 2 1 1 1 1 03/13/1999 12:00:00 AM 5 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
109826 37384 1 50 755 Morse St 18 1 1 1 1 06/15/1998 12:00:00 AM 5 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
110425 37367 1 50 755 Morse St 1 1 1 1 1 03/13/1999 12:00:00 AM 5 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
112545 37370 1 50 755 Morse St 4 1 1 1 1 06/15/1998 12:00:00 AM 4 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
115975 37380 1 50 755 Morse St 14 1 1 1 1 06/15/1998 12:00:00 AM 5 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
129265 37382 1 50 755 Morse St 16 1 1 1 1 06/15/1998 12:00:00 AM 5 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
143392 37369 1 50 755 Morse St 3 1 1 1 1 03/13/1999 12:00:00 AM 5 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
30262 177548 2 50 1212 Sunnydale Ave 1 9 1 1     7 Width 6ft   6008309.89956 2087076.14497 37.7111833088358 -122.413077230629 (37.7111833088358, -122.413077230629)
23613 177549 2 50 1212 Sunnydale Ave 2 9 1 1     8 Width 6ft   6008302.63413 2087080.3017900002 37.7111943147388 -122.41310263557502 (37.7111943147388, -122.413102635575)
12983 73822 2 50 118X Lowell St 3 1 1 1 1 05/30/1998 12:00:00 AM 10 3x3   5998761.76944 2087100.1867 37.7107086898252 -122.44607953033999 (37.7107086898252, -122.44607953034)
19640 41394 1 50 1250 Sunnydale Ave 22 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
78392 41405 1 50 1250 Sunnydale Ave 2 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
83061 41397 1 50 1250 Sunnydale Ave 10 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
90897 41408 1 50 1250 Sunnydale Ave 15 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
91647 41393 1 50 1250 Sunnydale Ave 11 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
95096 41399 1 50 1250 Sunnydale Ave 23 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
95366 41392 1 50 1250 Sunnydale Ave 20 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
97480 41398 1 50 1250 Sunnydale Ave 9 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
98726 41388 1 50 1250 Sunnydale Ave 14 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
101105 41406 1 50 1250 Sunnydale Ave 1 1 1 1 1 08/03/2002 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
102191 41403 1 50 1250 Sunnydale Ave 4 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
104466 41386 1 50 1250 Sunnydale Ave 12 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
105218 41402 1 50 1250 Sunnydale Ave 5 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
107035 41391 1 50 1250 Sunnydale Ave 19 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
109577 41400 1 50 1250 Sunnydale Ave 7 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
109989 41387 1 50 1250 Sunnydale Ave 13 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
111241 41395 1 50 1250 Sunnydale Ave 6 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
111491 41396 1 50 1250 Sunnydale Ave 21 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
113046 41389 1 50 1250 Sunnydale Ave 16 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
113269 41401 1 50 1250 Sunnydale Ave 17 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
120697 41407 1 50 1250 Sunnydale Ave 8 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
145483 41390 1 50 1250 Sunnydale Ave 18 1 1 1 1 10/28/2000 12:00:00 AM     Permit Number 42021 6008204.54210993 2087109.47599829 37.711268913870896 -122.41344372896201 (37.7112689138709, -122.413443728962)
28957 177550 2 50 1232 Sunnydale Ave 1 9 1 1     8 Width 6ft   6008203.75149 2087114.38987 37.7112823619554 -122.41344680884899 (37.7112823619554, -122.413446808849)
47744 177551 2 50 1232 Sunnydale Ave 2 9 1 1     11 Width 6ft   6008194.37646 2087118.0668 37.711291931647104 -122.4134794713 (37.7112919316471, -122.4134794713)
163639 177552 2 50 1252 Sunnydale Ave 1 9 1 1     9 Width 6ft   6008179.27118 2087123.9525 37.7113072443981 -122.413532095133 (37.7113072443981, -122.413532095133)
28515 177540 2 50 118 Lowell St 2 1 1 1     11 Width 3ft   5998750.27555 2087125.8155099999 37.7107784043659 -122.446121097934 (37.7107784043659, -122.446121097934)
26699 177553 2 50 1252 Sunnydale Ave 2 9 1 1     6 Width 6ft   6008169.89589 2087127.62977 37.7113168149851 -122.413564758528 (37.7113168149851, -122.413564758528)
167720 78779 2 50 50 Farragut Ave 1 1 1 1 1 10/21/2000 12:00:00 AM 14     5997572.003219999 2087132.1924700001 37.7107285558476 -122.45019391613701 (37.7107285558476, -122.450193916137)
39906 41404 1 50 1252 Sunnydale Ave 3 1 1 1 1 10/28/2000 12:00:00 AM 7   Permit Number 42021 6008157.91792 2087132.40574 37.7113292562177 -122.413606495143 (37.7113292562177, -122.413606495143)
68587 177554 2 50 1250 Sunnydale Ave 1 9 1 1     8 Width 6ft   6008137.76094 2087139.4402400001 37.711347439601 -122.41367666025101 (37.711347439601, -122.413676660251)
51706 177541 2 50 763 Morse St 7 1 1 1     11 Width 3ft   5998622.731430001 2087153.99485 37.7108484939443 -122.446563943873 (37.7108484939443, -122.446563943873)
62663 177555 2 50 1262 Sunnydale Ave 1 9 1 1     4 Width 6ft   6008091.22398 2087157.2966900002 37.7113938563146 -122.41383876666401 (37.7113938563146, -122.413838766664)
146503 177542 2 50 763 Morse St 9 1 1 1     7 Width 3ft   5998634.17055 2087157.9364900002 37.710859970193 -122.446524691177 (37.710859970193, -122.446524691177)
76610 177543 2 50 763 Morse St 11 1 1 1     8 Width 3ft   5998648.38585 2087164.77044 37.7108795466262 -122.446476051329 (37.7108795466262, -122.446476051329)
55278 177556 2 50 1272 Sunnydale Ave 1 9 1 1     7 Width 6ft   6008061.6956 2087168.1827200002 37.711422088742104 -122.413941594254 (37.7114220887421, -122.413941594254)
59779 177544 2 50 763 Morse St 13 1 1 1     8 Width 3ft   5998663.80946 2087170.3503700001 37.7108957487982 -122.44642314511299 (37.7108957487982, -122.446423145113)
12245 72809 2 50 118X Lowell St 1 1 1 1 1 05/30/1998 12:00:00 AM 10 3x3   5998733.92072 2087172.14442 37.710904679081395 -122.446180954109 (37.7109046790814, -122.446180954109)
179208 177545 2 50 763 Morse St 14 1 1 1     9 Width 3ft   5998675.35081 2087179.2071099998 37.71092072659079 -122.446383892402 (37.7109207265908, -122.446383892402)
68450 177557 2 50 1272 Sunnydale Ave 2 9 1 1     8 Width 6ft   6008002.127780001 2087190.6623 37.7114804673251 -122.414149066054 (37.7114804673251, -122.414149066054)
53130 177558 2 50 1272 Sunnydale Ave 3 9 1 1     12 Width 6ft   6007990.6783 2087195.6021 37.7114933878791 -122.41418898783701 (37.7114933878791, -122.414188987837)
126328 44414 1 50 715 Prague St 1 1 1 1 1 03/23/2001 12:00:00 AM 11   Permit Number 43765 6002608.88238 2087292.96021 37.711456946454504 -122.43279681623699 (37.7114569464545, -122.432796816237)
185544 44415 1 50 715 Prague St 2 1 1 1 1 03/23/2001 12:00:00 AM 10   Permit Number 43765 6002616.35291 2087303.28452 37.711485718453204 -122.432771733227 (37.7114857184532, -122.432771733227)
177982 44413 1 50 715 Prague St 3 1 1 1 1 03/23/2001 12:00:00 AM 11   Permit Number 43765 6002624.57094 2087314.6775200001 37.7115174672301 -122.432744142937 (37.7115174672301, -122.432744142937)
1852 178671 2 50 624 Rolph St 1 1 1 1     8 Width 5ft   6002757.8843 2087321.68 37.7115442544376 -122.432283877092 (37.7115442544376, -122.432283877092)
4397 251730 2 50 536 Rolph St 1 1 1 1   10/11/2017 11:34:00 AM 3 3x3   6002599.0 2087392.0 37.71172832759 -122.432838043044 (37.71172832759, -122.432838043044)
90184 44408 1 50 1201 Naples St 5 1 1 1 1 03/23/2001 12:00:00 AM     Permit Number 43761 6001148.59414975 2087417.50046792 37.711715976255796 -122.437852856075 (37.7117159762558, -122.437852856075)
167569 177579 2 50 518 Rolph St 2 1 1 1     11 Width 3ft   6002528.751209999 2087456.67798 37.7119019345989 -122.433085459944 (37.7119019345989, -122.433085459944)
9769 159355 4 50 417 Ellington Ave 2 1 1 1   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998509.882680001 2087558.1907400002 37.7119518775514 -122.44698304145001 (37.7119518775514, -122.44698304145)
4208 163311 2 50 261 Sadowa St 1 1 1 1   10/10/2017 08:33:00 AM 3 Width 0ft   5994382.20064 2087745.46311 37.7122293948338 -122.46126294184201 (37.7122293948338, -122.461262941842)
4269 163375 2 50 204 Sadowa St 1 1 1 1   10/10/2017 07:56:00 AM 3 Width 0ft   5994989.76466 2087776.26613 37.712348920149104 -122.45916526416799 (37.7123489201491, -122.459165264168)
4263 163376 2 50 204 Sadowa St 2 1 1 1   10/10/2017 08:04:00 AM 3 Width 0ft   5994976.692009999 2087776.5788200002 37.7123490271688 -122.45921046950899 (37.7123490271688, -122.459210469509)
4262 163377 2 50 210 Sadowa St 1 1 1 1   10/10/2017 08:24:00 AM 3 Width 0ft   5994919.0 2087792.0 37.7123880531541 -122.45941098523701 (37.7123880531541, -122.459410985237)
163619 73817 2 50 125 Morse St 1 1 1 1 1 05/30/1998 12:00:00 AM 7     6000831.98332 2087914.4715900002 37.7130625393704 -122.438982739962 (37.7130625393704, -122.438982739962)
27152 72787 2 50 125 Morse St 2 1 1 1 1 05/30/1998 12:00:00 AM 10     6000842.138719999 2087917.52073 37.7130714894434 -122.43894785796199 (37.7130714894434, -122.438947857962)
182274 177559 2 50 321 Ellington Ave 1 1 1 1     14 Width 2ft   5998895.58023 2087925.27433 37.712981834213 -122.44567634809201 (37.712981834213, -122.445676348092)
24208 177560 2 50 321 Ellington Ave 3 1 1 1     11 Width 2ft   5998919.67884 2087945.88417 37.7130398000187 -122.445594536777 (37.7130398000187, -122.445594536777)
130624 78732 2 50 53 Foote Ave 1 1 1 1 1 10/21/2000 12:00:00 AM 12     5998972.2526 2087962.75673 37.7130891296288 -122.44541403745 (37.7130891296288, -122.44541403745)
86886 44390 1 50 15 Cordova St 1 1 1 1 1 03/22/2001 12:00:00 AM     Permit Number 43749 6001647.0719332 2087964.37014378 37.7132458927569 -122.43616909431101 (37.7132458927569, -122.436169094311)
124286 44389 1 50 15 Cordova St 2 1 1 1 1 03/22/2001 12:00:00 AM     Permit Number 43749 6001647.0719332 2087964.37014378 37.7132458927569 -122.43616909431101 (37.7132458927569, -122.436169094311)
149 26071 3 50 247 Orizaba Ave 1 1 1 2   03/28/2017 01:41:00 PM 3 3X3   5993990.1569314 2088190.8403771 37.7134297247264 -122.46265023824101 (37.7134297247264, -122.462650238241)
1808 26069 3 50 271 Orizaba Ave 1 1 1 2   06/27/1997 12:00:00 AM 3 3X3   5993995.7894187 2088348.3730133998 37.713862596316 -122.462642190986 (37.713862596316, -122.462642190986)
146403 73117 2 50 170 Rome St 1 1 1 1 1 10/21/2000 12:00:00 AM 13     5998798.49436 2089027.5311099999 37.7160028368265 -122.44609114241699 (37.7160028368265, -122.446091142417)
28707 177564 2 50 791 Edinburgh St 1 1 1 1     8 Width 2ft   6001913.98711 2089225.11823 37.7167227891097 -122.435336672548 (37.7167227891097, -122.435336672548)
144351 41038 1 50 10 Jennings St 1 1 1 1   10/20/1999 12:00:00 AM     Permit Number 41823 6012891.67554567 2089346.007114 37.717672045776204 -122.39740045328699 (37.7176720457762, -122.397400453287)
38852 177570 2 50 478 Wilde Ave 1 1 1 1     1 Width 3ft   6010169.953290001 2089428.2061400001 37.7177458326947 -122.406814054248 (37.7177458326947, -122.406814054248)
11631 15824 3 50 5060 Mission St 2 1 1 2   04/26/1995 12:00:00 AM 12 3X3   6000432.8297 2089486.0645 37.7173550615336 -122.440474991501 (37.7173550615336, -122.440474991501)
55854 177563 2 50 738 Edinburgh St 1 1 1 1     12 Width 2ft   6002044.3357 2089508.8562099999 37.7175092723187 -122.434906402712 (37.7175092723187, -122.434906402712)
145012 15826 3 50 5081 Mission St 1 1 1 2   04/27/1995 12:00:00 AM 6 3X3   6000584.2194 2089509.2478099999 37.7174273368683 -122.43995337049401 (37.7174273368683, -122.439953370494)
50306 187447 2 50 5083 Mission St 1 1 1 1     7 Width 0ft   6000540.1333 2089544.2391 37.71752090531329 -122.44010826310199 (37.7175209053133, -122.440108263102)
12125 15819 1 50 5050 Mission St 1 1 1 1   11/11/2001 12:00:00 AM 12 3X3   6000495.0068 2089582.3782 37.717623057493896 -122.440266977896 (37.7176230574939, -122.440266977896)
11034 15821 3 50 5051 Mission St 1 1 1 2   04/27/1995 12:00:00 AM 6 3X3   6000582.469 2089604.8822 37.717689827708895 -122.43996627417101 (37.7176898277089, -122.439966274171)
Powered by Datasette · Query took 16.088ms · Data source: data.sfgov.org