trees
8,758 rows where qSpecies_id = 16 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24 | 264941 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Portola Dr | 12 | Median : Cutout | Tree | Private 2 | 3x3 | 5999749 | 2101261 | 37.7496473113918 | -122.443684097942 | (37.7496473113918, -122.443684097942) | 2 | 5 | 5 | 28862 | 38 | ||||
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 | ||||
487 | 5304 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1635 Divisadero St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6001115.9968 | 2113959.0141 | 37.7845907831124 | -122.439867300639 | (37.7845907831124, -122.439867300639) | 15 | 6 | 11 | 29490 | 13 | |||
529 | 131532 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 899 Powell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009999.72804 | 2116574.87915 | 37.7922750033291 | -122.409317116588 | (37.7922750033291, -122.409317116588) | 5 | 1 | 10 | 28857 | 21 | |||
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 | ||
556 | 116312 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1515 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6001647.9793 | 2113762.7776 | 37.784082235457 | -122.438012762917 | (37.784082235457, -122.438012762917) | 15 | 6 | 11 | 29490 | 13 | ||||
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 | |||
829 | 262514 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
836 | 115913 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 701X 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5987215.25385 | 2111126.11495 | 37.776011367597 | -122.487750355607 | (37.776011367597, -122.487750355607) | 11 | 6 | 2 | 55 | 26 | |||
850 | 181731 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2755 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987133.0103 | 2107077.382 | 37.7648898800849 | -122.487737334915 | (37.7648898800849, -122.487737334915) | 1 | 8 | 3 | 56 | 35 | |||
854 | 121835 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 19th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 5990009.97122 | 2112348.02461 | 37.7795290070423 | -122.47817215782 | (37.7795290070423, -122.47817215782) | 11 | 6 | 2 | 55 | 26 | |||
896 | 184943 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000 41st Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 12/12/2019 12:00:00 AM | 3 | 3x10 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 | |
1001 | 70458 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3222 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982856.1897 | 2099504.4786 | 37.74384642674 | -122.501969135738 | (37.74384642674, -122.501969135738) | 1 | 8 | 3 | 29491 | 35 | |||
1060 | 9003 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5211 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5990830.5755 | 2112639.2637 | 37.7803762685111 | -122.475354635721 | (37.7803762685111, -122.475354635721) | 11 | 6 | 2 | 54 | 26 | |||
1093 | 262511 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
1109 | 102184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1840X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | 12 | 3x3 | 6003534.8 | 2115143.2 | 37.7879796472282 | -122.431583632877 | (37.7879796472282, -122.431583632877) | 13 | 9 | 11 | 29490 | 27 | ||
1147 | 131409 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2817 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6003467.33625 | 2118170.97636 | 37.796289323341 | -122.432033340382 | (37.796289323341, -122.432033340382) | 13 | 9 | 1 | 57 | 17 | |||
1182 | 922 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1253 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6002943.78693 | 2094101.1406 | 37.7301696879821 | -122.432125178253 | (37.7301696879821, -122.432125178253) | 9 | 7 | 6 | 28861 | 25 | |||
1188 | 186259 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1800 Sunset Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984936.3948 | 2102583.754 | 37.7524232591449 | -122.495003387226 | (37.7524232591449, -122.495003387226) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
1217 | 8697 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3015 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5997765.247 | 2113011.588 | 37.7817980956526 | -122.451391351666 | (37.7817980956526, -122.451391351666) | 15 | 6 | 2 | 54 | 16 | |||
1274 | 78340 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4355 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5985152.99367 | 2111756.8586 | 37.7776227056539 | -122.494930668748 | (37.7776227056539, -122.494930668748) | 11 | 6 | 2 | 55 | 26 | |||
1299 | 117654 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5001 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2020 12:00:00 AM | 3 | Width 3ft | 5983150.11815 | 2111683.94621 | 37.7773050604289 | -122.501853783426 | (37.7773050604289, -122.501853783426) | 11 | 6 | 2 | 55 | 26 | ||
1307 | 184338 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300 Sunset Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 5984829.2872 | 2105764.6569 | 37.7611508651334 | -122.495608375429 | (37.7611508651334, -122.495608375429) | 1 | 8 | 3 | 56 | 35 | |||
1317 | 71329 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 346 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6003746.38005 | 2089169.34853 | 37.7166735503194 | -122.428999024181 | (37.7166735503194, -122.428999024181) | 9 | 7 | 6 | 28861 | 5 | |||
1368 | 184450 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2127 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5982917.6673 | 2100633.8105 | 37.7469508716588 | -122.501840104956 | (37.7469508716588, -122.501840104956) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||
1403 | 77662 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006681.78325 | 2093389.68756 | 37.7284274151839 | -122.419151965791 | (37.7284274151839, -122.419151965791) | 9 | 3 | 7 | 309 | 5 | ||
1457 | 209974 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 634 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995417.8126 | 2093581.25052 | 37.7283126275124 | -122.458105669454 | (37.7283126275124, -122.458105669454) | 9 | 7 | 4 | 28861 | 40 | |||
1484 | 118198 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 830 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5985123.98161 | 2110205.8621 | 37.7733624146684 | -122.49491664155 | (37.7733624146684, -122.49491664155) | 11 | 6 | 2 | 55 | 26 | |||
1485 | 70364 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4039 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5982287.6338 | 2104871.478 | 37.7585492864556 | -122.504332547004 | (37.7585492864556, -122.504332547004) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
1574 | 122761 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86X Park Hill Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001171 | 2107689 | 37.7673780360046 | -122.439227450619 | (37.7673780360046, -122.439227450619) | 15 | 5 | 5 | 29492 | 3 | ||||
1621 | 71826 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1559 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5988678.2006 | 2104711.6203 | 37.7584841471685 | -122.482219640193 | (37.7584841471685, -122.482219640193) | 1 | 8 | 3 | 56 | 35 | |||
1629 | 73716 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 946 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 3x3 | 6012746.53827 | 2103105.12598 | 37.7554436304258 | -122.398867256125 | (37.7554436304258, -122.398867256125) | 10 | 3 | 8 | 28856 | 29 | ||
1667 | 101664 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
1677 | 259282 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
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 | ||
1767 | 143451 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 KEARNY ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6011460.6008 | 2116606.6227 | 37.7924439028882 | -122.404264674229 | (37.7924439028882, -122.404264674229) | 4 | 1 | 10 | 28854 | 6 | |||
1874 | 78526 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3550 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5981863.3141 | 2099471.5008 | 37.7436975019585 | -122.505399764525 | (37.7436975019585, -122.505399764525) | 1 | 8 | 3 | 29491 | 35 | |||
1894 | 185385 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2300 Sunset Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 0ft | 5985055.3332 | 2099090.1134 | 37.7428376362899 | -122.494334586063 | (37.7428376362899, -122.494334586063) | 1 | 8 | 3 | 29491 | 35 | |||
1909 | 72386 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 350 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6012294.64496 | 2118148.60765 | 37.7967243955558 | -122.401487260038 | (37.7967243955558, -122.401487260038) | 3 | 1 | 10 | 28860 | 4 | ||
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 | |||
2042 | 71413 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1207 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6016921.2196 | 2093689.4573 | 37.7298218479605 | -122.38377424868 | (37.7298218479605, -122.38377424868) | 10 | 3 | 8 | 58 | 1 | |||
2051 | 250522 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95 26th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 5987685.78964 | 2115424.25577 | 37.7878402763649 | -122.486438309599 | (37.7878402763649, -122.486438309599) | 11 | 6 | 1 | 55 | 33 | |||
2124 | 209922 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 870 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5990546.69569 | 2099087.99208 | 37.7431516445476 | -122.475347038257 | (37.7431516445476, -122.475347038257) | 1 | 8 | 4 | 29491 | 40 | |||
2147 | 1184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3014 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 5996622.2967 | 2087313.8651 | 37.7111729927061 | -122.453489407116 | (37.7111729927061, -122.453489407116) | 9 | 7 | 6 | 28861 | 25 | |||
2162 | 250415 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Seacliff Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/14/2020 12:00:00 AM | 3 | Width 4ft | 5987895.18737 | 2115830.32518 | 37.7889674299609 | -122.485743656163 | (37.7889674299609, -122.485743656163) | 11 | 6 | 1 | 55 | 33 | ||
2182 | 83139 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6016637.95414 | 2095483.71733 | 37.7347328669128 | -122.384878489677 | (37.7347328669128, -122.384878489677) | 10 | 3 | 8 | 58 | 1 | |||
2190 | 117790 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3915 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5983427.0312 | 2111011.12513 | 37.775473951484 | -122.500846098251 | (37.775473951484, -122.500846098251) | 11 | 6 | 2 | 55 | 26 | |||
2198 | 232238 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1742 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003957.58921 | 2098088.34983 | 37.7411750875649 | -122.428904483875 | (37.7411750875649, -122.428904483875) | 2 | 7 | 5 | 63 | 7 | |||
2300 | 1941 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 217 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6000825.89094 | 2097729.82062 | 37.7400128936831 | -122.439707051235 | (37.7400128936831, -122.439707051235) | 2 | 7 | 5 | 63 | 7 | |||
2361 | 256460 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 9 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
2373 | 183738 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2271 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 09/26/2020 12:00:00 AM | 3 | 4x6 | 5985432.7595 | 2099768.105 | 37.7447212985473 | -122.493079504102 | (37.7447212985473, -122.493079504102) | 1 | 8 | 3 | 29491 | 35 | |
2400 | 232794 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 701 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x9 | 6003144.80454 | 2104133.37104 | 37.7577272573137 | -122.432146391441 | (37.7577272573137, -122.432146391441) | 2 | 4 | 5 | 28862 | 3 | |||
2401 | 75310 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Vega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5999369.874 | 2112377.7239 | 37.7801494207177 | -122.445794512547 | (37.7801494207177, -122.445794512547) | 15 | 5 | 1 | 54 | 16 | |||
2404 | 76334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006750.61437 | 2093170.72103 | 37.7278300567077 | -122.418898489194 | (37.7278300567077, -122.418898489194) | 9 | 3 | 7 | 309 | 5 | ||
2422 | 80046 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2325 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6001817.74148 | 2118715.85745 | 37.7976917657091 | -122.437780314931 | (37.7976917657091, -122.437780314931) | 13 | 9 | 1 | 57 | 17 | |||
2491 | 193810 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 285 Texas St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6013775.34661 | 2105819.12575 | 37.7629529551453 | -122.395499427275 | (37.7629529551453, -122.395499427275) | 14 | 3 | 8 | 28856 | 29 | |||
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 | |||||||||||||
2515 | 71240 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1929 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 6001514.7914 | 2112836.7931 | 37.781532142896 | -122.438407179792 | (37.781532142896, -122.438407179792) | 15 | 5 | 11 | 29490 | 41 | |||
2518 | 250436 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 Seacliff Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5987616.8568 | 2115817.96032 | 37.7889172576592 | -122.486705722111 | (37.7889172576592, -122.486705722111) | 11 | 6 | 1 | 55 | 33 | |||
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 | |||
2556 | 4083 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3215 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6008095.47339 | 2100529.11474 | 37.7481102284008 | -122.414769812274 | (37.7481102284008, -122.414769812274) | 2 | 4 | 7 | 28859 | 2 | |||
2562 | 232750 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 373 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002968.45088 | 2106099.8261 | 37.7631166695342 | -122.432896777683 | (37.7631166695342, -122.432896777683) | 15 | 4 | 5 | 28862 | 3 | |||
2639 | 210264 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1201 Irving St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5991895.36421 | 2106557.41103 | 37.7637388043301 | -122.471227833003 | (37.7637388043301, -122.471227833003) | 1 | 8 | 11 | 56 | 12 | |||
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 | |||
2663 | 181722 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2645 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5987446.5903 | 2107090.374 | 37.764943837931 | -122.486653709544 | (37.764943837931, -122.486653709544) | 1 | 8 | 3 | 56 | 35 | |||
2680 | 71821 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1270 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5988034.775 | 2106656.0393 | 37.7637855451579 | -122.484587490638 | (37.7637855451579, -122.484587490638) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
2732 | 118955 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 750 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5981074.93145 | 2110594.12979 | 37.7741906275321 | -122.508951455998 | (37.7741906275321, -122.508951455998) | 11 | 6 | 2 | 55 | 26 | |||
2738 | 140731 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2023 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2004 12:00:00 AM | 12 | Width 0ft | 6001651.0062 | 2113204.4884 | 37.7825494877114 | -122.437962288192 | (37.7825494877114, -122.437962288192) | 15 | 5 | 11 | 29490 | 41 | ||
2863 | 143418 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 575 Kearny St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 6011374.2644 | 2116814.4836 | 37.7930098144506 | -122.404578041099 | (37.7930098144506, -122.404578041099) | 3 | 1 | 10 | 28857 | 4 | |||
2926 | 183551 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5989202.4612 | 2097677.5503 | 37.7392009295048 | -122.479891799473 | (37.7392009295048, -122.479891799473) | 1 | 8 | 3 | 29491 | 35 | |||
2945 | 98684 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014207 | 2094775 | 37.7326521179743 | -122.393233618799 | (37.7326521179743, -122.393233618799) | 10 | 3 | 8 | 58 | 1 | |||||
2953 | 118676 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4825 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5980559.76523 | 2110909.18852 | 37.7750253031785 | -122.510756894567 | (37.7750253031785, -122.510756894567) | 11 | 6 | 2 | 55 | 26 | |||
2971 | 250510 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 75 27th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 5ft | 5987308.66603 | 2115522.71145 | 37.7880886178397 | -122.487750306256 | (37.7880886178397, -122.487750306256) | 11 | 6 | 1 | 55 | 33 | |||
2972 | 74792 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 749 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6007023.88187 | 2113548.27609 | 37.783797519769 | -122.419398818026 | (37.783797519769, -122.419398818026) | 7 | 9 | 9 | 28858 | 36 | |||
3003 | 131309 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Maple St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 5996544.36803 | 2115871.17754 | 37.7895797810398 | -122.455821775454 | (37.7895797810398, -122.455821775454) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||
3074 | 144281 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 690 45th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5981991.18166 | 2111072.85964 | 37.7755590499331 | -122.505817535952 | (37.7755590499331, -122.505817535952) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
3178 | 83368 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1129 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011680.56998 | 2103127.21797 | 37.7554448364124 | -122.40255527513 | (37.7554448364124, -122.40255527513) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
3264 | 1125 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2466 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5998958.39293 | 2088881.75103 | 37.7156116878713 | -122.445527983003 | (37.7156116878713, -122.445527983003) | 9 | 7 | 6 | 28861 | 25 | |||
3280 | 131640 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012516.39598 | 2119702.01834 | 37.8010020586619 | -122.400829137966 | (37.8010020586619, -122.400829137966) | 3 | 1 | 10 | 28860 | 6 | |||
3282 | 232681 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 998 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009404.5391 | 2103406.76128 | 37.7560850691817 | -122.410446255909 | (37.7560850691817, -122.410446255909) | 2 | 4 | 7 | 28859 | 19 | |||
3290 | 122954 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993081.91997 | 2114080.47457 | 37.7844636809028 | -122.467671095614 | (37.7844636809028, -122.467671095614) | 11 | 6 | 2 | 54 | 11 | |||
3317 | 75134 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Vega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5999276.808 | 2112366.556 | 37.7801134423261 | -122.44611566553 | (37.7801134423261, -122.44611566553) | 15 | 5 | 1 | 54 | 16 | |||
3318 | 185278 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2601 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984958.2606 | 2097437.8471 | 37.7382952768032 | -122.49454845339 | (37.7382952768032, -122.49454845339) | 1 | 8 | 3 | 29491 | 35 | |||
3330 | 213252 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 239 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5991927.67162 | 2090111.22138 | 37.7185836258199 | -122.4699185829 | (37.7185836258199, -122.4699185829) | 9 | 8 | 6 | 64 | 24 | |||
3339 | 19580 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY4 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 8 |
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) );