trees
150 rows where Police Districts = 4 and qLegalStatus_id = 6 sorted by Location
This data as json, CSV (advanced)
These facets timed out: Police Districts
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
86615 | 253183 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 5159 Diamond Heights Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 6000808 | 2099903 | 37.745978911495 | -122.439924689335 | (37.745978911495, -122.439924689335) | 2 | 4 | 5 | 63 | 22 | |||||
68284 | 253182 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 5157 Diamond Heights Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 6000788 | 2100195 | 37.7467795353698 | -122.440014780391 | (37.7467795353698, -122.440014780391) | 2 | 4 | 5 | 63 | 22 | |||||
159982 | 102589 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 5157 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6000788.8 | 2100195.2 | 37.7467801300642 | -122.440012028415 | (37.7467801300642, -122.440012028415) | 2 | 4 | 5 | 63 | 22 | ||||
91521 | 255902 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3943 Cesar Chavez St | 1 | Front Yard : Yard | Tree | Private 2 | 6004266 | 2100418 | 37.7475892225894 | -122.428004081153 | (37.7475892225894, -122.428004081153) | 2 | 4 | 5 | 63 | 22 | |||||
1790 | 103256 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 4187 26th St | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 3x3 | 6002700 | 2100625 | 37.7480688746475 | -122.433434000346 | (37.7480688746475, -122.433434000346) | 2 | 4 | 5 | 63 | 22 | |||
194449 | 262095 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 3550 Cesar Chavez St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 785078 | 6006203 | 2100616 | 37.7482422814736 | -122.421320098122 | (37.7482422814736, -122.421320098122) | 2 | 4 | 5 | 28859 | 19 | |||
173080 | 105857 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 1500X Valencia St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006259.2 | 2100711.5 | 37.7485076710609 | -122.421132539956 | (37.7485076710609, -122.421132539956) | 2 | 4 | 5 | 28859 | 19 | ||||
112541 | 255922 | Significant Tree 6 | Alnus rhombifolia :: White Alder 327 | 554 Clipper St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6001599 | 2100911 | 37.7487916364102 | -122.437261685392 | (37.7487916364102, -122.437261685392) | 2 | 4 | 5 | 28862 | 22 | ||||
29057 | 116956 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 380 SAN JOSE AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 28 | 3x3 | 6006172 | 2100967 | 37.7492042995658 | -122.421452219126 | (37.7492042995658, -122.421452219126) | 2 | 4 | 5 | 28859 | 19 | |||
32199 | 253765 | Significant Tree 6 | Cornus SPP :: Dogwood 355 | 1366 Guerrero St | 2 | Front Yard : Yard | Tree | Private 2 | 02/14/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780977 | 6005800.08489 | 2101007.66776 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | 2 | 4 | 5 | 28859 | 19 | |
43399 | 117435 | Significant Tree 6 | Salix babylonica :: Weeping Willow 308 | 98X CLIPPER ST | 1 | Back Yard : Yard | Tree | Private 2 | 6004559 | 2101087 | 37.7494427139243 | -122.427038546128 | (37.7494427139243, -122.427038546128) | 2 | 4 | 5 | 28862 | 22 | |||||
61723 | 111634 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 3009 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6009514.91537658 | 2100993.40768569 | 37.7494647260255 | -122.40989418187 | (37.7494647260255, -122.40989418187) | 2 | 4 | 7 | 28859 | 19 | |||
59089 | 116955 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 818 Douglass St | 1 | Front Yard : Cutout | Tree | Private 2 | 6 | 3x3 | 6001245 | 2101454 | 37.7502624545247 | -122.43852471352 | (37.7502624545247, -122.43852471352) | 2 | 4 | 5 | 28862 | 22 | |||
194330 | 265002 | Significant Tree 6 | :: Tree 573 | 1445 San Bruno Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5x5 | 6011217 | 2101257 | 37.7502837374969 | -122.404026841996 | (37.7502837374969, -122.404026841996) | 10 | 4 | 8 | 28859 | 19 | ||||
15065 | 261762 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 2943 Harrison St | 1 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6009034.67775 | 2101326.83516 | 37.7503533174728 | -122.411578417814 | (37.7503533174728, -122.411578417814) | 2 | 4 | 7 | 28859 | 19 | ||||
192074 | 101233 | Significant Tree 6 | Tree(s) :: 17 | 3740 25th St | 1 | Front Yard : Yard | Tree | Private 2 | 10/04/2012 12:00:00 AM | Permit Number 769197 | 6005584 | 2101403 | 37.7503682845448 | -122.423516527668 | (37.7503682845448, -122.423516527668) | 2 | 4 | 5 | 28859 | 19 | |||
144070 | 97894 | Significant Tree 6 | Tree(s) :: 17 | 2927 Folsom St | Front Yard : Yard | Tree | Private 2 | 02/29/2012 12:00:00 AM | 30 | Permit Number 768566 | 6008395 | 2101384 | 37.7504743768844 | -122.413794517972 | (37.7504743768844, -122.413794517972) | 2 | 4 | 7 | 28859 | 19 | |||
107642 | 251173 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 367 Jersey St | 2 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6002770.52649 | 2101500.01269 | 37.7504754543841 | -122.433252636724 | (37.7504754543841, -122.433252636724) | 2 | 4 | 5 | 28862 | 22 | ||||
9966 | 251172 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 363 Jersey St | 2 | Front Yard : Yard | Tree | Private 2 | 6002784.74363 | 2101501.25508 | 37.750479672211 | -122.433203561601 | (37.750479672211, -122.433203561601) | 2 | 4 | 5 | 28862 | 22 | |||||
89841 | 253178 | Significant Tree 6 | Washingtonia filifera :: California Fan Palm 176 | 4450 24th St | 2 | Front Yard : Cutout | Tree | Private 2 | Width 0ft | Permit Number 780574 | 6000289.52403 | 2101701.02913 | 37.7508863393389 | -122.441846529398 | (37.7508863393389, -122.441846529398) | 2 | 4 | 5 | 28862 | 22 | |||
8316 | 260638 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 3140 25th St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008726.17419 | 2101580.94088 | 37.7510337250786 | -122.412663209658 | (37.7510337250786, -122.412663209658) | 2 | 4 | 7 | 28859 | 19 | |||
93094 | 106927 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 4150 24th St | Sidewalk: Property side : Cutout | Tree | Private 2 | 1.5X1.5 | Permit Number 772519 | 6002207.56819 | 2101805.30097 | 37.7512817512061 | -122.435221219626 | (37.7512817512061, -122.435221219626) | 2 | 4 | 5 | 28862 | 22 | ||||
20184 | 108109 | Significant Tree 6 | Tree(s) :: 17 | 952 CAPP ST | 1 | Front Yard : Yard | Tree | Private 2 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774355 | 6007364.7 | 2101732.3 | 37.7513728159016 | -122.417382061559 | (37.7513728159016, -122.417382061559) | 2 | 4 | 7 | 28859 | 19 | |
172650 | 255483 | Significant Tree 6 | Persea americana :: Avocado 34 | 1295 Hampshire St | 1 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6010340.83328 | 2101731.71507 | 37.7515382084299 | -122.407090155993 | (37.7515382084299, -122.407090155993) | 10 | 4 | 7 | 28859 | 19 | ||||
24634 | 111770 | Significant Tree 6 | Pittosporum tobira :: Japanese Mockorange 118 | 707 Douglass St | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 775627 | 6001281 | 2102187.2 | 37.7522776937422 | -122.438452748375 | (37.7522776937422, -122.438452748375) | 2 | 4 | 5 | 28862 | 22 | ||||
23877 | 105554 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 410 Elizabeth St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 772516 | 6003623.1 | 2102191.9 | 37.7524235434098 | -122.430353733326 | (37.7524235434098, -122.430353733326) | 2 | 4 | 5 | 28862 | 22 | ||||
46751 | 105555 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 410 Elizabeth St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 772516 | 6003623.1 | 2102191.9 | 37.7524235434098 | -122.430353733326 | (37.7524235434098, -122.430353733326) | 2 | 4 | 5 | 28862 | 22 | ||||
61475 | 187629 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 4283 23rd St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6001353 | 2102279 | 37.7525338497288 | -122.438210337194 | (37.7525338497288, -122.438210337194) | 2 | 4 | 5 | 28862 | 22 | ||||
81588 | 113833 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 932 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 6007966 | 2102301 | 37.7529681504442 | -122.415342945464 | (37.7529681504442, -122.415342945464) | 2 | 4 | 7 | 28859 | 19 | ||||
108934 | 104726 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 1079 Church St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770313 | 6004474.7 | 2102638.1 | 37.7536969056436 | -122.427440543051 | (37.7536969056436, -122.427440543051) | 2 | 4 | 5 | 28862 | 22 | ||||
89489 | 112577 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 3326 23RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Permit Number 775776 | 6006851 | 2102663.4 | 37.7539004875763 | -122.419224541208 | (37.7539004875763, -122.419224541208) | 2 | 4 | 7 | 28859 | 19 | |||
145683 | 112626 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3430X 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6006285 | 2102686.4 | 37.7539317482446 | -122.421183538041 | (37.7539317482446, -122.421183538041) | 2 | 4 | 5 | 28859 | 19 | ||||
170834 | 107493 | Significant Tree 6 | Tree(s) :: 17 | 180 BARTLETT ST | 1 | Back Yard : Yard | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | Permit Number 774017 | 6006657.2 | 2102756.7 | 37.7541457516772 | -122.419901368465 | (37.7541457516772, -122.419901368465) | 2 | 4 | 7 | 28859 | 19 | ||
182270 | 107121 | Significant Tree 6 | Cercis canadensis :: Eastern Redbud 346 | 1054 GUERRERO ST | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6005686.8 | 2102852.5 | 37.7543540785936 | -122.423264063467 | (37.7543540785936, -122.423264063467) | 2 | 4 | 5 | 28859 | 19 | ||||
13092 | 261764 | Significant Tree 6 | Melaleuca quinquenervia :: Cajeput 10 | 130 Bartlett St | 2 | Front Yard : Cutout | Tree | Private 2 | 4x4 | 6006663 | 2102839 | 37.7543720553146 | -122.419887150249 | (37.7543720553146, -122.419887150249) | 2 | 4 | 7 | 28859 | 19 | ||||
18002 | 261423 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 2400x 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011254 | 2102764 | 37.7544236960072 | -122.404004933004 | (37.7544236960072, -122.404004933004) | 10 | 4 | 8 | 28859 | 19 | ||||
34658 | 104715 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 3618 22nd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.428325838726 | (37.7549616692716, -122.428325838726) | 2 | 4 | 5 | 28862 | 22 | ||||
103792 | 104717 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 3618 22nd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.428325838726 | (37.7549616692716, -122.428325838726) | 2 | 4 | 5 | 28862 | 22 | ||||
138982 | 104716 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 3618 22nd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.428325838726 | (37.7549616692716, -122.428325838726) | 2 | 4 | 5 | 28862 | 22 | ||||
27985 | 253620 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 1120 South Van Ness Ave | 3 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 6007603.98274 | 2103104.14442 | 37.7551530486792 | -122.416651764192 | (37.7551530486792, -122.416651764192) | 2 | 4 | 7 | 28859 | 19 | ||||
69856 | 112572 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 162 GRAND VIEW AVE | 4 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000754 | 2103380 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | 2 | 4 | 5 | 63 | 38 | ||||
78900 | 254971 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 972 Guerrero St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6005650 | 2103315 | 37.7556219192197 | -122.423424204919 | (37.7556219192197, -122.423424204919) | 2 | 4 | 5 | 28859 | 19 | ||||
194287 | 264983 | Significant Tree 6 | Yucca spp :: Yucca 289 | 2957 22nd St | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6008491 | 2103259 | 37.7556280948319 | -122.41359514096 | (37.7556280948319, -122.41359514096) | 2 | 4 | 7 | 28859 | 19 | |||||
43597 | 78107 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 970 GUERRERO ST | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 6005649.9 | 2103318.5 | 37.7556315237614 | -122.423424799558 | (37.7556315237614, -122.423424799558) | 2 | 4 | 5 | 28859 | 19 | ||||
8218 | 100711 | Significant Tree 6 | Tree(s) :: 17 | 966-968 Guerrero St | 1 | Front Yard : Yard | Tree | Private 2 | 09/27/2012 12:00:00 AM | 14 | Permit Number 769148 | 6005605.8 | 2103343.5 | 37.7556976788024 | -122.423579088745 | (37.7556976788024, -122.423579088745) | 2 | 4 | 5 | 28859 | 19 | ||
143770 | 110950 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 342 HILL ST | Front Yard : Yard | Tree | Private 2 | 15 | 3x3 | Permit Number 778799 | 6004048 | 2103384 | 37.7557208285242 | -122.428969343229 | (37.7557208285242, -122.428969343229) | 2 | 4 | 5 | 28862 | 22 | |||
12923 | 237906 | Significant Tree 6 | Tree(s) :: 17 | 3937 21st St | 3 | Front Yard : Yard | Tree | Private 2 | 10/06/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785171 | 6002245.41508 | 2103514.00804 | 37.7559756019151 | -122.43521254633 | (37.7559756019151, -122.43521254633) | 2 | 4 | 5 | 28862 | 22 | |
10271 | 262199 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 801 Sanchez St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003778 | 2103544 | 37.7561448640021 | -122.429914501498 | (37.7561448640021, -122.429914501498) | 2 | 4 | 5 | 28862 | 22 | ||||
16292 | 262198 | Significant Tree 6 | Pittosporum tobira :: Japanese Mockorange 118 | 801 Sanchez St | 2 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003778 | 2103544 | 37.7561448640021 | -122.429914501498 | (37.7561448640021, -122.429914501498) | 2 | 4 | 5 | 28862 | 22 | ||||
19453 | 261628 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3930 21st St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6002255 | 2103579 | 37.7561545985327 | -122.435184046951 | (37.7561545985327, -122.435184046951) | 2 | 4 | 5 | 28862 | 3 | ||||
113215 | 108560 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 330 | 3790 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003155.9 | 2103640.4 | 37.7563743055091 | -122.432072816055 | (37.7563743055091, -122.432072816055) | 2 | 4 | 5 | 28862 | 3 | |||||
12225 | 102131 | Significant Tree 6 | Tree(s) :: 17 | 850 Treat Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12/24/2012 12:00:00 AM | Permit Number 769452 | 6008548.2 | 2103592.2 | 37.7565461982029 | -122.413420887965 | (37.7565461982029, -122.413420887965) | 2 | 4 | 7 | 28859 | 19 | |||
113829 | 101236 | Significant Tree 6 | Tree(s) :: 17 | 895X Church St | 1 | Back Yard : Yard | Tree | Private 2 | 10/05/2012 12:00:00 AM | 13 | Permit Number 769299 | 6004383.5 | 2103691.7 | 37.7565846850157 | -122.427831000859 | (37.7565846850157, -122.427831000859) | 2 | 4 | 5 | 28862 | 3 | ||
9783 | 261822 | Significant Tree 6 | Acacia baileyana :: Bailey's Acacia 122 | 3580 21st St | 2 | Front Yard : Yard | Tree | Private 2 | Width 3ft | Permit Number 785112 | 6004538.52309 | 2103691.84305 | 37.7565938462521 | -122.427294885373 | (37.7565938462521, -122.427294885373) | 2 | 4 | 5 | 28862 | 3 | |||
3323 | 258079 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 606 Capp St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 6007262.82565 | 2103708.68672 | 37.7567937898158 | -122.417874439265 | (37.7567937898158, -122.417874439265) | 2 | 4 | 7 | 28859 | 19 | ||||
193898 | 258078 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 606 Capp St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 6007262.82565 | 2103708.68672 | 37.7567937898158 | -122.417874439265 | (37.7567937898158, -122.417874439265) | 2 | 4 | 7 | 28859 | 19 | ||||
2713 | 121088 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1X Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | ||||
1871 | 261422 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1110x Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
2313 | 260963 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1100x Vermont St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
4089 | 260964 | Significant Tree 6 | Fraxinus spp :: Ash Spp 121 | 1100x Vermont St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
4630 | 261689 | Significant Tree 6 | Fraxinus spp :: Ash Spp 121 | 1100x Vermont St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
6430 | 260967 | Significant Tree 6 | Fraxinus spp :: Ash Spp 121 | 1100x Vermont St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
8787 | 260968 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 2400x 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
9066 | 260960 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1001 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
9216 | 261431 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1110x Vermont St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
10119 | 261688 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1100x Vermont St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
13844 | 260966 | Significant Tree 6 | Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 | 1100x Vermont St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
14462 | 261432 | Significant Tree 6 | Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 | 1100x Vermont St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
16010 | 260965 | Significant Tree 6 | Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 | 1100x Vermont St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
14736 | 92056 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1001 Potrero Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 06/16/2009 12:00:00 AM | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
45541 | 92053 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1001 Potrero Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | |||||
161427 | 92055 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1001 Potrero Ave | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | |||||
175545 | 92054 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1001 Potrero Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | |||||
54248 | 115888 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 811 TREAT AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 20 | 3x3 | 6008597 | 2103712 | 37.7568778816719 | -122.413260590978 | (37.7568778816719, -122.413260590978) | 2 | 4 | 7 | 28859 | 19 | |||
66903 | 233917 | Significant Tree 6 | Persea americana :: Avocado 34 | 1011 South Van Ness Ave | 1 | Front Yard : Yard | Tree | Private 2 | 21 | Width 3ft | 6007639.59401 | 2103741.67603 | 37.756905567467 | -122.416573768674 | (37.756905567467, -122.416573768674) | 2 | 4 | 7 | 28859 | 19 | |||
103318 | 115673 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 86 Stanton St | Front Yard : Yard | Tree | Private 2 | 6000281.6 | 2103909.8 | 37.7569506357303 | -122.442032456595 | (37.7569506357303, -122.442032456595) | 2 | 4 | 5 | 28862 | 38 | ||||||
54607 | 108196 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 930 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009368.6 | 2103733.3 | 37.7569796561067 | -122.410593604092 | (37.7569796561067, -122.410593604092) | 2 | 4 | 7 | 28859 | 19 | |||||
180439 | 108197 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 930 FLORIDA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009368.6 | 2103733.3 | 37.7569796561067 | -122.410593604092 | (37.7569796561067, -122.410593604092) | 2 | 4 | 7 | 28859 | 19 | |||||
6758 | 95372 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 180 Yukon St | Back Yard : Cutout | Tree | Private 2 | 15 | Permit Number 767755 | 6000174.3 | 2103956.9 | 37.7570738455347 | -122.442406920559 | (37.7570738455347, -122.442406920559) | 2 | 4 | 5 | 28862 | 3 | ||||
110004 | 113695 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 907 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6009441 | 2103786 | 37.7571284172194 | -122.410346937481 | (37.7571284172194, -122.410346937481) | 2 | 4 | 7 | 28859 | 19 | |||
3581 | 255621 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 366 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 785157 | 6006692 | 2103986 | 37.7575230865131 | -122.419868246156 | (37.7575230865131, -122.419868246156) | 2 | 4 | 7 | 28859 | 19 | |||
9069 | 255620 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 366 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 785157 | 6006692 | 2103986 | 37.7575230865131 | -122.419868246156 | (37.7575230865131, -122.419868246156) | 2 | 4 | 7 | 28859 | 19 | |||
107615 | 121415 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 366 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6006692 | 2103986 | 37.7575230865131 | -122.419868246156 | (37.7575230865131, -122.419868246156) | 2 | 4 | 7 | 28859 | 19 | |||
131057 | 121416 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 366 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006692 | 2103986 | 37.7575230865131 | -122.419868246156 | (37.7575230865131, -122.419868246156) | 2 | 4 | 7 | 28859 | 19 | ||||
176722 | 253637 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 701 Noe St | 2 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6003144.80454 | 2104133.37104 | 37.7577272573137 | -122.432146391441 | (37.7577272573137, -122.432146391441) | 2 | 4 | 5 | 28862 | 3 | ||||
104567 | 254405 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 321 Lexington St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 3ft | 6006540.69106 | 2104208.04068 | 37.7581242333638 | -122.420407294379 | (37.7581242333638, -122.420407294379) | 2 | 4 | 7 | 28859 | 19 | ||||
152275 | 103719 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 8 | 748 Treat Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 8 | 3x3 | 6008496.2 | 2104169 | 37.7581270399512 | -122.413641518528 | (37.7581270399512, -122.413641518528) | 2 | 4 | 7 | 28859 | 19 | |||
113217 | 255048 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 45 Eagle St | 3 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6000118.88808 | 2104341.86796 | 37.7581277146448 | -122.44262619575 | (37.7581277146448, -122.44262619575) | 2 | 4 | 5 | 28862 | 3 | ||||
57122 | 104444 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 507 Capp St | 1 | Front Yard : Cutout | Tree | Private 2 | 2x6 | Permit Number 770679 | 6007300 | 2104257.5 | 37.7583027968034 | -122.417784776473 | (37.7583027968034, -122.417784776473) | 2 | 4 | 7 | 28859 | 19 | |||
189920 | 104445 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 507 Capp St | 2 | Front Yard : Cutout | Tree | Private 2 | 2x6 | Permit Number 770679 | 6007300 | 2104257.5 | 37.7583027968034 | -122.417784776473 | (37.7583027968034, -122.417784776473) | 2 | 4 | 7 | 28859 | 19 | |||
67165 | 258067 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 833 York St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x3 | Permit Number 782335 | 6009933.30187 | 2104364.32189 | 37.758743943813 | -122.408685158341 | (37.758743943813, -122.408685158341) | 2 | 4 | 7 | 28859 | 19 | |||
40225 | 99859 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 4443 19th St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.438930324474 | (37.7589248414166, -122.438930324474) | 2 | 4 | 5 | 28862 | 3 | ||||
66345 | 100552 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 4443 19th St | 4 | Front Yard : Yard | Tree | Private 2 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.438930324474 | (37.7589248414166, -122.438930324474) | 2 | 4 | 5 | 28862 | 3 | |||||
121953 | 100550 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 4443 19th St | 2 | Front Yard : Yard | Tree | Private 2 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.438930324474 | (37.7589248414166, -122.438930324474) | 2 | 4 | 5 | 28862 | 3 | |||||
171061 | 100551 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 4443 19th St | 3 | Front Yard : Yard | Tree | Private 2 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.438930324474 | (37.7589248414166, -122.438930324474) | 2 | 4 | 5 | 28862 | 3 | |||||
67906 | 223957 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 98 Seward St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6000715.72405 | 2104622.00656 | 37.7589309108477 | -122.440582177927 | (37.7589309108477, -122.440582177927) | 2 | 4 | 5 | 28862 | 38 | |||
167295 | 223958 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 98 Seward St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6000714.90104 | 2104629.88079 | 37.7589524846915 | -122.440585589054 | (37.7589524846915, -122.440585589054) | 2 | 4 | 5 | 28862 | 38 | |||
98162 | 173886 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 2931 20th St | 1 | Front Yard : Yard | Tree | Private 2 | 6009454 | 2104482 | 37.7590402047035 | -122.410351120118 | (37.7590402047035, -122.410351120118) | 2 | 4 | 7 | 28859 | 19 | |||||
158462 | 173887 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 2931 20th St | 2 | Front Yard : Yard | Tree | Private 2 | 6009454 | 2104482 | 37.7590402047035 | -122.410351120118 | (37.7590402047035, -122.410351120118) | 2 | 4 | 7 | 28859 | 19 | |||||
48978 | 87197 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 617 Sanchez St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 50213 | 6003760 | 2104634 | 37.7591367256626 | -122.430054504807 | (37.7591367256626, -122.430054504807) | 2 | 4 | 5 | 28862 | 3 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );