6,714 rows where qSpecies_id = 7 sorted by Police 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                    
72 135801 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 16 Phoenix Ter 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 2ft   6008610.92916 2117913.61927 37.7958729471262 -122.414217164494 (37.7958729471262, -122.414217164494) 5 1 10 308 21
752 32695 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1106 Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM 5 3x3 Permit Number 37103 6008138.63139 2115547.98028 37.7893509440283 -122.415683826556 (37.7893509440283, -122.415683826556) 13 1 10 28858 21
1955 55970 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1246 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2017 12:00:00 AM 3   Permit Number 12041 6008815.91632 2116679.99391 37.7924972267216 -122.413420580993 (37.7924972267216, -122.413420580993) 5 1 10 28857 21
2984 261389 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 611 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2           6010649.76194 2118553.23001 37.7977434736118 -122.407207494731 (37.7977434736118, -122.407207494731) 3 1 10 308 4
3324 100985 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2190 Powell St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
5789 142614 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 701 GREENWICH ST 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6009469.9119 2120131.871 37.8020119312896 -122.411401700731 (37.8020119312896, -122.411401700731) 3 1 10 308 23
5866 73526 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 807 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6009578.52705 2116144.74687 37.7910703569642 -122.410744096059 (37.7910703569642, -122.410744096059) 5 1 10 28857 21
7922 135849 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2456 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007515.30382 2120841.49853 37.8038505659037 -122.418215928918 (37.8038505659037, -122.418215928918) 5 1 1 308 32
8792 71157 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 807 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6009578.49301 2116131.05118 37.7910327500084 -122.410743246197 (37.7910327500084, -122.410743246197) 5 1 10 28857 21
13711 50946 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1134 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2014 12:00:00 AM 3   Permit Number 773916 6007565.24376916 2118876.40998362 37.7984577381814 -122.417903725033 (37.7984577381814, -122.417903725033) 5 1 10 28858 32
14977 71423 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 701 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6009442.6696 2120129.5624 37.8020040644534 -122.411495809181 (37.8020040644534, -122.411495809181) 3 1 10 308 23
17117 142613 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 701 GREENWICH ST 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6009456.5216 2120130.9476 37.8020086448232 -122.411447972427 (37.8020086448232, -122.411447972427) 3 1 10 308 23
17712 71441 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 900 Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6012101.83844 2118902.5962 37.7987839069199 -122.402207456009 (37.7987839069199, -122.402207456009) 3 1 10 28860 6
21157 53443 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1955 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1986 12:00:00 AM 5   Permit Number 23058 6007695.32961 2119167.05545 37.7992630980807 -122.417474195999 (37.7992630980807, -122.417474195999) 5 1 10 28858 32
24124 142520 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301 FRANCISCO ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     7 Width 0ft   6009467.3323 2121175.1455 37.8048763586912 -122.411484377145 (37.8048763586912, -122.411484377145) 3 1 10 308 23
25627 142658 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 396 Francisco St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6009447.6089 2121213.6739 37.8049810417497 -122.411555356166 (37.8049810417497, -122.411555356166) 3 1 10 308 23
26062 142655 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 55 VANDEWATER ST 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6009102.8791 2121306.4263 37.8052163739487 -122.412754898161 (37.8052163739487, -122.412754898161) 3 1 10 308 23
27328 249807 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 258 Chestnut St 6 Back Yard : Yard Tree Private 2     7 Width 0ft   6010752.11734 2121021.55825 37.8045266258517 -122.407027386026 (37.8045266258517, -122.407027386026) 3 1 10 308 23
27375 135795 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1106 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008156.60543 2115549.40456 37.7893558651186 -122.415621739153 (37.7893558651186, -122.415621739153) 13 1 10 28858 21
28687 135856 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 220 Lombard St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6011197.01398 2120748.14382 37.803800783049 -122.405468504785 (37.803800783049, -122.405468504785) 3 1 10 308 23
30108 135842 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1177 Greenwich St 5 Sidewalk: Curb side : Yard Tree Private 2     6     6007263.48219 2119827.6474 37.8010526095424 -122.419015420851 (37.8010526095424, -122.419015420851) 5 1 1 28858 32
30486 142534 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2100 POWELL ST 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6009442.0785 2120933.4916 37.8042114208681 -122.411554687027 (37.8042114208681, -122.411554687027) 3 1 10 308 23
31121 135811 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1188 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6007357.99127 2118847.16 37.7983657590324 -122.418618809023 (37.7983657590324, -122.418618809023) 5 1 10 28858 32
31296 135822 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1941 Leavenworth St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007711.58797 2119054.8847 37.7989560200535 -122.417409982592 (37.7989560200535, -122.417409982592) 5 1 10 28858 32
31713 107635 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 1150 Lombard St 10 Front Yard : Yard Tree Private 2   10/01/2014 12:00:00 AM 3   Permit Number 773092 6006825.00646 2120436.80144 37.8027004912885 -122.420576003873 (37.8027004912885, -122.420576003873) 5 1 1 28858 32
35451 65039 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 900 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1989 12:00:00 AM 6   Permit Number 26091 6008677.06955 2119030.1621 37.7989424124088 -122.414067334761 (37.7989424124088, -122.414067334761) 5 1 10 308 32
35699 121688 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 800 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2     7     6008462.12689 2120388.3747 37.8026596503908 -122.414907290765 (37.8026596503908, -122.414907290765) 5 1 10 308 32
36477 249963 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 271 Filbert St 1 Front Yard : Yard Tree Private 2     10 Width 0ft   6011592.60874 2120072.38059 37.8019674134157 -122.404051933175 (37.8019674134157, -122.404051933175) 3 1 10 308 23
37974 142616 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1867 POWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6009512.0452 2120108.7843 37.801950904005 -122.411254267134 (37.801950904005, -122.411254267134) 3 1 10 308 23
40310 13074 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 645X Lombard St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156) 3 1 10 308 23
40495 249833 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 333 Greenwich St 1 Front Yard : Yard Tree Private 2     7 Width 0ft   6011234.89731 2120366.37397 37.8027546547576 -122.405310505601 (37.8027546547576, -122.405310505601) 3 1 10 308 23
42347 135851 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 787 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6007518.53532 2120901.3436 37.8040150672041 -122.418208991563 (37.8040150672041, -122.418208991563) 5 1 1 308 32
45294 135858 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 220 Lombard St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6011178.53707 2120744.35584 37.8037893490595 -122.405532178584 (37.8037893490595, -122.405532178584) 3 1 10 308 23
45702 113955 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1441 Powell St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6009717.46061 2118594.91218 37.7978057026147 -122.410436472191 (37.7978057026147, -122.410436472191) 3 1 10 308 4
47208 249808 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 258 Chestnut St 7 Back Yard : Yard Tree Private 2     12 Width 0ft   6010714.23144 2121016.75548 37.8045113184913 -122.407158155531 (37.8045113184913, -122.407158155531) 3 1 10 308 23
47976 135834 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 900 Green St 16 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6008624.12392 2119028.66096 37.7989353167715 -122.414250438519 (37.7989353167715, -122.414250438519) 5 1 10 308 32
49676 135819 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1955 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007698.59451 2119147.16202 37.7992086594047 -122.417461487661 (37.7992086594047, -122.417461487661) 5 1 10 28858 32
50273 135846 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2430 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6007526.598 2120747.58183 37.8035933301309 -122.41817018222 (37.8035933301309, -122.41817018222) 5 1 1 308 32
52032 135836 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 900 Green St 23 Sidewalk: Property side : Yard Tree Private 2     7 Width 5ft   6008591.77677 2119025.88036 37.7989258649019 -122.41436217388 (37.7989258649019, -122.41436217388) 5 1 10 308 32
52923 249809 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 258 Chestnut St 8 Back Yard : Yard Tree Private 2     5 Width 0ft   6010708.45628 2121025.23541 37.8045342790877 -122.407178739215 (37.8045342790877, -122.407178739215) 3 1 10 308 23
53270 143244 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1913 STOCKTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6009926.8482 2120632.4472 37.8034120074717 -122.409855833569 (37.8034120074717, -122.409855833569) 3 1 10 308 23
53654 142540 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2100 POWELL ST 9 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6009421.7884 2121061.7254 37.8045623807522 -122.411633968656 (37.8045623807522, -122.411633968656) 3 1 10 308 23
54918 135804 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1613 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008352.68547 2117970.55983 37.7960147828127 -122.415114771533 (37.7960147828127, -122.415114771533) 5 1 10 28858 21
57068 85390 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1060 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2007 12:00:00 AM 5   Permit Number 49660 6009093.49986 2117706.63601 37.7953317162473 -122.412532734295 (37.7953317162473, -122.412532734295) 3 1 10 308 21
60169 135857 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 220 Lombard St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6011195.52799 2120759.07991 37.8038307277799 -122.405474417834 (37.8038307277799, -122.405474417834) 3 1 10 308 23
62880 62976 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1950 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/1986 12:00:00 AM 7   Permit Number 23365 6007747.12203 2119162.34513 37.7992530787278 -122.417294641847 (37.7992530787278, -122.417294641847) 5 1 10 308 32
64171 249873 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 230 Greenwich St 9 Back Yard : Yard Tree Private 2     26 Width 0ft   6011670.78297 2120474.23594 37.8030751776447 -122.403809705266 (37.8030751776447, -122.403809705266) 3 1 10 28860 6
64459 53232 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1469 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/31/1991 12:00:00 AM 10   Permit Number 29642 6007065.8379 2117721.11108 37.7952574583051 -122.419549817763 (37.7952574583051, -122.419549817763) 5 1 10 28858 32
65747 53178 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2420 REVISED Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/14/2006 12:00:00 AM 5   Permit Number 49096 6007531.88349 2120715.221 37.8035047729776 -122.418149595852 (37.8035047729776, -122.418149595852) 5 1 1 308 32
66909 135840 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1177 Greenwich St 3 Sidewalk: Curb side : Yard Tree Private 2     8     6007238.19952 2119824.86734 37.8010435524736 -122.419102712642 (37.8010435524736, -122.419102712642) 5 1 1 28858 32
69988 249835 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 333 Greenwich St 3 Front Yard : Yard Tree Private 2     10 Width 0ft   6011233.03828 2120380.52255 37.8027933993566 -122.40531793578 (37.8027933993566, -122.40531793578) 3 1 10 308 23
71064 135847 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2434 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6007523.40269 2120763.66368 37.8036373069691 -122.418182380615 (37.8036373069691, -122.418182380615) 5 1 1 308 32
72088 135832 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 900 Green St 11 Front Yard : Yard Tree Private 2     4     6008638.14569 2119013.6558 37.7988949039377 -122.414200856206 (37.7988949039377, -122.414200856206) 5 1 10 308 32
72760 135833 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 900 Green St 12 Front Yard : Yard Tree Private 2     2     6008637.50385 2119009.84925 37.7988844160443 -122.414202807733 (37.7988844160443, -122.414202807733) 5 1 10 308 32
74062 106161 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 827 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/2014 12:00:00 AM 3 3x3 Permit Number 770049 6006757.57528 2121490.32366 37.8055893943007 -122.420884191365 (37.8055893943007, -122.420884191365) 5 1 1 28858 32
74533 135835 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 900 Green St 20 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6008609.07224 2119027.30535 37.7989307491201 -122.414302426519 (37.7989307491201, -122.414302426519) 5 1 10 308 32
76016 135859 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 220 Lombard St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6011176.6986 2120755.37641 37.8038195060395 -122.405539317394 (37.8038195060395, -122.405539317394) 3 1 10 308 23
77449 13073 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 645X Lombard St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156) 3 1 10 308 23
77623 249829 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 339 Greenwich St 2 Front Yard : Yard Tree Private 2     5 Width 0ft   6011201.84726 2120367.04696 37.8027546547757 -122.405424923615 (37.8027546547757, -122.405424923615) 3 1 10 308 23
79948 135854 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 220 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6011219.52919 2120749.38326 37.8038054451262 -122.405390676534 (37.8038054451262, -122.405390676534) 3 1 10 28860 23
80029 55403 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1254 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/28/1973 12:00:00 AM 7   Permit Number 11342 6011509.51714 2119661.57098 37.8008347874628 -122.404310539521 (37.8008347874628, -122.404310539521) 3 1 10 308 23
80924 135806 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 22 Aladdin Ter 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6008809.71493 2119549.22227 37.8003750720026 -122.413645068874 (37.8003750720026, -122.413645068874) 3 1 10 308 32
81802 113954 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1441 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6009714.20821 2118628.89779 37.797898836429 -122.410450127476 (37.797898836429, -122.410450127476) 3 1 10 308 4
81844 112372 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 15 Vandewater St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009194.601 2121319.3086 37.8052568931935 -122.412438393162 (37.8052568931935, -122.412438393162) 3 1 10 308 23
81940 142537 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 2100 POWELL ST 6 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009436.3973 2120993.5505 37.8043760089549 -122.411578593269 (37.8043760089549, -122.411578593269) 3 1 10 308 23
83714 135818 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1071 Lombard St 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   6007217.26018 2120160.17933 37.8019630553145 -122.419198970666 (37.8019630553145, -122.419198970666) 5 1 1 28858 32
89075 135831 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 900 Green St 9 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   6008642.51144 2119028.50949 37.7989359337052 -122.414186800682 (37.7989359337052, -122.414186800682) 5 1 10 308 32
89350 142736 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 15 VANDEWATER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6009218.8197 2121322.4003 37.805266741303 -122.412354799662 (37.805266741303, -122.412354799662) 3 1 10 308 23
91477 135843 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1175 Greenwich St 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 10ft   6007285.97876 2119831.24581 37.8010637566478 -122.418937828239 (37.8010637566478, -122.418937828239) 5 1 1 28858 32
92199 250005 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 232 Filbert St 3 Side Yard : Yard Tree Private 2     8 Width 0ft   6011493.8796 2120090.77159 37.802012393927 -122.404394879735 (37.802012393927, -122.404394879735) 3 1 10 308 23
93450 135839 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1177 Greenwich St 2 Sidewalk: Curb side : Yard Tree Private 2     6     6007217.01278 2119823.01799 37.8010372815012 -122.419175896763 (37.8010372815012, -122.419175896763) 5 1 1 28858 32
94778 135852 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 13 MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2     8     6008609.879 2119160.01046 37.7992951697024 -122.414309029333 (37.7992951697024, -122.414309029333) 5 1 10 308 32
95678 249933 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 345 Filbert St 2 Front Yard : Yard Tree Private 2     7 Width 0ft   6011225.47356 2120026.31802 37.801820417444 -122.405319155254 (37.801820417444, -122.405319155254) 3 1 10 308 23
97260 135820 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1955 Leavenworth St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007700.92901 2119129.01998 37.7991589772563 -122.417452123041 (37.7991589772563, -122.417452123041) 5 1 10 28858 32
97682 249969 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 213 Filbert St 2 Back Yard : Yard Tree Private 2     28 Width 0ft   6011730.79134 2120085.86253 37.8020121511077 -122.403574702535 (37.8020121511077, -122.403574702535) 3 1 10 308 23
98213 143084 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 463 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6010663.1497 2120298.4418 37.8025361473527 -122.407284261185 (37.8025361473527, -122.407284261185) 3 1 10 308 23
99006 143215 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 215 FRANCISCO ST 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6010264.7976 2121285.9953 37.805225422299 -122.408732475128 (37.805225422299, -122.408732475128) 3 1 10 308 23
99928 135821 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1941 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007709.39539 2119079.95376 37.7990247300556 -122.417419347243 (37.7990247300556, -122.417419347243) 5 1 10 28858 32
101994 142615 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 701 GREENWICH ST 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009481.4553 2120134.1797 37.8020189178421 -122.411361918128 (37.8020189178421, -122.411361918128) 3 1 10 308 23
102060 135829 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 900 Green St 6 Front Yard : Yard Tree Private 2     2     6008653.20032 2119016.0444 37.7989023080442 -122.414148931139 (37.7989023080442, -122.414148931139) 5 1 10 308 32
102284 135828 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 900 Green St 5 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   6008658.00325 2119030.21476 37.7989414861063 -122.414133314422 (37.7989414861063, -122.414133314422) 5 1 10 308 32
102731 135797 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1272 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008693.37353 2116663.42391 37.7924448483907 -122.41384341164 (37.7924448483907, -122.41384341164) 5 1 10 28857 21
106099 50376 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1620 Montgomery St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734) 3 1 10 28860 6
106674 135838 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1177 Greenwich St 1 Sidewalk: Curb side : Yard Tree Private 2     5     6007200.95123 2119822.58623 37.8010351914662 -122.419231446093 (37.8010351914662, -122.419231446093) 5 1 1 28858 32

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