trees
8,758 rows where qSpecies_id = 16 sorted by Fire Prevention Districts descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts ▲ | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
173 | 27068 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 801 Silver Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4 | 6006971.0744 | 2093616.11167 | 37.7290654140285 | -122.418167915919 | (37.7290654140285, -122.418167915919) | 9 | 3 | 7 | 309 | 28 | |||
564 | 67334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 801 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1992 12:00:00 AM | 12 | Permit Number 30818 | 6008868.73151 | 2090340.18885 | 37.7201770527016 | -122.411376204361 | (37.7201770527016, -122.411376204361) | 9 | 3 | 7 | 309 | 28 | |
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 | |||
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 | |||
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 | |||
2095 | 210451 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 Ocean Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 4ft | Permit Number 779678 | 5998008.54618 | 2091535.2933 | 37.722843428355 | -122.449002108475 | (37.722843428355, -122.449002108475) | 9 | 7 | 4 | 28861 | 24 | ||
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 | |||
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 | ||
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 | |||
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 | |||
3082 | 67279 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 419 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1992 12:00:00 AM | 14 | Permit Number 30755 | 6004653.1094 | 2092898.46061 | 37.7269641597687 | -122.42613023813 | (37.7269641597687, -122.42613023813) | 9 | 7 | 6 | 28861 | 5 | |
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 | |||
3245 | 177750 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1830 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | Permit Number 784881 | 6001125.87502 | 2091373.61723 | 37.7225772947014 | -122.438214605635 | (37.7225772947014, -122.438214605635) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |||
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 | |||
3473 | 58897 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/29/1980 12:00:00 AM | 13 | Permit Number 18169 | 6009836.93544 | 2088163.79838 | 37.7142553893523 | -122.407876041144 | (37.7142553893523, -122.407876041144) | 9 | 7 | 8 | 309 | 39 | ||
3604 | 77660 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006693.80957 | 2093349.88561 | 37.7283188049508 | -122.419107568078 | (37.7283188049508, -122.419107568078) | 9 | 3 | 7 | 309 | 5 | ||
3734 | 67984 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 35 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31708 | 5996379.31437828 | 2088033.23094013 | 37.713134273022 | -122.454381139129 | (37.713134273022, -122.454381139129) | 9 | 8 | 6 | 28861 | 24 | ||
3999 | 213261 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 255 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992959.15066 | 2088902.16567 | 37.7153234215169 | -122.466265391939 | (37.7153234215169, -122.466265391939) | 9 | 8 | 6 | 64 | 24 | |||
4107 | 27215 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 430 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004120.16717 | 2093461.88579 | 37.7284810633405 | -122.428012742214 | (37.7284810633405, -122.428012742214) | 9 | 7 | 6 | 28861 | 5 | |||
4153 | 19360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 711 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992081.20032 | 2089838.16122 | 37.7178427427344 | -122.469368036824 | (37.7178427427344, -122.469368036824) | 9 | 8 | 6 | 64 | 24 | |||
4579 | 177618 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 278 Onondaga Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6000004.08234 | 2091569.41543 | 37.7230510458563 | -122.442106428983 | (37.7230510458563, -122.442106428983) | 9 | 7 | 6 | 28861 | 25 | |||
4584 | 177605 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 Ruth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001479.84547 | 2091684.05861 | 37.7234498223318 | -122.437013225577 | (37.7234498223318, -122.437013225577) | 9 | 7 | 6 | 28861 | 25 | |||
4585 | 210019 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 851 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5996737.87668 | 2098254.3429 | 37.7412195716338 | -122.453879510543 | (37.7412195716338, -122.453879510543) | 9 | 7 | 4 | 59 | 40 | |||
4867 | 76353 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006742.79477 | 2093189.9157 | 37.7278823207912 | -122.418926882581 | (37.7278823207912, -122.418926882581) | 9 | 3 | 7 | 309 | 5 | ||
5187 | 16150 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 395 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999449.98722 | 2094649.82142 | 37.7314775324521 | -122.444243069762 | (37.7314775324521, -122.444243069762) | 9 | 7 | 4 | 63 | 40 | |||
5233 | 65185 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 247 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 9 | Permit Number 27169 | 6003009.64323 | 2091977.07087 | 37.7243412033768 | -122.43174590807 | (37.7243412033768, -122.43174590807) | 9 | 7 | 6 | 28861 | 5 | |
5500 | 77664 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006642.94243 | 2093520.00504 | 37.728783051183 | -122.419295481395 | (37.728783051183, -122.419295481395) | 9 | 3 | 7 | 309 | 5 | ||
5596 | 177677 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 860 Mansell St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6009316.75189 | 2090057.74751 | 37.7194266458123 | -122.40980761495 | (37.7194266458123, -122.40980761495) | 9 | 3 | 7 | 309 | 28 | |||
5695 | 77663 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6006674.08558 | 2093407.54115 | 37.7284760037541 | -122.419179842976 | (37.7284760037541, -122.419179842976) | 9 | 3 | 7 | 309 | 5 | ||
5947 | 76372 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006736.19364 | 2093210.27498 | 37.7279378512454 | -122.418951146283 | (37.7279378512454, -122.418951146283) | 9 | 3 | 7 | 309 | 5 | ||
5991 | 217563 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5991900.5999 | 2088650.2079 | 37.714570473344 | -122.469905841257 | (37.714570473344, -122.469905841257) | 9 | 8 | 6 | 64 | 24 | |||
6015 | 16176 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 438 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999154.53701 | 2094721.74383 | 37.731658154085 | -122.445269662966 | (37.731658154085, -122.445269662966) | 9 | 7 | 4 | 59 | 40 | |||
6030 | 19323 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X5 | 5993467.32802 | 2089853.93143 | 37.7179660496774 | -122.4645779904 | (37.7179660496774, -122.4645779904) | 9 | 8 | 6 | 64 | 24 | |||
6638 | 77652 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006723.02825 | 2093252.77715 | 37.7280538116191 | -122.41899967279 | (37.7280538116191, -122.41899967279) | 9 | 3 | 7 | 309 | 5 | ||
6800 | 65190 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 263 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 14 | Permit Number 27174 | 6002953.3046 | 2091886.83764 | 37.7240902493544 | -122.431934222489 | (37.7240902493544, -122.431934222489) | 9 | 7 | 6 | 28861 | 5 | |
6975 | 213248 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2950 San Jose Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5996050.31606 | 2087518.48106 | 37.7117020161965 | -122.455481080804 | (37.7117020161965, -122.455481080804) | 9 | 8 | 6 | 28861 | 24 | |||
7360 | 91134 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400X Trumbull St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005738.144013 | 2094265.96683 | 37.730780298312 | -122.422476416564 | (37.730780298312, -122.422476416564) | 9 | 7 | 6 | 28861 | 5 | |||
7465 | 17540 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 512 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6002977.3728 | 2090782.38877 | 37.721059043035 | -122.431772202434 | (37.721059043035, -122.431772202434) | 9 | 7 | 6 | 28861 | 5 | |||
7600 | 12920 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2981X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 5996820.13855 | 2087345.5314 | 37.7112712800431 | -122.452807904632 | (37.7112712800431, -122.452807904632) | 9 | 7 | 6 | 28861 | 25 | |||
7982 | 65224 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 424 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 15 | Permit Number 28011 | 6002436.63551 | 2090340.67814 | 37.7198155369321 | -122.433609818641 | (37.7198155369321, -122.433609818641) | 9 | 7 | 6 | 28861 | 5 | |
7984 | 213195 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 66 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5995352.58216 | 2090355.50173 | 37.7194517449684 | -122.45809781389 | (37.7194517449684, -122.45809781389) | 9 | 8 | 6 | 28861 | 24 | |||
8472 | 65709 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 142 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | Permit Number 28638 | 6000250.18995538 | 2088032.18663542 | 37.7133526386349 | -122.44100204672 | (37.7133526386349, -122.44100204672) | 9 | 7 | 6 | 28861 | 5 | ||
8555 | 77658 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006705.39704 | 2093310.53877 | 37.7282114196192 | -122.419064719886 | (37.7282114196192, -122.419064719886) | 9 | 3 | 7 | 309 | 5 | ||
8797 | 213239 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 25 Majestic Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5997415.57746 | 2089795.63137 | 37.7180327919586 | -122.450926484985 | (37.7180327919586, -122.450926484985) | 9 | 8 | 6 | 28861 | 24 | |||
9261 | 61896 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 19 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/1985 12:00:00 AM | 11 | Permit Number 21939 | 6009273.47888 | 2094140.55724 | 37.7306347561928 | -122.410245303295 | (37.7306347561928, -122.410245303295) | 9 | 3 | 7 | 309 | 28 | ||
9364 | 27216 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 440 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004188.32264 | 2093464.07452 | 37.7284909288141 | -122.427777281084 | (37.7284909288141, -122.427777281084) | 9 | 7 | 6 | 28861 | 5 | |||
9393 | 210003 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 44 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993676.73838 | 2093064.62621 | 37.7267939100051 | -122.46408710354 | (37.7267939100051, -122.46408710354) | 9 | 8 | 4 | 59 | 40 | |||
9739 | 77653 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006717.25868 | 2093269.99639 | 37.7281007670162 | -122.41902083924 | (37.7281007670162, -122.41902083924) | 9 | 3 | 7 | 309 | 5 | ||
9763 | 111086 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 582X Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5996560.16999 | 2095740.09269 | 37.7343058616961 | -122.454312386561 | (37.7343058616961, -122.454312386561) | 9 | 7 | 4 | 59 | 40 | |||||
9881 | 213143 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 233 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5995623.80037 | 2091512.74066 | 37.7226448283785 | -122.457243989419 | (37.7226448283785, -122.457243989419) | 9 | 8 | 4 | 28861 | 24 | |||
9916 | 91389 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 165 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52087 | 5994308.9 | 2093484 | 37.7279818222938 | -122.461932151311 | (37.7279818222938, -122.461932151311) | 9 | 8 | 4 | 59 | 40 | |||
10476 | 70493 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 53 La Grande Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6005304.47442 | 2091965.67161 | 37.7244397195916 | -122.423812181596 | (37.7244397195916, -122.423812181596) | 9 | 7 | 6 | 309 | 5 | |||
10514 | 213161 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 131 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 4ft | 5995315.69861 | 2090785.50252 | 37.7206303056246 | -122.458256412019 | (37.7206303056246, -122.458256412019) | 9 | 8 | 6 | 28861 | 24 | |||
10582 | 213172 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 551 Junipero Serra Blvd | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5991456.92444 | 2093622.00243 | 37.7281961392214 | -122.471801470083 | (37.7281961392214, -122.471801470083) | 9 | 8 | 4 | 59 | 40 | |||
10731 | 16564 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2265X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999663.62849 | 2089384.1717 | 37.7170314576056 | -122.443126439495 | (37.7170314576056, -122.443126439495) | 9 | 7 | 6 | 28861 | 25 | |||
10943 | 210378 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 52 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5993374.1705 | 2093389.91722 | 37.7276696365248 | -122.465156680749 | (37.7276696365248, -122.465156680749) | 9 | 8 | 4 | 59 | 40 | |||
11101 | 210448 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5997106.39782 | 2094677.94067 | 37.7314207564505 | -122.452347291502 | (37.7314207564505, -122.452347291502) | 9 | 7 | 4 | 59 | 40 | |||
11238 | 1253 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3802X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2006 12:00:00 AM | 3 | 3X5 | 5992813.09767 | 2087592.82096 | 37.7117198470729 | -122.466675091581 | (37.7117198470729, -122.466675091581) | 9 | 8 | 4 | 64 | 24 | ||
11528 | 213133 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 530 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5997236.23471 | 2094134.25097 | 37.7299353516323 | -122.451859215049 | (37.7299353516323, -122.451859215049) | 9 | 7 | 4 | 28861 | 40 | ||||
11547 | 177767 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4271 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6003326 | 2093704 | 37.7291008919885 | -122.430775488572 | (37.7291008919885, -122.430775488572) | 9 | 7 | 6 | 28861 | 5 | |||
11650 | 213242 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 116 Majestic Ave | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5997026.98347 | 2089301.08259 | 37.7166526221889 | -122.452234013791 | (37.7166526221889, -122.452234013791) | 9 | 8 | 6 | 28861 | 24 | |||
11722 | 16206 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 512 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5998670.78741 | 2094729.8528 | 37.7316527941412 | -122.446942658283 | (37.7316527941412, -122.446942658283) | 9 | 7 | 4 | 59 | 40 | |||
12017 | 213228 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 Bright St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5993764.44098 | 2088418.41063 | 37.7140415764298 | -122.46344689056 | (37.7140415764298, -122.46344689056) | 9 | 8 | 6 | 64 | 24 | |||
12020 | 32737 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 223 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 5 | Permit Number 37120 | 5994748.23288 | 2088380.20466 | 37.7139933044225 | -122.460043789395 | (37.7139933044225, -122.460043789395) | 9 | 8 | 6 | 28861 | 24 | |
12185 | 30909 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 125 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 8 | Permit Number 34731 | 5994911.53291 | 2091873.96272 | 37.7235957238357 | -122.459732275923 | (37.7235957238357, -122.459732275923) | 9 | 8 | 4 | 28861 | 24 | |
12437 | 1235 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3645 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5993271.90922 | 2087553.28553 | 37.7116377596374 | -122.465086457186 | (37.7116377596374, -122.465086457186) | 9 | 8 | 4 | 64 | 24 | |||
12474 | 51019 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 251 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | Permit Number 47497 | 5992948.45681034 | 2088862.24435583 | 37.7152131901669 | -122.466299454682 | (37.7152131901669, -122.466299454682) | 9 | 8 | 6 | 64 | 24 | |||
12722 | 4851 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1499X ALEMANY BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X6 | 6002180 | 2093376 | 37.7281352832027 | -122.43471385212 | (37.7281352832027, -122.43471385212) | 9 | 7 | 6 | 28861 | 25 | |||
13020 | 25365 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 996 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6000644.8782 | 2088863.97387 | 37.7156590125416 | -122.439697466259 | (37.7156590125416, -122.439697466259) | 9 | 7 | 6 | 28861 | 5 | |||
13752 | 38739 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
13778 | 77659 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6006700.09662 | 2093328.78928 | 37.7282612330662 | -122.419084337666 | (37.7282612330662, -122.419084337666) | 9 | 3 | 7 | 309 | 5 | ||
14388 | 210045 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Monterey Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5999952.2642 | 2094712.52265 | 37.7316783384633 | -122.442511107728 | (37.7316783384633, -122.442511107728) | 9 | 7 | 4 | 63 | 40 | |||
14433 | 76390 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006730.14725 | 2093235.82763 | 37.7280076727975 | -122.418973860459 | (37.7280076727975, -122.418973860459) | 9 | 3 | 7 | 309 | 5 | ||
14439 | 104509 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80 DICHIERA CT | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5998620 | 2088043 | 37.7132893442667 | -122.446637305723 | (37.7132893442667, -122.446637305723) | 9 | 7 | 6 | 28861 | 25 | |||||
15122 | 78380 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1027 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6x4 | 6003865.37713 | 2089493.15016 | 37.7175693740048 | -122.428610778768 | (37.7175693740048, -122.428610778768) | 9 | 7 | 6 | 28861 | 5 | ||
15300 | 177686 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1669 Geneva Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 8ft | 6003304.44382 | 2087685.74457 | 37.7125748721142 | -122.430420783092 | (37.7125748721142, -122.430420783092) | 9 | 7 | 6 | 28861 | 5 | |||
15314 | 16219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 550 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5998423.31695 | 2094734.1662 | 37.7316504963562 | -122.447798519712 | (37.7316504963562, -122.447798519712) | 9 | 7 | 4 | 59 | 40 | |||
16061 | 69750 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 805 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6008877.58173 | 2090316.9331 | 37.7201136936615 | -122.411343969962 | (37.7201136936615, -122.411343969962) | 9 | 3 | 7 | 309 | 28 | |||
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 | |||
17259 | 77657 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006712.15653 | 2093290.62233 | 37.7281571140509 | -122.41903993995 | (37.7281571140509, -122.41903993995) | 9 | 3 | 7 | 309 | 5 | ||
17661 | 16049 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 209X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1993 12:00:00 AM | 6 | 3X3 | 6000683.55426 | 2094621.79166 | 37.7314708693667 | -122.439976394621 | (37.7314708693667, -122.439976394621) | 9 | 7 | 4 | 63 | 40 | ||
17697 | 210454 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 Ocean Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 4ft | 5998090.15261 | 2091532.80921 | 37.7228412744865 | -122.448719834659 | (37.7228412744865, -122.448719834659) | 9 | 7 | 4 | 28861 | 24 | |||
18051 | 77661 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6006687.82384 | 2093371.12447 | 37.7283767851556 | -122.419129766951 | (37.7283767851556, -122.419129766951) | 9 | 3 | 7 | 309 | 5 | ||
18128 | 213232 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Geneva Ave | 1 | : | Tree | Private 2 | 15 | Width 0ft | 5997159.34871 | 2091557.33009 | 37.7228553326789 | -122.451939179162 | (37.7228553326789, -122.451939179162) | 9 | 8 | 4 | 28861 | 24 | |||
18388 | 217560 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5991890.4732 | 2088641.6156 | 37.7145462955922 | -122.469940217678 | (37.7145462955922, -122.469940217678) | 9 | 8 | 6 | 64 | 24 | |||
18949 | 65737 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 47 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 10 | Permit Number 33496 | 6000834.88494 | 2087430.71452 | 37.7117344151764 | -122.438938064335 | (37.7117344151764, -122.438938064335) | 9 | 7 | 6 | 28861 | 5 | |
19184 | 213175 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 800 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5994399.61547 | 2090601.97319 | 37.7200736945134 | -122.461409703103 | (37.7200736945134, -122.461409703103) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
19855 | 44060 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 261 Santos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | 8 | Permit Number 43587 | 6006383.26807 | 2086331.02129 | 37.7090290107549 | -122.419683323929 | (37.7090290107549, -122.419683323929) | 9 | 7 | 8 | 309 | 39 | ||
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 | ||
20520 | 66318 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 158 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1994 12:00:00 AM | Permit Number 29435 | 6001030.24418552 | 2094968.77102458 | 37.7324433243511 | -122.438802679239 | (37.7324433243511, -122.438802679239) | 9 | 7 | 5 | 63 | 40 | ||
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 | |||
20674 | 217568 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5991802.0948 | 2088763.4428 | 37.7148756943238 | -122.470254552609 | (37.7148756943238, -122.470254552609) | 9 | 8 | 6 | 64 | 24 | |||
20805 | 213208 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 265 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5994420.92342 | 2089007.37217 | 37.715696526836 | -122.461220520805 | (37.715696526836, -122.461220520805) | 9 | 8 | 6 | 28861 | 24 | |||
21006 | 31183 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 627 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34881 | 5992393.27316776 | 2089825.88959744 | 37.7178270773306 | -122.468288456554 | (37.7178270773306, -122.468288456554) | 9 | 8 | 6 | 64 | 24 | ||
21093 | 11635 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
21271 | 210053 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 210 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5999382.95261 | 2094096.3165 | 37.7299539127436 | -122.444435056156 | (37.7299539127436, -122.444435056156) | 9 | 7 | 4 | 28861 | 40 | |||
21382 | 213233 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Geneva Ave | 2 | : | Tree | Private 2 | 13 | Width 0ft | 5997185.51842 | 2091545.75493 | 37.7228250489166 | -122.451847881795 | (37.7228250489166, -122.451847881795) | 9 | 8 | 4 | 28861 | 24 |
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) );