Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1804 | 1804 | 44554 | Permitted Site 1 | Tree(s) :: 17 | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
4823 | 4823 | 45930 | Permitted Site 1 | Tree(s) :: 17 | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
5031 | 5031 | 3531 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/03/2017 12:00:00 AM | 3 | 3X3 | 6018350.91064 | 2097856.90864 | 37.741343775188 | -122.379120922001 | (37.741343775188, -122.379120922001) | ||
8666 | 8666 | 19642 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
9064 | 9064 | 12160 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X La Salle Ave | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6016105.23501 | 2095780.8120099998 | 37.73551914997571 | -122.38674101011101 | (37.7355191499757, -122.386741010111) | |||
9150 | 9150 | 44849 | Permitted Site 1 | Tree(s) :: 17 | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
10017 | 10017 | 173623 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 41 | 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) | |||
11459 | 11459 | 48213 | Permitted Site 1 | Tree(s) :: 17 | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
11765 | 11765 | 20396 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
14767 | 14767 | 51143 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 41 | 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) | |||
22352 | 22352 | 3605 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018137.75637 | 2098119.86028 | 37.7420540318827 | -122.37987620861601 | (37.7420540318827, -122.379876208616) | |||
25490 | 25490 | 225139 | Undocumented 2 | Chamaecyparis species :: 347 | 701 Church St | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004346.6017 | 2104631.68872 | 37.759163584356706 | -122.428025590809 | (37.7591635843567, -122.428025590809) | ||||
28705 | 28705 | 206872 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Junipero Serra Blvd | 41 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991149.64989 | 2090725.7488 | 37.7202259623434 | -122.47265264062 | (37.7202259623434, -122.47265264062) | |||
29288 | 29288 | 204521 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 3ft | 5999107.98616 | 2096985.95215 | 37.737872477539604 | -122.445593357764 | (37.7378724775396, -122.445593357764) | |||
29990 | 29990 | 202485 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6015591.97779 | 2114203.68942 | 37.7860759863606 | -122.389801952302 | (37.7860759863606, -122.389801952302) | |||
30436 | 30436 | 203829 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200x Terrace Dr | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 5993865.8273 | 2096513.9581 | 37.7362758229773 | -122.463683673072 | (37.7362758229773, -122.463683673072) | ||||
31200 | 31200 | 205107 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5991336.964 | 2092532.2101 | 37.7251968993055 | -122.472136770613 | (37.7251968993055, -122.472136770613) | |||
35443 | 35443 | 237864 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1201 San Jose Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004410.62481 | 2096042.76783 | 37.735584015890204 | -122.427192376154 | (37.7355840158902, -122.427192376154) | ||||
35889 | 35889 | 185557 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2201 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984925.3425 | 2099814.4466 | 37.744818850863794 | -122.494837444262 | (37.7448188508638, -122.494837444262) | |||
36478 | 36478 | 133192 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1306x Montgomery St | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011420.83782 | 2120184.50099 | 37.8022656699768 | -122.404654242423 | (37.8022656699768, -122.404654242423) | |||
38375 | 38375 | 193076 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 41 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6015380.37917 | 2098678.9075 | 37.7434365686321 | -122.38944945853399 | (37.7434365686321, -122.389449458534) | |||
40184 | 40184 | 211356 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 300x Marietta Dr | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5999471.528530001 | 2097511.88906 | 37.7393373238643 | -122.444374204418 | (37.7393373238643, -122.444374204418) | |||
41558 | 41558 | 205942 | Undocumented 2 | Cedrus atlantica :: Atlas Cedar 304 | 700 Junipero Serra Blvd | 41 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991261.76371 | 2092534.5655 | 37.7251990144957 | -122.47239689950399 | (37.7251990144957, -122.472396899504) | |||
44624 | 44624 | 205088 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 5991229.30633 | 2090865.43732 | 37.7206141232198 | -122.47238747550301 | (37.7206141232198, -122.472387475503) | |||
45477 | 45477 | 181481 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984870.0074 | 2105318.556 | 37.759928381058394 | -122.495434641971 | (37.7599283810584, -122.495434641971) | |||
47089 | 47089 | 197845 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6012007.9467400005 | 2091249.84858 | 37.7228503648454 | -122.400588788767 | (37.7228503648454, -122.400588788767) | |||
48027 | 48027 | 194435 | Undocumented 2 | Pinus halepensis :: Allepo Pine 164 | 800 Vermont St | 41 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 60 | 6011302.64565 | 2104147.13964 | 37.7582242092014 | -122.40393402935301 | (37.7582242092014, -122.403934029353) | ||||
48416 | 48416 | 181408 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1500 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984930.7159 | 2104693.9263 | 37.758216876291705 | -122.49517862143298 | (37.7582168762917, -122.495178621433) | |||
48578 | 48578 | 185316 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984979.4062 | 2097194.1498 | 37.7376273869334 | -122.49445738400101 | (37.7376273869334, -122.494457384001) | |||
49369 | 49369 | 193620 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 602 Arthur Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6015868.84489 | 2099868.33266 | 37.7467295550179 | -122.387843428526 | (37.7467295550179, -122.387843428526) | ||||
50149 | 50149 | 181563 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984874.1846 | 2106092.4508 | 37.762053524514606 | -122.495477273587 | (37.7620535245146, -122.495477273587) | |||
52025 | 52025 | 201793 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6015446.06267 | 2088163.05451 | 37.7145657786635 | -122.388488487967 | (37.7145657786635, -122.388488487967) | |||
52430 | 52430 | 217461 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 5996430.050430001 | 2088999.1612900002 | 37.7157894025409 | -122.454275506331 | (37.7157894025409, -122.454275506331) | |||
54354 | 54354 | 194291 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6014364.32912 | 2095287.3135099998 | 37.7340675655682 | -122.39272551607701 | (37.7340675655682, -122.392725516077) | ||||
55833 | 55833 | 186230 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1701 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984805.6515 | 2103366.0598 | 37.7545636003156 | -122.49551320628099 | (37.7545636003156, -122.495513206281) | |||
59607 | 59607 | 197261 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1322 Hudson Ave | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017380.571719999 | 2095099.80246 | 37.7337197590624 | -122.38228428011499 | (37.7337197590624, -122.382284280115) | |||
60414 | 60414 | 188512 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Pennsylvania Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6014229.234019999 | 2106696.64866 | 37.7653876762377 | -122.393991007905 | (37.7653876762377, -122.393991007905) | ||||
60583 | 60583 | 189390 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1190 Fairfax Ave | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017676.30083 | 2096675.9487599998 | 37.7380638739522 | -122.38137140977 | (37.7380638739522, -122.38137140977) | |||
65325 | 65325 | 186374 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1801 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984789.9466 | 2102521.0099 | 37.7522424068183 | -122.495505194478 | (37.7522424068183, -122.495505194478) | |||
68134 | 68134 | 186046 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1900 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984987.6927 | 2102206.2791 | 37.7513898196771 | -122.49479816500099 | (37.7513898196771, -122.494798165001) | |||
68654 | 68654 | 186773 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1200 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984840.0098 | 2106777.241 | 37.7639317651664 | -122.495645981391 | (37.7639317651664, -122.495645981391) | |||
69503 | 69503 | 224311 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300 San Jose Ave | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6003371.63665 | 2095581.9974099998 | 37.7342600339703 | -122.430751682345 | (37.7342600339703, -122.430751682345) | ||||
71056 | 71056 | 185015 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 0ft | 5984992.91 | 2096422.1279 | 37.7355084115427 | -122.494353804567 | (37.7355084115427, -122.494353804567) | |||
72129 | 72129 | 229771 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011447.677180001 | 2102483.4305 | 37.7536641328931 | -122.403315407293 | (37.7536641328931, -122.403315407293) | |||
72624 | 72624 | 185709 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2101 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984908.4893 | 2100423.9717 | 37.7464914545154 | -122.49494065264601 | (37.7464914545154, -122.494940652646) | |||
73058 | 73058 | 186967 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2800 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985210.5401 | 2096146.418 | 37.7347641193316 | -122.493581077021 | (37.7347641193316, -122.493581077021) | |||
73077 | 73077 | 186684 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1401 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 0ft | 5984721.0536 | 2105370.8826 | 37.760063332390295 | -122.495953653365 | (37.7600633323903, -122.495953653365) | |||
75865 | 75865 | 202249 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013205.71087 | 2093269.90652 | 37.7284637621797 | -122.396589876845 | (37.7284637621797, -122.396589876845) | |||
76804 | 76804 | 175626 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6009096.33692 | 2089936.65243 | 37.7190817890677 | -122.410560964424 | (37.7190817890677, -122.410560964424) | |||
77185 | 77185 | 186156 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1700 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984977.8278 | 2103337.3397 | 37.7544948232836 | -122.49491566635 | (37.7544948232836, -122.49491566635) | |||
87655 | 87655 | 3736 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017167.798756 | 2098792.720184 | 37.743848015002605 | -122.383276872883 | (37.7438480150026, -122.383276872883) | |||
94568 | 94568 | 49265 | Permitted Site 1 | Tree(s) :: 17 | 1X Main St | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
96574 | 96574 | 12496 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
102681 | 102681 | 206832 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 52 | Width 8ft | 5994051.70376 | 2101574.41752 | 37.750181282555 | -122.463408144182 | (37.750181282555, -122.463408144182) | |||
102807 | 102807 | 6499 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6017004.32701 | 2097592.12501 | 37.7405423887708 | -122.38375855101201 | (37.7405423887708, -122.383758551012) | ||
110004 | 110004 | 39034 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009405.63 | 2105912.797 | 37.7629661362051 | -122.410619446859 | (37.7629661362051, -122.410619446859) | ||
114310 | 114310 | 99153 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 41 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
128103 | 128103 | 25877 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012751.85401 | 2119935.10401 | 37.80165518616639 | -122.400030725403 | (37.8016551861664, -122.400030725403) | ||
133708 | 133708 | 132326 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 900 Green St | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6008538.05329 | 2119021.31977 | 37.79891032461779 | -122.414547752584 | (37.7989103246178, -122.414547752584) | |||
134099 | 134099 | 185113 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 0ft | 5985054.6718 | 2095908.9819999998 | 37.7341030638616 | -122.49410246540701 | (37.7341030638616, -122.494102465407) | |||
134566 | 134566 | 186303 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1800 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984981.6714 | 2102749.3532 | 37.752880599418894 | -122.49485902426301 | (37.7528805994189, -122.494859024263) | |||
136867 | 136867 | 224241 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6004764.42793 | 2096634.9587599998 | 37.7372300405369 | -122.42601128568998 | (37.7372300405369, -122.42601128569) | ||||
137392 | 137392 | 233313 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200x Diamond Heights Blvd | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6001700.69582 | 2098799.77338 | 37.743000487396294 | -122.436758913492 | (37.7430004873963, -122.436758913492) | ||||
137881 | 137881 | 200571 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6016326.461 | 2095462.4873 | 37.7346573398722 | -122.385953958726 | (37.7346573398722, -122.385953958726) | |||
141855 | 141855 | 10769 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1120X Hudson Ave | 41 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
149963 | 149963 | 187179 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2301 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984914.0932 | 2099227.6174 | 37.7432069184805 | -122.494833083055 | (37.7432069184805, -122.494833083055) | |||
150115 | 150115 | 188865 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 900x Carolina St | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012505.22674 | 2103087.46941 | 37.7553817004262 | -122.39970055083401 | (37.7553817004262, -122.399700550834) | ||||
150297 | 150297 | 186095 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 57 | Width 0ft | 5984840.151000001 | 2101765.7139 | 37.7501715111334 | -122.495275887194 | (37.7501715111334, -122.495275887194) | |||
151224 | 151224 | 135083 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010341.3497 | 2122324.71825 | 37.8080817844136 | -122.40854087398701 | (37.8080817844136, -122.408540873987) | ||||
156770 | 156770 | 185189 | Undocumented 2 | Tree(s) :: 17 | 2500 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985143.9825 | 2097859.9805 | 37.73946521004989 | -122.49393742902299 | (37.7394652100499, -122.493937429023) | |||
162533 | 162533 | 220176 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6004978.26443 | 2096560.7455900002 | 37.73703835094361 | -122.425266674926 | (37.7370383509436, -122.425266674926) | ||||
162766 | 162766 | 185982 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2001 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984874.3278 | 2101056.369 | 37.748225845136 | -122.495105402668 | (37.748225845136, -122.495105402668) | |||
164893 | 164893 | 184780 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 69 | Width 0ft | 5984672.982999999 | 2105911.7799 | 37.7615456694917 | -122.496159811415 | (37.7615456694917, -122.496159811415) | |||
167058 | 167058 | 185898 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2000 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985035.2587 | 2101255.8864 | 37.7487830856711 | -122.49456362292 | (37.7487830856711, -122.49456362292) | |||
168011 | 168011 | 180473 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008102.7284699995 | 2092853.30423 | 37.727034540698206 | -122.414201739328 | (37.7270345406982, -122.414201739328) | |||
169988 | 169988 | 183953 | Undocumented 2 | Araucaria heterophylla :: Norfolk Island Pine 24 | 2100 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985069.1522 | 2100584.5154 | 37.74694166760111 | -122.49439693858 | (37.7469416676011, -122.49439693858) | |||
171129 | 171129 | 187022 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2501 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984980.0493 | 2097896.5997 | 37.7395561634642 | -122.49450692872 | (37.7395561634642, -122.49450692872) | |||
171481 | 171481 | 224441 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 310 Liberty St | 41 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6003891.83885 | 2103931.1825 | 37.757214421627395 | -122.42954842002399 | (37.7572144216274, -122.429548420024) | |||
175132 | 175132 | 185488 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 41 | unknown : Yard 19 | Tree 1 | Private 1 | 27 | Width 0ft | 5985122.4012 | 2098536.3046 | 37.741320951397704 | -122.494061879541 | (37.7413209513977, -122.494061879541) | |||
177174 | 177174 | 180070 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000442.5181599995 | 2090189.01132 | 37.7192857463155 | -122.440491891393 | (37.7192857463155, -122.440491891393) | |||
177225 | 177225 | 187356 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2200 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985052.9474 | 2099788.1079 | 37.7447540006126 | -122.494394275911 | (37.7447540006126, -122.494394275911) | |||
177909 | 177909 | 187258 | Undocumented 2 | Tree(s) :: 17 | 2401 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984954.3762 | 2098434.6407 | 37.7410319765896 | -122.494635349253 | (37.7410319765896, -122.494635349253) | |||
179142 | 179142 | 184040 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1600 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984924.3927 | 2103821.4069 | 37.7558208098367 | -122.495136149639 | (37.7558208098367, -122.495136149639) | |||
179756 | 179756 | 186570 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1501 Sunset Blvd | 41 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5984760.623 | 2104719.4531 | 37.7582770060448 | -122.495768750789 | (37.7582770060448, -122.495768750789) | |||
182036 | 182036 | 190437 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 41 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017375.251180001 | 2097308.04531 | 37.73978285968779 | -122.382456265548 | (37.7397828596878, -122.382456265548) | |||
182870 | 182870 | 249757 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 41 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000240.78319 | 2117204.07092 | 37.7934510045092 | -122.443128372672 | (37.7934510045092, -122.443128372672) | |||
185373 | 185373 | 211529 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 300 Junipero Serra Blvd | 41 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5991392.35207 | 2094374.63873 | 37.730258953789395 | -122.47207953326999 | (37.7302589537894, -122.47207953327) | |||
185858 | 185858 | 215259 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 41 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991333.88736 | 2093532.9142200002 | 37.7279444054996 | -122.472220318525 | (37.7279444054996, -122.472220318525) | |||
186018 | 186018 | 184852 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984650.5796 | 2106852.1548 | 37.7641263625826 | -122.49630668173201 | (37.7641263625826, -122.496306681732) | |||
187897 | 187897 | 179760 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 10ft | 6004853.85523 | 2094362.29345 | 37.730994864507 | -122.425540397994 | (37.730994864507, -122.425540397994) |
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");