sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2538 39950 1 180 0 Ervine St 8 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
6380 46722 1 180   1 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
6817 39953 1 180 0 Ervine St 5 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
7518 39946 1 180 0 Ervine St 3 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
8803 39951 1 180 0 Ervine St 9 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
10505 39952 1 180 0 Ervine St 10 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
10637 46729 1 180   5 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
11296 39947 1 180 0 Ervine St 4 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
11344 46730 1 180   4 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
11625 46731 1 180   3 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
12724 39945 1 180 0 Ervine St 2 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
12755 39949 1 180 0 Ervine St 1 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
13635 39944 1 180 0 Ervine St 7 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
15467 46732 1 180   2 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
15759 39948 1 180 0 Ervine St 6 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
64858 179339 2 180 340 Tocoloma Ave 2 2 1 1     1 Width 3ft   6012524.83653 2086861.1237299999 37.7108286189149 -122.398494192156 (37.7108286189149, -122.398494192156)
58993 84117 1 180 61 Desmond St 1 1 1 1   06/05/2008 12:00:00 AM 8 3x3 Permit Number 50688 6010623.589380001 2086904.22894 37.710840875768206 -122.40506840807899 (37.7108408757682, -122.405068408079)
117606 86758 1 180 500 Brotherhood Way   19 1 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
85882 111097 1 180 67 SAINT CHARLES AVE 32 1 1 1           5992079.0 2088073.0 37.712995910736204 -122.46924723728901 (37.7129959107362, -122.469247237289)
103668 44146 1 180 67 SAINT CHARLES AVE 30 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992079.0 2088073.0 37.712995910736204 -122.46924723728901 (37.7129959107362, -122.469247237289)
20652 44154 1 180 67 Saint Charles Ave 9 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
58708 44145 1 180 67 Saint Charles Ave 29 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
77694 44160 1 180 67 Saint Charles Ave 1 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
78157 44147 1 180 67 Saint Charles Ave 22 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
78542 44139 1 180 67 Saint Charles Ave 21 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
81499 44142 1 180 67 Saint Charles Ave 26 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
85601 44157 1 180 67 Saint Charles Ave 6 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
86989 44153 1 180 67 Saint Charles Ave 10 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
91360 44137 1 180 67 Saint Charles Ave 19 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
94782 44151 1 180 67 Saint Charles Ave 3 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
99766 44156 1 180 67 Saint Charles Ave 7 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
100809 44144 1 180 67 Saint Charles Ave 28 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
103969 44148 1 180 67 Saint Charles Ave 23 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
109360 44138 1 180 67 Saint Charles Ave 20 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
114459 44152 1 180 67 Saint Charles Ave 11 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
119821 44143 1 180 67 Saint Charles Ave 27 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
122454 44158 1 180 67 Saint Charles Ave 5 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
122711 44155 1 180 67 Saint Charles Ave 8 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
123610 44140 1 180 67 Saint Charles Ave 25 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
124765 44161 1 180 67 Saint Charles Ave 4 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
140284 44159 1 180 67 Saint Charles Ave 2 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
141214 44136 1 180 67 Saint Charles Ave 18 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
144394 44150 1 180 67 Saint Charles Ave 24 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
42150 179345 2 180 96 Alpha St 5 7 1 1     1     6011048.99338 2088244.3601799998 37.7145443783829 -122.40369233834 (37.7145443783829, -122.40369233834)
152793 30885 1 180 248 Dublin St 1 1 1 1   03/08/1995 12:00:00 AM 16   Permit Number 34717 6003986.5052 2089044.44729 37.716344188011796 -122.42816013477899 (37.7163441880118, -122.428160134779)
169713 179343 2 180 26 Ervine St 11 7 1 1     7     6009596.1537 2089161.02063 37.716980073455204 -122.408778591782 (37.7169800734552, -122.408778591782)
159644 179344 2 180 26 Ervine St 4 7 1 1     7     6009638.385919999 2089289.7734599998 37.7173359675679 -122.40864169245899 (37.7173359675679, -122.408641692459)
49187 197204 2 180 961 Le Conte Ave 2 2 1 1     15     6013357.29959 2089363.32814 37.71774551972621 -122.395792202474 (37.7177455197262, -122.395792202474)
129752 214001 2 180 10 Caine Ave 14 4 1 1     5 Width 0ft   5997555.121730001 2089578.9570799998 37.717445842242604 -122.450428532174 (37.7174458422426, -122.450428532174)
19833 26915 3 180 10 Caine Ave 11 11 1 2   01/26/1999 12:00:00 AM 3 10   5997570.4467 2089598.1443599998 37.7174994031582 -122.450376943463 (37.7174994031582, -122.450376943463)
48006 200173 2 180 1022 Jamestown Ave 1 1 1 1     6 Width 0ft   6013894.556 2089735.8088 37.71879815104911 -122.39396119350599 (37.7187981510491, -122.393961193506)
132465 200174 2 180 1022 Jamestown Ave 2 1 1 1     6 Width 0ft   6013889.8173 2089740.206 37.718809961526 -122.393977881076 (37.718809961526, -122.393977881076)
87184 96226 3 180 14X CAINE AVE 11 11 1 2   08/24/2011 12:00:00 AM 3 6x300   5997641.2 2089761.8 37.7179528127364 -122.450144172407 (37.7179528127364, -122.450144172407)
99950 96227 3 180 14X CAINE AVE 10 11 1 2   08/24/2011 12:00:00 AM 3 6x300   5997641.2 2089761.8 37.7179528127364 -122.450144172407 (37.7179528127364, -122.450144172407)
42338 179342 3 180 700x Mansell St 45 11 1 2     4 Width 0ft   6009054.2584 2089931.4323900002 37.7190650967554 -122.410706045769 (37.7190650967554, -122.410706045769)
149405 113507 3 180 200x Mansell St 13 11 1 2     3 3x3   6011128.47606 2090549.92676 37.720879434926 -122.40357972973999 (37.720879434926, -122.40357972974)
181252 113496 3 180 200x Mansell St 2 11 1 2     6 3x3   6011235.51183 2090583.52363 37.7209776633755 -122.403212099473 (37.7209776633755, -122.403212099473)
26939 179341 3 180 100x Mansell St 9 11 1 2     11 Width 0ft   6011434.8537800005 2090631.08875 37.7211193983363 -122.40252637270599 (37.7211193983363, -122.402526372706)
65331 179340 3 180 10x Mansell St 11 11 1 2     18 Width 0ft   6011654.04439 2090707.0392200002 37.721340177375204 -122.40177402596301 (37.7213401773752, -122.401774025963)
77580 52426 1 180 300 Seneca Ave 5 1 1 1   12/22/2005 12:00:00 AM     Permit Number 48542 5999289.94205438 2090904.87008142 37.7211856330713 -122.44452732141501 (37.7211856330713, -122.444527321415)
81287 52425 1 180 300 Seneca Ave 4 1 1 1   12/22/2005 12:00:00 AM     Permit Number 48542 5999289.94205438 2090904.87008142 37.7211856330713 -122.44452732141501 (37.7211856330713, -122.444527321415)
83268 52423 1 180 300 Seneca Ave 2 1 1 1   12/22/2005 12:00:00 AM     Permit Number 48542 5999289.94205438 2090904.87008142 37.7211856330713 -122.44452732141501 (37.7211856330713, -122.444527321415)
88367 52424 1 180 300 Seneca Ave 3 1 1 1   12/22/2005 12:00:00 AM     Permit Number 48542 5999289.94205438 2090904.87008142 37.7211856330713 -122.44452732141501 (37.7211856330713, -122.444527321415)
120138 52422 1 180 300 Seneca Ave 1 1 1 1   12/22/2005 12:00:00 AM     Permit Number 48542 5999289.94205438 2090904.87008142 37.7211856330713 -122.44452732141501 (37.7211856330713, -122.444527321415)
66008 43425 1 180 310 Seneca Ave 7 1 1 1   07/18/2000 12:00:00 AM     Permit Number 43161 5999253.52417428 2090923.87202653 37.7212357299628 -122.444654572182 (37.7212357299628, -122.444654572182)
66742 43420 1 180 310 Seneca Ave 12 1 1 1   07/18/2000 12:00:00 AM     Permit Number 43161 5999253.52417428 2090923.87202653 37.7212357299628 -122.444654572182 (37.7212357299628, -122.444654572182)
83160 43430 1 180 310 Seneca Ave 1 1 1 1   07/18/2000 12:00:00 AM     Permit Number 43161 5999253.52417428 2090923.87202653 37.7212357299628 -122.444654572182 (37.7212357299628, -122.444654572182)
89914 43431 1 180 310 Seneca Ave 2 1 1 1   07/18/2000 12:00:00 AM     Permit Number 43161 5999253.52417428 2090923.87202653 37.7212357299628 -122.444654572182 (37.7212357299628, -122.444654572182)
92984 43422 1 180 310 Seneca Ave 10 1 1 1   07/18/2000 12:00:00 AM     Permit Number 43161 5999253.52417428 2090923.87202653 37.7212357299628 -122.444654572182 (37.7212357299628, -122.444654572182)
104433 43429 1 180 310 Seneca Ave 3 1 1 1   07/18/2000 12:00:00 AM     Permit Number 43161 5999253.52417428 2090923.87202653 37.7212357299628 -122.444654572182 (37.7212357299628, -122.444654572182)
107296 43423 1 180 310 Seneca Ave 9 1 1 1   07/18/2000 12:00:00 AM     Permit Number 43161 5999253.52417428 2090923.87202653 37.7212357299628 -122.444654572182 (37.7212357299628, -122.444654572182)
109115 43421 1 180 310 Seneca Ave 11 1 1 1   07/18/2000 12:00:00 AM     Permit Number 43161 5999253.52417428 2090923.87202653 37.7212357299628 -122.444654572182 (37.7212357299628, -122.444654572182)
114843 43426 1 180 310 Seneca Ave 6 1 1 1   07/18/2000 12:00:00 AM     Permit Number 43161 5999253.52417428 2090923.87202653 37.7212357299628 -122.444654572182 (37.7212357299628, -122.444654572182)
115515 43427 1 180 310 Seneca Ave 5 1 1 1   07/18/2000 12:00:00 AM     Permit Number 43161 5999253.52417428 2090923.87202653 37.7212357299628 -122.444654572182 (37.7212357299628, -122.444654572182)
117335 43428 1 180 310 Seneca Ave 4 1 1 1   07/18/2000 12:00:00 AM     Permit Number 43161 5999253.52417428 2090923.87202653 37.7212357299628 -122.444654572182 (37.7212357299628, -122.444654572182)
123196 43424 1 180 310 Seneca Ave 8 1 1 1   07/18/2000 12:00:00 AM     Permit Number 43161 5999253.52417428 2090923.87202653 37.7212357299628 -122.444654572182 (37.7212357299628, -122.444654572182)
182202 111445 1 180 241 Oneida Ave 35 1 1 2 6   7     5999980.8477300005 2091017.84349 37.721535231343296 -122.442147171851 (37.7215352313433, -122.442147171851)
12923 111444 1 180 241 Oneida Ave 34 1 1 2 6   14 6x12   5999970.3074 2091024.03837 37.721551640364396 -122.442184051271 (37.7215516403644, -122.442184051271)
45429 111443 1 180 241 Oneida Ave 33 1 1 2 6   17     5999927.23458 2091047.72982 37.7216142367899 -122.442334641847 (37.7216142367899, -122.442334641847)
180178 111442 1 180 241 Oneida Ave 32 1 1 2 6   8     5999909.42688 2091057.1743400001 37.721639154299204 -122.44239687581002 (37.7216391542992, -122.44239687581)
162227 111441 1 180 241 Oneida Ave 31 1 1 2 6   5     5999897.1183 2091063.84845 37.721656778309494 -122.442439902078 (37.7216567783095, -122.442439902078)
54575 111440 1 180 241 Oneida Ave 30 1 1 2 6   12     5999883.47669 2091070.55057 37.72167440322979 -122.442487538293 (37.7216744032298, -122.442487538293)
183638 111439 1 180 241 Oneida Ave 29 1 1 2 6   6     5999870.68262 2091075.2427400001 37.721686557579204 -122.44253210058201 (37.7216865575792, -122.442532100582)
28704 43445 1 180 241 Oneida Ave 28 1 1 2 6 07/18/2000 12:00:00 AM 5   Permit Number 43162 5999858.82768 2091082.35027 37.7217053974709 -122.44257358990299 (37.7217053974709, -122.442573589903)
24577 43433 1 180 241 Oneida Ave 27 1 1 2 6 07/18/2000 12:00:00 AM 16   Permit Number 43162 5999846.51913 2091089.02473 37.7217230223792 -122.442616616172 (37.7217230223792, -122.442616616172)
33677 43434 1 180 241 Oneida Ave 26 1 1 2 6 07/18/2000 12:00:00 AM 7   Permit Number 43162 5999832.90051 2091096.8327900001 37.7217436851966 -122.44266425237 (37.7217436851966, -122.44266425237)
45283 43435 1 180 241 Oneida Ave 25 1 1 2 6 07/18/2000 12:00:00 AM 14   Permit Number 43162 5999819.49506 2091104.19362 37.7217631321556 -122.44271111962699 (37.7217631321556, -122.442711119627)
93570 111448 1 180 241 Oneida Ave 38 1 1 2 6     6x7   5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334)
96890 111446 1 180 241 Oneida Ave 36 1 1 2 6         5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334)
111981 43455 1 180 241 Oneida Ave 11 1 1 2 6 07/18/2000 12:00:00 AM     Permit Number 43162 5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334)
113461 111447 1 180 241 Oneida Ave 37 1 1 2 6         5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334)
123447 43449 1 180 241 Oneida Ave 24 1 1 2 6 07/18/2000 12:00:00 AM 7   Permit Number 43162 5999756.32409 2091134.05765 37.7218415305512 -122.442931628018 (37.7218415305512, -122.442931628018)
135134 43451 1 180 241 Oneida Ave 23 1 1 2 6 07/18/2000 12:00:00 AM 1   Permit Number 43162 5999743.131580001 2091140.9715900002 37.7218597624867 -122.442977727254 (37.7218597624867, -122.442977727254)
19137 29594 3 180 900X Junipero Serra Blvd 3 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991181.08119 2091145.24325 37.7213796099522 -122.472574562389 (37.7213796099522, -122.472574562389)
133363 43450 1 180 241 Oneida Ave 22 1 1 2 6 07/18/2000 12:00:00 AM 1   Permit Number 43162 5999728.91774 2091148.65353 37.72188004492379 -122.443027412104 (37.7218800449238, -122.443027412104)
66622 43448 1 180 241 Oneida Ave 21 1 1 2 6 07/18/2000 12:00:00 AM 9   Permit Number 43162 5999710.3638 2091158.16281 37.721905097333 -122.443092230725 (37.721905097333, -122.443092230725)
151274 179338 2 180 2134 San Jose Ave 8 9 1 1     5 Width 8ft   5998927.16036 2091160.9726 37.7218681244079 -122.44579975756201 (37.7218681244079, -122.445799757562)
155143 43447 1 180 241 Oneida Ave 20 1 1 2 6 07/18/2000 12:00:00 AM 1   Permit Number 43162 5999697.54909 2091165.42889 37.7219243176433 -122.443137049362 (37.7219243176433, -122.443137049362)
187095 43432 1 180 241 Oneida Ave 19 1 1 2 6 07/18/2000 12:00:00 AM 3   Permit Number 43162 5999683.18724 2091173.0602 37.7219444525549 -122.443187242296 (37.7219444525549, -122.443187242296)
162642 43446 1 180 241 Oneida Ave 18 1 1 2 6 07/18/2000 12:00:00 AM 1   Permit Number 43162 5999670.6407 2091179.60867 37.721961717728 -122.44323108247299 (37.721961717728, -122.443231082473)
68075 43459 1 180 241 Oneida Ave 17 1 1 2 6 07/18/2000 12:00:00 AM 5   Permit Number 43162 5999660.0285 2091185.4802700002 37.7219772346577 -122.443268187573 (37.7219772346577, -122.443268187573)
Powered by Datasette · Query took 6.387ms · Data source: data.sfgov.org