563 rows where qSpecies_id = 52 sorted by qCaretaker_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                      
2649 20050 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY52 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
3196 19917 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY35 13 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
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                      
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                      
4870 19873 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY33 5 Sidewalk: Curb side : Cutout Tree DPW 1     30 25ST                      
5641 19822 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY25 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
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                      
7383 17629 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 150 Phelps St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 10M                      
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                      
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                      
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                      
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                      
12194 261567 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 1299 Wisconsin St 12 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
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                      
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
18251 19765 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY16 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 30ST                      
18337 113889 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 1x STORRIE ST 2 Sidewalk: Property side : Yard Tree DPW 1     90     6000722 2105303 37.7608011093363 -122.440609317727 (37.7608011093363, -122.440609317727) 15 4 5 28862 3
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
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
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
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
30226 11204 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001X Ingalls St 2 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X4   6018170.9910099 2094117.1281791 37.7310651541831 -122.379483297777 (37.7310651541831, -122.379483297777) 10 3 8 58 1
31265 176308 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 300x Mansell St 12 Median : Cutout Tree DPW 1     23 Width 0ft   6010842.73462 2090461.59096 37.7206209176161 -122.404561241708 (37.7206209176161, -122.404561241708) 10 7 7 309 28
31554 12012 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1230X La Salle Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1   11/09/1992 12:00:00 AM 6 3X3   6017323.1168478 2094452.6646717 37.7319396729967 -122.382437910438 (37.7319396729967, -122.382437910438) 10 3 8 58 1
31787 176327 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 700x Mansell St 31 Median : Cutout Tree DPW 1     46 Width 0ft   6009212.31958 2089948.46975 37.7191207387124 -122.410160889327 (37.7191207387124, -122.410160889327) 9 3 8 309 18
33151 176307 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 300x Mansell St 7 Median : Cutout Tree DPW 1     14 Width 0ft   6010889.97096 2090468.71488 37.7206431182563 -122.404398460825 (37.7206431182563, -122.404398460825) 10 7 7 309 28
36101 106466 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 3500X MISSION ST 6 Median : Cutout Tree DPW 1     26     6005565.6 2097823.9 37.7405398531137 -122.42332575716 (37.7405398531137, -122.42332575716) 2 7 7 28859 2
36414 11348 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1300X Ingalls St 6 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6017347.6886145 2093992.5867035 37.7306777467756 -122.382320962891 (37.7306777467756, -122.382320962891) 10 3 8 58 1
36545 176317 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 600x Mansell St 5 Median : Cutout Tree DPW 1     20 Width 0ft   6009952.88344 2090194.234 37.7198370388417 -122.407618351232 (37.7198370388417, -122.407618351232) 10 3 8 309 18
37416 24066 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 21X Whitfield Ct 9 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6017547.7495644 2094131.2536992 37.7310695474783 -122.381638954529 (37.7310695474783, -122.381638954529) 10 3 8 58 1
38341 107538 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 198X JENNINGS ST 2 Front Yard : Yard Tree DPW 1           6018784 2097136 37.739388174499 -122.377573417349 (37.739388174499, -122.377573417349) 10 3 8 58 1
38642 176330 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 700x Mansell St 35 Median : Cutout Tree DPW 1     7 Width 0ft   6009184.10476 2089961.98667 37.7191562718235 -122.410259371368 (37.7191562718235, -122.410259371368) 9 3 8 309 18
39464 11276 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1176X Ingalls St 15 Sidewalk: Curb side : Cutout Tree DPW 1     45 3x3   6017716.362196 2093961.1645628 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671) 10 3 8 58 1
40971 23414 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1800X VAN NESS AVE 2 Median : Cutout Tree DPW 1     30 9   6006192 2116736 37.7925033310543 -122.422503407712 (37.7925033310543, -122.422503407712) 13 9 10 28858 32
42151 176303 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 200x Mansell St 16 Median : Cutout Tree DPW 1     23 Width 0ft   6011115.33526 2090539.97459 37.7208513742667 -122.403624453898 (37.7208513742667, -122.403624453898) 10 7 7 309 28
43256 12008 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1230X La Salle Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017323.1168478 2094452.6646717 37.7319396729967 -122.382437910438 (37.7319396729967, -122.382437910438) 10 3 8 58 1
43752 12018 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1230X La Salle Ave 19 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017323.1168478 2094452.6646717 37.7319396729967 -122.382437910438 (37.7319396729967, -122.382437910438) 10 3 8 58 1
44557 12013 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1230X La Salle Ave 14 Sidewalk: Curb side : Cutout Tree DPW 1     45 3X3   6017323.1168478 2094452.6646717 37.7319396729967 -122.382437910438 (37.7319396729967, -122.382437910438) 10 3 8 58 1
44857 6104 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 500X 08th St 6 Median : Cutout Tree DPW 1     12 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34

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