sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
12993 19985 3 46 100 STAIRWAY46 5 1 1 2     3 40            
16163 26637 3 46 400X Winfield St 1 1 1 2   02/12/1998 12:00:00 AM 6 3X3            
22840 251107 3 46 1700X Quesada Ave 1 3 1 2                    
81045 109169 3 46 6x Octavia St Frontage West 6 11 1 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
83700 109168 3 46 6x Octavia St Frontage West 7 11 1 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
97204 109171 3 46 6x Octavia St Frontage West 4 11 1 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
99403 109164 3 46 6x Octavia St Frontage West 11 11 1 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
116938 109163 3 46 6x Octavia St Frontage West 12 11 1 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
121401 109167 3 46 6x Octavia St Frontage West 8 11 1 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
126070 109170 3 46 6x Octavia St Frontage West 5 11 1 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
144933 119701 3 46 6x Octavia St Frontage West 3 11 1 2           2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
84832 119681 3 46 2x Octavia St Frontage East 7 11 1 2           2109501.0 6005733.0 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)
92481 119675 3 46 2x Octavia St Frontage East 1 11 1 2           2109501.0 6005733.0 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)
93922 119676 3 46 2x Octavia St Frontage East 2 11 1 2           2109501.0 6005733.0 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)
105805 119677 3 46 2x Octavia St Frontage East 3 11 1 2           2109501.0 6005733.0 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)
110275 119680 3 46 2x Octavia St Frontage East 6 11 1 2           2109501.0 6005733.0 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)
113138 119682 3 46 2x Octavia St Frontage East 8 11 1 2           2109501.0 6005733.0 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)
125886 119679 3 46 2x Octavia St Frontage East 5 11 1 2           2109501.0 6005733.0 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)
1192 119753 3 46 101x Octavia St 8 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1196 119750 3 46 101x Octavia St 5 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1202 119754 3 46 101x Octavia St 9 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1204 119749 3 46 101x Octavia St 4 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1213 119747 3 46 101x Octavia St 2 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1223 119752 3 46 101x Octavia St 7 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1227 119736 3 46 101x Octavia St 1 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1233 119757 3 46 101x Octavia St 12 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1234 119748 3 46 101x Octavia St 3 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1235 119756 3 46 101x Octavia St 11 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
99951 119755 3 46 106x Octavia St Frontage West 10 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
91459 119712 3 46 102x Octavia St Frontage East 5 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
101446 119713 3 46 102x Octavia St Frontage East 6 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
103389 119708 3 46 102x Octavia St Frontage East 1 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
108290 119716 3 46 102x Octavia St Frontage East 9 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
110953 119719 3 46 102x Octavia St Frontage East 12 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
122353 119718 3 46 102x Octavia St Frontage East 11 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
124457 119717 3 46 102x Octavia St Frontage East 10 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
128093 119709 3 46 102x Octavia St Frontage East 2 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
128531 119710 3 46 102x Octavia St Frontage East 3 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
141876 119711 3 46 102x Octavia St Frontage East 4 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
145232 119714 3 46 102x Octavia St Frontage East 7 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
1183 119797 3 46 201x Octavia St 5 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1187 119794 3 46 201x Octavia St 2 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1189 119798 3 46 201x Octavia St 6 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1194 119795 3 46 201x Octavia St 3 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1199 119799 3 46 201x Octavia St 7 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1203 119796 3 46 201x Octavia St 4 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1206 119801 3 46 201x Octavia St 9 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1207 119793 3 46 201x Octavia St 1 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1208 119803 3 46 201x Octavia St 11 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1209 119800 3 46 201x Octavia St 8 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
84934 119788 3 46 202x Octavia St Frontage East 8 11 1 2           2110143.0 6005643.0 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)
87810 119785 3 46 202x Octavia St Frontage East 5 11 1 2           2110143.0 6005643.0 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)
96137 119790 3 46 202x Octavia St Frontage East 10 11 1 2           2110143.0 6005643.0 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)
100873 119784 3 46 202x Octavia St Frontage East 4 11 1 2           2110143.0 6005643.0 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)
107228 119786 3 46 202x Octavia St Frontage East 6 11 1 2           2110143.0 6005643.0 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)
108319 119791 3 46 202x Octavia St Frontage East 11 11 1 2           2110143.0 6005643.0 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)
112254 119783 3 46 202x Octavia St Frontage East 3 11 1 2           2110143.0 6005643.0 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)
118324 119789 3 46 202x Octavia St Frontage East 9 11 1 2           2110143.0 6005643.0 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)
122435 119792 3 46 202x Octavia St Frontage East 12 11 1 2           2110143.0 6005643.0 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)
144605 119782 3 46 202x Octavia St Frontage East 2 11 1 2           2110143.0 6005643.0 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)
145037 119787 3 46 202x Octavia St Frontage East 7 11 1 2           2110143.0 6005643.0 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)
146012 119781 3 46 202x Octavia St Frontage East 1 11 1 2           2110143.0 6005643.0 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)
1185 119832 3 46 301x Octavia St 5 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1191 119838 3 46 301x Octavia St 11 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1201 119839 3 46 301x Octavia St 12 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1211 119836 3 46 301x Octavia St 9 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1212 119828 3 46 301x Octavia St 1 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1219 119829 3 46 301x Octavia St 2 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1222 119837 3 46 301x Octavia St 10 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1226 119830 3 46 301x Octavia St 3 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1228 119831 3 46 301x Octavia St 4 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1230 119834 3 46 301x Octavia St 7 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1231 119833 3 46 301x Octavia St 6 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
85315 119826 3 46 302x Octavia St Frontage East 10 11 1 2           2110484.0 6005595.0 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)
85972 119818 3 46 302x Octavia St Frontage East 2 11 1 2           2110484.0 6005595.0 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)
91533 119820 3 46 302x Octavia St Frontage East 4 11 1 2           2110484.0 6005595.0 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)
92952 119827 3 46 302x Octavia St Frontage East 11 11 1 2           2110484.0 6005595.0 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)
93091 119824 3 46 302x Octavia St Frontage East 8 11 1 2           2110484.0 6005595.0 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)
122930 119817 3 46 302x Octavia St Frontage East 1 11 1 2           2110484.0 6005595.0 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)
127815 119816 3 46 302x Octavia St Frontage East 12 11 1 2           2110484.0 6005595.0 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)
128474 119819 3 46 302x Octavia St Frontage East 3 11 1 2           2110484.0 6005595.0 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)
139301 119823 3 46 302x Octavia St Frontage East 7 11 1 2           2110484.0 6005595.0 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)
142143 119825 3 46 302x Octavia St Frontage East 9 11 1 2           2110484.0 6005595.0 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)
143889 119821 3 46 302x Octavia St Frontage East 5 11 1 2           2110484.0 6005595.0 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)
143969 119822 3 46 302x Octavia St Frontage East 6 11 1 2           2110484.0 6005595.0 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)
102460 11630 3 46 400X Junipero Serra Blvd 2 1 1 2     24 4x4   5991380.578 2094219.03 37.7298310098579 -122.47210889946501 (37.7298310098579, -122.472108899465)
85950 1325 3 46 4051X Alemany Blvd 2 1 1 2     15 3X3   5991764.76245 2086963.37686 37.709930989883496 -122.47025258193399 (37.7099309898835, -122.470252581934)
109476 19301 3 46 100X Balboa St 2 1 1 2     12 3x3   5995247.10654 2111496.409 37.7774933045144 -122.459993084378 (37.7774933045144, -122.459993084378)
78358 1208 3 46 3141 Alemany Blvd 2 1 1 2     25 3x3   5995992.87885 2086942.4061599998 37.7101169521706 -122.455637985173 (37.7101169521706, -122.455637985173)
11281 1166 3 46 2900 Alemany Blvd 1 1 1 2   04/22/2008 12:00:00 AM 25 3X3   5997012.91474 2087625.1618700002 37.7120501257788 -122.45216178836 (37.7120501257788, -122.45216178836)
140379 14496 3 46 345 Masonic Ave 1 1 1 2     24 3X4   5998988.10277 2111568.3775400002 37.7779053592654 -122.44705696740499 (37.7779053592654, -122.447056967405)
21400 14591 3 46 1221 Masonic Ave 3 1 1 2   08/09/2011 12:00:00 AM 3 3x3   5999412.7083 2108624.4902 37.7698464448905 -122.445376387082 (37.7698464448905, -122.445376387082)
20352 14598 3 46 1247 Masonic Ave 1 1 1 2   11/01/2016 12:00:00 AM 45 3X3   5999428.6068 2108510.475 37.7695342955042 -122.445313195872 (37.7695342955042, -122.445313195872)
16950 25174 3 46 3062 Market St 2 1 1 2     100 3X3   6000130.8652 2105433.23803 37.761125030928895 -122.44266313540199 (37.7611250309289, -122.442663135402)
9754 25175 3 46 3066 Market St 1 1 1 2     40 9x9 Permit Number 772559 6000144.4461106 2105441.7794376 37.7611492576992 -122.44261677830299 (37.7611492576992, -122.442616778303)
2806 18057 3 46 2882 Pine St 1 1 1 2     16 3X3   6000155.2064 2114785.6979 37.7868059046739 -122.443250696948 (37.7868059046739, -122.443250696948)
18446 25173 3 46 3062 Market St 1 1 1 2     80 3X3   6000161.42067 2105438.6168299997 37.761141541560505 -122.44255784368 (37.7611415415605, -122.44255784368)
1270 18055 3 46 2872 Pine St 1 1 1 2     12 3X3   6000192.328 2114789.41 37.786818213822706 -122.443122531996 (37.7868182138227, -122.443122531996)
17390 25188 3 46 3741 Market St 1 1 1 2     18 3X3   6000279.55164 2102883.22055 37.7541317821777 -122.44196585866501 (37.7541317821777, -122.441965858665)
124784 25189 3 46 3733 Market St 1 1 1 2     18 3x3   6000311.6199976 2102932.6354716998 37.754269290896104 -122.44185850513901 (37.7542692908961, -122.441858505139)
127 18052 3 46 2840 Pine St 2 1 1 2     18 3X3   6000317.799 2114808.7133 37.7868783690408 -122.442689819484 (37.7868783690408, -122.442689819484)
Powered by Datasette · Query took 56.151ms · Data source: data.sfgov.org