trees

Custom SQL query returning 14 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
29272 129388 1 6 2507 Larkin St 5 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6006666.99925 2119949.93729 37.8013547799481 -122.421088199869 (37.8013547799481, -122.421088199869) 5 9 1 28858 32
42678 87855 7 6 2537 Larkin St 1 Sidewalk: Curb side : Cutout Tree 2   11/06/2008 12:00:00 AM   3x3 Permit Number 50783 6006632 2119882 37.8011662683494 -122.421204486113 (37.8011662683494, -122.421204486113) 5 9 1 28858 32
49974 73594 1 6 780 Post St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/12/2014 12:00:00 AM 3   Permit Number 772812 6008453.79298 2114896.74793 37.7875805296608 -122.414547298434 (37.7875805296608, -122.414547298434) 5 1 10 28858 21
63396 129389 1 6 2507 Larkin St 7 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6006655.24817 2120043.69212 37.8016115444852 -122.421135524881 (37.8016115444852, -122.421135524881) 5 9 1 28858 32
67418 255648 7 6 2834 Polk St   Sidewalk: Curb side : Cutout Tree 2 FUF 06/21/2018 12:00:00 AM 3 3x3 Permit Number 779253 6006100.90264 2120497.78973 37.8028271147622 -122.423086110708 (37.8028271147622, -122.423086110708) 5 9 1 28858 32
74064 42693 7 6 2500 Larkin St 3 Sidewalk: Curb side : Cutout Tree 2   06/26/2000 12:00:00 AM 3 3x3 Permit Number 42711 6006694.5506046 2119774.0082852 37.8008732765742 -122.420980361587 (37.8008732765742, -122.420980361587) 5 9 1 28858 32
92442 129379 1 6 1765 Jackson St 3 Sidewalk: Curb side : Cutout Tree 2     3 Width 4ft   6005697.11148 2117184.40611 37.793706610722 -122.424247645012 (37.793706610722, -122.424247645012) 13 9 1 28858 27
102379 84816 1 6 736 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 2   11/13/2009 12:00:00 AM 4 3x3 Permit Number 53031 6008319.93046 2115035.61847 37.7879543130824 -122.415020270782 (37.7879543130824, -122.415020270782) 5 1 10 28858 21
131191 71549 1 6 780 Post St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 08/18/2015 12:00:00 AM 3 3x3 Permit Number 772812 6008431.05429 2114892.38013 37.7875672592553 -122.414625660841 (37.7875672592553, -122.414625660841) 5 1 10 28858 21
142268 129380 1 6 730 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 4ft   6008321.92773 2115014.63424 37.7878968077251 -122.415011874722 (37.7878968077251, -122.415011874722) 5 1 10 28858 21
146089 52362 1 6 1438ASHINGTON Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/14/2005 12:00:00 AM 9   Permit Number 48498 6007994.93646 2117377.76116 37.7943669936906 -122.416310648633 (37.7943669936906, -122.416310648633) 5 1 10 28858 21
158967 79726 7 6 780 Post St 1 Sidewalk: Curb side : Cutout Tree 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50955 6008416.19534554 2114892.53002417 37.7875668360064 -122.414677080613 (37.7875668360064, -122.414677080613) 5 1 10 28858 21
179565 129387 1 6 2507 Larkin St 2 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6006679.63776 2119843.90732 37.8010643609816 -122.421036932226 (37.8010643609816, -122.421036932226) 5 9 1 28858 32
188002 88645 7 6 2500x Larkin St   Sidewalk: Curb side : Cutout Tree 2   08/05/2008 12:00:00 AM   3x3 Permit Number 51618 6006882.7 2119972.1 37.8014277902223 -122.420343352043 (37.8014277902223, -122.420343352043) 5 1 1 28858 32