trees
150 rows where Police Districts = 4 and qLegalStatus_id = 6 sorted by Zip Codes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||||
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 | ||||
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 | |||||
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 | |||||
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 | ||||
1533 | 120590 | Significant Tree 6 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 | 52 Prosper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003308 | 2106220 | 37.7634658909933 | -122.43173097309 | (37.7634658909933, -122.43173097309) | 15 | 4 | 5 | 28862 | 3 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||||
10260 | 261386 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 31 Abbey St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6004642 | 2106187 | 37.7634508076606 | -122.427114742536 | (37.7634508076606, -122.427114742536) | 8 | 4 | 5 | 28862 | 3 | ||||
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 | ||||
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 | |
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 | ||||
17604 | 261710 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3555 16th St | 1 | Front Yard : Yard | Tree | Public Library 12 | 8x8 | 6003221.95473 | 2106496.25325 | 37.7642195378276 | -122.432048304209 | (37.7642195378276, -122.432048304209) | 15 | 4 | 5 | 28862 | 3 | ||||
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 | ||||
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 | ||||
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 | ||||
27944 | 252826 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 3852 17th St | 5 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
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 | ||||
36007 | 107047 | Significant Tree 6 | Tree(s) :: 17 | 1933 15TH ST | Front Yard : Yard | Tree | Private 2 | 6004592.7 | 2107127.1 | 37.7660293092823 | -122.427352228532 | (37.7660293092823, -122.427352228532) | 8 | 4 | 5 | 28862 | 3 | ||||||
37022 | 95985 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 577 Sanchez St | 1 | Front Yard : | Tree | Private 2 | 6003673 | 2104901 | 37.7598649162805 | -122.430374442168 | (37.7598649162805, -122.430374442168) | 2 | 4 | 5 | 28862 | 3 | |||||
37050 | 252828 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 273 | 3852 17th St | 7 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
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 | ||||
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 | |||||
44457 | 252830 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 3852 17th St | 9 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
46691 | 258502 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 3321 16th St | 2 | Front Yard : Yard | Tree | Private 2 | 6004551.31558 | 2106568.33958 | 37.7644927464624 | -122.427455559127 | (37.7644927464624, -122.427455559127) | 8 | 4 | 5 | 28862 | 3 | |||||
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 | ||||
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 | ||||
52899 | 173663 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 3878 17th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6003109 | 2105964 | 37.7627516946294 | -122.432400964417 | (37.7627516946294, -122.432400964417) | 15 | 4 | 5 | 28862 | 3 | ||||
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 | |||
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 | ||||
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 | |||||
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 | |||
69345 | 252824 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 3852 17th St | 3 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
73609 | 252836 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 98 Prosper St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
76481 | 94535 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 265 Dorland St | 1 | Back Yard : Yard | Tree | Private 2 | 6003831 | 2105693 | 37.7620485075454 | -122.429884491233 | (37.7620485075454, -122.429884491233) | 8 | 4 | 5 | 28862 | 3 | |||||
78991 | 252827 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 3852 17th St | 6 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
84261 | 251716 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3929 19th St | 1 | Front Yard : Yard | Tree | Private 2 | 6003450 | 2104734 | 37.7593937399337 | -122.431133769968 | (37.7593937399337, -122.431133769968) | 2 | 4 | 5 | 28862 | 3 | |||||
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 | |||
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 | ||||
94274 | 252822 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 3852 17th St | 1 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
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 | ||||||
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 | ||||
106429 | 105497 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3929 19TH ST | 1 | Front Yard : Yard | Tree | Private 2 | 60 | 6003450.9 | 2104734.8 | 37.7593959875427 | -122.431130714429 | (37.7593959875427, -122.431130714429) | 2 | 4 | 5 | 28862 | 3 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||||
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 | ||||
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 | ||
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 | |||||
136228 | 252825 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 3852 17th St | 4 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
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 | ||||
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 | |||
159259 | 104674 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 3649-3651 17TH ST | 1 | Front Yard : Yard | Tree | Private 2 | 20 | Permit Number 770917 | 6004555.5 | 2105964.3 | 37.7628344347284 | -122.427398052716 | (37.7628344347284, -122.427398052716) | 8 | 4 | 5 | 28862 | 3 | |||
160817 | 252823 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 3852 17th St | 2 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
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 | |||
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 | |||||
171763 | 106405 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 4849X 19th St | Front Yard : Yard | Tree | Private 2 | Permit Number 772769 | 5999644.57626 | 2104777.09851 | 37.7592957011711 | -122.444297841065 | (37.7592957011711, -122.444297841065) | 2 | 4 | 5 | 28862 | 3 | |||||
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 | ||||
189569 | 252838 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 99 Pond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
189693 | 252829 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 273 | 3852 17th St | 8 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | ||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |
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 | ||||
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 | |
37736 | 101041 | Significant Tree 6 | Tree(s) :: 17 | 3750 18th St | 1 | Front Yard : Yard | Tree | SFUSD 4 | 03/15/2012 12:00:00 AM | 30 | Permit Number 769376 | 6005230 | 2105481 | 37.7615455321967 | -122.425030802687 | (37.7615455321967, -122.425030802687) | 8 | 4 | 5 | 28859 | 19 | ||
42649 | 115940 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 3401x 17TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 20 | 3x3 | 6006069 | 2106010 | 37.7630453994978 | -122.422166625338 | (37.7630453994978, -122.422166625338) | 8 | 4 | 5 | 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 | ||||
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 | |||||
52809 | 224289 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 166 San Carlos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 3ft | 6006647.34642 | 2105145.25174 | 37.7607036068074 | -122.420104944992 | (37.7607036068074, -122.420104944992) | 2 | 4 | 7 | 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 | |||
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 | |||||
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 | |||
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 | |||
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 |
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) );