563 rows where qSpecies_id = 52 sorted by PermitNotes

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)
116 113159 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 555 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005146 2111243 37.777361853017 -122.425731455878 (37.777361853017, -122.425731455878) 7 9 11 28852 10
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
308 102295 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 1500 Michigan St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6016449 2101073.5 37.7500708170088 -122.385921283567 (37.7500708170088, -122.385921283567) 10 3 8 58 1
400 104991 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 669X NOE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6003139 2104447 37.7585880783392 -122.432188863302 (37.7585880783392, -122.432188863302) 2 4 5 28862 3
445 110235 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 2346x CASTRO ST 1 Median : Cutout Tree Private 2       3x3   6002664.5 2098664.4 37.7426835115852 -122.433416673574 (37.7426835115852, -122.433416673574) 2 7 5 63 7
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                      
2862 261320 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 872 Ingerson Ave   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014869 2089377 37.7178670406836 -122.390567842363 (37.7178670406836, -122.390567842363) 10 3 8 58 1
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                      
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                      
6505 261618 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 1900x Bay Shore Blvd 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
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                      
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                      
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                      
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                      
14136 112391 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 2201X LYON ST 2 Sidewalk: Property side : Cutout Tree Private 2       3x12   5999307 2116423 37.7912531030346 -122.446303107227 (37.7912531030346, -122.446303107227) 13 6 1 29490 31
14460 261617 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 1900x Bay Shore Blvd 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
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                      
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
18515 12492 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 307 Lake Merced Blvd 37 Sidewalk: Curb side : Cutout Tree PUC 8     36 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
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
19966 4328 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 816 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/2000 12:00:00 AM 3 3X3   6001892.96711 2095861.16752 37.7349426843331 -122.435883876812 (37.7349426843331, -122.435883876812) 2 7 5 63 7
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

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