sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
961 251408 2 47 75 Christmas Tree Point Rd 1 1 1 1       3x3   5998776.0 2103023.0 37.75442978774979 -122.447175546291 (37.7544297877498, -122.447175546291)
2144 252907 3 47 25 Point Lobos Ave 10 1 1 2       10x10   5982783.76519 2112486.06679 37.7794859217892 -122.50318049806101 (37.7794859217892, -122.503180498061)
2151 252916 6 47 101 Gold Mine Dr 1 1 1 1       3x3   6001472.0 2098865.0 37.7431665844065 -122.437554349716 (37.7431665844065, -122.437554349716)
3112 253318 2 47 2 Euclid Ave 16 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3113 253332 2 47 2 Euclid Ave 27 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3115 253329 2 47 2 Euclid Ave 24 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3116 253328 2 47 2 Euclid Ave 23 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3119 253313 2 47 2 Euclid Ave 11 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3120 253308 2 47 2 Euclid Ave 6 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3121 253303 2 47 2 Euclid Ave 1 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3122 253323 2 47 2 Euclid Ave 21 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3123 253306 2 47 2 Euclid Ave 4 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3125 253309 2 47 2 Euclid Ave 7 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3127 253316 2 47 2 Euclid Ave 14 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3128 253330 2 47 2 Euclid Ave 25 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3129 253317 2 47 2 Euclid Ave 15 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3130 253319 2 47 2 Euclid Ave 17 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3131 253310 2 47 2 Euclid Ave 8 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3133 253333 2 47 2 Euclid Ave 28 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3135 253335 2 47 2 Euclid Ave 30 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3136 253320 2 47 2 Euclid Ave 18 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3139 253322 2 47 2 Euclid Ave 20 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3140 253334 2 47 2 Euclid Ave 29 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3141 253311 2 47 2 Euclid Ave 9 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3143 253336 2 47 2 Euclid Ave 31 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3145 253304 2 47 2 Euclid Ave 2 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3146 253314 2 47 2 Euclid Ave 12 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3148 253327 2 47 2 Euclid Ave 22 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3150 253331 2 47 2 Euclid Ave 26 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3151 253312 2 47 2 Euclid Ave 10 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3152 253307 2 47 2 Euclid Ave 5 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3153 253315 2 47 2 Euclid Ave 13 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3155 253305 2 47 2 Euclid Ave 3 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3156 253321 2 47 2 Euclid Ave 19 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
19685 92559 1 47 222 Stanyan St 1 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
22920 251148 2 47 625 Brotherhood Way 1 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22923 251152 2 47 625 Brotherhood Way 5 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22924 251154 2 47 625 Brotherhood Way 7 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22925 251150 2 47 625 Brotherhood Way 3 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22927 251157 2 47 625 Brotherhood Way 10 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22928 251155 2 47 625 Brotherhood Way 8 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22929 251156 2 47 625 Brotherhood Way 9 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22930 251151 2 47 625 Brotherhood Way 4 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22931 251158 2 47 625 Brotherhood Way 11 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22932 251153 2 47 625 Brotherhood Way 6 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22933 251149 2 47 625 Brotherhood Way 2 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22934 251159 2 47 625 Brotherhood Way 12 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
50101 121189 6 47 1000x Duncan St 10 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
78630 85239 1 47 200 Yerba Buena Ave 2 1 1 1   07/20/2007 12:00:00 AM     Permit Number 49542 5994792.0 2096029.0 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237)
79781 122494 2 47 69x Bonview St 10 1 1 2       3x3   6007716.0 2099172.0 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063)
80495 92565 1 47 222 Stanyan St 7 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
83377 87064 1 47 101 Arbor St 1 1 1 1   05/30/2007 12:00:00 AM     Permit Number 50006 6001805.0 2096722.0 37.737301333655 -122.436249595043 (37.737301333655, -122.436249595043)
83819 92562 1 47 222 Stanyan St 4 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
84753 108074 2 47 101 BUENA VISTA AVE EAST 4 1 1 1       3x3   6001336.0 2108482.0 37.769564805176394 -122.438713569331 (37.7695648051764, -122.438713569331)
92632 91152 1 47 166 Kensington Way 3 1 1 1       3x3 Permit Number 52026 5994670.3 2098755.2 37.742476040106396 -122.46106469780199 (37.7424760401064, -122.461064697802)
92932 86903 1 47 233 Drake St 1 1 1 1   10/30/2007 12:00:00 AM   3x3 Permit Number 49863 6001780.0 2086418.0 37.7090074518569 -122.435599089406 (37.7090074518569, -122.435599089406)
104492 92563 1 47 222 Stanyan St 5 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
108304 41202 1 47 79 Midcrest Way 1 1 1 1         Permit Number 53043 5998096.00481154 2100748.3020607 37.748145150880795 -122.44936325399401 (37.7481451508808, -122.449363253994)
118999 92564 1 47 222 Stanyan St 6 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
125657 87116 1 47 470 West Portal Ave 7 1 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
125794 85238 1 47 200 Yerba Buena Ave 1 1 1 1   07/20/2007 12:00:00 AM     Permit Number 49542 5994792.0 2096029.0 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237)
125992 93107 1 47 15 Mesa Ave 1 1 1 1   02/02/2010 12:00:00 AM   3x3 Permit Number 53163 5993680.1 2100698.2 37.747753995799705 -122.46462954455299 (37.7477539957997, -122.464629544553)
126878 92561 1 47 222 Stanyan St 3 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
127792 99864 1 47 681 47th Ave 2 1 1 1         Permit Number 768887 5981306.2 2111092.9 37.775573734396204 -122.508188499048 (37.7755737343962, -122.508188499048)
140584 117248 6 47 299x GRAYSTONE TER 1 1 1 1       3x3   5999641.0 2104067.0 37.7573457417117 -122.44425918093 (37.7573457417117, -122.44425918093)
142440 95072 1 47 19 Miguel St 1 1 1 1       3x3 Permit Number 54021 6003434.0 2097382.0 37.7392059633181 -122.430664475135 (37.7392059633181, -122.430664475135)
144772 40713 1 47 2 Crown Ter 1 1 1 1         Permit Number 41692 5998528.84920016 2104703.4154957 37.7590296670037 -122.448151244492 (37.7590296670037, -122.448151244492)
145203 92560 1 47 222 Stanyan St 2 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
145554 121180 6 47 1000x Duncan St 1 1 1 1       3x3   5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
118592 106929 2 47 340 SHOTWELL ST 1 1 1 1     1 10x8   6007766.2 2105923.3 37.7629029238803 -122.41629043085 (37.7629029238803, -122.41629043085)
7193 110906 1 47 2891 Vallejo St 2 1 1 1   05/08/2015 12:00:00 AM 3 3x10 Permit Number 775210 5999784.0596900005 2117390.4095799997 37.7939365889551 -122.44472206489799 (37.7939365889551, -122.444722064898)
7419 97731 3 47 1150 Francisco St 9 1 1 4 2   3 3x3 Permit Number 50638 6005778.11415 2120709.05822 37.803388983478605 -122.42421815984501 (37.8033889834786, -122.424218159845)
13273 20881 3 47 1892X Sunset Blvd 31 1 1 2   02/21/2017 10:23:00 AM 3 60   5984852.8466778 2102317.5089788004 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334)
13276 20799 3 47 1792X Sunset Blvd 3 1 1 2   02/21/2017 10:19:00 AM 3     5984829.6375693 2102999.3844439 37.7535582155387 -122.49540321629601 (37.7535582155387, -122.495403216296)
13278 20803 3 47 1792X Sunset Blvd 7 1 1 2   02/21/2017 10:15:00 AM 3 60   5984829.6375693 2102999.3844439 37.7535582155387 -122.49540321629601 (37.7535582155387, -122.495403216296)
19244 20545 3 47 1303X Sunset Blvd 23 1 1 2     3 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
35574 206878 2 47 15 Belmont Ave 4 1 1 1     3 Width 4ft   5996722.9126 2106147.11856 37.762890304760205 -122.454501283825 (37.7628903047602, -122.454501283825)
87147 750 3 47 2301X 36th Ave 4 1 1 2   09/19/2016 01:42:00 PM 3 6   5985126.566983701 2099532.1780828 37.7440555948275 -122.494120857895 (37.7440555948275, -122.494120857895)
96354 20544 3 47 1303X Sunset Blvd 22 1 1 2     3 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
105118 21301 3 47 2501X Sunset Blvd 1 1 1 2     3 60   5985074.890734901 2098188.1189419 37.740362147215 -122.494200494189 (37.740362147215, -122.494200494189)
107353 21307 3 47 2501X Sunset Blvd 7 1 1 2     3 60   5985074.890734901 2098188.1189419 37.740362147215 -122.494200494189 (37.740362147215, -122.494200494189)
108604 21269 3 47 2492X Sunset Blvd 7 1 1 2     3 60   5984994.4282385 2098239.2478178 37.740497824548 -122.494482465671 (37.740497824548, -122.494482465671)
109740 21279 3 47 2492X Sunset Blvd 17 1 1 2     3 60   5984994.4282385 2098239.2478178 37.740497824548 -122.494482465671 (37.740497824548, -122.494482465671)
119234 21281 3 47 2492X Sunset Blvd 19 1 1 2     3 60   5984994.4282385 2098239.2478178 37.740497824548 -122.494482465671 (37.740497824548, -122.494482465671)
123073 20939 3 47 1992X Sunset Blvd 16 1 1 2     3 60   5984875.945426799 2101638.8759791 37.7498253446275 -122.495142757654 (37.7498253446275, -122.495142757654)
128605 90814 3 47 3101X Cabrillo St 2 1 1 2   04/07/2008 12:00:00 AM 3 3x3   5985939.530040001 2110416.22532 37.773987719434096 -122.492111077157 (37.7739877194341, -122.492111077157)
145113 120920 2 47 198X Miraloma Dr 2 1 1 1     3 3x10   5994595.0 2096392.0 37.7359829456919 -122.461153801837 (37.7359829456919, -122.461153801837)
150980 223769 2 47 340 Shotwell St 2 1 1 1     3 Width 3ft   6007778.5816 2105921.91586 37.7628998195803 -122.416247509035 (37.7628998195803, -122.416247509035)
40580 223723 2 47 2900 25th St 1 1 1 1     4 Width 3ft   6010018.43827 2101654.33057 37.751307680712294 -122.40819958573499 (37.7513076807123, -122.408199585735)
41645 206879 2 47 15 Belmont Ave 2 1 1 1     4 Width 4ft   5996709.23846 2106155.1061299997 37.7629114523342 -122.45454915471599 (37.7629114523342, -122.454549154716)
72114 223768 2 47 340 Shotwell St 3 1 1 1     4 Width 3ft   6007779.74156 2105912.97739 37.762875341838004 -122.41624286402 (37.762875341838, -122.41624286402)
175414 223770 2 47 340 Shotwell St 1 1 1 1     4 Width 3ft   6007775.55004 2105926.88107 37.7629132824304 -122.416258345863 (37.7629132824304, -122.416258345863)
94221 21339 3 47 2592X Sunset Blvd 3 1 1 2     5 60   5985018.1742183 2097562.094386 37.7386399329486 -122.494350460592 (37.7386399329486, -122.494350460592)
3981 18927 3 47 2691 Sacramento St 1 1 1 2     6 3X3   6001960.28459 2115686.06098 37.7893808348161 -122.437070045665 (37.7893808348161, -122.437070045665)
6147 19906 3 47 100 STAIRWAY35 2 1 1 2     6 120ST            
7886 19945 3 47 100 STAIRWAY39 2 1 1 2     6 25ST            
9072 19804 3 47 100 STAIRWAY22 3 1 1 2     6 20            
13184 20013 3 47 100 STAIRWAY47 1 1 1 2     6 100ST            
15771 19908 3 47 100 STAIRWAY35 4 1 1 2     6 120ST            
18718 21167 3 47 2301 Sunset Blvd 8 1 1 2     6 60   5985027.9083074005 2099542.6271361 37.744078511576 -122.49446276258301 (37.744078511576, -122.494462762583)
24419 20488 1 47 1204 Sunset Blvd 9 1 1 3     6 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
Powered by Datasette · Query took 129.139ms · Data source: data.sfgov.org