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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15355 | 20450 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
15456 | 20376 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
15758 | 260531 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1790x 46th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | ||||||||||||
16160 | 20446 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15 | |||||||||||||
16387 | 8964 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5020 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5991488.65703 | 2112763.73301 | 37.7807561501982 | -122.473087126722 | (37.7807561501982, -122.473087126722) | 11 | 6 | 2 | 54 | 26 | |||
16528 | 142138 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3059 GEARY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 0ft | 5997659.9978 | 2112998.7279 | 37.7817567579445 | -122.451754534904 | (37.7817567579445, -122.451754534904) | 15 | 6 | 2 | 54 | 16 | |||
16598 | 2199 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000885.4114 | 2112518.592 | 37.7806226245627 | -122.440561697516 | (37.7806226245627, -122.440561697516) | 15 | 5 | 11 | 29490 | 41 | |||
16731 | 6337 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1916 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001700.9234 | 2112915.307 | 37.7817583075946 | -122.437768878541 | (37.7817583075946, -122.437768878541) | 15 | 5 | 11 | 29490 | 41 | |||
16818 | 1919 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 24 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6001550.75426 | 2097278.97191 | 37.7388162000182 | -122.437168505248 | (37.7388162000182, -122.437168505248) | 2 | 7 | 5 | 63 | 7 | |||
16838 | 19544 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x9 | 6000579.8735828 | 2113139.7164613 | 37.7823106701496 | -122.441663283894 | (37.7823106701496, -122.441663283894) | 15 | 5 | 1 | 29490 | 41 | |||
16902 | 15463 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2430 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6006912.9895 | 2104192.6227 | 37.7581028719933 | -122.41911862969 | (37.7581028719933, -122.41911862969) | 2 | 4 | 7 | 28859 | 19 | |||
16958 | 16301 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 739 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5997182.92524 | 2094674.84101 | 37.7314166294574 | -122.45208249962 | (37.7314166294574, -122.45208249962) | 9 | 7 | 4 | 59 | 40 | |||
17105 | 20440 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
17377 | 260517 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4711x Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
17523 | 11896 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 603 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/04/2017 12:00:00 AM | 3 | 3x3 | 6017299.30184 | 2096353.90744 | 37.7371587926313 | -122.382652493121 | (37.7371587926313, -122.382652493121) | 10 | 3 | 8 | 58 | 1 | ||
17777 | 219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2949 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 5X8 | 5990525.93487 | 2095591.0616 | 37.7335487664486 | -122.475163590944 | (37.7335487664486, -122.475163590944) | 1 | 8 | 4 | 64 | 35 | |||
17847 | 20000 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY46 | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2 | |||||||||||||
18537 | 12409 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1500 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004564.3 | 2114031.3 | 37.7849849463478 | -122.427942483992 | (37.7849849463478, -122.427942483992) | 13 | 9 | 11 | 28858 | 41 | |||
19122 | 18740 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 202 Roosevelt Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001042.8808602 | 2107393.4739119 | 37.7665593032466 | -122.439649407088 | (37.7665593032466, -122.439649407088) | 15 | 5 | 5 | 29492 | 3 | |||
19356 | 232579 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500x 27th St | 25 | Median : Cutout | Tree | DPW 1 | 9 | Width 4ft | 6002958.22552 | 2100071.04753 | 37.7465624978722 | -122.432501505848 | (37.7465624978722, -122.432501505848) | 2 | 7 | 5 | 63 | 22 | |||
19559 | 19579 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY4 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | |||||||||||||
19655 | 2651 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1958 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004155.6542 | 2114999.6285 | 37.7876206064413 | -122.429425346374 | (37.7876206064413, -122.429425346374) | 13 | 9 | 11 | 29490 | 27 | |||
19684 | 6390 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Entrada Ct | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60M | 5992282.41809 | 2092443.27672 | 37.7250073785701 | -122.468861992007 | (37.7250073785701, -122.468861992007) | 9 | 8 | 4 | 59 | 40 | |||
19763 | 18919 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2645 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002161.66396 | 2115714.10413 | 37.7894692786198 | -122.436375304992 | (37.7894692786198, -122.436375304992) | 13 | 6 | 1 | 29490 | 27 | |||
20246 | 21299 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2500X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5985009.9602829 | 2098185.8984763 | 37.7403522506308 | -122.494424831045 | (37.7403522506308, -122.494424831045) | 1 | 8 | 3 | 29491 | 35 | |||
20250 | 16280 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 696 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/03/1990 12:00:00 AM | 12 | 3X3 | 5997496.61353 | 2094747.10919 | 37.7316330243257 | -122.451003234912 | (37.7316330243257, -122.451003234912) | 9 | 7 | 4 | 59 | 40 | ||
20452 | 21375 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2600X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5985033.8876136 | 2097503.4419654 | 37.7384798087017 | -122.494291809869 | (37.7384798087017, -122.494291809869) | 1 | 8 | 3 | 29491 | 35 | |||
20487 | 20789 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1703X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 10 | 5984905.3324351 | 2103602.9558617 | 37.7552198878299 | -122.495185956691 | (37.7552198878299, -122.495185956691) | 1 | 8 | 3 | 56 | 35 | |||
20534 | 20773 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1700X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984823.7077142 | 2103627.2778149 | 37.7552818900199 | -122.495470028613 | (37.7552818900199, -122.495470028613) | 1 | 8 | 3 | 56 | 35 | |||
20590 | 10526 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010016.24586 | 2090146.56283 | 37.7197096903227 | -122.40739596955 | (37.7197096903227, -122.40739596955) | 9 | 7 | 8 | 309 | 18 | |||
20694 | 11897 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2002 12:00:00 AM | 18 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
20876 | 14615 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1655X Masonic Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999993.83806 | 2106945.43035 | 37.7652693234708 | -122.443245665889 | (37.7652693234708, -122.443245665889) | 15 | 5 | 5 | 29492 | 3 | |||
20948 | 20644 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1500X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10 | 5984804.3392132 | 2104951.3164434 | 37.7589161983039 | -122.495634665209 | (37.7589161983039, -122.495634665209) | 1 | 8 | 3 | 56 | 35 | |||
21418 | 10896 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300X Hudson Ave | 3 | 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 | |||
21715 | 1234 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3633 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5993305.81701 | 2087547.31495 | 37.7116233210332 | -122.464968830366 | (37.7116233210332, -122.464968830366) | 9 | 8 | 4 | 64 | 24 | |||
21771 | 4886 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 810X Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2000 12:00:00 AM | 18 | 3X70 | 6009498.8982 | 2090113.01653 | 37.7195886091646 | -122.409181897741 | (37.7195886091646, -122.409181897741) | 9 | 3 | 7 | 309 | 28 | ||
21866 | 90992 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2745 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987007.45758 | 2111141.11704 | 37.7760404365843 | -122.48847027088 | (37.7760404365843, -122.48847027088) | 11 | 6 | 2 | 55 | 26 | ||
21869 | 1059 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2058 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6000366.95559 | 2090175.28019 | 37.7192437407752 | -122.440752097656 | (37.7192437407752, -122.440752097656) | 9 | 7 | 6 | 28861 | 25 | |||
22233 | 11427 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 722X Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016169.29297 | 2097000.91139 | 37.7388728426442 | -122.38660458642 | (37.7388728426442, -122.38660458642) | 10 | 3 | 8 | 58 | 1 | |||
22440 | 16226 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 562 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5998337.61942 | 2094733.99815 | 37.7316451364134 | -122.448094779751 | (37.7316451364134, -122.448094779751) | 9 | 7 | 4 | 59 | 40 | |||
22471 | 177641 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5900 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | 5996637.80016 | 2086397.84413 | 37.7086586987048 | -122.453369731652 | (37.7086586987048, -122.453369731652) | 9 | 7 | 6 | 28861 | 25 | |||
22819 | 15059 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10X Minerva St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996572.9500165 | 2089038.2134875 | 37.7159048245128 | -122.45378440062 | (37.7159048245128, -122.45378440062) | 9 | 8 | 6 | 28861 | 24 | |||
22909 | 12840 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2306 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 5988228.37522 | 2114687.85651 | 37.7858499460156 | -122.48450705297 | (37.7858499460156, -122.48450705297) | 11 | 6 | 1 | 55 | 33 | |||
22996 | 11425 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 722X Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016169.29297 | 2097000.91139 | 37.7388728426442 | -122.38660458642 | (37.7388728426442, -122.38660458642) | 10 | 3 | 8 | 58 | 1 | |||
23128 | 20959 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000X Sunset Blvd | 5 | 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 | |||
23141 | 252866 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1660 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000023 | 2106990 | 37.7653933634599 | -122.443148003218 | (37.7653933634599, -122.443148003218) | 15 | 5 | 5 | 29492 | 3 | ||||
23193 | 10672 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1099X Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002688.4855 | 2110577.4857 | 37.775395340044 | -122.43418520195 | (37.775395340044, -122.43418520195) | 15 | 5 | 11 | 29492 | 10 | |||
23485 | 3487 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301X Cargo Way | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | |||
23785 | 21127 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2203X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/1997 12:00:00 AM | 3 | 10 | 5985013.3358538 | 2100217.4790898 | 37.745930619038 | -122.494562890162 | (37.745930619038, -122.494562890162) | 1 | 8 | 3 | 29491 | 35 | ||
24012 | 8658 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2807 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/1994 12:00:00 AM | 6 | 3X3 | 5998399.1111 | 2113100.5929 | 37.7820787552534 | -122.449204902046 | (37.7820787552534, -122.449204902046) | 15 | 6 | 2 | 54 | 16 | ||
24115 | 3156 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3395X California St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 5x16 | 5998207.526573 | 2114818.376913 | 37.78678437906 | -122.449991538327 | (37.78678437906, -122.449991538327) | 15 | 6 | 1 | 54 | 31 | |||
24159 | 10982 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1478 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6016356.31002 | 2096980.69736 | 37.7388276906321 | -122.385956553763 | (37.7388276906321, -122.385956553763) | 10 | 3 | 8 | 58 | 1 | |||
24236 | 15958 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5858 MISSION ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5996945.1 | 2086589.8 | 37.7092033751387 | -122.452321511011 | (37.7092033751387, -122.452321511011) | 9 | 7 | 6 | 28861 | 25 | |||
24255 | 20614 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1403X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984795.0202245 | 2105623.5542948 | 37.7607614301436 | -122.495716480052 | (37.7607614301436, -122.495716480052) | 1 | 8 | 3 | 56 | 35 | |||
24543 | 20741 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1603X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984871.9653092 | 2104287.6004361 | 37.757097778558 | -122.49535183767 | (37.757097778558, -122.49535183767) | 1 | 8 | 3 | 56 | 35 | |||
24573 | 9040 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5435 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/1994 12:00:00 AM | 8 | 3X3 | 5990114.663 | 2112613.7237 | 37.7802646194615 | -122.477829416556 | (37.7802646194615, -122.477829416556) | 11 | 6 | 2 | 55 | 26 | ||
24795 | 21088 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2103X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984987.6230273 | 2100889.8482373 | 37.7477752566644 | -122.494701361992 | (37.7477752566644, -122.494701361992) | 1 | 8 | 3 | 29491 | 35 | |||
25203 | 1031 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1984 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000748.31196 | 2090644.16977 | 37.7205529162678 | -122.439467489832 | (37.7205529162678, -122.439467489832) | 9 | 7 | 6 | 28861 | 25 | |||
25329 | 1037 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1995 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000781.27408 | 2090531.40269 | 37.7202451592572 | -122.439345471618 | (37.7202451592572, -122.439345471618) | 9 | 7 | 6 | 28861 | 25 | |||
25663 | 124292 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4401x Cornwall St | 2 | Median : Yard | Tree | DPW 1 | 18 | Width 7ft | 5993800.52883 | 2114192.89776 | 37.7848138297402 | -122.465193144089 | (37.7848138297402, -122.465193144089) | 11 | 6 | 2 | 54 | 11 | |||
25775 | 18716 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65X Roosevelt Way | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001677.14761 | 2107395.15996 | 37.7666000127186 | -122.437455715402 | (37.7666000127186, -122.437455715402) | 15 | 5 | 5 | 28862 | 3 | |||
25948 | 8802 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3700 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5995518.15698 | 2112860.63855 | 37.7812547016031 | -122.459154247437 | (37.7812547016031, -122.459154247437) | 11 | 6 | 2 | 54 | 11 | |||
25955 | 12134 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400X La Salle Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/1996 12:00:00 AM | 8 | 3X3 | 6016411.87063 | 2095295.25189 | 37.7342028712732 | -122.385647014298 | (37.7342028712732, -122.385647014298) | 10 | 3 | 8 | 58 | 1 | ||
26402 | 10943 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1398X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6016847.08406 | 2096598.97391 | 37.7378067029035 | -122.384233093 | (37.7378067029035, -122.384233093) | 10 | 3 | 8 | 58 | 1 | ||
26478 | 9144 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5920 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5988605.85195 | 2112678.07483 | 37.7803536274735 | -122.48305374502 | (37.7803536274735, -122.48305374502) | 11 | 6 | 2 | 55 | 26 | |||
26590 | 113154 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300X POINT LOBOS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 12 | 5981901 | 2112674 | 37.7799500018865 | -122.50624824453 | (37.7799500018865, -122.50624824453) | 11 | 6 | 2 | 55 | 26 | |||
26744 | 70431 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3940 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/14/1994 12:00:00 AM | 5982333 | 2105594 | 37.760535794591 | -122.504229174925 | (37.760535794591, -122.504229174925) | 1 | 8 | 3 | 56 | 35 | ||||
27038 | 30136 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 890X Mansell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x6 | 6009289.45808 | 2090050.20778 | 37.719404413654 | -122.409901427998 | (37.719404413654, -122.409901427998) | 9 | 3 | 7 | 309 | 28 | |||
27202 | 99737 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 900X Ocean Ave | 3 | Median : Cutout | Tree | DPW 1 | 5997264.7 | 2091625.4 | 37.7230482703916 | -122.451579911331 | (37.7230482703916, -122.451579911331) | 9 | 7 | 4 | 28861 | 40 | |||||
27229 | 19352 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/16/1998 12:00:00 AM | 3 | 3X3 | 5992301.66271 | 2089835.42474 | 37.7178479668989 | -122.468605803823 | (37.7178479668989, -122.468605803823) | 9 | 8 | 6 | 64 | 24 | ||
27588 | 16154 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 395 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999478.9553736 | 2094639.3973427 | 37.731450563021 | -122.444142172906 | (37.731450563021, -122.444142172906) | 9 | 7 | 4 | 63 | 40 | |||
27683 | 24684 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6710X Geary Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5986222.534148 | 2112571.777854 | 37.7799227926563 | -122.491290810224 | (37.7799227926563, -122.491290810224) | 11 | 6 | 2 | 55 | 26 | |||
27690 | 3151 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3395X California St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/1999 12:00:00 AM | 18 | 4x4 | 5998207.526573 | 2114818.376913 | 37.78678437906 | -122.449991538327 | (37.78678437906, -122.449991538327) | 15 | 6 | 1 | 54 | 31 | ||
27790 | 1239 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3702X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3X5 | 5993039.27607 | 2087635.23978 | 37.711849369237 | -122.465896444163 | (37.711849369237, -122.465896444163) | 9 | 8 | 4 | 64 | 24 | |||
27993 | 213231 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1x Minerva St | 51 | Median : Cutout | Tree | DPW 1 | 27 | Width 0ft | 5996543.8328 | 2088997.86009 | 37.7157923540991 | -122.453882130253 | (37.7157923540991, -122.453882130253) | 9 | 8 | 6 | 28861 | 24 | |||
28072 | 10607 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 22 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6016994.80167 | 2095495.89651 | 37.7347860393267 | -122.383645581171 | (37.7347860393267, -122.383645581171) | 10 | 3 | 8 | 58 | 1 | |||
28184 | 109638 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1X Geneva Ave | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6001799 | 2091822 | 37.723846713797 | -122.435919833731 | (37.723846713797, -122.435919833731) | 9 | 7 | 6 | 28861 | 25 | ||||
28266 | 8950 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4800 Geary Blvd | 11 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
28312 | 10967 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1443 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016505.63953 | 2096794.13456 | 37.7383236898955 | -122.385427239795 | (37.7383236898955, -122.385427239795) | 10 | 3 | 8 | 58 | 1 | |||
28387 | 90300 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4425 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981861.24257 | 2110957.0551 | 37.775233435802 | -122.506258429872 | (37.775233435802, -122.506258429872) | 11 | 6 | 2 | 55 | 26 | ||
28438 | 3556 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018742.23536 | 2097565.89761 | 37.7405662870104 | -122.377747650939 | (37.7405662870104, -122.377747650939) | 10 | 3 | 8 | 58 | 1 | |||
28591 | 8858 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4100 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5994165.98943 | 2112811.42847 | 37.7810417566011 | -122.463828472047 | (37.7810417566011, -122.463828472047) | 11 | 6 | 2 | 54 | 11 | |||
28866 | 1609 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 741 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5995628.32947 | 2111171.314 | 37.7766225976947 | -122.458650775877 | (37.7766225976947, -122.458650775877) | 11 | 6 | 2 | 54 | 11 | |||
28965 | 21126 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2203X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 10 | 5985013.3358538 | 2100217.4790898 | 37.745930619038 | -122.494562890162 | (37.745930619038, -122.494562890162) | 1 | 8 | 3 | 29491 | 35 | |||
29019 | 90276 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4314 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982167.88762 | 2111025.94337 | 37.7754406305568 | -122.505202799812 | (37.7754406305568, -122.505202799812) | 11 | 6 | 2 | 55 | 26 | ||
29123 | 90254 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3202 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5985621.53252 | 2111149.66239 | 37.7759829347997 | -122.493265113137 | (37.7759829347997, -122.493265113137) | 11 | 6 | 2 | 55 | 26 | ||
29172 | 14427 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10X Masonic Ave | 3 | Median : Cutout | Tree | DPW 1 | 35 | 12 | 5998974.4449529 | 2113166.8020455 | 37.7822934389095 | -122.447219282793 | (37.7822934389095, -122.447219282793) | 15 | 5 | 1 | 54 | 16 | |||
29478 | 8641 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2600X Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5999196.602 | 2113264.8967 | 37.7825754726316 | -122.446457780402 | (37.7825754726316, -122.446457780402) | 15 | 5 | 1 | 54 | 31 | |||
29565 | 90993 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2739 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987029.8281 | 2111142.80406 | 37.7760463739382 | -122.48839301037 | (37.7760463739382, -122.48839301037) | 11 | 6 | 2 | 55 | 26 | ||
29573 | 15651 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3723 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005328.4757 | 2096510.5274 | 37.7369202420501 | -122.424052265727 | (37.7369202420501, -122.424052265727) | 2 | 7 | 7 | 28859 | 2 | |||
29742 | 20615 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1403X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10 | 5984795.0202245 | 2105623.5542948 | 37.7607614301436 | -122.495716480052 | (37.7607614301436, -122.495716480052) | 1 | 8 | 3 | 56 | 35 | |||
29870 | 2695 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2111 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/2003 12:00:00 AM | 3 | 3x3 | 6003424.2987912 | 2114891.8357248 | 37.787283200782 | -122.431947991092 | (37.787283200782, -122.431947991092) | 13 | 9 | 11 | 29490 | 27 | ||
30065 | 107237 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1340 HUDSON AVE | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 6017131 | 2095773 | 37.7355544375929 | -122.383193973215 | (37.7355544375929, -122.383193973215) | 10 | 3 | 8 | 58 | 1 | ||||
30386 | 236 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2996X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X5 | 5990618.96661 | 2095242.77985 | 37.7325978647004 | -122.474816544366 | (37.7325978647004, -122.474816544366) | 1 | 8 | 4 | 64 | 40 | |||
30392 | 24797 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 7521 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2005 12:00:00 AM | 3 | 3X3 | 5983656.61314 | 2112387.41673 | 37.7792663253199 | -122.500153699286 | (37.7792663253199, -122.500153699286) | 11 | 6 | 2 | 55 | 26 | ||
30426 | 6073 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1944 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001125.2679 | 2112488.2186 | 37.7805528822601 | -122.439729742976 | (37.7805528822601, -122.439729742976) | 15 | 5 | 11 | 29490 | 41 | |||
30531 | 11610 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X3 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
30571 | 18128 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400X Portola Dr | 1 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 5993139.2629046 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | 1 | 8 | 4 | 59 | 40 | |||
30686 | 2172 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1010X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001284.93622 | 2109041.43324 | 37.7710979644197 | -122.438930293594 | (37.7710979644197, -122.438930293594) | 15 | 5 | 11 | 29492 | 9 | |||
30789 | 3145 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3333 California St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5998356.8929 | 2114831.5358 | 37.7868290555036 | -122.449475716773 | (37.7868290555036, -122.449475716773) | 15 | 6 | 1 | 54 | 31 |
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) );