Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▲ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 117371 | 117371 | 113795 | Section 143 8 | Maytenus boaria :: Mayten 22 | 331 TERESITA BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997873.0 | 2098382.0 | 37.741635103508294 | -122.44996387489401 | (37.7416351035083, -122.449963874894) | ||||
| 107936 | 107936 | 118318 | Property Tree 7 | Maytenus boaria :: Mayten 22 | 20 Norton St | 1 | Front Yard : Yard 7 | Tree 1 | MTA 6 | 6002015.686319999 | 2092167.12899 | 37.724806667280895 | -122.435195459751 | (37.7248066672809, -122.435195459751) | |||||
| 1950 | 1950 | 252823 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 3852 17th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 20865 | 20865 | 103256 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 4187 26th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 3x3 | 6002700.0 | 2100625.0 | 37.7480688746475 | -122.433434000346 | (37.7480688746475, -122.433434000346) | |||
| 79494 | 79494 | 105555 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 410 Elizabeth St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 772516 | 6003623.1 | 2102191.9 | 37.7524235434098 | -122.430353733326 | (37.7524235434098, -122.430353733326) | ||||
| 88320 | 88320 | 105866 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 3555 Cesar Chavez St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | |||||
| 92493 | 92493 | 112481 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 1275 Columbus Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 126305 | 126305 | 105554 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 410 Elizabeth St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 772516 | 6003623.1 | 2102191.9 | 37.7524235434098 | -122.430353733326 | (37.7524235434098, -122.430353733326) | ||||
| 1491 | 1491 | 110535 | Private 5 | Maytenus boaria :: Mayten 22 | 100X ASHBURY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | Private 3 | 04/21/2015 04:52:00 PM | 3 | 3x3 | 5998750.0 | 2110223.0 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | |
| 103226 | 103226 | 104358 | Private 5 | Maytenus boaria :: Mayten 22 | 745X GOLDEN GATE AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3 | 6005986.0 | 2112447.0 | 37.7807151749226 | -122.42291120983299 | (37.7807151749226, -122.422911209833) | ||||
| 139788 | 139788 | 104400 | Private 5 | Maytenus boaria :: Mayten 22 | 755 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 5999044.0 | 2107976.0 | 37.768044800389 | -122.44660507122101 | (37.768044800389, -122.446605071221) | ||||
| 146018 | 146018 | 104109 | Private 5 | Maytenus boaria :: Mayten 22 | 342-346 MOULTRIE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x6 | 6007700.0 | 2097518.0 | 37.739820149686295 | -122.415924151926 | (37.7398201496863, -122.415924151926) | |||
| 3501 | 3501 | 247943 | Planning Code 138.1 required 4 | Maytenus boaria :: Mayten 22 | 29 Joy St | 6 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 2 | Permit Number 775404 | 6010304.2598 | 2098903.51059 | 37.7437705318851 | -122.407017307297 | (37.7437705318851, -122.407017307297) | |||
| 46 | 46 | 18228 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1737-1795 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2004 12:00:00 AM | 12 | 3X3 | 6003682.1522 | 2114179.2812 | 37.785341320174396 | -122.431004998109 | (37.7853413201744, -122.431004998109) | ||
| 202 | 202 | 138810 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2355 PINE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6002718.089 | 2115091.954 | 37.787792613821004 | -122.434405637805 | (37.787792613821, -122.434405637805) | |||
| 212 | 212 | 138800 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2375 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 0ft | 6002511.9355 | 2115060.8724 | 37.7876955676952 | -122.435116665287 | (37.7876955676952, -122.435116665287) | |||
| 237 | 237 | 2654 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1988 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2005 12:00:00 AM | 12 | 3X3 | 6004003.2237 | 2114978.8425 | 37.7875549020514 | -122.429951242636 | (37.7875549020514, -122.429951242636) | ||
| 278 | 278 | 9598 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1350 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003113.217999999 | 2112071.7207 | 37.7795222347306 | -122.43282272296999 | (37.7795222347306, -122.43282272297) | |||
| 686 | 686 | 23735 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 805 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2016 12:00:00 AM | 12 | 4X4 | 6003900.7925 | 2111534.0109 | 37.778090453740504 | -122.430059798517 | (37.7780904537405, -122.430059798517) | ||
| 753 | 753 | 48 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 810 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6003376.13457 | 2107738.85817 | 37.767640169485105 | -122.43160376032499 | (37.7676401694851, -122.431603760325) | |||
| 770 | 770 | 231129 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 821 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 3ft | 6003305.97559 | 2107686.68734 | 37.7674929441754 | -122.431842705671 | (37.7674929441754, -122.431842705671) | |||
| 893 | 893 | 18095 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 3001 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5999540.0604 | 2114647.8242 | 37.7863922432736 | -122.44536903339501 | (37.7863922432736, -122.445369033395) | |||
| 1155 | 1155 | 14734 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 895 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4x4 | 6004929.3578 | 2111921.9134 | 37.7792137381495 | -122.42652924677799 | (37.7792137381495, -122.426529246778) | |||
| 1353 | 1353 | 14712 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 845 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1993 12:00:00 AM | 8 | 4x4 | 6005208.5684 | 2111961.5273 | 37.779338288494 | -122.42556616152099 | (37.779338288494, -122.425566161521) | ||
| 1581 | 1581 | 111 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 955 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002518.0 | 2107623.0 | 37.767273374303706 | -122.43456365047399 | (37.7672733743037, -122.434563650474) | |||
| 1818 | 1818 | 139879 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 870 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/16/2000 12:00:00 AM | 12 | Width 0ft | 6005009.3284 | 2111993.411 | 37.779414573538205 | -122.42625768702801 | (37.7794145735382, -122.426257687028) | ||
| 1897 | 1897 | 245386 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 3243 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1998 12:00:00 AM | 6 | Width 0ft | 6006500.2854 | 2099391.485 | 37.7448967968639 | -122.420205198271 | (37.7448967968639, -122.420205198271) | ||
| 2124 | 2124 | 22782 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1866 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001070.0369 | 2112136.3428 | 37.7795835769795 | -122.439895576072 | (37.7795835769795, -122.439895576072) | |||
| 2458 | 2458 | 9644 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1495 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6002520.4964 | 2111934.6452 | 37.7791122249761 | -122.434863391819 | (37.7791122249761, -122.434863391819) | |||
| 2579 | 2579 | 14672 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 739 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005639.1537 | 2112019.7041 | 37.7795223479045 | -122.424080723662 | (37.7795223479045, -122.424080723662) | |||
| 2827 | 2827 | 18276 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1950 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002797.4872 | 2114109.7892 | 37.78510034529771 | -122.434060698947 | (37.7851003452977, -122.434060698947) | |||
| 3222 | 3222 | 5838 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 860 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1997 12:00:00 AM | 6 | 3X3 | 6006312.21276 | 2113211.9775099996 | 37.7828340176265 | -122.421837034768 | (37.7828340176265, -122.421837034768) | ||
| 3346 | 3346 | 139859 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 704 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005699.1313 | 2112090.0249 | 37.7797188177748 | -122.423878237045 | (37.7797188177748, -122.423878237045) | |||
| 3353 | 3353 | 139860 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 706 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/2016 12:00:00 AM | 8 | Width 0ft | 6005680.9512 | 2112087.9472 | 37.7797120865642 | -122.42394098222 | (37.7797120865642, -122.42394098222) | ||
| 3771 | 3771 | 47 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 810 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1998 12:00:00 AM | 6 | 3X3 | 6003389.5525400005 | 2107739.47109 | 37.7676426129451 | -122.431557393053 | (37.7676426129451, -122.431557393053) | ||
| 4327 | 4327 | 103839 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1552 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006685.2576 | 2116316.1212 | 37.791378262309706 | -122.420766896 | (37.7913782623097, -122.420766896) | ||
| 4535 | 4535 | 12416 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1660 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 6 | 4X4 | 6004502.1372 | 2114559.4680000003 | 37.786431646664205 | -122.428195201763 | (37.7864316466642, -122.428195201763) | ||
| 5150 | 5150 | 12412 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1620 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004511.4773 | 2114458.3749 | 37.786154598782396 | -122.428155680217 | (37.7861545987824, -122.428155680217) | |||
| 5265 | 5265 | 5279 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1350 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001320.5373 | 2113019.2025 | 37.7820219415228 | -122.43909228156001 | (37.7820219415228, -122.43909228156) | |||
| 5341 | 5341 | 19786 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY19 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 50ST | ||||||||
| 5438 | 5438 | 7826 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 807 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6006132.89126 | 2112941.5799 | 37.7820814577469 | -122.422438193788 | (37.7820814577469, -122.422438193788) | |||
| 5464 | 5464 | 18230 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1737-1795 Post St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2004 12:00:00 AM | 3 | 3X3 | 6003859.0712 | 2114201.8624 | 37.7854133456405 | -122.430394523724 | (37.7854133456405, -122.430394523724) | ||
| 5510 | 5510 | 20148 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1028 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1999 12:00:00 AM | 3 | 4X4 | 6002939.2419 | 2111824.3037 | 37.7788330206804 | -122.433406894695 | (37.7788330206804, -122.433406894695) | ||
| 5621 | 5621 | 6044 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1834 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001440.1248 | 2112530.373 | 37.780686543842705 | -122.43864352716801 | (37.7806865438427, -122.438643527168) | |||
| 5760 | 5760 | 20149 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1040 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002932.4508 | 2111847.2891 | 37.7788957475604 | -122.433432030761 | (37.7788957475604, -122.433432030761) | |||
| 5778 | 5778 | 24244 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 289X Willow St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6006236.37633 | 2113335.30136 | 37.7831683576867 | -122.42210816146499 | (37.7831683576867, -122.422108161465) | |||
| 5790 | 5790 | 18038 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2809 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000359.9496 | 2114756.9723 | 37.7867387044094 | -122.442540272299 | (37.7867387044094, -122.442540272299) | |||
| 6164 | 6164 | 5280 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1350 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001316.1378 | 2113050.3373 | 37.7821071794141 | -122.43910973392799 | (37.7821071794141, -122.439109733928) | |||
| 6207 | 6207 | 17935 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2426 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002142.0869 | 2115065.9831 | 37.787688592105205 | -122.436396634074 | (37.7876885921052, -122.436396634074) | |||
| 6320 | 6320 | 9597 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1340 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/1994 12:00:00 AM | 12 | 3X3 | 6003188.5795 | 2112083.2043 | 37.779558039769505 | -122.432562836067 | (37.7795580397695, -122.432562836067) | ||
| 6358 | 6358 | 14669 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 731 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 4x4 | 6005678.1934 | 2112026.9763 | 37.7795445196864 | -122.423946185798 | (37.7795445196864, -122.423946185798) | |||
| 6451 | 6451 | 17934 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2424 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002175.8086 | 2115067.4242 | 37.7876944650438 | -122.436280066856 | (37.7876944650438, -122.436280066856) | |||
| 6498 | 6498 | 18062 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2901 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1994 12:00:00 AM | 12 | 3X3 | 6000020.8872 | 2114713.4888 | 37.786599977163704 | -122.443710218956 | (37.7865999771637, -122.443710218956) | ||
| 6559 | 6559 | 18229 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1737-1795 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 6 | 3X3 | 6003704.9298 | 2114183.2083 | 37.7853533936228 | -122.43092647489901 | (37.7853533936228, -122.430926474899) | ||
| 6562 | 6562 | 17937 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2430 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002084.443 | 2115054.4543 | 37.7876536614139 | -122.436595244995 | (37.7876536614139, -122.436595244995) | |||
| 6908 | 6908 | 7825 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 807 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6006133.13296 | 2112953.34413 | 37.7821137730772 | -122.422438193776 | (37.7821137730772, -122.422438193776) | |||
| 7144 | 7144 | 20150 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1040 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002930.8836 | 2111873.4088 | 37.7789673768152 | -122.433439319366 | (37.7789673768152, -122.433439319366) | |||
| 7266 | 7266 | 17932 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2418 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002216.7357 | 2115077.2237 | 37.787723697261896 | -122.43613916872499 | (37.7877236972619, -122.436139168725) | |||
| 7350 | 7350 | 17974 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2519 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6001636.0692 | 2114939.9757 | 37.78731384268 | -122.438138324219 | (37.78731384268, -122.438138324219) | |||
| 7511 | 7511 | 17938 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2432 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4x4 | 6002059.6562 | 2115054.4543 | 37.7876522528246 | -122.436681002358 | (37.7876522528246, -122.436681002358) | |||
| 7565 | 7565 | 18105 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 3053 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999309.1186 | 2114616.1068 | 37.7862919697055 | -122.446165748193 | (37.7862919697055, -122.446165748193) | |||
| 7687 | 7687 | 5278 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1350 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001321.891 | 2113007.3577 | 37.781989495746394 | -122.439086749209 | (37.7819894957464, -122.439086749209) | |||
| 7757 | 7757 | 18225 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1675 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 6 | 3x3 | 6004149.2891 | 2114241.9195 | 37.7855397675254 | -122.42939331414699 | (37.7855397675254, -122.429393314147) | ||
| 7760 | 7760 | 14671 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 735 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 4x4 | 6005659.8218 | 2112023.5316 | 37.779534024179995 | -122.42400949606301 | (37.77953402418, -122.424009496063) | |||
| 7869 | 7869 | 18231 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1737-1795 Post St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 6 | 3X3 | 6003887.3468 | 2114207.7531 | 37.785431121654895 | -122.430297119046 | (37.7854311216549, -122.430297119046) | ||
| 8038 | 8038 | 18275 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1950 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002826.7788 | 2114117.8444 | 37.7851241251679 | -122.433959935292 | (37.7851241251679, -122.433959935292) | |||
| 8076 | 8076 | 17868 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2127 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/1992 12:00:00 AM | 12 | 3X3 | 6003572.046 | 2115203.4059 | 37.7881470684138 | -122.431459068113 | (37.7881470684138, -122.431459068113) | ||
| 8254 | 8254 | 19248 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 719 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002022.643999999 | 2111108.6569999997 | 37.7768159902052 | -122.43652652713999 | (37.7768159902052, -122.43652652714) | |||
| 8570 | 8570 | 17936 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2428 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002109.8063 | 2115059.6423 | 37.7876693476195 | -122.436507864526 | (37.7876693476195, -122.436507864526) | |||
| 8827 | 8827 | 12430 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1734 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 3 | 3X3 | 6004454.6634 | 2114845.8604 | 37.787215322181794 | -122.428379869098 | (37.7872153221818, -122.428379869098) | ||
| 8974 | 8974 | 9427 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 727 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1998 12:00:00 AM | 6 | 3X3 | 6005864.05119 | 2112400.08095 | 37.78057946490821 | -122.423329753784 | (37.7805794649082, -122.423329753784) | ||
| 9492 | 9492 | 4292 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 4338 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001697.8339599995 | 2100319.1603900003 | 37.7471722031488 | -122.43687755566299 | (37.7471722031488, -122.436877555663) | |||
| 9541 | 9541 | 5901 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1218 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2005 12:00:00 AM | 3 | 3X3 | 6001385.6835 | 2112540.5048 | 37.7807112660329 | -122.43883259166401 | (37.7807112660329, -122.438832591664) | ||
| 10131 | 10131 | 19871 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY33 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 10501 | 10501 | 17501 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 124 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6002114.94221 | 2091325.72307 | 37.722501991763004 | -122.434792202295 | (37.722501991763, -122.434792202295) | |||
| 11219 | 11219 | 213 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2933 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2X3 | 5990523.08308 | 2095701.4011400002 | 37.7338515654947 | -122.475181502731 | (37.7338515654947, -122.475181502731) | |||
| 11588 | 11588 | 17577 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 801X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/1992 12:00:00 AM | 10 | 3x3 | 6003802.45105 | 2090312.9257 | 37.719816736620395 | -122.428886697071 | (37.7198167366204, -122.428886697071) | ||
| 12307 | 12307 | 17505 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 137 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002178.53273 | 2091331.3237299998 | 37.7225209800456 | -122.434572784827 | (37.7225209800456, -122.434572784827) | |||
| 12365 | 12365 | 17561 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 644 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/1992 12:00:00 AM | 8 | 3X3 | 6003309.034969999 | 2090573.8726599999 | 37.7205052989509 | -122.430610872798 | (37.7205052989509, -122.430610872798) | ||
| 12433 | 12433 | 211 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2929 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2X3 | 5990523.61376 | 2095726.5411900003 | 37.7339206244383 | -122.475181502724 | (37.7339206244383, -122.475181502724) | |||
| 12849 | 12849 | 17560 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 636 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6003292.50024 | 2090584.1150200001 | 37.720532485468205 | -122.43066875855601 | (37.7205324854682, -122.430668758556) | |||
| 13261 | 13261 | 144 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 18 | 3x3 | 6002159.27678 | 2107619.02908 | 37.7672421007673 | -122.435804136578 | (37.7672421007673, -122.435804136578) | ||
| 13281 | 13281 | 19183 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 809X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/17/2001 12:00:00 AM | 18 | 3X3 | 6003428.49558 | 2107695.87949 | 37.7675251282004 | -122.431419581861 | (37.7675251282004, -122.431419581861) | ||
| 14146 | 14146 | 19784 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY19 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 50ST | ||||||||
| 14308 | 14308 | 19785 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY19 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 50ST | ||||||||
| 14579 | 14579 | 26113 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1505 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015456.7778 | 2095136.8611 | 37.7337150680783 | -122.38893804759701 | (37.7337150680783, -122.388938047597) | |||
| 15513 | 15513 | 26115 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1505 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015488.1057 | 2095113.7774 | 37.7336534213284 | -122.388828125884 | (37.7336534213284, -122.388828125884) | |||
| 16935 | 16935 | 10205 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1265 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/1994 12:00:00 AM | 12 | 2X2 | 6005835.28036 | 2101602.69371 | 37.750930777534705 | -122.422661770643 | (37.7509307775347, -122.422661770643) | ||
| 16939 | 16939 | 3879 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 5 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001986.3803 | 2108685.97385 | 37.7701618451199 | -122.436478532758 | (37.7701618451199, -122.436478532758) | |||
| 16972 | 16972 | 140 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/06/1997 12:00:00 AM | 7 | 3x3 | 6002065.74261 | 2107612.5408 | 37.7672189719923 | -122.436127192841 | (37.7672189719923, -122.436127192841) | ||
| 17007 | 17007 | 110 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 945 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002532.89226 | 2107646.47434 | 37.767338674478104 | -122.43451381896799 | (37.7673386744781, -122.434513818968) | |||
| 17091 | 17091 | 5182 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 443 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 2X2 | 6001670.04782 | 2110029.17719 | 37.7738319666993 | -122.43766893298599 | (37.7738319666993, -122.437668932986) | |||
| 17248 | 17248 | 5144 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 214 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001894.3899 | 2108883.7709 | 37.77069971914 | -122.43681088772699 | (37.77069971914, -122.436810887727) | |||
| 17254 | 17254 | 4103 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 3330 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/1998 12:00:00 AM | 3 | 3X3 | 6007495.85144 | 2100611.17884 | 37.7483018487501 | -122.41684910241399 | (37.7483018487501, -122.416849102414) | ||
| 17285 | 17285 | 5684 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1496 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6005204.76481 | 2099660.93456 | 37.745563560601795 | -122.42470403746401 | (37.7455635606018, -122.424704037464) | |||
| 17301 | 17301 | 158 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1095 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001530.2126 | 2107592.17995 | 37.7671326262835 | -122.437978050639 | (37.7671326262835, -122.437978050639) | |||
| 17346 | 17346 | 3877 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 7 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1999 12:00:00 AM | 3 | 3X3 | 6002026.39342 | 2108649.7395900004 | 37.770064628417394 | -122.436337534354 | (37.7700646284174, -122.436337534354) | ||
| 17351 | 17351 | 52 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 814 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6003333.6015 | 2107734.84158 | 37.767626730010704 | -122.43175058993201 | (37.7676267300107, -122.431750589932) | |||
| 17367 | 17367 | 4448 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1362 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6004481.19296 | 2100959.81807 | 37.7490891017952 | -122.427298546501 | (37.7490891017952, -122.427298546501) | |||
| 17374 | 17374 | 70 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 877 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003041.605930001 | 2107668.70427 | 37.7674285769945 | -122.432755839529 | (37.7674285769945, -122.432755839529) |
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");