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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188554 | 188554 | 221300 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6010513.720919999 | 2100755.88609 | 37.748868470213104 | -122.406423533516 | (37.7488684702131, -122.406423533516) | |||
23604 | 23604 | 223865 | DPW Maintained 3 | Cussonia spicata :: Cabbage tree 325 | 3700x Cesar Chavez St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 6005794.48367 | 2100533.61064 | 37.7479930188582 | -122.422726883358 | (37.7479930188582, -122.422726883358) | |||
23611 | 23611 | 211242 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 5ft | 5993561.819519999 | 2100384.28411 | 37.7468852429767 | -122.465015753384 | (37.7468852429767, -122.465015753384) | |||
24137 | 24137 | 231180 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2800x Bryant St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6009829.19056 | 2100977.4251599996 | 37.7494384497445 | -122.408806277407 | (37.7494384497445, -122.408806277407) | |||
24456 | 24456 | 211158 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 300x Marietta Dr | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 5ft | 5999457.5176099995 | 2097516.55077 | 37.73934932439921 | -122.444422982731 | (37.7393493243992, -122.444422982731) | |||
25576 | 25576 | 231188 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2850x Bryant St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009844.761940001 | 2100681.8264599997 | 37.7486276731362 | -122.408731579718 | (37.7486276731362, -122.408731579718) | |||
26004 | 26004 | 204552 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 60 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 5ft | 5999641.44525 | 2097441.40723 | 37.7391534907361 | -122.443781647414 | (37.7391534907361, -122.443781647414) | |||
26865 | 26865 | 200267 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6014763.4294300005 | 2089103.4873400002 | 37.7171101711671 | -122.39091365107001 | (37.7171101711671, -122.39091365107) | |||
28276 | 28276 | 215739 | DPW Maintained 3 | Ulmus spp :: Elm Spp 215 | 15x San Marcos Ave | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5993350.77612 | 2100350.23209 | 37.746779573516 | -122.46574304232401 | (37.746779573516, -122.465743042324) | |||
28584 | 28584 | 196158 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 390x Hampshire St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 6010042.156719999 | 2106501.92637 | 37.764619417770206 | -122.408459468244 | (37.7646194177702, -122.408459468244) | |||
28726 | 28726 | 211228 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 5ft | 5993736.5001300005 | 2100633.35574 | 37.74757920122521 | -122.464429809989 | (37.7475792012252, -122.464429809989) | |||
29614 | 29614 | 210555 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 15x San Marcos Ave | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5993274.23094 | 2100297.44327 | 37.7466302132305 | -122.466003890675 | (37.7466302132305, -122.466003890675) | |||
30035 | 30035 | 194392 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 860x Jamestown Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 6014755.052209999 | 2089115.5775900001 | 37.7171429037943 | -122.39094345187799 | (37.7171429037943, -122.390943451878) | |||
30212 | 30212 | 211230 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 34 | Width 5ft | 5993731.93938 | 2100593.11713 | 37.7474684533162 | -122.464442659515 | (37.7474684533162, -122.464442659515) | |||
30280 | 30280 | 217724 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 150x Lincoln Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5995249.55673 | 2107377.5130000003 | 37.7661840384824 | -122.45968619826701 | (37.7661840384824, -122.459686198267) | |||
32217 | 32217 | 211245 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 15x San Marcos Ave | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 5ft | 5993240.72195 | 2100276.6847599996 | 37.7465712824474 | -122.46611825206301 | (37.7465712824474, -122.466118252063) | |||
32380 | 32380 | 211155 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 300x Marietta Dr | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 5ft | 5999298.00043 | 2097563.30482 | 37.739468597008205 | -122.444977880636 | (37.7394685970082, -122.444977880636) | |||
32439 | 32439 | 194391 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 828x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 5ft | 6014866.8225 | 2088973.5540099998 | 37.7167591360948 | -122.39054719349899 | (37.7167591360948, -122.390547193499) | |||
32681 | 32681 | 181225 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012142.64872 | 2087966.32727 | 37.713841988985 | -122.399892688298 | (37.713841988985, -122.399892688298) | |||
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) | |||
34340 | 34340 | 200271 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014518.22002 | 2089293.0618599998 | 37.7176170965211 | -122.391774477626 | (37.7176170965211, -122.391774477626) | |||
37488 | 37488 | 231181 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2800x Bryant St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009829.63299 | 2100960.5991599998 | 37.7493922740476 | -122.408803560533 | (37.7493922740476, -122.408803560533) | |||
38677 | 38677 | 212161 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Marietta Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 5ft | 5999206.26812 | 2097588.84406 | 37.7395334857736 | -122.445296885446 | (37.7395334857736, -122.445296885446) | |||
39056 | 39056 | 200272 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014501.14248 | 2089299.14768 | 37.7176328589541 | -122.39183393271401 | (37.7176328589541, -122.391833932714) | |||
39319 | 39319 | 205763 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 5999213.2528 | 2097587.01076 | 37.739528850671 | -122.445272603768 | (37.739528850671, -122.445272603768) | |||
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) | |||
40906 | 40906 | 205764 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5999220.2422400005 | 2097585.41843 | 37.7395248774812 | -122.445248322956 | (37.7395248774812, -122.445248322956) | |||
41263 | 41263 | 218719 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993701.46816 | 2100309.93296 | 37.7466891448909 | -122.464527467374 | (37.7466891448909, -122.464527467374) | |||
41784 | 41784 | 194394 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 920x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 5ft | 6014490.42947 | 2089308.0420799998 | 37.717656686497506 | -122.39187158462799 | (37.7176566864975, -122.391871584628) | |||
42384 | 42384 | 212160 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Marietta Dr | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 5ft | 5999181.20972 | 2097594.9111099998 | 37.7395487140123 | -122.44538396231 | (37.7395487140123, -122.44538396231) | |||
42882 | 42882 | 211250 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 33 | Width 5ft | 5993746.09289 | 2100276.06203 | 37.7465987162755 | -122.464370702046 | (37.7465987162755, -122.464370702046) | |||
43117 | 43117 | 219165 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5993760.22324 | 2100276.5052799997 | 37.7466007478231 | -122.46432187335199 | (37.7466007478231, -122.464321873352) | |||
43528 | 43528 | 209215 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x Castenada Ave | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 5993821.14503 | 2100240.07202 | 37.746504222711295 | -122.46410856948 | (37.7465042227113, -122.46410856948) | |||
43705 | 43705 | 190817 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 6010044.56493 | 2106488.02831 | 37.7645813917285 | -122.40845015844101 | (37.7645813917285, -122.408450158441) | |||
44102 | 44102 | 209213 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 5993777.82606 | 2100247.64237 | 37.7465225122089 | -122.46425891004101 | (37.7465225122089, -122.464258910041) | |||
44505 | 44505 | 181226 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012120.3534699995 | 2087937.9432299999 | 37.713762809074 | -122.39996775739901 | (37.713762809074, -122.399967757399) | |||
45040 | 45040 | 231439 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101x Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 5ft | 5999775.11781 | 2101292.59964 | 37.749735565955795 | -122.443596051626 | (37.7497355659558, -122.443596051626) | |||
45072 | 45072 | 181223 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6012185.06666 | 2088017.9901400001 | 37.7139862096601 | -122.399749700601 | (37.7139862096601, -122.399749700601) | |||
45155 | 45155 | 190814 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 5ft | 6010041.1190599995 | 2106539.02685 | 37.7647212291204 | -122.40846567444599 | (37.7647212291204, -122.408465674446) | |||
45676 | 45676 | 181228 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 6012082.02881 | 2087884.13753 | 37.7136129325747 | -122.400096445907 | (37.7136129325747, -122.400096445907) | |||
45970 | 45970 | 204550 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 62 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 5999656.91248 | 2097430.30525 | 37.739123889545496 | -122.44372737153499 | (37.7391238895455, -122.443727371535) | |||
46169 | 46169 | 188192 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 860x Jamestown Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014712.4620199995 | 2089164.16636 | 37.7172739556962 | -122.391094061367 | (37.7172739556962, -122.391094061367) | |||
47077 | 47077 | 205769 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5999260.68226 | 2097573.72632 | 37.7394950820195 | -122.44510765910499 | (37.7394950820195, -122.445107659105) | |||
47145 | 47145 | 211241 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 5ft | 5993566.16036 | 2100378.64225 | 37.7468700021587 | -122.46500033359501 | (37.7468700021587, -122.465000333595) | |||
47313 | 47313 | 211354 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 300x Marietta Dr | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 5999278.01006 | 2097568.54324 | 37.7394818395234 | -122.445047374833 | (37.7394818395234, -122.445047374833) | |||
47921 | 47921 | 211249 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 5ft | 5993726.26019 | 2100287.2096700002 | 37.74662818164779 | -122.464440090141 | (37.7466281816478, -122.464440090141) | |||
48849 | 48849 | 198000 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 828x Jamestown Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 6014844.30096 | 2089001.4675099999 | 37.7168345316683 | -122.390626989449 | (37.7168345316683, -122.390626989449) | |||
49142 | 49142 | 200274 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014408.1626699995 | 2089360.68754 | 37.7177966731557 | -122.392159625791 | (37.7177966731557, -122.392159625791) | |||
50356 | 50356 | 200269 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014632.09061 | 2089229.7896900002 | 37.7174496841459 | -122.39137645477501 | (37.7174496841459, -122.391376454775) | |||
51688 | 51688 | 200270 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014621.84489 | 2089234.87823 | 37.717463087626705 | -122.39141222532 | (37.7174630876267, -122.39141222532) | |||
54902 | 54902 | 204547 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 68 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 5999723.97514 | 2097336.19746 | 37.738869316670204 | -122.443488741839 | (37.7388693166702, -122.443488741839) | |||
55123 | 55123 | 198002 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 860x Jamestown Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 6014610.54339 | 2089241.6149400002 | 37.717480958049 | -122.39145176041 | (37.717480958049, -122.39145176041) | |||
55655 | 55655 | 198001 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 860x Jamestown Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 5ft | 6014795.93259 | 2089063.22643 | 37.7170014260431 | -122.390798490171 | (37.7170014260431, -122.390798490171) | |||
55927 | 55927 | 211233 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 5ft | 5993724.9195 | 2100471.15011 | 37.7471331581716 | -122.464458079279 | (37.7471331581716, -122.464458079279) | |||
56579 | 56579 | 204560 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 54 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 5ft | 5999598.12734 | 2097466.8336099996 | 37.7392208346642 | -122.443933247029 | (37.7392208346642, -122.443933247029) | |||
56613 | 56613 | 211254 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 5ft | 5993790.37609 | 2100225.91603 | 37.7464635805444 | -122.46421393671899 | (37.7464635805444, -122.464213936719) | |||
58367 | 58367 | 132070 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 5ft | 6013297.802519999 | 2119184.84583 | 37.7996255806051 | -122.39808881644501 | (37.7996255806051, -122.398088816445) | |||
58464 | 58464 | 222781 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2950x Cesar Chavez St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 6009693.66446 | 2100583.0279099997 | 37.748347930031 | -122.40924710438401 | (37.748347930031, -122.409247104384) | |||
58921 | 58921 | 188193 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 860x Jamestown Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014700.6925800005 | 2089174.7091700002 | 37.7173022510631 | -122.391135479631 | (37.7173022510631, -122.391135479631) | |||
60120 | 60120 | 241884 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 387x Holly Park Cir | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6006329.1092300005 | 2096869.11862 | 37.737961298159796 | -122.420618072992 | (37.7379612981598, -122.420618072992) | |||
60137 | 60137 | 209212 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 5993771.94389 | 2100232.96399 | 37.746481870051106 | -122.4642781843 | (37.7464818700511, -122.4642781843) | |||
60138 | 60138 | 203309 | DPW Maintained 3 | Acer macrophyllum :: Big Leaf Maple 159 | 300x Marietta Dr | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 5999493.35383 | 2097506.1285599996 | 37.7393227521334 | -122.444298328617 | (37.7393227521334, -122.444298328617) | |||
60262 | 60262 | 219167 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5993768.02883 | 2100241.187 | 37.7465042226907 | -122.464292318936 | (37.7465042226907, -122.464292318936) | |||
60563 | 60563 | 181224 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012163.826230001 | 2087990.6147200002 | 37.713909858116104 | -122.39982119490601 | (37.7139098581161, -122.399821194906) | |||
60777 | 60777 | 181229 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012059.81705 | 2087859.8714700001 | 37.713545064337296 | -122.400171515023 | (37.7135450643373, -122.400171515023) | |||
61181 | 61181 | 211251 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5993753.32003 | 2100266.28903 | 37.746572298679794 | -122.464345002125 | (37.7465722986798, -122.464345002125) | |||
61236 | 61236 | 231182 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2800x Bryant St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009830.8123699995 | 2100941.41106 | 37.7493396538235 | -122.408798128636 | (37.7493396538235, -122.408798128636) | |||
61403 | 61403 | 211240 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 5ft | 5993599.48899 | 2100373.1315599997 | 37.7468567929 | -122.464884687082 | (37.7468567929, -122.464884687082) | |||
61882 | 61882 | 211236 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 5ft | 5993665.945669999 | 2100370.25602 | 37.7468527288888 | -122.464654679171 | (37.7468527288888, -122.464654679171) | |||
62268 | 62268 | 181231 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6012012.90847 | 2087803.8646200001 | 37.713388665025 | -122.40032971745 | (37.713388665025, -122.40032971745) | |||
62623 | 62623 | 211232 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 5ft | 5993723.69131 | 2100501.14941 | 37.747215457839296 | -122.464464504057 | (37.7472154578393, -122.464464504057) | |||
63061 | 63061 | 211229 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 5ft | 5993733.85215 | 2100613.4292099997 | 37.747524335392 | -122.464437519896 | (37.747524335392, -122.464437519896) | |||
63521 | 63521 | 200266 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014773.14657 | 2089094.60205 | 37.7170863130726 | -122.39087944264999 | (37.7170863130726, -122.39087944265) | |||
63549 | 63549 | 211237 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 5993655.2284 | 2100373.0715 | 37.7468598416197 | -122.464691942604 | (37.7468598416197, -122.464691942604) | |||
64215 | 64215 | 231184 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2800x Bryant St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009832.795080001 | 2100903.82499 | 37.7492365618324 | -122.40878862099599 | (37.7492365618324, -122.408788620996) | |||
65373 | 65373 | 206437 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 300x Marietta Dr | 49 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 5ft | 5999552.5631800005 | 2097488.9767299998 | 37.7392790352022 | -122.444092377567 | (37.7392790352022, -122.444092377567) | |||
67188 | 67188 | 204553 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 64 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5999694.8834 | 2097395.01803 | 37.7390291648714 | -122.443593551518 | (37.7390291648714, -122.443593551518) | |||
67936 | 67936 | 209179 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 255x San Marcos Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5993078.87861 | 2100249.74193 | 37.7464879656554 | -122.46667592616998 | (37.7464879656554, -122.46667592617) | |||
68371 | 68371 | 204555 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 59 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5999635.81986 | 2097444.2193400003 | 37.7391608912586 | -122.443801299384 | (37.7391608912586, -122.443801299384) | |||
70511 | 70511 | 212162 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Marietta Dr | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 5ft | 5999237.80706 | 2097579.98932 | 37.7395109730464 | -122.445187201442 | (37.7395109730464, -122.445187201442) | |||
71016 | 71016 | 211248 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 255x San Marcos Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 5ft | 5993162.336569999 | 2100242.4372400003 | 37.7464727248343 | -122.46638680940599 | (37.7464727248343, -122.466386809406) | |||
71033 | 71033 | 211427 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 300x Marietta Dr | 65 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5999709.393759999 | 2097376.92843 | 37.73898032267461 | -122.443542082395 | (37.7389803226746, -122.443542082395) | |||
71827 | 71827 | 196444 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200x Kansas St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 6011674.76736 | 2102721.10758 | 37.7543294225845 | -122.402546786399 | (37.7543294225845, -122.402546786399) | |||
71859 | 71859 | 231438 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101x Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 5ft | 5999777.38069 | 2101303.6444900003 | 37.749766021497706 | -122.443589019842 | (37.7497660214977, -122.443589019842) | |||
73104 | 73104 | 200264 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 828x Jamestown Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014856.837309999 | 2088987.16565 | 37.716795957049996 | -122.390582658263 | (37.71679595705, -122.390582658263) | |||
73694 | 73694 | 188195 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 920x Jamestown Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 6014470.00417 | 2089321.4715900002 | 37.717692427352 | -122.391943124797 | (37.717692427352, -122.391943124797) | |||
74116 | 74116 | 211428 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 300x Marietta Dr | 53 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 5ft | 5999583.37084 | 2097473.06947 | 37.7392371150928 | -122.44398471614099 | (37.7392371150928, -122.443984716141) | |||
74246 | 74246 | 211231 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 5ft | 5993728.84225 | 2100569.4992299997 | 37.747403426025 | -122.464451654542 | (37.747403426025, -122.464451654542) | |||
74360 | 74360 | 211234 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 5ft | 5993717.77408 | 2100431.7053400003 | 37.7470244409403 | -122.46447992381201 | (37.7470244409403, -122.464479923812) | |||
74481 | 74481 | 218721 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5993716.07745 | 2100297.78462 | 37.746656630797794 | -122.464476068412 | (37.7466566307978, -122.464476068412) | |||
74641 | 74641 | 205772 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 5ft | 5999313.6439 | 2097558.6392200002 | 37.7394566791949 | -122.444923457253 | (37.7394566791949, -122.444923457253) | |||
74873 | 74873 | 211239 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 5993619.45361 | 2100368.2719799997 | 37.746844600813496 | -122.464815299002 | (37.7468446008135, -122.464815299002) | |||
75070 | 75070 | 211244 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 5ft | 5993471.7444 | 2100377.29447 | 37.7468608569505 | -122.46532671465499 | (37.7468608569505, -122.465326714655) | |||
75541 | 75541 | 209208 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 5993802.83706 | 2100253.03783 | 37.7465387683529 | -122.46417281704399 | (37.7465387683529, -122.464172817044) | |||
75617 | 75617 | 246964 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 250x Noe St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 6002901.21345 | 2106817.19927 | 37.7650825884135 | -122.433180589307 | (37.7650825884135, -122.433180589307) | |||
76824 | 76824 | 219162 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 5993732.15666 | 2100284.86554 | 37.74662208515711 | -122.46441953075501 | (37.7466220851571, -122.464419530755) | |||
82243 | 82243 | 206416 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 255x San Marcos Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 5993123.33521 | 2100243.25688 | 37.7464727248457 | -122.466521730189 | (37.7464727248457, -122.466521730189) | |||
123719 | 123719 | 209209 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 5993795.21392 | 2100243.94669 | 37.746513367011 | -122.464198516942 | (37.746513367011, -122.464198516942) | |||
130553 | 130553 | 181234 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6011952.76833 | 2087732.27923 | 37.7131887520264 | -122.40053255865601 | (37.7131887520264, -122.400532558656) | |||
132398 | 132398 | 211246 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 255x San Marcos Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 5ft | 5993194.451640001 | 2100249.90353 | 37.7464950783995 | -122.466276302521 | (37.7464950783995, -122.466276302521) |
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");