Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 123326 | 123326 | 48658 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 601 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2003 12:00:00 AM | Permit Number 45947 | 5992474.12537509 | 2103859.88961246 | 37.7563655794475 | -122.469029766101 | (37.7563655794475, -122.469029766101) | ||
| 123327 | 123327 | 19476 | DPW Maintained 3 | Eucalyptus lehmanni :: Bushy Yate 267 | 1900X Sloat Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 20 | 5984946.1404685 | 2095883.2432036998 | 37.734026040705 | -122.49447578991699 | (37.734026040705, -122.494475789917) | |||
| 123328 | 123328 | 48011 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1921 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45734 | 5991237.8181056995 | 2102332.85604348 | 37.7521012359965 | -122.473193942643 | (37.7521012359965, -122.473193942643) | ||
| 123329 | 123329 | 88999 | Permitted Site 1 | Tree(s) :: 17 | 2218 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2008 12:00:00 AM | 3x3 | Permit Number 51747 | 5999369.0 | 2116393.0 | 37.7911742716773 | -122.446086430907 | (37.7911742716773, -122.446086430907) | ||
| 123330 | 123330 | 84225 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1361 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50686 | 6011917.47723073 | 2088615.29524593 | 37.7156113688947 | -122.400716532679 | (37.7156113688947, -122.400716532679) | ||
| 123331 | 123331 | 46240 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 160 King St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2002 12:00:00 AM | Permit Number 44534 | 6015164.29463736 | 2111614.90461458 | 37.778944043146204 | -122.39110062088999 | (37.7789440431462, -122.39110062089) | |||
| 123332 | 123332 | 104232 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 298X Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2015 12:00:00 AM | 3 | 6x6 | Permit Number 771309 | 5997366.55609 | 2109687.30332 | 37.772647639236204 | -122.452530652813 | (37.7726476392362, -122.452530652813) | |
| 123333 | 123333 | 50654 | Permitted Site 1 | Tree(s) :: 17 | 2824 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | Permit Number 47236 | 6004394.14845271 | 2118840.16150037 | 37.7981792344265 | -122.428874109151 | (37.7981792344265, -122.428874109151) | |||
| 123334 | 123334 | 97254 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 601 Tompkins Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | Permit Number 768271 | 6008616.2 | 2096553.7 | 37.7372238594213 | -122.412688154144 | (37.7372238594213, -122.412688154144) | |||
| 123335 | 123335 | 50027 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1704 Felton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46757 | 6005996.45076047 | 2092411.63801237 | 37.7257032858692 | -122.42145176694599 | (37.7257032858692, -122.421451766946) | ||
| 123336 | 123336 | 86754 | Permitted Site 1 | Tree(s) :: 17 | 1376 06th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | Permit Number 49715 | 5994310.3 | 2106169.4 | 37.7628128189867 | -122.462847225894 | (37.7628128189867, -122.462847225894) | ||||
| 123337 | 123337 | 19200 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 199X Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003554.8234858 | 2107093.0395024 | 37.765877034625795 | -122.430939601641 | (37.7658770346258, -122.430939601641) | |||
| 123338 | 123338 | 49140 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 130 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2003 12:00:00 AM | Permit Number 46429 | 5995159.93409274 | 2093558.50432473 | 37.7282353512387 | -122.458995514447 | (37.7282353512387, -122.458995514447) | ||
| 123339 | 123339 | 107555 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
| 123340 | 123340 | 113566 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 123341 | 123341 | 117622 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 890x VERMONT ST | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 6011292.0 | 2104239.0 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | |||||
| 123342 | 123342 | 98942 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400X San Bruno Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 3x3 | 6011147.5 | 2101806.3 | 37.7517881116631 | -122.40430583648501 | (37.7517881116631, -122.404305836485) | ||
| 123343 | 123343 | 11935 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 660X Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017236.56511 | 2096428.9556383 | 37.7373613939034 | -122.38287462596399 | (37.7373613939034, -122.382874625964) | |||
| 123344 | 123344 | 13232 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2301 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/12/1995 12:00:00 AM | 10 | 3X3 | 6001301.0 | 2119283.0 | 37.7992195934801 | -122.439609056557 | (37.7992195934801, -122.439609056557) | ||
| 123345 | 123345 | 99500 | Permitted Site 1 | Aesculus hippocastanum :: White Horsechestnut 364 | 2698@Divisadero Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000656.0 | 2117555.0 | 37.7944382299983 | -122.44171689194401 | (37.7944382299983, -122.441716891944) | |||||
| 123346 | 123346 | 42750 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 123347 | 123347 | 116289 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 123348 | 123348 | 32918 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 438 Hugo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37249 | 5994422.15833953 | 2107041.67313449 | 37.7652142959667 | -122.46252362442101 | (37.7652142959667, -122.462523624421) | ||
| 123349 | 123349 | 114804 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2427 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | Permit Number 775689 | 5989172.0 | 2098830.2 | 37.742364035662796 | -122.480081453283 | (37.7423640356628, -122.480081453283) | |||
| 123350 | 123350 | 39250 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3168 Cesar Chavez St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.41298280187401 | (37.7483859278404, -122.412982801874) | |||
| 123351 | 123351 | 115457 | Permitted Site 1 | Tree(s) :: 17 | 476 FAIR OAKS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005502.0 | 2100939.0 | 37.7490896185955 | -122.423767101444 | (37.7490896185955, -122.423767101444) | ||||
| 123352 | 123352 | 34057 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1718 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37959 | 6009442.90556489 | 2106775.8067624 | 37.7653378532253 | -122.410551467879 | (37.7653378532253, -122.410551467879) | ||
| 123353 | 123353 | 44124 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 751 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/29/2000 12:00:00 AM | Permit Number 43628 | 5981028.36208653 | 2110606.15983469 | 37.774220913121 | -122.509113438342 | (37.774220913121, -122.509113438342) | |||
| 123354 | 123354 | 47041 | Permitted Site 1 | Acer spp :: Maple 158 | 50 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | 1 | 3x3 | Permit Number 45032 | 6004340.5553933 | 2108752.14114491 | 37.7704770161634 | -122.428340177957 | (37.7704770161634, -122.428340177957) | |
| 123355 | 123355 | 39877 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 301 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | |||
| 123356 | 123356 | 35927 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 22 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | Permit Number 39097 | 6005564.10753047 | 2097077.73566378 | 37.738490969573 | -122.423277889221 | (37.738490969573, -122.423277889221) | ||
| 123357 | 123357 | 34213 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 137 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38029 | 6010403.59737914 | 2099053.11250995 | 37.7441868646564 | -122.40668436049499 | (37.7441868646564, -122.406684360495) | ||
| 123358 | 123358 | 60155 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1668 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 19686 | 5990610.46669896 | 2104039.03153173 | 37.7567495994005 | -122.47548796034401 | (37.7567495994005, -122.475487960344) | ||
| 123359 | 123359 | 40789 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 27 Urbano Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41740 | 5993852.22414759 | 2092279.20351858 | 37.7246474428237 | -122.463423485902 | (37.7246474428237, -122.463423485902) | ||
| 123360 | 123360 | 24806 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7253 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 5984468.16229 | 2112417.35948 | 37.7793961372971 | -122.497348468163 | (37.7793961372971, -122.497348468163) | |||
| 123361 | 123361 | 117295 | Significant Tree 6 | Tree(s) :: 17 | 130 CAMBON DR | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5990450.0 | 2089482.0 | 37.7167704112637 | -122.47498033116501 | (37.7167704112637, -122.474980331165) | ||||
| 123362 | 123362 | 76037 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/16/1996 12:00:00 AM | 6 | 4x6 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | |
| 123363 | 123363 | 46741 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 21 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44848 | 5993934.28224784 | 2089153.42556477 | 37.71606953632679 | -122.462913152344 | (37.7160695363268, -122.462913152344) | ||
| 123364 | 123364 | 108758 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1449 PAGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999638.3 | 2109087.9 | 37.7711317264146 | -122.44462938571199 | (37.7711317264146, -122.444629385712) | |||||
| 123365 | 123365 | 45753 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 806 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2001 12:00:00 AM | Permit Number 44399 | 6011825.65444004 | 2104622.45579414 | 37.7595585281932 | -122.402158643537 | (37.7595585281932, -122.402158643537) | |||
| 123366 | 123366 | 12369 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1335 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004408.00965 | 2113459.2839 | 37.7834054897746 | -122.428442413333 | (37.7834054897746, -122.428442413333) | |||
| 123367 | 123367 | 50367 | Permitted Site 1 | Grevillea robusta :: Silk Oak Tree 145 | 4288-4298 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2004 12:00:00 AM | Permit Number 47283 | 6001343.34114851 | 2101761.08186739 | 37.751111221395796 | -122.438206640079 | (37.7511112213958, -122.438206640079) | |||
| 123368 | 123368 | 110244 | Permitted Site 1 | Tree(s) :: 17 | 2582 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2015 12:00:00 AM | 3 | Permit Number 775248 | 6000594.1 | 2118607.8 | 37.7973254142876 | -122.442006676457 | (37.7973254142876, -122.442006676457) | ||
| 123369 | 123369 | 42926 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 500 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43380 | 6009210.68116468 | 2105903.38929548 | 37.7629293730529 | -122.411293045793 | (37.7629293730529, -122.411293045793) | ||
| 123370 | 123370 | 88381 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 423 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51359 | 5990873.7 | 2112494.8 | 37.779982110660896 | -122.475194900005 | (37.7799821106609, -122.475194900005) | |||
| 123371 | 123371 | 38167 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 315 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40305 | 6010555.26362325 | 2092792.3936381 | 37.7270047480515 | -122.405719032848 | (37.7270047480515, -122.405719032848) | ||
| 123372 | 123372 | 116663 | DPW Maintained 3 | Araucaria araucana :: Monkey puzzle 154 | 199x Esmeralda Ave | 16 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 123373 | 123373 | 51248 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 684 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47625 | 6007471.15651424 | 2105682.67696043 | 37.7622256337552 | -122.417293833991 | (37.7622256337552, -122.417293833991) | ||
| 123374 | 123374 | 58602 | Permitted Site 1 | Tree(s) :: 17 | 718 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1979 12:00:00 AM | Permit Number 17808 | 5997971.89469326 | 2107987.65011821 | 37.7680154907799 | -122.450314190437 | (37.7680154907799, -122.450314190437) | |||
| 123375 | 123375 | 46077 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 814 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2001 12:00:00 AM | Permit Number 44458 | 6003949.63841524 | 2110800.90118746 | 37.7760802817088 | -122.429838518249 | (37.7760802817088, -122.429838518249) | |||
| 123376 | 123376 | 50565 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 619 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2003 12:00:00 AM | Permit Number 47187 | 5998098.1621261 | 2095312.01092038 | 37.733218530780704 | -122.448964249181 | (37.7332185307807, -122.448964249181) | ||
| 123377 | 123377 | 21176 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985027.9083074005 | 2099542.6271361 | 37.744078511576 | -122.49446276258301 | (37.744078511576, -122.494462762583) | |||
| 123378 | 123378 | 45403 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 45 De Soto St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2001 12:00:00 AM | Permit Number 44210 | 5992987.43170266 | 2091499.81031742 | 37.722457556714 | -122.466356320506 | (37.722457556714, -122.466356320506) | ||
| 123379 | 123379 | 28428 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2499 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991618.4954 | 2094538.91045 | 37.730723086818706 | -122.471309697155 | (37.7307230868187, -122.471309697155) | ||
| 123380 | 123380 | 59422 | Permitted Site 1 | Tree(s) :: 17 | 63 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1980 12:00:00 AM | Permit Number 18782 | 6004316.22615658 | 2097855.02307008 | 37.7405547185192 | -122.42764782556999 | (37.7405547185192, -122.42764782557) | |||
| 123381 | 123381 | 39391 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
| 123382 | 123382 | 50541 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 60 29th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180.0 | 2099188.0 | 37.74432002092679 | -122.421298240567 | (37.7443200209268, -122.421298240567) | |||
| 123383 | 123383 | 38420 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1542 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42357 | 6004548.16357043 | 2099910.23270392 | 37.7462109701995 | -122.426992216906 | (37.7462109701995, -122.426992216906) | ||
| 123384 | 123384 | 3295 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 4721 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2005 12:00:00 AM | 6 | 3X3 | 5992917.64909 | 2114121.4523400003 | 37.784566708473 | -122.468242393585 | (37.784566708473, -122.468242393585) | ||
| 123385 | 123385 | 57193 | Permitted Site 1 | Tree(s) :: 17 | 633 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/1974 12:00:00 AM | Permit Number 14473 | 6007510.46945444 | 2113541.05571027 | 37.7838050881462 | -122.417714890881 | (37.7838050881462, -122.417714890881) | |||
| 123386 | 123386 | 50671 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 4333 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | Permit Number 47251 | 6001749.56821679 | 2100564.10310624 | 37.747847698036104 | -122.43671619374399 | (37.7478476980361, -122.436716193744) | |||
| 123387 | 123387 | 40698 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | Permit Number 41678 | 6006308.40202986 | 2093422.77537775 | 37.7284972327963 | -122.420445112942 | (37.7284972327963, -122.420445112942) | |||
| 123388 | 123388 | 2257 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 700X Brotherhood Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |||
| 123389 | 123389 | 55034 | Permitted Site 1 | Tree(s) :: 17 | 433 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | Permit Number 10913 | 6003465.03949638 | 2103873.80420057 | 37.7570326996362 | -122.431020362108 | (37.7570326996362, -122.431020362108) | |||
| 123390 | 123390 | 119724 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 123391 | 123391 | 57536 | Permitted Site 1 | Tree(s) :: 17 | 300 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1976 12:00:00 AM | Permit Number 16395 | 6004402.26000103 | 2096454.97863083 | 37.7367153805698 | -122.42725065000099 | (37.7367153805698, -122.427250650001) | |||
| 123392 | 123392 | 113322 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6004079.74050315 | 2108375.213269 | 37.7694273021614 | -122.42921545709 | (37.7694273021614, -122.42921545709) | ||||
| 123393 | 123393 | 86413 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1843 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 05:00:00 PM | 3 | 3x3 | 5988125.881073 | 2102762.3473509997 | 37.7530998280813 | -122.48398684731801 | (37.7530998280813, -122.483986847318) | ||
| 123394 | 123394 | 114040 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 40 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | |||
| 123395 | 123395 | 46466 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3310X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2002 12:00:00 AM | 12 | 3x3 | Permit Number 44668 | 6002328.64862435 | 2119517.88465055 | 37.7999229605029 | -122.436069860968 | (37.7999229605029, -122.436069860968) | |
| 123396 | 123396 | 49518 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1483 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2006 12:00:00 AM | Permit Number 46423 | 6005507.92497714 | 2114781.52271548 | 37.7870982103643 | -122.42473122826 | (37.7870982103643, -122.42473122826) | |||
| 123397 | 123397 | 27568 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 123398 | 123398 | 29159 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 532 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 8 | 3x3 | 6008904.683107 | 2114354.7787345 | 37.7861177338401 | -122.412948968266 | (37.7861177338401, -122.412948968266) | ||
| 123399 | 123399 | 5784 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 529 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003264.5891464995 | 2108312.4032751 | 37.769208661335504 | -122.432030542626 | (37.7692086613355, -122.432030542626) | |||
| 123400 | 123400 | 57947 | Permitted Site 1 | Tree(s) :: 17 | 12 Byron Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | Permit Number 16906 | 5999407.80723315 | 2086738.68680627 | 37.7097529637216 | -122.443820730773 | (37.7097529637216, -122.443820730773) | |||
| 123401 | 123401 | 109201 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 123402 | 123402 | 98170 | Significant Tree 6 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 2324 Sacramento St | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/22/2011 12:00:00 AM | 3 | Permit Number 768454 | 6003670.2 | 2115963.1 | 37.7902385582714 | -122.43117371849199 | (37.7902385582714, -122.431173718492) | |||
| 123403 | 123403 | 89284 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 160 Vicksburg St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2008 12:00:00 AM | 3x3 | Permit Number 51893 | 6004103.0 | 2102285.0 | 37.752706346041606 | -122.42870079588499 | (37.7527063460416, -122.428700795885) | ||
| 123404 | 123404 | 24445 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2251X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1995 12:00:00 AM | 3 | 3X3 | 6015765.11922 | 2105348.0588 | 37.7617699797552 | -122.388584545263 | (37.7617699797552, -122.388584545263) | ||
| 123405 | 123405 | 57203 | Permitted Site 1 | Tree(s) :: 17 | 2449 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/1975 12:00:00 AM | Permit Number 14484 | 5992011.00283657 | 2098772.83003559 | 37.742371058875605 | -122.47026095479201 | (37.7423710588756, -122.470260954792) | |||
| 123406 | 123406 | 87742 | Permitted Site 1 | Morus alba :: White Mulberry 112 | 1725 Mason St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50405 | 6009154.0 | 2119215.0 | 37.7994767072274 | -122.41243006353399 | (37.7994767072274, -122.412430063534) | |||
| 123407 | 123407 | 228327 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Rose St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006141.43109 | 2109876.17462 | 37.7736650804216 | -122.422190799263 | (37.7736650804216, -122.422190799263) | |||
| 123408 | 123408 | 238943 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 601 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009029.7299 | 2105069.8621099996 | 37.7606305476811 | -122.411859992851 | (37.7606305476811, -122.411859992851) | |||
| 123409 | 123409 | 238738 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 540 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008934.980269999 | 2105835.53395 | 37.7627275913403 | -122.412241807236 | (37.7627275913403, -122.412241807236) | |||
| 123410 | 123410 | 51321 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2604 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | 12 | Permit Number 47748 | 6001576.65847 | 2116992.3974099997 | 37.7929458832083 | -122.438490979888 | (37.7929458832083, -122.438490979888) | ||
| 123411 | 123411 | 50768 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | 5 | Permit Number 47301 | 6019728.52002 | 2094123.20714 | 37.7311676233867 | -122.374099009669 | (37.7311676233867, -122.374099009669) | ||
| 123412 | 123412 | 38815 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 204 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1998 12:00:00 AM | 8 | Permit Number 40651 | 5994944.16478 | 2114141.25002 | 37.78473790153421 | -122.461232820546 | (37.7847379015342, -122.461232820546) | |
| 123413 | 123413 | 193901 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014663.2882199995 | 2110608.1620400003 | 37.7761519396893 | -122.392763367653 | (37.7761519396893, -122.392763367653) | |||
| 123414 | 123414 | 212570 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 746 Myra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5997447.591519999 | 2098022.0057599996 | 37.7406222958753 | -122.45140882825301 | (37.7406222958753, -122.451408828253) | |||
| 123415 | 123415 | 247578 | DPW Maintained 3 | Eucalyptus camaldulensis :: River Red Gum 340 | 300x Alemany Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 43 | 6008699.141969999 | 2095317.61632 | 37.733834496346 | -122.412314043462 | (37.733834496346, -122.412314043462) | ||||
| 123416 | 123416 | 221842 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 5 Marsily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 2ft | 6004251.52018 | 2095424.7771400001 | 37.7338781539609 | -122.427698444448 | (37.7338781539609, -122.427698444448) | |||
| 123417 | 123417 | 247871 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6009746.3542 | 2098404.30325 | 37.742368581453704 | -122.40891120669201 | (37.7423685814537, -122.408911206692) | ||||
| 123418 | 123418 | 194185 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1100 19th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6014258.375 | 2105287.7993 | 37.7615209034762 | -122.393791593112 | (37.7615209034762, -122.393791593112) | |||
| 123419 | 123419 | 97459 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 198x Venus St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2012 12:00:00 AM | 7 | 3x3 | Permit Number 769335 | 6012779.459869999 | 2093933.7450599999 | 37.7302627947816 | -122.398110010771 | (37.7302627947816, -122.398110010771) | |
| 123420 | 123420 | 178181 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 491 La Grande Ave | 5 | : Yard 23 | Tree 1 | Private 1 | 23 | 6004429.890380001 | 2089255.59598 | 37.7169490333536 | -122.42664260617501 | (37.7169490333536, -122.426642606175) | ||||
| 123421 | 123421 | 93111 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 7 | 3x3 | Permit Number 53024 | 6016584.37921 | 2098370.12887 | 37.742655406712295 | -122.38526477996099 | (37.7426554067123, -122.385264779961) | |
| 123422 | 123422 | 126352 | Undocumented 2 | Corymbia maculata :: Spotted Gum 165 | 502 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6012121.48389 | 2117472.15309 | 37.794857349936294 | -122.402038861028 | (37.7948573499363, -122.402038861028) | |||
| 123423 | 123423 | 114660 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1603 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6004469.8992 | 2114403.3025 | 37.786001031208 | -122.428295602978 | (37.786001031208, -122.428295602978) | |||
| 123424 | 123424 | 203715 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 310 Vicente St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5991940.55717 | 2097770.8819999998 | 37.7396158915521 | -122.470431578674 | (37.7396158915521, -122.470431578674) | |||
| 123425 | 123425 | 200225 | Undocumented 2 | Tristania conferta :: 79 | 3098 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014353.5321 | 2090113.0139 | 37.7198593794464 | -122.392401052747 | (37.7198593794464, -122.392401052747) |
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");