trees

194,517 rows sorted by SiteOrder descending

✎ View and edit SQL

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)
4397 44679 Permitted Site 7 Tree(s) :: 17   99 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
7996 45026 Permitted Site 7 Tree(s) :: 17   99 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
11315 48289 Permitted Site 7 Tree(s) :: 17   99 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
13496 45859 Permitted Site 7 Tree(s) :: 17   99 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
26539 207135 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 700 Junipero Serra Blvd 99 : Tree Private 2     5 Width 0ft   5991243.40911 2092046.59438 37.7238581046423 -122.472424791093 (37.7238581046423, -122.472424791093) 9 8 4 64 40
30037 224270 DPW Maintained 1 Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 1000 San Jose Ave 99 Front Yard : Yard Tree Private 2     31     6004965.43171 2096836.50087 37.7377947878061 -122.425330660777 (37.7377947878061, -122.425330660777) 2 7 5 63 7
31657 3663 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 99 Sidewalk: Curb side : Cutout Tree Port 6   03/12/1990 12:00:00 AM 3 3X3   6017184.0839 2098879.25737 37.744086528482 -122.383226584333 (37.744086528482, -122.383226584333) 10 3 8 58 1
33741 173634 DPW Maintained 1 Acacia cognata :: River Wattle 291 1155 Market St 99 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008672 2111900 37.779364436223 -122.4135803097 (37.779364436223, -122.4135803097) 8 2 9 28853 34
170203 186826 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 1200 Sunset Blvd 99 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984816.4913 2106624.0982 37.7635099007919 -122.495716026683 (37.7635099007919, -122.495716026683) 1 8 3 56 35
176676 214164 DPW Maintained 1 Schinus molle :: California Pepper 91 900 Junipero Serra Blvd 99 : Tree Private 2     5 Width 0ft   5991142.14923 2090504.71444 37.7196186222819 -122.47266246032 (37.7196186222819, -122.47266246032) 9 8 4 64 40
192931 173637 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1155 Market St 99 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008672 2111900 37.779364436223 -122.4135803097 (37.779364436223, -122.4135803097) 8 2 9 28853 34
1008 48288 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
10442 45860 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
12840 45025 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
16497 44678 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
22595 181585 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1200 Sunset Blvd 98 Sidewalk: Property side : Yard Tree Private 2     34 Width 0ft   5984843.0144 2106607.1528 37.7634649266844 -122.495623043152 (37.7634649266844, -122.495623043152) 1 8 3 56 35
50183 206263 DPW Maintained 1 Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 900 Junipero Serra Blvd 98 : Tree Private 2     26 Width 0ft   5991142.47333 2090520.08752 37.7196608517337 -122.4726624603 (37.7196608517337, -122.4726624603) 9 8 4 64 40
91870 207134 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 700 Junipero Serra Blvd 98 : Tree Private 2     12 Width 0ft   5991244.20773 2092057.90852 37.7238892166875 -122.472422854852 (37.7238892166875, -122.472422854852) 9 8 4 64 40
10915 48287 Permitted Site 7 Tree(s) :: 17   97 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
13485 45024 Permitted Site 7 Tree(s) :: 17   97 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
13500 45861 Permitted Site 7 Tree(s) :: 17   97 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
18065 44701 Permitted Site 7 Tree(s) :: 17   97 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
36584 206862 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700 Junipero Serra Blvd 97 : Tree Private 2     16 Width 0ft   5991236.44384 2092069.53712 37.7239206965711 -122.472450540456 (37.7239206965711, -122.472450540456) 9 8 4 64 40
129031 3661 DPW Maintained 1 Quercus ilex :: Holly Oak 305 100X Cargo Way 97 Sidewalk: Curb side : Cutout Tree Port 6   05/02/2017 12:21:00 PM 3 3X3   6017220.32274 2098859.87245 37.7440353039781 -122.383099928312 (37.7440353039781, -122.383099928312) 10 3 8 58 1
131022 204391 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 900 Junipero Serra Blvd 97 : Tree Private 2     4 Width 0ft   5991142.05412 2090528.37768 37.7196835902046 -122.472664513466 (37.7196835902046, -122.472664513466) 9 8 4 64 40
140020 186833 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1200 Sunset Blvd 97 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984849.2768 2106596.8383 37.7634369726808 -122.495600623018 (37.7634369726808, -122.495600623018) 1 8 3 56 35
160577 184094 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1600 Sunset Blvd 97 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984942.4654 2104248.1437 37.7569935689127 -122.495105115522 (37.7569935689127, -122.495105115522) 1 8 3 56 35
161087 245820 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 97 Front Yard : Yard Tree Private 2     5     6004968.56772 2096865.41877 37.7378743670117 -122.425321875304 (37.7378743670117, -122.425321875304) 2 7 5 63 7
5544 48286 Permitted Site 7 Tree(s) :: 17   96 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
15686 45023 Permitted Site 7 Tree(s) :: 17   96 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
18086 45862 Permitted Site 7 Tree(s) :: 17   96 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
19213 44683 Permitted Site 7 Tree(s) :: 17   96 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
29155 204129 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 700 Junipero Serra Blvd 96 : Tree Private 2     6 Width 0ft   5991250.64251 2092078.21023 37.7239453325821 -122.472402090391 (37.7239453325821, -122.472402090391) 9 8 4 64 40
56294 245819 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 96 Front Yard : Yard Tree Private 2     16     6004972.44653 2096874.30966 37.7378989985293 -122.425309096855 (37.7378989985293, -122.425309096855) 2 7 5 63 7
78691 186827 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1200 Sunset Blvd 96 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984832.3315 2106605.311 37.7634592440326 -122.495659855463 (37.7634592440326, -122.495659855463) 1 8 3 56 35
101014 184093 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1600 Sunset Blvd 96 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984922.9495 2104229.3007 37.7569406887046 -122.495171218388 (37.7569406887046, -122.495171218388) 1 8 3 56 35
168288 204154 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 900 Junipero Serra Blvd 96 : Tree Private 2     3 Width 0ft   5991156.52869 2090538.72027 37.7197128262716 -122.47261523421 (37.7197128262716, -122.47261523421) 9 8 4 64 40
181394 3660 DPW Maintained 1 Quercus ilex :: Holly Oak 305 100X Cargo Way 96 Sidewalk: Curb side : Cutout Tree Port 6     3 3X3   6017231.85716 2098842.1766 37.7439873521291 -122.383058813116 (37.7439873521291, -122.383058813116) 10 3 8 58 1
2775 45022 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
9780 45872 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
11907 48285 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
19195 44685 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
44735 186828 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1200 Sunset Blvd 95 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984824.2272 2106601.6272 37.76344865476 -122.495687613477 (37.76344865476, -122.495687613477) 1 8 3 56 35
55500 245818 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 95 Front Yard : Yard Tree Private 2     15     6004977.00826 2096882.72633 37.7379223665264 -122.42529392347 (37.7379223665264, -122.42529392347) 2 7 5 63 7
112823 211025 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 95 : Tree Private 2     6 Width 0ft   5991234.71561 2092082.53367 37.7239562818437 -122.472457461651 (37.7239562818437, -122.472457461651) 9 8 4 64 40
125045 3659 DPW Maintained 1 Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 100X Cargo Way 95 Sidewalk: Curb side : Cutout Tree Port 6     12 3X3   6017251.66004 2098826.19142 37.7439445542915 -122.382989226284 (37.7439445542915, -122.382989226284) 10 3 8 58 1
138327 211509 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 900 Junipero Serra Blvd 95 : Tree Private 2     12 Width 0ft   5991136.45301 2090544.4672 37.719727443836 -122.472685046799 (37.719727443836, -122.472685046799) 9 8 4 64 40
156872 184092 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1600 Sunset Blvd 95 Sidewalk: Property side : Yard Tree Private 2     25 Width 0ft   5984922.9495 2104224.59 37.7569277544289 -122.49517087102 (37.7569277544289, -122.49517087102) 1 8 3 56 35
4748 45021 Permitted Site 7 Tree(s) :: 17   94 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
10300 48270 Permitted Site 7 Tree(s) :: 17   94 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
10839 44710 Permitted Site 7 Tree(s) :: 17   94 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
13968 45864 Permitted Site 7 Tree(s) :: 17   94 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
27896 211024 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 94 : Tree Private 2     6 Width 0ft   5991236.61569 2092101.43513 37.7240082905392 -122.472452270761 (37.7240082905392, -122.472452270761) 9 8 4 64 40
68327 186829 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1200 Sunset Blvd 94 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984823.8588 2106586.1554 37.763406151967 -122.495687746344 (37.763406151967, -122.495687746344) 1 8 3 56 35
68935 184091 DPW Maintained 1 Sequoia sempervirens :: Coast Redwood 155 1600 Sunset Blvd 94 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984954.5787 2104192.9608 37.7568427611219 -122.495059154794 (37.7568427611219, -122.495059154794) 1 8 3 56 35
86570 204390 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 900 Junipero Serra Blvd 94 : Tree Private 2     5 Width 0ft   5991146.57188 2090545.43725 37.7197306930948 -122.472650140495 (37.7197306930948, -122.472650140495) 9 8 4 64 40
116226 3658 DPW Maintained 1 Quercus suber :: Cork Oak 78 100X Cargo Way 94 Sidewalk: Curb side : Cutout Tree Port 6     6 3x3   6017265.72601 2098814.03291 37.7439119466908 -122.382939742901 (37.7439119466908, -122.382939742901) 10 3 8 58 1
122374 245817 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 94 Front Yard : Yard Tree Private 2     32     6004980.52596 2096892.52372 37.7379494666842 -122.425282458027 (37.7379494666842, -122.425282458027) 2 7 5 63 7
514 45011 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
3563 44709 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
14612 48283 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
18690 45856 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
40702 186830 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1200 Sunset Blvd 93 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984826.8059 2106580.9981 37.7633921640535 -122.495677173 (37.7633921640535, -122.495677173) 1 8 3 56 35
41120 181366 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1600 Sunset Blvd 93 Sidewalk: Property side : Yard Tree Private 2     33 Width 0ft   5984930.8531 2104160.775 37.756752998853 -122.495138832152 (37.756752998853, -122.495138832152) 1 8 3 56 35
79530 3657 DPW Maintained 1 Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 100X Cargo Way 93 Sidewalk: Curb side : Cutout Tree Port 6     12 3X3   6017283.49959 2098800.90892 37.7438768929081 -122.382877372202 (37.7438768929081, -122.382877372202) 10 3 8 58 1
106003 215649 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 900 Junipero Serra Blvd 93 : Tree Private 2     4 Width 0ft   5991151.37081 2090546.73366 37.7197345305043 -122.472633646933 (37.7197345305043, -122.472633646933) 9 8 4 64 40
113681 245816 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 93 Front Yard : Yard Tree Private 2     7     6004985.63853 2096904.07268 37.7379814663592 -122.425265602924 (37.7379814663592, -122.425265602924) 2 7 5 63 7
190918 204128 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 700 Junipero Serra Blvd 93 : Tree Private 2     8 Width 0ft   5991254.18034 2092103.55707 37.7240151334793 -122.472391707724 (37.7240151334793, -122.472391707724) 9 8 4 64 40
4171 48297 Permitted Site 7 Tree(s) :: 17   92 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4432 181365 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1600 Sunset Blvd 92 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984912.4611 2104151.8757 37.7567274870678 -122.495201781242 (37.7567274870678, -122.495201781242) 1 8 3 56 35
12587 45866 Permitted Site 7 Tree(s) :: 17   92 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
15096 45020 Permitted Site 7 Tree(s) :: 17   92 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
17050 44708 Permitted Site 7 Tree(s) :: 17   92 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
22592 245815 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 92 Front Yard : Yard Tree Private 2     8     6004991.22077 2096914.75844 37.7380111224129 -122.425247062517 (37.7380111224129, -122.425247062517) 2 7 5 63 7
64997 186834 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 1200 Sunset Blvd 92 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984853.6973 2106574.7357 37.7633765440011 -122.495583703829 (37.7633765440011, -122.495583703829) 1 8 3 56 35
135806 215648 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 900 Junipero Serra Blvd 92 : Tree Private 2     3 Width 0ft   5991148.46508 2090549.78954 37.7197427529995 -122.472643913597 (37.7197427529995, -122.472643913597) 9 8 4 64 40
146138 3656 DPW Maintained 1 Quercus ilex :: Holly Oak 305 100X Cargo Way 92 Sidewalk: Curb side : Cutout Tree Port 6   03/07/2006 12:00:00 AM 3 3X3   6017299.77103 2098787.22136 37.7438402086508 -122.382820156452 (37.7438402086508, -122.382820156452) 10 3 8 58 1
185048 204732 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 700 Junipero Serra Blvd 92 : Tree Private 2     9 Width 0ft   5991226.61275 2092125.57221 37.7240739859998 -122.472488607886 (37.7240739859998, -122.472488607886) 9 8 4 64 40
2632 48281 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
10879 44707 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
16425 45867 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
16835 45029 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
32875 184090 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1600 Sunset Blvd 91 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984905.3417 2104126.3643 37.7566570230164 -122.4952245211 (37.7566570230164, -122.4952245211) 1 8 3 56 35
52081 224017 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1000 San Jose Ave 91 Front Yard : Yard Tree Private 2     28     6004994.74234 2096924.07429 37.7380369005842 -122.425235549407 (37.7380369005842, -122.425235549407) 2 7 5 63 7
95989 211508 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 900 Junipero Serra Blvd 91 : Tree Private 2     8 Width 0ft   5991145.77584 2090549.03297 37.7197405199769 -122.472653154122 (37.7197405199769, -122.472653154122) 9 8 4 64 40
103847 204127 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 700 Junipero Serra Blvd 91 : Tree Private 2     2 Width 0ft   5991259.14537 2092125.38495 37.7240753547864 -122.472376135061 (37.7240753547864, -122.472376135061) 9 8 4 64 40
153819 186620 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1501 Sunset Blvd 91 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984755.0749 2104355.2681 37.7572767304033 -122.495761074715 (37.7572767304033, -122.495761074715) 1 8 3 56 35
185865 3655 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 91 Sidewalk: Curb side : Cutout Tree Port 6     6 3X3   6017319.27606 2098771.24223 37.7437974108278 -122.382751600221 (37.7437974108278, -122.382751600221) 10 3 8 58 1
8605 48280 Permitted Site 7 Tree(s) :: 17   90 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
8878 45868 Permitted Site 7 Tree(s) :: 17   90 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
9779 44706 Permitted Site 7 Tree(s) :: 17   90 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
11495 45018 Permitted Site 7 Tree(s) :: 17   90 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
30089 187307 DPW Maintained 1 Sequoia sempervirens :: Coast Redwood 155 2401 Sunset Blvd 90 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984946.0227 2098230.3328 37.7404705132188 -122.494649173616 (37.7404705132188, -122.494649173616) 1 8 3 29491 35
35871 224016 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1000 San Jose Ave 90 Front Yard : Yard Tree Private 2     25     6005001.85234 2096930.17792 37.7380540614461 -122.425211400785 (37.7380540614461, -122.425211400785) 2 7 5 63 7
41770 186831 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1200 Sunset Blvd 90 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984823.4905 2106576.2092 37.763378820926 -122.495688286465 (37.763378820926, -122.495688286465) 1 8 3 56 35
71159 207133 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 700 Junipero Serra Blvd 90 : Tree Private 2     10 Width 0ft   5991231.48328 2092142.91587 37.7241218892943 -122.472473035196 (37.7241218892943, -122.472473035196) 9 8 4 64 40
111667 3654 DPW Maintained 1 Quercus ilex :: Holly Oak 305 100X Cargo Way 90 Sidewalk: Curb side : Cutout Tree Port 6     6 3X3   6017326.20806 2098774.96233 37.7438080084417 -122.382727889579 (37.7438080084417, -122.382727889579) 10 3 8 58 1
119802 215647 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 900 Junipero Serra Blvd 90 : Tree Private 2     5 Width 0ft   5991141.92136 2090550.26747 37.7197436864904 -122.472666567521 (37.7197436864904, -122.472666567521) 9 8 4 64 40
180771 186619 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 Sunset Blvd 90 Sidewalk: Property side : Yard Tree Private 2     28 Width 0ft   5984733.72 2104360.7115 37.7572904258336 -122.495835328738 (37.7572904258336, -122.495835328738) 1 8 3 56 35
186569 184089 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1600 Sunset Blvd 90 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984906.5283 2104110.9388 37.7566147383421 -122.495219279964 (37.7566147383421, -122.495219279964) 1 8 3 56 35

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);