trees

302 rows where qSpecies_id = 167 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

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)
1585 34112 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1398 Plymouth Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37977 5995892.17100072 2093289.41859175 37.7275385716585 -122.456444707829 (37.7275385716585, -122.456444707829) 9 7 4 28861 40
23016 60906 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1443 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1983 12:00:00 AM     Permit Number 20696 5994564.62076665 2105704.92459357 37.7615521348608 -122.461933943385 (37.7615521348608, -122.461933943385) 1 5 11 56 12
26232 54232 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1265 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1983 12:00:00 AM     Permit Number 9972 5995143.28929522 2106927.58636529 37.7649425453263 -122.460021156774 (37.7649425453263, -122.460021156774) 15 5 11 56 12
28226 46608 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1166 Noriega St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2002 12:00:00 AM     Permit Number 44731 5990419.11281219 2103161.32215556 37.7543285475592 -122.476085621892 (37.7543285475592, -122.476085621892) 1 8 4 56 12
31006 44821 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1608 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/2001 12:00:00 AM     Permit Number 43913 5993106.95790851 2104515.64796333 37.7582026654605 -122.466888899121 (37.7582026654605, -122.466888899121) 1 8 4 56 12
31857 65669 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 979 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1990 12:00:00 AM     Permit Number 28589 5998410.3805024 2095666.47034675 37.734209643166 -122.447910340725 (37.734209643166, -122.447910340725) 9 7 4 59 40
33084 47171 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 230 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2002 12:00:00 AM     Permit Number 45135 5992362.95598719 2095257.05561838 37.7327379703821 -122.468788241573 (37.7327379703821, -122.468788241573) 9 8 4 59 40
33231 64308 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1519 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/10/1988 12:00:00 AM     Permit Number 25119 6003981.51464704 2099431.34343854 37.7448639932298 -122.428917482655 (37.7448639932298, -122.428917482655) 2 7 5 63 22
34044 39132 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 786 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40812 6007317.12360596 2102737.01571967 37.7541288594826 -122.417617789975 (37.7541288594826, -122.417617789975) 2 4 7 28859 19
34366 51866 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 141 Alpine Ter 2 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2005 12:00:00 AM     Permit Number 48086 6001731.90100781 2108013.17914536 37.7683000536682 -122.43731059058 (37.7683000536682, -122.43731059058) 15 5 5 29492 3
34370 63667 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 4040 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/02/1987 12:00:00 AM     Permit Number 24317 6003634.2199128 2100428.29946056 37.7475817391255 -122.430189473003 (37.7475817391255, -122.430189473003) 2 4 5 63 22
37361 63891 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 61 Brady St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1987 12:00:00 AM     Permit Number 24600 6006704.26059714 2109561.52554736 37.7728328593412 -122.420221545678 (37.7728328593412, -122.420221545678) 8 2 9 28853 19
39527 139116 Undocumented 4 Prunus blireiana :: Flowering Plum 167 1501 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6004490.8408 2114272.6601 37.7856435047825 -122.428213836711 (37.7856435047825, -122.428213836711) 13 9 11 29490 13
43973 64675 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 827 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/07/1988 12:00:00 AM     Permit Number 25611 6005699.53822151 2104160.47613012 37.7579461954401 -122.423312985478 (37.7579461954401, -122.423312985478) 2 4 5 28859 19
45898 34127 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1401 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37983 5995840.26429469 2093321.75315516 37.7276243745144 -122.456626485978 (37.7276243745144, -122.456626485978) 9 7 4 28861 40
47162 44322 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 3101 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/02/2001 12:00:00 AM     Permit Number 43712 6007112.9770146 2100542.34949089 37.7480913155606 -122.418168196056 (37.7480913155606, -122.418168196056) 2 4 7 28859 2
47384 51865 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 141 Alpine Ter 1 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2005 12:00:00 AM     Permit Number 48086 6001731.90100781 2108013.17914536 37.7683000536682 -122.43731059058 (37.7683000536682, -122.43731059058) 15 5 5 29492 3
50692 51422 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 655 05th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM   3x3 Permit Number 52282 6013199.59186321 2110555.37408537 37.7759255920049 -122.397823019146 (37.7759255920049, -122.397823019146) 6 2 9 28856 34
51191 56269 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 27 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2001 12:00:00 AM     Permit Number 44402 6006135.85394887 2104023.0641993 37.7575935091812 -122.421794258753 (37.7575935091812, -122.421794258753) 2 4 5 28859 19
51250 85264 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 3000 Ocean Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM     Permit Number 49557 5989530.4 2095609.1 37.7335405447433 -122.478606721292 (37.7335405447433, -122.478606721292) 1 8 4 64 35
56501 45755 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 27 Liberty St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2001 12:00:00 AM     Permit Number 44402 6006135.85394887 2104023.0641993 37.7575935091812 -122.421794258753 (37.7575935091812, -122.421794258753) 2 4 5 28859 19
62681 59573 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 964 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/07/1981 12:00:00 AM     Permit Number 18963 6003107.75578888 2102621.90086172 37.7535750192842 -122.432166582864 (37.7535750192842, -122.432166582864) 2 4 5 28862 22
73350 67526 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1301 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/22/1992 12:00:00 AM     Permit Number 31064 6013774.38377619 2105211.91246173 37.761285626876 -122.395460215282 (37.761285626876, -122.395460215282) 10 3 8 28856 29
77109 65661 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 76 Melrose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1990 12:00:00 AM     Permit Number 28581 5999609.85654862 2095526.3392082 37.7338933644168 -122.443753320491 (37.7338933644168, -122.443753320491) 9 7 4 63 40
77173 256161 Undocumented 4 Prunus blireiana :: Flowering Plum 167 198X Peralta Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009711 2099918 37.7465228810693 -122.409140238555 (37.7465228810693, -122.409140238555) 2 7 7 28859 2
77254 60515 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 255 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1989 12:00:00 AM     Permit Number 25818 6004877.54107387 2099860.14096955 37.7460920491494 -122.425849704584 (37.7460920491494, -122.425849704584) 2 7 5 63 22
77356 60791 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 276 Ewing Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/14/1983 12:00:00 AM     Permit Number 20465 5998453.93543616 2112227.70718861 37.7796851739557 -122.44895233828 (37.7796851739557, -122.44895233828) 15 6 2 54 16
78325 44326 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 3101 Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/02/2001 12:00:00 AM     Permit Number 43712 6007112.9770146 2100542.34949089 37.7480913155606 -122.418168196056 (37.7480913155606, -122.418168196056) 2 4 7 28859 2
78768 50189 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 350 Noriega St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2003 12:00:00 AM     Permit Number 46896 5992966.98430504 2103249.49310039 37.7547180534592 -122.467280921215 (37.7547180534592, -122.467280921215) 1 8 4 56 12
79931 60386 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1432 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1982 12:00:00 AM     Permit Number 19966 6015791.47503069 2094604.97930734 37.7322731738529 -122.387743792201 (37.7322731738529, -122.387743792201) 10 3 8 58 1
81771 63785 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 4007 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24470 6003796.64349499 2101262.51482532 37.7498814982247 -122.42968731122 (37.7498814982247, -122.42968731122) 2 4 5 28862 22
82409 63662 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 3929 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/02/1987 12:00:00 AM     Permit Number 24311 6004353.00566134 2100414.81780831 37.7475854070132 -122.427702994 (37.7475854070132, -122.427702994) 2 4 5 63 22
83252 64834 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 552 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/1989 12:00:00 AM     Permit Number 25843 6002326.41169322 2099472.15020661 37.7448822177818 -122.434643430049 (37.7448822177818, -122.434643430049) 2 7 5 63 22
83761 44069 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 45 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43593 6002668.59972375 2105639.21740039 37.761834937896 -122.433900935359 (37.761834937896, -122.433900935359) 15 4 5 28862 3
84475 64804 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1476 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1989 12:00:00 AM     Permit Number 25803 6003915.51476447 2099673.7745449 37.7455259170349 -122.42916298071 (37.7455259170349, -122.42916298071) 2 7 5 63 22
88206 44237 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 415 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2001 12:00:00 AM     Permit Number 43676 6001527.40561887 2103403.09040324 37.755630249317 -122.437687712198 (37.755630249317, -122.437687712198) 2 4 5 28862 22
89930 67744 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1460 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1992 12:00:00 AM     Permit Number 31363 5994310.57601305 2105578.84704093 37.7611913298083 -122.462803426682 (37.7611913298083, -122.462803426682) 1 5 11 56 12
90030 40825 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 695 05th St 6 Sidewalk: Curb side : Cutout Tree Private 2   08/26/1999 12:00:00 AM     Permit Number 41762 6013368.81391754 2110378.20910645 37.7754485595516 -122.39722520599 (37.7754485595516, -122.39722520599) 6 2 9 28856 34
91037 65677 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 25 Sequoia Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/1990 12:00:00 AM     Permit Number 28597 5998247.19530514 2097659.9759073 37.7396740035761 -122.448618049723 (37.7396740035761, -122.448618049723) 9 7 4 59 40
92552 63685 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1488 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1987 12:00:00 AM     Permit Number 24342 6003919.51862242 2099605.68059427 37.7453391734545 -122.429144281616 (37.7453391734545, -122.429144281616) 2 7 5 63 22
96098 109293 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 370 27th St 2 Sidewalk: Curb side : Cutout Tree Private 2           6004104.9 2100171.3 37.7469027259862 -122.428543573264 (37.7469027259862, -122.428543573264) 2 7 5 63 22
97602 63680 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1290 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1987 12:00:00 AM     Permit Number 24335 6003854.79358898 2100760.12330994 37.7485053408812 -122.42945040251 (37.7485053408812, -122.42945040251) 2 4 5 28862 22
99731 65675 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 35 Sequoia Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/1990 12:00:00 AM     Permit Number 28595 5998245.89042686 2097529.81502266 37.7393165384712 -122.448613189427 (37.7393165384712, -122.448613189427) 9 7 4 59 40
101816 63684 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1477 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1987 12:00:00 AM     Permit Number 24341 6003967.42510642 2099676.82682244 37.7455372363545 -122.428983700412 (37.7455372363545, -122.428983700412) 2 7 5 63 22
103090 60911 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 9 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1983 12:00:00 AM     Permit Number 20703 5995767.1919331 2107036.52457374 37.7652775252135 -122.457871132491 (37.7652775252135, -122.457871132491) 15 5 11 56 12
103124 65676 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 29 Sequoia Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/1990 12:00:00 AM     Permit Number 28596 5998246.67335369 2097607.91153994 37.7395310174996 -122.448616105598 (37.7395310174996, -122.448616105598) 9 7 4 59 40
104270 63655 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1374 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1987 12:00:00 AM     Permit Number 24302 6003882.00730683 2100268.96113166 37.747158264512 -122.429321278666 (37.747158264512, -122.429321278666) 2 7 5 63 22
105028 39133 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 786 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/1999 12:00:00 AM     Permit Number 40812 6007317.12360596 2102737.01571967 37.7541288594826 -122.417617789975 (37.7541288594826, -122.417617789975) 2 4 7 28859 19
106286 63666 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 4019 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/02/1987 12:00:00 AM     Permit Number 24316 6003771.80904203 2100383.61201619 37.7474668298055 -122.42971051138 (37.7474668298055, -122.42971051138) 2 4 5 63 22
106731 65345 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 182 Lippard Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/21/1994 12:00:00 AM     Permit Number 28177 6001753.2001687 2095039.63295635 37.7326789990165 -122.43630832371 (37.7326789990165, -122.43630832371) 9 7 5 63 40
110192 49555 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 71REVISED Bronte St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2003 12:00:00 AM     Permit Number 46444 6009365.93611768 2097039.29774225 37.7385992569024 -122.410130235329 (37.7385992569024, -122.410130235329) 10 7 7 28859 2
110536 46606 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1166 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2002 12:00:00 AM     Permit Number 44731 5990419.11281219 2103161.32215556 37.7543285475592 -122.476085621892 (37.7543285475592, -122.476085621892) 1 8 4 56 12
112731 64368 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 416 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1988 12:00:00 AM     Permit Number 25207 6010971.78233994 2119344.22600524 37.7999333725763 -122.406148966564 (37.7999333725763, -122.406148966564) 3 1 10 308 23
113099 46607 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1166 Noriega St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2002 12:00:00 AM     Permit Number 44731 5990419.11281219 2103161.32215556 37.7543285475592 -122.476085621892 (37.7543285475592, -122.476085621892) 1 8 4 56 12
119371 64408 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 80 Montcalm St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/1988 12:00:00 AM     Permit Number 25254 6010509.94669729 2100012.34807199 37.7468266663579 -122.406384201378 (37.7468266663579, -122.406384201378) 2 7 7 28859 2
121892 46605 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1166 Noriega St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2002 12:00:00 AM     Permit Number 44731 5990419.11281219 2103161.32215556 37.7543285475592 -122.476085621892 (37.7543285475592, -122.476085621892) 1 8 4 56 12
123284 85263 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 3000 Ocean Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM     Permit Number 49557 5989530.4 2095609.1 37.7335405447433 -122.478606721292 (37.7335405447433, -122.478606721292) 1 8 4 64 35
123402 63670 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1480 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/02/1987 12:00:00 AM     Permit Number 24320 6003916.84938378 2099651.07656136 37.7454636691757 -122.429156747668 (37.7454636691757, -122.429156747668) 2 7 5 63 22
123995 48404 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 229 States St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2002 12:00:00 AM     Permit Number 45785 6000714.62430191 2106535.28548397 37.7641842416872 -122.440723221205 (37.7641842416872, -122.440723221205) 15 5 5 28862 3
127350 98667 Undocumented 4 Prunus blireiana :: Flowering Plum 167 396 Townsend St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013391.9 2110381 37.7754575079339 -122.397145540942 (37.7754575079339, -122.397145540942) 6 2 9 28856 34
127426 45342 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 466 Ralston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/27/2001 12:00:00 AM     Permit Number 44172 5992247.31717609 2090977.05466926 37.7209794647769 -122.46887668176 (37.7209794647769, -122.46887668176) 9 8 6 64 24
127653 39615 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 41 Grattan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41016 5998377.05402267 2106536.9754029 37.7640554838896 -122.44880829126 (37.7640554838896, -122.44880829126) 15 5 11 29492 9
133226 46266 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1461 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1987 12:00:00 AM     Permit Number 44550 6003962.08662823 2099767.6187722 37.7457862278615 -122.429008632092 (37.7457862278615, -122.429008632092) 2 7 5 63 22
133366 50190 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 350 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2003 12:00:00 AM     Permit Number 46896 5992966.98430504 2103249.49310039 37.7547180534592 -122.467280921215 (37.7547180534592, -122.467280921215) 1 8 4 56 12
133667 63671 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 371 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/02/1987 12:00:00 AM     Permit Number 24322 6004109.81981541 2100108.88292896 37.7467316215822 -122.428522112668 (37.7467316215822, -122.428522112668) 2 7 5 63 22
140030 60907 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1491 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1983 12:00:00 AM     Permit Number 20697 5994575.4199228 2105392.22311625 37.7606941592004 -122.461873918454 (37.7606941592004, -122.461873918454) 1 5 11 56 12
140942 63743 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 330 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24415 6002754.42754095 2109677.07121909 37.7729267674736 -122.433892719333 (37.7729267674736, -122.433892719333) 15 5 11 29492 9
143285 60381 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1350 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1982 12:00:00 AM     Permit Number 19961 6016233.53392592 2094275.31577425 37.7313924611256 -122.386192505476 (37.7313924611256, -122.386192505476) 10 3 8 58 1
147558 40222 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 4387 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1999 12:00:00 AM     Permit Number 41401 6001391.00854692 2101128.86800083 37.7493780241405 -122.437996521237 (37.7493780241405, -122.437996521237) 2 4 5 28862 22
153565 65660 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 106 Melrose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1990 12:00:00 AM     Permit Number 28580 5999382.81726917 2095526.44780449 37.7338807102318 -122.444538269179 (37.7338807102318, -122.444538269179) 9 7 4 59 40
154377 34113 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1398 Plymouth Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37977 5995892.17100072 2093289.41859175 37.7275385716585 -122.456444707829 (37.7275385716585, -122.456444707829) 9 7 4 28861 40
158240 60370 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1439 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1982 12:00:00 AM     Permit Number 19948 6015729.73368672 2094586.16842125 37.7322181026296 -122.387955935836 (37.7322181026296, -122.387955935836) 10 3 8 58 1
160965 85262 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 3000 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM     Permit Number 49557 5989530.4 2095609.1 37.7335405447433 -122.478606721292 (37.7335405447433, -122.478606721292) 1 8 4 64 35
161372 83531 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1355x COLE ST 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2008 12:00:00 AM   3x3 Permit Number 50899 5998199 2105694 37.7617307020229 -122.449363384978 (37.7617307020229, -122.449363384978) 15 5 11 29492 9
171034 50755 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 949 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2004 12:00:00 AM     Permit Number 47296 6007821.20096678 2120247.77734731 37.8022375706793 -122.417115255464 (37.8022375706793, -122.417115255464) 5 1 10 308 32
171935 60803 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 120 Ewing Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1983 12:00:00 AM     Permit Number 20479 5998693.79228565 2112443.24923504 37.7802907109033 -122.448138097032 (37.7802907109033, -122.448138097032) 15 6 2 54 16
172690 40824 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 695 05th St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/26/1999 12:00:00 AM     Permit Number 41762 6013368.81391754 2110378.20910645 37.7754485595516 -122.39722520599 (37.7754485595516, -122.39722520599) 6 2 9 28856 34
179037 63775 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 29 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24456 6004942.98585197 2101617.48681583 37.7509210136603 -122.425748465468 (37.7509210136603, -122.425748465468) 2 4 5 28862 22
180109 64262 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 159 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/03/1988 12:00:00 AM     Permit Number 25064 6010000.52253468 2100073.98033326 37.7469673841837 -122.408150095635 (37.7469673841837, -122.408150095635) 2 7 7 28859 2
181019 64271 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1627 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/1988 12:00:00 AM     Permit Number 25074 6009690.91214732 2100255.03327712 37.7474471748973 -122.409233479729 (37.7474471748973, -122.409233479729) 2 7 7 28859 2
181649 67772 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 146 Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1992 12:00:00 AM     Permit Number 31403 6004564.19848572 2108804.14815363 37.7706324670974 -122.427570300779 (37.7706324670974, -122.427570300779) 7 9 11 28852 10
182259 84042 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 508 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 50447 6003026.52400311 2103317.18885819 37.7554795089619 -122.432497158122 (37.7554795089619, -122.432497158122) 2 4 5 28862 22
186986 59836 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1271 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1983 12:00:00 AM     Permit Number 19290 5995144.61588097 2106889.02596139 37.7648367447545 -122.46001377482 (37.7648367447545, -122.46001377482) 15 5 11 56 12
190777 85265 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 3000 Ocean Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM     Permit Number 49557 5989530.4 2095609.1 37.7335405447433 -122.478606721292 (37.7335405447433, -122.478606721292) 1 8 4 64 35
191094 63659 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 411 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/02/1987 12:00:00 AM     Permit Number 24307 6003836.58732035 2100093.87745401 37.7466749538841 -122.429465853369 (37.7466749538841, -122.429465853369) 2 7 5 63 22
191968 60785 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 126 Ewing Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/14/1983 12:00:00 AM     Permit Number 20455 5998690.69552191 2112465.2130408 37.7803508407843 -122.448150392076 (37.7803508407843, -122.448150392076) 15 6 2 54 16
1951 196519 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 3 Sidewalk: Curb side : Yard Tree Private 2     1     6014493.82827 2101802.94838 37.7519653333515 -122.392733453506 (37.7519653333515, -122.392733453506) 10 3 8 28856 1
22590 181828 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2311 31st Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   5986682.779 2099487.7451 37.7440245328775 -122.488736632211 (37.7440245328775, -122.488736632211) 1 8 3 29491 35
27193 196521 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 7 Sidewalk: Curb side : Yard Tree Private 2     1     6014496.49753 2101766.20536 37.7518645930792 -122.392721652585 (37.7518645930792, -122.392721652585) 10 3 8 28856 1
34949 238549 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 125 Mullen Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009831.14885 2099860.0052 37.7463703703058 -122.408720684427 (37.7463703703058, -122.408720684427) 2 7 7 28859 2
42259 183468 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2531 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5987663.5713 2098059.3859 37.7401598234787 -122.485240531105 (37.7401598234787, -122.485240531105) 1 8 3 29491 35
53390 213716 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 252 Lobos St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5994453.52606 2088731.32317 37.7149404380182 -122.461087834836 (37.7149404380182, -122.461087834836) 9 8 6 28861 24
54150 196518 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1     6014492.91389 2101810.69981 37.7519865663454 -122.392737157804 (37.7519865663454, -122.392737157804) 10 3 8 28856 1
102825 196517 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1     6014492.80276 2101818.43499 37.7520077993331 -122.392738083189 (37.7520077993331, -122.392738083189) 10 3 8 28856 1
113719 238560 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 3329 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6007360.6242 2105555.31734 37.7618697145455 -122.417667096959 (37.7618697145455, -122.417667096959) 2 4 7 28859 19
128132 196520 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 6 Sidewalk: Curb side : Yard Tree Private 2     1     6014495.9358 2101776.59314 37.7518930845169 -122.392724321763 (37.7518930845169, -122.392724321763) 10 3 8 28856 1
140530 120349 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2122 Lake St 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5988820.20378 2114710.27627 37.7859459503003 -122.482461158758 (37.7859459503003, -122.482461158758) 11 6 1 55 33
163456 196527 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 333 Texas St 1 : Tree Private 2     1 Width 3ft   6013792.65149 2105531.32389 37.7621636768226 -122.395419411895 (37.7621636768226, -122.395419411895) 10 3 8 28856 29
183117 181827 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2311 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5986682.1022 2099505.6814 37.7440737416666 -122.488740290538 (37.7440737416666, -122.488740290538) 1 8 3 29491 35
192532 185747 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1802 Rivera St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5987565.4993 2100345.9151 37.7464323129859 -122.48574739527 (37.7464323129859, -122.48574739527) 1 8 3 29491 35

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)
);