563 rows where qSpecies_id = 52 sorted by qLegalStatus_id

View and edit SQL

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)
163 17253 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 15 Osceola Ln 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6017345.102761 2094248.0837329 37.7313791485056 -122.382347671583 (37.7313791485056, -122.382347671583) 10 3 8 58 1
454 11293 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1199X Ingalls St 5 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X3   6017612.0195749 2093925.7037957 37.7305086962257 -122.381402471608 (37.7305086962257, -122.381402471608) 10 3 8 58 1
900 19637 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 36 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
1171 19952 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY39 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
1272 113499 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 200x Mansell St 5 Median : Cutout Tree DPW 1     19 3x3   6011193.56936 2090563.53064 37.7209204242214 -122.403355677147 (37.7209204242214, -122.403355677147) 10 7 7 309 28
1350 19628 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 27 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
1420 19991 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY46 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
2026 19643 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 42 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
2604 224449 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1201 San Jose Ave 62 Front Yard : Yard Tree Private 2     22     6004503.55801 2096138.79869 37.7358529500558 -122.426877907491 (37.7358529500558, -122.426877907491) 2 7 5 28861 2
2633 261854 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1900x Bay Shore Blvd 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
2649 20050 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY52 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
3174 224198 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001 San Jose Ave 30 Front Yard : Yard Tree Private 2     9     6005259.16763 2097058.51402 37.7384209767501 -122.424330858406 (37.7384209767501, -122.424330858406) 2 7 5 28859 2
3196 19917 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY35 13 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
3489 244479 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 124 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005906.1302 2110197.2252 37.7745333330343 -122.423027565946 (37.7745333330343, -122.423027565946) 7 9 11 28852 10
3527 19876 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY33 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
3552 19877 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY33 9 Sidewalk: Curb side : Cutout Tree DPW 1     24 25ST                      
3737 51577 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 584 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   28   Permit Number 47871 5982583.51771 2111812.9357 37.7776259284617 -122.50382336032 (37.7776259284617, -122.50382336032) 11 6 2 55 26
3823 121262 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 505 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005321 2111256 37.7774074352434 -122.42512699851 (37.7774074352434, -122.42512699851) 7 9 11 28852 10
3992 9289 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 13X George Ct 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017208.5497632 2094048.0250587 37.7308222832509 -122.382805848563 (37.7308222832509, -122.382805848563) 10 3 8 58 1
4099 19572 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY1 6 Sidewalk: Curb side : Cutout Tree DPW 1     24 100ST                      
4115 19918 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY35 14 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
4220 11355 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1339 Ingalls St 4 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6017292.9099838 2093920.0801467 37.7304756321775 -122.382505299944 (37.7304756321775, -122.382505299944) 10 3 8 58 1
4242 19575 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY1 10 Sidewalk: Curb side : Cutout Tree DPW 1     36 100ST                      
4705 19622 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 21 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
4768 17628 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 150 Phelps St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 10M                      
4835 261613 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1900x Bay Shore Blvd 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
4870 19873 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY33 5 Sidewalk: Curb side : Cutout Tree DPW 1     30 25ST                      
4933 261616 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1900x Bay Shore Blvd 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
5641 19822 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY25 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
5847 261615 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1900x Bay Shore Blvd 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
5870 11357 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1350X Ingalls St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6017253.696644 2093959.2156364 37.7305809242894 -122.382643589629 (37.7305809242894, -122.382643589629) 10 3 8 58 1
6428 19770 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY16 9 Sidewalk: Curb side : Cutout Tree DPW 1     6 30ST                      
6890 19879 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY33 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
7211 19619 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 18 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
7246 264704 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 95 Middle Point Rd 37 Front Yard : Cutout Tree Private 2       3x3   6018242 2095673 37.7353411892906 -122.379345838246 (37.7353411892906, -122.379345838246) 10 3 8 58 1
7383 17629 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 150 Phelps St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 10M                      
7446 243531 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 2095 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   6008748.77289 2106455.16153 37.764418495754 -122.412929646495 (37.764418495754, -122.412929646495) 8 4 7 28859 19
7681 19824 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY25 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
8240 20391 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 262X Sunset Blvd 37 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
8446 19823 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY25 7 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
8556 19623 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 22 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
8624 52193 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 2050x Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14   Permit Number 48383 6003893.10220549 2115458.97047215 37.7888669751572 -122.430366510079 (37.7888669751572, -122.430366510079) 13 9 11 29490 27
8705 224209 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001 San Jose Ave 70 Front Yard : Yard Tree Private 2     20     6005356.45271 2097454.81484 37.7395146225008 -122.424022667913 (37.7395146225008, -122.424022667913) 2 7 5 28859 2
8778 19630 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 29 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
9166 19571 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY1 5 Sidewalk: Curb side : Cutout Tree DPW 1     24 100ST                      
9314 19995 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY46 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
9456 19881 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY33 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
9686 19629 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 28 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
9690 19636 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 35 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
9767 19990 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY46 10 Sidewalk: Curb side : Cutout Tree DPW 1     6 40                      
9982 261614 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1900x Bay Shore Blvd 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
10139 19618 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 17 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
10150 19701 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY12 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
10734 20046 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY52 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 10                      
11237 19870 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY33 2 Sidewalk: Curb side : Cutout Tree DPW 1     36 25ST                      
11530 261611 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1900x Bay Shore Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
11589 19641 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 40 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
11997 20028 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY49 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
12219 19617 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 16 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
12413 19734 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY14 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
12534 19640 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 39 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
12925 122943 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 300 09th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     29 Width 3ft   5993094 2113125 37.7818409059319 -122.467559795372 (37.7818409059319, -122.467559795372) 11 6 2 54 11
13069 19574 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY1 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
13619 19639 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 38 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
13651 19987 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY46 7 Sidewalk: Curb side : Cutout Tree DPW 1     6 40                      
13854 9287 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 13X George Ct 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017208.5497632 2094048.0250587 37.7308222832509 -122.382805848563 (37.7308222832509, -122.382805848563) 10 3 8 58 1
13892 19884 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY33 16 Sidewalk: Curb side : Cutout Tree DPW 1     18 25ST                      
15245 19996 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY46 16 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
15612 19626 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 25 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
15637 19921 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY37 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3                      
15654 19916 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY35 12 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
16165 19703 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY13 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
16570 19635 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 34 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
16689 19767 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY16 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 30ST                      
16816 19567 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY1 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 100ST                      
16933 176313 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 500x Mansell St 18 Median : Cutout Tree DPW 1     38 Width 0ft   6010259.13784 2090270.57035 37.7200637812891 -122.406565108408 (37.7200637812891, -122.406565108408) 10 7 8 309 28
16957 261853 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1900x Bay Shore Blvd 13 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
17526 19573 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY1 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
18106 25447 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1261X La Salle Ave 15 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017141.6501925 2094501.7221284 37.732064349457 -122.383068698568 (37.732064349457, -122.383068698568) 10 3 8 58 1
18183 261610 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1900x Bay Shore Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
18251 19765 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY16 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 30ST                      
19028 17266 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 40 Osceola Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017197.5430923 2094354.669125 37.7316636592684 -122.382865232677 (37.7316636592684, -122.382865232677) 10 3 8 58 1
19364 10993 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1514 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016151.5025 2097133.86056 37.7392369091669 -122.386675366572 (37.7392369091669, -122.386675366572) 10 3 8 58 1
19379 261609 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1900x Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
21244 186970 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1650x Sloat Blvd 1 Median : Cutout Tree DPW 1     10 Width 0ft   5986025.4295 2095869.2083 37.7340506115946 -122.490743373283 (37.7340506115946, -122.490743373283) 1 8 4 64 35
21497 106463 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 3500X MISSION ST 3 Median : Cutout Tree DPW 1     28     6005565.6 2097823.9 37.7405398531137 -122.42332575716 (37.7405398531137, -122.42332575716) 2 7 7 28859 2
22120 11335 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1279 Ingalls St 4 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6017412.9471167 2093950.7223454 37.7305663998171 -122.382092440811 (37.7305663998171, -122.382092440811) 10 3 8 58 1
22332 11205 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001X Ingalls St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X4   6018170.9910099 2094117.1281791 37.7310651541831 -122.379483297777 (37.7310651541831, -122.379483297777) 10 3 8 58 1
22605 11290 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1199X Ingalls St 2 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6017612.0195749 2093925.7037957 37.7305086962257 -122.381402471608 (37.7305086962257, -122.381402471608) 10 3 8 58 1
22682 254083 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 170x Kensington Way 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5994883 2098695 37.7423229834884 -122.460324888843 (37.7423229834884, -122.460324888843) 1 8 4 59 40
23101 11356 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1339 Ingalls St 5 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6017292.9099838 2093920.0801467 37.7304756321775 -122.382505299944 (37.7304756321775, -122.382505299944) 10 3 8 58 1
23827 11368 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1351X Ingalls St 7 Sidewalk: Curb side : Cutout Tree DPW 1     45 3X3   6017270.42563 2093912.097264 37.730452470679 -122.38258247713 (37.730452470679, -122.38258247713) 10 3 8 58 1
26132 9282 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 12 George Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017331.5677853 2094059.0389315 37.7308593210732 -122.382381317235 (37.7308593210732, -122.382381317235) 10 3 8 58 1
26569 11361 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1350X Ingalls St 5 Sidewalk: Curb side : Cutout Tree DPW 1     80 3X3   6017253.696644 2093959.2156364 37.7305809242894 -122.382643589629 (37.7305809242894, -122.382643589629) 10 3 8 58 1
27402 106587 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001X SAN JOSE AVE 8 Median : Yard Tree DPW 1     25     6004855 2096548 37.7369963898236 -122.425691948858 (37.7369963898236, -122.425691948858) 2 7 5 28859 2
29305 187037 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 2501 Sunset Blvd 56 Sidewalk: Property side : Yard Tree Private 2     29 Width 0ft   5984959.5362 2097794.0341 37.7392733453171 -122.494570293909 (37.7392733453171, -122.494570293909) 1 8 3 29491 35
29600 12029 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1250X La Salle Ave 11 Sidewalk: Curb side : Cutout Tree DPW 1   02/25/2011 12:00:00 AM 12 3X3   6017218.4556902 2094518.641349 37.7321150500381 -122.382804339533 (37.7321150500381, -122.382804339533) 10 3 8 58 1
29971 117550 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 24X KEMPTON AVE 4 Side Yard : Yard Tree DPW 1       30x30   5992274 2087683 37.7119363308651 -122.468544900416 (37.7119363308651, -122.468544900416) 9 8 4 64 24
30070 199407 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 301x Cashmere St 7 Median : Yard Tree DPW 1     18     6016184.13642 2096191.07332 37.736650012889 -122.386496812495 (37.736650012889, -122.386496812495) 10 3 8 58 1
30090 11422 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 803X Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6016040.90005 2096755.86498 37.738192886184 -122.38703142706 (37.738192886184, -122.38703142706) 10 3 8 58 1

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