trees

267 rows where qSpecies_id = 100 sorted by DBH

✎ 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)
985 262391 Private 9 Pinus Spp :: Pine Spp 100 2646 38th Ave 1 Back Yard : Yard Tree Private 2       Width 0ft   5984657 2097167 37.7375339667511 -122.495570077384 (37.7375339667511, -122.495570077384) 1 8 3 29491 35
1192 262086 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 6 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
1202 254563 DPW Maintained 1 Pinus Spp :: Pine Spp 100 98x High St 1 unknown : Yard Tree DPW 1       3x3   5999731 2100707 37.748125134697 -122.443706547761 (37.748125134697, -122.443706547761) 2 4 5 63 22
1526 262088 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 4 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
1707 262090 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 2 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
3507 91430 DPW Maintained 1 Pinus Spp :: Pine Spp 100 800X Portola Dr 4 Median : Cutout Tree DPW 1   10/10/2005 12:00:00 AM   4x4   5996711.121131 2099335.742872 37.7441872967186 -122.454050104178 (37.7441872967186, -122.454050104178) 1 7 4 59 40
5089 262085 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 7 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
11844 262089 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 3 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
11958 262083 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 9 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
12562 262087 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 5 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
13846 262084 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 8 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
15464 262332 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1X Cuesta Ct 1 Unaccepted Street : Yard Tree Private 2       3x3   5999654 2101769 37.7510367373071 -122.444049107076 (37.7510367373071, -122.444049107076) 2 5 5 63 38
18853 262082 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 1 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
28797 106211 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1646 35TH AVE 1 Sidewalk: Curb side : Yard Tree Private 2         Permit Number 773238 5985355 2103995.9 37.7563251201532 -122.493659849192 (37.7563251201532, -122.493659849192) 1 8 3 56 35
28928 116154 Property Tree 8 Pinus Spp :: Pine Spp 100 324 POPE ST 1 Back Yard : Yard Tree Private 2       3x3   6000502 2087202 37.7110874704678 -122.440072212787 (37.7110874704678, -122.440072212787) 9 7 6 28861 5
35285 110616 Undocumented 4 Pinus Spp :: Pine Spp 100 182X LOWER TER   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999820 2106230 37.7632950157782 -122.44379552503 (37.7632950157782, -122.44379552503) 15 5 5 29492 3
35747 93927 Permitted Site 7 Pinus Spp :: Pine Spp 100 737 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5988857.6 2089713.7 37.7173141872637 -122.480501360019 (37.7173141872637, -122.480501360019) 1 8 4 64 14
48765 98082 Significant Tree 6 Pinus Spp :: Pine Spp 100 525 Grafton Ave 1 Sidewalk: Property side : Cutout Tree Private 2           5995193.7 2090526.9 37.7199132334677 -122.45865940878 (37.7199132334677, -122.45865940878) 9 8 6 28861 24
50522 93931 Significant Tree 6 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 1 8 4 64 14
54825 110699 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 5 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
57396 106550 DPW Maintained 1 Pinus Spp :: Pine Spp 100 81 MINERVA ST   Median : Cutout Tree DPW 1           5996079.6 2088963.3 37.7156708325413 -122.455484227095 (37.7156708325413, -122.455484227095) 9 8 6 28861 24
60871 110703 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 9 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
61835 110697 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 3 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
64164 251362 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1300X Stanyan St 1 Unaccepted Street : Yard Tree Private 2       3x3   5997565 2104877 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349) 15 5 11 28862 12
68559 91429 DPW Maintained 1 Pinus Spp :: Pine Spp 100 800X Portola Dr 3 Median : Cutout Tree DPW 1   10/10/2005 12:00:00 AM   4x4   5996711.121131 2099335.742872 37.7441872967186 -122.454050104178 (37.7441872967186, -122.454050104178) 1 7 4 59 40
72516 258223 Significant Tree 6 Pinus Spp :: Pine Spp 100 53 Starr King Way 1 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft Permit Number 782966 6005764 2113984 37.784922869937 -122.423788535241 (37.784922869937, -122.423788535241) 13 9 11 28858 41
80145 110707 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 13 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
93191 110709 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 15 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
93834 87762 Permitted Site 7 Pinus Spp :: Pine Spp 100 747 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50415 6012202 2113577 37.7841666723804 -122.401486377799 (37.7841666723804, -122.401486377799) 6 2 9 28853 34
98050 110259 Undocumented 4 Pinus Spp :: Pine Spp 100 655 SANCHEZ ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003729.2 2104438 37.7585968119418 -122.430147043342 (37.7585968119418, -122.430147043342) 2 4 5 28862 3
99587 110713 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 19 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
105498 93932 Significant Tree 6 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 1 8 4 64 14
107393 98343 Undocumented 4 Pinus Spp :: Pine Spp 100 2999x Turk St 1 Sidewalk: Property side : Cutout Tree Private 2   02/01/2012 12:00:00 AM   5x3 Permit Number 768613 5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
113217 255048 Significant Tree 6 Pinus Spp :: Pine Spp 100 45 Eagle St 3 Front Yard : Yard Tree Private 2       Width 3ft   6000118.88808 2104341.86796 37.7581277146448 -122.44262619575 (37.7581277146448, -122.44262619575) 2 4 5 28862 3
116302 110705 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 11 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
125688 117419 Undocumented 4 Pinus Spp :: Pine Spp 100 452 OAK ST 1 Front Yard : Yard Tree Private 2           6004802 2110240 37.774588415373 -122.426850015779 (37.774588415373, -122.426850015779) 7 9 11 28852 10
137658 91427 DPW Maintained 1 Pinus Spp :: Pine Spp 100 800X Portola Dr 1 Median : Cutout Tree DPW 1   10/10/2005 12:00:00 AM   4x4   5996711.121131 2099335.742872 37.7441872967186 -122.454050104178 (37.7441872967186, -122.454050104178) 1 7 4 59 40
137765 100745 Permitted Site 7 Pinus Spp :: Pine Spp 100 760 Duboce Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002024.1 2108325.5 37.7691742163209 -122.436322258742 (37.7691742163209, -122.436322258742) 15 5 5 29492 9
154648 110701 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 7 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
162240 93928 Permitted Site 7 Pinus Spp :: Pine Spp 100 737 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5988857.6 2089713.7 37.7173141872637 -122.480501360019 (37.7173141872637, -122.480501360019) 1 8 4 64 14
165349 110711 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 17 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
167631 112904 Undocumented 4 Pinus Spp :: Pine Spp 100 727 BURNETT AVE   Back Yard : Yard Tree Private 2       3x3   5999303 2101616 37.750596607185 -122.44525189688 (37.750596607185, -122.44525189688) 2 5 5 63 38
171763 106405 Significant Tree 6 Pinus Spp :: Pine Spp 100 4849X 19th St   Front Yard : Yard Tree Private 2         Permit Number 772769 5999644.57626 2104777.09851 37.7592957011711 -122.444297841065 (37.7592957011711, -122.444297841065) 2 4 5 28862 3
175590 110271 Undocumented 4 Pinus Spp :: Pine Spp 100 298X 28TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004269 2099559 37.7452307768148 -122.427932506483 (37.7452307768148, -122.427932506483) 2 7 5 63 22
177628 93925 Permitted Site 7 Pinus Spp :: Pine Spp 100 3711 19th Ave 2 Sidewalk: Curb side : Yard Tree Private 2           5990297.3 2090806 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889) 1 8 4 64 14
182249 173897 Undocumented 4 Pinus Spp :: Pine Spp 100 90x Knollview Way 1 Back Yard : Yard Tree Private 2       3x3   5997593 2101480 37.7501254274205 -122.451155378281 (37.7501254274205, -122.451155378281) 1 5 4 63 38
38345 181498 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1400 Sunset Blvd 58 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984861.653 2105433.8466 37.7602444476946 -122.495472038545 (37.7602444476946, -122.495472038545) 1 8 3 56 35
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
72299 200142 Undocumented 4 Pinus Spp :: Pine Spp 100 700 Jamestown Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015325.0376 2088350.2198 37.7150729908419 -122.388919862472 (37.7150729908419, -122.388919862472) 10 3 8 58 1
84766 181408 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1500 Sunset Blvd 41 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984930.7159 2104693.9263 37.7582168762917 -122.495178621433 (37.7582168762917, -122.495178621433) 1 8 3 56 35
96144 186012 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1900 Sunset Blvd 7 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985010.9219 2101736.8552 37.750102270029 -122.494683232466 (37.750102270029, -122.494683232466) 1 8 3 29491 35
97619 187039 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2501 Sunset Blvd 58 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984947.4301 2097783.6094 37.7392440133349 -122.494611382457 (37.7392440133349, -122.494611382457) 1 8 3 29491 35
130013 181474 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1400 Sunset Blvd 34 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984899.5262 2105276.2272 37.7598138863622 -122.495329430578 (37.7598138863622, -122.495329430578) 1 8 3 56 35
136225 186490 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1400 Lower Great Hwy 36 unknown : Yard Tree Private 2     1 Width 0ft   5980883.265 2105397.7493 37.7599115788226 -122.509228480711 (37.7599115788226, -122.509228480711) 1 8 3 56 35
167992 181494 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1400 Sunset Blvd 54 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984852.1847 2105397.6443 37.7601444918652 -122.495502114318 (37.7601444918652, -122.495502114318) 1 8 3 56 35
177971 200796 Undocumented 4 Pinus Spp :: Pine Spp 100 700 Jamestown Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015315.685 2088368.925 37.7151238332906 -122.388953494511 (37.7151238332906, -122.388953494511) 10 3 8 58 1
183847 185496 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2400 Sunset Blvd 50 unknown : Yard Tree Private 2     1 Width 0ft   5985141.6583 2098649.8553 37.7416338578085 -122.494003662835 (37.7416338578085, -122.494003662835) 1 8 3 29491 35
185727 185166 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2500 Sunset Blvd 17 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985143.9825 2097713.2278 37.7390622665176 -122.493926616722 (37.7390622665176, -122.493926616722) 1 8 3 29491 35
193255 185171 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2500 Sunset Blvd 23 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985156.5992 2097759.0465 37.7391888105651 -122.493886370266 (37.7391888105651, -122.493886370266) 1 8 3 29491 35
4649 141530 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2901 TURK BLVD 1 Sidewalk: Property side : Cutout Tree Private 2     10 Width 0ft   5996711.9256 2111472.0638 37.7775105970069 -122.454924058113 (37.7775105970069, -122.454924058113) 15 6 2 54 16
10838 233336 DPW Maintained 1 Pinus Spp :: Pine Spp 100 5545 Diamond Heights Blvd 4 Sidewalk: Property side : Yard Tree Private 2     11 Width 9ft   6001777.47587 2097325.41548 37.7389566084644 -122.436387932367 (37.7389566084644, -122.436387932367) 2 7 5 63 7
70928 182054 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1358 30th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     11 Width 0ft   5986815.973 2106023.5284 37.7619777922823 -122.48875640159 (37.7619777922823, -122.48875640159) 1 8 3 56 35
874 19715 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY13 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
2429 19676 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 75 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
2687 19642 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 41 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
2883 19735 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
3770 19669 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 68 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
3883 19686 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 85 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
4763 19993 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
5085 19999 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 19 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
5469 19685 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 84 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
5560 19687 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 86 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
5857 19992 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
6036 19632 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 31 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
6212 19719 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY13 17 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
6354 19722 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY13 20 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
6577 19937 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY38 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
6893 19997 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 17 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
7006 19814 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY24 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
7883 19613 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
7921 19736 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
8767 19662 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 61 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
8957 19624 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 23 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
9280 19702 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY12 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
9459 19610 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
9917 19611 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
10384 19679 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 78 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
10714 19791 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY19 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 20ST                      
11089 19690 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 89 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
11194 19644 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 43 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
11434 19648 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 47 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
11608 20009 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY47 18 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
13490 19614 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
13544 19716 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY13 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
14700 19670 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 69 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
14796 19621 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 20 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
15132 19718 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY13 16 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
15362 20010 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY47 19 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
15491 19647 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 46 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
15658 19658 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 57 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      

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