trees

Custom SQL query returning 67 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
91858 234491 1 100 24 Saturn St 5 Side Yard : Yard Tree 2     17 Width 3ft   6000385.28479 2106021.72649 37.7627553749804 -122.44182544749 (37.7627553749804, -122.44182544749) 15 5 5 28862 3
148969 23882 1 100 1500X Webster St 5 Median : Cutout Tree 1     20 12   6003644.6262703 2113904.6308207 37.7845850728987 -122.431115216253 (37.7845850728987, -122.431115216253) 13 9 11 29490 41
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
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
16706 19652 1 100 100 STAIRWAY5 51 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
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
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                      
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
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
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
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
15658 19658 1 100 100 STAIRWAY5 57 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
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
10472 19659 1 100 100 STAIRWAY5 58 Sidewalk: Curb side : Cutout Tree 1     18 60ST                      
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
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
1192 262086 1 100 498X Burnett Ave 6 Sidewalk: Property side : Cutout Tree 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
4379 19728 1 100 100 STAIRWAY14 6 Sidewalk: Curb side : Cutout Tree 1     3 40ST                      
6577 19937 1 100 100 STAIRWAY38 6 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
13138 19607 1 100 100 STAIRWAY5 6 Sidewalk: Curb side : Cutout Tree 1     6 30                      
16746 19862 1 100 100 STAIRWAY30 6 Sidewalk: Curb side : Cutout Tree 1     24 100ST                      
19228 19750 1 100 100 STAIRWAY15 6 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
124287 211045 1 100 380 Santa Clara Ave 6 Sidewalk: Curb side : Yard Tree 2     33 Width 3ft   5993150.7745 2095420.35942 37.7332318444736 -122.466076441693 (37.7332318444736, -122.466076441693) 9 8 4 59 40
134476 245149 1 100 1192 Page St 6 Sidewalk: Curb side : Cutout Tree 2     18 Width 0ft   6000871.2374 2109327.7689 37.7718606240856 -122.440381827143 (37.7718606240856, -122.440381827143) 15 5 11 29492 9
192591 808 1 100 600X 39th Ave 6 Median : Cutout Tree 1     3 6-HOA   5983831.1679936 2111715.0127262 37.7774303425616 -122.499500145383 (37.7774303425616, -122.499500145383) 11 6 2 55 26
193841 211046 1 100 251 Wildwood Way 6 Sidewalk: Curb side : Yard Tree 2     19 Width 3ft   5995705.57302 2093291.07499 37.7275324053909 -122.457089894179 (37.7275324053909, -122.457089894179) 9 7 4 28861 40
8767 19662 1 100 100 STAIRWAY5 61 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
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
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
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                      
5089 262085 1 100 498X Burnett Ave 7 Sidewalk: Property side : Cutout Tree 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
15419 23925 1 100 1700X Webster St 7 Median : Cutout Tree 1     60 12x1   6003454.8844904 2114845.825423 37.7871586020093 -122.431838884639 (37.7871586020093, -122.431838884639) 13 9 11 29490 27
18517 19608 1 100 100 STAIRWAY5 7 Sidewalk: Curb side : Cutout Tree 1     12 30                      
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
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
154648 110701 4 100 2999X Turk St 7 Sidewalk: Property side : Cutout Tree 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
175552 234488 1 100 4090 20th St 7 : Yard Tree 2     16 Width 3ft   6003119.17834 2104176.3954 37.7578439389691 -122.432238089941 (37.7578439389691, -122.432238089941) 2 4 5 28862 3
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                      
3041 19585 1 100 100 STAIRWAY4 8 Sidewalk: Curb side : Cutout Tree 1     3 60                      
3448 19730 1 100 100 STAIRWAY14 8 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
13846 262084 1 100 498X Burnett Ave 8 Sidewalk: Property side : Cutout Tree 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
18480 19609 1 100 100 STAIRWAY5 8 Sidewalk: Curb side : Cutout Tree 1     6 30                      
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
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
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
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                      
668 19865 1 100 100 STAIRWAY30 9 Sidewalk: Curb side : Cutout Tree 1     24 100ST                      
6570 19989 1 100 100 STAIRWAY46 9 Sidewalk: Curb side : Cutout Tree 1     6 40                      
9459 19610 1 100 100 STAIRWAY5 9 Sidewalk: Curb side : Cutout Tree 1     12 30                      
11958 262083 1 100 498X Burnett Ave 9 Sidewalk: Property side : Cutout Tree 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
18475 19731 1 100 100 STAIRWAY14 9 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
60871 110703 4 100 2999X Turk St 9 Sidewalk: Property side : Cutout Tree 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 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
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
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