trees
8,758 rows where qSpecies_id = 16 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
173 | 27068 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 801 Silver Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4 | 6006971.0744 | 2093616.11167 | 37.7290654140285 | -122.418167915919 | (37.7290654140285, -122.418167915919) | 9 | 3 | 7 | 309 | 28 | |||
181 | 14420 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Masonic Ave | 8 | Median : Cutout | Tree | DPW 1 | 35 | 5998841.5976 | 2113071.3194 | 37.7820236767836 | -122.447671998063 | (37.7820236767836, -122.447671998063) | 15 | 5 | 2 | 54 | 16 | ||||
408 | 109629 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200X GELLERT DR | 30 | Median : Cutout | Tree | DPW 1 | 30x200 | 5985380 | 2094516.3 | 37.730298158605 | -122.492875173009 | (37.730298158605, -122.492875173009) | 1 | 8 | 4 | 64 | 35 | ||||
545 | 90279 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4338 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982078.08793 | 2111023.84587 | 37.7754295872152 | -122.505513277346 | (37.7754295872152, -122.505513277346) | 11 | 6 | 2 | 55 | 26 | ||
624 | 20956 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984893.4728491 | 2101578.9445242 | 37.749661815397 | -122.495077729215 | (37.749661815397, -122.495077729215) | 1 | 8 | 3 | 29491 | 35 | |||
682 | 16784 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1961 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 5999039.4234543 | 2112720.6314145 | 37.781072082708 | -122.446962370058 | (37.781072082708, -122.446962370058) | 15 | 5 | 1 | 54 | 16 | |||
1201 | 2190 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1055 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000864.0909 | 2112351.4116 | 37.7801623757286 | -122.440623460362 | (37.7801623757286, -122.440623460362) | 15 | 5 | 1 | 29490 | 41 | |||
1396 | 90269 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4010 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5983101.97325 | 2111055.77054 | 37.7755774445967 | -122.501973836946 | (37.7755774445967, -122.501973836946) | 11 | 6 | 2 | 55 | 26 | ||
1492 | 20444 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
1542 | 261489 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100X Portola Dr | 3 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | |||
1740 | 5129 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2775 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/18/1983 12:00:00 AM | 10 | 3X3 | 6002512.34992 | 2095942.64763 | 37.7352015755927 | -122.433748276472 | (37.7352015755927, -122.433748276472) | 2 | 7 | 5 | 63 | 7 | ||
1994 | 10838 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1139X Hudson Ave | 45 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 3X4 | 6017982.97201 | 2094620.05501 | 37.7324357213845 | -122.380168255061 | (37.7324357213845, -122.380168255061) | 10 | 3 | 8 | 58 | 1 | |||
2511 | 20282 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
2538 | 20304 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
2550 | 1015 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1854X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6001128.27711 | 2091386.71553 | 37.7226133962853 | -122.438207240029 | (37.7226133962853, -122.438207240029) | 9 | 7 | 6 | 28861 | 25 | |||
2652 | 18747 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Roosevelt Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000958.79784 | 2107315.99315 | 37.7663417741813 | -122.439934678663 | (37.7663417741813, -122.439934678663) | 15 | 5 | 5 | 29492 | 3 | |||
2692 | 18211 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1575 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004651.3172937 | 2114317.5621297 | 37.7857758731644 | -122.427661834419 | (37.7857758731644, -122.427661834419) | 13 | 9 | 11 | 28858 | 13 | |||
3007 | 27222 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 371 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3x3 | 6003827.51824 | 2093508.67438 | 37.7285929731823 | -122.429027779127 | (37.7285929731823, -122.429027779127) | 9 | 7 | 6 | 28861 | 5 | |||
3036 | 258017 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2342 43rd Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 3 | 5983011.19804 | 2099184.33916 | 37.7429765166721 | -122.501409485055 | (37.7429765166721, -122.501409485055) | 1 | 8 | 3 | 29491 | 35 | ||||
3066 | 11935 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017236.56511 | 2096428.9556383 | 37.7373613939034 | -122.382874625964 | (37.7373613939034, -122.382874625964) | 10 | 3 | 8 | 58 | 1 | |||
3121 | 28070 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3445 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5996465.30474 | 2112747.36669 | 37.780998091992 | -122.455869411327 | (37.780998091992, -122.455869411327) | 11 | 6 | 2 | 54 | 16 | |||
3153 | 16204 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 504 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 5998737.42681 | 2094729.30283 | 37.7316550910092 | -122.446712233977 | (37.7316550910092, -122.446712233977) | 9 | 7 | 4 | 59 | 40 | |||
3249 | 9238 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6400 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 12 | 8M | 5987194.6568724 | 2112586.3612843 | 37.7800195894976 | -122.487928920824 | (37.7800195894976, -122.487928920824) | 11 | 6 | 2 | 55 | 26 | |||
3339 | 19580 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY4 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 8 | |||||||||||||
3401 | 21158 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2300X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984964.3463827 | 2099540.4551822 | 37.7440688278009 | -122.494682382207 | (37.7440688278009, -122.494682382207) | 1 | 8 | 3 | 29491 | 35 | |||
3458 | 260537 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1238 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5982443.47735 | 2106679.23386 | 37.7635220339644 | -122.503927471267 | (37.7635220339644, -122.503927471267) | 1 | 8 | 3 | 56 | 35 | ||
3548 | 296 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3451X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X3 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | 1 | 8 | 4 | 64 | 14 | |||
3634 | 20382 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
3924 | 117653 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5001 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2020 12:00:00 AM | 3 | Width 3ft | 5983129.01167 | 2111683.19763 | 37.7773017651933 | -122.501926740971 | (37.7773017651933, -122.501926740971) | 11 | 6 | 2 | 55 | 26 | ||
3997 | 20436 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15 | |||||||||||||
4035 | 90978 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3051 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/13/2008 12:00:00 AM | 3 | 3x3 | 5986104.90225 | 2111110.08173 | 37.7759025178632 | -122.491590119843 | (37.7759025178632, -122.491590119843) | 11 | 6 | 2 | 55 | 26 | ||
4153 | 19360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 711 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992081.20032 | 2089838.16122 | 37.7178427427344 | -122.469368036824 | (37.7178427427344, -122.469368036824) | 9 | 8 | 6 | 64 | 24 | |||
4295 | 20447 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
4531 | 20442 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
4790 | 102992 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 5 | 3x3 | 5993571.87038 | 2110700.08123 | 37.7752103110101 | -122.465730364497 | (37.7752103110101, -122.465730364497) | 11 | 6 | 2 | 54 | 11 | ||
5187 | 16150 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 395 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999449.98722 | 2094649.82142 | 37.7314775324521 | -122.444243069762 | (37.7314775324521, -122.444243069762) | 9 | 7 | 4 | 63 | 40 | |||
5218 | 19581 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY4 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 8 | |||||||||||||
5272 | 20437 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15 | |||||||||||||
5831 | 11910 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | |||
5850 | 20445 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
6015 | 16176 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 438 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999154.53701 | 2094721.74383 | 37.731658154085 | -122.445269662966 | (37.731658154085, -122.445269662966) | 9 | 7 | 4 | 59 | 40 | |||
6030 | 19323 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X5 | 5993467.32802 | 2089853.93143 | 37.7179660496774 | -122.4645779904 | (37.7179660496774, -122.4645779904) | 9 | 8 | 6 | 64 | 24 | |||
6114 | 140733 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2015 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6001710.23 | 2113212.2721 | 37.7825742274801 | -122.437757957488 | (37.7825742274801, -122.437757957488) | 15 | 5 | 11 | 29490 | 41 | |||
6271 | 15012 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1492X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016294.2605501 | 2097022.8093396 | 37.7389398874772 | -122.386174028839 | (37.7389398874772, -122.386174028839) | 10 | 3 | 8 | 58 | 1 | |||
6596 | 20449 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
6828 | 131262 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2711 Union St | 2 | Front Yard : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 785082 | 6000010.78683 | 2118118.88771 | 37.7959497330364 | -122.443989935801 | (37.7959497330364, -122.443989935801) | 13 | 9 | 1 | 57 | 17 | ||
6911 | 20443 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
6998 | 20438 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
7156 | 10925 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1345X Hudson Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017013.5679363 | 2096006.7331036 | 37.7361897319358 | -122.383616251853 | (37.7361897319358, -122.383616251853) | 10 | 3 | 8 | 58 | 1 | |||
7360 | 91134 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400X Trumbull St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005738.144013 | 2094265.96683 | 37.730780298312 | -122.422476416564 | (37.730780298312, -122.422476416564) | 9 | 7 | 6 | 28861 | 5 | |||
7465 | 17540 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 512 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6002977.3728 | 2090782.38877 | 37.721059043035 | -122.431772202434 | (37.721059043035, -122.431772202434) | 9 | 7 | 6 | 28861 | 5 | |||
7518 | 20555 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1305X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10 | 5984811.9199471 | 2106303.0061321 | 37.7626280043626 | -122.495708151398 | (37.7626280043626, -122.495708151398) | 1 | 8 | 3 | 56 | 35 | |||
7600 | 12920 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2981X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 5996820.13855 | 2087345.5314 | 37.7112712800431 | -122.452807904632 | (37.7112712800431, -122.452807904632) | 9 | 7 | 6 | 28861 | 25 | |||
7741 | 261484 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1000 Portola Dr | 12 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
8044 | 90232 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2738 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986996.67991 | 2111198.28734 | 37.7761967812113 | -122.488511755965 | (37.7761967812113, -122.488511755965) | 11 | 6 | 2 | 55 | 26 | ||
8194 | 24582 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 731 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X3 | 6007975.47278 | 2097199.92125 | 37.7389622589098 | -122.414949173076 | (37.7389622589098, -122.414949173076) | 2 | 7 | 7 | 28859 | 2 | |||
8283 | 19872 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY33 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
8323 | 10894 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017213.3373221 | 2095437.5732367 | 37.7346379721127 | -122.382885962987 | (37.7346379721127, -122.382885962987) | 10 | 3 | 8 | 58 | 1 | |||
8499 | 8180 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1205X Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002000.37874 | 2111170.93633 | 37.7769857283744 | -122.436608008152 | (37.7769857283744, -122.436608008152) | 15 | 5 | 11 | 29492 | 10 | |||
9011 | 6052 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1900 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2003 12:00:00 AM | 3 | 3X3 | 6001270.4508 | 2112511.2313 | 37.7806243318768 | -122.439229137442 | (37.7806243318768, -122.439229137442) | 15 | 5 | 11 | 29490 | 41 | ||
9076 | 9908 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1809 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 6x6 | 6005225.98494 | 2115998.17525 | 37.7904229062421 | -122.425793311632 | (37.7904229062421, -122.425793311632) | 13 | 9 | 1 | 28858 | 27 | |||
9136 | 11920 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
9192 | 9302 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 320X Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1992 12:00:00 AM | 6 | 3X100 | 6010916.2744 | 2090546.6069 | 37.7208584636334 | -122.404313017158 | (37.7208584636334, -122.404313017158) | 10 | 3 | 7 | 309 | 28 | ||
9535 | 124144 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4100x Geary Blvd | 6 | Median : Yard | Tree | DPW 1 | 14 | 5994110.98895 | 2112812.22704 | 37.7810407796467 | -122.464018802579 | (37.7810407796467, -122.464018802579) | 11 | 6 | 2 | 54 | 11 | ||||
10004 | 20406 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 51 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
10514 | 213161 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 131 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 4ft | 5995315.69861 | 2090785.50252 | 37.7206303056246 | -122.458256412019 | (37.7206303056246, -122.458256412019) | 9 | 8 | 6 | 28861 | 24 | |||
10516 | 102842 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10526 | 20383 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
10547 | 20439 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15 | |||||||||||||
10554 | 90281 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4400X Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981875.06739 | 2111015.68504 | 37.7753952303043 | -122.506214955899 | (37.7753952303043, -122.506214955899) | 11 | 6 | 2 | 55 | 26 | ||
10660 | 162 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5119X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/1994 12:00:00 AM | 3 | 3X3 | 5991169.13123 | 2112654.48309 | 37.7804376750562 | -122.474184536114 | (37.7804376750562, -122.474184536114) | 11 | 6 | 2 | 54 | 26 | ||
10849 | 8736 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3240 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5997038.8246 | 2113016.8335 | 37.781770875875 | -122.453904798838 | (37.781770875875, -122.453904798838) | 11 | 6 | 1 | 54 | 31 | |||
11100 | 142139 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3059 GEARY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 5997638.0004 | 2112996.359 | 37.7817489937123 | -122.451830464257 | (37.7817489937123, -122.451830464257) | 15 | 6 | 2 | 54 | 16 | |||
11238 | 1253 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3802X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2006 12:00:00 AM | 3 | 3X5 | 5992813.09767 | 2087592.82096 | 37.7117198470729 | -122.466675091581 | (37.7117198470729, -122.466675091581) | 9 | 8 | 4 | 64 | 24 | ||
11384 | 258014 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4222 Moraga Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | |||||||||||||||
11624 | 10949 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400X Hudson Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016738.0241541 | 2096692.24342 | 37.7380567715564 | -122.384616664641 | (37.7380567715564, -122.384616664641) | 10 | 3 | 8 | 58 | 1 | |||
11722 | 16206 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 512 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5998670.78741 | 2094729.8528 | 37.7316527941412 | -122.446942658283 | (37.7316527941412, -122.446942658283) | 9 | 7 | 4 | 59 | 40 | |||
11803 | 261486 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1000 Portola Dr | 13 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
11860 | 20441 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 15 | |||||||||||||
11862 | 260530 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1790x 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | ||||||||||||
12124 | 8617 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2600 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 5999387.1761445 | 2113256.6615953 | 37.7825637442266 | -122.445797886011 | (37.7825637442266, -122.445797886011) | 15 | 5 | 1 | 29490 | 31 | |||
12437 | 1235 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3645 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5993271.90922 | 2087553.28553 | 37.7116377596374 | -122.465086457186 | (37.7116377596374, -122.465086457186) | 9 | 8 | 4 | 64 | 24 | |||
13065 | 20384 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
13141 | 386 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3721X 19th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | |||
13261 | 10837 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1139X Hudson Ave | 44 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/28/1995 12:00:00 AM | 6 | 3X4 | 6017972.55601 | 2094607.03401 | 37.7323993935967 | -122.380203361451 | (37.7323993935967, -122.380203361451) | 10 | 3 | 8 | 58 | 1 | ||
13897 | 20448 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
13900 | 18758 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 257 Roosevelt Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000826.59652 | 2107132.10254 | 37.7658293296857 | -122.440378747682 | (37.7658293296857, -122.440378747682) | 15 | 5 | 5 | 29492 | 3 | |||
14019 | 18119 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Portola Dr | 3 | Median : Cutout | Tree | DPW 1 | 6 | 10 | 5993139.2629046 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | 1 | 8 | 4 | 59 | 40 | |||
14056 | 20375 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
14126 | 27524 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3201 California St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 5999021.2149 | 2114925.4479 | 37.7871248935498 | -122.447184087894 | (37.7871248935498, -122.447184087894) | 15 | 6 | 1 | 54 | 31 | |||
14134 | 10928 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1338X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017067.78489 | 2095945.48919 | 37.7360245649694 | -122.383424537716 | (37.7360245649694, -122.383424537716) | 10 | 3 | 8 | 58 | 1 | |||
14273 | 20403 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 48 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
14385 | 9237 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6400 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12 | 8M | 5987194.6568724 | 2112586.3612843 | 37.7800195894976 | -122.487928920824 | (37.7800195894976, -122.487928920824) | 11 | 6 | 2 | 55 | 26 | |||
14500 | 8776 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3500 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5996225.73725 | 2112888.16755 | 37.7813709415224 | -122.456708374766 | (37.7813709415224, -122.456708374766) | 11 | 6 | 2 | 54 | 16 | |||
14652 | 257979 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2126 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x4 | 5981719.28463 | 2100605.34561 | 37.7468022472561 | -122.5059818232 | (37.7468022472561, -122.5059818232) | 1 | 8 | 3 | 29491 | 35 | |||
14701 | 8631 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2600 Geary Blvd | 19 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 5999387.1761445 | 2113256.6615953 | 37.7825637442266 | -122.445797886011 | (37.7825637442266, -122.445797886011) | 15 | 5 | 1 | 29490 | 31 | |||
14818 | 20309 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
14939 | 20281 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
15307 | 14419 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Masonic Ave | 7 | Median : Cutout | Tree | DPW 1 | 35 | 5998835.1676 | 2113089.5942 | 37.7820734871416 | -122.447695558807 | (37.7820734871416, -122.447695558807) | 15 | 5 | 2 | 54 | 16 | ||||
15314 | 16219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 550 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5998423.31695 | 2094734.1662 | 37.7316504963562 | -122.447798519712 | (37.7316504963562, -122.447798519712) | 9 | 7 | 4 | 59 | 40 |
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) );