trees

Custom SQL query returning 26 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
59242 135671 1 296 701 Buchanan St 1 Sidewalk: Curb side : Yard Tree 2     4 Width 6ft   6004478.12377 2110899.33168 37.7763804610255 -122.428017362009 (37.7763804610255, -122.428017362009) 7 9 11 28852 10
148599 138956 1 296 723 Buchanan St 5 Sidewalk: Curb side : Cutout Tree 2     1 Width 0ft   6004478.9225 2110904.2582 37.776394033229 -122.428014950126 (37.776394033229, -122.428014950126) 7 9 11 28852 10
39825 196058 1 296 2301 19th St 1 Sidewalk: Property side : Yard Tree 2     6     6010884.66338 2105058.48135 37.7607031886221 -122.405443783305 (37.7607031886221, -122.405443783305) 10 3 8 28856 29
96787 196057 1 296 578 San Bruno Ave 5 Sidewalk: Curb side : Yard Tree 2     9 Width 4ft   6010921.38174 2105592.13415 37.7621705323591 -122.40535437273 (37.7621705323591, -122.40535437273) 8 3 8 28856 29
150484 196060 1 296 955 Kansas St 1 Front Yard : Yard Tree 2     4     6011632.64941 2103950.51096 37.757702741818 -122.402778897843 (37.757702741818, -122.402778897843) 10 3 8 28856 29
170502 196059 1 296 582 Rhode Island St 10 Sidewalk: Property side : Yard Tree 2     2     6011759.57915 2105642.68997 37.7623561758285 -122.402458905576 (37.7623561758285, -122.402458905576) 8 3 8 28856 29
164818 234913 1 296 277 Bartlett St 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6006752.15418 2102195.66936 37.7526106391832 -122.419533192001 (37.7526106391832, -122.419533192001) 2 4 7 28859 19
15559 178691 1 296 549 Cordova St 1 Sidewalk: Curb side : Yard Tree 2     4 Width 8ft   6002129.66344 2086422.57937 37.709039879958 -122.434390930201 (37.709039879958, -122.434390930201) 9 7 6 28861 5
155102 178692 1 296 549 Cordova St 2 Sidewalk: Curb side : Yard Tree 2     4 Width 8ft   6002131.76754 2086425.47642 37.7090479540599 -122.434383865118 (37.7090479540599, -122.434383865118) 9 7 6 28861 5
162423 178693 1 296 549 Cordova St 3 Sidewalk: Curb side : Yard Tree 2     4 Width 8ft   6002128.86761 2086428.02428 37.7090547853188 -122.434394069733 (37.7090547853188, -122.434394069733) 9 7 6 28861 5
183401 234914 1 296 2 Vicksburg St 2 Sidewalk: Curb side : Cutout Tree 2     6 Width 5ft   6004059.29219 2103001.00468 37.7546698528419 -122.428902987393 (37.7546698528419, -122.428902987393) 2 4 5 28862 22
82473 142050 1 296 32 ATALAYA TER 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 0ft   5998847.8737 2110957.7576 37.776220741334 -122.447498103076 (37.776220741334, -122.447498103076) 15 6 2 29492 16
79574 117870 1 296 850 40th Ave 2 Sidewalk: Curb side : Yard Tree 2     8 Width 4ft   5983580.45743 2110020.85288 37.7727639566416 -122.500242142011 (37.7727639566416, -122.500242142011) 11 6 2 55 26
167812 117742 1 296 475 39th Ave 4 Sidewalk: Curb side : Yard Tree 2     3 Width 4ft   5983747.94106 2112662.50958 37.7800270099537 -122.499858102338 (37.7800270099537, -122.499858102338) 11 6 2 55 26
17240 202089 1 296 1 Gould St 17 Sidewalk: Curb side : Yard Tree 2     5     6012847.10312 2091145.29083 37.7226100354079 -122.397680651962 (37.7226100354079, -122.397680651962) 10 3 8 58 1
101697 255715 4 296 937x Meade Ave 1 Front Yard : Yard Tree 2       3x3   6012763 2089349 37.7176730984513 -122.397845439416 (37.7176730984513, -122.397845439416) 10 3 8 58 1
154830 196061 1 296 2330 Lane St 4 Front Yard : Yard Tree 2     3     6013950.20438 2092923.64002 37.7275543902 -122.393991875717 (37.7275543902, -122.393991875717) 10 3 8 58 1
182726 212852 1 296 613 Detroit St 1 Sidewalk: Property side : Yard Tree 2     5 Width 10ft   5999415.15878 2095029.40033 37.732517780054 -122.444390746543 (37.732517780054, -122.444390746543) 9 7 4 59 40
6094 212854 1 296 383 Joost Ave 1 Sidewalk: Property side : Yard Tree 2     3 Width 10ft   5999561.12695 2094940.87947 37.7322830498256 -122.443879743667 (37.7322830498256, -122.443879743667) 9 7 4 63 40
56004 212857 1 296 326 Detroit St 6 Sidewalk: Property side : Yard Tree 2     1 Width 7ft   5999454.72629 2094321.91638 37.7305774522885 -122.444203131795 (37.7305774522885, -122.444203131795) 9 7 4 63 40
73838 212853 1 296 162 Mangels Ave 3 Sidewalk: Property side : Yard Tree 2     6 Width 10ft   6000336.93073 2095252.91733 37.7331840553884 -122.441220000514 (37.7331840553884, -122.441220000514) 9 7 5 63 40
80279 212858 1 296 326 Detroit St 7 Sidewalk: Property side : Yard Tree 2     2 Width 7ft   5999452.2625 2094329.12509 37.73059710516 -122.444212167269 (37.73059710516, -122.444212167269) 9 7 4 63 40
102178 212856 1 296 326 Detroit St 5 Sidewalk: Property side : Yard Tree 2     2 Width 7ft   5999450.88098 2094315.05558 37.7305583947567 -122.444215932735 (37.7305583947567, -122.444215932735) 9 7 4 63 40
153656 212855 1 296 326 Detroit St 3 Sidewalk: Property side : Yard Tree 2     1 Width 7ft   5999451.80031 2094287.65002 37.7304831979422 -122.4442107859 (37.7304831979422, -122.4442107859) 9 7 4 63 40
164583 234915 1 296 127 Farnum St 1 Sidewalk: Property side : Yard Tree 2     2 Width 3ft   6002448.02484 2097346.2472 37.7390518862338 -122.434070974792 (37.7390518862338, -122.434070974792) 2 7 5 63 7
105349 114158 6 296 1200X JUNIPERO SERRA BLVD 6 Front Yard : Yard Tree 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14