trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
13154 19625 1 100 100 STAIRWAY5 24 Sidewalk: Curb side : Cutout Tree 1     6 30                      
17668 19627 1 100 100 STAIRWAY5 26 Sidewalk: Curb side : Cutout Tree 1     12 30                      
18793 19631 1 100 100 STAIRWAY5 30 Sidewalk: Curb side : Cutout Tree 1     12 30                      
6036 19632 1 100 100 STAIRWAY5 31 Sidewalk: Curb side : Cutout Tree 1     12 30                      
19598 19633 1 100 100 STAIRWAY5 32 Sidewalk: Curb side : Cutout Tree 1     6 30                      
14227 19634 1 100 100 STAIRWAY5 33 Sidewalk: Curb side : Cutout Tree 1     6 30                      
8062 19638 1 100 100 STAIRWAY5 37 Sidewalk: Curb side : Cutout Tree 1     6 30                      
2687 19642 1 100 100 STAIRWAY5 41 Sidewalk: Curb side : Cutout Tree 1     12 30                      
11194 19644 1 100 100 STAIRWAY5 43 Sidewalk: Curb side : Cutout Tree 1     12 30                      
18925 19645 1 100 100 STAIRWAY5 44 Sidewalk: Curb side : Cutout Tree 1     3 30                      
18738 19646 1 100 100 STAIRWAY5 45 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
15491 19647 1 100 100 STAIRWAY5 46 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
11434 19648 1 100 100 STAIRWAY5 47 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
16706 19652 1 100 100 STAIRWAY5 51 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
15694 19654 1 100 100 STAIRWAY5 53 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
17754 19655 1 100 100 STAIRWAY5 54 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
15658 19658 1 100 100 STAIRWAY5 57 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
10472 19659 1 100 100 STAIRWAY5 58 Sidewalk: Curb side : Cutout Tree 1     18 60ST                      
8767 19662 1 100 100 STAIRWAY5 61 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
3770 19669 1 100 100 STAIRWAY5 68 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
14700 19670 1 100 100 STAIRWAY5 69 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
16026 19673 1 100 100 STAIRWAY5 72 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
2429 19676 1 100 100 STAIRWAY5 75 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
10384 19679 1 100 100 STAIRWAY5 78 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
17410 19681 1 100 100 STAIRWAY5 80 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
7456 19682 1 100 100 STAIRWAY5 81 Sidewalk: Curb side : Cutout Tree 1     6 60ST                      
17616 19684 1 100 100 STAIRWAY5 83 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
5469 19685 1 100 100 STAIRWAY5 84 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
3883 19686 1 100 100 STAIRWAY5 85 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
5560 19687 1 100 100 STAIRWAY5 86 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
16250 19688 1 100 100 STAIRWAY5 87 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
18817 19689 1 100 100 STAIRWAY5 88 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
11089 19690 1 100 100 STAIRWAY5 89 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
9280 19702 1 100 100 STAIRWAY12 2 Sidewalk: Curb side : Cutout Tree 1     12 60                      
18658 19704 1 100 100 STAIRWAY13 2 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
874 19715 1 100 100 STAIRWAY13 13 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
13544 19716 1 100 100 STAIRWAY13 14 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
16278 19717 1 100 100 STAIRWAY13 15 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
15132 19718 1 100 100 STAIRWAY13 16 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
6212 19719 1 100 100 STAIRWAY13 17 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
6354 19722 1 100 100 STAIRWAY13 20 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
5502 19723 1 100 100 STAIRWAY14 1 Sidewalk: Curb side : Cutout Tree 1     3 40ST                      
4043 19724 1 100 100 STAIRWAY14 2 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
798 19725 1 100 100 STAIRWAY14 3 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
7129 19726 1 100 100 STAIRWAY14 4 Sidewalk: Curb side : Cutout Tree 1     3 40ST                      
7696 19727 1 100 100 STAIRWAY14 5 Sidewalk: Curb side : Cutout Tree 1     3 40ST                      
4379 19728 1 100 100 STAIRWAY14 6 Sidewalk: Curb side : Cutout Tree 1     3 40ST                      
3448 19730 1 100 100 STAIRWAY14 8 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
18475 19731 1 100 100 STAIRWAY14 9 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
7846 19732 1 100 100 STAIRWAY14 10 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
15775 19733 1 100 100 STAIRWAY14 11 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
2883 19735 1 100 100 STAIRWAY14 13 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
7921 19736 1 100 100 STAIRWAY14 14 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
6279 19737 1 100 100 STAIRWAY14 15 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
16876 19738 1 100 100 STAIRWAY14 16 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
15815 19739 1 100 100 STAIRWAY14 17 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
10352 19743 1 100 100 STAIRWAY15 -8 Sidewalk: Curb side : Cutout Tree 1     6 1OST                      
8572 19744 1 100 100 STAIRWAY15 -7 Sidewalk: Curb side : Cutout Tree 1     6 1OST                      
4365 19748 1 100 100 STAIRWAY15 4 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
19228 19750 1 100 100 STAIRWAY15 6 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
6896 19756 1 100 100 STAIRWAY15 14 Sidewalk: Curb side : Cutout Tree 1     3 20ST                      
4839 19757 1 100 100 STAIRWAY15 15 Sidewalk: Curb side : Cutout Tree 1     3 20ST                      
16380 19763 1 100 100 STAIRWAY16 2 Sidewalk: Curb side : Cutout Tree 1     6 30ST                      
10714 19791 1 100 100 STAIRWAY19 13 Sidewalk: Curb side : Cutout Tree 1     12 20ST                      
7006 19814 1 100 100 STAIRWAY24 5 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
15745 19847 1 100 100 STAIRWAY26 5 Sidewalk: Curb side : Cutout Tree 1     3 30                      
7083 19857 1 100 100 STAIRWAY30 1 Sidewalk: Curb side : Cutout Tree 1     24 30ST                      
9155 19858 1 100 100 STAIRWAY30 2 Sidewalk: Curb side : Cutout Tree 1     24 30ST                      
4956 19859 1 100 100 STAIRWAY30 3 Sidewalk: Curb side : Cutout Tree 1     24 30ST                      
3211 19860 1 100 100 STAIRWAY30 4 Sidewalk: Curb side : Cutout Tree 1     24 30ST                      
16655 19861 1 100 100 STAIRWAY30 5 Sidewalk: Curb side : Cutout Tree 1     24 30ST                      
16746 19862 1 100 100 STAIRWAY30 6 Sidewalk: Curb side : Cutout Tree 1     24 100ST                      
668 19865 1 100 100 STAIRWAY30 9 Sidewalk: Curb side : Cutout Tree 1     24 100ST                      
4582 19867 1 100 100 STAIRWAY30 11 Sidewalk: Curb side : Cutout Tree 1     24 100ST                      
7444 19914 1 100 100 STAIRWAY35 10 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
9396 19915 1 100 100 STAIRWAY35 11 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
6577 19937 1 100 100 STAIRWAY38 6 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
17497 19970 1 100 100 STAIRWAY44 1 Sidewalk: Curb side : Cutout Tree 1     12 15                      
16896 19981 1 100 100 STAIRWAY46 1 Sidewalk: Curb side : Cutout Tree 1     3 40                      
1785 19984 1 100 100 STAIRWAY46 4 Sidewalk: Curb side : Cutout Tree 1     18 40                      
6570 19989 1 100 100 STAIRWAY46 9 Sidewalk: Curb side : Cutout Tree 1     6 40                      
5857 19992 1 100 100 STAIRWAY46 12 Sidewalk: Curb side : Cutout Tree 1     12 40                      
4763 19993 1 100 100 STAIRWAY46 13 Sidewalk: Curb side : Cutout Tree 1     12 40                      
19429 19994 1 100 100 STAIRWAY46 14 Sidewalk: Curb side : Cutout Tree 1     12 40                      
6893 19997 1 100 100 STAIRWAY46 17 Sidewalk: Curb side : Cutout Tree 1     12 40                      
5085 19999 1 100 100 STAIRWAY46 19 Sidewalk: Curb side : Cutout Tree 1     12 40                      
11608 20009 1 100 100 STAIRWAY47 18 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
15362 20010 1 100 100 STAIRWAY47 19 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
4845 20011 1 100 100 STAIRWAY47 20 Sidewalk: Curb side : Cutout Tree 1     6 100ST                      
19337 20012 1 100 100 STAIRWAY47 21 Sidewalk: Curb side : Cutout Tree 1     6 100ST                      
72299 200142 4 100 700 Jamestown Ave 4 Sidewalk: Curb side : Cutout Tree 2     1 Width 0ft   6015325.0376 2088350.2198 37.7150729908419 -122.388919862472 (37.7150729908419, -122.388919862472) 10 3 8 58 1
17887 20041 1 100 100 STAIRWAY51 12 Sidewalk: Curb side : Cutout Tree 1     6 ST                      
177971 200796 4 100 700 Jamestown Ave 5 Sidewalk: Curb side : Cutout Tree 2     1 Width 0ft   6015315.685 2088368.925 37.7151238332906 -122.388953494511 (37.7151238332906, -122.388953494511) 10 3 8 58 1
7553 20501 1 100 1204 Sunset Blvd 22 Sidewalk: Curb side : Cutout Tree 5     24 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
169637 20525 1 100 1303X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree 1     3 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
151364 20534 1 100 1303X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree 1     6 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
93621 20546 1 100 1303X Sunset Blvd 24 Sidewalk: Curb side : Cutout Tree 1     3 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
154492 20647 1 100 1501X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree 1     3 60   5984817.9532367 2104951.7766639 37.7589182591611 -122.495587616201 (37.7589182591611, -122.495587616201) 1 8 3 56 35
99835 20781 1 100 1701X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree 1     18 60   5984888.092725 2103630.7874996 37.7552952964732 -122.49524762816 (37.7552952964732, -122.49524762816) 1 8 3 56 35
40408 20784 1 100 1701X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree 1     12 60   5984888.092725 2103630.7874996 37.7552952964732 -122.49524762816 (37.7552952964732, -122.49524762816) 1 8 3 56 35
98857 211044 1 100 372 Santa Clara Ave 3 Sidewalk: Curb side : Yard Tree 2     53 Width 3ft   5993146.9743 2095534.41654 37.7335447977497 -122.466097865337 (37.7335447977497, -122.466097865337) 9 8 4 59 40