trees
1,732 rows where qLegalStatus_id = 6 sorted by Longitude
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
174521 | 258525 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 50 Hermann St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
28942 | 110737 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6004594 | 2089787 | 37.7184174301537 | -122.426113167879 | (37.7184174301537, -122.426113167879) | 9 | 7 | 8 | 309 | 18 | ||||
67675 | 110738 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6004594 | 2089787 | 37.7184174301537 | -122.426113167879 | (37.7184174301537, -122.426113167879) | 9 | 7 | 8 | 309 | 18 | ||||
124026 | 110739 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6004594 | 2089787 | 37.7184174301537 | -122.426113167879 | (37.7184174301537, -122.426113167879) | 9 | 7 | 8 | 309 | 18 | ||||
39795 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
47565 | 116834 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
93840 | 116835 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
127835 | 116836 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
142462 | 116837 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 5 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
20207 | 105239 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 6 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
27763 | 105240 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 10 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
117572 | 105241 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 11 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
117668 | 105242 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 14 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
10900 | 256098 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1776 Vallejo St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005064.21519 | 2118169.93221 | 37.7963768588038 | -122.426507729874 | (37.7963768588038, -122.426507729874) | 13 | 9 | 1 | 28858 | 17 | |||||
10123 | 257894 | Significant Tree 6 | Metrosideros robusta :: Northern Rata Tree 335 | 1776 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 01/27/2020 12:00:00 AM | 3 | 6005064 | 2118169 | 37.7963742870274 | -122.426508408066 | (37.7963742870274, -122.426508408066) | 13 | 9 | 1 | 28858 | 17 | |||
125282 | 110236 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 100 BUCHANAN ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x20 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||
88383 | 103615 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
110134 | 103612 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
144064 | 103614 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
172262 | 103613 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
182906 | 103611 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
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 | |||||
60900 | 103616 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 201X Haight St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
75842 | 103617 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 201X Haight St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
95437 | 103618 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 201X Haight St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
29 | 264952 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 2 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
31 | 264951 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 1 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
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 | ||||
109250 | 107818 | Significant Tree 6 | Ficus Spp. :: 101 | 474 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 6004715.2 | 2110227.8 | 37.7745500089947 | -122.427149405032 | (37.7745500089947, -122.427149405032) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | |||
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 | ||||||
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 | |||
83971 | 105071 | Significant Tree 6 | Acacia stenophylla :: Shoestring Acacia 30 | 1808 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 771033 | 6004794.05676 | 2118138.55822 | 37.7962754378239 | -122.427440299436 | (37.7962754378239, -122.427440299436) | 13 | 9 | 1 | 57 | 17 | |||
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 | ||||
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 | |||||
121235 | 86895 | Significant Tree 6 | Tree(s) :: 17 | 321 Haight St | Front Yard : Yard | Tree | Private 2 | 10/26/2007 12:00:00 AM | Permit Number 49844 | 6004599.9 | 2109420.1 | 37.7723257406977 | -122.427490696784 | (37.7723257406977, -122.427490696784) | 7 | 9 | 11 | 28852 | 10 | ||||
44345 | 253366 | Significant Tree 6 | Ficus carica :: Edible Fig 341 | 20 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004582 | 2109434 | 37.7723628942784 | -122.427553605007 | (37.7723628942784, -122.427553605007) | 7 | 9 | 11 | 28852 | 10 | ||||
15160 | 260680 | Significant Tree 6 | Tree(s) :: 17 | 1450x Laguna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6004617 | 2113883 | 37.7845807327875 | -122.42774958855 | (37.7845807327875, -122.42774958855) | 13 | 9 | 11 | 28858 | 41 | ||||
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 | ||
169126 | 115697 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1425x LAGUNA ST | 1 | Front Yard : Yard | Tree | Private 2 | 25 | 6004559 | 2113815 | 37.7843907406582 | -122.4279454018 | (37.7843907406582, -122.4279454018) | 13 | 9 | 11 | 29490 | 41 | ||||
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 | |||||
92359 | 120121 | Significant Tree 6 | Juglans hindsii :: Walnut: Black (n.calif) 457 | 444 Page St | 1 | Front Yard : Yard | Tree | Private 2 | 6004415 | 2109849 | 37.7734929358756 | -122.428160854421 | (37.7734929358756, -122.428160854421) | 7 | 9 | 11 | 28852 | 10 | |||||
17242 | 253971 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
108843 | 253969 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
139296 | 253970 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
159837 | 253968 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
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 | ||||
100865 | 96279 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 55@ Alemany Trumbull St | 7 | Back Yard : Yard | Tree | Private 2 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | 9 | 7 | 6 | 28861 | 5 | |||||
180754 | 96273 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 55@ Alemany Trumbull St | 1 | Back Yard : Yard | Tree | Private 2 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | 9 | 7 | 6 | 28861 | 5 | |||||
92381 | 116164 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2411 OCTAVIA ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 15x4 | 6004495 | 2117637 | 37.7948813682629 | -122.428439330772 | (37.7948813682629, -122.428439330772) | 13 | 9 | 1 | 28858 | 27 | |||
71809 | 96274 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 55@ Alemany Trumbull St | 2 | Back Yard : Yard | Tree | Private 2 | 2 | 6004001.3006 | 2094332.00643 | 37.7308634942567 | -122.428485665086 | (37.7308634942567, -122.428485665086) | 9 | 7 | 6 | 28861 | 5 | ||||
170923 | 109294 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 370 27TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6004104.9 | 2100171.3 | 37.7469027259862 | -122.428543573264 | (37.7469027259862, -122.428543573264) | 2 | 7 | 5 | 63 | 22 | ||||
165425 | 96275 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 55@ Alemany Trumbull St | 3 | Back Yard : Yard | Tree | Private 2 | 3 | 6003967.55773 | 2094330.40491 | 37.73085718729 | -122.428602205549 | (37.73085718729, -122.428602205549) | 9 | 7 | 6 | 28861 | 5 | ||||
25451 | 105226 | Significant Tree 6 | Tree(s) :: 17 | 1150X Golden Gate Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/02/2014 12:00:00 AM | Permit Number 771276 | 6004329.61165 | 2112216.22051 | 37.7799879097685 | -122.428625001082 | (37.7799879097685, -122.428625001082) | 7 | 9 | 11 | 29490 | 41 | |||
165618 | 105227 | Significant Tree 6 | Tree(s) :: 17 | 1150X Golden Gate Ave | 2 | Front Yard : Yard | Tree | Private 2 | 01/02/2014 12:00:00 AM | Permit Number 771276 | 6004329.61165 | 2112216.22051 | 37.7799879097685 | -122.428625001082 | (37.7799879097685, -122.428625001082) | 7 | 9 | 11 | 29490 | 41 | |||
159825 | 96276 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 55@ Alemany Trumbull St | 4 | Back Yard : Yard | Tree | Private 2 | 2 | 6003946.78636 | 2094329.77315 | 37.7308542770831 | -122.428673970523 | (37.7308542770831, -122.428673970523) | 9 | 7 | 6 | 28861 | 5 | ||||
120908 | 96277 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 55@ Alemany Trumbull St | 5 | Back Yard : Yard | Tree | Private 2 | 2 | 6003933.28624 | 2094328.99121 | 37.7308513660015 | -122.428720586902 | (37.7308513660015, -122.428720586902) | 9 | 7 | 6 | 28861 | 5 | ||||
180419 | 105351 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 2040 Jackson St | 1 | Front Yard : Yard | Tree | Private 2 | 01/16/2014 12:00:00 AM | 3 | Permit Number 769933 | 6004399.13095 | 2117053.27366 | 37.7932731788779 | -122.428729419132 | (37.7932731788779, -122.428729419132) | 13 | 9 | 1 | 28858 | 27 | ||
150154 | 96278 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 55@ Alemany Trumbull St | 6 | Back Yard : Yard | Tree | Private 2 | 2 | 6003898.31997 | 2094328.29867 | 37.7308474854131 | -122.428841421596 | (37.7308474854131, -122.428841421596) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | |||
92073 | 98492 | Significant Tree 6 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6004211.7 | 2116183 | 37.7908730187591 | -122.429315856087 | (37.7908730187591, -122.429315856087) | 13 | 9 | 1 | 29490 | 27 | |||||
62475 | 107113 | Significant Tree 6 | Brahea edulis :: Guadalupe Palm 218 | 2100 MARKET ST | Front Yard : Cutout | Tree | Private 2 | 6004034 | 2107672.1 | 37.7674941340109 | -122.429323526179 | (37.7674941340109, -122.429323526179) | 7 | 9 | 5 | 28862 | 3 | ||||||
73226 | 114272 | Significant Tree 6 | Tree(s) :: 17 | 2241 Sacramento St | 1 | Front Yard : Cutout | Tree | Private 2 | 03/22/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776884 | 6004082.4 | 2115905.7 | 37.7901043022718 | -122.429743441495 | (37.7901043022718, -122.429743441495) | 13 | 9 | 1 | 29490 | 27 | |
16372 | 96327 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 296 Randall St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 767829 | 6003708 | 2097940 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | 2 | 7 | 5 | 63 | 7 | ||||
162530 | 96328 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 296 Randall St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 767829 | 6003708 | 2097940 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | 2 | 7 | 5 | 63 | 7 | ||||
129276 | 93903 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 546 Page St | Front Yard : | Tree | Private 2 | 6003947 | 2109752 | 37.7732001072566 | -122.429772814549 | (37.7732001072566, -122.429772814549) | 7 | 9 | 11 | 29492 | 10 | ||||||
158642 | 94066 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 273 | 548 Page St | Front Yard : | Tree | Private 2 | 06/02/2010 12:00:00 AM | Permit Number 53460 | 6003937 | 2109751 | 37.7731967952272 | -122.429807334526 | (37.7731967952272, -122.429807334526) | 7 | 9 | 11 | 29492 | 10 | ||||
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 | |||||
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 | ||||
37483 | 85089 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
46495 | 85086 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
89745 | 85085 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
105107 | 85090 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
118931 | 85087 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
193247 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
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 | ||||
110740 | 173731 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 484 Chenery St | 1 | Front Yard : Yard | Tree | Private 2 | 6003566 | 2096120 | 37.7357482768139 | -122.430118073632 | (37.7357482768139, -122.430118073632) | 2 | 7 | 5 | 63 | 7 | |||||
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 | ||||
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 | |||||
64 | 264974 | Significant Tree 6 | Persea americana :: Avocado 34 | 1868 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003954 | 2119422 | 37.7997518904289 | -122.430438688757 | (37.7997518904289, -122.430438688757) | 13 | 9 | 1 | 57 | 17 | ||||
81315 | 104261 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1556X O'Farrell St | 1 | Front Yard : Yard | Tree | Private 2 | 6003781.85581 | 2113525.38813 | 37.783551542878 | -122.430613377711 | (37.783551542878, -122.430613377711) | 13 | 9 | 11 | 29490 | 41 | |||||
86813 | 104872 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1753 Noe St | 1 | Hanging basket : Yard | Tree | Private 2 | 11/22/2013 12:00:00 AM | Permit Number 770054 | 6003434.1 | 2098036.1 | 37.7410019772539 | -122.430710793678 | (37.7410019772539, -122.430710793678) | 2 | 7 | 5 | 63 | 7 | |||
149707 | 108978 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 MIGUEL ST | 1 | Front Yard : Yard | Tree | Private 2 | 44 | 6003334.2 | 2097391.9 | 37.7392274919289 | -122.431010244874 | (37.7392274919289, -122.431010244874) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
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 | |||||
7770 | 98170 | Significant Tree 6 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2324 Sacramento St | Front Yard : Yard | Tree | Private 2 | 12/22/2011 12:00:00 AM | 3 | Permit Number 768454 | 6003670.2 | 2115963.1 | 37.7902385582714 | -122.431173718492 | (37.7902385582714, -122.431173718492) | 13 | 9 | 1 | 29490 | 27 | |||
166311 | 127110 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3201 Laguna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 6ft | 6003718.35126 | 2119752.0994 | 37.8006449063974 | -122.431277695812 | (37.8006449063974, -122.431277695812) | 13 | 9 | 1 | 57 | 17 | |||
84706 | 103143 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2620 Buchanan St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6003626 | 2117322 | 37.7939672460834 | -122.431423695166 | (37.7939672460834, -122.431423695166) | 13 | 9 | 1 | 29490 | 27 | ||||
43750 | 253165 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1451 Bay St | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6003691 | 2120547 | 37.8028259466608 | -122.431429119577 | (37.8028259466608, -122.431429119577) | 13 | 9 | 1 | 57 | 17 | ||||
194298 | 262528 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3400 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | 6003691 | 2120547 | 37.8028259466608 | -122.431429119577 | (37.8028259466608, -122.431429119577) | 13 | 9 | 1 | 57 | 17 | ||
50525 | 173933 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 190 Beacon St | 1 | Front Yard : Yard | Tree | Private 2 | 6003193 | 2097540 | 37.7396261385587 | -122.431509020833 | (37.7396261385587, -122.431509020833) | 2 | 7 | 5 | 63 | 7 | |||||
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 | |||||
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 | |||||
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 | |||||
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 |
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) );