4,014 rows where qSpecies_id = 40 sorted by qSiteInfo

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)
124385 196469 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1001 Cesar Chavez St 1 : Tree Private 2     5 Width 3ft   6015764.4296 2101073.59632 37.750033173207 -122.388288593857 (37.750033173207, -122.388288593857) 10 3 8 58 1
127559 213360 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 25 Elmhurst Dr 7 : Tree Private 2     3 Width 3ft   5991212.62572 2094437.93395 37.7304223444182 -122.472705478494 (37.7304223444182, -122.472705478494) 9 8 4 64 40
129113 201292 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 82 Lydia Ave 1 : Tree Private 2     2 Width 2ft   6012604.14806 2093027.69229 37.7277651940081 -122.398652533104 (37.7277651940081, -122.398652533104) 10 3 8 58 1
131106 237030 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Octavia St 4 : Tree DPW 1     5 Width 4ft   6005725.94025 2109733.85532 37.7732508616652 -122.423617927146 (37.7732508616652, -122.423617927146) 7 9 11 28852 10
131435 237032 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Octavia St 6 : Tree Private 2     5 Width 4ft   6005721.49565 2109758.3052 37.7733177442556 -122.423635040324 (37.7733177442556, -122.423635040324) 7 9 11 28852 10
132330 238055 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 438 Lily St 1 : Tree Private 2     9 Width 2ft   6004413.04242 2109984.42979 37.7738646822544 -122.428177279482 (37.7738646822544, -122.428177279482) 7 9 11 28852 10
132840 239462 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 173 Marview Way 1 : Tree Private 2     3 Width 3ft   5998149.49547 2103367.33608 37.7553394322787 -122.449366958943 (37.7553394322787, -122.449366958943) 1 5 4 63 38
134398 246594 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 22 Waller St 5 : Tree Private 2     5 Width 3ft   6005538.63737 2109282.04946 37.7719997374372 -122.424233694733 (37.7719997374372, -122.424233694733) 7 9 11 28852 10
134471 213348 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 438 Victoria St 1 : Tree Private 2     7 Width 3ft   5993267.15159 2090112.97171 37.7186657698839 -122.465288712916 (37.7186657698839, -122.465288712916) 9 8 6 64 24
136415 237037 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 129 Octavia St 1 : Tree Private 2     6 Width 4ft   6005605.52362 2109755.39176 37.7733031977155 -122.424035996776 (37.7733031977155, -122.424035996776) 7 9 11 28852 10
136737 237034 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 150 Octavia St 1 : Tree Private 2     4 Width 4ft   6005711.67822 2109842.25548 37.7735476972984 -122.423674970241 (37.7735476972984, -122.423674970241) 7 9 11 28852 10
138969 202042 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 52 Exeter St 1 : Tree Private 2     1 Width 3ft   6012532.81359 2090984.99672 37.7221523937885 -122.398755844523 (37.7221523937885, -122.398755844523) 10 3 8 58 1
139259 238041 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 38 Dolores St 7 : Tree Private 2     2 Width 4ft   6004732.58551 2107964.89474 37.7683376027325 -122.426928066278 (37.7683376027325, -122.426928066278) 8 4 5 28862 3
139955 213317 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 341 Howth St 2 : Tree Private 2     2 Width 3ft   5997142.77814 2090220.59605 37.7191840249054 -122.451900070344 (37.7191840249054, -122.451900070344) 9 8 6 28861 24
141653 196472 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2500 Newhall St 2 : Tree Private 2     5 Width 3ft   6012828.31305 2093641.68277 37.7294635726784 -122.39792063783 (37.7294635726784, -122.39792063783) 10 3 8 58 1
144364 238040 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 49 Pearl St 1 : Tree Private 2     10 Width 3ft   6005642.22428 2108761.00256 37.7705749163322 -122.423838323102 (37.7705749163322, -122.423838323102) 8 2 5 28853 19
145893 196455 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 11 : Tree Private 2     6 Width 3ft   6012871.43703 2101015.96129 37.7497141944763 -122.39828874204 (37.7497141944763, -122.39828874204) 10 3 8 28856 1
148691 238047 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 400 Lily St 2 : Tree Private 2     4 Width 3ft   6004564.74999 2110005.30362 37.7739305791617 -122.427653985566 (37.7739305791617, -122.427653985566) 7 9 11 28852 10
149691 246595 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 52 Waller St 1 : Tree Private 2     8 Width 3ft   6005513.49124 2109280.44319 37.7719939071131 -122.424320562945 (37.7719939071131, -122.424320562945) 7 9 11 28852 10
149692 196448 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Madera St 2 : Tree Private 2     6 Width 3ft   6012976.23669 2103282.94556 37.7559446805133 -122.398085357651 (37.7559446805133, -122.398085357651) 10 3 8 28856 29
149693 213352 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 752 Head St 2 : Tree Private 2     5 Width 3ft   5993533.94375 2090828.77797 37.7206465833581 -122.464418471345 (37.7206465833581, -122.464418471345) 9 8 6 64 24
153067 246475 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 318 Duncan St 1 : Tree Private 2     14 Width 3ft   6004316.48172 2099879.21952 37.7461127118429 -122.427791134863 (37.7461127118429, -122.427791134863) 2 7 5 63 22
156519 196450 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 1 : Tree Private 2     1 Width 3ft   6013387.24706 2101044.34817 37.7498208576628 -122.3965070277 (37.7498208576628, -122.3965070277) 10 3 8 28856 1
159452 237012 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 401 Lily St 2 : Tree Private 2     6 Width 2ft   6004502.75117 2109973.05936 37.7738385371506 -122.427866151824 (37.7738385371506, -122.427866151824) 7 9 11 28852 10
160146 196468 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Cesar Chavez St 12 : Tree Private 2     8 Width 3ft   6015629.24905 2101065.86664 37.7500044578413 -122.388755520048 (37.7500044578413, -122.388755520048) 10 3 8 58 1
160198 196465 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Cesar Chavez St 3 : Tree Private 2     3 Width 3ft   6015262.99985 2101056.82815 37.7499593343528 -122.390021408488 (37.7499593343528, -122.390021408488) 10 3 8 58 1
164139 196453 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 7 : Tree Private 2     2 Width 3ft   6012987.92898 2101021.89129 37.7497369652948 -122.397886321506 (37.7497369652948, -122.397886321506) 10 3 8 28856 1
168426 237015 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 401 Lily St 5 : Tree Private 2     4 Width 2ft   6004541.71287 2109979.25241 37.7738577457794 -122.427731818294 (37.7738577457794, -122.427731818294) 7 9 11 28852 10
170909 237039 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101 Octavia St 2 : Tree Private 2     7 Width 4ft   6005609.24206 2109730.37641 37.7732347215415 -122.424021354908 (37.7732347215415, -122.424021354908) 7 9 11 28852 10
171186 213312 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 109 Caine Ave 2 : Tree Private 2     4 Width 3ft   5997293.25449 2089167.74263 37.7163017516982 -122.451304041065 (37.7163017516982, -122.451304041065) 9 8 6 28861 24
173187 246424 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 418 Duncan St 1 : Tree Private 2     17 Width 4ft   6003710.7768 2099847.40017 37.7459910605319 -122.429883314964 (37.7459910605319, -122.429883314964) 2 7 5 63 22
175641 213313 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 109 Caine Ave 3 : Tree Private 2     5 Width 3ft   5997305.30098 2089185.13122 37.7163501865023 -122.451263656101 (37.7163501865023, -122.451263656101) 9 8 6 28861 24
176814 213346 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 223 Ramsell St 1 : Tree Private 2     4 Width 3ft   5992956.82489 2088699.80941 37.7147676656708 -122.466258733373 (37.7147676656708, -122.466258733373) 9 8 6 64 24
178694 237031 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Octavia St 5 : Tree Private 2     5 Width 4ft   6005723.44032 2109745.94906 37.773283927046 -122.423627434762 (37.773283927046, -122.423627434762) 7 9 11 28852 10
180226 179042 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2913 20th Ave 1 : Tree Private 2     5 Width 2ft   5990217.22266 2095888.70199 37.7343481135815 -122.476252619576 (37.7343481135815, -122.476252619576) 1 8 4 64 35
182790 213315 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 325 Howth St 1 : Tree Private 2     2 Width 3ft   5997161.75267 2090255.45529 37.7192808270242 -122.451836996388 (37.7192808270242, -122.451836996388) 9 8 6 28861 24
183687 246596 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 52 Waller St 2 : Tree Private 2     5 Width 3ft   6005499.23386 2109278.37719 37.7719874292938 -122.424369733388 (37.7719874292938, -122.424369733388) 7 9 11 28852 10
185279 196454 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 10 : Tree Private 2     1 Width 3ft   6012891.82767 2101016.42082 37.7497165920542 -122.398218262172 (37.7497165920542, -122.398218262172) 10 3 8 28856 1
186102 250644 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2610 Lake St 5 : Tree Private 2     4 Width 3ft   5987312.10464 2114657.57566 37.785713403992 -122.487674827026 (37.785713403992, -122.487674827026) 11 6 1 55 33
187252 246498 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 313 Duncan St 1 : Tree Private 2     4 Width 3ft   6004359.59327 2099835.65026 37.7459955193923 -122.42763895699 (37.7459955193923, -122.42763895699) 2 7 5 63 22
187542 213354 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 142 Garfield St 1 : Tree Private 2     3 Width 3ft   5993565.63371 2090507.60393 37.7197665436602 -122.464285624407 (37.7197665436602, -122.464285624407) 9 8 6 64 24
189691 213342 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 442 Vernon St 2 : Tree Private 2     10 Width 3ft   5992492.2832 2090792.26428 37.7204862252464 -122.468016479897 (37.7204862252464, -122.468016479897) 9 8 6 64 24
189754 196482 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 282 Bridgeview Dr 1 : Tree Private 2     5 Width 2ft   6012916.33928 2095157.16046 37.7336296640747 -122.39772257563 (37.7336296640747, -122.39772257563) 10 3 8 58 1
192027 196459 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1760 Cesar Chavez St 5 : Tree Private 2     5 Width 2ft   6013796.36432 2101069.01684 37.7499113519264 -122.395093999398 (37.7499113519264, -122.395093999398) 10 3 8 58 1
42333 237115 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Hwy 101 Southbound 6 Back Yard : Yard Tree Private 2     6     6005846.05822 2108984.84199 37.7712010306339 -122.423149171694 (37.7712010306339, -122.423149171694) 8 2 5 28853 19
53799 237116 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Hwy 101 Southbound 4 Back Yard : Yard Tree Private 2     5     6005840.35144 2109000.46624 37.7712436090254 -122.423170022474 (37.7712436090254, -122.423170022474) 8 2 5 28853 19
29803 105161 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1600X Oakdale Ave 2 Front Yard : Cutout Tree Arts Commission 19     13 3x3   6014869.34112 2095641.83637 37.735069048787 -122.391004288315 (37.735069048787, -122.391004288315) 10 3 8 58 1
165013 85367 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1990 09th Ave 1 Front Yard : Cutout Tree Private 2   08/17/2007 12:00:00 AM     Permit Number 49643 5993523.3 2101996.8 37.7513105791605 -122.465266058842 (37.7513105791605, -122.465266058842) 1 8 4 29491 12
16256 260911 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2035 15th Ave 1 Front Yard : Yard Tree Private 2       Width 3ft   5991575 2101572 37.7500316406912 -122.471972478281 (37.7500316406912, -122.471972478281) 1 8 4 29491 12
25676 237114 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 San Jose Ave 18 Front Yard : Yard Tree Private 2     2     6004844.31996 2096418.97753 37.7366415196845 -122.425719694004 (37.7366415196845, -122.425719694004) 2 7 5 28859 2
30746 213665 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 120 Edgehill Way 1 Front Yard : Yard Tree Private 2     3 Width 3ft   5994824.1493 2098927.22664 37.7429572344905 -122.460545199208 (37.7429572344905, -122.460545199208) 1 8 4 59 40
50542 237113 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 San Jose Ave 17 Front Yard : Yard Tree Private 2     2     6004838.14282 2096415.36394 37.7366312485184 -122.425740793928 (37.7366312485184, -122.425740793928) 2 7 5 28859 2
52276 104869 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 411 Holladay Ave 4 Front Yard : Yard Tree Private 2         Permit Number 770735 6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
58842 213670 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 120 Edgehill Way 6 Front Yard : Yard Tree Private 2     4 Width 3ft   5994884.54629 2098945.43271 37.7430106982792 -122.460337683337 (37.7430106982792, -122.460337683337) 1 8 4 59 40
68471 249941 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 331 Filbert St 3 Front Yard : Yard Tree Private 2     13 Width 0ft   6011275.70767 2120025.2952 37.8018204174494 -122.405145248872 (37.8018204174494, -122.405145248872) 3 1 10 308 23
75191 213669 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 120 Edgehill Way 5 Front Yard : Yard Tree Private 2     3 Width 3ft   5994884.8089 2098938.57589 37.7429918862669 -122.460336278605 (37.7429918862669, -122.460336278605) 1 8 4 59 40
84450 104867 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 411 Holladay Ave 2 Front Yard : Yard Tree Private 2         Permit Number 770735 6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
93231 249855 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 241 Greenwich St 1 Front Yard : Yard Tree Private 2     3 Width 0ft   6011547.42399 2120404.90985 37.8028779329365 -122.404231712119 (37.8028779329365, -122.404231712119) 3 1 10 308 23
120159 237112 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 San Jose Ave 16 Front Yard : Yard Tree Private 2     2     6004834.07081 2096408.30138 37.7366116262135 -122.425754370088 (37.7366116262135, -122.425754370088) 2 7 5 28859 2
128959 213671 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 120 Edgehill Way 7 Front Yard : Yard Tree Private 2     6 Width 3ft   5994885.50886 2098943.91671 37.7430065910919 -122.460334245238 (37.7430065910919, -122.460334245238) 1 8 4 59 40
144336 249940 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 331 Filbert St 2 Front Yard : Yard Tree Private 2     4 Width 0ft   6011278.90186 2120029.10977 37.8018310698943 -122.405134464188 (37.8018310698943, -122.405134464188) 3 1 10 308 23
153234 213666 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 120 Edgehill Way 2 Front Yard : Yard Tree Private 2     4 Width 3ft   5994837.41528 2098931.71854 37.7429703313118 -122.460499654841 (37.7429703313118, -122.460499654841) 1 8 4 59 40
169674 213668 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 120 Edgehill Way 4 Front Yard : Yard Tree Private 2     7 Width 3ft   5994864.53372 2098940.09364 37.7429948873009 -122.460406494088 (37.7429948873009, -122.460406494088) 1 8 4 59 40
170057 213667 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 120 Edgehill Way 3 Front Yard : Yard Tree Private 2     3 Width 3ft   5994852.48941 2098936.76868 37.7429850649213 -122.460447898854 (37.7429850649213, -122.460447898854) 1 8 4 59 40
1360 238060 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2x Montezuma St 1 Median : Cutout Tree DPW 1     3 Width 3ft   6007260.48935 2099759.47356 37.7459500163869 -122.417602623671 (37.7459500163869, -122.417602623671) 2 7 7 28859 2
24571 29668 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2500 Van Ness Ave 3 Median : Cutout Tree DPW 1   12/09/2004 12:00:00 AM 6     6005837.0202043 2118942.4447679 37.7985416396102 -122.423888617279 (37.7985416396102, -122.423888617279) 13 9 10 28858 32
58554 87738 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3200X Van Ness Ave 10 Median : Cutout Tree DPW 1   05/10/2008 12:00:00 AM 3 4x4   6005444.64461 2121623.98788 37.8058823097966 -122.425437295217 (37.8058823097966, -122.425437295217) 5 1 1 28858 32
69685 23487 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2500X Van Ness Ave 2 Median : Cutout Tree DPW 1   01/25/2008 12:00:00 AM 3 9   6005837.0202043 2118942.4447679 37.7985416396102 -122.423888617279 (37.7985416396102, -122.423888617279) 13 9 10 28858 32
77381 22521 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 6600 03rd St 1 Median : Cutout Tree DPW 1   02/20/1992 12:00:00 AM 3 3X3   6012847.5284056 2089784.7633559 37.7188743244909 -122.397583806576 (37.7188743244909, -122.397583806576) 10 3 8 58 1
95145 196444 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1200x Kansas St 2 Median : Cutout Tree DPW 1     5 Width 5ft   6011674.76736 2102721.10758 37.7543294225845 -122.402546786399 (37.7543294225845, -122.402546786399) 10 3 8 28856 29
96306 92531 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1298X Kansas St 1 Median : Cutout Tree DPW 1     4     6011695.14318 2102366.06354 37.7533556870153 -122.402451357562 (37.7533556870153, -122.402451357562) 10 3 8 28856 29
97434 23488 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2500X Van Ness Ave 4 Median : Cutout Tree DPW 1   12/09/2004 12:00:00 AM 6 9   6005837.0202043 2118942.4447679 37.7985416396102 -122.423888617279 (37.7985416396102, -122.423888617279) 13 9 10 28858 32
140231 101655 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 200X Vasquez Ave 2 Median : Cutout Tree DPW 1     6 8   5994672.47713 2099264.801 37.7438754024487 -122.461094099214 (37.7438754024487, -122.461094099214) 1 8 4 59 40
143911 88451 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3200X Van Ness Ave 1 Median : Cutout Tree DPW 1   06/07/2008 12:00:00 AM 3 5x12   6005480.84439 2121378.35155 37.8052099010884 -122.425294529632 (37.8052099010884, -122.425294529632) 5 1 1 28858 32
146975 121620 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1300x Kansas St 1 Median : Cutout Tree DPW 1     1 3x3   6011700.39266 2102280.30315 37.7531205008135 -122.402427173876 (37.7531205008135, -122.402427173876) 10 3 8 28856 29
161262 214700 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 200x Vasquez Ave 2 Median : Cutout Tree DPW 1     8 Width 6ft   5994642.56982 2099211.09063 37.7437262061113 -122.461193618499 (37.7437262061113, -122.461193618499) 1 8 4 59 40
166393 23489 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2500X Van Ness Ave 5 Median : Cutout Tree DPW 1   12/09/2004 12:00:00 AM 6 9   6005837.0202043 2118942.4447679 37.7985416396102 -122.423888617279 (37.7985416396102, -122.423888617279) 13 9 10 28858 32
177743 111661 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1398x Kansas St 1 Median : Cutout Tree DPW 1   06/25/2015 01:32:00 PM 3 3x3   6011721.86925 2101900.79241 37.7520796461774 -122.402326221379 (37.7520796461774, -122.402326221379) 10 3 8 28856 29
181937 87739 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3200X Van Ness Ave 11 Median : Cutout Tree DPW 1   05/10/2008 12:00:00 AM 3 4x4   6005433.61853 2121623.41722 37.8058801199389 -122.425475412067 (37.8058801199389, -122.425475412067) 13 1 1 28858 17
183446 22527 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 6600 03rd St 7 Median : Cutout Tree DPW 1     3 3X3   6012847.5284056 2089784.7633559 37.7188743244909 -122.397583806576 (37.7188743244909, -122.397583806576) 10 3 8 58 1
193704 88452 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3200X Van Ness Ave 2 Median : Cutout Tree DPW 1   06/07/2008 12:00:00 AM 4 5x12   6005470.42698 2121378.16696 37.8052088057127 -122.425330567252 (37.8052088057127, -122.425330567252) 5 1 1 28858 17
30319 136006 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1237x Robert C Levy Tunl 10 Median : Yard Tree DPW 1     3     6007669.82361 2118117.13537 37.7963788445653 -122.417488005977 (37.7963788445653, -122.417488005977) 5 1 10 28858 32
36307 237111 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2x Coso Ave 7 Median : Yard Tree DPW 1     2     6007125.29232 2099860.06971 37.7462186223039 -122.418077248072 (37.7462186223039, -122.418077248072) 2 7 7 28859 2
140300 136005 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1237x Robert C Levy Tunl 9 Median : Yard Tree DPW 1     3     6007661.46268 2118150.4985 37.7964699809712 -122.417519302367 (37.7964699809712, -122.417519302367) 5 1 10 28858 32
4873 151570 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1300x Vermont St 2 Side Yard : Cutout Tree Private 2 DPW 06/22/2019 12:00:00 AM 3 Width 4ft   6011393.71667 2102232.58713 37.7529723581964 -122.403484369222 (37.7529723581964, -122.403484369222) 10 4 8 28859 19
34890 196480 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499 Rankin St 6 Side Yard : Yard Tree Private 2     4 Width 3ft   6012679.65409 2096682.3113 37.737804227083 -122.39864786201 (37.737804227083, -122.39864786201) 10 3 8 58 1
38048 196479 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499 Rankin St 3 Side Yard : Yard Tree Private 2     3 Width 3ft   6012661.09972 2096663.01157 37.7377502003122 -122.398710659866 (37.7377502003122, -122.398710659866) 10 3 8 58 1
39552 196478 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499 Rankin St 2 Side Yard : Yard Tree Private 2     2 Width 3ft   6012656.37794 2096656.54864 37.7377321913814 -122.398726532018 (37.7377321913814, -122.398726532018) 10 3 8 58 1
62471 238433 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 272 Corbett Ave 8 Side Yard : Yard Tree Private 2     8 Width 3ft   5999629.67276 2105348.17571 37.7608628875441 -122.444390425487 (37.7608628875441, -122.444390425487) 15 5 5 28862 3
64129 196477 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499 Rankin St 1 Side Yard : Yard Tree Private 2     6 Width 3ft   6012648.61518 2096647.76204 37.7377076327033 -122.398752755335 (37.7377076327033, -122.398752755335) 10 3 8 58 1
97117 123168 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 598 10th Ave 1 Side Yard : Yard Tree Private 2     6     5992809.72377 2111438.20531 37.7771930089585 -122.468420491782 (37.7771930089585, -122.468420491782) 11 6 2 54 11
139985 250003 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 232 Filbert St 1 Side Yard : Yard Tree Private 2     11 Width 0ft   6011516.94138 2120107.55399 37.8020597630161 -122.404316256511 (37.8020597630161, -122.404316256511) 3 1 10 308 23
78 237365 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2463 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008244.71386 2104091.00553 37.7578987598438 -122.414505749733 (37.7578987598438, -122.414505749733) 2 4 7 28859 19
538 214628 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1442 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5992754.41359 2105631.11276 37.7612450859223 -122.468189283707 (37.7612450859223, -122.468189283707) 1 8 4 56 12
632 23885 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1750X Geary Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6003231.6817 2113926.646 37.7846221123784 -122.432545437068 (37.7846221123784, -122.432545437068) 13 9 11 29490 13
708 214648 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Hillway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996112.80548 2106851.31964 37.7647888500462 -122.456662349289 (37.7647888500462, -122.456662349289) 15 5 11 29492 12
738 55617 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 411 Laurel St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/14/1983 12:00:00 AM 6   Permit Number 20476 5998121.25588 2115028.99118 37.7873577334097 -122.45030520092 (37.7873577334097, -122.45030520092) 11 6 1 54 31
739 38480 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2515 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/1998 12:00:00 AM 9   Permit Number 40479 5999797.20513 2119471.52027 37.7996515161494 -122.444826245059 (37.7996515161494, -122.444826245059) 13 9 1 57 17
995 238517 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 258 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6001824.70148 2096208.99046 37.7358938476086 -122.436144777258 (37.7358938476086, -122.436144777258) 2 7 5 63 7
1029 65280 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 435 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/1989 12:00:00 AM 1   Permit Number 28085 6011091.92612 2112217.73363 37.7803724445696 -122.405231107147 (37.7803724445696, -122.405231107147) 14 2 9 28853 34

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