trees

228 rows where qLegalStatus_id = 1 and qSpecies_id = 100 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

qLegalStatus_id ✖

  • DPW Maintained · 228 ✖
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)
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
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
90168 91487 DPW Maintained 1 Pinus Spp :: Pine Spp 100 750x Brotherhood Way 21 Median : Cutout Tree DPW 1   03/15/2007 12:00:00 AM 3     5991053.474445 2088092.036965 37.7129888676025 -122.472793145921 (37.7129888676025, -122.472793145921) 1 8 4 64 14
124810 107321 DPW Maintained 1 Pinus Spp :: Pine Spp 100 400X JUNIPERO SERRA BLVD 4 Median : Cutout Tree DPW 1     14     5991395 2094254 37.7299278633008 -122.47206158935 (37.7299278633008, -122.47206158935) 9 8 4 64 40
140163 194432 DPW Maintained 1 Pinus Spp :: Pine Spp 100 900x Carolina St 64 Median : Yard Tree DPW 1     17     6012507.9331 2102881.18314 37.754815434199 -122.399676708016 (37.754815434199, -122.399676708016) 10 3 8 28856 29
176168 3760 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1062X Carolina St 2 Median : Cutout Tree DPW 1     20     6012453.5755993 2103020.9691678 37.7551962258659 -122.399874507795 (37.7551962258659, -122.399874507795) 10 3 8 28856 29
668 19865 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 9 Sidewalk: Curb side : Cutout Tree DPW 1     24 100ST                      
4582 19867 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 11 Sidewalk: Curb side : Cutout Tree DPW 1     24 100ST                      
4845 20011 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY47 20 Sidewalk: Curb side : Cutout Tree DPW 1     6 100ST                      
7006 19814 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY24 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
11608 20009 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY47 18 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
15362 20010 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY47 19 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
16746 19862 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 6 Sidewalk: Curb side : Cutout Tree DPW 1     24 100ST                      
19337 20012 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY47 21 Sidewalk: Curb side : Cutout Tree DPW 1     6 100ST                      
4365 19748 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY15 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
6577 19937 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY38 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
19228 19750 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY15 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
148969 23882 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1500X Webster St 5 Median : Cutout Tree DPW 1     20 12   6003644.6262703 2113904.6308207 37.7845850728987 -122.431115216253 (37.7845850728987, -122.431115216253) 13 9 11 29490 41
7444 19914 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY35 10 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
9396 19915 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY35 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
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
17497 19970 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY44 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
112548 3763 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1074 Carolina St 1 Median : Cutout Tree DPW 1     12 18   6012456.6037355 2102966.9856684 37.7550481677782 -122.399860245008 (37.7550481677782, -122.399860245008) 10 3 8 28856 29
167995 3761 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1074 Carolina St 1 Median : Cutout Tree DPW 1     12 18   6012458 2102979 37.7550812343514 -122.399856259894 (37.7550812343514, -122.399856259894) 10 3 8 28856 29
8572 19744 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY15 -7 Sidewalk: Curb side : Cutout Tree DPW 1     6 1OST                      
10352 19743 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY15 -8 Sidewalk: Curb side : Cutout Tree DPW 1     6 1OST                      
157910 16689 DPW Maintained 1 Pinus Spp :: Pine Spp 100 620 Noriega St 1 Median : Cutout Tree DPW 1     12 2   5992122.8128645 2103567.9103998 37.7555435761415 -122.470223454796 (37.7555435761415, -122.470223454796) 1 8 4 56 12
4839 19757 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY15 15 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
6896 19756 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY15 14 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
10714 19791 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY19 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 20ST                      
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                      
8062 19638 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 37 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
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                      
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                      
11194 19644 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 43 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
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                      
14227 19634 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 33 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
14796 19621 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 20 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
15745 19847 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY26 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 30                      
16095 19616 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
17668 19627 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 26 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
18118 19603 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
18480 19609 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
18517 19608 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
18599 19604 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
18793 19631 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 30 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
18925 19645 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 44 Sidewalk: Curb side : Cutout Tree DPW 1     3 30                      
19223 19615 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
19598 19633 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 32 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
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                      
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
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
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
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
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
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                      
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                      

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