174 rows where Police Districts = 5 and qSpecies_id = 53

View and edit SQL

Police Districts

rowid ▼ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
3159 94569 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100@ Cole Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998051 2107197 37.7658490933668 -122.449983584058 (37.7658490933668, -122.449983584058) 15 5 11 29492 9
8384 104821 Undocumented 4 Ficus nitida :: Laurel Fig 53 2173 15TH ST   Sidewalk: Curb side : Cutout Tree Private 2     20     6003063.7 2107068.1 37.7657807169148 -122.432636512343 (37.7657807169148, -122.432636512343) 15 5 5 28862 3
8565 105233 Undocumented 4 Ficus nitida :: Laurel Fig 53 1508 WALLER ST 3 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5998474.1 2108297 37.7688936152058 -122.448599407064 (37.7688936152058, -122.448599407064) 15 5 11 29492 9
13077 34262 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3618 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/1997 12:00:00 AM 14 3x3 Permit Number 38067 6002793.22003166 2106527.80070587 37.7642818435653 -122.433533428216 (37.7642818435653, -122.433533428216) 15 5 5 28862 3
13231 248334 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1569 Waller St 1 Sidewalk: Property side : Cutout Tree Private 2     0 Width 0ft   5998104.0324 2108202.8007 37.7686138007777 -122.449872650062 (37.7686138007777, -122.449872650062) 15 5 11 29492 9
14591 17106 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1777 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   5998507.83576 2109285.1679 37.7716088013494 -122.448553894841 (37.7716088013494, -122.448553894841) 15 5 11 29492 9
19484 77283 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1210 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6001986.2323 2110871.5472 37.7761628769629 -122.436635509753 (37.7761628769629, -122.436635509753) 15 5 11 29492 10
19494 20113 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 800X OAK ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6002934 2109937 37.7736506563952 -122.433290134136 (37.7736506563952, -122.433290134136) 15 5 11 29492 9
19867 48735 Permitted Site 7 Ficus nitida :: Laurel Fig 53 36 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/1969 12:00:00 AM     Permit Number 46015 6001979.18448022 2107865.24554965 37.7679079189757 -122.436444672891 (37.7679079189757, -122.436444672891) 15 5 5 29492 3
20084 115908 Undocumented 4 Ficus nitida :: Laurel Fig 53 500x WALLER ST 5 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2016 12:00:00 AM 3 4x4   6003255 2109006 37.7711125644946 -122.432113248928 (37.7711125644946, -122.432113248928) 15 5 11 29492 9
20310 112288 Undocumented 4 Ficus nitida :: Laurel Fig 53 895x PAGE ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002361 2109458 37.7723029182135 -122.435237957834 (37.7723029182135, -122.435237957834) 15 5 11 29492 9
20699 17025 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1109 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6001571.2304 2109724.9634 37.7729910525637 -122.43798896281 (37.7729910525637, -122.43798896281) 15 5 11 29492 9
20709 109328 Undocumented 4 Ficus nitida :: Laurel Fig 53 1349 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2015 12:00:00 AM 3 3x3   5999000.5 2104870.1 37.7595142924854 -122.446532051538 (37.7595142924854, -122.446532051538) 15 5 5 28862 12
24756 55741 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2289 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/1973 12:00:00 AM 13 3x3 Permit Number 11768 6002326.09413197 2107044.17123182 37.7656731563843 -122.435186018715 (37.7656731563843, -122.435186018715) 15 5 5 28862 3
25241 8179 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1205X Fulton St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002000.37874 2111170.93633 37.7769857283744 -122.436608008152 (37.7769857283744, -122.436608008152) 15 5 11 29492 10
25450 17122 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1931 Oak St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   5997743.85041 2109170.01524 37.7712489089965 -122.451188245827 (37.7712489089965, -122.451188245827) 15 5 11 29492 9
26693 111116 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2085 Hayes St 4 Sidewalk: Curb side : Cutout Tree Private 2     12     5997903.58032533 2109906.22418863 37.7732794935428 -122.450688824407 (37.7732794935428, -122.450688824407) 15 5 11 29492 16
27436 107660 Undocumented 4 Ficus nitida :: Laurel Fig 53 1316 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5999083.9 2105040.7 37.7599874810533 -122.446255886285 (37.7599874810533, -122.446255886285) 15 5 5 28862 3
27757 16589 Permitted Site 7 Ficus nitida :: Laurel Fig 53 17 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 4X4PL   6002850.124051 2108197.2585517 37.768868996076 -122.433455924251 (37.768868996076, -122.433455924251) 15 5 5 28862 3
27991 97561 Undocumented 4 Ficus nitida :: Laurel Fig 53 1251X 04th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5994791.4 2106981 37.7650689602603 -122.461242116604 (37.7650689602603, -122.461242116604) 15 5 11 56 12
28234 109001 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
28579 116510 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1500x Waller St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998488 2108327 37.7689767823615 -122.448553488995 (37.7689767823615, -122.448553488995) 15 5 11 29492 9
28710 102826 Undocumented 4 Ficus nitida :: Laurel Fig 53 2001X Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997438 2109144 37.7711599615563 -122.452244312179 (37.7711599615563, -122.452244312179) 15 5 11 29492 9
32698 58520 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1486 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/02/1979 12:00:00 AM   7x7 Permit Number 17697 5998599.14429808 2108320.44227206 37.7689651308865 -122.448168577388 (37.7689651308865, -122.448168577388) 15 5 11 29492 9
32968 16997 Permitted Site 7 Ficus nitida :: Laurel Fig 53 903 Oak St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3X3   6002604.56537 2109869.28932 37.7734460452794 -122.43442485558 (37.7734460452794, -122.43442485558) 15 5 11 29492 9
35050 115907 Undocumented 4 Ficus nitida :: Laurel Fig 53 500x WALLER ST 4 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2016 12:00:00 AM 3 4x4   6003255 2109006 37.7711125644946 -122.432113248928 (37.7711125644946, -122.432113248928) 15 5 11 29492 9
38510 19240 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 701 Scott St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 8x6   6002037.68577 2110909.98609 37.7762713444054 -122.436460270394 (37.7762713444054, -122.436460270394) 15 5 11 29492 10
38742 113004 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
39074 20124 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 924X Fell St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002999.41967 2110319.25168 37.7747039360019 -122.433091154251 (37.7747039360019, -122.433091154251) 15 5 11 29492 10
39288 116011 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1448 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/09/2016 12:00:00 AM 3     6000920 2110390.8 37.7747822166773 -122.440289401956 (37.7747822166773, -122.440289401956) 15 5 11 29492 10
40868 173774 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2239 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002625 2107043 37.7656869095489 -122.434152085943 (37.7656869095489, -122.434152085943) 15 5 5 28862 3
43330 113005 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
43860 8182 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1218 Fulton St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6001778.22585 2111194.36963 37.7770374434445 -122.437378180533 (37.7770374434445, -122.437378180533) 15 5 11 29492 41
43961 17044 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1200X Oak St 8 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x5   6001235.1914802 2109729.1714048 37.7729834911046 -122.439151661694 (37.7729834911046, -122.439151661694) 15 5 11 29492 10
43985 111817 Undocumented 4 Ficus nitida :: Laurel Fig 53 80 ORD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6000817 2105938 37.7625500726099 -122.440326296311 (37.7625500726099, -122.440326296311) 15 5 5 28862 3
48462 111114 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2085 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2     10     5997903.58032533 2109906.22418863 37.7732794935428 -122.450688824407 (37.7732794935428, -122.450688824407) 15 5 11 29492 16
49452 86740 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1275 02nd Ave   Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49708 5995441.8 2106872.8 37.7648092803065 -122.458984723243 (37.7648092803065, -122.458984723243) 15 5 11 56 12
49558 113001 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
50094 253202 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 800 Oak St 4 Sidewalk: Property side : Cutout Tree DPW 1 Private     6x6   6003064 2109976 37.77376511482 -122.432843231253 (37.77376511482, -122.432843231253) 15 5 11 29492 10
51996 17674 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1015X Pierce St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002359.74374 2112046.46454 37.7794101245475 -122.435427501131 (37.7794101245475, -122.435427501131) 15 5 11 29490 41
52375 120531 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1390 Waller St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999052.33988667 2108383.59508746 37.7691644298026 -122.446605553634 (37.7691644298026, -122.446605553634) 15 5 11 29492 9
53774 20090 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2075X Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   5997085.68869 2109091.58753 37.7709958615587 -122.453459178714 (37.7709958615587, -122.453459178714) 15 5 11 29492 9
55603 17013 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1001 Oak St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002208.6674 2109818.85859 37.7732850945599 -122.43579071263 (37.7732850945599, -122.43579071263) 15 5 11 29492 9
57729 16813 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2097X O'Farrell St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   5999009.37837 2112716.355 37.7810586242256 -122.447066002739 (37.7810586242256, -122.447066002739) 15 5 1 54 16
59389 102825 Undocumented 4 Ficus nitida :: Laurel Fig 53 2001X Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997438 2109144 37.7711599615563 -122.452244312179 (37.7711599615563, -122.452244312179) 15 5 11 29492 9
60833 102647 Undocumented 4 Ficus nitida :: Laurel Fig 53 221 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x9   6002283 2109227 37.7716642197307 -122.435491238531 (37.7716642197307, -122.435491238531) 15 5 11 29492 9
61483 17037 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1200X Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6001158.18128 2109720.4277 37.7729551007398 -122.439417421896 (37.7729551007398, -122.439417421896) 15 5 11 29492 10
62158 20114 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 800X OAK ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6002934 2109937 37.7736506563952 -122.433290134136 (37.7736506563952, -122.433290134136) 15 5 11 29492 9
65361 17049 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1209 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6001136.98076 2109644.95458 37.7727466639243 -122.439485345621 (37.7727466639243, -122.439485345621) 15 5 11 29492 9
65899 109000 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     6 2x2 circle   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
66858 173948 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1300 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999106 2105162 37.7603218028196 -122.446188178838 (37.7603218028196, -122.446188178838) 15 5 5 28862 3
66963 45334 Permitted Site 7 Ficus nitida :: Laurel Fig 53 946 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 44166 6002468.75387281 2109900.46778234 37.7735239435411 -122.434896876631 (37.7735239435411, -122.434896876631) 15 5 11 29492 10
70103 121337 Permitted Site 7 Ficus nitida :: Laurel Fig 53 44 Hugo St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   5995656.55399656 2107084.69972772 37.7654034448102 -122.458257287589 (37.7654034448102, -122.458257287589) 15 5 11 56 12
74559 115904 Undocumented 4 Ficus nitida :: Laurel Fig 53 500x WALLER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6003255 2109006 37.7711125644946 -122.432113248928 (37.7711125644946, -122.432113248928) 15 5 11 29492 9
74570 102020 Undocumented 4 Ficus nitida :: Laurel Fig 53 4149X 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6001459 2105817 37.7622543686513 -122.438097188092 (37.7622543686513, -122.438097188092) 15 5 5 28862 3
75176 173949 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1306 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999102 2105133 37.7602419475954 -122.446199926833 (37.7602419475954, -122.446199926833) 15 5 5 28862 3
75844 13307 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1377X Oak St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6000417.28547 2109565.1947 37.7724866778901 -122.441969118639 (37.7724866778901, -122.441969118639) 15 5 11 29492 9
76288 20091 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2075X Oak St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   5997085.68869 2109091.58753 37.7709958615587 -122.453459178714 (37.7709958615587, -122.453459178714) 15 5 11 29492 9
77397 16979 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 830X Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x6   6003018.00984 2109974.66323 37.7737588358485 -122.43300222285 (37.7737588358485, -122.43300222285) 15 5 11 29492 10
77653 17118 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1907 Oak St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5997842.84103 2109183.73864 37.7712922571659 -122.4508468245 (37.7712922571659, -122.4508468245) 15 5 11 29492 9
79333 33008 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1311 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM   6x4 Permit Number 37302 5994224.05093468 2106581.50911401 37.7639393951455 -122.463175433011 (37.7639393951455, -122.463175433011) 1 5 11 56 12
79391 96083 Undocumented 4 Ficus nitida :: Laurel Fig 53 2177 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003180 2107100 37.7658749013738 -122.432236534109 (37.7658749013738, -122.432236534109) 15 5 5 28862 3
79887 16728 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1519 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   5999136.4110982 2112734.4359693 37.7811155269813 -122.446627836224 (37.7811155269813, -122.446627836224) 15 5 1 54 16
80201 20122 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 924X Fell St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002999.41967 2110319.25168 37.7747039360019 -122.433091154251 (37.7747039360019, -122.433091154251) 15 5 11 29492 10
80642 55728 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2158 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM 15 4x4 Permit Number 11754 6003183.89247133 2107143.93253238 37.7659957501376 -122.432226208659 (37.7659957501376, -122.432226208659) 15 5 5 28862 3
81702 93042 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110X Ord St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6000798.7 2105708.1 37.7619177818182 -122.440373100603 (37.7619177818182, -122.440373100603) 15 5 5 28862 3
84466 64020 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2344 15TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1987 12:00:00 AM     Permit Number 778144 6002015 2107091 37.7657840660528 -122.436265375372 (37.7657840660528, -122.436265375372) 15 5 5 28862 3
85569 48875 Permitted Site 7 Ficus nitida :: Laurel Fig 53 650 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2002 12:00:00 AM     Permit Number 46082 6002579.05689486 2108874.6714316 37.7707136224387 -122.434441965818 (37.7707136224387, -122.434441965818) 15 5 11 29492 9
87620 13306 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1377X Oak St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000417.28547 2109565.1947 37.7724866778901 -122.441969118639 (37.7724866778901, -122.441969118639) 15 5 11 29492 9
87820 20116 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 800X OAK ST 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002934 2109937 37.7736506563952 -122.433290134136 (37.7736506563952, -122.433290134136) 15 5 11 29492 9
90078 111115 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2085 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2     10     5997903.58032533 2109906.22418863 37.7732794935428 -122.450688824407 (37.7732794935428, -122.450688824407) 15 5 11 29492 16
92694 112578 Undocumented 4 Ficus nitida :: Laurel Fig 53 660x Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999086 2108401 37.7692141419233 -122.446490377962 (37.7692141419233, -122.446490377962) 15 5 11 29492 9
93895 173772 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2235 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002649 2107045 37.7656937631635 -122.434069218237 (37.7656937631635, -122.434069218237) 15 5 5 28862 3
94921 109333 Undocumented 4 Ficus nitida :: Laurel Fig 53 1317 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   5999055 2105304 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866) 15 5 5 28862 12
95195 58514 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1460 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/1979 12:00:00 AM   3x3 Permit Number 17691 5998731.52150291 2108338.88905051 37.7690233477366 -122.447712023248 (37.7690233477366, -122.447712023248) 15 5 11 29492 9
95868 19217 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1103X Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002080.8485 2110141.50629 37.7741637433971 -122.436255949697 (37.7741637433971, -122.436255949697) 15 5 11 29492 10
95956 58140 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2168 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/08/1978 12:00:00 AM 16 3x3 Permit Number 17124 6003092.5 2107149.8 37.7660066784939 -122.432542735552 (37.7660066784939, -122.432542735552) 15 5 5 28862 3
96594 94566 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998051 2107197 37.7658490933668 -122.449983584058 (37.7658490933668, -122.449983584058) 15 5 11 29492 9
97537 58524 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1544 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/02/1979 12:00:00 AM     Permit Number 17701 5998255.7040764 2108272.5838384 37.7688140844915 -122.449353060877 (37.7688140844915, -122.449353060877) 15 5 11 29492 9
99621 17017 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1047 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6001994.16718 2109794.13406 37.7732050204621 -122.436530926895 (37.7732050204621, -122.436530926895) 15 5 11 29492 9
100751 116905 Undocumented 4 Ficus nitida :: Laurel Fig 53 80 Beaver St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002383 2106795 37.7649922243231 -122.434971372236 (37.7649922243231, -122.434971372236) 15 5 5 28862 3
100953 8184 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1225 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6001879.34509 2111133.55167 37.7768762007109 -122.437024023016 (37.7768762007109, -122.437024023016) 15 5 11 29492 10
102388 113158 Undocumented 4 Ficus nitida :: Laurel Fig 53 1104 STANYAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997339 2106686 37.764405251212 -122.452409351598 (37.764405251212, -122.452409351598) 15 5 11 29492 9
102782 109882 Undocumented 4 Ficus nitida :: Laurel Fig 53 1520 PAGE ST 4 Sidewalk: Curb side : Cutout Tree Private 2       6x8   5999172.7 2109108.7 37.7711622584795 -122.446241403234 (37.7711622584795, -122.446241403234) 15 5 11 29492 9
103473 55732 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2229 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM 20   Permit Number 11758 6002695.31984114 2107064.65711257 37.7657503654861 -122.433910413324 (37.7657503654861, -122.433910413324) 15 5 5 28862 3
104097 62645 Permitted Site 7 Ficus nitida :: Laurel Fig 53 400 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM     Permit Number 25453 6000705.45672766 2110331.40246789 37.7746069085927 -122.441027287197 (37.7746069085927, -122.441027287197) 15 5 11 29492 10
105017 13309 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 300X Lyon St 2 Median : Cutout Tree DPW 1     6 100   6000275.5456666 2109923.7813264 37.7734631881999 -122.442485158742 (37.7734631881999, -122.442485158742) 15 5 11 29492 16
105056 116231 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1486 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5   5998599.14429808 2108320.44227206 37.7689651308865 -122.448168577388 (37.7689651308865, -122.448168577388) 15 5 11 29492 9
105584 113009 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
105646 10464 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1584 Haight St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   5998533.97425 2108659.62994 37.7698927281656 -122.448418425141 (37.7698927281656, -122.448418425141) 15 5 11 29492 9
106316 17014 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1001 Oak St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002208.6674 2109818.85859 37.7732850945599 -122.43579071263 (37.7732850945599, -122.43579071263) 15 5 11 29492 9
106362 115905 Undocumented 4 Ficus nitida :: Laurel Fig 53 500x WALLER ST 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6003255 2109006 37.7711125644946 -122.432113248928 (37.7711125644946, -122.432113248928) 15 5 11 29492 9
107825 113010 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
107943 104241 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1544 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998256.5 2108266.6 37.768797699923 -122.44934987666 (37.768797699923, -122.44934987666) 15 5 11 29492 9
107993 17088 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1611 Oak St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   5999244.55181 2109378.06634 37.77190597325 -122.446012243601 (37.77190597325, -122.446012243601) 15 5 11 29492 9
108160 14847 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1336 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002770.69391 2111673.82369 37.7784102764476 -122.433979208741 (37.7784102764476, -122.433979208741) 15 5 11 29490 41
111821 116112 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x SCOTT ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002265 2109203 37.7715972993524 -122.435551784305 (37.7715972993524, -122.435551784305) 15 5 11 29492 9
113625 13308 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 300X Lyon St 1 Median : Cutout Tree DPW 1     6 100   6000275.5456666 2109923.7813264 37.7734631881999 -122.442485158742 (37.7734631881999, -122.442485158742) 15 5 11 29492 16
115400 58777 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1500x Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/1980 12:00:00 AM   3x3 Permit Number 18128 5998488 2108327 37.7689767823615 -122.448553488995 (37.7689767823615, -122.448553488995) 15 5 11 29492 9
118914 113002 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);