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)
28797 106211 1 100 1646 35TH AVE 1 Sidewalk: Curb side : Yard Tree 2         Permit Number 773238 5985355 2103995.9 37.7563251201532 -122.493659849192 (37.7563251201532, -122.493659849192) 1 8 3 56 35
57396 106550 1 100 81 MINERVA ST   Median : Cutout Tree 1           5996079.6 2088963.3 37.7156708325413 -122.455484227095 (37.7156708325413, -122.455484227095) 9 8 6 28861 24
124810 107321 1 100 400X JUNIPERO SERRA BLVD 4 Median : Cutout Tree 1     14     5991395 2094254 37.7299278633008 -122.47206158935 (37.7299278633008, -122.47206158935) 9 8 4 64 40
113538 11196 1 100 180 Idora Ave 2 Median : Cutout Tree 1     3 8   5995389.3079719 2099438.232962 37.7443928282829 -122.458628033721 (37.7443928282829, -122.458628033721) 1 8 4 59 40
151588 11197 1 100 180 Idora Ave 3 Median : Cutout Tree 1     3 8   5995389.3079719 2099438.232962 37.7443928282829 -122.458628033721 (37.7443928282829, -122.458628033721) 1 8 4 59 40
90765 113415 1 100 450 PORTOLA DR   Sidewalk: Curb side : Cutout Tree 1     60 3x3   5998094 2100018 37.7461398052423 -122.449317577522 (37.7461398052423, -122.449317577522) 2 7 5 63 7
174020 12499 1 100 1200X Lake Merced Blvd 1 Median : Cutout Tree 1     18 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649) 1 8 4 64 14
57780 12503 1 100 1200X Lake Merced Blvd 5 Median : Cutout Tree 1     12 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649) 1 8 4 64 14
25415 132165 1 100 3075 Clay St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 4ft   6000074.17402 2115752.57218 37.7894560684958 -122.443600532065 (37.7894560684958, -122.443600532065) 13 6 1 29490 27
182791 13404 1 100 360 Marietta Dr 2 Median : Cutout Tree 1     40 5x1000   5999647.998558 2097391.335153 37.7390163784819 -122.44375539278 (37.7390163784819, -122.44375539278) 9 7 4 59 40
35177 13405 1 100 362 Marietta Dr 1 Median : Cutout Tree 1     45 5   5999656.8275613 2097385.3812268 37.7390005339934 -122.443724438614 (37.7390005339934, -122.443724438614) 9 7 4 59 40
133753 141484 1 100 2901 TURK BLVD 8 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   5996823.7065 2111503.4721 37.7776032476224 -122.454539642462 (37.7776032476224, -122.454539642462) 15 6 2 54 16
144141 141485 1 100 2901 TURK BLVD 9 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   5996846.7484 2111491.4026 37.7775714294456 -122.454459061112 (37.7775714294456, -122.454459061112) 15 6 2 54 16
70203 141487 1 100 2901 TURK BLVD 11 Sidewalk: Curb side : Cutout Tree 2     25 Width 0ft   5996890.9122 2111495.5172 37.7775852598057 -122.45430658183 (37.7775852598057, -122.45430658183) 15 6 2 54 16
85674 141489 1 100 2901 TURK BLVD 13 Sidewalk: Curb side : Cutout Tree 2     27 Width 0ft   5996912.3083 2111498.8089 37.777595524924 -122.45423280375 (37.777595524924, -122.45423280375) 15 6 2 54 16
113118 141491 1 100 2901 TURK BLVD 15 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   5996944.1281 2111502.1006 37.7776063877102 -122.454122966753 (37.7776063877102, -122.454122966753) 15 6 2 54 16
193417 141493 1 100 2901 TURK BLVD 17 Sidewalk: Curb side : Cutout Tree 2     7 Width 0ft   5996968.2673 2111507.0382 37.7776213292106 -122.45403981827 (37.7776213292106, -122.45403981827) 15 6 2 54 16
83939 141495 1 100 2901 TURK BLVD 19 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   5996998.9899 2111511.9757 37.7776366478442 -122.45393389566 (37.7776366478442, -122.45393389566) 15 6 2 54 16
4649 141530 1 100 2901 TURK BLVD 1 Sidewalk: Property side : Cutout Tree 2     10 Width 0ft   5996711.9256 2111472.0638 37.7775105970069 -122.454924058113 (37.7775105970069, -122.454924058113) 15 6 2 54 16
3185 141534 1 100 2901 TURK BLVD 5 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   5996778.1712 2111479.8816 37.7775358625794 -122.454695458772 (37.7775358625794, -122.454695458772) 15 6 2 54 16
135916 141536 1 100 2901 TURK BLVD 7 Sidewalk: Curb side : Cutout Tree 2     7 Width 0ft   5996809.4424 2111483.7219 37.7775482006436 -122.454587559354 (37.7775482006436, -122.454587559354) 15 6 2 54 16
37573 141619 1 100 31 LOYOLA TER 2 Sidewalk: Curb side : Cutout Tree 2     3 Width 0ft   5998404.7923 2110908.8953 37.7760612473543 -122.449027315104 (37.7760612473543, -122.449027315104) 15 6 2 29492 16
157910 16689 1 100 620 Noriega St 1 Median : Cutout Tree 1     12 2   5992122.8128645 2103567.9103998 37.7555435761415 -122.470223454796 (37.7555435761415, -122.470223454796) 1 8 4 56 12
4432 181365 1 100 1600 Sunset Blvd 92 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984912.4611 2104151.8757 37.7567274870678 -122.495201781242 (37.7567274870678, -122.495201781242) 1 8 3 56 35
84766 181408 1 100 1500 Sunset Blvd 41 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984930.7159 2104693.9263 37.7582168762917 -122.495178621433 (37.7582168762917, -122.495178621433) 1 8 3 56 35
16767 181422 1 100 1500 Sunset Blvd 55 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984930.7159 2104775.5208 37.758440912105 -122.495184638383 (37.758440912105, -122.495184638383) 1 8 3 56 35
130013 181474 1 100 1400 Sunset Blvd 34 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984899.5262 2105276.2272 37.7598138863622 -122.495329430578 (37.7598138863622, -122.495329430578) 1 8 3 56 35
167992 181494 1 100 1400 Sunset Blvd 54 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984852.1847 2105397.6443 37.7601444918652 -122.495502114318 (37.7601444918652, -122.495502114318) 1 8 3 56 35
38345 181498 1 100 1400 Sunset Blvd 58 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984861.653 2105433.8466 37.7602444476946 -122.495472038545 (37.7602444476946, -122.495472038545) 1 8 3 56 35
70928 182054 1 100 1358 30th Ave 3 Sidewalk: Curb side : Yard Tree 2     11 Width 0ft   5986815.973 2106023.5284 37.7619777922823 -122.48875640159 (37.7619777922823, -122.48875640159) 1 8 3 56 35
9159 182059 1 100 1358 30th Ave 2 Sidewalk: Curb side : Yard Tree 2     6 Width 0ft   5986815.973 2106006.8659 37.7619320416514 -122.48875517676 (37.7619320416514, -122.48875517676) 1 8 3 56 35
137660 183336 1 100 4711 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree 2     3 3x3   5981096.0962 2106871.8479 37.7639715747264 -122.508601850774 (37.7639715747264, -122.508601850774) 1 8 3 56 35
135364 185161 1 100 2500 Sunset Blvd 10 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5985124.0613 2097656.7845 37.7389061227579 -122.493991335448 (37.7389061227579, -122.493991335448) 1 8 3 29491 35
161472 185163 1 100 2500 Sunset Blvd 13 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5985155.9352 2097682.682 37.7389790952829 -122.493883039881 (37.7389790952829, -122.493883039881) 1 8 3 29491 35
185727 185166 1 100 2500 Sunset Blvd 17 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5985143.9825 2097713.2278 37.7390622665176 -122.493926616722 (37.7390622665176, -122.493926616722) 1 8 3 29491 35
193255 185171 1 100 2500 Sunset Blvd 23 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5985156.5992 2097759.0465 37.7391888105651 -122.493886370266 (37.7391888105651, -122.493886370266) 1 8 3 29491 35
45981 185462 1 100 2400 Sunset Blvd 13 unknown : Yard Tree 2     2 Width 0ft   5985138.3382 2098374.943 37.740878828405 -122.493994886454 (37.740878828405, -122.493994886454) 1 8 3 29491 35
183847 185496 1 100 2400 Sunset Blvd 50 unknown : Yard Tree 2     1 Width 0ft   5985141.6583 2098649.8553 37.7416338578085 -122.494003662835 (37.7416338578085, -122.494003662835) 1 8 3 29491 35
84533 185510 1 100 2200 Sunset Blvd 57 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5985082.4009 2099946.5475 37.7451907564521 -122.494304109241 (37.7451907564521, -122.494304109241) 1 8 3 29491 35
129083 185537 1 100 2201 Sunset Blvd 21 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984862.7264 2100065.7068 37.7455050775816 -122.495072479787 (37.7455050775816, -122.495072479787) 1 8 3 29491 35
130182 185865 1 100 2000 Sunset Blvd 8 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5985059.0462 2100990.2907 37.7480552245721 -122.494461791049 (37.7480552245721, -122.494461791049) 1 8 3 29491 35
96144 186012 1 100 1900 Sunset Blvd 7 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5985010.9219 2101736.8552 37.750102270029 -122.494683232466 (37.750102270029, -122.494683232466) 1 8 3 29491 35
139990 186132 1 100 1700 Sunset Blvd 17 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984975.4043 2103142.7715 37.753960450821 -122.494909702152 (37.753960450821, -122.494909702152) 1 8 3 56 35
70195 186133 1 100 1700 Sunset Blvd 18 Sidewalk: Property side : Yard Tree 2     8 Width 0ft   5984952.5547 2103165.275 37.7540209016237 -122.494990379508 (37.7540209016237, -122.494990379508) 1 8 3 56 35
48449 186134 1 100 1700 Sunset Blvd 19 Sidewalk: Property side : Yard Tree 2     4 Width 0ft   5984955.6705 2103171.5067 37.754038194553 -122.49498006395 (37.754038194553, -122.49498006395) 1 8 3 56 35
90455 186135 1 100 1700 Sunset Blvd 20 Sidewalk: Property side : Yard Tree 2     5 Width 0ft   5984963.2871 2103177.7384 37.7540557509571 -122.494954183766 (37.7540557509571, -122.494954183766) 1 8 3 56 35
152496 186156 1 100 1700 Sunset Blvd 41 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984977.8278 2103337.3397 37.7544948232836 -122.49491566635 (37.7544948232836, -122.49491566635) 1 8 3 56 35
136225 186490 1 100 1400 Lower Great Hwy 36 unknown : Yard Tree 2     1 Width 0ft   5980883.265 2105397.7493 37.7599115788226 -122.509228480711 (37.7599115788226, -122.509228480711) 1 8 3 56 35
60998 186736 1 100 1200 Sunset Blvd 2 Sidewalk: Property side : Yard Tree 2     22 Width 0ft   5984872.7556 2106587.8007 37.76341353282 -122.495518752014 (37.76341353282, -122.495518752014) 1 8 3 56 35
20775 186778 1 100 1200 Sunset Blvd 46 Sidewalk: Property side : Yard Tree 2     27 Width 0ft   5984835.1586 2106804.893 37.7640074057024 -122.495664799754 (37.7640074057024, -122.495664799754) 1 8 3 56 35
85558 186783 1 100 1200 Sunset Blvd 51 Sidewalk: Property side : Yard Tree 2     25 Width 0ft   5984862.3254 2106838.1239 37.7641002392741 -122.49557329041 (37.7641002392741, -122.49557329041) 1 8 3 56 35
68327 186829 1 100 1200 Sunset Blvd 94 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984823.8588 2106586.1554 37.763406151967 -122.495687746344 (37.763406151967, -122.495687746344) 1 8 3 56 35
97619 187039 1 100 2501 Sunset Blvd 58 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984947.4301 2097783.6094 37.7392440133349 -122.494611382457 (37.7392440133349, -122.494611382457) 1 8 3 29491 35
175429 187119 1 100 2600 Sunset Blvd 55 Sidewalk: Property side : Yard Tree 2     4 Width 0ft   5985168.1593 2097316.6584 37.7379748077492 -122.493813809362 (37.7379748077492, -122.493813809362) 1 8 3 29491 35
151873 187220 1 100 2401 Sunset Blvd 3 Sidewalk: Property side : Yard Tree 2     29 Width 0ft   5984921.2891 2098780.6261 37.7419800224632 -122.494775253241 (37.7419800224632, -122.494775253241) 1 8 3 29491 35
130886 187232 1 100 2401 Sunset Blvd 15 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984921.2891 2098611.514 37.7415156862998 -122.494762787921 (37.7415156862998, -122.494762787921) 1 8 3 29491 35
169924 187279 1 100 2401 Sunset Blvd 62 Median : Yard Tree 1     4 Width 0ft   5984952.4466 2098301.7622 37.7406670151021 -122.494632227246 (37.7406670151021, -122.494632227246) 1 8 3 29491 35
168059 187335 1 100 2200 Sunset Blvd 20 Sidewalk: Property side : Yard Tree 2     4 Width 0ft   5985078.6769 2099672.3252 37.744437598438 -122.49429677682 (37.744437598438, -122.49429677682) 1 8 3 29491 35
21989 187401 1 100 2100 Sunset Blvd 54 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5985066.4729 2100733.1142 37.747349522643 -122.494417155333 (37.747349522643, -122.494417155333) 1 8 3 29491 35
140163 194432 1 100 900x Carolina St 64 Median : Yard Tree 1     17     6012507.9331 2102881.18314 37.754815434199 -122.399676708016 (37.754815434199, -122.399676708016) 10 3 8 28856 29
26457 194520 1 100 1600 Bay Shore Blvd 40 Sidewalk: Property side : Yard Tree 2     6 Width 6ft   6012006.62045 2091255.62525 37.7228661524341 -122.400593779099 (37.7228661524341, -122.400593779099) 10 3 7 309 28
3041 19585 1 100 100 STAIRWAY4 8 Sidewalk: Curb side : Cutout Tree 1     3 60                      
18118 19603 1 100 100 STAIRWAY5 2 Sidewalk: Curb side : Cutout Tree 1     12 30                      
18599 19604 1 100 100 STAIRWAY5 3 Sidewalk: Curb side : Cutout Tree 1     12 30                      
8828 19606 1 100 100 STAIRWAY5 5 Sidewalk: Curb side : Cutout Tree 1     6 30                      
13138 19607 1 100 100 STAIRWAY5 6 Sidewalk: Curb side : Cutout Tree 1     6 30                      
18517 19608 1 100 100 STAIRWAY5 7 Sidewalk: Curb side : Cutout Tree 1     12 30                      
18480 19609 1 100 100 STAIRWAY5 8 Sidewalk: Curb side : Cutout Tree 1     6 30                      
9459 19610 1 100 100 STAIRWAY5 9 Sidewalk: Curb side : Cutout Tree 1     12 30                      
9917 19611 1 100 100 STAIRWAY5 10 Sidewalk: Curb side : Cutout Tree 1     12 30                      
1363 19612 1 100 100 STAIRWAY5 11 Sidewalk: Curb side : Cutout Tree 1     6 30                      
7883 19613 1 100 100 STAIRWAY5 12 Sidewalk: Curb side : Cutout Tree 1     12 30                      
13490 19614 1 100 100 STAIRWAY5 13 Sidewalk: Curb side : Cutout Tree 1     12 30                      
19223 19615 1 100 100 STAIRWAY5 14 Sidewalk: Curb side : Cutout Tree 1     12 30                      
16095 19616 1 100 100 STAIRWAY5 15 Sidewalk: Curb side : Cutout Tree 1     12 30                      
7118 19620 1 100 100 STAIRWAY5 19 Sidewalk: Curb side : Cutout Tree 1     18 30                      
14796 19621 1 100 100 STAIRWAY5 20 Sidewalk: Curb side : Cutout Tree 1     12 30                      
8957 19624 1 100 100 STAIRWAY5 23 Sidewalk: Curb side : Cutout Tree 1     12 30                      
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