trees
27,746 rows where qCaretaker_id = 1 sorted by PermitNotes descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14210 | 85214 | - 12 | Jacaranda mimosifolia :: Jacaranda 50 | 2889 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/13/2007 12:00:00 AM | 3 | 3x3 | under 3yr maintenance agreement. ends on 4/13/2007 | 6009588.01504 | 2102148.81833 | 37.7526413233918 | -122.409722943913 | (37.7526413233918, -122.409722943913) | 2 | 4 | 7 | 28859 | 19 |
| 190505 | 85250 | - 12 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1335 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/19/2007 12:00:00 AM | 15 | 3x3 | under 3yr maintenance agreement. Expires 7/19/2010. | 6001350.12437 | 2111060.02557 | 37.7766442216524 | -122.438849483935 | (37.7766442216524, -122.438849483935) | 15 | 5 | 11 | 29492 | 10 |
| 163157 | 85249 | - 12 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1335 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/19/2007 12:00:00 AM | 3 | 3x3 | under 3 yr maintenance agreement. expires 7/19/2010 | 6001350.12437 | 2111060.02557 | 37.7766442216524 | -122.438849483935 | (37.7766442216524, -122.438849483935) | 15 | 5 | 11 | 29492 | 10 |
| 178928 | 191854 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 573 10th St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 24 | Width 6ft | tree is in ROW therefore DPW maintained | 6009977.72395 | 2108375.30106 | 37.7697596664942 | -122.408814503513 | (37.7697596664942, -122.408814503513) | 8 | 2 | 9 | 28853 | 34 | ||
| 31609 | 16684 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 262 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/1998 12:00:00 AM | 3 | 4x4 | privately planted on DPW street; unpermitted | 6002878.0000942 | 2106783.4724174 | 37.7649886658228 | -122.4332584684 | (37.7649886658228, -122.4332584684) | 15 | 5 | 5 | 28862 | 3 | |
| 57073 | 86829 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 258 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/13/2009 12:00:00 AM | 3 | 3x3 | privately planted on DPW street; unpermitted | 6002882.169263 | 2106798.606637 | 37.7650304572247 | -122.433245129787 | (37.7650304572247, -122.433245129787) | 15 | 5 | 5 | 28862 | 3 | |
| 157770 | 5356 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 220 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2015 03:17:00 PM | 3 | 6x6 | posted for removal 3/27/14 DPW | 6004796.95819 | 2107043.90776 | 37.7658124332187 | -122.426639815582 | (37.7658124332187, -122.426639815582) | 8 | 4 | 5 | 28862 | 3 | |
| 146966 | 110456 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 200X Masonic Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | next to cross walk | 5998971.77907 | 2112109.89902 | 37.7793913048339 | -122.447152418644 | (37.7793913048339, -122.447152418644) | 15 | 5 | 1 | 54 | 16 | |||
| 108194 | 21564 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1450 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 4X4 | dead | 6005645.68769 | 2114853.19648 | 37.7873027884337 | -122.424259698627 | (37.7873027884337, -122.424259698627) | 13 | 9 | 1 | 28858 | 41 | ||
| 15423 | 85309 | - 12 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/26/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.7706407896873 | -122.442827504693 | (37.7706407896873, -122.442827504693) | 15 | 5 | 11 | 29492 | 9 |
| 188548 | 85310 | - 12 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/27/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.7706407896873 | -122.442827504693 | (37.7706407896873, -122.442827504693) | 15 | 5 | 11 | 29492 | 9 |
| 80991 | 105000 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280X SAN MARCOS AVE | 1 | Median : Cutout | Tree | DPW 1 | 65 | Tree tag no. 416 | 5993063.2 | 2100277.9 | 37.7465643757171 | -122.466732187112 | (37.7465643757171, -122.466732187112) | 1 | 8 | 4 | 29491 | 40 | |||
| 180035 | 4148 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3631 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/17/1999 12:00:00 AM | 3 | 3X3 | She would like to be kept in the loop on what happens with this. | 6006082.4281665 | 2100506.5376626 | 37.7479349243864 | -122.421729258843 | (37.7479349243864, -122.421729258843) | 2 | 4 | 7 | 28859 | 22 | |
| 87616 | 86601 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1728 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/10/2011 12:00:00 AM | 3 | 3x3 | Replant with Acer rubrum 'Red Sunset' | 6009458 | 2106735 | 37.7652266534479 | -122.410496377801 | (37.7652266534479, -122.410496377801) | 8 | 4 | 7 | 28859 | 19 | |
| 26373 | 18941 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2782 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | Replace with P. Undulatum | 6001522.42549 | 2115673.82967 | 37.7893223527794 | -122.438584108286 | (37.7893223527794, -122.438584108286) | 13 | 6 | 1 | 29490 | 27 | ||
| 1215 | 253279 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | ROW IS 10' tree is street tree | |||||||||||||
| 19664 | 93051 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1555X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/09/2010 12:00:00 AM | 3 | 3x3 | Planted for DPW by FUF | 6015509.3 | 2098161.9 | 37.7420241196322 | -122.388967590374 | (37.7420241196322, -122.388967590374) | 10 | 3 | 8 | 58 | 1 | |
| 44041 | 93052 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1555X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/09/2010 12:00:00 AM | 3 | 3x3 | Planted by FUF for BUF | 6015509.3 | 2098161.9 | 37.7420241196322 | -122.388967590374 | (37.7420241196322, -122.388967590374) | 10 | 3 | 8 | 58 | 1 | |
| 194279 | 249475 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Van Ness Ave | 2 | Median : Yard | Tree | DPW 1 | 18 | Permit Number 787880 | 6006389.52859 | 2114780.40651 | 37.7871448980627 | -122.421680989782 | (37.7871448980627, -122.421680989782) | 13 | 9 | 1 | 28858 | 21 | |||
| 194258 | 175137 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1802 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | Width 4ft | Permit Number 785586 | 6001243.74865 | 2091600.63197 | 37.7232073291514 | -122.437823395139 | (37.7232073291514, -122.437823395139) | 9 | 7 | 6 | 28861 | 25 | ||
| 194280 | 171105 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1802 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | Permit Number 785586 | 6001198.95061 | 2091509.82624 | 37.7229554497111 | -122.437971751813 | (37.7229554497111, -122.437971751813) | 9 | 7 | 6 | 28861 | 25 | ||
| 194285 | 171104 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1802 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | Permit Number 785586 | 6001222.88972 | 2091557.90636 | 37.7230888281699 | -122.437892441496 | (37.7230888281699, -122.437892441496) | 9 | 7 | 6 | 28861 | 25 | ||
| 194286 | 171103 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1802 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | Permit Number 785586 | 6001233.28844 | 2091580.94986 | 37.7231526917255 | -122.437858144945 | (37.7231526917255, -122.437858144945) | 9 | 7 | 6 | 28861 | 25 | ||
| 17461 | 2783 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 424 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/17/2020 12:00:00 AM | 3 | 3X3 | Permit Number 785448 | 5994280.27723 | 2110781.18915 | 37.7754738485256 | -122.463285730589 | (37.7754738485256, -122.463285730589) | 11 | 6 | 2 | 54 | 11 | |
| 13228 | 197239 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 830 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 4x4 | Permit Number 785334 | 6011827.26305 | 2104492.53285 | 37.7592018783746 | -122.40214394589 | (37.7592018783746, -122.40214394589) | 10 | 3 | 8 | 28856 | 29 | ||
| 18558 | 220932 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 56 Mirabel Ave | 1 | Front Yard : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 785183 | 6007687.03242 | 2099968.45973 | 37.7465478380206 | -122.416142489803 | (37.7465478380206, -122.416142489803) | 2 | 7 | 7 | 28859 | 2 | ||
| 194261 | 15784 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4840 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2015 02:53:00 PM | 3 | 3X3 | Permit Number 785142 | 6001135.2157 | 2090596.8347 | 37.7204449566644 | -122.438126700052 | (37.7204449566644, -122.438126700052) | 9 | 7 | 6 | 28861 | 25 | |
| 194263 | 15782 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4840 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/06/2015 12:38:00 PM | 3 | 3X3 | Permit Number 785142 | 6001159.6334 | 2090631.0194 | 37.7205402088092 | -122.438044743528 | (37.7205402088092, -122.438044743528) | 9 | 7 | 6 | 28861 | 25 | |
| 194266 | 15786 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4840 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/04/2013 12:00:00 AM | 12 | 3x3 | Permit Number 785142 | 6001077.7653 | 2090502.844 | 37.7201836118857 | -122.43831855702 | (37.7201836118857, -122.43831855702) | 9 | 7 | 6 | 28861 | 25 | |
| 194268 | 15788 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4840 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2020 12:00:00 AM | 12 | 3X3 | Permit Number 785142 | 6001054.6013 | 2090473.5841 | 37.7201019532463 | -122.438396531841 | (37.7201019532463, -122.438396531841) | 9 | 7 | 6 | 28861 | 25 | |
| 194271 | 15783 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4840 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2015 03:01:00 PM | 3 | 3X3 | Permit Number 785142 | 6001146.6106 | 2090614.741 | 37.7204947713768 | -122.43808859365 | (37.7204947713768, -122.43808859365) | 9 | 7 | 6 | 28861 | 25 | |
| 6828 | 131262 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2711 Union St | 2 | Front Yard : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 785082 | 6000010.78683 | 2118118.88771 | 37.7959497330364 | -122.443989935801 | (37.7959497330364, -122.443989935801) | 13 | 9 | 1 | 57 | 17 | ||
| 1965 | 195920 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 15 Baldwin Ct | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 12 | 4x4 | Permit Number 784616 | 6017944.92051 | 2093525.02511 | 37.7294268839465 | -122.380223738131 | (37.7294268839465, -122.380223738131) | 10 | 3 | 8 | 58 | 1 | ||
| 8002 | 212121 | DPW Maintained 1 | Tree(s) :: 17 | 2101x Monterey Blvd | 3 | Median : Yard | Tree | DPW 1 | 11/27/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 784468 | 5991651 | 2095488 | 37.7333309287491 | -122.471266448142 | (37.7333309287491, -122.471266448142) | 9 | 8 | 4 | 59 | 40 | |
| 12418 | 4841 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 142 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x9 | Permit Number 784458 | 6006480.03392 | 2097559.50493 | 37.7398654498357 | -122.420145233727 | (37.7398654498357, -122.420145233727) | 2 | 7 | 7 | 28859 | 2 | ||
| 1077 | 149677 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011154.9566 | 2106050.92707 | 37.7634433311543 | -122.404578819881 | (37.7634433311543, -122.404578819881) | 8 | 3 | 8 | 28856 | 29 | |
| 3416 | 262187 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 4 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
| 8898 | 149678 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 2 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
| 18413 | 149679 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 3 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
| 19354 | 262188 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 490 Vermont St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784452 | 6011166 | 2106075 | 37.7635100471883 | -122.404542318782 | (37.7635100471883, -122.404542318782) | 8 | 3 | 8 | 28856 | 29 | |
| 13199 | 261348 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 784323 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 16027 | 261349 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 784323 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 126116 | 236828 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 11 Woodland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/10/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 783065 | 5997011.57389 | 2106623.6128 | 37.7642151878129 | -122.453537316698 | (37.7642151878129, -122.453537316698) | 15 | 5 | 11 | 29492 | 12 | |
| 946 | 133881 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2864 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 4ft | Permit Number 782825 | 5999916.99907 | 2117104.86853 | 37.7931601538699 | -122.444241554422 | (37.7931601538699, -122.444241554422) | 13 | 9 | 1 | 57 | 27 | ||
| 4186 | 133880 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2864 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 4ft | Permit Number 782825 | 5999941.97757 | 2117109.13743 | 37.7931733001669 | -122.444155434443 | (37.7931733001669, -122.444155434443) | 13 | 9 | 1 | 57 | 27 | ||
| 11115 | 580 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3013 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 782763 | 6008848.9981 | 2102129.16474 | 37.7525459176681 | -122.412277214445 | (37.7525459176681, -122.412277214445) | 2 | 4 | 7 | 28859 | 19 | ||
| 14425 | 582 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 3013 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/1992 12:00:00 AM | 12 | 3x3 | Permit Number 782763 | 6008818.92095 | 2102127.6459 | 37.7525400594852 | -122.412381119401 | (37.7525400594852, -122.412381119401) | 2 | 4 | 7 | 28859 | 19 | |
| 187682 | 12736 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1625 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2019 12:00:00 AM | 3 | 3X3 | Permit Number 782752 | 5990372.3863 | 2114714.93418 | 37.7860489118948 | -122.477091430633 | (37.7860489118948, -122.477091430633) | 11 | 6 | 2 | 55 | 26 | |
| 14578 | 252915 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1924 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782602 | 6007321 | 2118975 | 37.7987146929528 | -122.418755881393 | (37.7987146929528, -122.418755881393) | 5 | 1 | 10 | 28858 | 32 | |
| 14665 | 256768 | DPW Maintained 1 | Tree(s) :: 17 | 900 Brotherhood Way | 7 | Front Yard : Yard | Tree | DPW 1 | 09/25/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782397 | 5987917.15522 | 2088760.91322 | 37.7146433748779 | -122.483682180705 | (37.7146433748779, -122.483682180705) | 1 | 8 | 4 | 64 | 14 | |
| 126498 | 231439 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101x Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | 18 | Width 5ft | Permit Number 782331 | 5999775.11781 | 2101292.59964 | 37.7497355659558 | -122.443596051626 | (37.7497355659558, -122.443596051626) | 2 | 4 | 5 | 28862 | 38 | ||
| 132685 | 231438 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101x Portola Dr | 1 | Median : Cutout | Tree | DPW 1 | 18 | Width 5ft | Permit Number 782331 | 5999777.38069 | 2101303.64449 | 37.7497660214977 | -122.443589019842 | (37.7497660214977, -122.443589019842) | 2 | 4 | 5 | 28862 | 38 | ||
| 72404 | 90852 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2439 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782290 | 5987980.63943 | 2110496.20326 | 37.7743264199702 | -122.485056492221 | (37.7743264199702, -122.485056492221) | 11 | 6 | 2 | 55 | 26 | |
| 183431 | 10960 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1430 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2018 12:00:00 AM | 3 | 3X4 | Permit Number 782059 | 6016587.34912 | 2096809.91728 | 37.7383715463994 | -122.385145824822 | (37.7383715463994, -122.385145824822) | 10 | 3 | 8 | 58 | 1 | |
| 15309 | 16874 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 269 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781998 | 6005705.9301 | 2110300.3269 | 37.7748051262311 | -122.423727430112 | (37.7748051262311, -122.423727430112) | 7 | 9 | 11 | 28852 | 10 | |
| 3705 | 244981 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/31/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005180.5539 | 2109687.8318 | 37.7730936920725 | -122.425501217452 | (37.7730936920725, -122.425501217452) | 7 | 9 | 11 | 28852 | 10 |
| 124127 | 4189 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3854 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/17/1998 12:00:00 AM | 6 | 3X3 | Permit Number 781750 | 6004813.31142 | 2100488.37375 | 37.747813401782 | -122.426116518959 | (37.747813401782, -122.426116518959) | 2 | 4 | 5 | 63 | 22 | |
| 155396 | 1522 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 422 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2013 12:00:00 AM | 3 | 3X3 | Permit Number 781664 | 5995605.60631 | 2113581.85062 | 37.7832399843175 | -122.458903950762 | (37.7832399843175, -122.458903950762) | 11 | 6 | 1 | 54 | 31 | |
| 179045 | 19350 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 618 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781612 | 5992350.09465 | 2089866.75515 | 37.7179367902328 | -122.468440675709 | (37.7179367902328, -122.468440675709) | 9 | 8 | 6 | 64 | 24 | |
| 146709 | 254547 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2908 Bush St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 02/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781446 | 5999588.42992 | 2114352.40043 | 37.7855838475934 | -122.445180440387 | (37.7855838475934, -122.445180440387) | 15 | 6 | 1 | 29490 | 31 | |
| 51452 | 2624 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1822 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781445 | 6004615.6699 | 2115060.0567 | 37.7878125608959 | -122.427838089219 | (37.7878125608959, -122.427838089219) | 13 | 9 | 11 | 28858 | 27 | |
| 7398 | 13267 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000572.6787 | 2119285.0637 | 37.7991837803388 | -122.442129440006 | (37.7991837803388, -122.442129440006) | 13 | 9 | 1 | 57 | 17 | |
| 8764 | 13266 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000592.3683 | 2119282.3787 | 37.7991775301158 | -122.442061114605 | (37.7991775301158, -122.442061114605) | 13 | 9 | 1 | 57 | 17 | |
| 17749 | 13265 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000636.2224 | 2119294.0135 | 37.7992119752158 | -122.441910200363 | (37.7992119752158, -122.441910200363) | 13 | 9 | 1 | 57 | 17 | |
| 121417 | 53916 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 319 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 01/09/2018 12:00:00 AM | 3 | Permit Number 781053 | 6012951.97966 | 2105523.30262 | 37.7620948589082 | -122.398326431733 | (37.7620948589082, -122.398326431733) | 10 | 3 | 8 | 28856 | 29 | |
| 190939 | 13063 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 590 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2017 12:00:00 AM | 3 | 2X2 | Permit Number 780933 | 6009554.3361 | 2120533.7978 | 37.803120257284 | -122.411137959105 | (37.803120257284, -122.411137959105) | 3 | 1 | 10 | 308 | 23 | |
| 639 | 261347 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 15290 | 25338 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 90207 | 6932 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 500 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | Permit Number 780762 | 6004980.8762 | 2110598.20876 | 37.7755820815859 | -122.426256755638 | (37.7755820815859, -122.426256755638) | 7 | 9 | 11 | 28852 | 10 | ||
| 142334 | 12245 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 503 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2015 03:15:00 PM | 3 | 5x5 | Permit Number 780762 | 6004995.5845 | 2110652.4736 | 37.7757319109571 | -122.426209740207 | (37.7757319109571, -122.426209740207) | 7 | 9 | 11 | 28852 | 10 | |
| 73655 | 253718 | Significant Tree 6 | Acer buergeranum :: Trident Maple 110 | 227 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | Permit Number 780760 | 6005690 | 2092595 | 37.7261894743752 | -122.422524168298 | (37.7261894743752, -122.422524168298) | 9 | 7 | 7 | 309 | 5 | ||
| 27355 | 239457 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 165 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001959.66963 | 2096487.1672 | 37.7366653238346 | -122.435698035437 | (37.7366653238346, -122.435698035437) | 2 | 7 | 5 | 63 | 7 | |
| 90355 | 222216 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 3ft | Permit Number 780743 | 6002014.89564 | 2096488.79408 | 37.7366729276156 | -122.435507211887 | (37.7366729276156, -122.435507211887) | 2 | 7 | 5 | 63 | 7 | ||
| 115391 | 224618 | Planning Code 138.1 required 2 | Ficus microcarpa :: Chinese Banyan 97 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | 2 | 7 | 5 | 63 | 7 | ||
| 159683 | 239458 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 165 Sussex St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001977.4736 | 2096494.97635 | 37.7366877772239 | -122.435637038029 | (37.7366877772239, -122.435637038029) | 2 | 7 | 5 | 63 | 7 | |
| 152110 | 239088 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 3855 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3x3 | Permit Number 780732 | 6004794.15723 | 2100737.40071 | 37.748496089722 | -122.426200479689 | (37.748496089722, -122.426200479689) | 2 | 4 | 5 | 63 | 22 | ||
| 50450 | 27604 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 988 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003185.1314 | 2111389.5656 | 37.7776532852192 | -122.43252520607 | (37.7776532852192, -122.43252520607) | 15 | 9 | 11 | 29492 | 41 | |
| 56063 | 27606 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 988 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003145.1713 | 2111385.063 | 37.7776386560762 | -122.432663119808 | (37.7776386560762, -122.432663119808) | 15 | 9 | 11 | 29492 | 41 | |
| 194310 | 264995 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
| 194314 | 214535 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
| 194317 | 264994 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
| 30794 | 10153 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 978 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2016 06:51:00 AM | 3 | 3x3 | Permit Number 780464 | 6005672.85931 | 2103292.97405 | 37.7555627312558 | -122.423343584439 | (37.7555627312558, -122.423343584439) | 2 | 4 | 5 | 28859 | 19 | |
| 95306 | 10595 | DPW Maintained 1 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 | 1098 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 38 | 3X3 | Permit Number 780455 | 6010831.52232 | 2110575.81704 | 37.7758495624369 | -122.406016267448 | (37.7758495624369, -122.406016267448) | 14 | 2 | 9 | 28853 | 34 | ||
| 154883 | 10596 | DPW Maintained 1 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 | 1098 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | Permit Number 780455 | 6010813.59233 | 2110557.81798 | 37.7757991383537 | -122.406077023861 | (37.7757991383537, -122.406077023861) | 14 | 2 | 9 | 28853 | 34 | ||
| 116843 | 71631 | DPW Maintained 1 | Laurus x 'Saratoga' :: Hybrid Laurel 4 | 678 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | Permit Number 780356 | 5984775.35157 | 2111233.16415 | 37.7761626774292 | -122.496198392825 | (37.7761626774292, -122.496198392825) | 11 | 6 | 2 | 55 | 26 | |
| 28191 | 4983 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5300 Diamond Heights Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/10/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780192 | 6001475.6363 | 2098933.58975 | 37.7433551224547 | -122.437546687242 | (37.7433551224547, -122.437546687242) | 2 | 7 | 5 | 63 | 7 | |
| 71822 | 4982 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5300 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/31/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780192 | 6001462.73007 | 2098944.10019 | 37.7433832478516 | -122.437592066128 | (37.7433832478516, -122.437592066128) | 2 | 7 | 5 | 63 | 7 | |
| 81420 | 17844 | DPW Maintained 1 | Tree(s) :: 17 | 2064 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/03/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780190 | 6004071.9084 | 2115331.7333 | 37.7885277407175 | -122.429738786656 | (37.7885277407175, -122.429738786656) | 13 | 9 | 11 | 29490 | 27 | |
| 8205 | 200857 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1117 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | Width 0ft | Permit Number 780155 | 6008905.5117 | 2112149.5313 | 37.7800626991558 | -122.412790138104 | (37.7800626991558, -122.412790138104) | 8 | 2 | 9 | 28853 | 34 | ||
| 17301 | 13943 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1101 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Permit Number 780155 | 6008953.3362 | 2112197.3558 | 37.7801966980589 | -122.412628072717 | (37.7801966980589, -122.412628072717) | 8 | 2 | 9 | 28853 | 34 | |||
| 51230 | 13736 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | Permit Number 780155 | 6010795.99203 | 2114077.59841 | 37.7854626460159 | -122.406385972454 | (37.7854626460159, -122.406385972454) | 14 | 2 | 10 | 28852 | 6 | ||
| 61771 | 13737 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | Permit Number 780155 | 6010751.43772 | 2114034.04518 | 37.7853405666668 | -122.40653704776 | (37.7853405666668, -122.40653704776) | 14 | 2 | 10 | 28852 | 6 | ||
| 78775 | 200856 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1117 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 0ft | Permit Number 780155 | 6008896.2254 | 2112159.7462 | 37.7800902256084 | -122.412822986117 | (37.7800902256084, -122.412822986117) | 8 | 2 | 9 | 28853 | 34 | ||
| 161421 | 13941 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1101 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | Permit Number 780155 | 6008943.5856 | 2112207.5707 | 37.7802241984973 | -122.412662526962 | (37.7802241984973, -122.412662526962) | 8 | 2 | 9 | 28853 | 34 | ||
| 121821 | 42970 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1150 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/05/2000 12:00:00 AM | 12 | 3x3 | Permit Number 780074 | 6007984.36875 | 2092053.86438 | 37.7248328006832 | -122.414554361714 | (37.7248328006832, -122.414554361714) | 9 | 3 | 7 | 309 | 28 |
| 126179 | 7171 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003475.9145 | 2111120.5411 | 37.7769310959731 | -122.431500078765 | (37.7769310959731, -122.431500078765) | 15 | 9 | 11 | 29492 | 10 | ||
| 149806 | 7172 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003478.684 | 2111101.7087 | 37.7768795438362 | -122.431489153471 | (37.7768795438362, -122.431489153471) | 15 | 9 | 11 | 29492 | 10 | ||
| 181278 | 7170 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003473.1451 | 2111141.589 | 37.7769887313283 | -122.43151116193 | (37.7769887313283, -122.43151116193) | 15 | 9 | 11 | 29492 | 10 | ||
| 189104 | 7169 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003470.3756 | 2111160.9753 | 37.7770418043343 | -122.431522126808 | (37.7770418043343, -122.431522126808) | 15 | 9 | 11 | 29492 | 10 | ||
| 183025 | 26841 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | Permit Number 779930 | 6006975.88726 | 2110943.04151 | 37.7766414730488 | -122.419379980819 | (37.7766414730488, -122.419379980819) | 7 | 9 | 9 | 28852 | 36 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );