Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4667 | 4667 | 177596 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2969 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 2ft | 5996863.1047 | 2087380.0497599998 | 37.7113685215187 | -122.452661893251 | (37.7113685215187, -122.452661893251) | |||
4706 | 4706 | 2834 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3X3 | 6008517.592999999 | 2116245.0199599997 | 37.791286140299 | -122.414422000399 | (37.791286140299, -122.414422000399) | |||
4767 | 4767 | 7019 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1060 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002340.5774 | 2110230.3568 | 37.774422458417504 | -122.43536385962601 | (37.7744224584175, -122.435363859626) | |||
4773 | 4773 | 8756 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3355 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996698.2031 | 2112866.405 | 37.781338303610504 | -122.45507230946801 | (37.7813383036105, -122.455072309468) | |||
5017 | 5017 | 27394 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2264 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007125.97571 | 2120126.616 | 37.801865757665894 | -122.419512476126 | (37.8018657576659, -122.419512476126) | |||
5094 | 5094 | 253788 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1663X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991413.0 | 2103963.0 | 37.756587325686105 | -122.472706989611 | (37.7565873256861, -122.472706989611) | ||||
5266 | 5266 | 2205 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1119 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000838.0324 | 2112547.0194 | 37.7806979809143 | -122.440727643404 | (37.7806979809143, -122.440727643404) | |||
5297 | 5297 | 9909 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1850 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005266.16067 | 2116037.55632 | 37.790533307027296 | -122.425657110207 | (37.7905333070273, -122.425657110207) | |||
5372 | 5372 | 3142 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3333 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998246.7366 | 2114816.476 | 37.7867814031738 | -122.449855744427 | (37.7867814031738, -122.449855744427) | |||
5408 | 5408 | 8173 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001985.2987 | 2111217.5273 | 37.777112798515205 | -122.436663510376 | (37.7771127985152, -122.436663510376) | |||
5469 | 5469 | 19012 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3107 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999843.28922 | 2115392.90967 | 37.7884553586667 | -122.444373507449 | (37.7884553586667, -122.444373507449) | |||
5556 | 5556 | 6080 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1970 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001000.0518 | 2112470.2823 | 37.7804965057813 | -122.440161637274 | (37.7804965057813, -122.440161637274) | |||
5603 | 5603 | 34246 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38056 | ||||||||||
5666 | 5666 | 8170 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1190 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6002123.0971 | 2111240.3416 | 37.7771832708527 | -122.436188456168 | (37.7771832708527, -122.436188456168) | |||
5688 | 5688 | 18490 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 29 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | 6010377.42756 | 2113906.8182 | 37.784970300477 | -122.407822041378 | (37.784970300477, -122.407822041378) | |||
5705 | 5705 | 2688 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2103 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1991 12:00:00 AM | 6 | 3X3 | 6003377.8906 | 2114832.113 | 37.7871165862827 | -122.432104286971 | (37.7871165862827, -122.432104286971) | ||
5756 | 5756 | 8772 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3434 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 5996377.3792 | 2112940.8578 | 37.781524320662 | -122.456187581392 | (37.781524320662, -122.456187581392) | |||
5847 | 5847 | 8661 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2830 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998270.9338 | 2113188.3287 | 37.7823123226421 | -122.449654659499 | (37.7823123226421, -122.449654659499) | |||
5962 | 5962 | 82000 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50638 | 6005983.68719 | 2120729.63993 | 37.803457100839296 | -122.423508229633 | (37.8034571008393, -122.423508229633) |
5966 | 5966 | 117017 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008130.7573 | 2112963.51283 | 37.7822541806174 | -122.415528017206 | (37.7822541806174, -122.415528017206) | |
6011 | 6011 | 66459 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 26 Wood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 12 | Permit Number 29609 | 5998393.1041 | 2113638.7682 | 37.7835561003446 | -122.449264468811 | (37.7835561003446, -122.449264468811) | |
6014 | 6014 | 14505 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999117.4959 | 2111218.7139 | 37.7769526647296 | -122.44658418923201 | (37.7769526647296, -122.446584189232) | |||
6022 | 6022 | 2195 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1100 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6000891.1646 | 2112477.643 | 37.780510516656605 | -122.44053885663901 | (37.7805105166566, -122.440538856639) | |||
6058 | 6058 | 8699 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3019 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/1994 12:00:00 AM | 3 | 3X3 | 5997744.2649 | 2113009.5574 | 37.781791318676795 | -122.45146379306101 | (37.7817913186768, -122.451463793061) | ||
6183 | 6183 | 53961 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2456 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | 14 | 3x3 | Permit Number 9676 | 6002263.92073 | 2116681.1159200002 | 37.7921302538612 | -122.436090735194 | (37.7921302538612, -122.436090735194) | |
6226 | 6226 | 18920 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2649 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002116.02107 | 2115708.8544 | 37.7894522706541 | -122.436532848209 | (37.7894522706541, -122.436532848209) | |||
6231 | 6231 | 8155 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1060 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6002678.2452 | 2111319.127 | 37.7774311210584 | -122.43427365855801 | (37.7774311210584, -122.434273658558) | |||
6284 | 6284 | 6343 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1932 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1994 12:00:00 AM | 12 | 3X3 | 6001619.7021 | 2112903.1238 | 37.78172023692821 | -122.43804899261299 | (37.7817202369282, -122.438048992613) | ||
6368 | 6368 | 8674 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5998029.5545 | 2113103.6387 | 37.7820659737765 | -122.45048361361201 | (37.7820659737765, -122.450483613612) | |||
6378 | 6378 | 10671 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1099X Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002659.3771 | 2110570.8701 | 37.7753755231217 | -122.434285421548 | (37.7753755231217, -122.434285421548) | |||
6382 | 6382 | 8738 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3300X Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6x10 | 5996893.3032 | 2112947.7955 | 37.7815729712314 | -122.45440324333 | (37.7815729712314, -122.45440324333) | |||
6392 | 6392 | 6363 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2053 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6001063.5059 | 2112776.0464 | 37.7813396684229 | -122.439964050414 | (37.7813396684229, -122.439964050414) | |||
6443 | 6443 | 19238 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 659 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002061.8001 | 2110816.8234 | 37.7760169132006 | -122.43637018327499 | (37.7760169132006, -122.436370183275) | |||
6486 | 6486 | 6067 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1930 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001213.2576 | 2112501.0787 | 37.780593200714996 | -122.439426267637 | (37.780593200715, -122.439426267637) | |||
6488 | 6488 | 6051 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1900 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1993 12:00:00 AM | 6 | 3X3 | 6001294.8172 | 2112514.6155 | 37.780635010552395 | -122.439145085226 | (37.7806350105524, -122.439145085226) | ||
6603 | 6603 | 8657 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2807 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/30/1992 12:00:00 AM | 6 | 3X3 | 5998380.8363 | 2113098.9008 | 37.7820730639086 | -122.449268002324 | (37.7820730639086, -122.449268002324) | ||
6626 | 6626 | 10691 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1245 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001914.4034 | 2110469.3909 | 37.7750545742745 | -122.436855188969 | (37.7750545742745, -122.436855188969) | |||
6754 | 6754 | 8718 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3145 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5997330.7134 | 2112954.0563 | 37.781615237280704 | -122.45289047303899 | (37.7816152372807, -122.452890473039) | |||
6790 | 6790 | 8720 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3151 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5997317.8534 | 2112951.6873 | 37.781607995678 | -122.45293479123501 | (37.781607995678, -122.452934791235) | |||
6944 | 6944 | 6360 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2038 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6001105.9779 | 2112831.3784 | 37.7814940136483 | -122.43982108672199 | (37.7814940136483, -122.439821086722) | |||
7185 | 7185 | 6341 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1930 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6001644.4069 | 2112907.1848 | 37.7817327923252 | -122.437963816777 | (37.7817327923252, -122.437963816777) | |||
7211 | 7211 | 6359 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2034 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001132.0363 | 2112836.4547 | 37.7815094351264 | -122.43973130146401 | (37.7815094351264, -122.439731301464) | |||
7314 | 7314 | 8694 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3001 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997791.3055 | 2113016.6643 | 37.7818135259457 | -122.451301568097 | (37.7818135259457, -122.451301568097) | |||
7349 | 7349 | 11121 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2111 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/1991 12:00:00 AM | 24 | 3X3 | 6007150.67301 | 2119614.39818 | 37.8004607279458 | -122.419390653056 | (37.8004607279458, -122.419390653056) | ||
7358 | 7358 | 6362 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2050 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001055.2146 | 2112826.6404 | 37.7814781146475 | -122.43999636304399 | (37.7814781146475, -122.439996363044) | |||
7360 | 7360 | 8713 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3121 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/1994 12:00:00 AM | 3 | 3X3 | 5997442.3926 | 2112967.5931 | 37.7816588049301 | -122.452505095337 | (37.7816588049301, -122.452505095337) | ||
7402 | 7402 | 8711 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3120 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997427.3329 | 2113071.9963 | 37.7819446058243 | -122.45256473134701 | (37.7819446058243, -122.452564731347) | |||
7420 | 7420 | 24657 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3030 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5997669.9813 | 2113103.8079 | 37.7820458518086 | -122.451727579321 | (37.7820458518086, -122.451727579321) | |||
7455 | 7455 | 66458 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 11 Wood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | 12 | Permit Number 29608 | 5998357.739 | 2113627.431 | 37.783522948461396 | -122.449386000758 | (37.7835229484614, -122.449386000758) | |
7460 | 7460 | 3086 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2925 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6000198.2675 | 2115085.6403 | 37.787631923902104 | -122.44312326569201 | (37.7876319239021, -122.443123265692) | |||
7467 | 7467 | 6365 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2065 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001002.9284 | 2112768.9395 | 37.78131670607711 | -122.440173108663 | (37.7813167060771, -122.440173108663) | |||
7480 | 7480 | 8156 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1062 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4X4 | 6002659.9937 | 2111315.4767 | 37.7774200622935 | -122.43433653539499 | (37.7774200622935, -122.434336535395) | |||
7493 | 7493 | 7730 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3x3 | 6006431.70019 | 2111170.5594099998 | 37.7772355175274 | -122.421278646599 | (37.7772355175274, -122.421278646599) | |||
7503 | 7503 | 2209 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1131 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 4X4 | 6000831.9408 | 2112595.4137 | 37.78083051240179 | -122.44075218952801 | (37.7808305124018, -122.440752189528) | |||
7582 | 7582 | 8770 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3430 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/1994 12:00:00 AM | 6 | 3X3 | 5996399.715 | 2112942.2115 | 37.781529319654105 | -122.45611040861 | (37.7815293196541, -122.45611040861) | ||
7591 | 7591 | 14429 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998837.1981 | 2113128.5127 | 37.7821804632664 | -122.44769133675501 | (37.7821804632664, -122.447691336755) | |||
7680 | 7680 | 6863 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6007373.9126699995 | 2110931.35709 | 37.7766317999636 | -122.418002262612 | (37.7766317999636, -122.418002262612) | |||
7682 | 7682 | 84827 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2680 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 53660 | 5999436.2585 | 2113644.4547 | 37.7836313258411 | -122.445655978901 | (37.7836313258411, -122.445655978901) |
7707 | 7707 | 8644 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2707 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5998734.8255 | 2113145.603 | 37.7822215373925 | -122.448046729352 | (37.7822215373925, -122.448046729352) | |||
7743 | 7743 | 121449 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1274 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 10x6 | 6006927.94593 | 2119481.89109 | 37.800084349978 | -122.420151970562 | (37.800084349978, -122.420151970562) | |||
7744 | 7744 | 6340 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1923 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 7x5 | 6001568.262 | 2112844.2384 | 37.7815556270697 | -122.43822273106301 | (37.7815556270697, -122.438222731063) | |||
7749 | 7749 | 8151 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1040 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6002784.7119 | 2111334.3365 | 37.777478924912295 | -122.43390644299 | (37.7774789249123, -122.43390644299) | |||
7825 | 7825 | 18270 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1949 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002871.8831 | 2114071.2435 | 37.7849987304434 | -122.433800556721 | (37.7849987304434, -122.433800556721) | |||
7876 | 7876 | 2697 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2117 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6003239.8117 | 2114811.7937 | 37.787052965257296 | -122.43258055733999 | (37.7870529652573, -122.43258055734) | |||
7962 | 7962 | 6347 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1940 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001595.6742 | 2112898.0474 | 37.781704931936105 | -122.43813175391001 | (37.7817049319361, -122.43813175391) | |||
7983 | 7983 | 8157 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1082 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6002625.6202 | 2111311.5222 | 37.7774072530977 | -122.434455161682 | (37.7774072530977, -122.434455161682) | |||
8057 | 8057 | 18494 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 45 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4X4 | 6010359.58232 | 2113994.15068 | 37.785209095679 | -122.407889941061 | (37.785209095679, -122.407889941061) | |||
8125 | 8125 | 6090 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2004 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6000804.7824 | 2112443.2085 | 37.7804110490892 | -122.44083522187799 | (37.7804110490892, -122.440835221878) | |||
8144 | 8144 | 6367 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2076 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6000929.8293 | 2112807.858 | 37.78141940439271 | -122.440428787167 | (37.7814194043927, -122.440428787167) | |||
8247 | 8247 | 8698 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3018 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997712.6224 | 2113110.2379 | 37.782065948906 | -122.45158052523199 | (37.782065948906, -122.451580525232) | |||
8280 | 8280 | 109193 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4124 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773525 | |||||
8357 | 8357 | 2699 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2119 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003207.4855 | 2114810.8701 | 37.787048596041004 | -122.43269233270901 | (37.787048596041, -122.432692332709) | |||
8377 | 8377 | 8710 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3112 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997442.5618 | 2113074.0268 | 37.781951053579505 | -122.45251219321699 | (37.7819510535795, -122.452512193217) | |||
8471 | 8471 | 6088 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6000823.7341 | 2112446.2543 | 37.780420491387 | -122.44076987778999 | (37.780420491387, -122.44076987779) | |||
8495 | 8495 | 17823 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1916 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2007 12:00:00 AM | 3 | 3X3 | 6004641.9366 | 2115407.1265 | 37.788767013293 | -122.427771950207 | (37.788767013293, -122.427771950207) | ||
8516 | 8516 | 2705 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2125 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1981 12:00:00 AM | 6 | 3X3 | 6003127.3628 | 2114798.1705 | 37.787009181880606 | -122.432968631522 | (37.7870091818806, -122.432968631522) | ||
8527 | 8527 | 27521 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3201 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5998932.21 | 2114912.2494 | 37.7870835680029 | -122.44749107369499 | (37.7870835680029, -122.447491073695) | |||
8533 | 8533 | 6082 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1980 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000975.347 | 2112464.8675 | 37.7804802316041 | -122.44024671420799 | (37.7804802316041, -122.440246714208) | |||
8664 | 8664 | 9907 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1809 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005224.35314 | 2116024.07833 | 37.7904939373852 | -122.425800802087 | (37.7904939373852, -122.425800802087) | |||
8686 | 8686 | 6339 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1919 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 7x7 | 6001586.1984 | 2112846.6073 | 37.7815631515793 | -122.438160849577 | (37.7815631515793, -122.438160849577) | |||
8731 | 8731 | 8646 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2761 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998500.976 | 2113115.4835 | 37.782125466793104 | -122.448853570215 | (37.7821254667931, -122.448853570215) | |||
8778 | 8778 | 8697 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3015 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1986 12:00:00 AM | 6 | 3X3 | 5997765.247 | 2113011.588 | 37.7817980956526 | -122.45139135166599 | (37.7817980956526, -122.451391351666) | ||
8780 | 8780 | 2207 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1130 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000880.6735 | 2112571.0474 | 37.7807663839162 | -122.440581851595 | (37.7807663839162, -122.440581851595) | |||
8789 | 8789 | 8706 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3100 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1986 12:00:00 AM | 12 | 3x3 | 5997482.4956 | 2113078.7647 | 37.7819663504933 | -122.452374383353 | (37.7819663504933, -122.452374383353) | ||
8840 | 8840 | 20436 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15 | ||||||||
8843 | 8843 | 8660 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2826 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998302.407000001 | 2113191.3745 | 37.7823224861492 | -122.449545996211 | (37.7823224861492, -122.449545996211) | |||
8844 | 8844 | 2212 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1180 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x6 | 6000876.2741 | 2112611.6580000003 | 37.7808776397405 | -122.44059998488999 | (37.7808776397405, -122.44059998489) | |||
8914 | 8914 | 8668 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2882 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/1993 12:00:00 AM | 24 | 3X3 | 5998247.9211 | 2113184.9445 | 37.7823017139268 | -122.44973402892201 | (37.7823017139268, -122.449734028922) | ||
8978 | 8978 | 2691 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2105 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6003350.6443 | 2114827.9568 | 37.787103629638096 | -122.432198256194 | (37.7871036296381, -122.432198256194) | |||
8979 | 8979 | 2696 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2115 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003266.5962 | 2114816.4117 | 37.7870671640055 | -122.43248821896799 | (37.7870671640055, -122.432488218968) | |||
8993 | 8993 | 8648 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2800 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5998383.6283 | 2113204.2346 | 37.782362442714 | -122.449265934547 | (37.782362442714, -122.449265934547) | |||
9038 | 9038 | 173597 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 473 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003668.0 | 2105532.0 | 37.7615972080674 | -122.430436757163 | (37.7615972080674, -122.430436757163) | ||||
9054 | 9054 | 2234 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1219 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1989 12:00:00 AM | 12 | 4X4 | 6000791.161 | 2112886.9641 | 37.7816287128377 | -122.44091418756099 | (37.7816287128377, -122.440914187561) | ||
9102 | 9102 | 957 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1528 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3X3 | 6001955.00111 | 2093277.90628 | 37.7278531638615 | -122.43548466570299 | (37.7278531638615, -122.435484665703) | |||
9139 | 9139 | 8752 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3330 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5996845.9242 | 2112992.1287 | 37.7816919812146 | -122.454570354799 | (37.7816919812146, -122.454570354799) | |||
9155 | 9155 | 8690 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2950 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5997911.7837 | 2113137.4809 | 37.7821521543336 | -122.450893486037 | (37.7821521543336, -122.450893486037) | |||
9159 | 9159 | 19367 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 445X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6x10 | 5994012.35224 | 2114842.43406 | 37.7866094923379 | -122.464507488788 | (37.7866094923379, -122.464507488788) | |||
9225 | 9225 | 18783 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 345X Roosevelt Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000292.8158924 | 2106925.3125911 | 37.7652311289718 | -122.442210131131 | (37.7652311289718, -122.442210131131) | |||
9237 | 9237 | 10668 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1027 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6002900.4751 | 2110607.2358 | 37.775489055911706 | -122.43345400736999 | (37.7754890559117, -122.43345400737) | |||
9265 | 9265 | 10666 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1015 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6002966.2768 | 2110616.4892 | 37.7755181964859 | -122.433227045109 | (37.7755181964859, -122.433227045109) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");