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            
5254 253839 3 16 94 Cortland Ave 1 1 1 2       3x3   6006239.0 2097690.0 37.740210176126794 -122.42098789234 (37.7402101761268, -122.42098789234)
19557 119842 3 35 350 Octavia St Frontage East 2 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
65293 119806 3 35 251X Octavia St Frontage West 3 1 1 2       3x3   6005545.0 2110174.0 37.7744491774234 -122.42427513465401 (37.7744491774234, -122.424275134654)
79671 115684 3 35 100x Octavia St Frontage East 4 1 1 2       4x4   6005589.0 2109665.0 37.773054070852496 -122.424086724818 (37.7730540708525, -122.424086724818)
80690 119841 3 35 350 Octavia St Frontage East 1 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
80706 119853 3 35 401 Octavia St Frontage West 1 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
81889 119810 3 35 250 Octavia St Frontage East 2 1 1 2       4x4   6005726.0 2110076.0 37.7741903117261 -122.42364205127599 (37.7741903117261, -122.423642051276)
82267 114834 3 198 251x TRUMBULL ST 16 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
82773 119812 3 35 250 Octavia St Frontage East 4 1 1 2       4x4   6005726.0 2110076.0 37.7741903117261 -122.42364205127599 (37.7741903117261, -122.423642051276)
82903 114822 3 198 251x TRUMBULL ST 4 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
83464 119866 3 35 451X Octavia St Frontage West 7 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
84338 119805 3 35 251X Octavia St Frontage West 2 1 1 2       3x3   6005545.0 2110174.0 37.7744491774234 -122.42427513465401 (37.7744491774234, -122.424275134654)
85800 119596 3 35 431 Octavia St 2 1 1 2       4x4   6005470.0 2110737.0 37.7759908035691 -122.42457463067 (37.7759908035691, -122.42457463067)
88602 114838 3 198 251x TRUMBULL ST 20 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
88617 115688 3 35 150X Octavia St Frontage East 2 1 1 2       4x4   6005692.21728 2109889.45005 37.7736761836422 -122.42374564492701 (37.7736761836422, -122.423745644927)
89929 119858 3 35 431 Octavia St Frontage West 2 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
91588 119804 3 35 251X Octavia St Frontage West 1 1 1 2       3x3   6005545.0 2110174.0 37.7744491774234 -122.42427513465401 (37.7744491774234, -122.424275134654)
91881 114825 3 198 251x TRUMBULL ST 7 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
91988 114837 3 198 251x TRUMBULL ST 19 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
92251 114828 3 198 251x TRUMBULL ST 10 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
93073 114824 3 198 251x TRUMBULL ST 6 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
93294 119598 3 35 401x Octavia St 1 1 1 2       4x4   6005458.0 2110677.0 37.7758253804544 -122.424611872791 (37.7758253804544, -122.424611872791)
95582 119809 3 35 250 Octavia St Frontage East 1 1 1 2       4x4   6005726.0 2110076.0 37.7741903117261 -122.42364205127599 (37.7741903117261, -122.423642051276)
96058 119851 3 35 331 Octavia St Frontage West 2 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
96072 109161 3 35 200 Octavia St Frontage East 7 1 1 2       4x4   6005726.0 2110076.0 37.7741903117261 -122.42364205127599 (37.7741903117261, -122.423642051276)
96639 111917 3 35 150X Octavia St Frontage East 1 1 1 2       4x4   6005692.21728 2109889.45005 37.7736761836422 -122.42374564492701 (37.7736761836422, -122.423745644927)
96725 109157 2 35 200 OCTAVIA ST 3 1 1 2   04/25/2016 12:00:00 AM   4x4   6005726.0 2110076.0 37.7741903117261 -122.42364205127599 (37.7741903117261, -122.423642051276)
97014 109160 3 35 200 Octavia St Frontage East 6 1 1 2       4x4   6005726.0 2110076.0 37.7741903117261 -122.42364205127599 (37.7741903117261, -122.423642051276)
97482 119877 3 35 450X Octavia St Frontage East 4 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
99034 106992 3 18 1701X Post St 2 1 1 2   04/01/2012 12:00:00 AM       6004025.8 2114231.4 37.785503891427005 -122.42981979958701 (37.785503891427, -122.429819799587)
99656 119850 3 35 331 Octavia St Frontage West 1 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
100139 119864 3 35 451X Octavia St Frontage West 5 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
101341 115455 3 35 300 Octavia St Frontage East 6 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
101488 119870 3 35 400X Octavia St Frontage East 4 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
101970 119856 3 35 431 Octavia St Frontage West 1 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
102125 119872 3 35 400X Octavia St Frontage East 6 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
102395 119863 3 35 451X Octavia St Frontage West 4 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
103270 114823 3 198 251x TRUMBULL ST 5 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
103508 106991 3 18 1701X Post St 1 1 1 2   04/01/2014 12:00:00 AM       6004025.8 2114231.4 37.785503891427005 -122.42981979958701 (37.785503891427, -122.429819799587)
103534 115686 3 35 100x Octavia St Frontage East 6 1 1 2       4x4   6005589.0 2109665.0 37.773054070852496 -122.424086724818 (37.7730540708525, -122.424086724818)
104070 119873 3 35 400X Octavia St Frontage East 7 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
105377 114831 3 198 251x TRUMBULL ST 13 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
105813 114826 3 198 251x TRUMBULL ST 8 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
107925 119597 3 35 431 Octavia St 3 1 1 2       4x4   6005470.0 2110737.0 37.7759908035691 -122.42457463067 (37.7759908035691, -122.42457463067)
108079 119843 3 35 350 Octavia St Frontage East 3 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
108332 114830 3 198 251x TRUMBULL ST 12 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
109355 119876 3 35 450X Octavia St Frontage East 3 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
110359 114827 3 198 251x TRUMBULL ST 9 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
111648 119720 3 35 150X Octavia St Frontage East 4 1 1 2       4x4   6005692.21728 2109889.45005 37.7736761836422 -122.42374564492701 (37.7736761836422, -122.423745644927)
112492 119852 3 35 331 Octavia St Frontage West 3 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
113327 115456 3 35 300 Octavia St Frontage East 7 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
113520 114821 3 198 251x TRUMBULL ST 3 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
115299 115687 3 35 100x Octavia St Frontage East 7 1 1 2       4x4   6005589.0 2109665.0 37.773054070852496 -122.424086724818 (37.7730540708525, -122.424086724818)
118718 119875 3 35 450X Octavia St Frontage East 2 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
119612 96804 3 35 1200X Revere Ave 1 22 1 2           6017205.4 2092876.1 37.7276042330013 -122.38273521775801 (37.7276042330013, -122.382735217758)
121524 119874 3 35 450X Octavia St Frontage East 1 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
122170 114832 3 198 251x TRUMBULL ST 14 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
122392 114820 3 198 251x TRUMBULL ST 2 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
124671 119865 3 35 451X Octavia St Frontage West 6 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
124768 109159 3 35 200 Octavia St Frontage East 5 1 1 2       4x4   6005726.0 2110076.0 37.7741903117261 -122.42364205127599 (37.7741903117261, -122.423642051276)
125682 115453 2 35 300 Octavia St Frontage East 4 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
127506 119859 3 35 431 Octavia St Frontage West 3 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
139109 114829 3 198 251x TRUMBULL ST 11 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
139389 114836 3 198 251x TRUMBULL ST 18 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
140404 114835 3 198 251x TRUMBULL ST 17 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
141123 114839 3 198 251x TRUMBULL ST 21 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
143597 119811 3 35 250 Octavia St Frontage East 3 1 1 2       4x4   6005726.0 2110076.0 37.7741903117261 -122.42364205127599 (37.7741903117261, -122.423642051276)
143671 114833 3 198 251x TRUMBULL ST 15 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
143683 115685 3 35 100x Octavia St Frontage East 5 1 1 2       4x4   6005589.0 2109665.0 37.773054070852496 -122.424086724818 (37.7730540708525, -122.424086724818)
144990 119871 3 35 400X Octavia St Frontage East 5 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
145152 119844 3 35 350 Octavia St Frontage East 4 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
145803 119595 3 35 431 Octavia St 1 1 1 2       4x4   6005470.0 2110737.0 37.7759908035691 -122.42457463067 (37.7759908035691, -122.42457463067)
118129 2453 3 35 1801X Buchanan St 1 1 1 2   06/26/2012 12:00:00 AM 0 4X4   6003961.1396892 2114603.1916159 37.786521075947796 -122.430070036959 (37.7865210759478, -122.430070036959)
26465 213721 3 237 66x Santa Monica Way 2 3 1 2     1     5993647.57824 2097426.08398 37.7387677148629 -122.46450445281401 (37.7387677148629, -122.464504452814)
27753 178904 3 35 10x Mansell St 4 11 1 2     1 Width 0ft   6011792.88406 2090769.7339700002 37.7215200714836 -122.401298496839 (37.7215200714836, -122.401298496839)
43899 214548 2 18 800 Irving St 2 1 1 2     1 Width 4ft   5993241.508719999 2106665.1801299998 37.7641124834295 -122.46657980664 (37.7641124834295, -122.46657980664)
154431 178903 3 35 10x Mansell St 3 11 1 2     1 Width 0ft   6011814.45609 2090752.0893599999 37.7214728265024 -122.401222688486 (37.7214728265024, -122.401222688486)
158887 121620 3 18 1300x Kansas St 1 11 1 2     1 3x3   6011700.392659999 2102280.30315 37.7531205008135 -122.402427173876 (37.7531205008135, -122.402427173876)
2513 138183 3 35 1865 Buchanan St 3 1 1 2   06/26/2012 12:00:00 AM 2 Width 0ft   6003936.4381 2114774.6580000003 37.7869904804487 -122.43016773530199 (37.7869904804487, -122.430167735302)
2541 138182 3 35 1865 Buchanan St 2 1 1 2   06/26/2012 12:00:00 AM 2 Width 0ft   6003933.6106 2114790.6807 37.7870343146011 -122.43017866131201 (37.7870343146011, -122.430178661312)
2544 138181 3 35 1865 Buchanan St 1 1 1 2   06/26/2012 12:00:00 AM 2 Width 0ft   6003932.1968 2114801.9909 37.7870652894849 -122.43018435992599 (37.7870652894849, -122.430184359926)
2550 138186 3 35 1865 Buchanan St 6 1 1 2     2 Width 0ft   6003941.622 2114719.9923 37.786840675810396 -122.43014589889499 (37.7868406758104, -122.430145898895)
31626 106986 3 35 1737-1795 Post St 7 1 1 2   04/01/2012 12:00:00 AM 2     6003814.6942 2114193.6153 37.7853881873399 -122.430547466156 (37.7853881873399, -122.430547466156)
37982 237111 3 18 2x Coso Ave 7 3 1 2     2     6007125.29232 2099860.06971 37.7462186223039 -122.418077248072 (37.7462186223039, -122.418077248072)
50088 1497 3 84 325 Arguello Blvd 3 1 1 2     2 3x3   5995534.5488977 2114067.6155393003 37.7845696798314 -122.45918496626999 (37.7845696798314, -122.45918496627)
51598 117842 3 16 620x 39th Ave 5 11 1 2     2 Width 6ft   5983810.65643 2111554.107 37.7769873385843 -122.499559205901 (37.7769873385843, -122.499559205901)
52167 214406 3 35 200x Terrace Dr 10 3 1 2     2     5993802.78615 2096495.7432 37.736222176613104 -122.463900308969 (37.7362221766131, -122.463900308969)
60634 117841 3 16 600x 39th Ave 1 11 1 2     2 Width 6ft   5983809.68656 2111621.06726 37.7771711351486 -122.499567510814 (37.7771711351486, -122.499567510814)
66160 214405 3 35 200x Terrace Dr 9 3 1 2     2     5993807.85396 2096495.9519200001 37.73622304175571 -122.46388280274701 (37.7362230417557, -122.463882802747)
87590 91928 3 18 1201X IRVING ST 4 1 1 2   02/19/2009 12:00:00 AM 2 3x3   5992070.0 2106573.0 37.7637917074669 -122.470624962715 (37.7637917074669, -122.470624962715)
98111 91929 3 18 1201X IRVING ST 2 1 1 2   06/11/2014 12:00:00 AM 2 3x3   5992070.0 2106573.0 37.7637917074669 -122.470624962715 (37.7637917074669, -122.470624962715)
110833 16607 3 35 107 Noe St 2 1 1 2     2 3X3   6002880.641859099 2107642.9841193003 37.7673488254303 -122.433310753696 (37.7673488254303, -122.433310753696)
131922 213728 3 237 66x San Lorenzo Way 13 3 1 2     2     5993678.600330001 2097499.69771 37.7389716280322 -122.464402537152 (37.7389716280322, -122.464402537152)
132802 106988 3 35 1737-1795 Post St 11 1 1 2   04/01/2012 12:00:00 AM 2     6003903.841 2114208.5386 37.7854342126943 -122.43024011010401 (37.7854342126943, -122.430240110104)
146849 106987 3 35 1737-1795 Post St 8 1 1 2   04/01/2012 12:00:00 AM 2     6003830.0102 2114195.5789 37.78539444652429 -122.430494617565 (37.7853944465243, -122.430494617565)
148511 212576 3 16 100x Idora Ave 7 3 1 2     2 Width 9ft   5995353.74805 2099410.49817 37.74431463161879 -122.458748984199 (37.7443146316188, -122.458748984199)
156598 106989 3 35 1737-1795 Post St 12 1 1 2   04/01/2012 12:00:00 AM 2     6003919.5496 2114210.5022 37.7854404939773 -122.430185903176 (37.7854404939773, -122.430185903176)
Powered by Datasette · Query took 31.212ms · Data source: data.sfgov.org