Street_Tree_List

Data source: data.sfgov.org

643 rows where qSpecies = 61 sorted by rowid descending

View and edit SQL

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
165173 204287 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1723 12th Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5992461.83589 2103758.6049200003 37.756086768014995 -122.469064896048 (37.756086768015, -122.469064896048)
164438 205525 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 141 Greenwood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5995964.76572 2093711.7341900002 37.7287023163446 -122.45622427066002 (37.7287023163446, -122.45622427066)
164287 221134 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2820 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008816.36555 2106342.1549299997 37.7641119995907 -122.412687871844 (37.7641119995907, -122.412687871844)
163991 204318 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 110 Merced Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   5994644.68067 2099578.49879 37.7447351384188 -122.461212946744 (37.7447351384188, -122.461212946744)
163553 34707 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 678 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1997 12:00:00 AM 8   Permit Number 38364 5981677.4444 2111118.32695 37.7756654188698 -122.506906183465 (37.7756654188698, -122.506906183465)
163472 175556 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 675 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6002319.00588 2089864.96187 37.7185026508577 -122.43398243563499 (37.7185026508577, -122.433982435635)
163370 205563 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 45 Montecito Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 3ft   5996681.19029 2094527.91215 37.7309844449573 -122.45380647568399 (37.7309844449573, -122.453806475684)
162854 137857 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1845 LAGUNA ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6004358.4918 2115232.5475 37.7882716253172 -122.428740178583 (37.7882716253172, -122.428740178583)
162837 204306 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 40 Forest Side Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992602.3256 2098798.4802200003 37.7424756574394 -122.46821822299201 (37.7424756574394, -122.468218222992)
162700 204343 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 101 San Ramon Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5995730.23226 2092715.80427 37.725954266071 -122.456963055597 (37.725954266071, -122.456963055597)
162656 204321 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 270 San Fernando Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992107.33741 2095082.2192 37.7322431424058 -122.46965924719 (37.7322431424058, -122.46965924719)
162449 204304 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2554 19th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5990533.67464 2098000.2477599997 37.740164224398896 -122.475312663464 (37.7401642243989, -122.475312663464)
162447 204294 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2155 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5991295.02228 2100740.61314 37.7477326633329 -122.472880030596 (37.7477326633329, -122.472880030596)
162405 33264 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 1424 Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/13/1996 12:00:00 AM 8   Permit Number 37439 5988466.7481 2097653.8327 37.7390930364544 -122.48243379651501 (37.7390930364544, -122.482433796515)
162353 125714 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 941 Vallejo St 10 Front Yard : Yard 7 Tree 1 Private 1     7     6008973.41059 2118698.11415 37.7980473306652 -122.413018402384 (37.7980473306652, -122.413018402384)
162064 204273 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 347 Parnassus Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 5ft   5996336.12959 2106534.5413599997 37.76393187798529 -122.45586703204201 (37.7639318779853, -122.455867032042)
161057 205573 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 114 Santa Paula Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5993978.105 2097062.9530599997 37.7377896958481 -122.46333531168399 (37.7377896958481, -122.463335311684)
160980 33263 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 1422 Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/13/1996 12:00:00 AM 7   Permit Number 37438 5988495.8087 2097654.8706 37.7390975767362 -122.48233339540701 (37.7390975767362, -122.482333395407)
160749 183583 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2605 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5988610.8123 2097582.8977 37.738906646935895 -122.48193049915001 (37.7389066469359, -122.48193049915)
160448 32341 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 120 Burrows St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/2005 12:00:00 AM 6   Permit Number 47986 6010882.28946 2093426.3819099998 37.728763829978796 -122.404633115548 (37.7287638299788, -122.404633115548)
160322 33239 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 2581 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/07/1996 12:00:00 AM 8   Permit Number 37424 5988605.1751 2097786.0324 37.739464073986 -122.481964866217 (37.739464073986, -122.481964866217)
159852 205589 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1939 09th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5993443.93471 2102269.25213 37.752054085634704 -122.46556030186501 (37.7520540856347, -122.465560301865)
159448 52683 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 700 REVISED 37th Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/2006 12:00:00 AM 5   Permit Number 48754 5984474.1727 2110997.72398 37.7754985800658 -122.49722285223801 (37.7754985800658, -122.497222852238)
159373 38691 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 13904 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/07/1998 12:00:00 AM 8   Permit Number 40604 6001240.455 2110421.1619 37.7748838228637 -122.439183061176 (37.7748838228637, -122.439183061176)
159103 79179 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 1859 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/2007 12:00:00 AM 1 3x3 Permit Number 50037 5983166.9149 2102491.0694 37.7520650271804 -122.50111558741199 (37.7520650271804, -122.501115587412)
159052 221141 DPW Maintained 3 Arbutus unedo :: Strawberry Tree 61 500x 27th St 2 Median : Cutout 11 Tree 1 DPW 2     6 Width 4ft   6002659.15171 2100055.38577 37.7465025301635 -122.43353455080201 (37.7465025301635, -122.433534550802)
158878 205542 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 135 Colon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5996129.13326 2093930.4300400002 37.72931223654879 -122.455671846797 (37.7293122365488, -122.455671846797)
158696 204316 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 184 Forest Side Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5992299.25829 2097965.83058 37.740171904608204 -122.469205541028 (37.7401719046082, -122.469205541028)
158678 52682 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 3535 REVISED Balboa St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/2006 12:00:00 AM 5   Permit Number 48754 5984583.26235 2111053.32202 37.7756576289957 -122.496849595053 (37.7756576289957, -122.496849595053)
158553 47683 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 730 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/2002 12:00:00 AM 8   Permit Number 45474 5991337.42645 2110428.10245 37.7743343910633 -122.473439892203 (37.7743343910633, -122.473439892203)
158546 204256 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 40 Rossmoor Dr 2 : 4 Tree 1 Private 1     6 Width 3ft   5991070.06293 2094489.8143 37.7305565412538 -122.473202115591 (37.7305565412538, -122.473202115591)
158369 175548 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 127 Mount Vernon Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 1ft   5999115.8036400005 2089145.41882 37.7163446448588 -122.44500284583 (37.7163446448588, -122.44500284583)
158306 125712 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 956 Vallejo St 4 Front Yard : Yard 7 Tree 1 Private 1     15     6008850.76057 2118710.67422 37.798074931775396 -122.413443697187 (37.7980749317754, -122.413443697187)
158263 204332 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 351 Kenwood Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993583.80688 2093600.7249900002 37.7282605495865 -122.464447270321 (37.7282605495865, -122.464447270321)
158194 33163 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 1900 Santiago St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM 5   Permit Number 37385 5986968.1646 2099642.2172 37.7444653222212 -122.487761192729 (37.7444653222212, -122.487761192729)
158003 221169 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 217 Jersey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6003687.36586 2101552.84441 37.75067248686889 -122.430085907055 (37.7506724868689, -122.430085907055)
157656 205526 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 141 Greenwood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5995945.00881 2093703.6137400002 37.7286788854057 -122.456291984186 (37.7286788854057, -122.456291984186)
157325 40205 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 531 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1999 12:00:00 AM 10   Permit Number 41387 5982523.74709 2112147.83586 37.7785419514891 -122.50405493614099 (37.7785419514891, -122.504054936141)
157132 52677 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 700 REVISED 37th Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/2006 12:00:00 AM 7   Permit Number 48754 5984472.12802 2111009.36044 37.7755304106086 -122.49723078434401 (37.7755304106086, -122.497230784344)
156838 204236 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1330 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   5993657.9849 2106425.1721 37.7634775090049 -122.46512191475 (37.7634775090049, -122.46512191475)
156456 205596 DPW Maintained 3 Arbutus unedo :: Strawberry Tree 61 600x Laguna Honda Blvd 9 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   5995525.67673 2099905.10703 37.745682584978205 -122.458190285765 (37.7456825849782, -122.458190285765)
156387 221165 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1511 Castro St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002609.85714 2101016.35214 37.7491383207878 -122.433773677812 (37.7491383207878, -122.433773677812)
156074 51042 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 2031 19th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2004 12:00:00 AM 4   Permit Number 47515 5990334.5392 2101532.5464 37.749851453790605 -122.476259131856 (37.7498514537906, -122.476259131856)
156056 32640 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 2663 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM 9   Permit Number 37085 6010083.06076 2103949.57384 37.7576135254646 -122.408137970501 (37.7576135254646, -122.408137970501)
155939 205607 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 549 Joost Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5998498.386580001 2094968.0137599998 37.7322968768869 -122.447555816948 (37.7322968768869, -122.447555816948)
155705 205578 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 150 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5993989.91477 2096955.84067 37.737496272231205 -122.46328670960699 (37.7374962722312, -122.463286709607)
155622 74125 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1501 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/13/1994 12:00:00 AM 9     6007522.57983 2116468.5162 37.7918438593627 -122.417880578935 (37.7918438593627, -122.417880578935)
155264 204322 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 270 San Fernando Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992107.8063 2095069.8675799998 37.7322092550468 -122.46965672727801 (37.7322092550468, -122.469656727278)
155022 204284 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 927 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991101.29307 2102443.5789 37.752397346083896 -122.47367413827499 (37.7523973460839, -122.473674138275)
154225 52681 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 3535 REVISED Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/2006 12:00:00 AM 6   Permit Number 48754 5984542.32395 2111051.13386 37.7756492220711 -122.49699104738 (37.7756492220711, -122.49699104738)
154211 204227 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1773 09th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5993405.2188 2103425.86061 37.7552276015825 -122.46577821299101 (37.7552276015825, -122.465778212991)
153663 33178 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 3333 Ulloa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/05/1996 12:00:00 AM 8   Permit Number 37390 5985663.1141 2098179.7448 37.74037355789021 -122.49216606308599 (37.7403735578902, -122.492166063086)
153145 204274 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1786 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 5ft   5993146.90584 2103327.98453 37.7549439554161 -122.466664413955 (37.7549439554161, -122.466664413955)
152882 205543 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 35 Greenwood Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   5996424.35956 2093713.8664799999 37.7287345426545 -122.45463558948 (37.7287345426545, -122.45463558948)
152875 40214 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 483 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1999 12:00:00 AM 13   Permit Number 41394 5981888.55122 2112529.15759 37.7795515745255 -122.506280566157 (37.7795515745255, -122.506280566157)
152775 221112 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 400 Ellsworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008049.49369 2096950.1796799998 37.738280682507 -122.41467557324499 (37.738280682507, -122.414675573245)
152761 175555 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 744 Naples St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6002240.95464 2089320.7382099999 37.7170039036857 -122.434213341068 (37.7170039036857, -122.434213341068)
152677 205585 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 40 Maywood Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5994312.873380001 2096182.99146 37.7353928200065 -122.46211406653299 (37.7353928200065, -122.462114066533)
152385 221153 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 445 Anderson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6007892.34512 2096862.23202 37.7380303670096 -122.415212693326 (37.7380303670096, -122.415212693326)
152340 31373 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 616 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/21/1995 12:00:00 AM 17   Permit Number 34975 5991252.30155 2099116.74406 37.743271464822705 -122.47290936108801 (37.7432714648227, -122.472909361088)
152015 183584 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2609 25th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5988610.1868 2097562.569 37.7388507932479 -122.48193117307501 (37.7388507932479, -122.481931173075)
151895 31374 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 618 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/21/1995 12:00:00 AM 17   Permit Number 34976 5991223.6620000005 2099114.89273 37.7432647234805 -122.47300825323799 (37.7432647234805, -122.473008253238)
151597 140386 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1739 O'Farrell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6002991.9931 2113391.544 37.783139262071096 -122.433336428258 (37.7831392620711, -122.433336428258)
151267 221150 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 75 Piedmont St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5999396.601840001 2106952.45088 37.7652545262116 -122.445311861861 (37.7652545262116, -122.445311861861)
151222 204235 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1327 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993916.536730001 2106469.2082 37.7636133264094 -122.464230870957 (37.7636133264094, -122.464230870957)
151192 31864 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 1734 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/1995 12:00:00 AM 10   Permit Number 35306 5992515.136390001 2103625.8443 37.75572532149229 -122.468870905993 (37.7557253214923, -122.468870905993)
150566 205580 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 150 Santa Paula Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5993997.03811 2096919.5005400002 37.7373969016417 -122.463259444867 (37.7373969016417, -122.463259444867)
150533 205588 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1943 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5993444.46485 2102246.46663 37.7519915530764 -122.465556813412 (37.7519915530764, -122.465556813412)
150077 205536 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 521 Wildwood Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   5994768.77516 2093311.49345 37.7275346258157 -122.460329867332 (37.7275346258157, -122.460329867332)
149960 175554 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 751 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   6002038.05484 2089420.5116400002 37.7172663411433 -122.434921798223 (37.7172663411433, -122.434921798223)
149072 204253 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 205 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5995324.11092 2091288.71013 37.7220124772637 -122.45826373608601 (37.7220124772637, -122.458263736086)
148224 188231 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 123 Clementina St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6012859.425559999 2113671.68237 37.7844633085723 -122.399218553795 (37.7844633085723, -122.399218553795)
147953 33095 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 1127 Kearny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/05/1996 12:00:00 AM 11   Permit Number 37338 6011115.1734 2118807.4721 37.798467596260096 -122.405614950876 (37.7984675962601, -122.405614950876)
147940 118015 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 484 37th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   5984418.072319999 2112574.2634400004 37.779824014236205 -122.49753333513901 (37.7798240142362, -122.497533335139)
147936 204225 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1755 09th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5993401.713269999 2103536.7053900003 37.75553175049821 -122.46579838928001 (37.7555317504982, -122.46579838928)
147813 33323 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 3115 Gough St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/14/1996 12:00:00 AM 7   Permit Number 37465 6004629.84544 2120270.80512 37.802120751438295 -122.428160537697 (37.8021207514383, -122.428160537697)
147727 221156 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 461 Ellsworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6008056.95305 2096731.8919400002 37.737681731314105 -122.41463433930299 (37.7376817313141, -122.414634339303)
147647 125711 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 954 Vallejo St 2 Front Yard : Yard 7 Tree 1 Private 1     5     6008937.17158 2118714.51142 37.798090319168 -122.413144960375 (37.798090319168, -122.413144960375)
147400 204262 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1541 12th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992421.48169 2104887.89672 37.7591851761784 -122.469286646366 (37.7591851761784, -122.469286646366)
147008 204245 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 525 Laguna Honda Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5995534.84133 2100102.49255 37.746225083015794 -122.458172879382 (37.7462250830158, -122.458172879382)
146788 221099 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2815 18th St 2 : 4 Tree 1 Private 1     11 Width 3ft   6009329.84306 2105433.4467700003 37.7616457005982 -122.410847712362 (37.7616457005982, -122.410847712362)
146670 221162 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 112 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007705.04092 2107226.74413 37.7664784387541 -122.416594298407 (37.7664784387541, -122.416594298407)
146580 221148 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 71 Woodland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5997071.8183 2106141.02353 37.7628935738126 -122.453294106749 (37.7628935738126, -122.453294106749)
146509 204266 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 602 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   5992373.65673 2104591.5484 37.758368717652004 -122.46943047495701 (37.758368717652, -122.469430474957)
145688 68495 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 1771 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM     Permit Number 32371 5993402.07949897 2103439.3729604 37.7552645219201 -122.46579005124501 (37.7552645219201, -122.465790051245)
145517 39710 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 780 Joost Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/05/1999 12:00:00 AM     Permit Number 41095 5996936.4012082005 2095030.50112432 37.7323790624539 -122.45296043786999 (37.7323790624539, -122.45296043787)
145440 244151 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 403 Rose St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6004595.5153 2109633.7909 37.772912235932004 -122.427521090443 (37.772912235932, -122.427521090443)
145154 40747 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 60 Cedro Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/13/1999 12:00:00 AM     Permit Number 41720 5992465.74581598 2093166.10361938 37.7270026730351 -122.46828081444599 (37.7270026730351, -122.468280814446)
145150 69512 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 472 Nevada St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/24/1994 12:00:00 AM     Permit Number 33639 6008869.38717848 2096146.49207246 37.736119961903896 -122.411784001618 (37.7361199619039, -122.411784001618)
144740 39817 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 2101 46th Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM     Permit Number 41148 5981978.01419846 2100783.80216684 37.7473074654157 -122.505100399713 (37.7473074654157, -122.505100399713)
144431 68059 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 1755 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/26/1993 12:00:00 AM     Permit Number 31796 5993398.60860505 2103544.1147165 37.7555519155036 -122.465809664403 (37.7555519155036, -122.465809664403)
144108 86351 DPW Maintained 3 Arbutus unedo :: Strawberry Tree 61 2423 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/16/2015 10:30:00 AM 3 3x3   5988571.076426 2098824.756846 37.7423141562535 -122.482158841615 (37.7423141562535, -122.482158841615)
144090 46425 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 500x LAIDLEY ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/13/2002 12:00:00 AM   3x3 Permit Number 44647 6003128.0 2096056.0 37.7355477305103 -122.43162784146999 (37.7355477305103, -122.43162784147)
143861 40742 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 40 Cedro Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/13/1999 12:00:00 AM     Permit Number 41719 5992588.05334035 2093209.10678957 37.7271278125133 -122.46786112953899 (37.7271278125133, -122.467861129539)
143049 68041 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 1786 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/23/1993 12:00:00 AM     Permit Number 31778 5993148.36779464 2103327.49581212 37.7549426978918 -122.466659322623 (37.7549426978918, -122.466659322623)
141608 114519 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 199x WESTWOOD DR 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   5995156.0 2093967.0 37.7293567553632 -122.45903868041599 (37.7293567553632, -122.459038680416)
141121 111212 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 3100x 19TH ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   6008781.0 2105093.0 37.7606801217813 -122.412721875792 (37.7606801217813, -122.412721875792)
140857 40765 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 26 Entrada Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/13/1999 12:00:00 AM     Permit Number 41729 5992399.49150569 2092389.70166559 37.7248670377879 -122.46845338960199 (37.7248670377879, -122.468453389602)
140597 40745 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 40 Cedro Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/13/1999 12:00:00 AM     Permit Number 41719 5992588.05334035 2093209.10678957 37.7271278125133 -122.46786112953899 (37.7271278125133, -122.467861129539)
140544 52244 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 1550 22nd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2005 12:00:00 AM     Permit Number 48413 6013439.04799366 2103846.48755141 37.7575178110179 -122.396524293417 (37.7575178110179, -122.396524293417)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 36.208ms · Data source: data.sfgov.org