trees

Custom SQL query returning 20 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
121669 234075 1 36 1400 San Bruno Ave 6 Sidewalk: Curb side : Cutout Tree 4     14 Width 4ft   6011146.17896 2101629.85029 37.7513035456277 -122.404297986789 (37.7513035456277, -122.404297986789) 10 4 8 28859 19
11226 33101 1 300 450X Chestnut St 1 Sidewalk: Curb side : Cutout Tree 4 DPW 11/05/1996 12:00:00 AM 14   Permit Number 37341 6009682.3141 2120901.0273 37.804135754367 -122.410721035819 (37.804135754367, -122.410721035819) 3 1 10 308 23
11807 70932 1 16 250 23rd Ave 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   14     5988727.46903 2113517.26751 37.7826648905872 -122.482694534783 (37.7826648905872, -122.482694534783) 11 6 2 55 26
14144 75133 1 103 125 Excelsior Ave 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   14 4x4   6002899.19862 2092441.61812 37.7256104849218 -122.432160858845 (37.7256104849218, -122.432160858845) 9 7 6 28861 5
24577 99676 1 17 1250X Shrader St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   14 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
24846 99691 1 36 1550X Washington St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   14 3x3   6007274.7 2117123.2 37.7936275055362 -122.418784695641 (37.7936275055362, -122.418784695641) 5 1 10 28858 32
27553 97723 1 97 1000X Bay St 2 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency   14 7x57   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028) 5 1 1 28858 32
45359 96211 1 70 201X Diamond St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   14 4x4   6001762.6 2104666.8 37.759113460692 -122.436964804087 (37.759113460692, -122.436964804087) 2 4 5 28862 3
58278 75214 1 103 125 Excelsior Ave 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/08/1992 12:00:00 AM 14 4x5   6002868.59368 2092460.80856 37.7256614422973 -122.432268027453 (37.7256614422973, -122.432268027453) 9 7 6 28861 5
59231 97070 1 17 1551 Newcomb Ave 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   14 3x3   6015475.3 2095481.7 37.7346629526589 -122.388898077079 (37.7346629526589, -122.388898077079) 10 3 8 58 1
67880 77637 1 57 2X Yale St 13 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 10/26/1984 12:00:00 AM 14 4x4   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
79131 97722 1 97 1000X Bay St 1 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency   14 7x57   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028) 5 1 1 28858 32
98383 96212 1 70 201X Diamond St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   14 4x4   6001762.6 2104666.8 37.759113460692 -122.436964804087 (37.759113460692, -122.436964804087) 2 4 5 28862 3
119464 76771 1 9 200X Farallones St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
129428 76768 1 9 200X Farallones St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
140619 76757 1 9 200X Farallones St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
167189 97724 1 97 1000X Bay St 3 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency   14 7x82   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028) 5 1 1 28858 32
180726 77634 1 57 2X Yale St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 10/26/1984 12:00:00 AM 14 4x4   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
184196 122755 1 57 693 Vermont St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   14     6011274.22678 2105356.76628 37.7615439863765 -122.404117444276 (37.7615439863765, -122.404117444276) 10 3 8 28856 29
191029 95148 1 16 250 23rd Ave 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   14     5988724.77962 2113566.52719 37.7827999873072 -122.482707449869 (37.7827999873072, -122.482707449869) 11 6 2 55 26