Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189095 | 189095 | 83407 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 745 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52540 | 6007021.2303 | 2113557.8449 | 37.783823644044794 | -122.419408670548 | (37.7838236440448, -122.419408670548) | |
| 189089 | 189089 | 117809 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3840 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5983588.39645 | 2111074.63902 | 37.775657815018896 | -122.50029260305901 | (37.7756578150189, -122.500292603059) | |||
| 189083 | 189083 | 231390 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007475.91312 | 2099467.8666 | 37.745161448558605 | -122.416837059595 | (37.7451614485586, -122.416837059595) | |||
| 189071 | 189071 | 210353 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 116 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5993170.86596 | 2099198.21757 | 37.74360605486729 | -122.46628144035601 | (37.7436060548673, -122.466281440356) | |||
| 189064 | 189064 | 185387 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2300 Sunset Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 0ft | 5985052.012999999 | 2099287.3331 | 37.743378953957794 | -122.494360600593 | (37.7433789539578, -122.494360600593) | |||
| 189055 | 189055 | 250836 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 283 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986490.348619999 | 2114051.42085 | 37.7840011137113 | -122.49047321958 | (37.7840011137113, -122.49047321958) | |||
| 189038 | 189038 | 131471 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 280 Redwood St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6006315.87363 | 2112335.20118 | 37.7804268103756 | -122.421762072675 | (37.7804268103756, -122.421762072675) | |||
| 189019 | 189019 | 248579 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 794 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998642.0083 | 2107670.5786 | 37.7671832202752 | -122.44797351892599 | (37.7671832202752, -122.447973518926) | |||
| 189000 | 189000 | 123975 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 59 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993615.75025 | 2115111.34494 | 37.7873249775569 | -122.4658991705 | (37.7873249775569, -122.4658991705) | |||
| 188998 | 188998 | 183023 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2550 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983685.1086 | 2097771.6711 | 37.739137270019 | -122.49897497427901 | (37.739137270019, -122.498974974279) | |||
| 188991 | 188991 | 218259 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400x Portola Dr | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5992809.1507 | 2097219.8287299997 | 37.7381530219397 | -122.46738832232 | (37.7381530219397, -122.46738832232) | ||||
| 188974 | 188974 | 250864 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 170 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986515.92946 | 2114612.51535 | 37.7855432117965 | -122.49042601236 | (37.7855432117965, -122.49042601236) | |||
| 188951 | 188951 | 177670 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 946 Olmstead St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008872.57604 | 2090401.61835 | 37.7203459408834 | -122.411367252501 | (37.7203459408834, -122.411367252501) | |||
| 188946 | 188946 | 210372 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 195 Kensington Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994217.10914 | 2099094.32927 | 37.7433811146583 | -122.46265628039 | (37.7433811146583, -122.46265628039) | |||
| 188917 | 188917 | 232553 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 665 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002074.013180001 | 2102049.1230599997 | 37.7519436434985 | -122.43570050948 | (37.7519436434985, -122.43570050948) | |||
| 188893 | 188893 | 140656 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2250 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997220.8834 | 2109861.2154 | 37.7731168094428 | -122.453047103766 | (37.7731168094428, -122.453047103766) | |||
| 188884 | 188884 | 186847 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2700 Sunset Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 0ft | 5985140.3975 | 2096462.5634 | 37.73562806681571 | -122.493846870805 | (37.7356280668157, -122.493846870805) | |||
| 188861 | 188861 | 210378 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 52 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5993374.1705 | 2093389.9172200002 | 37.727669636524794 | -122.46515668074899 | (37.7276696365248, -122.465156680749) | |||
| 188857 | 188857 | 182887 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2701 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5982431.1859 | 2096675.2907 | 37.736053277353705 | -122.503229244147 | (37.7360532773537, -122.503229244147) | |||
| 188825 | 188825 | 193903 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014692.85578 | 2110638.20466 | 37.776236072159996 | -122.392663186766 | (37.77623607216, -122.392663186766) | |||
| 188824 | 188824 | 131583 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1232 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007143.44817 | 2119511.4983900003 | 37.8001777841442 | -122.419408349913 | (37.8001777841442, -122.419408349913) | |||
| 188800 | 188800 | 184156 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3400 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983666.6511 | 2104289.914 | 37.757033484731004 | -122.49952038054701 | (37.757033484731, -122.499520380547) | |||
| 188759 | 188759 | 232775 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4702 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000220.76645 | 2104639.33564 | 37.7589502948468 | -122.442295211967 | (37.7589502948468, -122.442295211967) | |||
| 188757 | 188757 | 131639 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 John Maher St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012517.79158 | 2119695.20026 | 37.8009834157025 | -122.40082382928301 | (37.8009834157025, -122.400823829283) | |||
| 188735 | 188735 | 184433 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3814 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5981600.6988 | 2100822.1423 | 37.7473905292661 | -122.506407948923 | (37.7473905292661, -122.506407948923) | |||
| 188733 | 188733 | 122051 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 155 18th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5990200.56519 | 2114371.40602 | 37.785095710141505 | -122.47766075953501 | (37.7850957101415, -122.477660759535) | |||
| 188712 | 188712 | 69011 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2154 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 10 | Permit Number 33014 | 5982348.1034 | 2100442.2638 | 37.7463914641075 | -122.50379538901001 | (37.7463914641075, -122.50379538901) | |
| 188705 | 188705 | 186849 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2700 Sunset Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985134.8973 | 2096609.0061 | 37.7360298376031 | -122.493876675464 | (37.7360298376031, -122.493876675464) | |||
| 188688 | 188688 | 177734 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1185 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6003355.65211 | 2094241.1005400002 | 37.7305773290785 | -122.430711291105 | (37.7305773290785, -122.430711291105) | |||
| 188681 | 188681 | 199886 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1501 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015908.558999999 | 2094353.114 | 37.7315880872084 | -122.38732143959999 | (37.7315880872084, -122.3873214396) | |||
| 188675 | 188675 | 185824 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3021 Pacheco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5985576.2606 | 2101582.453 | 37.7497113976278 | -122.492716916208 | (37.7497113976278, -122.492716916208) | |||
| 188617 | 188617 | 58966 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 205 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1980 12:00:00 AM | 15 | Permit Number 18248 | 5994892.071719999 | 2114155.06341 | 37.78477283129121 | -122.46141404577801 | (37.7847728312912, -122.461414045778) | ||
| 188581 | 188581 | 143159 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 30 MIDWAY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6010083.8953 | 2121533.9898 | 37.805896219637496 | -122.40937602503 | (37.8058962196375, -122.40937602503) | |||
| 188565 | 188565 | 185372 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Wawona St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5983789.4975 | 2096821.8757 | 37.7365355115304 | -122.498543910586 | (37.7365355115304, -122.498543910586) | |||
| 188550 | 188550 | 231380 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 258 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6006105.02228 | 2096078.3054 | 37.7357772693965 | -122.421336710424 | (37.7357772693965, -122.421336710424) | |||
| 188526 | 188526 | 118205 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 618 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5985072.5538099995 | 2111637.49972 | 37.7772902712889 | -122.49520012917 | (37.7772902712889, -122.49520012917) | |||
| 188500 | 188500 | 131531 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 899 Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009989.68499 | 2116646.9055 | 37.7924722075687 | -122.40935695115499 | (37.7924722075687, -122.409356951155) | |||
| 188487 | 188487 | 231253 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 93 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6005058.7335 | 2104551.61986 | 37.758983997825204 | -122.425556997657 | (37.7589839978252, -122.425556997657) | |||
| 188485 | 188485 | 182894 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2710 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5982313.7536 | 2096525.7083 | 37.7356356612407 | -122.503624174318 | (37.7356356612407, -122.503624174318) | |||
| 188480 | 188480 | 65600 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 65 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 18 | 9x4.5 | Permit Number 28502 | 6003805.36917 | 2093762.79554 | 37.7292894792277 | -122.429122461528 | (37.7292894792277, -122.429122461528) |
| 188445 | 188445 | 232771 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4530 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001267.37682 | 2104094.20879 | 37.7575131044697 | -122.43863649018 | (37.7575131044697, -122.43863649018) | |||
| 188422 | 188422 | 183160 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2359 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5981732.5141 | 2099040.0130000003 | 37.742505058297404 | -122.50582004946199 | (37.7425050582974, -122.505820049462) | |||
| 188418 | 188418 | 232181 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 165 Roosevelt Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6001233.9639099995 | 2107409.58015 | 37.7666144009701 | -122.43898964045601 | (37.7666144009701, -122.438989640456) | |||
| 188366 | 188366 | 184365 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2246 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5981748.9474 | 2099793.4739 | 37.7445748198756 | -122.505819075039 | (37.7445748198756, -122.505819075039) | |||
| 188353 | 188353 | 183708 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1367 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5983360.8125 | 2105830.6285 | 37.761245903222296 | -122.500691996816 | (37.7612459032223, -122.500691996816) | |||
| 188331 | 188331 | 232208 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6 Park Hill Ave | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6001153.48827 | 2107682.20045 | 37.7673583696159 | -122.439287533699 | (37.7673583696159, -122.439287533699) | |||
| 188320 | 188320 | 119983 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 351 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5987493.39104 | 2115287.18901 | 37.787452713746 | -122.48709389374399 | (37.787452713746, -122.487093893744) | |||
| 188314 | 188314 | 56091 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 764 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1973 12:00:00 AM | 14 | Permit Number 12189 | 5981386.79293 | 2110532.60366 | 37.77404007412879 | -122.50786812371099 | (37.7740400741288, -122.507868123711) | ||
| 188293 | 188293 | 213216 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 211 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994887.0913 | 2088379.5209299999 | 37.7139994126132 | -122.45956379603201 | (37.7139994126132, -122.459563796032) | |||
| 188280 | 188280 | 143441 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 501 KEARNY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6011486.9958 | 2116406.7742 | 37.7918966415155 | -122.4041592748 | (37.7918966415155, -122.4041592748) | |||
| 188279 | 188279 | 193951 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1333 Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017949.6573 | 2094593.78019 | 37.7323617377914 | -122.380281607712 | (37.7323617377914, -122.380281607712) | |||
| 188278 | 188278 | 183088 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 42nd Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983384.5770000005 | 2097376.5313 | 37.7380346904942 | -122.499984858817 | (37.7380346904942, -122.499984858817) | |||
| 188276 | 188276 | 232160 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 204 Roosevelt Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001052.08044 | 2107402.23134 | 37.76658387258139 | -122.439618215322 | (37.7665838725814, -122.439618215322) | |||
| 188260 | 188260 | 139375 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2451 SUTTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000996.0798 | 2114152.7262 | 37.7851158399965 | -122.44029606874099 | (37.7851158399965, -122.440296068741) | |||
| 188257 | 188257 | 210275 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1148 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 5991231.06617 | 2105231.36894 | 37.7600593981514 | -122.47342868628401 | (37.7600593981514, -122.473428686284) | |||
| 188246 | 188246 | 249930 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 345 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 0ft | 6011183.60917 | 2120017.47195 | 37.8017937876064 | -122.40546340291999 | (37.8017937876064, -122.40546340292) | |||
| 188239 | 188239 | 200013 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1401 Griffith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6017733.4979 | 2092339.4479 | 37.7261598523232 | -122.38087226721599 | (37.7261598523232, -122.380872267216) | |||
| 188229 | 188229 | 122233 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 664 14th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 5991642.185219999 | 2110940.40215 | 37.7757586700444 | -122.47242304061399 | (37.7757586700444, -122.472423040614) | |||
| 188211 | 188211 | 182131 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5987946.7845 | 2098317.4825 | 37.740884983303204 | -122.484280230772 | (37.7408849833032, -122.484280230772) | |||
| 188210 | 188210 | 209941 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401 14th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5992008.19047 | 2098968.5284 | 37.742908234043796 | -122.47028492711 | (37.7429082340438, -122.47028492711) | |||
| 188204 | 188204 | 232517 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 96 Homestead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6000967.63208 | 2101175.21313 | 37.74948119091621 | -122.43946388536101 | (37.7494811909162, -122.439463885361) | |||
| 188190 | 188190 | 213180 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 79 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995306.54199 | 2090415.6756 | 37.7196143226245 | -122.458261309722 | (37.7196143226245, -122.458261309722) | |||
| 188166 | 188166 | 210031 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 66 Martha Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000584.10711 | 2095656.05125 | 37.734305044127495 | -122.44039434913401 | (37.7343050441275, -122.440394349134) | |||
| 188131 | 188131 | 39237 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 6 | Permit Number 40872 | 6007370.26248 | 2112668.82776 | 37.781402270828295 | -122.418138097991 | (37.7814022708283, -122.418138097991) | ||
| 188114 | 188114 | 182883 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3401 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5982308.1696 | 2096702.7029 | 37.73612131180229 | -122.50365658341002 | (37.7361213118023, -122.50365658341) | |||
| 188111 | 188111 | 193912 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 Berry St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6014944.72987 | 2110876.13402 | 37.7769033583289 | -122.39180851876301 | (37.7769033583289, -122.391808518763) | |||
| 188110 | 188110 | 68454 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1824 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1993 12:00:00 AM | 8 | Permit Number 32316 | 6005458.13045 | 2117201.77806 | 37.7937408128466 | -122.425075777637 | (37.7937408128466, -122.425075777637) | ||
| 188066 | 188066 | 101112 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1611 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5988946.0821 | 2103051.1539 | 37.7539405298718 | -122.481171610101 | (37.7539405298718, -122.481171610101) | |||
| 188044 | 188044 | 210421 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 167 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994382.92519 | 2095492.46879 | 37.7335008478732 | -122.461821819218 | (37.7335008478732, -122.461821819218) | |||
| 188006 | 188006 | 139687 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Saint Joseph's Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000433.2846 | 2113232.0371 | 37.782555805804 | -122.44217704453199 | (37.782555805804, -122.442177044532) | |||
| 187996 | 187996 | 140851 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 571 Euclid Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 5996626.4577 | 2113806.2024 | 37.7839146219169 | -122.45538845370001 | (37.7839146219169, -122.4553884537) | |||
| 187995 | 187995 | 187310 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2200 Sunset Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 0ft | 5985030.9318 | 2099750.1318 | 37.7446484400934 | -122.49446760159401 | (37.7446484400934, -122.494467601594) | |||
| 187944 | 187944 | 118504 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8149 Geary Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5981658.42687 | 2112320.40323 | 37.778964846285 | -122.507061160796 | (37.778964846285, -122.507061160796) | ||||
| 187940 | 187940 | 232705 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 575 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6001463.33313 | 2101429.91062 | 37.7502087280675 | -122.43776797981 | (37.7502087280675, -122.43776797981) | |||
| 187935 | 187935 | 232578 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1816 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6002582.77555 | 2100317.86283 | 37.7472188968407 | -122.43381740825701 | (37.7472188968407, -122.433817408257) | |||
| 187930 | 187930 | 63653 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3400 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1987 12:00:00 AM | 5 | Permit Number 24300 | 5983704.2368 | 2104292.0530000003 | 37.7570415630367 | -122.49939055504 | (37.7570415630367, -122.49939055504) | |
| 187912 | 187912 | 231243 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 870 Treat Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 3ft | 6008548.77023 | 2103484.7360799997 | 37.7562511586886 | -122.413411316203 | (37.7562511586886, -122.413411316203) | |||
| 187887 | 187887 | 250037 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2 Daniel Burnham Ct | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6006314.34591 | 2114758.99752 | 37.7870818744731 | -122.42193958446998 | (37.7870818744731, -122.42193958447) | |||
| 187884 | 187884 | 131667 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6011626.61094 | 2117682.40003 | 37.7954070047799 | -122.403766001804 | (37.7954070047799, -122.403766001804) | |||
| 187858 | 187858 | 209882 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 550 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5995386.655119999 | 2106291.65804 | 37.763210444528106 | -122.459133369735 | (37.7632104445281, -122.459133369735) | |||
| 187835 | 187835 | 232484 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 534 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6001731.64356 | 2100900.62439 | 37.7487706869304 | -122.436802262622 | (37.7487706869304, -122.436802262622) | |||
| 187798 | 187798 | 143157 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 30 MIDWAY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010090.163 | 2121485.1014 | 37.8057623354244 | -122.40935088231001 | (37.8057623354244, -122.40935088231) | |||
| 187794 | 187794 | 131507 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 391 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6008146.95768 | 2113065.94872 | 37.7825363555003 | -122.41547922540899 | (37.7825363555003, -122.415479225409) | |||
| 187754 | 187754 | 123064 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 405 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992157.48705 | 2112628.1982299997 | 37.7804227097672 | -122.47076346601101 | (37.7804227097672, -122.470763466011) | |||
| 187750 | 187750 | 193859 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90 Stevenson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 6012502.23298 | 2115355.06002 | 37.789065556785495 | -122.400572617131 | (37.7890655567855, -122.400572617131) | |||
| 187743 | 187743 | 232177 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 118 Museum Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6000959.17951 | 2106598.84201 | 37.7643726761943 | -122.43988193432699 | (37.7643726761943, -122.439881934327) | |||
| 187733 | 187733 | 131522 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1083 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009542.343090001 | 2117079.4498400004 | 37.7936347953637 | -122.41093533781999 | (37.7936347953637, -122.41093533782) | |||
| 187715 | 187715 | 83139 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/2006 12:00:00 AM | 4 | 6016637.95414 | 2095483.71733 | 37.7347328669128 | -122.38487848967699 | (37.7347328669128, -122.384878489677) | ||
| 187685 | 187685 | 51375 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 548 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2004 12:00:00 AM | 3 | Permit Number 47708 | 6009914.05728 | 2108346.99937 | 37.769678390277 | -122.40903272848499 | (37.769678390277, -122.409032728485) | ||
| 187660 | 187660 | 193894 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 De Boom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6014858.98059 | 2112957.79621 | 37.782614372583794 | -122.39225077834699 | (37.7826143725838, -122.392250778347) | |||
| 187640 | 187640 | 184700 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3649 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5982879.3386 | 2104210.923 | 37.7567703719175 | -122.50223731592199 | (37.7567703719175, -122.502237315922) | |||
| 187634 | 187634 | 231248 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1039 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009998.98174 | 2103147.21886 | 37.7554057303083 | -122.408372158452 | (37.7554057303083, -122.408372158452) | |||
| 187626 | 187626 | 183369 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3000 Quintara St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983728.1875 | 2100894.5645 | 37.7477144082933 | -122.499056705621 | (37.7477144082933, -122.499056705621) | |||
| 187624 | 187624 | 248183 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 216 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 43 | 6007446.150909999 | 2098698.08371 | 37.743046122577894 | -122.416885444016 | (37.7430461225779, -122.416885444016) | ||||
| 187598 | 187598 | 209849 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1218 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993324.64026 | 2107154.55748 | 37.765460981767895 | -122.466327849866 | (37.7654609817679, -122.466327849866) | |||
| 187578 | 187578 | 184279 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1507 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982465.775 | 2104814.3384 | 37.758402873004705 | -122.503712233236 | (37.7584028730047, -122.503712233236) | |||
| 187571 | 187571 | 250436 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5987616.8568 | 2115817.96032 | 37.7889172576592 | -122.486705722111 | (37.7889172576592, -122.486705722111) | |||
| 187568 | 187568 | 40690 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 190 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 12 | 5x10 | Permit Number 41673 | 6004620.52288 | 2094031.3393400002 | 37.730072951499 | -122.42632351321998 | (37.730072951499, -122.42632351322) |
| 187566 | 187566 | 209902 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5991457.920609999 | 2104558.57905 | 37.7582252290246 | -122.47259506063801 | (37.7582252290246, -122.472595060638) | |||
| 187535 | 187535 | 193930 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 102 Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6016666.74671 | 2095388.9397900002 | 37.734474219207705 | -122.384772342665 | (37.7344742192077, -122.384772342665) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");