trees
8,758 rows where qSpecies_id = 16 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3825 | 263630 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1020 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000550 | 2112598 | 37.7808215534457 | -122.441727743189 | (37.7808215534457, -122.441727743189) | 15 | 5 | 1 | 29490 | 16 | ||||
3913 | 35208 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
3921 | 12687 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1330 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 5991313.40727 | 2114800.59643 | 37.7863386650766 | -122.473842035632 | (37.7863386650766, -122.473842035632) | 11 | 6 | 1 | 54 | 33 | |||
3924 | 117653 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5001 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2020 12:00:00 AM | 3 | Width 3ft | 5983129.01167 | 2111683.19763 | 37.7773017651933 | -122.501926740971 | (37.7773017651933, -122.501926740971) | 11 | 6 | 2 | 55 | 26 | ||
3997 | 20436 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15 | |||||||||||||
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 | |||
4017 | 250443 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 120 Seacliff Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5987542.94428 | 2115793.76045 | 37.7888465026131 | -122.486959668166 | (37.7888465026131, -122.486959668166) | 11 | 6 | 1 | 55 | 33 | |||
4035 | 90978 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3051 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/13/2008 12:00:00 AM | 3 | 3x3 | 5986104.90225 | 2111110.08173 | 37.7759025178632 | -122.491590119843 | (37.7759025178632, -122.491590119843) | 11 | 6 | 2 | 55 | 26 | ||
4091 | 210316 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995716.2843 | 2106399.35256 | 37.7635250903217 | -122.458001093579 | (37.7635250903217, -122.458001093579) | 15 | 5 | 11 | 56 | 12 | |||
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 | |||
4111 | 131305 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 6ft | 5997155.69751 | 2115003.89282 | 37.7872335145555 | -122.453644000576 | (37.7872335145555, -122.453644000576) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||
4160 | 194003 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1353 Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6016963.78411 | 2096284.21898 | 37.7369489007781 | -122.38380769119 | (37.7369489007781, -122.38380769119) | 10 | 3 | 8 | 58 | 1 | |||
4197 | 262260 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
4256 | 232803 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 12 Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002731.51343 | 2106822.30283 | 37.765086973515 | -122.433767904182 | (37.765086973515, -122.433767904182) | 15 | 5 | 5 | 28862 | 3 | |||
4295 | 20447 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
4298 | 262513 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
4318 | 232497 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 807 Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001287.12628 | 2101684.8467 | 37.7508987005301 | -122.438395575313 | (37.7508987005301, -122.438395575313) | 2 | 4 | 5 | 28862 | 22 | |||
4401 | 258690 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100x Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
4531 | 20442 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
4547 | 9087 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5655 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5989409.7723 | 2112590.066 | 37.7801587272022 | -122.48026619876 | (37.7801587272022, -122.48026619876) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
4587 | 35197 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
4680 | 200788 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6015393 | 2095982 | 37.7360321129218 | -122.389217541455 | (37.7360321129218, -122.389217541455) | 10 | 3 | 8 | 58 | 1 | |||
4893 | 131541 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1234 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008553.82207 | 2116816.41978 | 37.7928570994281 | -122.414337095377 | (37.7928570994281, -122.414337095377) | 5 | 1 | 10 | 28857 | 21 | |||
4914 | 245440 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2940 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6007168.2123 | 2106770.9942 | 37.7651968502685 | -122.418418777324 | (37.7651968502685, -122.418418777324) | 8 | 4 | 7 | 28853 | 19 | |||
5054 | 102983 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
5115 | 260959 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Cherry St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 9ft | 5996243 | 2114742 | 37.7864620624436 | -122.456782770891 | (37.7864620624436, -122.456782770891) | 11 | 6 | 1 | 54 | 31 | ||||
5150 | 177697 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6010372.60751 | 2090257.89401 | 37.7200353222515 | -122.406171987774 | (37.7200353222515, -122.406171987774) | 10 | 7 | 8 | 309 | 28 | |||
5187 | 16150 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 395 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999449.98722 | 2094649.82142 | 37.7314775324521 | -122.444243069762 | (37.7314775324521, -122.444243069762) | 9 | 7 | 4 | 63 | 40 | |||
5218 | 19581 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY4 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 8 | |||||||||||||
5272 | 20437 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15 | |||||||||||||
5338 | 121017 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x4 | 6012098.89577 | 2117793.01824 | 37.7957371081465 | -122.402139588686 | (37.7957371081465, -122.402139588686) | 3 | 1 | 10 | 28860 | 4 | |||
5354 | 8706 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3100 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5997482.4956 | 2113078.7647 | 37.7819663504933 | -122.452374383353 | (37.7819663504933, -122.452374383353) | 15 | 6 | 1 | 54 | 31 | |||
5381 | 131608 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2318 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008064.43802 | 2120372.10874 | 37.8025926337993 | -122.416282346076 | (37.8025926337993, -122.416282346076) | 5 | 1 | 10 | 308 | 32 | |||
5496 | 131655 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 967 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6010169.62149 | 2116837.55427 | 37.7930057627679 | -122.408747818762 | (37.7930057627679, -122.408747818762) | 3 | 1 | 10 | 28857 | 4 | |||
5507 | 122105 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 315 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 6ft | 5990861.85286 | 2113260.77662 | 37.7820845839552 | -122.475291822165 | (37.7820845839552, -122.475291822165) | 11 | 6 | 2 | 54 | 26 | |||
5512 | 259281 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 4 | 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 | ||||
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 | |||
5611 | 139705 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301 Saint Joseph's Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000476.8247 | 2113129.5897 | 37.7822769928429 | -122.442019059209 | (37.7822769928429, -122.442019059209) | 15 | 5 | 1 | 29490 | 16 | |||
5620 | 250454 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Seacliff Ave | 1 | : | Tree | Private 2 | 9 | Width 4ft | 5987161.73503 | 2115752.97281 | 37.7887122778945 | -122.488275583153 | (37.7887122778945, -122.488275583153) | 11 | 6 | 1 | 55 | 33 | |||
5665 | 185384 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2300 Sunset Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985061.3096 | 2099023.7095 | 37.7426556588679 | -122.494309028051 | (37.7426556588679, -122.494309028051) | 1 | 8 | 3 | 29491 | 35 | |||
5672 | 250483 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 475 Seacliff Ave | 6 | : | Tree | Private 2 | 7 | Width 2ft | 5986409.29286 | 2115158.05614 | 37.7870348804072 | -122.490835095073 | (37.7870348804072, -122.490835095073) | 11 | 6 | 1 | 55 | 33 | |||
5704 | 247050 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 523 Valley St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6002490.03893 | 2099140.16558 | 37.7439799534136 | -122.434053911082 | (37.7439799534136, -122.434053911082) | 2 | 7 | 5 | 63 | 22 | |||
5708 | 120015 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 351 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5986818.7431 | 2113586.36762 | 37.7827433860635 | -122.48930290495 | (37.7827433860635, -122.48930290495) | 11 | 6 | 2 | 55 | 26 | |||
5730 | 144279 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 690 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5981990.61575 | 2111117.56689 | 37.7756817696347 | -122.505822808694 | (37.7756817696347, -122.505822808694) | 11 | 6 | 2 | 55 | 26 | ||
5745 | 193934 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | Width 3ft | 6016623.26344 | 2095403.70542 | 37.7345123576517 | -122.384923708478 | (37.7345123576517, -122.384923708478) | 10 | 3 | 8 | 58 | 1 | |||
5751 | 209873 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 449 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995567.09272 | 2106280.19552 | 37.7631893428269 | -122.458508470412 | (37.7631893428269, -122.458508470412) | 15 | 5 | 4 | 63 | 12 | |||
5810 | 111954 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 73 SEACLIFF AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5987709 | 2115789 | 37.7888431121968 | -122.486384796167 | (37.7888431121968, -122.486384796167) | 11 | 6 | 1 | 55 | 33 | ||||
5831 | 11910 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | |||
5849 | 79288 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3701 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 5 | 3x3 | Permit Number 50039 | 5984227.9242 | 2106296.9995 | 37.7625772948491 | -122.49772750788 | (37.7625772948491, -122.49772750788) | 1 | 8 | 3 | 56 | 35 | |
5850 | 20445 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
5872 | 184336 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Sunset Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 5984831.242 | 2105456.766 | 37.7603055972166 | -122.495578904812 | (37.7603055972166, -122.495578904812) | 1 | 8 | 3 | 56 | 35 | |||
5931 | 7196 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 949 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003418.39077 | 2111568.89089 | 37.7781588927529 | -122.431731089816 | (37.7781588927529, -122.431731089816) | 15 | 9 | 11 | 29492 | 41 | |||
5948 | 107882 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1x Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014791.78085 | 2116908.84659 | 37.7934593169345 | -122.392759756859 | (37.7934593169345, -122.392759756859) | 12 | 2 | 9 | 28855 | 6 | |||
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 | |||
6011 | 186520 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501 Sunset Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 0ft | 5984772.6613 | 2104877.4166 | 37.7587114348302 | -122.495738769506 | (37.7587114348302, -122.495738769506) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
6016 | 96544 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100@ Front St Pine St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 08/29/2019 12:00:00 AM | 3 | Permit Number 784583 | 6013029.74558 | 2116576.80835 | 37.7924495959214 | -122.398833259061 | (37.7924495959214, -122.398833259061) | 4 | 1 | 10 | 28860 | 6 | ||
6030 | 19323 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X5 | 5993467.32802 | 2089853.93143 | 37.7179660496774 | -122.4645779904 | (37.7179660496774, -122.4645779904) | 9 | 8 | 6 | 64 | 24 | |||
6114 | 140733 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2015 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6001710.23 | 2113212.2721 | 37.7825742274801 | -122.437757957488 | (37.7825742274801, -122.437757957488) | 15 | 5 | 11 | 29490 | 41 | |||
6200 | 193907 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 Berry St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6014756.18185 | 2110696.70352 | 37.77640021373 | -122.39244821553 | (37.77640021373, -122.39244821553) | 6 | 2 | 9 | 28856 | 20 | |||
6224 | 200787 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6015393 | 2095982 | 37.7360321129218 | -122.389217541455 | (37.7360321129218, -122.389217541455) | 10 | 3 | 8 | 58 | 1 | |||
6251 | 60411 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1548 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1982 12:00:00 AM | 11 | Permit Number 19992 | 6015521.632 | 2094461.6625 | 37.73186470328 | -122.388666708344 | (37.73186470328, -122.388666708344) | 10 | 3 | 8 | 58 | 1 | ||
6271 | 15012 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1492X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016294.2605501 | 2097022.8093396 | 37.7389398874772 | -122.386174028839 | (37.7389398874772, -122.386174028839) | 10 | 3 | 8 | 58 | 1 | |||
6302 | 38481 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1116 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1998 12:00:00 AM | Permit Number 40480 | 6017830.40993478 | 2092735.6877236 | 37.727253198437 | -122.380564773574 | (37.727253198437, -122.380564773574) | 10 | 3 | 8 | 58 | 1 | |||
6328 | 209930 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2445 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992320.715 | 2098815.39655 | 37.742505836878 | -122.469193170828 | (37.742505836878, -122.469193170828) | 1 | 8 | 4 | 29491 | 40 | |||
6346 | 232604 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 509 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1989 12:00:00 AM | 14 | Width 3ft | Permit Number 28219 | 6003467.96193 | 2095980.6299 | 37.7353600451305 | -122.430447088284 | (37.7353600451305, -122.430447088284) | 2 | 7 | 5 | 63 | 7 | |
6363 | 12160 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400X La Salle Ave | 41 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6016105.23501 | 2095780.81201 | 37.7355191499757 | -122.386741010111 | (37.7355191499757, -122.386741010111) | 10 | 3 | 8 | 58 | 1 | |||
6368 | 142137 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3059 GEARY BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997680.98 | 2113001.7737 | 37.7817663225775 | -122.451682166477 | (37.7817663225775, -122.451682166477) | 15 | 6 | 2 | 54 | 16 | |||
6461 | 122303 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1401 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5991231.78342 | 2111293.0958 | 37.7767033085253 | -122.473868446087 | (37.7767033085253, -122.473868446087) | 11 | 6 | 2 | 54 | 26 | |||
6500 | 209978 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86 Merced Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5994900.84941 | 2099819.61861 | 37.7454119322075 | -122.460344637816 | (37.7454119322075, -122.460344637816) | 1 | 8 | 4 | 59 | 40 | |||
6571 | 94972 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 230 Seacliff Ave | 4 | Sidewalk: Curb side : | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | 11 | 6 | 1 | 55 | 33 | |||
6596 | 20449 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
6635 | 8146 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1000 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 4X4 | 6002926.0085 | 2111351.5233 | 37.7775341328911 | -122.433418880148 | (37.7775341328911, -122.433418880148) | 15 | 5 | 11 | 29492 | 41 | |||
6725 | 209934 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2497 Funston Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992330.36628 | 2098511.09323 | 37.7416708550141 | -122.469137657486 | (37.7416708550141, -122.469137657486) | 1 | 8 | 4 | 29491 | 40 | |||
6756 | 247422 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1017 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002479.5264 | 2110196.8042 | 37.7743382213836 | -122.434880809366 | (37.7743382213836, -122.434880809366) | 15 | 5 | 11 | 29492 | 10 | |||
6775 | 256471 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 15 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
6824 | 185239 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2519 44th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5982695.2777 | 2097952.3458 | 37.7395752424776 | -122.502410672836 | (37.7395752424776, -122.502410672836) | 1 | 8 | 3 | 29491 | 35 | |||
6828 | 131262 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2711 Union St | 2 | Front Yard : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 785082 | 6000010.78683 | 2118118.88771 | 37.7959497330364 | -122.443989935801 | (37.7959497330364, -122.443989935801) | 13 | 9 | 1 | 57 | 17 | ||
6869 | 51982 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2005 12:00:00 AM | Permit Number 48204 | 6007266.85815782 | 2113345.5415055 | 37.7832545419232 | -122.4185438282 | (37.7832545419232, -122.4185438282) | 7 | 9 | 9 | 28858 | 36 | |||
6885 | 259563 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Public Park | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994204 | 2098512 | 37.741781429361 | -122.462659374294 | (37.741781429361, -122.462659374294) | 1 | 8 | 4 | 59 | 40 | ||||
6886 | 118696 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4501 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5981579.7989 | 2110947.48462 | 37.7751905852 | -122.507231280143 | (37.7751905852, -122.507231280143) | 11 | 6 | 2 | 55 | 26 | |||
6911 | 20443 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
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 | |||
6998 | 20438 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
7034 | 184301 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1546 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5981896.8997 | 2104553.6198 | 37.7576535496395 | -122.505660295506 | (37.7576535496395, -122.505660295506) | 1 | 8 | 3 | 56 | 35 | |||
7156 | 10925 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1345X Hudson Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017013.5679363 | 2096006.7331036 | 37.7361897319358 | -122.383616251853 | (37.7361897319358, -122.383616251853) | 10 | 3 | 8 | 58 | 1 | |||
7191 | 22827 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 85 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 2x3 | 5999327.12721 | 2099090.71546 | 37.743664163661 | -122.444986946691 | (37.743664163661, -122.444986946691) | 2 | 7 | 5 | 63 | 22 | |||
7205 | 200834 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010496.9305 | 2106954.5492 | 37.7658876747805 | -122.406918423333 | (37.7658876747805, -122.406918423333) | 8 | 4 | 8 | 28853 | 19 | |||
7252 | 5072 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5575 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/1992 12:00:00 AM | 12 | 3X3 | 6001640.06502 | 2097135.58577 | 37.7384275714691 | -122.436849449162 | (37.7384275714691, -122.436849449162) | 2 | 7 | 5 | 63 | 7 | ||
7313 | 33583 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37691 | 6007181.85623533 | 2098126.23586774 | 37.7414610860553 | -122.417758780801 | (37.7414610860553, -122.417758780801) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
7384 | 131525 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1083 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009580.99158 | 2117083.07964 | 37.7936469290112 | -122.41080186673 | (37.7936469290112, -122.41080186673) | 3 | 1 | 10 | 28857 | 21 | |||
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 | |||
7474 | 35177 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
7518 | 20555 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1305X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10 | 5984811.9199471 | 2106303.0061321 | 37.7626280043626 | -122.495708151398 | (37.7626280043626, -122.495708151398) | 1 | 8 | 3 | 56 | 35 | |||
7600 | 12920 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2981X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 5996820.13855 | 2087345.5314 | 37.7112712800431 | -122.452807904632 | (37.7112712800431, -122.452807904632) | 9 | 7 | 6 | 28861 | 25 |
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) );