trees
267 rows where qSpecies_id = 100 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
3211 | 19860 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
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 | |||||||||||||
4582 | 19867 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||
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 | |||
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 | |||||||||||||
16095 | 19616 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
16250 | 19688 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 87 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
16278 | 19717 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
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 | |||||||||||||
16706 | 19652 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 51 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
16746 | 19862 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
16876 | 19738 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
16896 | 19981 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | |||||||||||||
17410 | 19681 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 80 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
17497 | 19970 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY44 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );