Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 501 | 501 | 251171 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:21:00 AM | 3 | ||||||||
| 1132 | 1132 | 188688 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1300 Evans Ave | 37 | : 4 | Tree 1 | DPW 2 | 03/18/2017 02:16:00 PM | 3 | Width 4ft | 6017441.41972 | 2097257.16832 | 37.739646816543996 | -122.382223941884 | (37.739646816544, -122.382223941884) | ||
| 3134 | 3134 | 44852 | Permitted Site 1 | Tree(s) :: 17 | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5023 | 5023 | 3601 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:11:00 AM | 3 | 3X3 | 6018206.00756 | 2098069.0742900004 | 37.7419183484432 | -122.379636687689 | (37.7419183484432, -122.379636687689) | ||
| 6103 | 6103 | 44532 | Permitted Site 1 | Tree(s) :: 17 | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 9353 | 9353 | 12157 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016176.76201 | 2095719.00601 | 37.73535340295211 | -122.386489403775 | (37.7353534029521, -122.386489403775) | |||
| 9567 | 9567 | 48195 | Permitted Site 1 | Tree(s) :: 17 | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 9599 | 9599 | 45926 | Permitted Site 1 | Tree(s) :: 17 | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 10003 | 10003 | 173619 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10720 | 10720 | 19638 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 13156 | 13156 | 20391 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 262X Sunset Blvd | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 14592 | 14592 | 51137 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 16472 | 16472 | 11547 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018868.04549 | 2097199.54045 | 37.7395672742039 | -122.377287229525 | (37.7395672742039, -122.377287229525) | |||
| 16519 | 16519 | 3732 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017092.791180001 | 2098843.12861 | 37.7439822808577 | -122.383539742673 | (37.7439822808577, -122.383539742673) | |||
| 19129 | 19129 | 12492 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 21425 | 21425 | 11754 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991270.92454 | 2092589.2026099998 | 37.725349564621204 | -122.472369212969 | (37.7253495646212, -122.472369212969) | ||
| 25644 | 25644 | 126371 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 1306x Montgomery St | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6011427.3089 | 2120158.66 | 37.8021950785935 | -122.404630029046 | (37.8021950785935, -122.404630029046) | |||
| 27943 | 27943 | 201789 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6015483.8795300005 | 2088094.9602400002 | 37.7143809005356 | -122.388353026664 | (37.7143809005356, -122.388353026664) | |||
| 29248 | 29248 | 187101 | Undocumented 2 | Melaleuca styphelliodes :: Paperbark Tree 239 | 2600 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5985154.9931 | 2097213.6802 | 37.7376912868614 | -122.49385174405501 | (37.7376912868614, -122.493851744055) | |||
| 29281 | 29281 | 186449 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1601 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984739.2681 | 2103899.1733 | 37.7560234949851 | -122.49578209696301 | (37.7560234949851, -122.495782096963) | |||
| 29985 | 29985 | 193072 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 37 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6015318.00876 | 2098725.46335 | 37.7435609430974 | -122.38966837242201 | (37.7435609430974, -122.389668372422) | |||
| 31743 | 31743 | 249705 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Baker St | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 5999691.230359999 | 2117200.88619 | 37.793410910039896 | -122.44502963123101 | (37.7934109100399, -122.445029631231) | ||||
| 32582 | 32582 | 181404 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 0ft | 5984893.3996 | 2104690.5846 | 37.7582055161201 | -122.49530742906799 | (37.7582055161201, -122.495307429068) | |||
| 33033 | 33033 | 223700 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6004786.16622 | 2096652.60405 | 37.7372797190785 | -122.42593738210199 | (37.7372797190785, -122.425937382102) | ||||
| 34150 | 34150 | 211157 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 300x Marietta Dr | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 5ft | 5999448.78231 | 2097518.60545 | 37.7393544676471 | -122.444453333051 | (37.7393544676471, -122.444453333051) | |||
| 35608 | 35608 | 194288 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6014411.93404 | 2095259.01392 | 37.733992504551296 | -122.392558950849 | (37.7339925045513, -122.392558950849) | ||||
| 36196 | 36196 | 250612 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 7ft | 5998863.03763 | 2111421.5701099997 | 37.7774951176523 | -122.447479040039 | (37.7774951176523, -122.447479040039) | |||
| 36731 | 36731 | 220173 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6004965.33197 | 2096549.91203 | 37.737007873798596 | -122.42531061759199 | (37.7370078737986, -122.425310617592) | ||||
| 37997 | 37997 | 249753 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 37 | : 4 | Tree 1 | Private 1 | 7 | Width 1ft | 6000238.5689199995 | 2117223.4057 | 37.793503966475 | -122.44313742344801 | (37.793503966475, -122.443137423448) | |||
| 38738 | 38738 | 125682 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Green St | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6008560.62871 | 2119023.68152 | 37.798918077657 | -122.41446980113899 | (37.798918077657, -122.414469801139) | |||
| 39928 | 39928 | 186152 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1700 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 0ft | 5984960.1712 | 2103307.566 | 37.754412039318 | -122.494974531355 | (37.754412039318, -122.494974531355) | |||
| 41377 | 41377 | 228981 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1300 San Jose Ave | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6003423.97246 | 2095615.4048 | 37.73435472807571 | -122.430573123757 | (37.7343547280757, -122.430573123757) | ||||
| 42536 | 42536 | 176390 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 700x Mansell St | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 0ft | 6009150.9462 | 2089957.5754799999 | 37.7191423008581 | -122.410373676998 | (37.7191423008581, -122.410373676998) | |||
| 45936 | 45936 | 184776 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984696.9053 | 2105942.9168 | 37.7616325639121 | -122.49607937246901 | (37.7616325639121, -122.496079372469) | |||
| 46912 | 46912 | 185894 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2000 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 0ft | 5985020.8519 | 2101190.1004 | 37.748601612070004 | -122.49460859166 | (37.74860161207, -122.49460859166) | |||
| 47273 | 47273 | 10756 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 47799 | 47799 | 186770 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1200 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984865.2362 | 2106764.1427 | 37.763897278132 | -122.49555776597 | (37.763897278132, -122.49555776597) | |||
| 55153 | 55153 | 186370 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1801 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984810.6867 | 2102537.171 | 37.7522879951786 | -122.49543466483601 | (37.7522879951786, -122.495434664836) | |||
| 56595 | 56595 | 211131 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5994094.61365 | 2101539.2804900003 | 37.7500872773246 | -122.463257210957 | (37.7500872773246, -122.463257210957) | |||
| 57544 | 57544 | 191973 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6017413.418380001 | 2095064.5219 | 37.7336246998239 | -122.382168264862 | (37.7336246998239, -122.382168264862) | |||
| 59344 | 59344 | 185312 | Undocumented 2 | Shrub :: Shrub 98 | 2601 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984965.1696 | 2097238.5346 | 37.737748422490604 | -122.494509877006 | (37.7377484224906, -122.494509877006) | |||
| 60561 | 60561 | 189226 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 101 Pennsylvania Ave | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014251.36443 | 2106690.81124 | 37.765372877885106 | -122.393914054695 | (37.7653728778851, -122.393914054695) | ||||
| 61777 | 61777 | 206452 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 500 Junipero Serra Blvd | 37 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991336.42216 | 2093557.70772 | 37.7280126289541 | -122.472213362281 | (37.7280126289541, -122.472213362281) | |||
| 62029 | 62029 | 142422 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 10 MAYFAIR DR | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5997618.0335 | 2114520.9492 | 37.7859339729155 | -122.452009568816 | (37.7859339729155, -122.452009568816) | |||
| 67666 | 67666 | 185656 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2100 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5985042.305 | 2100549.4408 | 37.746843791076 | -122.49448718724301 | (37.746843791076, -122.494487187243) | |||
| 67761 | 67761 | 206306 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Junipero Serra Blvd | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991444.74092 | 2094236.6421299998 | 37.7298830812226 | -122.471888366154 | (37.7298830812226, -122.471888366154) | |||
| 67982 | 67982 | 181559 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1300 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984856.3619 | 2106074.0712 | 37.7620020156588 | -122.49553755883801 | (37.7620020156588, -122.495537558838) | |||
| 68524 | 68524 | 187352 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2200 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985089.5104 | 2099749.8522 | 37.744651100545 | -122.49426503067 | (37.744651100545, -122.49426503067) | |||
| 69239 | 69239 | 191385 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 37 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6011271.65755 | 2104161.44484 | 37.7582617567794 | -122.404042206986 | (37.7582617567794, -122.404042206986) | |||
| 69723 | 69723 | 185553 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2201 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984885.8095 | 2099839.3869 | 37.744885015964705 | -122.49497597852199 | (37.7448850159647, -122.494975978522) | |||
| 72034 | 72034 | 197843 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6011998.75435 | 2091272.95857 | 37.722913307489 | -122.40062218776899 | (37.722913307489, -122.400622187769) | |||
| 76287 | 76287 | 189388 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1190 Fairfax Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017704.60452 | 2096656.13327 | 37.738011027092796 | -122.381272171384 | (37.7380110270928, -122.381272171384) | |||
| 97787 | 97787 | 25873 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012698.46901 | 2120014.53101 | 37.8018702969661 | -122.40022104474899 | (37.8018702969661, -122.400221044749) | ||
| 98774 | 98774 | 3527 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016626.76696 | 2099218.04074 | 37.7449859443431 | -122.38517728139 | (37.7449859443431, -122.38517728139) | ||
| 103186 | 103186 | 99154 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 37 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 112227 | 112227 | 93354 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 113461 | 113461 | 111447 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | ||||
| 129906 | 129906 | 186226 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1701 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984811.8118 | 2103374.3628 | 37.7545867587784 | -122.49549251499501 | (37.7545867587784, -122.495492514995) | |||
| 131940 | 131940 | 187018 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 64 | Width 0ft | 5984958.1911 | 2097916.1040000003 | 37.739608437718395 | -122.494583941282 | (37.7396084377184, -122.494583941282) | |||
| 137795 | 137795 | 187254 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2401 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984957.2356 | 2098455.4733 | 37.7410893446535 | -122.494626998091 | (37.7410893446535, -122.494626998091) | |||
| 138214 | 138214 | 191589 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 37 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6015171.71316 | 2097880.19375 | 37.7412318941435 | -122.390115192457 | (37.7412318941435, -122.390115192457) | |||
| 142018 | 142018 | 39020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009326.637 | 2105908.456 | 37.7629497877468 | -122.410892350936 | (37.7629497877468, -122.410892350936) | ||
| 146629 | 146629 | 185706 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 0ft | 5984860.1074 | 2100483.4684 | 37.746651983887794 | -122.49511233597401 | (37.7466519838878, -122.495112335974) | |||
| 146842 | 146842 | 186566 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1501 Sunset Blvd | 37 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5984742.1992 | 2104682.6054 | 37.7581747535408 | -122.49582974929 | (37.7581747535408, -122.49582974929) | |||
| 149845 | 149845 | 184918 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1990 41st Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983532.5797 | 2102094.6082 | 37.7509979199961 | -122.49982178293399 | (37.7509979199961, -122.499821782934) | |||
| 151848 | 151848 | 184848 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984690.0704 | 2106845.3199 | 37.764109909126205 | -122.496169592258 | (37.7641099091262, -122.496169592258) | |||
| 154852 | 154852 | 202245 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013200.83525 | 2093230.7571400001 | 37.728355994623996 | -122.396603988992 | (37.728355994624, -122.396603988992) | |||
| 156986 | 156986 | 186042 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | Width 0ft | 5984981.8854 | 2102165.144 | 37.7512765340519 | -122.49481521448 | (37.7512765340519, -122.49481521448) | |||
| 157793 | 157793 | 185109 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2801 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5985034.9918 | 2095922.7999 | 37.734139852548 | -122.494171522442 | (37.734139852548, -122.494171522442) | |||
| 158043 | 158043 | 187175 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2301 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984938.908 | 2099248.7285 | 37.743266336375896 | -122.494748837407 | (37.7432663363759, -122.494748837407) | |||
| 158230 | 158230 | 180067 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000510.614080001 | 2090253.83095 | 37.7194676036275 | -122.440261155949 | (37.7194676036275, -122.440261155949) | |||
| 158532 | 158532 | 205332 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1x Minerva St | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5996356.8338 | 2088999.78722 | 37.7157869222184 | -122.454528620522 | (37.7157869222184, -122.454528620522) | |||
| 160853 | 160853 | 204711 | DPW Maintained 3 | Ceanothus Sps :: California lilac 270 | 400x Marietta Dr | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5999138.58947 | 2096999.87001 | 37.737912439812796 | -122.445488548067 | (37.7379124398128, -122.445488548067) | |||
| 163818 | 163818 | 197194 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 602 Arthur Ave | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6015675.196819999 | 2099860.1770900004 | 37.746696432096 | -122.388512480964 | (37.746696432096, -122.388512480964) | ||||
| 164196 | 164196 | 185484 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Sunset Blvd | 37 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985117.0889 | 2098499.1184 | 37.741218537266796 | -122.494077507295 | (37.7412185372668, -122.494077507295) | |||
| 164264 | 164264 | 219590 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1201 San Jose Ave | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004431.32479 | 2096032.9751400002 | 37.7355582979675 | -122.42712011110399 | (37.7355582979675, -122.427120111104) | ||||
| 164583 | 164583 | 186680 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1401 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 46 | Width 0ft | 5984729.4281 | 2105398.2043 | 37.760138840627796 | -122.495926705976 | (37.7601388406278, -122.495926705976) | |||
| 165210 | 165210 | 180469 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008151.81482 | 2092695.5003099998 | 37.726604001951706 | -122.414020889251 | (37.7266040019517, -122.414020889251) | |||
| 167160 | 167160 | 137618 | Undocumented 2 | Fraxinus americana :: American Ash 23 | 2000 TURK BLVD | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999494.1594 | 2111936.8449 | 37.778945976017795 | -122.445332845737 | (37.7789459760178, -122.445332845737) | |||
| 167193 | 167193 | 185978 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2001 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5984834.9358 | 2101095.1072 | 37.7483299034009 | -122.495244473331 | (37.7483299034009, -122.495244473331) | |||
| 167602 | 167602 | 185011 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2701 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985034.3637 | 2096468.1875 | 37.7356373047826 | -122.49421387938601 | (37.7356373047826, -122.494213879386) | |||
| 167996 | 167996 | 186482 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 37 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980889.9955 | 2105407.5862 | 37.7599389849374 | -122.50920593411199 | (37.7599389849374, -122.509205934112) | |||
| 168424 | 168424 | 179756 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6004864.308119999 | 2094360.1184200002 | 37.7309894829744 | -122.42550410583401 | (37.7309894829744, -122.425504105834) | |||
| 169172 | 169172 | 200560 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016311.7963 | 2095496.5134 | 37.7347499571366 | -122.38600703115401 | (37.7347499571366, -122.386007031154) | |||
| 169299 | 169299 | 191042 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1301 Minnesota St | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6015379.59979 | 2102513.14016 | 37.7539645262576 | -122.38971990086701 | (37.7539645262576, -122.389719900867) | ||||
| 174081 | 174081 | 186091 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1901 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984808.6672 | 2101798.457 | 37.7502595713091 | -122.49538717298401 | (37.7502595713091, -122.495387172984) | |||
| 175436 | 175436 | 204152 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Junipero Serra Blvd | 37 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991169.92245 | 2090751.38969 | 37.7202975393725 | -122.472584434247 | (37.7202975393725, -122.472584434247) | |||
| 177017 | 177017 | 185421 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 37 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985094.1378 | 2099288.8619999997 | 37.7433856170495 | -122.494215058601 | (37.7433856170495, -122.494215058601) | |||
| 177467 | 177467 | 184037 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1600 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984932.8309 | 2103810.0952 | 37.7557902450486 | -122.49510613395901 | (37.7557902450486, -122.495106133959) | |||
| 177994 | 177994 | 211394 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 300 Junipero Serra Blvd | 37 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991385.475930001 | 2094405.95622 | 37.7303445458499 | -122.47210558662701 | (37.7303445458499, -122.472105586627) | |||
| 178220 | 178220 | 199651 | Undocumented 2 | :: 54 | 0 | 37 | : 4 | Tree 1 | Private 1 | 0 | Width 0ft | 6018297.01834 | 2097895.80454 | 37.7414476037323 | -122.37930996579901 | (37.7414476037323, -122.379309965799) | |||
| 178239 | 178239 | 181477 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984869.4504 | 2105294.0498 | 37.759861061253794 | -122.495434760928 | (37.7598610612538, -122.495434760928) | |||
| 178398 | 178398 | 135079 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010377.54006 | 2122303.65444 | 37.808025975171105 | -122.40841414062 | (37.8080259751711, -122.40841414062) | ||||
| 180024 | 180024 | 229767 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011451.55336 | 2102410.70185 | 37.7534646524788 | -122.40329688663799 | (37.7534646524788, -122.403296886638) | |||
| 180177 | 180177 | 211656 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 200x Terrace Dr | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993885.28493 | 2096476.0493 | 37.7361728559925 | -122.463613650077 | (37.7361728559925, -122.463613650077) | ||||
| 182248 | 182248 | 232293 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200 Eugenia Ave | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6006572.50895 | 2098130.46557 | 37.741438390175205 | -122.41986599782301 | (37.7414383901752, -122.419865997823) | ||||
| 182952 | 182952 | 205103 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991326.973119999 | 2092437.01185 | 37.724934930379206 | -122.47216437168899 | (37.7249349303792, -122.472164371689) | |||
| 183770 | 183770 | 185185 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2500 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 0ft | 5985131.3657 | 2097848.0278 | 37.739431652929895 | -122.493980171096 | (37.7394316529299, -122.493980171096) | |||
| 185004 | 185004 | 186299 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1800 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985021.1385 | 2102711.497 | 37.7527789669048 | -122.49471975093701 | (37.7527789669048, -122.494719750937) | |||
| 185459 | 185459 | 241144 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 310 Liberty St | 37 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6003932.042169999 | 2103938.25616 | 37.7572361204712 | -122.42940988577699 | (37.7572361204712, -122.429409885777) |
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");