6,714 rows where qSpecies_id = 7 sorted by Fire Prevention Districts

View and edit SQL

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)
604 20034 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
1515 31846 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
3055 20039 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 10 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
3242 43297 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1501 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2000 12:00:00 AM     Permit Number 43066                    
4991 20043 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 14 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
6396 36746 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 5555 Woodward St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39516                    
7114 20035 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
7286 33084 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
7976 20040 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 ST                      
9521 35167 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 240 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/1998 12:00:00 AM     Permit Number 38700                    
9968 31847 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   2 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
14278 31848 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   3 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
14721 20044 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 15 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
18188 33083 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   2 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
18800 20042 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 13 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
19322 46857 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   1 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2002 12:00:00 AM     Permit Number 44926                    
332 182987 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1975 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5989890.895 2098325.8493 37.7410209633467 -122.477558903564 (37.7410209633467, -122.477558903564) 1 8 3 29491 35
587 37078 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1318 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 2   Permit Number 39680 5982466.3981 2106106.9098 37.7619519432804 -122.50380580728 (37.7619519432804, -122.50380580728) 1 8 3 56 35
726 213079 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 127 Castenada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5994523.12061 2101041.16824 37.7487442639422 -122.461739308234 (37.7487442639422, -122.461739308234) 1 8 4 29491 40
839 71209 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2170 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5988552.6315 2100561.3439 37.7470812936995 -122.48234982645 (37.7470812936995, -122.48234982645) 1 8 3 29491 35
1159 70451 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2683 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5983041.4986 2096885.6865 37.7366668238827 -122.5011347377 (37.7366668238827, -122.5011347377) 1 8 3 29491 35
1236 78452 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 3075 23rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5989337.22841 2094863.71499 37.7314826909771 -122.479220054956 (37.7314826909771, -122.479220054956) 1 8 4 64 35
1251 218033 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 70 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5993104.01352 2098691.4194 37.7422106578044 -122.466475770336 (37.7422106578044, -122.466475770336) 1 8 4 59 40
1756 217968 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2535 17th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5991076.46377 2098128.02027 37.74054650193 -122.473445254517 (37.74054650193, -122.473445254517) 1 8 4 29491 40
1797 72003 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1991 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5987539.672 2101751.7111 37.7502907477313 -122.485939871711 (37.7502907477313, -122.485939871711) 1 8 3 29491 35
2423 183529 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2590 26th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 0ft   5988341.8215 2097699.5391 37.7392112662203 -122.482869079468 (37.7392112662203, -122.482869079468) 1 8 3 29491 35
2987 212886 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1941 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 1ft   5990935.1255 2102170.56129 37.7516380862328 -122.474228847281 (37.7516380862328, -122.474228847281) 1 8 4 29491 12
3145 68594 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1776 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/21/1993 12:00:00 AM     Permit Number 32496 5991255.24615708 2103348.30667764 37.7548904064419 -122.473207725085 (37.7548904064419, -122.473207725085) 1 8 4 56 12
3173 78509 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 750 Eucalyptus Dr 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5988915.04586 2094775.69423 37.7312164799499 -122.480673162464 (37.7312164799499, -122.480673162464) 1 8 4 64 35
3278 72888 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2506 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5989566.1304 2098258.2718 37.7408165618747 -122.478676867492 (37.7408165618747, -122.478676867492) 1 8 3 29491 35
3695 217936 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 2035 15th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   04/26/2004 12:00:00 AM 4 Width 3ft Permit Number 47390 5991589.39044 2101578.98372 37.7500516488693 -122.471923224775 (37.7500516488693, -122.471923224775) 1 8 4 29491 12
3989 218019 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 645 Santiago St 5 Sidewalk: Curb side : Pot Tree Private 2     2 Width 3ft   5990820.54277 2099711.93527 37.7448807008818 -122.474445681024 (37.7448807008818, -122.474445681024) 1 8 4 29491 40
4775 218083 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 281 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5994638.85855 2100259.1397 37.7466036724264 -122.461282408569 (37.7466036724264, -122.461282408569) 1 8 4 29491 40
4948 212696 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1342 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5994280.27927 2106365.59 37.7633497765027 -122.462965291019 (37.7633497765027, -122.462965291019) 1 5 11 56 12
5034 71218 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2271 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5988222.5624 2099870.3089 37.7451646891306 -122.483440513109 (37.7451646891306, -122.483440513109) 1 8 3 29491 35
5104 212915 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 830 Pacheco St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5992359.15804 2102812.51637 37.7534831218714 -122.469351125951 (37.7534831218714, -122.469351125951) 1 8 4 56 12
5196 72221 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1927 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5987523.8589 2102155.7654 37.7513992507221 -122.486024209623 (37.7513992507221, -122.486024209623) 1 8 3 29491 35
5231 45591 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1762 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2001 12:00:00 AM 2   Permit Number 44327 5985671.2041 2103229.2894 37.7542387115456 -122.492509867059 (37.7542387115456, -122.492509867059) 1 8 3 56 35
5330 121676 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 65 Sotelo Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993867 2101351 37.7495571916966 -122.464030639739 (37.7495571916966, -122.464030639739) 1 8 4 29491 40
5398 71818 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1274 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     5988967.2555 2106670.2084 37.7638787087739 -122.481363401299 (37.7638787087739, -122.481363401299) 1 8 3 56 35
5417 36107 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1342 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1998 12:00:00 AM     Permit Number 39204 5992735.49126181 2106322.00548974 37.7631410027064 -122.468304991085 (37.7631410027064, -122.468304991085) 1 8 11 56 12
5445 71037 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2655 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5990171.0618 2097314.9079 37.7382614326886 -122.476516364987 (37.7382614326886, -122.476516364987) 1 8 3 29491 35
5815 43587 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2006 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2000 12:00:00 AM 1   Permit Number 43248 5986971.0019 2101586.3374 37.7498035204361 -122.487894195347 (37.7498035204361, -122.487894195347) 1 8 3 29491 35
6079 212891 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1439 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5991128.6884 2105597.85808 37.7610597509203 -122.47380949522 (37.7610597509203, -122.47380949522) 1 8 4 56 12
6171 31268 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 2555 17th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/04/1995 12:00:00 AM     Permit Number 34928 5991067.84001 2098080.24601 37.7404148266578 -122.47347158803 (37.7404148266578, -122.47347158803) 1 8 4 29491 40
6218 214210 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2 Edgehill Way 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994958.11276 2099177.21478 37.7436513456346 -122.460100100459 (37.7436513456346, -122.460100100459) 1 8 4 59 40
6988 72005 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1963 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5987221.7723 2101915.2958 37.7507213765199 -122.487051188188 (37.7507213765199, -122.487051188188) 1 8 3 29491 35
7227 181941 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2338 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5985894.7639 2098931.5489 37.7424513496728 -122.49142044264 (37.7424513496728, -122.49142044264) 1 8 3 29491 35
7355 218024 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2439 Funston Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5992321.61488 2098826.36929 37.7425360172282 -122.469190857781 (37.7425360172282, -122.469190857781) 1 8 4 29491 40
7676 78416 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2959 20th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5990231.30854 2095554.29925 37.7334307457305 -122.47617950378 (37.7334307457305, -122.47617950378) 1 8 4 64 35
8220 212707 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1439 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   5994565.98091 2105717.62937 37.7615870971916 -122.461930160547 (37.7615870971916, -122.461930160547) 1 5 11 56 12
8823 217937 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 2035 15th Ave 2 Sidewalk: Curb side : Yard Tree Private 2   04/26/2004 12:00:00 AM 4 Width 3ft Permit Number 47390 5991588.27788 2101560.12813 37.7499998119378 -122.471925697939 (37.7499998119378, -122.471925697939) 1 8 4 29491 12
9472 78510 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 750 Eucalyptus Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5988931.24396 2094774.45392 37.7312140158088 -122.480617072624 (37.7312140158088, -122.480617072624) 1 8 4 64 35
9836 218111 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 70 Lopez Ave 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 0ft   5993944.94512 2100501.16931 37.747228264177 -122.463699432805 (37.747228264177, -122.463699432805) 1 8 4 29491 40
10148 78474 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2959 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5990228.52939 2095585.09331 37.7335151372166 -122.476191360437 (37.7335151372166, -122.476191360437) 1 8 4 64 35
10164 212975 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1350 07th Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5993969.17632 2106486.34131 37.7636634033545 -122.46405005237 (37.7636634033545, -122.46405005237) 1 5 11 56 12
10335 218324 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 430 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   5993138.3267 2099955.06168 37.7456822792311 -122.466448948955 (37.7456822792311, -122.466448948955) 1 8 4 29491 40
10519 71038 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1959 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5987222.8629 2101938.1977 37.7507843225586 -122.487049098627 (37.7507843225586, -122.487049098627) 1 8 3 29491 35
11152 212892 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1485 16th Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 5ft   5991130.51563 2105331.7867 37.7603292954688 -122.473783764707 (37.7603292954688, -122.473783764707) 1 8 4 56 12
11265 218415 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 200 Castenada Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 0ft   5994285.79928 2100659.94042 37.7476838445316 -122.462532308839 (37.7476838445316, -122.462532308839) 1 8 4 29491 40
11393 212890 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1391 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5990805.53929 2105956.91364 37.7620268998548 -122.474953326735 (37.7620268998548, -122.474953326735) 1 8 3 56 12
11911 78475 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 3075 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5989336.6982 2094888.29675 37.7315501554115 -122.479223685537 (37.7315501554115, -122.479223685537) 1 8 4 64 35
11992 212328 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2008 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5991630.07361 2101733.92656 37.7504794356741 -122.471793832122 (37.7504794356741, -122.471793832122) 1 8 4 29491 12
12057 213002 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1684 09th Ave 2 Front Yard : Yard Tree Private 2     7 Width 6ft   5993433.63561 2104037.38887 37.7569083391631 -122.465724367884 (37.7569083391631, -122.465724367884) 1 8 4 56 12
12181 212499 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 65 Sotelo Ave 7 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5993890.56554 2101313.40966 37.7494553362962 -122.463946421708 (37.7494553362962, -122.463946421708) 1 8 4 29491 40
12242 50084 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 163 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46816 5992385.51984068 2098065.73695017 37.7404512063716 -122.468914554715 (37.7404512063716, -122.468914554715) 1 8 4 59 40
12285 73534 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2122 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5988232.3443 2100841.764 37.7478326165783 -122.483477893757 (37.7478326165783, -122.483477893757) 1 8 3 29491 35
12521 217929 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1882 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2020 12:00:00 AM 3 Width 3ft   5990657.38608 2102600.85975 37.7528034790046 -122.475220706895 (37.7528034790046, -122.475220706895) 1 8 4 56 12
13026 218015 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 645 Santiago St 1 Sidewalk: Curb side : Pot Tree Private 2     2 Width 3ft   5990772.57779 2099709.35635 37.7448708407289 -122.474611345145 (37.7448708407289, -122.474611345145) 1 8 4 29491 40
13185 212371 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2558 14th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5992083.07109 2098029.43822 37.7403340604646 -122.469957652151 (37.7403340604646, -122.469957652151) 1 8 4 59 40
13241 72002 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1987 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5987538.0362 2101772.9771 37.7503490431313 -122.485947089116 (37.7503490431313, -122.485947089116) 1 8 3 29491 35
13301 114388 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 361x ARBALLO DR 1 Front Yard : Yard Tree Private 2     7     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
13321 184576 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1735 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5982829.6776 2103308.6964 37.7542901935078 -122.502342289658 (37.7542901935078, -122.502342289658) 1 8 3 56 35
13421 73651 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2484 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5989869.6737 2098462.6897 37.7413954601505 -122.477642278142 (37.7413954601505, -122.477642278142) 1 8 3 29491 35
13443 78042 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1975 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5986293.4379 2101820.6717 37.7504073916771 -122.490254444499 (37.7504073916771, -122.490254444499) 1 8 3 29491 35
13600 113384 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 127 CASTENADA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   5994537 2101046 37.748758329692 -122.461691664015 (37.748758329692, -122.461691664015) 1 8 4 29491 40
13625 212331 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 931 Ortega St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 1ft   5991024.19031 2102445.12769 37.7523971329339 -122.473940882576 (37.7523971329339, -122.473940882576) 1 8 4 29491 12
13668 71213 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2130 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5988234.1964 2100800.0919 37.7477183038635 -122.483468434844 (37.7477183038635, -122.483468434844) 1 8 3 29491 35
15618 32356 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 172 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 4   Permit Number 46079 5992320.99076 2098026.73224 37.7403403809031 -122.469134830931 (37.7403403809031, -122.469134830931) 1 8 4 59 40
15914 53351 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2274 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/12/1969 12:00:00 AM 2   Permit Number 6244 5988266.9432 2099841.7174 37.7450887673736 -122.483284958368 (37.7450887673736, -122.483284958368) 1 8 3 29491 35
15947 70994 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2419 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5989807.1077 2098888.9436 37.7425622116939 -122.477889760612 (37.7425622116939, -122.477889760612) 1 8 3 29491 35
15975 31371 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 537 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM 4   Permit Number 34973 5991501.22289 2099052.17268 37.7431085759965 -122.472043958778 (37.7431085759965, -122.472043958778) 1 8 4 29491 40
16112 212931 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1934 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5990977.97249 2102198.63259 37.7517176447705 -122.474082726332 (37.7517176447705, -122.474082726332) 1 8 4 29491 12
16531 78412 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 3035 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5989072.12667 2095062.74941 37.732013788304 -122.480151113209 (37.732013788304, -122.480151113209) 1 8 4 64 35
16964 264738 Section 806 (d) 5 Prunus cerasifera :: Cherry Plum 7 2722 42nd Ave 1 Sidewalk: Property side : Cutout Tree Private 2   09/29/2020 12:00:00 AM 3 3x6 Permit Number 781841 5983409.1923 2096639.50516 37.7360124610612 -122.499845290879 (37.7360124610612, -122.499845290879) 1 8 3 29491 35
16992 68045 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1972 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1993 12:00:00 AM     Permit Number 31782 5993192.12493699 2102059.66959025 37.7514640989736 -122.466415859099 (37.7514640989736, -122.466415859099) 1 8 4 29491 12
17011 97950 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 2 Mendosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
17018 214298 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 268 Pacheco St 6 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5994394.90516 2100680.9533 37.7477478232146 -122.4621565532 (37.7477478232146, -122.4621565532) 1 8 4 29491 40
17631 50345 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 555 Irving St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2003 12:00:00 AM     Permit Number 47028 5994078.33928892 2106636.06198176 37.7640807879805 -122.463683361812 (37.7640807879805, -122.463683361812) 1 5 11 56 12
18771 258679 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 40 Dorantes Ave 3 Sidewalk: Curb side : Yard Tree Private 2       Width 4ft   5994121.05183 2100069.6594 37.746053593117 -122.463059170366 (37.746053593117, -122.463059170366) 1 8 4 29491 40
18942 212977 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1350 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5993661.81325 2106290.71409 37.7631085432536 -122.465098907404 (37.7631085432536, -122.465098907404) 1 8 11 56 12
19133 71807 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2484 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5989868.5761 2098479.5203 37.7414416089199 -122.477647303158 (37.7414416089199, -122.477647303158) 1 8 3 29491 35
19135 212544 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 153 Terrace Dr 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   5993803.69689 2096613.44669 37.7365454136427 -122.463905701311 (37.7365454136427, -122.463905701311) 1 8 4 59 40
19286 71212 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2122 26th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5988232.8073 2100853.3395 37.7478644267725 -122.48347714122 (37.7478644267725, -122.48347714122) 1 8 3 29491 35
19425 183380 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2659 22nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5989552.3196 2097244.2751 37.738031587602 -122.478650482217 (37.738031587602, -122.478650482217) 1 8 3 29491 35
19597 212479 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1934 09th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5993488.07441 2102312.40438 37.7521751163927 -122.465410795884 (37.7521751163927, -122.465410795884) 1 8 4 29491 12
19670 53017 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 51@ 9TH AVE Sotelo Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   09/06/2006 12:00:00 AM   3x3 Permit Number 53024 5993884.35239316 2101253.60887052 37.7492907804788 -122.463963566443 (37.7492907804788, -122.463963566443) 1 8 4 29491 40
19937 68504 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1926 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32381 5992877.89349701 2102426.54262238 37.7524533008694 -122.467529176594 (37.7524533008694, -122.467529176594) 1 8 4 29491 12
20357 212901 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1942 16th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5991289.25239 2102186.06751 37.7517011709901 -122.473005373606 (37.7517011709901, -122.473005373606) 1 8 4 29491 12
20411 212987 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1475 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5992713.33462 2105426.68647 37.760681412438 -122.46831648474 (37.760681412438, -122.46831648474) 1 8 4 56 12

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