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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 6812 | 6812 | 26676 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2261 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002690.1285 | 2114739.216 | 37.786822497954 | -122.434477145422 | (37.786822497954, -122.434477145422) | |||
| 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) | |||
| 6927 | 6927 | 2732 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2257 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002711.9331 | 2114741.6938 | 37.786830539072206 | -122.434401883901 | (37.7868305390722, -122.434401883901) | |||
| 7038 | 7038 | 24234 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 200X Willow St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006430.34404 | 2113385.60278 | 37.78331741132 | -122.42144068376699 | (37.78331741132, -122.421440683767) | |||
| 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) | |||
| 7151 | 7151 | 9599 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1355 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1990 12:00:00 AM | 11 | 3X3 | 6003022.227000001 | 2112007.7178 | 37.7793413376686 | -122.43313292513201 | (37.7793413376686, -122.433132925132) | ||
| 7171 | 7171 | 9447 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 3 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005622.1957 | 2112431.3933 | 37.780651788182794 | -122.424168675479 | (37.7806517881828, -122.424168675479) | |||
| 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) | |||
| 7512 | 7512 | 9485 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 847 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2002 12:00:00 AM | 3 | 3X3 | 6005536.7021 | 2112359.7712 | 37.7804503039159 | -122.424459343214 | (37.7804503039159, -122.424459343214) | ||
| 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) | |||
| 7570 | 7570 | 9448 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 4 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 05/18/1992 12:00:00 AM | 12 | 3X3 | 6005590.2441 | 2112426.5193 | 37.78063660125729 | -122.424278864743 | (37.7806366012573, -122.424278864743) | ||
| 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) | |||
| 7740 | 7740 | 9445 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/01/1994 12:00:00 AM | 12 | 3X3 | 6005680.1419 | 2112439.5166 | 37.780677364386705 | -122.423968789396 | (37.7806773643867, -122.423968789396) | ||
| 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) | |||
| 7816 | 7816 | 102821 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 340 Presidio Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 46302 | 5999104.35672 | 2115397.03086 | 37.7884244867562 | -122.44693038434099 | (37.7884244867562, -122.446930384341) | ||
| 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) | ||
| 7945 | 7945 | 111904 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1944 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009089.4426 | 2119974.7658 | 37.801559212533604 | -122.41270719679301 | (37.8015592125336, -122.412707196793) | |||
| 7992 | 7992 | 111123 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2196 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5997448.8282 | 2109892.6608 | 37.773216211211 | -122.45226088690201 | (37.773216211211, -122.452260886902) | |||
| 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) | |||
| 8507 | 8507 | 13147 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1833 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6003597.2465 | 2119627.9507 | 37.8002971624487 | -122.431687899053 | (37.8002971624487, -122.431687899053) | |||
| 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) | |||
| 8588 | 8588 | 64901 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2100 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/1989 12:00:00 AM | 5 | 3x3 | 6003335.09871 | 2115955.0637 | 37.7901974974694 | -122.4323325691 | (37.7901974974694, -122.4323325691) | ||
| 8746 | 8746 | 9484 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 843 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005554.0072 | 2112361.9898 | 37.7804573728678 | -122.42439963452699 | (37.7804573728678, -122.424399634527) | |||
| 8748 | 8748 | 5273 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1320 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001321.5525 | 2112995.5129 | 37.7819569536833 | -122.439087071085 | (37.7819569536833, -122.439087071085) | |||
| 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) | ||
| 8853 | 8853 | 88238 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2196 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 18 | 3x3 | Permit Number 51227 | 5997416.147000001 | 2109885.795 | 37.77319548724729 | -122.45237343940201 | (37.7731954872473, -122.452373439402) | |
| 8920 | 8920 | 9449 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 5 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005556.1262 | 2112420.5622 | 37.780618317973 | -122.424396471178 | (37.780618317973, -122.424396471178) | |||
| 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) | ||
| 9061 | 9061 | 66 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 854 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 5.5x3.5 | 6003138.2570065 | 2107725.378034 | 37.767589670380296 | -122.432425585191 | (37.7675896703803, -122.432425585191) | |||
| 9143 | 9143 | 12567 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 311 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1992 12:00:00 AM | 6 | 3X3 | 5994495.46055 | 2114856.8855 | 37.786677009426604 | -122.462837112849 | (37.7866770094266, -122.462837112849) | ||
| 9198 | 9198 | 18049 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2827 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x4 | 6000144.0199 | 2114731.2352 | 37.7866557263604 | -122.443285486254 | (37.7866557263604, -122.443285486254) | |||
| 9236 | 9236 | 18060 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2895 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1990 12:00:00 AM | 10 | 3x4 | 6000123.5175 | 2114727.3092 | 37.7866437774494 | -122.443356137293 | (37.7866437774494, -122.443356137293) | ||
| 9258 | 9258 | 18059 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2895 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1990 12:00:00 AM | 6 | 3x4 | 6000110.4309 | 2114723.8195 | 37.786633449363606 | -122.443401162869 | (37.7866334493636, -122.443401162869) | ||
| 9334 | 9334 | 5282 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1350 Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6001308.3541 | 2113100.7621 | 37.782245190157106 | -122.43914027710301 | (37.7822451901571, -122.439140277103) | |||
| 9352 | 9352 | 5283 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1350 Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4X4 | 6001306.3236 | 2113123.0979 | 37.7823064030289 | -122.43914890306499 | (37.7823064030289, -122.439148903065) | |||
| 9412 | 9412 | 17939 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2445 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1991 12:00:00 AM | 6 | 3x3 | 6002249.5312774 | 2115023.8576257 | 37.7875790308508 | -122.43602188230601 | (37.7875790308508, -122.436021882306) | ||
| 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) | ||
| 9572 | 9572 | 100227 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 542 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Permit Number 769993 | 6002426.0 | 2099190.0 | 37.7441131524814 | -122.434278904907 | (37.7441131524814, -122.434278904907) | |||
| 9674 | 9674 | 61426 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3501X 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1984 12:00:00 AM | Permit Number 21355 | 6006351.47468928 | 2100870.60661273 | 37.7489497429973 | -122.420824749243 | (37.7489497429973, -122.420824749243) | ||
| 9704 | 9704 | 104747 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2-X FORD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6003502.9 | 2105705.5 | 37.762064243675106 | -122.431020153892 | (37.7620642436751, -122.431020153892) | ||||
| 9729 | 9729 | 173667 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 37 Ford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003363.0 | 2105606.0 | 37.7617831123707 | -122.431496910184 | (37.7617831123707, -122.431496910184) | ||||
| 9733 | 9733 | 173666 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 37 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003363.0 | 2105606.0 | 37.7617831123707 | -122.431496910184 | (37.7617831123707, -122.431496910184) | ||||
| 10074 | 10074 | 60000 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1227 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2017 12:00:00 AM | 3 | Permit Number 19486 | 5991400.84514705 | 2107067.03072332 | 37.76510946688521 | -122.472975370228 | (37.7651094668852, -122.472975370228) | |
| 10131 | 10131 | 19871 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY33 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 10149 | 10149 | 173884 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100X Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2017 12:00:00 AM | 3 | 3x3 | |||||||
| 10171 | 10171 | 173890 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2593 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989209.0 | 2097724.0 | 37.7393288482101 | -122.479872589648 | (37.7393288482101, -122.479872589648) | ||||
| 10173 | 10173 | 173893 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2593 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989209.0 | 2097724.0 | 37.7393288482101 | -122.479872589648 | (37.7393288482101, -122.479872589648) | ||||
| 10257 | 10257 | 101048 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3050 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008765.0 | 2105072.0 | 37.7606215625409 | -122.41277572810101 | (37.7606215625409, -122.412775728101) | ||||
| 10261 | 10261 | 101049 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3050 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008765.0 | 2105072.0 | 37.7606215625409 | -122.41277572810101 | (37.7606215625409, -122.412775728101) | ||||
| 10328 | 10328 | 51740 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2034 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2005 12:00:00 AM | 4 | Permit Number 48017 | 5989452.1138 | 2101481.869 | 37.7496610947618 | -122.479306857855 | (37.7496610947618, -122.479306857855) | ||
| 10356 | 10356 | 75141 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 5 | 4x4 | 6005823.096940001 | 2092308.52948 | 37.7254103965462 | -122.422043716969 | (37.7254103965462, -122.422043716969) | |
| 10433 | 10433 | 50855 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 638 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | 8 | 6x9 | Permit Number 47370 | 6002852.60741 | 2089781.5433900002 | 37.718303870103 | -122.432132042771 | (37.718303870103, -122.432132042771) | |
| 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) | |||
| 10568 | 10568 | 75056 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 12 | 4x4 | 6005836.26564 | 2092311.52216 | 37.7254193565072 | -122.421998406407 | (37.7254193565072, -122.421998406407) | |
| 10885 | 10885 | 75223 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 5 | 3x3 | 6005812.42229 | 2092304.2308200002 | 37.7253979913003 | -122.42208031306801 | (37.7253979913003, -122.422080313068) | |
| 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) | |||
| 11430 | 11430 | 214 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2933 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X3 | 5990522.122690001 | 2095686.58843 | 37.7338108378948 | -122.47518374203699 | (37.7338108378948, -122.475183742037) | |||
| 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) | ||
| 11652 | 11652 | 75299 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 3x3 | 6005800.51839 | 2092301.4633900002 | 37.7253897211337 | -122.422121267299 | (37.7253897211337, -122.422121267299) | |
| 11717 | 11717 | 61760 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3739 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1984 12:00:00 AM | Permit Number 21774 | |||||||
| 11810 | 11810 | 30642 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1500 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | Permit Number 34585 | ||||||||
| 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) | |||
| 12317 | 12317 | 75378 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 3x3 | 6005787.8485 | 2092298.2096 | 37.7253800723092 | -122.422164834944 | (37.7253800723092, -122.422164834944) | |
| 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) | ||
| 12389 | 12389 | 44404 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1171 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 6 | 5x5 | Permit Number 43757 | 6001253.36024 | 2087074.10385 | 37.710779041984296 | -122.437466181726 | (37.7107790419843, -122.437466181726) |
| 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) | |||
| 13193 | 13193 | 17566 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 701X Persia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1992 12:00:00 AM | 25 | 4.5x6 | 6003419.22785 | 2090557.86639 | 37.7204675912996 | -122.43022883000201 | (37.7204675912996, -122.430228830002) | ||
| 13258 | 13258 | 60325 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 335 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/2017 12:00:00 AM | 3 | Permit Number 779431 | 5986505.891009999 | 2113659.48607 | 37.7829258811438 | -122.49039060665001 | (37.7829258811438, -122.49039060665) | |
| 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) | ||
| 14041 | 14041 | 101151 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 390X Missouri St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5x9 | 6013467.3769 | 2105274.43287 | 37.7614402136082 | -122.39652641256001 | (37.7614402136082, -122.39652641256) | |||
| 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) | |||
| 14999 | 14999 | 28358 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1955 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2003 12:00:00 AM | 8 | 3x3 | 6012974.457669999 | 2096638.4172 | 37.737700123351395 | -122.39762549833999 | (37.7377001233514, -122.39762549834) | ||
| 15410 | 15410 | 30596 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 451 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34563 | ||||||||
| 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) | |||
| 16505 | 16505 | 30597 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 461 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34564 | ||||||||
| 16871 | 16871 | 61522 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1177 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 7 | 4x4 | Permit Number 772962 | 6012251.69921 | 2102932.86135 | 37.754943044411796 | -122.40056647116 | (37.7549430444118, -122.40056647116) |
| 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) | |||
| 16944 | 16944 | 28347 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 65 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2006 12:00:00 AM | 5 | 3X3 | 6006083.33794 | 2097822.75855 | 37.740565925489896 | -122.421535536156 | (37.7405659254899, -122.421535536156) | ||
| 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) | |||
| 17321 | 17321 | 15618 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3515 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1995 12:00:00 AM | 3 | 3X3 | 6005697.125 | 2097900.8869 | 37.7407586639333 | -122.42287646425801 | (37.7407586639333, -122.422876464258) | ||
| 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) |
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");