trees
8,758 rows where qSpecies_id = 16 sorted by PermitNotes
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3371 | 9374 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/1994 12:00:00 AM | 30 | 2X2 | 6001106.82258 | 2097916.97358 | 37.7405427580332 | -122.438749114996 | (37.7405427580332, -122.438749114996) | 2 | 7 | 5 | 63 | 7 | ||
3401 | 21158 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2300X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984964.3463827 | 2099540.4551822 | 37.7440688278009 | -122.494682382207 | (37.7440688278009, -122.494682382207) | 1 | 8 | 3 | 29491 | 35 | |||
3424 | 116715 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2817 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999908.2786 | 2114349.9787 | 37.7855954495545 | -122.444073686604 | (37.7855954495545, -122.444073686604) | 15 | 6 | 1 | 29490 | 31 | |||
3458 | 260537 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1238 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5982443.47735 | 2106679.23386 | 37.7635220339644 | -122.503927471267 | (37.7635220339644, -122.503927471267) | 1 | 8 | 3 | 56 | 35 | ||
3496 | 98500 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1670 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990941.3 | 2104038.3 | 37.7567667631156 | -122.474343775715 | (37.7567667631156, -122.474343775715) | 1 | 8 | 4 | 56 | 12 | ||||
3548 | 296 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3451X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X3 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | 1 | 8 | 4 | 64 | 14 | |||
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 | ||
3634 | 20382 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
3650 | 72105 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3024 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5997692.6555 | 2113106.1769 | 37.7820536550082 | -122.451649308253 | (37.7820536550082, -122.451649308253) | 15 | 6 | 1 | 54 | 31 | |||
3658 | 140493 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1340 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6003595.4388 | 2112480.2415 | 37.7806712690813 | -122.431183683552 | (37.7806712690813, -122.431183683552) | 15 | 9 | 11 | 29490 | 41 | |||
3694 | 231406 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301x Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008008.21538 | 2098169.17057 | 37.7416254437701 | -122.414904545115 | (37.7416254437701, -122.414904545115) | 2 | 7 | 7 | 28859 | 2 | |||
3752 | 209923 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 700 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991036.77148 | 2099253.35889 | 37.7436340939434 | -122.473664564077 | (37.7436340939434, -122.473664564077) | 1 | 8 | 4 | 29491 | 40 | |||
3801 | 183067 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2642 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | SFUSD | 8 | Width 0ft | 5983405.3697 | 2096822.8928 | 37.736515769554 | -122.499872058038 | (37.736515769554, -122.499872058038) | 1 | 8 | 3 | 29491 | 35 | ||
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 | ||||
3859 | 75387 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Vega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5999425.0368 | 2112388.5534 | 37.7801823052034 | -122.445604458946 | (37.7801823052034, -122.445604458946) | 15 | 5 | 1 | 54 | 16 | |||
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 | ||||
4211 | 69761 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3621 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5981890.0592 | 2100093.2822 | 37.7454063146777 | -122.50535336411 | (37.7454063146777, -122.50535336411) | 1 | 8 | 3 | 29491 | 35 | |||
4225 | 78616 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 240 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010824.43374 | 2092444.67892 | 37.7260650445568 | -122.404764042448 | (37.7260650445568, -122.404764042448) | 10 | 3 | 7 | 309 | 28 | |||
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 | |||
4629 | 79880 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1874 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5981353.9893 | 2102319.4895 | 37.7514872949963 | -122.507372114024 | (37.7514872949963, -122.507372114024) | 1 | 8 | 3 | 56 | 35 | |||
4631 | 71412 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1347 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6016206.5271 | 2094219.1986 | 37.731236879718 | -122.38628196304 | (37.731236879718, -122.38628196304) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
4774 | 81182 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2119 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5982918.3441 | 2100688.6349 | 37.7471014440375 | -122.501841820419 | (37.7471014440375, -122.501841820419) | 1 | 8 | 3 | 29491 | 35 | |||
4790 | 102992 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 5 | 3x3 | 5993571.87038 | 2110700.08123 | 37.7752103110101 | -122.465730364497 | (37.7752103110101, -122.465730364497) | 11 | 6 | 2 | 54 | 11 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 |
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) );