trees

267 rows where qSpecies_id = 100 sorted by PlotSize 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)
16026 19673 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 72 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
16250 19688 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 87 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
16706 19652 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 51 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
17410 19681 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 80 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
17616 19684 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 83 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
17754 19655 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 54 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
18738 19646 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 45 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
18817 19689 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 88 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
3041 19585 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY4 8 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
9280 19702 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY12 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
40408 20784 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1701X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 60   5984888.092725 2103630.7874996 37.7552952964732 -122.49524762816 (37.7552952964732, -122.49524762816) 1 8 3 56 35
43322 21267 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2492X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984994.4282385 2098239.2478178 37.740497824548 -122.494482465671 (37.740497824548, -122.494482465671) 1 8 3 29491 35
45445 21490 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2792X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5985060.3629888 2096294.4798015 37.7351618711636 -122.49411119238 (37.7351618711636, -122.49411119238) 1 8 3 29491 35
99835 20781 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1701X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     18 60   5984888.092725 2103630.7874996 37.7552952964732 -122.49524762816 (37.7552952964732, -122.49524762816) 1 8 3 56 35
154492 20647 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1501X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984817.9532367 2104951.7766639 37.7589182591611 -122.495587616201 (37.7589182591611, -122.495587616201) 1 8 3 56 35
146890 815 DPW Maintained 1 Pinus Spp :: Pine Spp 100 600X 39th Ave 13 Median : Cutout Tree DPW 1     3 6-HOA   5983831.1679936 2111715.0127262 37.7774303425616 -122.499500145383 (37.7774303425616, -122.499500145383) 11 6 2 55 26
192591 808 DPW Maintained 1 Pinus Spp :: Pine Spp 100 600X 39th Ave 6 Median : Cutout Tree DPW 1     3 6-HOA   5983831.1679936 2111715.0127262 37.7774303425616 -122.499500145383 (37.7774303425616, -122.499500145383) 11 6 2 55 26
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
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
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
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
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
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
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
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
182791 13404 DPW Maintained 1 Pinus Spp :: Pine Spp 100 360 Marietta Dr 2 Median : Cutout Tree DPW 1     40 5x1000   5999647.998558 2097391.335153 37.7390163784819 -122.44375539278 (37.7390163784819, -122.44375539278) 9 7 4 59 40
35177 13405 DPW Maintained 1 Pinus Spp :: Pine Spp 100 362 Marietta Dr 1 Median : Cutout Tree DPW 1     45 5   5999656.8275613 2097385.3812268 37.7390005339934 -122.443724438614 (37.7390005339934, -122.443724438614) 9 7 4 59 40
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
52821 91428 DPW Maintained 1 Pinus Spp :: Pine Spp 100 800X Portola Dr 2 Median : Cutout Tree DPW 1   10/10/2005 12:00:00 AM 3 4x4   5996711.121131 2099335.742872 37.7441872967186 -122.454050104178 (37.7441872967186, -122.454050104178) 1 7 4 59 40
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
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
798 19725 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
874 19715 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY13 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
2883 19735 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
3448 19730 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
4043 19724 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
4379 19728 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
5502 19723 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
6212 19719 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY13 17 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
6279 19737 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 15 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
6354 19722 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY13 20 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
7129 19726 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
7696 19727 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
7846 19732 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 10 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
7921 19736 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
13544 19716 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY13 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
15132 19718 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY13 16 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
15775 19733 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
15815 19739 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 17 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
16278 19717 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY13 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
16876 19738 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 16 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
18475 19731 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 9 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
18658 19704 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY13 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
1785 19984 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 40                      
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                      
5857 19992 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
6570 19989 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 9 Sidewalk: Curb side : Cutout Tree DPW 1     6 40                      
6893 19997 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 17 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
7553 20501 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1204 Sunset Blvd 22 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
16896 19981 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 40                      
19429 19994 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
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
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
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
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
90765 113415 DPW Maintained 1 Pinus Spp :: Pine Spp 100 450 PORTOLA DR   Sidewalk: Curb side : Cutout Tree DPW 1     60 3x3   5998094 2100018 37.7461398052423 -122.449317577522 (37.7461398052423, -122.449317577522) 2 7 5 63 7
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
103685 248958 Significant Tree 6 Pinus Spp :: Pine Spp 100 98x Rosewood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/2017 12:00:00 AM 3 3x3   5994824 2095658 37.7339807377795 -122.460308897898 (37.7339807377795, -122.460308897898) 9 8 4 59 40
137660 183336 DPW Maintained 1 Pinus Spp :: Pine Spp 100 4711 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   5981096.0962 2106871.8479 37.7639715747264 -122.508601850774 (37.7639715747264, -122.508601850774) 1 8 3 56 35
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
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
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
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
173188 29631 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1110X Junipero Serra Blvd 4 Median : Cutout Tree DPW 1     3 3X3   5991107.8990451 2089843.5367701 37.717801208369 -122.47273266668 (37.717801208369, -122.47273266668) 9 8 4 64 40
22262 23613 DPW Maintained 1 Pinus Spp :: Pine Spp 100 900X Vermont St 1 Sidewalk: Curb side : Cutout Tree DPW 1     36 30X30PL   6011293.8960822 2104150.9045186 37.7582340578883 -122.40396455427 (37.7582340578883, -122.40396455427) 10 3 8 28856 29
3211 19860 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      
4956 19859 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 3 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      
7083 19857 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      
9155 19858 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      
16380 19763 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY16 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 30ST                      
16655 19861 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 5 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      
1363 19612 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
2687 19642 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 41 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
6036 19632 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 31 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
7118 19620 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 19 Sidewalk: Curb side : Cutout Tree DPW 1     18 30                      
7883 19613 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      

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