trees
8,758 rows where qSpecies_id = 16 sorted by rowid descending
This data as json, CSV (advanced)
| rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194502 | 265146 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3512 23rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006075 | 2102620 | 37.753737588166 | -122.421905052211 | (37.753737588166, -122.421905052211) | 2 | 4 | 5 | 28859 | 19 | |||||
| 194282 | 177746 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Permit Number 785586 | 6001053.43812 | 2091726.98644 | 37.7235434462625 | -122.438490308995 | (37.7235434462625, -122.438490308995) | 9 | 7 | 6 | 28861 | 25 | |||
| 194278 | 177749 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Permit Number 785586 | 6001147.04243 | 2091731.7631 | 37.7235618859526 | -122.438167078262 | (37.7235618859526, -122.438167078262) | 9 | 7 | 6 | 28861 | 25 | |||
| 194275 | 177745 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Permit Number 785586 | 6001030.42901 | 2091724.92182 | 37.723536468427 | -122.438569699355 | (37.723536468427, -122.438569699355) | 9 | 7 | 6 | 28861 | 25 | |||
| 194264 | 177747 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Permit Number 785586 | 6001098.32148 | 2091729.1423 | 37.7235519187703 | -122.438335309921 | (37.7235519187703, -122.438335309921) | 9 | 7 | 6 | 28861 | 25 | |||
| 194260 | 177748 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Permit Number 785586 | 6001125.53976 | 2091732.02705 | 37.7235613877398 | -122.438241427924 | (37.7235613877398, -122.438241427924) | 9 | 7 | 6 | 28861 | 25 | |||
| 194256 | 177744 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Permit Number 785586 | 6001008.85116 | 2091721.5574 | 37.7235260030036 | -122.438644049011 | (37.7235260030036, -122.438644049011) | 9 | 7 | 6 | 28861 | 25 | |||
| 194251 | 213250 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 28 Monticello St | 2 | : | Tree | Private 2 | 17 | Width 3ft | 5991690.07083 | 2089001.80263 | 37.7155236951408 | -122.470659101751 | (37.7155236951408, -122.470659101751) | 9 | 8 | 6 | 64 | 24 | |||
| 194248 | 1915 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 9 Bell Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016631.8921901 | 2095265.2766477 | 37.7341327371653 | -122.384884235042 | (37.7341327371653, -122.384884235042) | 10 | 3 | 8 | 58 | 1 | |||
| 194246 | 38488 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 999 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2003 12:00:00 AM | 12 | Permit Number 47240 | 6008353.25415 | 2118952.75652 | 37.7987116832495 | -122.415182364581 | (37.7987116832495, -122.415182364581) | 5 | 1 | 10 | 308 | 21 | |
| 194219 | 56516 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992016.71366179 | 2099080.57669874 | 37.7432163828282 | -122.470263614355 | (37.7432163828282, -122.470263614355) | 1 | 8 | 4 | 29491 | 40 | ||||
| 194183 | 16195 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 482 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5998892.4801472 | 2094730.9663599 | 37.7316685147685 | -122.446176305405 | (37.7316685147685, -122.446176305405) | 9 | 7 | 4 | 59 | 40 | |||
| 194178 | 61518 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 11 | 3x3 | Permit Number 53170 | 5997136.693 | 2111517.5991 | 37.7776599825791 | -122.453457942657 | (37.7776599825791, -122.453457942657) | 15 | 6 | 2 | 54 | 16 | |
| 194162 | 121245 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853 | (37.791743655166, -122.40423986853) | 5 | 1 | 10 | 28854 | 6 | ||||
| 194156 | 47257 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1035 Gilman Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52469 | 6015368.10493708 | 2089617.80548286 | 37.7185559218928 | -122.388859444456 | (37.7185559218928, -122.388859444456) | 10 | 3 | 8 | 58 | 1 |
| 194138 | 185249 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2578 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 0ft | 5986167.9797 | 2097704.2052 | 37.7390973532428 | -122.490385486963 | (37.7390973532428, -122.490385486963) | 1 | 8 | 3 | 29491 | 35 | |||
| 194097 | 213144 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 205 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5995619.8871 | 2091308.21818 | 37.722083033577 | -122.457242728577 | (37.722083033577, -122.457242728577) | 9 | 8 | 4 | 28861 | 24 | |||
| 194051 | 5069 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5541 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001780.21152 | 2097345.69555 | 37.7390124482591 | -122.436379924815 | (37.7390124482591, -122.436379924815) | 2 | 7 | 5 | 63 | 7 | |||
| 194042 | 139583 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1920 TURK ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6000563.5972 | 2112083.6768 | 37.7794101280644 | -122.441643783108 | (37.7794101280644, -122.441643783108) | 15 | 5 | 1 | 29490 | 16 | |||
| 194031 | 121072 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007184.0711 | 2112771.95466 | 37.7816749506738 | -122.418789547121 | (37.7816749506738, -122.418789547121) | 7 | 9 | 9 | 28852 | 36 | |||
| 194029 | 185445 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2400 Sunset Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 0ft | 5985084.883 | 2098369.2987 | 37.7408602027886 | -122.494179296034 | (37.7408602027886, -122.494179296034) | 1 | 8 | 3 | 29491 | 35 | |||
| 194001 | 8648 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2800 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5998383.6283 | 2113204.2346 | 37.782362442714 | -122.449265934547 | (37.782362442714, -122.449265934547) | 15 | 6 | 1 | 54 | 31 | |||
| 193953 | 9142 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5913 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1993 12:00:00 AM | 6 | 3X3 | 5988638.2567 | 2112561.5492 | 37.7800355664092 | -122.482933100623 | (37.7800355664092, -122.482933100623) | 11 | 6 | 2 | 55 | 26 | ||
| 193939 | 57597 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1007 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/1976 12:00:00 AM | Permit Number 16465 | 6001956.93021678 | 2101160.46885236 | 37.7494969594121 | -122.436041814854 | (37.7494969594121, -122.436041814854) | 2 | 4 | 5 | 28862 | 22 | |||
| 193896 | 143444 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 KEARNY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6011479.4544 | 2116469.9339 | 37.7920696415903 | -122.404189815368 | (37.7920696415903, -122.404189815368) | 4 | 1 | 10 | 28854 | 6 | |||
| 193867 | 67961 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 851 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 9 | Permit Number 31681 | 5986940.99969 | 2110144.49154 | 37.7733001058091 | -122.488626893935 | (37.7733001058091, -122.488626893935) | 11 | 6 | 2 | 55 | 26 | |
| 193857 | 232506 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 612 Douglass St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6001179.55848 | 2102855.76538 | 37.7541076425683 | -122.438851454235 | (37.7541076425683, -122.438851454235) | 2 | 4 | 5 | 28862 | 22 | |||
| 193835 | 184157 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3434 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5983551.7551 | 2104286.2471 | 37.7570166744379 | -122.499917457181 | (37.7570166744379, -122.499917457181) | 1 | 8 | 3 | 56 | 35 | |||
| 193777 | 251094 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6200 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5987759.9162 | 2112629.2944 | 37.7801704288199 | -122.485976611665 | (37.7801704288199, -122.485976611665) | 11 | 6 | 2 | 55 | 26 | |||
| 193755 | 183029 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2550 41st Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5983675.5787 | 2097931.0813 | 37.7395744081299 | -122.499019698649 | (37.7395744081299, -122.499019698649) | 1 | 8 | 3 | 29491 | 35 | |||
| 193710 | 177676 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 860 Mansell St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6009332.5185 | 2090062.43492 | 37.7194404000398 | -122.409753446068 | (37.7194404000398, -122.409753446068) | 9 | 3 | 7 | 309 | 28 | |||
| 193685 | 104552 | Private 9 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 STARVIEW WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5997447 | 2102183 | 37.7520473310587 | -122.451710958005 | (37.7520473310587, -122.451710958005) | 1 | 5 | 4 | 63 | 38 | |||
| 193675 | 60821 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 53 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20499 | 6004777.4385748 | 2101608.3520195 | 37.7508865753177 | -122.42632029375 | (37.7508865753177, -122.42632029375) | 2 | 4 | 5 | 28862 | 22 | ||
| 193654 | 102153 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Clipper St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003792.2 | 2100904.7 | 37.7488987706557 | -122.429677160081 | (37.7488987706557, -122.429677160081) | 2 | 4 | 5 | 28862 | 22 | |||
| 193621 | 131484 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 303 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008068.74004 | 2112710.38762 | 37.781555673596 | -122.415724641393 | (37.781555673596, -122.415724641393) | 7 | 10 | 9 | 28852 | 36 | |||
| 193620 | 8862 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4141 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 5994127.3691 | 2112759.02895 | 37.780895656032 | -122.463958273194 | (37.780895656032, -122.463958273194) | 11 | 6 | 2 | 54 | 11 | |||
| 193615 | 213240 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 72 Majestic Ave | 1 | : | Tree | Private 2 | 11/24/1982 12:00:00 AM | 14 | Width 3ft | Permit Number 20046 | 5997197.84697 | 2089560.74227 | 37.7173753740534 | -122.451662146612 | (37.7173753740534, -122.451662146612) | 9 | 8 | 6 | 28861 | 24 | |
| 193567 | 1110 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2374 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5999256.41959 | 2089119.22107 | 37.7162807363552 | -122.444514928547 | (37.7162807363552, -122.444514928547) | 9 | 7 | 6 | 28861 | 25 | |||
| 193552 | 143413 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Kearny St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 6011351.7699 | 2116964.7162 | 37.7934210599755 | -122.404666454604 | (37.7934210599755, -122.404666454604) | 3 | 1 | 10 | 28857 | 4 | |||
| 193535 | 98020 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5988217.8603 | 2099007.863 | 37.7427963666772 | -122.483393560294 | (37.7427963666772, -122.483393560294) | 1 | 8 | 3 | 29491 | 35 | |||
| 193529 | 28809 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Point Lobos Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2005 12:00:00 AM | 3 | 3X3 | 5981914.41464 | 2112627.90945 | 37.7798242405661 | -122.50619841953 | (37.7798242405661, -122.50619841953) | 11 | 6 | 2 | 55 | 26 | ||
| 193527 | 56017 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2546 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1973 12:00:00 AM | 20 | Permit Number 12101 | 5996976.7709 | 2110801.3784 | 37.7756842593787 | -122.453959426504 | (37.7756842593787, -122.453959426504) | 15 | 6 | 2 | 54 | 16 | ||
| 193526 | 177659 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 Mansell St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 6011473.42215 | 2090717.42054 | 37.7213586009108 | -122.402399119539 | (37.7213586009108, -122.402399119539) | 10 | 3 | 7 | 309 | 28 | |||
| 193508 | 232720 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 814 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003061.19957 | 2103499.09448 | 37.755980944773 | -122.432390230944 | (37.755980944773, -122.432390230944) | 2 | 4 | 5 | 28862 | 22 | |||
| 193507 | 4387 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10X Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001708.3008261 | 2095817.8256998 | 37.7348131857142 | -122.436519230882 | (37.7348131857142, -122.436519230882) | 2 | 7 | 5 | 63 | 7 | |||
| 193504 | 18708 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 18 Roosevelt Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6001702.8694074 | 2107531.8635154 | 37.7669768293108 | -122.437376538243 | (37.7669768293108, -122.437376538243) | 15 | 5 | 5 | 28862 | 3 | |||
| 193474 | 9104 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5707 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1994 12:00:00 AM | 3 | 3X3 | 5989285.0319 | 2112585.2269 | 37.7801381911436 | -122.4806973734 | (37.7801381911436, -122.4806973734) | 11 | 6 | 2 | 55 | 26 | ||
| 193470 | 131565 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1362 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007019.85478 | 2118451.16549 | 37.7972594148337 | -122.419760753749 | (37.7972594148337, -122.419760753749) | 5 | 1 | 10 | 28858 | 32 | |||
| 193465 | 231419 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2291 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008821.80338 | 2105130.42346 | 37.7607851681274 | -122.412583400312 | (37.7607851681274, -122.412583400312) | 2 | 4 | 7 | 28859 | 19 | |||
| 193457 | 47591 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/2003 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
| 193455 | 193951 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1333 Hudson Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017949.6573 | 2094593.78019 | 37.7323617377914 | -122.380281607712 | (37.7323617377914, -122.380281607712) | 10 | 3 | 8 | 58 | 1 | |||
| 193419 | 131645 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6011425.02065 | 2116406.43511 | 37.791892247384 | -122.404373686296 | (37.791892247384, -122.404373686296) | 5 | 1 | 10 | 28857 | 6 | |||
| 193409 | 232494 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4437 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6001129.15343 | 2101118.08711 | 37.7493335276218 | -122.4389012479 | (37.7493335276218, -122.4389012479) | 2 | 4 | 5 | 28862 | 22 | |||
| 193405 | 232776 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4702 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6000203.97876 | 2104639.14499 | 37.758948814549 | -122.442353257814 | (37.758948814549, -122.442353257814) | 2 | 4 | 5 | 28862 | 3 | |||
| 193395 | 131651 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 608 Pine St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6011330.54609 | 2116338.92208 | 37.7917015929022 | -122.404695815353 | (37.7917015929022, -122.404695815353) | 5 | 1 | 10 | 28857 | 6 | |||
| 193356 | 213150 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 240 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994564.62402 | 2091919.46389 | 37.7237007035037 | -122.460934766643 | (37.7237007035037, -122.460934766643) | 9 | 8 | 4 | 28861 | 24 | |||
| 193335 | 210286 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1455 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5992399.82219 | 2105545.32566 | 37.7609890516241 | -122.469409409239 | (37.7609890516241, -122.469409409239) | 1 | 8 | 4 | 56 | 12 | |||
| 193313 | 210043 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Monterey Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5999993.00551 | 2094710.09723 | 37.7316740010391 | -122.442370083229 | (37.7316740010391, -122.442370083229) | 9 | 7 | 4 | 63 | 40 | |||
| 193286 | 46853 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 454 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 9 | Permit Number 44921 | 6003277.3604 | 2090963.48682 | 37.7215732987425 | -122.430748150718 | (37.7215732987425, -122.430748150718) | 9 | 7 | 6 | 28861 | 5 | |
| 193253 | 232726 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4102 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003100.79865 | 2101268.92168 | 37.7498596634114 | -122.432094031135 | (37.7498596634114, -122.432094031135) | 2 | 4 | 5 | 28862 | 22 | |||
| 193237 | 232508 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 704 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6001215.29481 | 2102233.58181 | 37.7524013093968 | -122.438683290024 | (37.7524013093968, -122.438683290024) | 2 | 4 | 5 | 28862 | 22 | |||
| 193177 | 19354 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 650 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5992292.38656 | 2089866.82743 | 37.7179336551949 | -122.468640150735 | (37.7179336551949, -122.468640150735) | 9 | 8 | 6 | 64 | 24 | |||
| 193149 | 63478 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2079 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1987 12:00:00 AM | 8 | Permit Number 24072 | 5999657.7272 | 2111536.1915 | 37.7778552202054 | -122.444738195119 | (37.7778552202054, -122.444738195119) | 15 | 5 | 11 | 29490 | 16 | |
| 193146 | 38444 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1401 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | 10 | 3 | 8 | 58 | 1 | ||
| 193144 | 33451 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 321 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37552 | 6006219.56929153 | 2098134.91814119 | 37.7414307262079 | -122.421086659248 | (37.7414307262079, -122.421086659248) | 2 | 7 | 7 | 28859 | 2 | |||
| 193141 | 140988 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2425 GEARY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999880.1931 | 2113248.2954 | 37.7825689102663 | -122.444091664454 | (37.7825689102663, -122.444091664454) | 15 | 5 | 1 | 29490 | 16 | |||
| 193140 | 250873 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150 30th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5986514.1703 | 2114700.87376 | 37.7857857157716 | -122.490438601084 | (37.7857857157716, -122.490438601084) | 11 | 6 | 1 | 55 | 33 | |||
| 193121 | 232627 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 Starview Way | 2 | : | Tree | Private 2 | 13 | Width 3ft | 5997483.45824 | 2102211.01483 | 37.7521263407563 | -122.451586901227 | (37.7521263407563, -122.451586901227) | 1 | 5 | 4 | 63 | 38 | |||
| 193120 | 103060 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2447 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5986361.646 | 2102961.746 | 37.7535444547699 | -122.490102501334 | (37.7535444547699, -122.490102501334) | 1 | 8 | 3 | 56 | 35 | |||
| 193097 | 101175 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994553 | 2106706 | 37.7643001590155 | -122.462046733301 | (37.7643001590155, -122.462046733301) | 11 | 5 | 11 | 56 | 12 | ||||
| 193092 | 23606 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
| 193058 | 131501 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Turk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6007445.03428 | 2112967.62505 | 37.7822269041808 | -122.417900610425 | (37.7822269041808, -122.417900610425) | 7 | 9 | 9 | 28852 | 36 | |||
| 193054 | 177789 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6002017.64706 | 2086775.84814 | 37.7100035197158 | -122.434803320611 | (37.7100035197158, -122.434803320611) | 9 | 7 | 6 | 28861 | 5 | |||
| 193039 | 251058 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6333 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5987308.6726 | 2112511.2433 | 37.7798199870529 | -122.487528974557 | (37.7798199870529, -122.487528974557) | 11 | 6 | 2 | 55 | 26 | |||
| 193022 | 185281 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2601 Sunset Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984957.4232 | 2097426.5415 | 37.7382641856476 | -122.494550515454 | (37.7382641856476, -122.494550515454) | 1 | 8 | 3 | 29491 | 35 | |||
| 192996 | 65590 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 875 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 12 | Permit Number 28491 | 6008718.16463 | 2120030.26562 | 37.8016907558706 | -122.413995919601 | (37.8016907558706, -122.413995919601) | 3 | 1 | 10 | 308 | 32 | ||
| 192994 | 250407 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 25 Seacliff Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/16/1997 12:00:00 AM | 12 | Width 4ft | Permit Number 38521 | 5987994.17396 | 2115794.49036 | 37.7888748051653 | -122.485398549405 | (37.7888748051653, -122.485398549405) | 11 | 6 | 1 | 55 | 33 | |
| 192984 | 131650 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 608 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6011349.67505 | 2116341.34751 | 37.7917093216713 | -122.404629799728 | (37.7917093216713, -122.404629799728) | 5 | 1 | 10 | 28857 | 6 | |||
| 192964 | 231424 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3309 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006221.95925 | 2103740.82586 | 37.7568234036034 | -122.421476427289 | (37.7568234036034, -122.421476427289) | 2 | 4 | 5 | 28859 | 19 | |||
| 192911 | 122759 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86X Park Hill Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001171 | 2107689 | 37.7673780360046 | -122.439227450619 | (37.7673780360046, -122.439227450619) | 15 | 5 | 5 | 29492 | 3 | ||||
| 192899 | 177778 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Naylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002419.92073 | 2086977.96609 | 37.7105813224323 | -122.433427420845 | (37.7105813224323, -122.433427420845) | 9 | 7 | 6 | 28861 | 5 | |||
| 192896 | 232610 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1040 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6000831.51592 | 2096230.36793 | 37.7358960680431 | -122.43958013711 | (37.7358960680431, -122.43958013711) | 2 | 7 | 5 | 63 | 7 | |||
| 192885 | 109187 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 8038 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773568 | 5982053.04205 | 2112402.52702 | 37.7792135667625 | -122.505702141836 | (37.7792135667625, -122.505702141836) | 11 | 6 | 2 | 55 | 26 |
| 192874 | 83520 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1488 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50200 | 5980958.16481146 | 2104928.49787253 | 37.7586275647998 | -122.508934600528 | (37.7586275647998, -122.508934600528) | 1 | 8 | 3 | 56 | 35 | ||
| 192870 | 65626 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 246 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | 12 | Permit Number 28534 | 6004998.19113 | 2094047.70433 | 37.7301392270241 | -122.425019029527 | (37.7301392270241, -122.425019029527) | 9 | 7 | 6 | 28861 | 5 | |
| 192841 | 15011 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 637 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 0 | 6016292.93152 | 2097079.40716 | 37.7390952200605 | -122.386182568687 | (37.7390952200605, -122.386182568687) | 10 | 3 | 8 | 58 | 1 | |||
| 192747 | 250457 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 230 Seacliff Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5987065.2989 | 2115744.60319 | 37.7886836704693 | -122.488608618305 | (37.7886836704693, -122.488608618305) | 11 | 6 | 1 | 55 | 33 | |||
| 192739 | 250042 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6006158.68902 | 2114736.17368 | 37.7870104260474 | -122.422476501285 | (37.7870104260474, -122.422476501285) | 13 | 9 | 1 | 28858 | 41 | |||
| 192720 | 131662 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 58 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6011794.08707 | 2115361.3348 | 37.7890432670696 | -122.40302316631 | (37.7890432670696, -122.40302316631) | 4 | 1 | 10 | 28854 | 6 | |||
| 192685 | 18774 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 305 Roosevelt Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000527.8155 | 2106909.53937 | 37.7652012098941 | -122.441396193897 | (37.7652012098941, -122.441396193897) | 15 | 5 | 5 | 28862 | 3 | |||
| 192678 | 24673 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4301 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2005 12:00:00 AM | 3 | 3X3 | 5993651.65223 | 2112718.86248 | 37.7807579428023 | -122.465601078977 | (37.7807579428023, -122.465601078977) | 11 | 6 | 2 | 54 | 11 | ||
| 192660 | 112981 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3880 NORIEGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982016 | 2102928 | 37.7531970663373 | -122.505127932021 | (37.7531970663373, -122.505127932021) | 1 | 8 | 3 | 56 | 35 | ||||
| 192653 | 232192 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 138 Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000854.6666 | 2105550.59859 | 37.7614885081095 | -122.440168239773 | (37.7614885081095, -122.440168239773) | 15 | 5 | 5 | 28862 | 3 | |||
| 192644 | 32328 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 446 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | 8 | Permit Number 44974 | 6001786.27742 | 2103255.73247 | 37.7552403557676 | -122.436781905573 | (37.7552403557676, -122.436781905573) | 2 | 4 | 5 | 28862 | 22 | |
| 192641 | 139333 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1599 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004633.6042 | 2114313.8357 | 37.7857646393648 | -122.427722851144 | (37.7857646393648, -122.427722851144) | 13 | 9 | 11 | 28858 | 13 | |||
| 192606 | 184533 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1901 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5981317.4398 | 2102072.4416 | 37.7508068182428 | -122.507480175988 | (37.7508068182428, -122.507480175988) | 1 | 8 | 3 | 29491 | 35 | |||
| 192559 | 9249 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6500X Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/01/1993 12:00:00 AM | 3 | 3X3 | 5986794.90325 | 2112599.27016 | 37.780031706607 | -122.489312779221 | (37.780031706607, -122.489312779221) | 11 | 6 | 2 | 55 | 26 | ||
| 192551 | 232558 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 665 Elizabeth St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002164.87583 | 2102045.53482 | 37.7519389517211 | -122.435386037248 | (37.7519389517211, -122.435386037248) | 2 | 4 | 5 | 28862 | 22 | |||
| 192539 | 231306 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 356 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003607.36045 | 2099253.05884 | 37.7443532799967 | -122.43019852107 | (37.7443532799967, -122.43019852107) | 2 | 7 | 5 | 63 | 22 | |||
| 192538 | 232505 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 665 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6001241.23493 | 2102531.23898 | 37.7532200800565 | -122.438614910959 | (37.7532200800565, -122.438614910959) | 2 | 4 | 5 | 28862 | 22 |
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) );