trees
8,758 rows where qSpecies_id = 16
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
4927 | 60400 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1515 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | Permit Number 19981 | 6015674.9738 | 2094268.7486 | 37.731343497592 | -122.388123111176 | (37.731343497592, -122.388123111176) | 10 | 3 | 8 | 58 | 1 | |
4942 | 60050 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1446 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 14 | Permit Number 19548 | 5988385.7954 | 2105465.1018 | 37.7605359907495 | -122.483286128086 | (37.7605359907495, -122.483286128086) | 1 | 8 | 3 | 56 | 35 | |
4967 | 61581 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 640 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 16 | Permit Number 21544 | 6012673.53684 | 2104479.8966 | 37.7592143816602 | -122.399216218276 | (37.7592143816602, -122.399216218276) | 10 | 3 | 8 | 28856 | 29 | |
5039 | 43055 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2183 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 7 | Permit Number 42905 | 5981687.8424 | 2100251.3939 | 37.7458285438516 | -122.506064306101 | (37.7458285438516, -122.506064306101) | 1 | 8 | 3 | 29491 | 35 | |
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 | |||
5155 | 60379 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1294 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 13 | Permit Number 19959 | 6016555.73606 | 2094038.62564 | 37.7307603851837 | -122.385062097043 | (37.7307603851837, -122.385062097043) | 10 | 3 | 8 | 58 | 1 | |
5171 | 108539 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401-423X Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011972.2839 | 2086844.73133 | 37.710752810564 | -122.400402802668 | (37.710752810564, -122.400402802668) | 10 | 3 | 8 | 309 | 1 |
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 | |||||||||||||
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 | |
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 | |||||||||||||
5326 | 59848 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1263 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 15 | Permit Number 19303 | 6016663.4515 | 2093881.8215 | 37.7303357898053 | -122.384678785547 | (37.7303357898053, -122.384678785547) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
5362 | 109193 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4124 Moraga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773525 | ||||||||||
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 | |||
5436 | 59846 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1243 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 13 | Permit Number 19301 | 6016762.3817 | 2093805.9751 | 37.7301330013468 | -122.384331486532 | (37.7301330013468, -122.384331486532) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
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 | ||
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 | |||
5610 | 46958 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 7 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
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 | |||
5681 | 60249 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1254 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 13 | Permit Number 19801 | 5988030.9455 | 2106760.2014 | 37.7640713227243 | -122.484608376536 | (37.7640713227243, -122.484608376536) | 1 | 8 | 3 | 56 | 35 | |
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 | ||
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 | ||||
5819 | 37136 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4641 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 7 | 3x3 | Permit Number 39718 | 5981284.3022 | 2106878.7818 | 37.7640017042438 | -122.507951428358 | (37.7640017042438, -122.507951428358) | 1 | 8 | 3 | 56 | 35 |
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 | |||
5889 | 37810 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1746 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44738 | 5981328.72954544 | 2103184.35370388 | 37.7538604793554 | -122.507523629232 | (37.7538604793554, -122.507523629232) | 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 | |||
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 | ||
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 | ||
6017 | 68305 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2146 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 7 | Permit Number 32116 | 5981725.4073 | 2100475.4291 | 37.7464458932007 | -122.505951021438 | (37.7464458932007, -122.505951021438) | 1 | 8 | 3 | 29491 | 35 | |
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 | |||
6164 | 68307 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2167 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32118 | 5981682.0022594 | 2100343.28066189 | 37.7460804954734 | -122.506091311951 | (37.7460804954734, -122.506091311951) | 1 | 8 | 3 | 29491 | 35 | ||
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 | |||
6202 | 35215 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 14 Shore View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1998 12:00:00 AM | 8 | Permit Number 38719 | 5984575.36767 | 2112876.98496 | 37.7806644184241 | -122.497011539732 | (37.7806644184241, -122.497011539732) | 11 | 6 | 2 | 55 | 26 | |
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 | |||
6483 | 60247 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1234 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 14 | Permit Number 19799 | 5988027.8819 | 2106876.6178 | 37.7643907918226 | -122.484627512544 | (37.7643907918226, -122.484627512544) | 1 | 8 | 3 | 56 | 35 | |
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 | |||
6516 | 78525 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3550 Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981839.963 | 2099470.1472 | 37.7436924112004 | -122.505480405304 | (37.7436924112004, -122.505480405304) | 1 | 8 | 3 | 29491 | 35 | |||
6563 | 71813 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3353 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5998192.69497 | 2116144.55888 | 37.7904248748608 | -122.450138476504 | (37.7904248748608, -122.450138476504) | 13 | 6 | 1 | 54 | 31 | |||
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 | |||
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 | ||
6685 | 68314 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3815 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 7 | Permit Number 32127 | 5981596.2993 | 2100763.5953 | 37.7472295165668 | -122.506418820774 | (37.7472295165668, -122.506418820774) | 1 | 8 | 3 | 29491 | 35 | |
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 | |||
6763 | 78304 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4355 Anza St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5985168.78138 | 2111757.58069 | 37.7776256124831 | -122.494876107778 | (37.7776256124831, -122.494876107778) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||||
6780 | 31935 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1330 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 6 | Permit Number 35351 | 5981536.6923 | 2106016.9784 | 37.7616503077312 | -122.507014568071 | (37.7616503077312, -122.507014568071) | 1 | 8 | 3 | 56 | 35 | |
6784 | 60048 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1463 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 14 | Permit Number 19546 | 5988345.982 | 2105367.5756 | 37.7602658931923 | -122.483416673161 | (37.7602658931923, -122.483416673161) | 1 | 8 | 3 | 56 | 35 | |
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 | |
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 | |||
6976 | 59854 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1182 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 18 | Permit Number 19310 | 6017139.45768 | 2093603.92018 | 37.7295990411395 | -122.38301381645 | (37.7295990411395, -122.38301381645) | 10 | 3 | 8 | 58 | 1 | |
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 | |||||||||||||
7005 | 60053 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1406 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 24 | 3x3 | Permit Number 19552 | 5988377.0869 | 2105705.2719 | 37.7611949257495 | -122.483333852456 | (37.7611949257495, -122.483333852456) | 1 | 8 | 3 | 56 | 35 |
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 | |||
7106 | 72209 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 315 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/16/2019 12:00:00 AM | 3 | 6011420.02502 | 2119355.99811 | 37.7999907575129 | -122.404598698471 | (37.7999907575129, -122.404598698471) | 3 | 1 | 10 | 308 | 23 | ||
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 |
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) );