trees

Custom SQL query returning 34 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
149723 254437 1 6 1408 48th Ave 1 Sidewalk: Curb side : Cutout Tree 1 Private 04/06/2015 01:04:00 PM   3x3   5981264 2105479 37.7601571100533 -122.507917756824 (37.7601571100533, -122.507917756824) 1 8 3 56 35
152474 94162 7 6 1750 09th Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53533 5993469.4 2103573.4 37.7556364086322 -122.465566975178 (37.7556364086322, -122.465566975178) 1 8 4 56 12
152525 109744 1 6 4307 Kirkham St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/03/2015 12:00:00 AM 3 3x3 Permit Number 772150 5981459.9 2104819.9 37.7583589503944 -122.507191346523 (37.7583589503944, -122.507191346523) 1 8 3 56 35
152713 48663 7 6 1300 11th Ave 3 Sidewalk: Curb side : Cutout Tree 2 FUF 08/03/2002 12:00:00 AM     Permit Number 45949 5992726.08644889 2106595.37916826 37.7638910715093 -122.468357408335 (37.7638910715093, -122.468357408335) 1 8 11 56 12
156551 206986 1 6 1284 11th Ave 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 4ft   5992719.06604 2106665.13626 37.7640822005694 -122.468386764944 (37.7640822005694, -122.468386764944) 11 8 11 56 12
158383 206998 1 6 223 Kirkham St 2 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   5994252.21923 2105280.12164 37.7603677459862 -122.462983582339 (37.7603677459862, -122.462983582339) 1 5 4 56 12
158809 184688 1 6 1611 37th Ave 1 Sidewalk: Curb side : Yard Tree 2   01/03/2019 12:00:00 AM 3 Width 0ft Permit Number 782745 5984657.9281 2104207.7196 37.7568659135367 -122.496086155975 (37.7568659135367, -122.496086155975) 1 8 3 56 35
161367 182659 1 6 2252 Ortega St 2 Sidewalk: Curb side : Cutout Tree 2     1 Width 0ft   5986985.3742 2102363.8158 37.7519391046129 -122.487901613135 (37.7519391046129, -122.487901613135) 1 8 3 56 35
162961 69182 1 6 1371 45th Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/23/2008 12:00:00 AM 2 3x3 Permit Number 50160 5982122.5039 2105769.199 37.7610044592096 -122.504970155565 (37.7610044592096, -122.504970155565) 1 8 3 56 35
165167 95901 7 6 1700 23rd Ave 5 Sidewalk: Curb side : Cutout Tree 2 FUF 07/27/2011 12:00:00 AM   3x3 Permit Number 767603 5989092 2103686.6 37.7556937768723 -122.480713514054 (37.7556937768723, -122.480713514054) 1 8 3 56 35
167096 98557 1 6 3906 Judah St 4 Sidewalk: Curb side : Cutout Tree 1   09/07/2012 12:00:00 AM 3     5982438 2105598 37.7605529521075 -122.503866330302 (37.7605529521075, -122.503866330302) 1 8 3 56 35
167767 88087 7 6 1254 38th Ave   Sidewalk: Curb side : Cutout Tree 2   06/30/2008 12:00:00 AM   3x3 Permit Number 51087 5984334.6 2106629.9 37.7634975987144 -122.497383137852 (37.7634975987144, -122.497383137852) 1 8 3 56 35
168187 836 1 6 1396X 48th Ave 2 Sidewalk: Curb side : Cutout Tree 1   02/21/2017 10:52:00 AM 3 3X3   5981241.3128 2105622.3145 37.7605492737866 -122.508006856179 (37.7605492737866, -122.508006856179) 1 8 3 56 35
169035 47267 1 6 1386 24th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/09/2002 12:00:00 AM 1   Permit Number 45208 5988680.1995 2105896.4201 37.7617374028544 -122.48229953296 (37.7617374028544, -122.48229953296) 1 8 3 56 35
169137 98848 1 6 1795X 31st Ave 1 Sidewalk: Curb side : Cutout Tree 2   04/11/2012 12:00:00 AM   3x3 Permit Number 768753 5986486.2 2103095 37.7539176067687 -122.489681571094 (37.7539176067687, -122.489681571094) 1 8 3 56 35
169433 115802 1 6 1218 48th Ave 1 Sidewalk: Curb side : Cutout Tree 2   02/24/2016 12:00:00 AM 3 3x3 Permit Number 774518 5981226.5 2106751.9 37.7636499175412 -122.50814192749 (37.7636499175412, -122.50814192749) 1 8 3 56 35
172462 206985 1 6 1498 17th Ave 2 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   5990877.17813 2105275.09317 37.7601589539866 -122.474655794123 (37.7601589539866, -122.474655794123) 1 8 4 56 12
172804 31938 1 6 1335 47th Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/29/2008 12:00:00 AM 4 3x3 Permit Number 50210 5981495.7067 2105969.8095 37.761518381611 -122.507152818801 (37.761518381611, -122.507152818801) 1 8 3 56 35
175408 95911 1 6 1845 Kirkham St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/27/2011 12:00:00 AM 2 3x3 Permit Number 767612 5989071.1412 2105102.6181 37.7595805696676 -122.480889318141 (37.7595805696676, -122.480889318141) 1 8 3 56 35
176687 63095 1 6 1314 45th Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/04/2016 12:00:00 AM 1   Permit Number 775034 5982157.61974918 2106142.20642168 37.7620306969809 -122.504876348182 (37.7620306969809, -122.504876348182) 1 8 3 56 35
178343 46893 7 6 1383 11th Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 04/26/2002 12:00:00 AM     Permit Number 44948 5992692.47897134 2106059.86172468 37.7624187406256 -122.468434681685 (37.7624187406256, -122.468434681685) 1 8 11 56 12
178982 95429 1 6 1437 23rd Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/01/2011 12:00:00 AM 2 3x3 Permit Number 767294 5988962.2823 2105532.8441 37.760755525792 -122.481297307618 (37.760755525792, -122.481297307618) 1 8 3 56 35
181063 182513 1 6 1573 34th Ave 1 Sidewalk: Curb side : Yard Tree 2   03/23/2018 12:00:00 AM 3 Width 0ft Permit Number 777985 5985578.9968 2104511.5721 37.7577541150318 -122.492923184352 (37.7577541150318, -122.492923184352) 1 8 3 56 35
181692 182658 1 6 2242 Ortega St 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 0ft   5987004.6631 2102364.6195 37.7519424365087 -122.487834969288 (37.7519424365087, -122.487834969288) 1 8 3 56 35
182139 183687 1 6 1341 42nd Ave 1 Sidewalk: Curb side : Cutout Tree 2   05/05/2017 12:00:00 AM 3 Width 0ft Permit Number 33196 5983043.3769 2106010.2341 37.7617204082059 -122.501803142928 (37.7617204082059, -122.501803142928) 1 8 3 56 35
184192 113139 7 6 1799x 25TH AVE 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5988397 2103119 37.7540948807956 -122.483075414994 (37.7540948807956, -122.483075414994) 1 8 3 56 35
185808 183691 1 6 1341 42nd Ave 5 Sidewalk: Curb side : Cutout Tree 2   05/05/2017 12:00:00 AM 3 Width 0ft   5983046.4226 2105931.5142 37.7615044445987 -122.501786784798 (37.7615044445987, -122.501786784798) 1 8 3 56 35
186945 254438 1 6 1412 48th Ave 1 Sidewalk: Curb side : Cutout Tree 1 Private 04/06/2015 01:14:00 PM   3x3   5981265 2105453 37.7600857804311 -122.507912368787 (37.7600857804311, -122.507912368787) 1 8 3 56 35
187202 183640 1 6 1484 47th Ave 3 Sidewalk: Curb side : Yard Tree 2     3 Width 0ft   5981572.1323 2104991.2828 37.7588361283195 -122.506815916291 (37.7588361283195, -122.506815916291) 1 8 3 56 35
188586 69101 7 6 1672 12th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/17/2014 12:00:00 AM 3 3x3 Permit Number 773502 5992502.12347703 2104077.04435662 37.7569634473758 -122.468948742276 (37.7569634473758, -122.468948742276) 1 8 4 56 12
193090 184126 1 6 1643 32nd Ave 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 0ft   5986219.0266 2104040.7857 37.7564988729574 -122.490675089245 (37.7564988729574, -122.490675089245) 1 8 3 56 35
193269 95900 7 6 1700 23rd Ave 4 Sidewalk: Curb side : Cutout Tree 2 FUF 07/27/2011 12:00:00 AM   3x3 Permit Number 767603 5989092 2103686.6 37.7556937768723 -122.480713514054 (37.7556937768723, -122.480713514054) 1 8 3 56 35
193752 184292 1 6 1543 40th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   0 3x3   5983695 2104642 37.7580018774889 -122.499448359455 (37.7580018774889, -122.499448359455) 1 8 3 56 35
194395 183689 1 6 1351 42nd Ave 3 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   5983050 2105938 37.7615224629013 -122.501774892125 (37.7615224629013, -122.501774892125) 1 8 3 56 35