trees
4,014 rows where qSpecies_id = 40 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );