sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2489 119760 3 35 101X Octavia St Frontage West 2 1 1 2       4x4            
2492 119762 3 35 101X Octavia St Frontage West 4 1 1 2       4x4            
2501 119761 3 35 101X Octavia St Frontage West 3 1 1 2       4x4            
2508 119759 3 35 101X Octavia St Frontage West 1 1 1 2       4x4            
3013 39333 1 35 0 21st St 3 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
3019 20034 3 16 100 STAIRWAY51 5 1 1 2     3 ST            
3403 19880 3 198 100 STAIRWAY33 12 1 1 2     6 25ST            
3610 115725 2 198 250X Octavia St 2 17 1 5                    
3951 20035 3 16 100 STAIRWAY51 6 1 1 2     3 ST            
4106 20001 3 198 100 STAIRWAY46 21 1 1 2     6 2            
4351 36746 1 16 5555 Woodward St 1 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39516          
5302 35167 1 16 240 Walter St 1 1 1 1   02/02/1998 12:00:00 AM     Permit Number 38700          
5325 40088 1 84   1 1 1 1   03/09/1999 12:00:00 AM     Permit Number 41311          
5373 31852 1 35 1117 Houston St 2 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35299          
5518 39334 1 35 0 21st St 4 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
5746 31847 1 16   2 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
6573 19697 3 84 100 STAIRWAY9 1 1 1 2     3 15ST            
6740 39332 1 35 0 21st St 2 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
7293 31848 1 16   3 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
7527 20039 3 16 100 STAIRWAY51 10 1 1 2     3 ST            
9510 46857 1 16   1 1 1 1   04/25/2002 12:00:00 AM     Permit Number 44926          
9515 19958 3 84 100 STAIRWAY40 3 1 1 2     3 15ST            
9562 19696 3 84 100 STAIRWAY9 -3 1 1 2     12 15ST            
10575 20040 3 16 100 STAIRWAY51 11 1 1 2     6 ST            
10800 19957 3 84 100 STAIRWAY40 2 1 1 2     3 15ST            
10952 43297 1 16 1501 Missouri St 1 1 1 1   07/12/2000 12:00:00 AM     Permit Number 43066          
11785 31851 1 35 1117 Houston St 1 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35299          
11795 31846 1 16   1 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
11812 20044 3 16 100 STAIRWAY51 15 1 1 2     3 ST            
11986 31849 1 35   1 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
12896 19960 3 84 100 STAIRWAY41 18 1 1 2     6 25ST            
12976 20042 3 16 100 STAIRWAY51 13 1 1 2     3 ST            
13223 33083 1 16   2 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
14197 39331 1 35 0 21st St 5 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
14604 19885 3 198 100 STAIRWAY33 17 1 1 2     6 25ST            
14695 20043 3 16 100 STAIRWAY51 14 1 1 2     3 ST            
14881 33084 1 16   1 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
15743 115724 2 198 250x Octavia St 1 17 1 5                    
15875 31850 1 35   2 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
15956 31845 1 35   3 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
16368 19956 3 84 100 STAIRWAY40 1 1 1 2     12 15ST            
44810 53918 1 35 3 21st St 1 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
165215 44743 1 16 306 Saint Charles Ave 1 1 1 1 1 04/03/2001 12:00:00 AM 5   Permit Number 43861 5992021.82053 2086414.86847 37.7084397758389 -122.469324250627 (37.7084397758389, -122.469324250627)
156176 44741 1 18 271 Saint Charles Ave 1 1 1 1 1 04/03/2001 12:00:00 AM 3   Permit Number 43859 5992054.55445 2086618.7004799999 37.7090013413078 -122.46922594483601 (37.7090013413078, -122.469225944836)
34347 44742 1 16 276 Saint Charles Ave 1 1 1 1 1 04/03/2001 12:00:00 AM 4   Permit Number 43860 5992023.15498 2086637.27235 37.7090505207416 -122.469335815893 (37.7090505207416, -122.469335815893)
186679 179670 3 198 300x Winding Way 6 11 1 2     7 Width 0ft   6001487.80324 2086473.7350700002 37.7091438874604 -122.436612949055 (37.7091438874604, -122.436612949055)
188289 178905 2 35 320 Hanover St 1 1 1 1     2 Width 3ft   5999575.27021 2086527.1037599999 37.7091815546459 -122.443226763913 (37.7091815546459, -122.443226763913)
28269 178750 2 16 52 Tomaso Ct 1 1 1 1     11 Width 3ft   6009169.8221 2086336.97845 37.709201944987605 -122.410052964391 (37.7092019449876, -122.410052964391)
40286 178844 2 16 52 Tomaso Ct 1 4 1 1     16 Width 2ft   6009171.05644 2086338.49099 37.7092061672978 -122.410048805012 (37.7092061672978, -122.410048805012)
140557 109055 1 18 320 Hanover St   1 1 1 1 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772693 5999569.6 2086544.4 37.70922872292179 -122.443247602414 (37.7092287229218, -122.443247602414)
146572 73606 2 16 40 Rhine St 1 1 1 1 1 09/30/1995 12:00:00 AM 4     5994431.8230800005 2086668.6372599998 37.7092755401168 -122.461013433922 (37.7092755401168, -122.461013433922)
68733 31023 1 18 330 Naylor St 2 1 1 1 1 03/13/1995 12:00:00 AM 9   Permit Number 34788 6002794.80361 2086503.3822400002 37.7092994800486 -122.43209787574 (37.7092994800486, -122.43209787574)
55122 71593 2 16 34 Rhine St 1 1 1 1 1 09/30/1995 12:00:00 AM 4     5994443.94493 2086683.2861799998 37.70931646014839 -122.46097260021001 (37.7093164601484, -122.46097260021)
157289 178971 2 18 509 Sunnydale Ave 1 1 1 1     2 Width 3ft   6010024.16897 2086365.7166900001 37.7093287026266 -122.407102219496 (37.7093287026266, -122.407102219496)
178402 31022 1 18 330 Naylor St 1 1 1 1 1 03/13/1995 12:00:00 AM 8   Permit Number 34788 6002783.56511 2086520.12567 37.7093448166924 -122.43213791266001 (37.7093448166924, -122.43213791266)
33909 178753 2 16 288 Schwerin St 1 1 1 1     6 Width 3ft   6008616.33006 2086415.6536599998 37.7093869328198 -122.41197148180099 (37.7093869328198, -122.411971481801)
165737 178848 2 16 284 Schwerin St 3 1 1 1     9 Width 4ft   6008617.09448 2086417.42045 37.709391826951105 -122.411968964603 (37.7093918269511, -122.411968964603)
172601 117182 2 35 26 Watt Ave 1 1 1 1     6 3x3   6000152.35367 2086600.7137400003 37.709416560993 -122.441237557982 (37.709416560993, -122.441237557982)
123650 24288 1 16 340 Winding Way 2 1 1 1     3 3X3   6001280.10777 2086581.3596299998 37.709427595658795 -122.43733847618401 (37.7094275956588, -122.437338476184)
155545 178843 2 16 316 Naylor St 4 1 1 1     8 Width 6ft   6002755.16684 2086552.83016 37.7094330059866 -122.432238395683 (37.7094330059866, -122.432238395683)
28678 179035 2 18 178 Desmond St 1 1 1 1     3 Width 3ft   6010379.06325 2086412.1514400002 37.709476057444796 -122.40587891040899 (37.7094760574448, -122.405878910409)
52388 178914 2 35 263 Flournoy St 9 2 1 1     1     5993788.47929 2086756.5816799998 37.7094799730978 -122.463243292153 (37.7094799730978, -122.463243292153)
66527 178915 2 35 263 Flournoy St 10 2 1 1     1     5993789.8911 2086758.89685 37.70948641134179 -122.46323858062 (37.7094864113418, -122.46323858062)
65590 178916 2 35 263 Flournoy St 11 2 1 1     1     5993790.44094 2086761.47706 37.7094935276652 -122.46323686739599 (37.7094935276652, -122.463236867396)
44971 178752 2 16 276 Schwerin St 1 1 1 1     2 Width 3ft   6008629.54675 2086454.27777 37.7094937282293 -122.411928530185 (37.7094937282293, -122.411928530185)
67795 178907 2 35 263 Flournoy St 1 2 1 1     1     5993774.9758 2086763.55645 37.7094983462303 -122.46329046790501 (37.7094983462303, -122.463290467905)
183985 178917 2 35 263 Flournoy St 12 2 1 1     1     5993792.21408 2086763.29106 37.7094986106303 -122.463230870712 (37.7094986106303, -122.463230870712)
48579 178918 2 35 263 Flournoy St 13 2 1 1     1     5993792.015380001 2086765.64003 37.709505048900496 -122.46323172778 (37.7095050489005, -122.46323172778)
76456 178908 2 35 263 Flournoy St 2 2 1 1     1     5993776.62184 2086766.22044 37.7095057557476 -122.463284972138 (37.7095057557476, -122.463284972138)
171245 178847 2 16 272 Schwerin St 2 1 1 1     2 Width 4ft   6008631.68261 2086459.28689 37.7095076020765 -122.411921502003 (37.7095076020765, -122.411921502003)
184051 178910 2 35 263 Flournoy St 4 2 1 1     1     5993781.83724 2086767.02745 37.7095082720684 -122.463267005492 (37.7095082720684, -122.463267005492)
155097 178919 2 35 263 Flournoy St 14 2 1 1     5     5993793.90715 2086767.20458 37.709509453768604 -122.463225303004 (37.7095094537686, -122.463225303004)
58079 178920 2 35 263 Flournoy St 15 2 1 1     2     5993797.37837 2086767.25523 37.7095097928145 -122.463213309645 (37.7095097928145, -122.463213309645)
61631 178909 2 35 263 Flournoy St 3 2 1 1     3     5993779.42986 2086768.12245 37.70951113998979 -122.463275405145 (37.7095111399898, -122.463275405145)
73045 31021 1 18 317 Naylor St 1 1 1 1 1 03/13/1995 12:00:00 AM 7   Permit Number 34787 6002776.11429 2086581.1916200002 37.7095120680942 -122.432168021935 (37.7095120680942, -122.432168021935)
178309 31056 1 16 9 Toyon Ln 1 1 1 1 1 03/13/1995 12:00:00 AM 7   Permit Number 34808 6003244.645880001 2086572.31488 37.7095142480656 -122.430548065039 (37.7095142480656, -122.430548065039)
182335 178911 2 35 263 Flournoy St 5 2 1 1     1     5993783.22919 2086769.82188 37.709516025103895 -122.46326239735201 (37.7095160251039, -122.463262397352)
34928 178912 2 35 263 Flournoy St 6 2 1 1     3     5993780.74611 2086770.03775 37.709516474781104 -122.463270994886 (37.7095164747811, -122.463270994886)
43104 178921 2 35 263 Flournoy St 16 2 1 1     3     5993794.96049 2086770.14434 37.7095175863374 -122.463221875682 (37.7095175863374, -122.463221875682)
134446 178705 2 16 980 Huron Ave 1 1 1 1     5 Width 2ft   5996782.39454 2086708.5296099999 37.7095200567877 -122.452892407466 (37.7095200567877, -122.452892407466)
184333 178913 2 35 263 Flournoy St 7 2 1 1     6     5993781.9303 2086773.16178 37.709525120851396 -122.463267128695 (37.7095251208514, -122.463267128695)
108284 86728 1 16 980 Huron Ave   1 1 1   09/25/2007 12:00:00 AM     Permit Number 49704 5996769.2 2086717.1 37.7095428329763 -122.452938628006 (37.7095428329763, -122.452938628006)
28128 179162 2 18 171 Winding Way 1 1 1 1     4 Width 3ft   6002093.74544 2086607.8879 37.7095466578231 -122.434528308849 (37.7095466578231, -122.434528308849)
39728 178751 2 16 272 Schwerin St 1 1 1 1     3 Width 3ft   6008644.3214 2086482.2621 37.709571396371395 -122.411879442491 (37.7095713963714, -122.411879442491)
167032 179163 2 18 171 Winding Way 2 1 1 1     5 Width 3ft   6002120.7512 2086617.7341900002 37.7095752265844 -122.43443567596 (37.7095752265844, -122.43443567596)
51803 178846 2 16 272 Schwerin St 1 1 1 1     4 Width 4ft   6008639.83625 2086484.9507 37.7095785270867 -122.411895133863 (37.7095785270867, -122.411895133863)
176572 178833 2 16 99 Drake St 1 1 1 1     4 Width 6ft   6001567.75342 2086664.56423 37.709672405530796 -122.43635027774401 (37.7096724055308, -122.436350277744)
10329 109051 1 18 32 De Long St 1 1 1 1 1 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772570 5995048.30925 2086814.9244099997 37.7097126663738 -122.45889335865 (37.7097126663738, -122.45889335865)
58904 44740 1 16 235 Saint Charles Ave 1 1 1 1 1 04/03/2001 12:00:00 AM 5   Permit Number 43858 5992059.17709 2086878.10482 37.7097138705641 -122.469228836168 (37.7097138705641, -122.469228836168)
167416 178834 2 16 99 Drake St 2 1 1 1     3 Width 6ft   6001553.31629 2086683.73815 37.7097242325659 -122.43640154631201 (37.7097242325659, -122.436401546312)
30587 178835 2 16 99 Drake St 3 1 1 1     5 Width 3ft   6001544.783340001 2086699.50707 37.709767045691294 -122.436432165527 (37.7097670456913, -122.436432165527)
53625 178836 2 16 99 Drake St 4 1 1 1     5 Width 3ft   6001534.9682599995 2086713.04585 37.7098036624786 -122.436467056534 (37.7098036624786, -122.436467056534)
179704 44738 1 16 224 Saint Charles Ave 1 1 1 1 1 04/03/2001 12:00:00 AM 6   Permit Number 43855 5992028.811919999 2086945.8058900002 37.7098980067533 -122.46933870721901 (37.7098980067533, -122.469338707219)
35376 179161 2 18 233 Naylor St 1 2 1 1     2 Width 6ft   6002647.79999 2086739.6543400001 37.7099398962889 -122.432622809119 (37.7099398962889, -122.432622809119)
40596 69408 1 16 981 Prague St 1 1 1 1 1 05/09/1994 12:00:00 AM 4   Permit Number 33513 6001538.598040001 2086768.9797900002 37.7099574510375 -122.43645851206301 (37.7099574510375, -122.436458512063)
99158 178837 2 16 981 Prague St 2 1 1 1     4 Width 3ft   6001551.41306 2086770.9715900002 37.7099636482706 -122.43641436345301 (37.7099636482706, -122.436414363453)
60318 178838 2 16 981 Prague St 3 1 1 1     5 Width 3ft   6001561.306469999 2086771.17725 37.7099647751299 -122.436380184711 (37.7099647751299, -122.436380184711)
117477 37344 1 35 571 Brunswick St 1 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39852 5999120.28976365 2086823.35415522 37.7099690371181 -122.444820521553 (37.7099690371181, -122.444820521553)
176683 179153 2 18 412 Cordova St 1 1 1 1     4 Width 8ft   6001969.08964 2086773.8202799999 37.7099951946836 -122.434970999229 (37.7099951946836, -122.434970999229)
157300 57927 1 18 559 Brunswick St 1 1 1 1   06/24/1977 12:00:00 AM 3   Permit Number 16885 5999203.256130001 2086855.58023 37.7100622571339 -122.444536089569 (37.7100622571339, -122.444536089569)
178112 178839 2 16 921 Prague St 1 1 1 1     1 Width 6ft   6001840.757 2086804.7866200001 37.7100729338953 -122.435416754499 (37.7100729338953, -122.435416754499)
Powered by Datasette · Query took 100.545ms · Data source: data.sfgov.org