Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 111961 | 111961 | 1 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 10 10th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 16 | 5992719.40718 | 2114869.71245 | 37.7866097734767 | -122.46898271049601 | (37.7866097734767, -122.468982710496) | |||
| 124086 | 124086 | 3 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2X 12th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 16 | 5992095.57585 | 2114853.19204 | 37.7865283500331 | -122.471139790973 | (37.7865283500331, -122.471139790973) | |||
| 76128 | 76128 | 10 | DPW Maintained 3 | Palm (unknown Genus) :: Palm Spp 161 | 97 12th St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3X3 | 6007166.5822125 | 2109668.7679164 | 37.7731533608049 | -122.418629924651 | (37.7731533608049, -122.418629924651) | |||
| 118070 | 118070 | 11 | DPW Maintained 3 | Palm (unknown Genus) :: Palm Spp 161 | 97 12th St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3X3 | 6007166.5822125 | 2109668.7679164 | 37.7731533608049 | -122.418629924651 | (37.7731533608049, -122.418629924651) | |||
| 107073 | 107073 | 12 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 97 12th St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 6007166.5822125 | 2109668.7679164 | 37.7731533608049 | -122.418629924651 | (37.7731533608049, -122.418629924651) | |||
| 113273 | 113273 | 441 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 700x 23rd Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8x100 | 5988813.91417 | 2110455.50375 | 37.7742631725206 | -122.482171092771 | (37.7742631725206, -122.482171092771) | |||
| 78172 | 78172 | 442 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700x 23rd Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5988814.32729 | 2110443.9038299997 | 37.7742313463884 | -122.482168813724 | (37.7742313463884, -122.482168813724) | ||||
| 81565 | 81565 | 443 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700x 23rd Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988815.988030001 | 2110428.99683 | 37.774190512498706 | -122.482161976658 | (37.7741905124987, -122.482161976658) | ||||
| 17996 | 17996 | 444 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 700X 23rd Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8-HOA | 5988817.90932 | 2110395.2754599997 | 37.774098034723 | -122.48215285967599 | (37.774098034723, -122.482152859676) | |||
| 58709 | 58709 | 445 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 700X 23rd Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8-HOA | 5988818.925419999 | 2110381.03816 | 37.774059002147204 | -122.482148301598 | (37.7740590021472, -122.482148301598) | |||
| 103854 | 103854 | 446 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 700x 23rd Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988817.30903 | 2110408.41055 | 37.7741340651206 | -122.48215589864901 | (37.7741340651206, -122.482155898649) | ||||
| 129093 | 129093 | 447 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 700x 23rd Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/19/2015 10:02:00 AM | 3 | 8-HOA | 5988844.179766299 | 2110365.2900002 | 37.7740172309193 | -122.48205978958599 | (37.7740172309193, -122.482059789586) | ||
| 83214 | 83214 | 448 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700x 23rd Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988818.05287 | 2110350.21953 | 37.773974331987795 | -122.482149061597 | (37.7739743319878, -122.482149061597) | ||||
| 144664 | 144664 | 449 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700x 23rd Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8-HOA | 5988819.75093 | 2110337.06115 | 37.7739383014913 | -122.482142223603 | (37.7739383014913, -122.482142223603) | |||
| 119795 | 119795 | 450 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 700x 23rd Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/29/2015 01:42:00 PM | 3 | 5988819.93055 | 2110324.8097900003 | 37.773904673102 | -122.48214070454901 | (37.773904673102, -122.482140704549) | |||
| 18888 | 18888 | 451 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 740X 23rd Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8-HOA | 5988823.24796 | 2110191.1107400004 | 37.7735377655293 | -122.482119432452 | (37.7735377655293, -122.482119432452) | |||
| 120774 | 120774 | 452 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 740x 23rd Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5988823.98791 | 2110205.31094 | 37.773576798380205 | -122.482117913396 | (37.7735767983802, -122.482117913396) | ||||
| 116178 | 116178 | 453 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 740X 23rd Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5988823.177519999 | 2110218.88788 | 37.773614029759706 | -122.482121711467 | (37.7736140297597, -122.482121711467) | ||||
| 86980 | 86980 | 454 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 740X 23rd Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8-HOA | 5988822.540159999 | 2110230.27386 | 37.7736452554339 | -122.482124750469 | (37.7736452554339, -122.482124750469) | |||
| 82164 | 82164 | 455 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 740X 23rd Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2015 08:09:00 AM | 3 | 8x100 | 5988822.12971 | 2110252.37193 | 37.773705906735 | -122.482127789493 | (37.773705906735, -122.482127789493) | ||
| 115054 | 115054 | 456 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 740x 23rd Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 5988821.67955 | 2110262.22324 | 37.7737329295184 | -122.482130068503 | (37.7737329295184, -122.482130068503) | ||||
| 123434 | 123434 | 457 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 760x 23rd Ave | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/31/2002 12:00:00 AM | 3 | 5988833.54517 | 2109972.18567 | 37.7729372568337 | -122.482067772117 | (37.7729372568337, -122.482067772117) | |||
| 83555 | 83555 | 458 | DPW Maintained 3 | Ficus rubiginosa :: Port Jackson Fig 188 | 760x 23rd Ave | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5988831.51293 | 2110000.66067 | 37.7730153231025 | -122.482076888223 | (37.7730153231025, -122.482076888223) | ||||
| 106244 | 106244 | 459 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 760x 23rd Ave | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5988830.89675 | 2110023.4193700003 | 37.773077776353 | -122.48208068722602 | (37.773077776353, -122.482080687226) | ||||
| 131764 | 131764 | 460 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 760x 23rd Ave | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 5988827.36485 | 2110053.67584 | 37.773160646819 | -122.482095121354 | (37.773160646819, -122.482095121354) | ||||
| 103239 | 103239 | 461 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 760x 23rd Ave | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/19/2015 10:10:00 AM | 3 | 8x100 | 5988827.12869 | 2110042.5268099997 | 37.7731300209347 | -122.48209512132799 | (37.7731300209347, -122.482095121328) | ||
| 126972 | 126972 | 463 | DPW Maintained 3 | Ficus rubiginosa :: Port Jackson Fig 188 | 760x 23rd Ave | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8-HOA | 5988827.93614 | 2110070.28551 | 37.7732062855999 | -122.482094362253 | (37.7732062855999, -122.482094362253) | |||
| 90389 | 90389 | 464 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 760x 23rd Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5988827.211759999 | 2110098.29514 | 37.7732831501538 | -122.48209892030701 | (37.7732831501538, -122.482098920307) | ||||
| 94915 | 94915 | 465 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 760x 23rd Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8-HOA | 5988826.12619 | 2110109.25362 | 37.773313175965 | -122.482103478364 | (37.773313175965, -122.482103478364) | |||
| 121730 | 121730 | 803 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 680X 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983825.76498 | 2111129.60729 | 37.7758226717015 | -122.499475562851 | (37.7758226717015, -122.499475562851) | |||
| 79512 | 79512 | 804 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 680X 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6-HOA | 5983823.94935 | 2111143.69789 | 37.7758612538886 | -122.499482885033 | (37.7758612538886, -122.499482885033) | |||
| 145945 | 145945 | 805 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 680X 39th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983823.96426 | 2111160.91126 | 37.7759085177004 | -122.499484105844 | (37.7759085177004, -122.499484105844) | |||
| 125116 | 125116 | 806 | DPW Maintained 3 | Pinus thunbergii :: Japanese Black Pine 306 | 600X 39th Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983808.23309 | 2111660.7549099997 | 37.777280020650295 | -122.499575472587 | (37.7772800206503, -122.499575472587) | |||
| 87349 | 87349 | 807 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600X 39th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983808.206040001 | 2111664.13118 | 37.7772892893219 | -122.49957581574499 | (37.7772892893219, -122.499575815745) | |||
| 145361 | 145361 | 808 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 600X 39th Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 145424 | 145424 | 809 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 111465 | 111465 | 810 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 84653 | 84653 | 811 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X 39th Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 114988 | 114988 | 812 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 105087 | 105087 | 813 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 143285 | 143285 | 814 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600X 39th Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 113487 | 113487 | 815 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 600X 39th Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 10605 | 10605 | 1293 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 10 | 5991961.87152 | 2087160.6390900002 | 37.7104840184951 | -122.46958569253701 | (37.7104840184951, -122.469585692537) | |||
| 12006 | 12006 | 1294 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991953.08243 | 2087152.92109 | 37.7104623187479 | -122.469615507754 | (37.7104623187479, -122.469615507754) | |||
| 10299 | 10299 | 1295 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991914.74417 | 2087134.82891 | 37.710410426081 | -122.46974669545901 | (37.710410426081, -122.469746695459) | |||
| 10785 | 10785 | 1296 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 10 | 5991907.39965 | 2087130.17274 | 37.710397216839496 | -122.46977174067499 | (37.7103972168395, -122.469771740675) | |||
| 11437 | 11437 | 1297 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991899.37983 | 2087126.21827 | 37.7103858952584 | -122.46979917089199 | (37.7103858952584, -122.469799170892) | |||
| 10727 | 10727 | 1298 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991889.9079 | 2087118.85792 | 37.7103651380077 | -122.46983137204599 | (37.7103651380077, -122.469831372046) | |||
| 10821 | 10821 | 1299 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 10 | 5991881.88808 | 2087114.90346 | 37.7103538164401 | -122.46985880224301 | (37.7103538164401, -122.469858802243) | |||
| 12049 | 12049 | 1300 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991824.5048400005 | 2087077.28239 | 37.7102472009077 | -122.470054391311 | (37.7102472009077, -122.470054391311) | |||
| 188789 | 188789 | 1301 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 4000X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | 10 | 5991772.09471 | 2087046.42932 | 37.7101594558675 | -122.470233284447 | (37.7101594558675, -122.470233284447) | |||
| 11290 | 11290 | 1302 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4000X Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991739.11571 | 2087020.66511 | 37.7100868068254 | -122.470345390352 | (37.7100868068254, -122.470345390352) | |||
| 11332 | 11332 | 1303 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 10 | 5991684.008830001 | 2086976.4673900001 | 37.709962264210404 | -122.47053263188299 | (37.7099622642104, -122.470532631883) | |||
| 13013 | 13013 | 1304 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 10 | 5991645.96929 | 2086939.8139900002 | 37.7098594231521 | -122.470661434599 | (37.7098594231521, -122.470661434599) | |||
| 97785 | 97785 | 1774 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | |||
| 122506 | 122506 | 1775 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | |||
| 91674 | 91674 | 1776 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | |||
| 98783 | 98783 | 1777 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | |||
| 11630 | 11630 | 1793 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012296.32723 | 2088174.84774 | 37.7144231111167 | -122.399376144697 | (37.7144231111167, -122.399376144697) | |||
| 13232 | 13232 | 1794 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012280.2141 | 2088145.3083400002 | 37.7143411037303 | -122.399429765893 | (37.7143411037303, -122.399429765893) | |||
| 11710 | 11710 | 1795 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012264.68095 | 2088118.8470599998 | 37.714267580549105 | -122.399481598293 | (37.7142675805491, -122.399481598293) | |||
| 11170 | 11170 | 1796 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012245.53967 | 2088092.97358 | 37.714195470207 | -122.39954594300899 | (37.714195470207, -122.399545943009) | |||
| 112272 | 112272 | 1797 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2010 Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6012333.445831 | 2088436.5537268997 | 37.7151437722719 | -122.399266207491 | (37.7151437722719, -122.399266207491) | |||
| 10723 | 10723 | 1798 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012206.26499 | 2088043.30695 | 37.714056906280604 | -122.39967820720899 | (37.7140569062806, -122.399678207209) | ||
| 139686 | 139686 | 1799 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | |||
| 101386 | 101386 | 1800 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | ||
| 81891 | 81891 | 1801 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | ||
| 141476 | 141476 | 1802 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/11/2007 12:00:00 AM | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | ||
| 144221 | 144221 | 1803 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/11/2007 12:00:00 AM | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | ||
| 23356 | 23356 | 1808 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 6 | 6012226.450619999 | 2088069.6740700002 | 37.7141304303483 | -122.39961028768299 | (37.7141304303483, -122.399610287683) | |||
| 111393 | 111393 | 1809 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2040 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012267.4866135 | 2088237.9390645002 | 37.7145947398058 | -122.399480256716 | (37.7145947398058, -122.399480256716) | |||
| 97318 | 97318 | 1810 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2040 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012267.4866135 | 2088237.9390645002 | 37.7145947398058 | -122.399480256716 | (37.7145947398058, -122.399480256716) | ||
| 82072 | 82072 | 1811 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2040 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012267.4866135 | 2088237.9390645002 | 37.7145947398058 | -122.399480256716 | (37.7145947398058, -122.399480256716) | |||
| 84693 | 84693 | 1816 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2100 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012027.2003656 | 2087907.9406618 | 37.7136752340099 | -122.400287624748 | (37.7136752340099, -122.400287624748) | |||
| 125100 | 125100 | 1818 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2100 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 3 | 6 | 6012027.2003656 | 2087907.9406618 | 37.7136752340099 | -122.400287624748 | (37.7136752340099, -122.400287624748) | ||
| 11132 | 11132 | 1820 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 3 | 6 | 6011846.03792 | 2087600.59079 | 37.7128212089973 | -122.400892211026 | (37.7128212089973, -122.400892211026) | ||
| 11580 | 11580 | 1821 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 6 | 6 | 6011817.461569999 | 2087571.87835 | 37.712740776339295 | -122.400988964593 | (37.7127407763393, -122.400988964593) | ||
| 11934 | 11934 | 1822 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011791.38112 | 2087549.257 | 37.7126772077525 | -122.401077519005 | (37.7126772077525, -122.401077519005) | |||
| 12292 | 12292 | 1840 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011305.78262 | 2087356.70002 | 37.7121213835762 | -122.40274237725401 | (37.7121213835762, -122.402742377254) | |||
| 10446 | 10446 | 1841 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011283.06964 | 2087344.7309400002 | 37.712087250691 | -122.40282003911301 | (37.712087250691, -122.402820039113) | |||
| 12160 | 12160 | 1842 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6011254.373459999 | 2087325.01114 | 37.7120315017345 | -122.402917835889 | (37.7120315017345, -122.402917835889) | |||
| 19280 | 19280 | 1843 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2200 Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011383.0146015 | 2087402.1416029998 | 37.712250468957 | -122.40247863283399 | (37.712250468957, -122.402478632834) | |||
| 106367 | 106367 | 1854 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2500 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010837.5147418 | 2086759.4488696998 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | |||
| 138313 | 138313 | 1855 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2500 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 6010837.5147418 | 2086759.4488696998 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | |||
| 139020 | 139020 | 1856 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2500 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010837.5147418 | 2086759.4488696998 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | |||
| 11567 | 11567 | 1857 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010751.52595 | 2086559.13987 | 37.7099004816803 | -122.404601950438 | (37.7099004816803, -122.404601950438) | |||
| 11400 | 11400 | 1858 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010736.7682300005 | 2086529.19155 | 37.709817424799 | -122.404650849269 | (37.709817424799, -122.404650849269) | |||
| 10337 | 10337 | 1859 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6010721.136519999 | 2086497.1887700001 | 37.7097286779125 | -122.404702624138 | (37.7097286779125, -122.404702624138) | |||
| 10981 | 10981 | 1860 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6010703.231369999 | 2086455.7019 | 37.709613762523205 | -122.404761589082 | (37.7096137625232, -122.404761589082) | |||
| 87252 | 87252 | 1861 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2510 Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6010780.8257042 | 2086709.3373148 | 37.710314531205896 | -122.404511250175 | (37.7103145312059, -122.404511250175) | |||
| 86585 | 86585 | 1862 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2510 Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010780.8257042 | 2086709.3373148 | 37.710314531205896 | -122.404511250175 | (37.7103145312059, -122.404511250175) | |||
| 124289 | 124289 | 2008 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12x100 | 6002728.1222807 | 2095276.2570246002 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | |||
| 20359 | 20359 | 2009 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 500X Bosworth St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002500.74236 | 2095308.75952 | 37.733460405376896 | -122.433743117057 | (37.7334604053769, -122.433743117057) | |||
| 19299 | 19299 | 2010 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 500X Bosworth St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002516.8064 | 2095305.3641599999 | 37.73345199401611 | -122.4336873366 | (37.7334519940161, -122.4336873366) | |||
| 19231 | 19231 | 2011 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002543.1242 | 2095301.43659 | 37.7334427031002 | -122.433596068029 | (37.7334427031002, -122.433596068029) | |||
| 21568 | 21568 | 2012 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 6002566.51434 | 2095294.967 | 37.7334262662011 | -122.43351473961599 | (37.7334262662011, -122.433514739616) | |||
| 17146 | 17146 | 2013 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002577.1884699995 | 2095292.92439 | 37.7334212632741 | -122.433477690263 | (37.7334212632741, -122.433477690263) | |||
| 19416 | 19416 | 2014 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 6002609.44021 | 2095285.23051 | 37.733401967419205 | -122.43336563743799 | (37.7334019674192, -122.433365637438) | |||
| 20093 | 20093 | 2015 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002627.0989 | 2095279.66022 | 37.733387674484604 | -122.433304188563 | (37.7333876744846, -122.433304188563) | |||
| 120471 | 120471 | 2028 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 600X Bosworth St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) |
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");