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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
761 | 761 | 195041 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 402 06th St | 1 | : 4 | Tree 1 | DPW 2 | 28 | Width 3ft | 6011480.36813 | 2111044.01847 | 37.777171403968296 | -122.40380468436199 | (37.7771714039683, -122.403804684362) | |||
1334 | 1334 | 250499 | Undocumented 2 | Tree(s) :: 17 | 540 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779924 | 5986884.24135 | 2115388.89729 | 37.7876964378791 | -122.489208879795 | (37.7876964378791, -122.489208879795) | |
1541 | 1541 | 196583 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6010636.210390001 | 2110621.8756 | 37.7759651028325 | -122.406695151275 | (37.7759651028325, -122.406695151275) | |||
1554 | 1554 | 196582 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6010641.65206 | 2110616.23142 | 37.7759499096844 | -122.40667592917801 | (37.7759499096844, -122.406675929178) | |||
1969 | 1969 | 198010 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 213 Clara St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | Permit Number 779305 | 6011863.46506 | 2111836.2655700003 | 37.7793681257663 | -122.40253514649099 | (37.7793681257663, -122.402535146491) | ||
2282 | 2282 | 234424 | Undocumented 2 | Photinia fraseri :: Photinia Tree 153 | 360 Church St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 780144 | 6004154.11162 | 2106813.1044400004 | 37.7651423384845 | -122.428846830126 | (37.7651423384845, -122.428846830126) | ||
2381 | 2381 | 201818 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 2 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021088.08179 | 2093322.4173400002 | 37.7290434795636 | -122.369343396492 | (37.7290434795636, -122.369343396492) | ||
2409 | 2409 | 201824 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 8 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021004.603680001 | 2093212.5880900002 | 37.728737329640495 | -122.369624404053 | (37.7287373296405, -122.369624404053) | ||
2410 | 2410 | 201817 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021101.98762 | 2093338.62944 | 37.7290887577236 | -122.36929644199101 | (37.7290887577236, -122.369296441991) | ||
2438 | 2438 | 201823 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 7 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021023.85438 | 2093233.10906 | 37.728794732485206 | -122.369559269737 | (37.7287947324852, -122.369559269737) | ||
2514 | 2514 | 246848 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 10 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001221.8841699995 | 2109765.97896 | 37.773083798207296 | -122.439200331843 | (37.7730837982073, -122.439200331843) | |||
2519 | 2519 | 246843 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 5 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001198.912769999 | 2109877.26909 | 37.7733880658265 | -122.439287771129 | (37.7733880658265, -122.439287771129) | |||
2532 | 2532 | 246847 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 9 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001212.96216 | 2109784.10249 | 37.773133053181404 | -122.43923249339198 | (37.7731330531814, -122.439232493392) | |||
2533 | 2533 | 246849 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 11 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001216.8657599995 | 2109748.1446700003 | 37.7730345441487 | -122.439216412614 | (37.7730345441487, -122.439216412614) | |||
2535 | 2535 | 246841 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 3 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001195.01805 | 2109899.62825 | 37.7734492368388 | -122.439302846449 | (37.7734492368388, -122.439302846449) | |||
2546 | 2546 | 246846 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 8 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001207.38463 | 2109809.38993 | 37.773202168766105 | -122.43925359959101 | (37.7732021687661, -122.439253599591) | |||
2552 | 2552 | 246840 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 2 | : 4 | Tree 1 | DPW for City Agency 10 | 19 | Width 3ft | 6001188.51269 | 2109936.2184200003 | 37.7735493340682 | -122.43932797261999 | (37.7735493340682, -122.43932797262) | |||
2553 | 2553 | 246842 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 4 | : 4 | Tree 1 | DPW for City Agency 10 | 15 | Width 4ft | 6001208.43411 | 2109888.06605 | 37.7734182533891 | -122.439255609578 | (37.7734182533891, -122.439255609578) | |||
2554 | 2554 | 246844 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 6 | : 4 | Tree 1 | DPW for City Agency 10 | 17 | Width 3ft | 6001203.63374 | 2109838.69012 | 37.773282406297895 | -122.439268674924 | (37.7732824062979, -122.439268674924) | |||
2565 | 2565 | 191072 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 779704 | 6008614.31812 | 2108613.9778 | 37.770338555601505 | -122.41354738542101 | (37.7703385556015, -122.413547385421) | ||
3873 | 3873 | 228872 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 32 Church St | 1 | : 4 | Tree 1 | Private 1 | 10/02/2017 12:00:00 AM | 3 | 4x7 | Permit Number 780415 | 6004066.01114 | 2108522.69035 | 37.7698314611737 | -122.42927346400101 | (37.7698314611737, -122.429273464001) | |
5171 | 5171 | 247184 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | |
5187 | 5187 | 247186 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | Permit Number 780753 | 6000985.28448 | 2108903.00262 | 37.770700815109294 | -122.439956869431 | (37.7707008151093, -122.439956869431) | ||
22286 | 22286 | 188618 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 15 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015989.5781 | 2098825.23782 | 37.7438721192948 | -122.387353189223 | (37.7438721192948, -122.387353189223) | |||
22360 | 22360 | 191245 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1675 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6014937.212180001 | 2097262.06336 | 37.7395216264201 | -122.3908828304 | (37.7395216264201, -122.3908828304) | |||
22364 | 22364 | 249565 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Franklin St | 3 | : 4 | Tree 1 | Private 1 | 25 | Width 4ft | 6005937.376069999 | 2114355.05187 | 37.785951472517 | -122.423215093814 | (37.785951472517, -122.423215093814) | |||
22855 | 22855 | 188957 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1708 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6014940.685740001 | 2096639.31184 | 37.73781187133179 | -122.39082730983499 | (37.7378118713318, -122.390827309835) | |||
22878 | 22878 | 211497 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 500 Junipero Serra Blvd | 69 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991316.04145 | 2093239.9376700001 | 37.7271389322076 | -122.472260663898 | (37.7271389322076, -122.472260663898) | |||
22880 | 22880 | 230389 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 51 13th St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008142.81587 | 2108281.73826 | 37.7693998171644 | -122.41515479496701 | (37.7693998171644, -122.415154794967) | |||
22911 | 22911 | 238577 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 133 Buchanan St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004747.18096 | 2108954.98025 | 37.771056963743 | -122.426948105892 | (37.771056963743, -122.426948105892) | |||
23411 | 23411 | 195158 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1188 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6011916.5871 | 2102892.02207 | 37.7548122137394 | -122.401722520004 | (37.7548122137394, -122.401722520004) | |||
23416 | 23416 | 247236 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Haight St | 1 | : 4 | Tree 1 | Private 1 | 26 | Width 6ft | 6000176.36555 | 2108836.62464 | 37.770472476353 | -122.442750157415 | (37.770472476353, -122.442750157415) | |||
23424 | 23424 | 197132 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016788.78445 | 2098277.43468 | 37.742412193171795 | -122.384551543811 | (37.7424121931718, -122.384551543811) | |||
23436 | 23436 | 187515 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Lauren Ct | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6012570.47183 | 2088125.85933 | 37.7143038745038 | -122.398425150324 | (37.7143038745038, -122.398425150324) | |||
23455 | 23455 | 194596 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 800 Wisconsin St | 7 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6012720.64304 | 2103613.2936299997 | 37.7568375049672 | -122.398992475934 | (37.7568375049672, -122.398992475934) | |||
23459 | 23459 | 240288 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 3980 22nd St | 2 | : 4 | Tree 1 | Private 1 | 20 | 6001954.916780001 | 2102957.6016 | 37.7544313427449 | -122.43617736779 | (37.7544313427449, -122.43617736779) | ||||
23467 | 23467 | 205659 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1598 10th Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5993106.7424 | 2104692.3682 | 37.7586878807581 | -122.466902491455 | (37.7586878807581, -122.466902491455) | |||
23483 | 23483 | 234406 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 147 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 8ft | 6006058.10348 | 2108951.831 | 37.7711223543454 | -122.422413351811 | (37.7711223543454, -122.422413351811) | |||
23494 | 23494 | 219849 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 72 Skyview Way | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997939.73785 | 2101790.86322 | 37.7509988274335 | -122.449978746126 | (37.7509988274335, -122.449978746126) | |||
23501 | 23501 | 187800 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2 Heron St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6009988.42633 | 2110014.66553 | 37.7742615809293 | -122.40889316451499 | (37.7742615809293, -122.408893164515) | |||
23509 | 23509 | 188616 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 13 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015976.85216 | 2098785.54996 | 37.7437624397877 | -122.38739442491999 | (37.7437624397877, -122.38739442492) | |||
23518 | 23518 | 247709 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 848 Waller St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6001610.36211 | 2108740.78692 | 37.7702909742819 | -122.437783100124 | (37.7702909742819, -122.437783100124) | |||
23554 | 23554 | 193631 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2 Industrial St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012126.8471099995 | 2097436.10996 | 37.7398431844134 | -122.400612133368 | (37.7398431844134, -122.400612133368) | |||
23570 | 23570 | 250043 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 Daniel Burnham Ct | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006138.25466 | 2114733.68143 | 37.787002430166396 | -122.422547022523 | (37.7870024301664, -122.422547022523) | |||
23580 | 23580 | 212649 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 321 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5992450.10328 | 2090020.5964400002 | 37.7183649772426 | -122.468106177365 | (37.7183649772426, -122.468106177365) | |||
23603 | 23603 | 231527 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 127 Scott St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6002315.440669999 | 2108966.67057 | 37.7709512619163 | -122.435360399361 | (37.7709512619163, -122.435360399361) | |||
23608 | 23608 | 210892 | Undocumented 2 | Paulownia tomentosa :: Empress Tree 332 | 210 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992474.84263 | 2089237.23886 | 37.7162154959333 | -122.467963716667 | (37.7162154959333, -122.467963716667) | |||
23657 | 23657 | 196979 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1551 20th St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013315.21298 | 2104723.80911 | 37.7599198521353 | -122.39701407983802 | (37.7599198521353, -122.397014079838) | |||
23679 | 23679 | 191569 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1610 Innes Ave | 8 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6015206.39657 | 2097489.64193 | 37.7401614427971 | -122.38996799323401 | (37.7401614427971, -122.389967993234) | |||
23687 | 23687 | 235690 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 63 Laussat St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6004411.60055 | 2109266.67882 | 37.7718938314631 | -122.428131106459 | (37.7718938314631, -122.428131106459) | |||
23710 | 23710 | 199357 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 929 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 23 | Width 7ft | 6011910.785069999 | 2104052.6476 | 37.757998712287204 | -122.401824164069 | (37.7579987122872, -122.401824164069) | |||
23714 | 23714 | 234376 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6008587.75214 | 2108113.66978 | 37.7689633348285 | -122.41360388622499 | (37.7689633348285, -122.413603886225) | |||
23726 | 23726 | 192170 | Undocumented 2 | Ficus rubiginosa :: Port Jackson Fig 188 | 1601 Kansas St | 9 | : 4 | Tree 1 | Private 1 | 51 | Width 7ft | 6011813.79085 | 2100866.0430099997 | 37.749243580141204 | -122.40193560806001 | (37.7492435801412, -122.40193560806) | |||
23741 | 23741 | 234546 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 390 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6006093.30748 | 2107339.39133 | 37.7666969650198 | -122.422177005484 | (37.7666969650198, -122.422177005484) | |||
23764 | 23764 | 197793 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 66 Ceres St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6013832.07065 | 2093815.87712 | 37.7299977259065 | -122.394462716674 | (37.7299977259065, -122.394462716674) | |||
23814 | 23814 | 247646 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6001616.30949 | 2108303.20625 | 37.769089824469496 | -122.43773118404499 | (37.7690898244695, -122.437731184045) | |||
23825 | 23825 | 247187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6000970.93564 | 2108908.88323 | 37.770716144966 | -122.440006923906 | (37.770716144966, -122.440006923906) | |||
23828 | 23828 | 177148 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991345.1062 | 2088786.2704900003 | 37.7149119421181 | -122.47183574413401 | (37.7149119421181, -122.471835744134) | |||
23879 | 23879 | 193824 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1550 Fairfax Ave | 3 | : 4 | Tree 1 | Private 1 | 14 | Width 6ft | 6015655.00087 | 2098203.32161 | 37.742145929985796 | -122.388466689285 | (37.7421459299858, -122.388466689285) | |||
23924 | 23924 | 215624 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 66 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991139.11135 | 2090614.21248 | 37.7199191010706 | -122.47268094048201 | (37.7199191010706, -122.472680940482) | |||
23930 | 23930 | 246508 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 241 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6004932.15845 | 2099866.5422 | 37.7461127118493 | -122.425661300149 | (37.7461127118493, -122.425661300149) | |||
23940 | 23940 | 190941 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1701 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013964.79274 | 2095080.10635 | 37.733476418703496 | -122.39409234708599 | (37.7334764187035, -122.394092347086) | |||
23951 | 23951 | 222885 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006051.02822 | 2109339.24494 | 37.7721857010308 | -122.422465357814 | (37.7721857010308, -122.422465357814) | |||
23966 | 23966 | 221105 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009452.05657 | 2105439.4087799997 | 37.761668922891296 | -122.41042544467301 | (37.7616689228913, -122.410425444673) | |||
24000 | 24000 | 246500 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 273 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6004745.35521 | 2099854.76299 | 37.746069811469 | -122.426306403626 | (37.746069811469, -122.426306403626) | |||
24013 | 24013 | 232628 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 Starview Way | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997489.976480001 | 2102197.32823 | 37.7520891340271 | -122.451563373145 | (37.7520891340271, -122.451563373145) | |||
24033 | 24033 | 189426 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 553 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 7ft | 6013011.23422 | 2104452.4501799997 | 37.759157834075204 | -122.398046364864 | (37.7591578340752, -122.398046364864) | |||
24055 | 24055 | 188977 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2000 Thomas Ave | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6012688.07294 | 2095454.3657900002 | 37.7344330140672 | -122.398532612087 | (37.7344330140672, -122.398532612087) | |||
24067 | 24067 | 201949 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 18 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013468.57071 | 2092447.06427 | 37.7262190300648 | -122.395623522912 | (37.7262190300648, -122.395623522912) | |||
24071 | 24071 | 250790 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 284 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985915.81821 | 2114007.58209 | 37.7838471713633 | -122.49245762762101 | (37.7838471713633, -122.492457627621) | |||
24091 | 24091 | 193642 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2000 Oakdale Ave | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012823.32202 | 2097168.087 | 37.739146068631705 | -122.398185200408 | (37.7391460686317, -122.398185200408) | |||
24128 | 24128 | 198134 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 131 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6013337.1330699995 | 2095632.7165299999 | 37.7349588665628 | -122.396301078452 | (37.7349588665628, -122.396301078452) | |||
24147 | 24147 | 210947 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 171 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992177.81487 | 2089015.3385599998 | 37.715589054271 | -122.468974238973 | (37.715589054271, -122.468974238973) | |||
24219 | 24219 | 189857 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6017207.28329 | 2098227.98563 | 37.7422995503725 | -122.383101045278 | (37.7422995503725, -122.383101045278) | |||
24236 | 24236 | 213361 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Elmhurst Dr | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991216.12738 | 2094471.85178 | 37.730515676960394 | -122.47269584493701 | (37.7305156769604, -122.472695844937) | |||
24261 | 24261 | 250049 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 Daniel Burnham Ct | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005972.08253 | 2114712.11265 | 37.7869338316717 | -122.42312040780199 | (37.7869338316717, -122.423120407802) | |||
24285 | 24285 | 211375 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 462 Head St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993511.66198 | 2088947.80239 | 37.7154805924354 | -122.46435899649201 | (37.7154805924354, -122.464358996492) | |||
24295 | 24295 | 249534 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6006252.357009999 | 2114034.72493 | 37.785089704362704 | -122.422102579373 | (37.7850897043627, -122.422102579373) | |||
24309 | 24309 | 191424 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 743 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012751.8613599995 | 2104046.56843 | 37.758028922326496 | -122.398914919298 | (37.7580289223265, -122.398914919298) | |||
24318 | 24318 | 195049 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 425 07th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011046.10585 | 2110191.14121 | 37.7748053308349 | -122.405246869567 | (37.7748053308349, -122.405246869567) | |||
24332 | 24332 | 246923 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 411 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 6ft | 5997906.77047 | 2107481.56832 | 37.7666221917918 | -122.450502958247 | (37.7666221917918, -122.450502958247) | |||
24334 | 24334 | 246922 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 417 Frederick St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 5997854.3485 | 2107475.00928 | 37.7666011818151 | -122.45068380291 | (37.7666011818151, -122.45068380291) | |||
24340 | 24340 | 241638 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200 Guerrero St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6005425.11854 | 2107744.6412400003 | 37.767771973225 | -122.424516988391 | (37.767771973225, -122.424516988391) | |||
24358 | 24358 | 211712 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 418 San Miguel St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997865.28032 | 2089936.92549 | 37.7184464872957 | -122.449382239324 | (37.7184464872957, -122.449382239324) | |||
24372 | 24372 | 246497 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 319 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 6ft | 6004279.93355 | 2099832.71811 | 37.7459829621447 | -122.427914200798 | (37.7459829621447, -122.427914200798) | |||
24373 | 24373 | 201122 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3401 03rd St | 11 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016102.9288 | 2099545.92892 | 37.7458572657 | -122.387011499888 | (37.7458572657, -122.387011499888) | |||
24374 | 24374 | 192945 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 238 11th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6008246.27864 | 2109382.4071299997 | 37.7724278093356 | -122.41487483150401 | (37.7724278093356, -122.414874831504) | |||
24404 | 24404 | 246777 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Esmeralda Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009797.217759999 | 2098767.51115 | 37.743368720206206 | -122.408760953364 | (37.7433687202062, -122.408760953364) | |||
24435 | 24435 | 189790 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 671 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6013319.6658 | 2103964.90842 | 37.7578363244071 | -122.39694547056601 | (37.7578363244071, -122.396945470566) | |||
24466 | 24466 | 207106 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 Tara St | 2 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | |||
24505 | 24505 | 195054 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 820 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6011686.5663 | 2110516.6477900003 | 37.775734882702295 | -122.403054272047 | (37.7757348827023, -122.403054272047) | |||
24506 | 24506 | 213803 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 216 Byxbee St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5991962.814730001 | 2089977.4457200002 | 37.7182183418945 | -122.469787374494 | (37.7182183418945, -122.469787374494) | |||
24550 | 24550 | 200288 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 450 Texas St | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6013765.39611 | 2104962.6941 | 37.7606008277911 | -122.39547383976499 | (37.7606008277911, -122.395473839765) | |||
24574 | 24574 | 250326 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5987393.53331 | 2114913.8058 | 37.786421687562104 | -122.487411939018 | (37.7864216875621, -122.487411939018) | |||
24599 | 24599 | 225999 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 700 Duboce Ave | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6002335.19401 | 2108315.06979 | 37.7691632487104 | -122.435245457027 | (37.7691632487104, -122.435245457027) | |||
24622 | 24622 | 247221 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 187 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6001849.330080001 | 2108668.89946 | 37.770107174421796 | -122.436951364836 | (37.7701071744218, -122.436951364836) | |||
24628 | 24628 | 193040 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1890 Evans Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6014266.5091 | 2099591.88048 | 37.745881580665 | -122.393364845912 | (37.745881580665, -122.393364845912) | |||
24639 | 24639 | 229283 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 995 Potrero Ave | 12 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6010503.18066 | 2104324.48808 | 37.758666470594896 | -122.40671143888099 | (37.7586664705949, -122.406711438881) | |||
24687 | 24687 | 188070 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2001 Revere Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6012192.04216 | 2096531.53608 | 37.737363051155796 | -122.400323196466 | (37.7373630511558, -122.400323196466) | |||
24712 | 24712 | 189244 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013923.095430001 | 2103892.83973 | 37.757672010179206 | -122.394853496397 | (37.7576720101792, -122.394853496397) |
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");