trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
436 120628 1 35 1500 Geary Blvd 5 Median : Cutout Tree 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
1049 120626 1 35 1500 Geary Blvd 3 Median : Cutout Tree 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
2117 111271 1 35 700X BOSWORTH ST 9 Front Yard : Yard Tree 1     42     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
37212 111553 1 35 900x BOSWORTH ST 31 Front Yard : Yard Tree 1     12     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
39660 111514 1 35 800x BOSWORTH ST 9 Front Yard : Yard Tree 1     12     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
40576 120625 1 35 1500 Geary Blvd 2 Median : Cutout Tree 1           6004349 2113949 37.7847467885767 -122.428681484586 (37.7847467885767, -122.428681484586) 13 9 11 29490 41
41737 115997 1 35 20X Park St 2 Median : Yard Tree 1   08/30/2016 09:25:00 AM 3     6004982.6 2096420.1 37.7366524147431 -122.425241679782 (37.7366524147431, -122.425241679782) 2 7 5 28859 2
45135 111279 1 35 700X BOSWORTH ST 17 Front Yard : Yard Tree 1     24     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
66177 109347 1 35 59x BURNSIDE AVE 1 Median : Yard Tree 1     14     6001229.7 2095779.3 37.7346801948558 -122.438171157158 (37.7346801948558, -122.438171157158) 2 7 5 63 7
66990 98838 1 35 1101X Portola Dr 7 Sidewalk: Property side : Yard Tree 1   04/11/2013 12:00:00 AM 3     5994967.95791 2097979.30417 37.740362747151 -122.459979297607 (37.740362747151, -122.459979297607) 9 8 4 59 40
68490 243115 1 35 5300x Diamond Heights Blvd 18 Median : Yard Tree 1   05/01/2017 12:00:00 AM 3     6001841.69539 2098643.31719 37.7425789076843 -122.436260181872 (37.7425789076843, -122.436260181872) 2 7 5 63 7
69254 111516 1 35 800x BOSWORTH ST 11 Front Yard : Yard Tree 1     14     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
69447 111507 1 35 800x BOSWORTH ST 2 Front Yard : Yard Tree 1     18     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
74434 120629 1 35 1500 Geary Blvd 6 Median : Cutout Tree 1           6004538 2114050 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681) 13 9 11 29490 13
87630 243112 1 35 5300x Diamond Heights Blvd 15 Median : Yard Tree 1   05/01/2017 12:00:00 AM 3     6001806.81928 2098684.11193 37.7426889388393 -122.436383692077 (37.7426889388393, -122.436383692077) 2 7 5 63 7
97385 112912 1 35 480X BEACON ST 2 Sidewalk: Property side : Yard Tree 1     30     6002571 2098077 37.7410653426557 -122.433697996676 (37.7410653426557, -122.433697996676) 2 7 5 63 7
101189 111558 1 35 900x BOSWORTH ST 36 Front Yard : Yard Tree 1     15     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
107565 252925 1 35 700 Sanchez St 2 Front Yard : Yard Tree 1           6003672 2104202 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181) 2 4 5 28862 3
113773 111508 1 35 800x BOSWORTH ST 3 Front Yard : Yard Tree 1     18     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
113834 243114 1 35 5300x Diamond Heights Blvd 17 Median : Yard Tree 1   05/01/2017 12:00:00 AM 3     6001830.21459 2098656.61242 37.7426147609522 -122.436300830338 (37.7426147609522, -122.436300830338) 2 7 5 63 7
115061 243111 1 35 5300x Diamond Heights Blvd 13 Median : Yard Tree 1   05/01/2017 12:00:00 AM 3     6001795.3662 2098698.75734 37.7427285009166 -122.436424341429 (37.7427285009166, -122.436424341429) 2 7 5 63 7
122378 101036 1 35 1010X Portola Dr 10 Front Yard : Yard Tree 1   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
127523 243106 1 35 5300x Diamond Heights Blvd 9 Median : Yard Tree 1   01/09/2018 12:00:00 AM 3     6001667.33897 2098826.57882 37.7430721930381 -122.436876170699 (37.7430721930381, -122.436876170699) 2 7 5 63 7
135146 243113 1 35 5300x Diamond Heights Blvd 16 Median : Yard Tree 1   05/01/2017 12:00:00 AM 3     6001816.52967 2098672.65474 37.7426580318326 -122.436349296602 (37.7426580318326, -122.436349296602) 2 7 5 63 7
138421 243116 1 35 5300x Diamond Heights Blvd 19 Median : Yard Tree 1   05/01/2017 12:00:00 AM 3     6001856.44522 2098624.22352 37.7425273189785 -122.436207815256 (37.7425273189785, -122.436207815256) 2 7 5 63 7
146907 243109 1 35 5300x Diamond Heights Blvd 10 Median : Yard Tree 1   05/01/2017 12:00:00 AM 3     6001750.32805 2098751.0187 37.7428694390712 -122.436583810118 (37.7428694390712, -122.436583810118) 2 7 5 63 7
147440 111557 1 35 900x BOSWORTH ST 35 Front Yard : Yard Tree 1     12     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
150152 120624 1 35 1500 Geary Blvd 1 Median : Cutout Tree 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
150320 111555 1 35 900x BOSWORTH ST 33 Front Yard : Yard Tree 1     24     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
156411 120627 1 35 1500 Geary Blvd 4 Median : Cutout Tree 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
162963 243101 1 35 5300x Diamond Heights Blvd 1 Median : Yard Tree 1   01/09/2018 12:00:00 AM 3     6001501.83115 2098971.73396 37.7434613467555 -122.437458843264 (37.7434613467555, -122.437458843264) 2 7 5 63 7
165137 101040 1 35 1010X Portola Dr 14 Front Yard : Yard Tree 1   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
165450 243102 1 35 5300x Diamond Heights Blvd 6 Median : Yard Tree 1   05/01/2017 12:00:00 AM 3     6001583.44665 2098902.15724 37.7432749451763 -122.437171657349 (37.7432749451763, -122.437171657349) 2 7 5 63 7
171251 111554 1 35 900x BOSWORTH ST 32 Front Yard : Yard Tree 1     26     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
175848 111265 1 35 700X BOSWORTH ST 3 Front Yard : Yard Tree 1     20     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
178910 61559 1 35 1096 Carolina St 1 Median : Cutout Tree 1   08/25/1984 12:00:00 AM 16   Permit Number 21519 6012461.11053783 2102868.78681941 37.7547787864142 -122.399837764002 (37.7547787864142, -122.399837764002) 10 3 8 28856 29
183037 8530 1 35 2100X Geary Blvd 1 Median : Cutout Tree 1   06/10/1994 12:00:00 AM 15     6001630.1932 2113615.3325 37.7836763773468 -122.438063730933 (37.7836763773468, -122.438063730933) 15 5 11 29490 41
183595 101034 1 35 1010X Portola Dr 8 Front Yard : Yard Tree 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
189067 243103 1 35 5300x Diamond Heights Blvd 8 Median : Yard Tree 1   05/01/2017 12:00:00 AM 3     6001619.86426 2098870.33574 37.7431896408852 -122.437043457211 (37.7431896408852, -122.437043457211) 2 7 5 63 7
83122 2045 1 35 700X Bosworth St 2 Median : Cutout Tree 1     24 10   6002154.6210393 2095431.8532492 37.7337787461998 -122.434948555048 (37.7337787461998, -122.434948555048) 2 7 5 63 7
160462 2028 1 35 600X Bosworth St 5 Median : Cutout Tree 1     12 10   6002398.10054 2095366.8333155 37.7336140379052 -122.434102128474 (37.7336140379052, -122.434102128474) 2 7 5 63 7
96483 4970 1 35 5200X Diamond Heights Blvd 6 Median : Cutout Tree 1   01/09/2018 12:00:00 AM 3 12   6000842.33366 2099520.2529 37.7449299333661 -122.439778532074 (37.7449299333661, -122.439778532074) 2 7 5 63 7
194257 4968 1 35 5200X Diamond Heights Blvd 4 Median : Cutout Tree 1   12/03/2018 12:00:00 AM 3 12   6000815.91312 2099549.13893 37.7450077436274 -122.439871959934 (37.7450077436274, -122.439871959934) 2 7 5 63 7
194284 4966 1 35 5200X Diamond Heights Blvd 2 Median : Cutout Tree 1   12/03/2018 12:00:00 AM 3 12   6000791.48606 2099581.9209 37.7450963646197 -122.439958774198 (37.7450963646197, -122.439958774198) 2 7 5 63 7
124888 2268 1 35 750X Brotherhood Way 2 Median : Cutout Tree 1     6 14M   5991074.0426161 2088106.2478104 37.7130290777882 -122.47272309172 (37.7130290777882, -122.47272309172) 1 8 4 64 14
164072 2266 1 35 700X Brotherhood Way 12 Median : Cutout Tree 1   04/04/2014 12:00:00 AM 22 14M Permit Number 772491 5991180.7931196 2088069.9959997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932) 1 8 4 64 14
161693 3773 1 35 1098 Carolina St 6 Median : Cutout Tree 1     12 18   6012462.6103665 2102859.9036449 37.754754478768 -122.399831953417 (37.754754478768, -122.399831953417) 10 3 8 28856 29
5625 19976 1 35 100 STAIRWAY45 3 Sidewalk: Curb side : Cutout Tree 1     12 30ST                      
7691 19980 1 35 100 STAIRWAY45 7 Sidewalk: Curb side : Cutout Tree 1     12 30ST                      
9342 23614 1 35 910X Vermont St 1 Sidewalk: Curb side : Cutout Tree 1     18 30X30PL   6011300.2113585 2104101.3880723 37.7580984495586 -122.403939228694 (37.7580984495586, -122.403939228694) 10 3 8 28856 29
66433 8563 1 35 2200 Geary Blvd 4 Sidewalk: Curb side : Cutout Tree 1     36 3X3   6001214.79121 2113518.75863 37.7833875775095 -122.439493935571 (37.7833875775095, -122.439493935571) 15 5 11 29490 13
71757 8562 1 35 2200 Geary Blvd 3 Sidewalk: Curb side : Cutout Tree 1     48 3X3   6001214.79121 2113518.75863 37.7833875775095 -122.439493935571 (37.7833875775095, -122.439493935571) 15 5 11 29490 13
107231 8560 1 35 2200 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree 1   06/01/1994 12:00:00 AM 6 3X3   6001214.79121 2113518.75863 37.7833875775095 -122.439493935571 (37.7833875775095, -122.439493935571) 15 5 11 29490 13
113256 8561 1 35 2200 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree 1   06/01/1994 12:00:00 AM 6 3X3   6001214.79121 2113518.75863 37.7833875775095 -122.439493935571 (37.7833875775095, -122.439493935571) 15 5 11 29490 13
129439 4367 1 35 973 Chenery St 1 Sidewalk: Curb side : Cutout Tree 1     24 3X3   6001101.12966 2096102.69208 37.7355608412513 -122.438638832041 (37.7355608412513, -122.438638832041) 2 7 5 63 7
83492 116067 1 35 4150X CLEMENT ST 5 Front Yard : Yard Tree 1   04/15/2016 12:00:00 AM 3 3x3 Permit Number 777818 5983115 2113126 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527) 11 6 2 55 15
86234 173745 1 35 500X Grand View Ave 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6000114 2102099 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22
106659 111575 1 35 1x SUNSET BLVD OFF RAMP 7 Median : Cutout Tree 1     5 3x3   5984955 2095624 37.7333147463652 -122.494426056577 (37.7333147463652, -122.494426056577) 1 8 4 64 35
193081 173746 1 35 500X Grand View Ave 3 Sidewalk: Curb side : Cutout Tree 1       3x3   6000114 2102099 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22
15936 19986 1 35 100 STAIRWAY46 6 Sidewalk: Curb side : Cutout Tree 1     12 40                      
187095 21459 1 35 2701X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree 1     12 40   5985119.0068215 2096832.7848434 37.7366433445438 -122.493948101207 (37.7366433445438, -122.493948101207) 1 8 3 29491 35
153963 24789 1 35 7700 Geary Blvd 1 Median : Cutout Tree 1     6 4X4   5983110.07731 2112460.67779 37.7794353864392 -122.502049785013 (37.7794353864392, -122.502049785013) 11 6 2 55 26
6586 258122 1 35 500X Clarendon Ave 4 Median : Cutout Tree 1   05/26/2019 09:11:00 PM 3 5x5                      
6935 258120 1 35 500X Clarendon Ave 2 Median : Cutout Tree 1   05/26/2019 09:06:00 PM 3 5x5                      
13326 258119 1 35 500X Clarendon Ave 1 Median : Cutout Tree 1   05/26/2019 09:14:00 PM 3 5x5                      
14131 258121 1 35 500X Clarendon Ave 3 Median : Cutout Tree 1   05/26/2019 09:09:00 PM 3 5x5                      
33534 27300 1 35 7900X Geary Blvd 1 Sidewalk: Curb side : Cutout Tree 1   06/10/1999 12:00:00 AM 6 5x5   5982547.93354 2112415.51016 37.7792783288562 -122.503991098801 (37.7792783288562, -122.503991098801) 11 6 2 55 26
20185 8536 1 35 2100 Geary Blvd 7 Median : Cutout Tree 1   06/10/1994 12:00:00 AM 6 6   6001688.6684406 2113658.1430724 37.7837972495813 -122.43786449651 (37.7837972495813, -122.43786449651) 15 5 11 29490 13
21559 8344 1 35 1300 Geary Blvd 10 Median : Cutout Tree 1   06/08/1994 12:00:00 AM 12 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
23996 8576 1 35 2200 Geary Blvd 3 Median : Cutout Tree 1     48 6   6001010.5429 2113459.32 37.7832127479531 -122.440196288881 (37.7832127479531, -122.440196288881) 15 5 11 29490 41
39949 8349 1 35 1300 Geary Blvd 15 Median : Cutout Tree 1     24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
43150 8574 1 35 2200 Geary Blvd 1 Median : Cutout Tree 1     6 6   6001134.4053 2113480.979 37.7832792690603 -122.439769329053 (37.7832792690603, -122.439769329053) 15 5 11 29490 41
43907 8339 1 35 1300 Geary Blvd 5 Median : Cutout Tree 1   06/08/1994 12:00:00 AM 18 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
60514 8341 1 35 1300 Geary Blvd 7 Median : Cutout Tree 1     24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
65234 8577 1 35 2200 Geary Blvd 4 Median : Cutout Tree 1     36 6   6000958.4259 2113453.9053 37.7831949132778 -122.440376203878 (37.7831949132778, -122.440376203878) 15 5 11 29490 41
79654 8340 1 35 1300 Geary Blvd 6 Median : Cutout Tree 1   06/08/1994 12:00:00 AM 24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
101800 8581 1 35 2200 Geary Blvd 8 Median : Cutout Tree 1     24 6   6000715.1007 2113420.9091 37.7830904567466 -122.441215640748 (37.7830904567466, -122.441215640748) 15 5 1 29490 41
116060 8575 1 35 2200 Geary Blvd 2 Median : Cutout Tree 1     48 6   6001093.7947 2113474.2106 37.7832583731226 -122.439909339764 (37.7832583731226, -122.439909339764) 15 5 11 29490 41
122803 8535 1 35 2100 Geary Blvd 6 Median : Cutout Tree 1     18 6   6001300.5704 2113502.1304 37.7833468021346 -122.439195981768 (37.7833468021346, -122.439195981768) 15 5 11 29490 41
125264 8348 1 35 1300 Geary Blvd 14 Median : Cutout Tree 1   06/08/1994 12:00:00 AM 6 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
126371 8532 1 35 2100 Geary Blvd 3 Median : Cutout Tree 1   06/10/1994 12:00:00 AM 6 6   6001535.4351 2113580.6442 37.7835757427727 -122.438389071264 (37.7835757427727, -122.438389071264) 15 5 11 29490 41
141624 8586 1 35 2200 Geary Blvd 13 Median : Cutout Tree 1     24 6   6000400.7068 2113377.2527 37.7829526738098 -122.442300177437 (37.7829526738098, -122.442300177437) 15 5 1 29490 41
150834 8342 1 35 1300 Geary Blvd 8 Median : Cutout Tree 1     24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
161286 8351 1 35 1300 Geary Blvd 17 Median : Cutout Tree 1     24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
170733 8578 1 35 2200 Geary Blvd 5 Median : Cutout Tree 1     18 6   6000905.6321 2113444.4294 37.7831658887746 -122.440558168856 (37.7831658887746, -122.440558168856) 15 5 11 29490 41
186033 8582 1 35 2200 Geary Blvd 9 Median : Cutout Tree 1     18 6   6000649.7853 2113412.1102 37.7830625764785 -122.441440973241 (37.7830625764785, -122.441440973241) 15 5 1 29490 41
187307 8537 1 35 2100 Geary Blvd 8 Median : Cutout Tree 1   06/10/1994 12:00:00 AM 3 6   6001688.6684406 2113658.1430724 37.7837972495813 -122.43786449651 (37.7837972495813, -122.43786449651) 15 5 11 29490 13
3808 20305 1 35 50X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree 1     24 60                      
13843 20301 1 35 50X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree 1     36 60                      
40897 21491 1 35 2792X Sunset Blvd 14 Sidewalk: Curb side : Cutout Tree 1     48 60   5985060.3629888 2096294.4798015 37.7351618711636 -122.49411119238 (37.7351618711636, -122.49411119238) 1 8 3 29491 35
49351 21431 1 35 2692X Sunset Blvd 28 Sidewalk: Curb side : Cutout Tree 1     36 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054) 1 8 3 29491 35
168039 21429 1 35 2692X Sunset Blvd 26 Sidewalk: Curb side : Cutout Tree 1     48 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054) 1 8 3 29491 35
4106 19663 1 35 100 STAIRWAY5 62 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
5212 19664 1 35 100 STAIRWAY5 63 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
6613 19666 1 35 100 STAIRWAY5 65 Sidewalk: Curb side : Cutout Tree 1     18 60ST                      
7975 19667 1 35 100 STAIRWAY5 66 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
103704 255364 1 35 700X Brotherhood Way 2 Median : Cutout Tree 1       6x10   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
154769 255363 1 35 700X Brotherhood Way 1 Median : Cutout Tree 1       6x10   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
26940 8472 1 35 1900 Geary Blvd 9 Median : Cutout Tree 1     6 8   6002074.2026 2113678.2789 37.7838744530021 -122.436532136471 (37.7838744530021, -122.436532136471) 13 5 11 29490 41
38568 8471 1 35 1900 Geary Blvd 8 Median : Cutout Tree 1   06/03/1994 12:00:00 AM 6 8   6002124.2891 2113678.9558 37.7838791576421 -122.43635890448 (37.7838791576421, -122.43635890448) 13 5 11 29490 41
45559 8390 1 35 1500 Geary Blvd 1 Median : Cutout Tree 1     36 8   6004488.7034 2114010.5767 37.7849237683164 -122.428202546761 (37.7849237683164, -122.428202546761) 13 9 11 29490 41