trees

Custom SQL query returning 24 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
701 52560 1 133 1742 39th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/12/2006 12:00:00 AM 7   Permit Number 48656 5984113.6499 2103302.6049 37.7543488257224 -122.497901608629 (37.7543488257224, -122.497901608629) 1 8 3 56 35
1328 65972 1 133 2090 23rd Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/25/1990 12:00:00 AM 2   Permit Number 28996 5989155.2561 2101119.0911 37.7486477564753 -122.480306841406 (37.7486477564753, -122.480306841406) 1 8 3 29491 35
9249 183317 1 133 1209 41st Ave 2 Sidewalk: Curb side : Cutout Tree 2     3 Width 0ft   5983329.0993 2106834.4338 37.7640002060456 -122.500875914404 (37.7640002060456, -122.500875914404) 1 8 3 56 35
10338 31751 1 133 2546 21st Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 06/19/1995 12:00:00 AM 9   Permit Number 35238 5989883.0648 2098033.3774 37.7402174568148 -122.477564605136 (37.7402174568148, -122.477564605136) 1 8 3 29491 35
18348 98409 7 133 55 19th Ave 1 Sidewalk: Curb side : Tree 2           5990099.2 2106073.1 37.7623049568555 -122.477404745944 (37.7623049568555, -122.477404745944) 1 8 3 56 35
23516 50918 1 133 2477 21st Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/26/2004 12:00:00 AM 3   Permit Number 47420 5989820.2795 2098517.5722 37.7415432867093 -122.477817075256 (37.7415432867093, -122.477817075256) 1 8 3 29491 35
33901 183040 1 133 2562 21st Ave 2 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   5989885.4338 2097934.2198 37.739945333152 -122.477549168466 (37.739945333152, -122.477549168466) 1 8 3 29491 35
47724 184366 1 133 2295 28th Ave 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   5987606.9921 2099709.6419 37.7446876937291 -122.485557233352 (37.7446876937291, -122.485557233352) 1 8 3 29491 35
55272 95906 1 133 1323 28th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/27/2011 12:00:00 AM 2 3x3 Permit Number 767607 5987385.7768 2106255.5896 37.7626482044987 -122.486802739667 (37.7626482044987, -122.486802739667) 1 8 3 56 35
89550 65967 1 133 2562 21st Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/21/1990 12:00:00 AM 7   Permit Number 28991 5989886.449 2097917.9756 37.7399007896882 -122.477544471364 (37.7399007896882, -122.477544471364) 1 8 3 29491 35
104910 31750 1 133 2546 21st Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/19/1995 12:00:00 AM 5   Permit Number 35238 5989885.0953 2098017.81 37.7401748305885 -122.477556447005 (37.7401748305885, -122.477556447005) 1 8 3 29491 35
110106 63000 1 133 1251 42nd Ave 1 Sidewalk: Curb side : Cutout Tree 2   09/22/1986 12:00:00 AM 2   Permit Number 23408 5983028.2339 2106580.2336 37.7632845753318 -122.501897691969 (37.7632845753318, -122.501897691969) 1 8 3 56 35
110892 31752 1 133 2642 21st Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 06/19/1995 12:00:00 AM 7   Permit Number 35239 5989905.4007 2097381.577 37.7384290772799 -122.477439751256 (37.7384290772799, -122.477439751256) 1 8 3 29491 35
119747 38530 1 133 2550 31st Ave 1 Sidewalk: Curb side : Cutout Tree 2   09/16/1998 12:00:00 AM 3   Permit Number 40512 5986784.3655 2097886.9498 37.7396351026284 -122.48826775932 (37.7396351026284, -122.48826775932) 1 8 3 29491 35
123013 31753 1 133 2642 21st Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/19/1995 12:00:00 AM 6   Permit Number 35239 5989905.4007 2097364.9943 37.738383545459 -122.477438539611 (37.738383545459, -122.477438539611) 1 8 3 29491 35
123636 182596 1 133 945 Rivera St 3 Sidewalk: Curb side : Yard Tree 2     8 Width 0ft   5990197.9307 2100380.5725 37.7466805119975 -122.47664737489 (37.7466805119975, -122.47664737489) 1 8 3 29491 35
132897 61351 7 133 2435 41st Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/18/1994 12:00:00 AM     Permit Number 33180 5983606.72733818 2098575.39773775 37.7413394866654 -122.499305352528 (37.7413394866654, -122.499305352528) 1 8 3 29491 35
138408 82688 1 133 1875 38th Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/30/2008 12:00:00 AM 2 3x3 Permit Number 51093 5984404.185 2102433.03 37.7519782422196 -122.496832705614 (37.7519782422196, -122.496832705614) 1 8 3 56 35
144997 69148 7 133 2478 42nd Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/18/1994 12:00:00 AM     Permit Number 33183 5983358.82084368 2098279.8149921 37.7405133500226 -122.500140666527 (37.7405133500226, -122.500140666527) 1 8 3 29491 35
146470 63003 1 133 1239 42nd Ave 1 Sidewalk: Curb side : Cutout Tree 2   09/22/1986 12:00:00 AM 3   Permit Number 23411 5983024.3565 2106665.5091 37.763518489811 -122.501917412441 (37.763518489811, -122.501917412441) 1 8 3 56 35
168589 183679 1 133 3627 Irving St 2 Sidewalk: Curb side : Cutout Tree 2     3 Width 0ft   5984438.7811 2106305.4338 37.7626128114068 -122.496998863919 (37.7626128114068, -122.496998863919) 1 8 3 56 35
170107 95910 1 133 1863 32nd Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/27/2011 12:00:00 AM 2 3x3 Permit Number 767611 5986268.2408 2102571.6706 37.7524679589822 -122.490396818222 (37.7524679589822, -122.490396818222) 1 8 3 56 35
171037 182595 1 133 955 Rivera St 2 Sidewalk: Curb side : Yard Tree 2     8 Width 0ft   5990177.9035 2100379.6188 37.7466767317389 -122.4767165565 (37.7466767317389, -122.4767165565) 1 8 3 29491 35
179616 63086 1 133 1209 41st Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/25/1986 12:00:00 AM 3   Permit Number 23570 5983326.3714 2106866.623 37.7640884282736 -122.500887729919 (37.7640884282736, -122.500887729919) 1 8 3 56 35