trees

Custom SQL query returning 31 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
140065 117142 10 8 2203x NEWCOMB AVE 7 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
143699 117137 10 8 2203x NEWCOMB AVE 2 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
154253 117141 10 8 2203x NEWCOMB AVE 6 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
167623 117139 10 8 2203x NEWCOMB AVE 4 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
172332 117144 10 8 2203x NEWCOMB AVE 9 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
963 109935 10 11 260 05th St 4 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302 2112245.5 37.7804604268654 -122.404506314811 (37.7804604268654, -122.404506314811) 14 2 9 28853 34
12295 108536 10 11 1036X Mission St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6009831.24398 2112235.16984 37.7803497589148 -122.409593644194 (37.7803497589148, -122.409593644194) 14 2 9 28853 34
13217 109951 10 39 400x CLEMENTINA ST 11 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
23173 109936 10 11 260 05th St 5 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302 2112245.5 37.7804604268654 -122.404506314811 (37.7804604268654, -122.404506314811) 14 2 9 28853 34
23235 109950 10 39 400x CLEMENTINA ST 10 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
26043 100060 10 11 260 05th St 3 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435 2112345 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
41644 109948 10 39 400x CLEMENTINA ST 8 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
55082 108822 10 110 101x FREMONT ST 2 Sidewalk: Curb side : Cutout Tree 2       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258) 12 2 9 28855 6
62944 108821 10 110 101x FREMONT ST 1 Sidewalk: Curb side : Cutout Tree 2   01/06/2015 12:00:00 AM 3 5x5 Permit Number 774616 6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258) 12 2 9 28855 6
79198 112368 10 7 550 Jessie St 1 Sidewalk: Curb side : Cutout Tree 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
86051 109944 10 39 400x CLEMENTINA ST 4 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
86412 109945 10 39 400x CLEMENTINA ST 5 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
93470 109942 10 39 400x CLEMENTINA ST 2 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
93555 112370 10 7 550 Jessie St 3 Sidewalk: Curb side : Cutout Tree 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
98375 112371 10 7 550 Jessie St 4 Sidewalk: Curb side : Cutout Tree 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
102447 100059 10 11 260 05th St 2 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435 2112345 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
104613 89263 10 16 1 Polk St 2 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 775142 6007496.395175 2110885.881534 37.7765138277066 -122.41757533494 (37.7765138277066, -122.41757533494) 7 2 9 28852 36
108791 109943 10 39 400x CLEMENTINA ST 3 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
118512 109946 10 39 400x CLEMENTINA ST 6 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
138387 110499 10 149 900X JESSIE ST 1 Sidewalk: Curb side : Cutout Tree 2     2 3x3   6007667 2110717 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872) 8 2 9 28853 34
145260 109947 10 39 400x CLEMENTINA ST 7 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
148956 32654 10 11 260 05th St 1 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011426.1069309 2112339.71009356 37.7807260408269 -122.40408360027 (37.7807260408269, -122.40408360027) 14 2 9 28853 34
169504 112369 10 7 550 Jessie St 2 Sidewalk: Curb side : Cutout Tree 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
191841 109941 10 39 400x CLEMENTINA ST 1 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
192360 109949 10 39 400x CLEMENTINA ST 9 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
193590 108823 10 110 101x FREMONT ST 3 Sidewalk: Curb side : Cutout Tree 2       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258) 12 2 9 28855 6