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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
5016 | 5016 | 8176 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001924.4605 | 2111208.7057 | 37.7770851190514 | -122.43687333680799 | (37.7770851190514, -122.436873336808) | |||
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) | ||||
5115 | 5115 | 14434 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90X Masonic Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998899.8061 | 2113051.3525 | 37.781972179426205 | -122.447469186406 | (37.7819721794262, -122.447469186406) | |||
5260 | 5260 | 10676 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1099X Hayes St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002794.3343 | 2110592.0399 | 37.775441309285604 | -122.433820087 | (37.7754413092856, -122.433820087) | |||
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) | |||
5294 | 5294 | 97730 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | Permit Number 50638 | 6005803.34745 | 2120703.57786 | 37.8033753605476 | -122.424130448959 | (37.8033753605476, -122.424130448959) | |
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) | |||
5344 | 5344 | 5307 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6001124.6062 | 2113907.9724 | 37.7844511257674 | -122.43983385427099 | (37.7844511257674, -122.439833854271) | |||
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) | |||
5407 | 5407 | 5304 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6001115.9968 | 2113959.0141 | 37.7845907831124 | -122.439867300639 | (37.7845907831124, -122.439867300639) | |||
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) | |||
5411 | 5411 | 8150 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002846.3106 | 2111341.485 | 37.7775020483312 | -122.433693863913 | (37.7775020483312, -122.433693863913) | |||
5436 | 5436 | 10673 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1099X Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002708.9937 | 2110579.4703 | 37.775401953211706 | -122.434114401257 | (37.7754019532117, -122.434114401257) | |||
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) | |||
5485 | 5485 | 8672 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998008.9107 | 2113150.6793 | 37.7821939533855 | -122.45055842381599 | (37.7821939533855, -122.450558423816) | |||
5508 | 5508 | 8174 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001968.8724 | 2111216.0063 | 37.777107688726204 | -122.436720225115 | (37.7771076887262, -122.436720225115) | |||
5533 | 5533 | 8673 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997990.2975 | 2113148.3104 | 37.7821863836314 | -122.45062264598499 | (37.7821863836314, -122.450622645985) | |||
5551 | 5551 | 8643 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999146.1772 | 2113255.7593 | 37.78254750349429 | -122.44663157016399 | (37.7825475034943, -122.446631570164) | |||
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) | |||
5564 | 5564 | 8191 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1280 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6001633.6542 | 2111170.6819 | 37.7769641829366 | -122.437876600816 | (37.7769641829366, -122.437876600816) | |||
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 | ||||||||||
5628 | 5628 | 8642 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999172.2357 | 2113259.8204 | 37.7825601426854 | -122.446541711639 | (37.7825601426854, -122.446541711639) | |||
5635 | 5635 | 8758 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3355 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996732.7221 | 2112870.4661 | 37.781351434582206 | -122.45495318481001 | (37.7813514345822, -122.45495318481) | |||
5651 | 5651 | 8712 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3120 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997408.0428 | 2113069.6273 | 37.781936995917896 | -122.45263129483801 | (37.7819369959179, -122.452631294838) | |||
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) | |||
5693 | 5693 | 8759 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3355 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996749.9816 | 2112873.8503 | 37.781361716788204 | -122.454893720301 | (37.7813617167882, -122.454893720301) | |||
5699 | 5699 | 97727 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | Permit Number 50638 | 6005898.3389 | 2120719.3141099997 | 37.8034239311172 | -122.42380284664699 | (37.8034239311172, -122.423802846647) | |
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) | |||
5800 | 5800 | 20309 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
5832 | 5832 | 20376 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
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) | |||
5849 | 5849 | 21633 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1615 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004763.9583 | 2114678.6617 | 37.786773733259395 | -122.42729786002701 | (37.7867737332594, -122.427297860027) | |||
5867 | 5867 | 19581 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 STAIRWAY4 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 8 | ||||||||
5947 | 5947 | 8624 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999301.8512 | 2113214.4718 | 37.782443029823206 | -122.446090036766 | (37.7824430298232, -122.446090036766) | |||
5969 | 5969 | 111118 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 5997454.0334 | 2109847.6499 | 37.7730929211041 | -122.45223963309401 | (37.7730929211041, -122.452239633094) | |||
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) | |||
6081 | 6081 | 19239 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 659 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002066.7434 | 2110793.9605 | 37.7759544182775 | -122.436351446483 | (37.7759544182775, -122.436351446483) | |||
6151 | 6151 | 6054 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1900 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001226.7944 | 2112502.0939 | 37.7805967585671 | -122.439379510292 | (37.7805967585671, -122.439379510292) | |||
6154 | 6154 | 8696 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3008 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5997736.312000001 | 2113111.93 | 37.7820719515644 | -122.451498692484 | (37.7820719515644, -122.451498692484) | |||
6158 | 6158 | 111117 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5997427.9716 | 2109844.5838 | 37.7730830093731 | -122.452329562425 | (37.7730830093731, -122.452329562425) | |||
6165 | 6165 | 14421 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 3X3 | 5998843.9665 | 2113055.4136 | 37.7819801389805 | -122.44766265742399 | (37.7819801389805, -122.447662657424) | |||
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) | |||
6290 | 6290 | 14424 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 12 | 5998854.1192 | 2113097.3779 | 37.7820959422738 | -122.44763055563999 | (37.7820959422738, -122.44763055564) | |||
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) | |||
6442 | 6442 | 18493 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 45 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4X4 | 6010362.59726 | 2113973.56841 | 37.785152750446 | -122.407878058349 | (37.785152750446, -122.407878058349) | |||
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) | |||
6514 | 6514 | 20450 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
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) | |||
6634 | 6634 | 2698 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2117 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003253.6657 | 2114814.1027 | 37.78706009082521 | -122.432532790607 | (37.7870600908252, -122.432532790607) | |||
6644 | 6644 | 10678 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1099X Hayes St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002838.6585 | 2110596.6708 | 37.775456539692705 | -122.433667090298 | (37.7754565396927, -122.433667090298) | |||
6674 | 6674 | 5302 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6001111.6921 | 2113998.3714 | 37.7846986031206 | -122.439885016276 | (37.7846986031206, -122.439885016276) | |||
6682 | 6682 | 10675 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1099X Hayes St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002771.1799 | 2110588.7321 | 37.7754309129501 | -122.43389994697701 | (37.7754309129501, -122.433899946977) | |||
6690 | 6690 | 2830 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6008514.679409999 | 2116307.39052 | 37.791457230925396 | -122.41443649656401 | (37.7914572309254, -122.414436496564) | |||
6730 | 6730 | 2692 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2105 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6003365.8837 | 2114830.7276 | 37.7871121015843 | -122.432145729207 | (37.7871121015843, -122.432145729207) | |||
6735 | 6735 | 6338 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1916 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001675.8802 | 2112911.5843 | 37.7817466619817 | -122.43785524938 | (37.7817466619817, -122.43785524938) | |||
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) | |||
6778 | 6778 | 20443 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
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) | |||
6820 | 6820 | 8167 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1124 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6002248.7279 | 2111258.5930000003 | 37.7772405215532 | -122.435755166091 | (37.7772405215532, -122.435755166091) | |||
6919 | 6919 | 8636 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999097.4445 | 2113192.4744 | 37.782370955794605 | -122.446795608488 | (37.7823709557946, -122.446795608488) | |||
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) | |||
7003 | 7003 | 14431 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998857.8418 | 2113111.93 | 37.7821361113043 | -122.44761872504499 | (37.7821361113043, -122.447618725045) | |||
7027 | 7027 | 3144 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3333 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998323.3892 | 2114826.7979 | 37.7868141298478 | -122.449591289713 | (37.7868141298478, -122.449591289713) | |||
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) | |||
7214 | 7214 | 14423 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90X Masonic Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 12 | 5998895.4066 | 2113040.8614 | 37.7819431221776 | -122.44748365121 | (37.7819431221776, -122.44748365121) | |||
7215 | 7215 | 2700 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2119 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003220.8778 | 2114813.1791 | 37.7870556954708 | -122.432646163369 | (37.7870556954708, -122.432646163369) | |||
7218 | 7218 | 8719 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3145 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997342.5582 | 2112956.0868 | 37.7816214912599 | -122.452849642485 | (37.7816214912599, -122.452849642485) | |||
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) | |||
7339 | 7339 | 97732 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | Permit Number 50638 | 6005757.30775 | 2120698.05289 | 37.8033575908394 | -122.424289378073 | (37.8033575908394, -122.424289378073) | |
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) | |||
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) | |||
7428 | 7428 | 7199 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 949 Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6003416.3824 | 2111558.7293 | 37.7781308777085 | -122.43173731178699 | (37.7781308777085, -122.431737311787) | |||
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) | |||
7534 | 7534 | 5301 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001109.2323 | 2114011.9005 | 37.7847356105359 | -122.43989449671301 | (37.7847356105359, -122.439894496713) | |||
7547 | 7547 | 8637 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999081.877 | 2113180.2912 | 37.7823366145664 | -122.44684858803001 | (37.7823366145664, -122.44684858803) | |||
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) | |||
7626 | 7626 | 8175 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001945.7539 | 2111212.6602 | 37.777097187307604 | -122.436799959546 | (37.7770971873076, -122.436799959546) | |||
7628 | 7628 | 6068 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1930 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001194.9828 | 2112498.3713 | 37.7805847268461 | -122.439489294599 | (37.7805847268461, -122.439489294599) | |||
7664 | 7664 | 5305 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6001119.0716 | 2113939.9503 | 37.7845386138352 | -122.439855295582 | (37.7845386138352, -122.439855295582) | |||
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) | |||
7699 | 7699 | 105527 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 228 Collins St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 5998178.2908 | 2113055.0752 | 37.7819411428258 | -122.449965554893 | (37.7819411428258, -122.449965554893) | |||
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) | |||
7709 | 7709 | 2215 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1180 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5x6 | 6000865.1061 | 2112691.864 | 37.7810972289783 | -122.440644375031 | (37.7810972289783, -122.440644375031) |
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");