267 rows where qSpecies_id = 100

View and edit SQL

Suggested facets: qLegalStatus_id, qCaretaker_id, PlantDate, Police Districts

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)
398 234490 DPW Maintained 1 Pinus Spp :: Pine Spp 100 4053 20th St 1 Front Yard : Yard Tree Private 2     13 Width 3ft   6003306.74467 2104167.50736 37.7578301676468 -122.43158877311 (37.7578301676468, -122.43158877311) 2 4 5 28862 3
668 19865 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 9 Sidewalk: Curb side : Cutout Tree DPW 1     24 100ST                      
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                      
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
1363 19612 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
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
1785 19984 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 40                      
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                      
3041 19585 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY4 8 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
3185 141534 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2901 TURK BLVD 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5996778.1712 2111479.8816 37.7775358625794 -122.454695458772 (37.7775358625794, -122.454695458772) 15 6 2 54 16
3211 19860 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      
3233 245150 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 0ft   6000845.3118 2109360.3422 37.7719485860085 -122.440473841976 (37.7719485860085, -122.440473841976) 15 5 11 29492 9
3448 19730 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
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
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                      
4043 19724 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
4365 19748 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY15 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
4379 19728 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
4432 181365 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1600 Sunset Blvd 92 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984912.4611 2104151.8757 37.7567274870678 -122.495201781242 (37.7567274870678, -122.495201781242) 1 8 3 56 35
4582 19867 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 11 Sidewalk: Curb side : Cutout Tree DPW 1     24 100ST                      
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
4763 19993 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
4839 19757 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY15 15 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
4845 20011 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY47 20 Sidewalk: Curb side : Cutout Tree DPW 1     6 100ST                      
4956 19859 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 3 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      
5085 19999 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 19 Sidewalk: Curb side : Cutout Tree DPW 1     12 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
5469 19685 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 84 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
5502 19723 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
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                      
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                      
6570 19989 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 9 Sidewalk: Curb side : Cutout Tree DPW 1     6 40                      
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                      
6896 19756 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY15 14 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
7006 19814 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY24 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
7083 19857 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      
7118 19620 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 19 Sidewalk: Curb side : Cutout Tree DPW 1     18 30                      
7129 19726 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
7444 19914 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY35 10 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
7456 19682 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 81 Sidewalk: Curb side : Cutout Tree DPW 1     6 60ST                      
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
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                      
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                      
8062 19638 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 37 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
8572 19744 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY15 -7 Sidewalk: Curb side : Cutout Tree DPW 1     6 1OST                      
8767 19662 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 61 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
8828 19606 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
8957 19624 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 23 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
9155 19858 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      
9159 182059 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1358 30th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 0ft   5986815.973 2106006.8659 37.7619320416514 -122.48875517676 (37.7619320416514, -122.48875517676) 1 8 3 56 35
9280 19702 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY12 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
9396 19915 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY35 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
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                      
10352 19743 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY15 -8 Sidewalk: Curb side : Cutout Tree DPW 1     6 1OST                      
10384 19679 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 78 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
10472 19659 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 58 Sidewalk: Curb side : Cutout Tree DPW 1     18 60ST                      
10714 19791 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY19 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 20ST                      
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
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                      
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
12300 93053 Permitted Site 7 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM 36   Permit Number 53387                    
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
13138 19607 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
13154 19625 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 24 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
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                      
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
14227 19634 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 33 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
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                      
15419 23925 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1700X Webster St 7 Median : Cutout Tree DPW 1     60 12x1   6003454.8844904 2114845.825423 37.7871586020093 -122.431838884639 (37.7871586020093, -122.431838884639) 13 9 11 29490 27
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
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                      
15694 19654 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 53 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
15745 19847 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY26 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 30                      
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                      
16026 19673 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 72 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)
);