Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82128 | 82128 | 39988 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 702 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | Permit Number 41246 | 6020313.39222717 | 2093680.55714076 | 37.729984337867705 | -122.37204636190701 | (37.7299843378677, -122.372046361907) | ||
| 178375 | 178375 | 201528 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6020307.12095 | 2093692.07813 | 37.7300156278056 | -122.372068839601 | (37.7300156278056, -122.372068839601) | |||
| 73500 | 73500 | 39990 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 714 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41248 | 6020251.6051199995 | 2093735.0931099998 | 37.730130688869295 | -122.372263742486 | (37.7301306888693, -122.372263742486) | |
| 76336 | 76336 | 201530 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 724 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6020205.16729 | 2093768.9038799999 | 37.7302209753954 | -122.37242662498899 | (37.7302209753954, -122.372426624989) | |||
| 181388 | 181388 | 39992 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 744 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41250 | 6020175.81777 | 2093790.38567 | 37.7302783476475 | -122.372529577584 | (37.7302783476475, -122.372529577584) | |
| 66551 | 66551 | 201656 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 748 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6020105.93205 | 2093842.3371599999 | 37.7304171562079 | -122.37277477954099 | (37.7304171562079, -122.372774779541) | |||
| 59918 | 59918 | 201657 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 748 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6020084.79381 | 2093857.53228 | 37.7304577174311 | -122.372848909746 | (37.7304577174311, -122.372848909746) | |||
| 132075 | 132075 | 39994 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 863 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2005 12:00:00 AM | 12 | 3x3 | Permit Number 41252 | 6019434.68731 | 2094262.5096 | 37.731533957726796 | -122.375124503897 | (37.7315339577268, -122.375124503897) |
| 183664 | 183664 | 40006 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 930 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 12 | Permit Number 41259 | 6019126.39744 | 2094573.6221900003 | 37.7323712445238 | -122.376211900284 | (37.7323712445238, -122.376211900284) | |
| 185929 | 185929 | 201502 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1099 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6018234.7860900005 | 2095166.37786 | 37.733949706701004 | -122.37933560007299 | (37.733949706701, -122.379335600073) | |||
| 108420 | 108420 | 40026 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Middle Point Rd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | Permit Number 41269 | 6018237.888375901 | 2095348.52577329 | 37.7344500201686 | -122.37933752244801 | (37.7344500201686, -122.379337522448) | |||
| 173204 | 173204 | 201501 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1099 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6018217.02471 | 2095179.1389799998 | 37.733983766719 | -122.379397893394 | (37.733983766719, -122.379397893394) | |||
| 92868 | 92868 | 11209 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1001X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | |||
| 93854 | 93854 | 11207 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1001X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/1999 12:00:00 AM | 3 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | ||
| 106837 | 106837 | 11212 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1001X Ingalls St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/14/2016 08:59:00 AM | 3 | 4X3 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | ||
| 119137 | 119137 | 11210 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1001X Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/14/2016 09:02:00 AM | 3 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | ||
| 140265 | 140265 | 11211 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1001X Ingalls St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2016 08:36:00 AM | 3 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | ||
| 123151 | 123151 | 38455 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 991 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.727463804070396 | -122.379579913535 | (37.7274638040704, -122.379579913535) | ||
| 15154 | 15154 | 11220 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/1998 12:00:00 AM | 12 | 3X4 | 6018137.92275 | 2094713.0843099998 | 37.732699709329204 | -122.37963900885799 | (37.7326997093292, -122.379639008858) | ||
| 71215 | 71215 | 188213 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1199 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6018109.9187 | 2094022.39232 | 37.730801659567206 | -122.37968785822099 | (37.7308016595672, -122.379687858221) | |||
| 15421 | 15421 | 11222 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050X Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2015 12:00:00 AM | 3 | 3X4 | 6018123.812969999 | 2094772.15079 | 37.7328611160499 | -122.379691892563 | (37.7328611160499, -122.379691892563) | ||
| 14734 | 14734 | 11223 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050X Ingalls St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/1992 12:00:00 AM | 35 | 3X4 | 6018117.580709999 | 2094794.3731799999 | 37.7329217906146 | -122.379714982678 | (37.7329217906146, -122.379714982678) | ||
| 16036 | 16036 | 11224 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050X Ingalls St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 3 | 3X4 | 6018109.81504 | 2094815.3391900002 | 37.7329789308191 | -122.379743287027 | (37.7329789308191, -122.379743287027) | ||
| 62398 | 62398 | 199966 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1235 Griffith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6018067.6906 | 2092802.2252 | 37.7274489886094 | -122.379749107759 | (37.7274489886094, -122.379749107759) | |||
| 124604 | 124604 | 11227 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050X Ingalls St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/1998 12:00:00 AM | 12 | 3X4 | 6018085.661882901 | 2094069.8743192002 | 37.7309306978843 | -122.379775016493 | (37.7309306978843, -122.379775016493) | ||
| 154656 | 154656 | 201401 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1051 Ingalls St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6018098.35359 | 2094705.9412599998 | 37.7326779133429 | -122.37977531459299 | (37.7326779133429, -122.379775314593) | |||
| 172472 | 172472 | 201394 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1051 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6018060.23644 | 2094824.70218 | 37.733001904899396 | -122.379915345332 | (37.7330019048994, -122.379915345332) | |||
| 73037 | 73037 | 188218 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 11 Rosie Lee Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6018038.291119999 | 2094428.2288 | 37.7319120561012 | -122.379963677596 | (37.7319120561012, -122.379963677596) | |||
| 67998 | 67998 | 199991 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1068 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6017994.8958 | 2092283.7607 | 37.7260213698028 | -122.379964752149 | (37.7260213698028, -122.379964752149) | |||
| 126694 | 126694 | 11234 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1100X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/1998 12:00:00 AM | 8 | 3X4 | 6018021.124713 | 2094004.401623 | 37.7307473625426 | -122.37999358681499 | (37.7307473625426, -122.379993586815) | ||
| 66437 | 66437 | 199945 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1210 Griffith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6017993.9927 | 2092780.4737 | 37.727385197779 | -122.380002373566 | (37.727385197779, -122.380002373566) | |||
| 76962 | 76962 | 74742 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1335 Griffith St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 9 | 6017895.1835 | 2092564.7892 | 37.7267875184409 | -122.38032897727501 | (37.7267875184409, -122.380328977275) | ||
| 159277 | 159277 | 75024 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1335 Griffith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 6 | 6017873.5405 | 2092533.5979 | 37.72670067896139 | -122.380401630434 | (37.7267006789614, -122.380401630434) | ||
| 33484 | 33484 | 75118 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1335 Griffith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 9 | 6017861.446 | 2092515.1377 | 37.7266493234609 | -122.38044215870701 | (37.7266493234609, -122.380442158707) | ||
| 14437 | 14437 | 1877 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 16 Beatrice Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6017871.97913 | 2094078.77448 | 37.7309433468436 | -122.380514379235 | (37.7309433468436, -122.380514379235) | |||
| 29356 | 29356 | 199936 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1320 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6017834.2799 | 2092562.1468 | 37.726776902275894 | -122.38053933798099 | (37.7267769022759, -122.380539337981) | |||
| 81068 | 81068 | 11254 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1145X Ingalls St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/1998 12:00:00 AM | 12 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | ||
| 152062 | 152062 | 188217 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 12 Lillian St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017866.54105 | 2094423.1335099998 | 37.7318885891874 | -122.380557106029 | (37.7318885891874, -122.380557106029) | |||
| 120070 | 120070 | 38483 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1116 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | Permit Number 40480 | 6017830.40993478 | 2092735.6877236 | 37.727253198437 | -122.38056477357401 | (37.727253198437, -122.380564773574) | |||
| 106201 | 106201 | 38457 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1115 Quesada Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | ||
| 111479 | 111479 | 38461 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1115 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | ||
| 161189 | 161189 | 199937 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1390 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6017806.3837 | 2092525.0044 | 37.726673377014706 | -122.380633194745 | (37.7266733770147, -122.380633194745) | |||
| 69806 | 69806 | 188214 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1200 Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017816.91744 | 2093947.7070400002 | 37.7305804227326 | -122.38069563131901 | (37.7305804227326, -122.380695631319) | |||
| 157976 | 157976 | 188216 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 12 Lillian St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6017813.27499 | 2094352.07269 | 37.7316905305754 | -122.38073632202699 | (37.7316905305754, -122.380736322027) | |||
| 77624 | 77624 | 38448 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1401 Griffith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | ||
| 95746 | 95746 | 38446 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1401 Griffith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | ||
| 89980 | 89980 | 38465 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1100 Revere Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.38080993565399 | (37.7264471943371, -122.380809935654) | ||
| 117719 | 117719 | 38469 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1100 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.38080993565399 | (37.7264471943371, -122.380809935654) | ||
| 64102 | 64102 | 200014 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1401 Griffith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6017741.1366 | 2092353.4521 | 37.7261987267401 | -122.38084683349399 | (37.7261987267401, -122.380846833494) | |||
| 46603 | 46603 | 12945 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 25 Lillian St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 6 | 3X3 | 6017779.247832701 | 2094371.1041299999 | 37.7317409092053 | -122.380855284503 | (37.7317409092053, -122.380855284503) | ||
| 144279 | 144279 | 11287 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1176X Ingalls St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2015 10:00:00 AM | 3 | 3X3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | ||
| 119679 | 119679 | 18801 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 11X Lillian St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017716.103612999 | 2094281.8506439999 | 37.7314923513917 | -122.381067386029 | (37.7314923513917, -122.381067386029) | ||
| 159190 | 159190 | 188215 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1200 Ingalls St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017679.77857 | 2093964.5807400001 | 37.730619185314296 | -122.381170918517 | (37.7306191853143, -122.381170918517) | |||
| 119556 | 119556 | 38464 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1160 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1998 12:00:00 AM | Permit Number 40473 | 6017581.82042544 | 2092920.99873262 | 37.7277483051936 | -122.381437035842 | (37.7277483051936, -122.381437035842) | |||
| 66734 | 66734 | 11306 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1201X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/1998 12:00:00 AM | 24 | 3X3 | 6017591.0151778 | 2093928.8426978001 | 37.7305161553992 | -122.38147530581499 | (37.7305161553992, -122.381475305815) | ||
| 71513 | 71513 | 38473 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | ||
| 101554 | 101554 | 38472 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | ||
| 122369 | 122369 | 38471 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | ||
| 76021 | 76021 | 200021 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1500 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6017538.0748 | 2092166.3042 | 37.72567364546789 | -122.381535805168 | (37.7256736454679, -122.381535805168) | |||
| 81911 | 81911 | 6547 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1225X Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/24/2011 12:00:00 AM | 3 | 4x4 | 6017625.4418446 | 2096995.6120179 | 37.738938797500296 | -122.381569480835 | (37.7389387975003, -122.381569480835) | ||
| 95601 | 95601 | 6544 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1225X Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2004 12:00:00 AM | 3 | 3X3 | 6017625.4418446 | 2096995.6120179 | 37.738938797500296 | -122.381569480835 | (37.7389387975003, -122.381569480835) | ||
| 139088 | 139088 | 6545 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1225X Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2015 09:12:00 AM | 3 | 3X3 | 6017625.4418446 | 2096995.6120179 | 37.738938797500296 | -122.381569480835 | (37.7389387975003, -122.381569480835) | ||
| 115222 | 115222 | 11322 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1216X Ingalls St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1993 12:00:00 AM | 0 | 3X3 | 6017561.7867095005 | 2093983.7658262001 | 37.7306653497809 | -122.38158017208 | (37.7306653497809, -122.38158017208) | ||
| 123268 | 123268 | 11321 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1216X Ingalls St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1999 12:00:00 AM | 8 | 3X3 | 6017561.7867095005 | 2093983.7658262001 | 37.7306653497809 | -122.38158017208 | (37.7306653497809, -122.38158017208) | ||
| 184366 | 184366 | 188061 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1241 Evans Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017553.88932 | 2097055.79305 | 37.739100091683895 | -122.381821063598 | (37.7391000916839, -122.381821063598) | |||
| 28877 | 28877 | 188060 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1241 Evans Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6017512.496169999 | 2097088.9484700002 | 37.7391888439962 | -122.381966489387 | (37.7391888439962, -122.381966489387) | |||
| 157677 | 157677 | 188059 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1241 Evans Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6017496.48371 | 2097099.74121 | 37.73921759440329 | -122.38202260437599 | (37.7392175944033, -122.382022604376) | |||
| 16870 | 16870 | 6554 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1275 Evans Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x8 | 6017477.53742 | 2097112.4140299999 | 37.7392513450766 | -122.382088994133 | (37.7392513450766, -122.382088994133) | |||
| 125684 | 125684 | 11338 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1279 Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2000 12:00:00 AM | 3 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.38209244081101 | (37.7305663998171, -122.382092440811) | ||
| 104513 | 104513 | 6555 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1275 Evans Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2004 12:00:00 AM | 3 | 3x3 | 6017367.643923099 | 2097188.6672174 | 37.7394546511947 | -122.382474264594 | (37.7394546511947, -122.382474264594) | ||
| 167322 | 167322 | 200079 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1297 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016898.7637 | 2093360.0183 | 37.728916032010204 | -122.383828952969 | (37.7289160320102, -122.383828952969) | |||
| 66342 | 66342 | 200078 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1297 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6016869.009 | 2093382.7401 | 37.7289767767356 | -122.383933399617 | (37.7289767767356, -122.383933399617) | |||
| 90514 | 90514 | 49344 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1603@ QUESADA Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2003 12:00:00 AM | Permit Number 46333 | 6016865.17482133 | 2093405.63049426 | 37.729039417289 | -122.38394824805 | (37.729039417289, -122.38394824805) | |||
| 99458 | 99458 | 49343 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1603@ QUESADA Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2003 12:00:00 AM | Permit Number 46333 | 6016865.17482133 | 2093405.63049426 | 37.729039417289 | -122.38394824805 | (37.729039417289, -122.38394824805) | |||
| 77773 | 77773 | 48974 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1609 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2002 12:00:00 AM | Permit Number 46161 | 6016855.54959465 | 2093392.70666779 | 37.7290033988911 | -122.383980623962 | (37.7290033988911, -122.383980623962) | |||
| 91866 | 91866 | 4759 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 33X Garlington Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/2011 12:00:00 AM | 3 | 3x3 | 6016785.1876546 | 2094686.7958143002 | 37.7325528215519 | -122.384313964135 | (37.7325528215519, -122.384313964135) | ||
| 121984 | 121984 | 8307 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 41 Garlington Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/1998 12:00:00 AM | 3 | 3X3 | 6016781.4771656 | 2094677.5253453997 | 37.7325271615192 | -122.384326146891 | (37.7325271615192, -122.384326146891) | ||
| 140010 | 140010 | 8309 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 41 Garlington Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/1998 12:00:00 AM | 3 | 3X3 | 6016781.4771656 | 2094677.5253453997 | 37.7325271615192 | -122.384326146891 | (37.7325271615192, -122.384326146891) | ||
| 88931 | 88931 | 8306 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 40 Garlington Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/1993 12:00:00 AM | 3 | 3X3 | 6016763.2740618 | 2094684.3635524 | 37.7325449313393 | -122.38438955609101 | (37.7325449313393, -122.384389556091) | ||
| 162926 | 162926 | 188212 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 10 Garlington Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6016745.546569999 | 2094555.70278 | 37.732190674145606 | -122.384441886807 | (37.7321906741456, -122.384441886807) | |||
| 14810 | 14810 | 4764 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 20 Commer Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6016747.24729 | 2094694.7761400002 | 37.7325726360097 | -122.384445690014 | (37.7325726360097, -122.384445690014) | |||
| 16730 | 16730 | 111884 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1415 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2015 12:00:00 AM | 3 | 3x3 | 6016650.17356 | 2096690.65464 | 37.738047550348 | -122.38492030003799 | (37.738047550348, -122.384920300038) | ||
| 70161 | 70161 | 188211 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 21 Commer Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6016598.21983 | 2094686.4594700001 | 37.7325415581292 | -122.384960339673 | (37.7325415581292, -122.384960339673) | |||
| 92812 | 92812 | 4765 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 25 Commer Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/1998 12:00:00 AM | 20 | 3X3 | 6016516.0463685 | 2094701.5331358002 | 37.7325784018492 | -122.38524548572799 | (37.7325784018492, -122.385245485728) | ||
| 49278 | 49278 | 188210 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 20 Commer Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6016492.38635 | 2094765.62976 | 37.7327530894828 | -122.38533174978399 | (37.7327530894828, -122.385331749784) | |||
| 124848 | 124848 | 4761 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 15 Commer Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2000 12:00:00 AM | 20 | 3X3 | 6016484.352950701 | 2094703.932641 | 37.7325832370534 | -122.38535522572701 | (37.7325832370534, -122.385355225727) | ||
| 128027 | 128027 | 82995 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1412 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52364 | 6016260.71862294 | 2093905.81391215 | 37.730379387125204 | -122.38607277339099 | (37.7303793871252, -122.386072773391) | ||
| 74922 | 74922 | 199861 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1412 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016220.7748 | 2093939.3471 | 37.730469251813204 | -122.386213202941 | (37.7304692518132, -122.386213202941) | |||
| 14273 | 14273 | 14873 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1409 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2006 12:00:00 AM | 12 | 3X3 | 6016102.3381 | 2095358.409 | 37.734359155897295 | -122.386721579123 | (37.7343591558973, -122.386721579123) | ||
| 171832 | 171832 | 46593 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1500 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 3 | Permit Number 44722 | 6016041.39566 | 2096866.9596 | 37.7384979569136 | -122.387037459737 | (37.7384979569136, -122.387037459737) | |
| 16827 | 16827 | 26123 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1443 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1988 12:00:00 AM | 12 | 3X3 | 6015874.9678 | 2094820.8647 | 37.7328705765106 | -122.387470191315 | (37.7328705765106, -122.387470191315) | ||
| 15237 | 15237 | 26122 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1447 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/2012 12:00:00 AM | 3 | 3X3 | 6015854.2463 | 2094834.679 | 37.7329073600996 | -122.38754279489599 | (37.7329073600996, -122.387542794896) | ||
| 174311 | 174311 | 52148 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1542 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 6 | Permit Number 48339 | 6015840.90736 | 2097015.91645 | 37.7388958583569 | -122.38774104790701 | (37.7388958583569, -122.387741047907) | |
| 131075 | 131075 | 188013 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 720 Illinois St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015981.64456 | 2105671.4836 | 37.7626700320247 | -122.387858232285 | (37.7626700320247, -122.387858232285) | |||
| 168885 | 168885 | 188012 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 720 Illinois St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015981.85051 | 2105686.87261 | 37.7627122983505 | -122.387858593818 | (37.7627122983505, -122.387858593818) | |||
| 187800 | 187800 | 188223 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 699 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6015788.5481900005 | 2097531.76582 | 37.740309374966 | -122.387958069605 | (37.740309374966, -122.387958069605) | |||
| 41363 | 41363 | 188222 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 699 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6015772.4529800005 | 2097506.68791 | 37.740239624455704 | -122.388011971371 | (37.7402396244557, -122.388011971371) | |||
| 48469 | 48469 | 188221 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 699 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6015754.24231 | 2097482.1230200003 | 37.7401711653638 | -122.38807322329599 | (37.7401711653638, -122.388073223296) | |||
| 80011 | 80011 | 26135 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1500 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/04/2014 12:00:00 AM | 3 | 5x5 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 89403 | 89403 | 26137 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1500 Oakdale Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/2012 12:00:00 AM | 3 | 5x5 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) |
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");