trees

Custom SQL query returning 14 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
12193 31672 1 348 1435 Larkin St 2 Sidewalk: Curb side : Cutout Tree 2   06/12/1995 12:00:00 AM 5   Permit Number 35179 6007130.45469 2116245.44002 37.791209271644 -122.41922150408 (37.791209271644, -122.41922150408) 13 9 10 28858 21
18938 221280 1 348 970 Elizabeth St 1 Sidewalk: Curb side : Yard Tree 2     7 Width 4ft   6000248.03946 2101990.02339 37.7516774837438 -122.442010727629 (37.7516774837438, -122.442010727629) 2 4 5 28862 22
23308 188837 1 348 649 Delancey St 5 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   6015787.114 2113113.03855 37.7830921248442 -122.389050649695 (37.7830921248442, -122.389050649695) 6 2 9 28856 6
53937 94690 8 348 749 Congo St   Front Yard : Yard Tree 2   10/28/2010 12:00:00 AM     Permit Number 53820 6000274 2096023 37.735294937499 -122.441492809367 (37.735294937499, -122.441492809367) 9 7 4 63 40
72170 205638 1 348 280 Joost Ave 8 Sidewalk: Curb side : Cutout Tree 2     19 Width 7ft   6000134.27006 2094973.65767 37.73240572724 -122.44190061462 (37.73240572724, -122.44190061462) 9 7 5 63 40
89701 246303 1 348 3996 17th St 2 Sidewalk: Curb side : Pot Tree 2     2 Width 0ft   6002336.9866 2105888.8305 37.7625014908552 -122.435065705348 (37.7625014908552, -122.435065705348) 15 4 5 28862 3
97720 104310 9 348 3747 23RD ST 3 Sidewalk: Curb side : Cutout Tree 2     13 5x5   6004798 2102451 37.7532014528284 -122.426309178314 (37.7532014528284, -122.426309178314) 2 4 5 28862 22
99309 246304 1 348 3996 17th St 3 Sidewalk: Curb side : Pot Tree 2     2 Width 0ft   6002336.3946 2105898.3028 37.7625274658745 -122.435068430359 (37.7625274658745, -122.435068430359) 15 4 5 28862 3
118237 246302 1 348 3996 17th St 1 Sidewalk: Curb side : Pot Tree 2     3 Width 0ft   6002339.3547 2105882.3182 37.7624837441274 -122.43505704918 (37.7624837441274, -122.43505704918) 15 4 5 28862 3
122242 18553 1 348 1700X Quesada Ave 8 Median : Cutout Tree 1     30 19   6014639.83884 2095088.09279 37.7335358440919 -122.391759060533 (37.7335358440919, -122.391759060533) 10 3 8 58 1
137409 175570 1 348 204 Hester Ave 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 2ft   6012727.17549 2087673.11869 37.7130694668578 -122.397851778545 (37.7130694668578, -122.397851778545) 10 3 8 309 1
146286 47251 1 348 971 Le Conte Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/09/2002 12:00:00 AM 6   Permit Number 45194 6013290.77748 2089430.96828 37.7179275452075 -122.396026878752 (37.7179275452075, -122.396026878752) 10 3 8 58 1
148236 53621 7 348 4322 25th St 1 Sidewalk: Curb side : Cutout Tree 2   10/02/2008 12:00:00 AM   3x3 Permit Number 51775 6001775.98851578 2101202.25628885 37.7496014166195 -122.436670506222 (37.7496014166195, -122.436670506222) 2 4 5 28862 22
151870 84879 1 348 2042 Grove St 1 Sidewalk: Curb side : Cutout Tree 2   03/20/2007 12:00:00 AM 2   Permit No. 49242 5998038.6133 2110322.1176 37.7744291581359 -122.450251713519 (37.7744291581359, -122.450251713519) 15 5 11 29492 16