trees

Custom SQL query returning 18 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1622 78494 1 50 2131 24th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   5     6012056.35315 2102319.00627 37.7532466361332 -122.401198904113 (37.7532466361332, -122.401198904113) 10 3 8 28856 29
13967 84622 1 50 382 Texas St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   5     6013742.24361 2105343.88141 37.761646197043 -122.395580621644 (37.761646197043, -122.395580621644) 10 3 8 28856 29
14099 38381 1 50 1464 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/17/2005 12:00:00 AM 5   Permit Number 48279 6011990.10357 2101552.61207 37.7511385883967 -122.401374155011 (37.7511385883967, -122.401374155011) 10 3 8 28856 29
18290 229761 1 50 1201 Vermont St 31 Sidewalk: Property side : Yard Tree 2     5 Width 4ft   6011456.4035 2102287.48645 37.7531266009123 -122.403271446634 (37.7531266009123, -122.403271446634) 10 4 8 28859 19
29512 190708 1 50 2033 22nd St 4 : Tree 2     5 Width 3ft   6011986.6004 2103715.0173 37.7570758846471 -122.401538231824 (37.7570758846471, -122.401538231824) 10 3 8 28856 29
31469 78725 1 50 1300 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree 2   06/22/2010 12:00:00 AM 5 3x3 Permit Number 53574 6011951.34663 2102291.29231 37.7531646809082 -122.401560092537 (37.7531646809082, -122.401560092537) 10 3 8 28856 29
34108 190689 1 50 1001 Minnesota St 1 Sidewalk: Curb side : Yard Tree 2     5 Width 4ft   6015296.26829 2103832.96006 37.7575838496448 -122.390100279027 (37.7575838496448, -122.390100279027) 10 3 8 28856 29
41300 229766 1 50 1201 Vermont St 36 Sidewalk: Property side : Yard Tree 2     5 Width 4ft   6011452.91917 2102390.65584 37.7534096868171 -122.403290753279 (37.7534096868171, -122.403290753279) 10 4 8 28859 19
45524 67540 1 50 619 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/05/1992 12:00:00 AM 5   Permit Number 31080 6012728.40675 2104463.00984 37.7591710721042 -122.399025265205 (37.7591710721042, -122.399025265205) 10 3 8 28856 29
90656 190704 1 50 1446 Kansas St 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 5ft   6011711.12531 2101607.11223 37.7512726647182 -122.402342728461 (37.7512726647182, -122.402342728461) 10 3 8 28856 29
92812 229776 1 50 1201 Vermont St 46 Sidewalk: Property side : Yard Tree 2     5 Width 4ft   6011441.50409 2102586.88485 37.7539478510307 -122.40334403271 (37.7539478510307, -122.40334403271) 10 4 8 28859 19
118901 37938 1 50 1833 19th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/08/1998 12:00:00 AM 5   Permit Number 40182 6012201.79932 2105128.09339 37.7609678851705 -122.400893265015 (37.7609678851705, -122.400893265015) 10 3 8 28856 29
121410 52722 1 50 1115 Kansas St 1 Sidewalk: Curb side : Cutout Tree 2   04/18/2006 12:00:00 AM 5   Permit Number 48775 6011675.49817 2103219.4484 37.7556977977188 -122.402579300492 (37.7556977977188, -122.402579300492) 10 3 8 28856 29
161520 41430 1 50 514 Connecticut St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 03/29/2018 12:00:00 AM 5   Permit Number 43060 6013229.56642 2104526.4373 37.7593731443828 -122.397296450777 (37.7593731443828, -122.397296450777) 10 3 8 28856 29
165791 229757 1 50 1201 Vermont St 26 Sidewalk: Property side : Yard Tree 2     5 Width 4ft   6011461.99954 2102213.77594 37.752924520553 -122.403246909533 (37.752924520553, -122.403246909533) 10 4 8 28859 19
174641 67525 1 50 1237 19th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/22/1992 12:00:00 AM 5   Permit Number 31063 6013863.96904 2105222.10332 37.7613185911004 -122.395151089252 (37.7613185911004, -122.395151089252) 10 3 8 28856 29
175462 196543 1 50 975 De Haro St 2 Sidewalk: Curb side : Cutout Tree 1   03/29/2018 12:00:00 AM 5 Width 3ft   6012204.60388 2103877.56611 37.7575343698359 -122.400795707451 (37.7575343698359, -122.400795707451) 10 3 8 28856 29
179676 38602 1 50 1556 Revere Ave 2 Sidewalk: Curb side : Cutout Tree 2   06/02/2008 12:00:00 AM 5 3x3 Permit Number 50557 6015367.191 2094226.978 37.7312117463081 -122.389184266735 (37.7312117463081, -122.389184266735) 10 3 8 58 1