trees

Custom SQL query returning 27 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
3024 103847 1 2 1529 Polk St 1 Sidewalk: Curb side : Pot Tree 1   08/21/2013 12:00:00 AM 3 3x3   6006640.1 2116184.7 37.7910148670423 -122.420913805894 (37.7910148670423, -122.420913805894) 13 9 10 28858 21
17740 96032 7 2 1314 Larkin St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767671 6007241 2115796 37.7899814452739 -122.418807131377 (37.7899814452739, -122.418807131377) 13 9 10 28858 21
20501 103817 7 2 1100 Polk St 3 Sidewalk: Curb side : Cutout Tree 2   11/01/2009 12:00:00 AM 3 3x3   6006925.9 2114751.5 37.7870957589339 -122.41982320605 (37.7870957589339, -122.41982320605) 13 9 10 28858 21
44915 103874 1 2 1331 Polk St 2 Sidewalk: Curb side : Cutout Tree 1   11/01/2009 12:00:00 AM 3 3x3   6006716.3 2115545.2 37.7892632533111 -122.42060474069 (37.7892632533111, -122.42060474069) 13 9 10 28858 21
50443 96012 7 2 999 California St 7 Sidewalk: Curb side : Cutout Tree 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767660 6009569 2116409 37.7917953978204 -122.410795730189 (37.7917953978204, -122.410795730189) 5 1 10 28857 21
53527 96014 7 2 999 California St 9 Sidewalk: Curb side : Cutout Tree 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767660 6009569 2116409 37.7917953978204 -122.410795730189 (37.7917953978204, -122.410795730189) 5 1 10 28857 21
53962 96013 7 2 999 California St 8 Sidewalk: Curb side : Cutout Tree 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767660 6009569 2116409 37.7917953978204 -122.410795730189 (37.7917953978204, -122.410795730189) 5 1 10 28857 21
57632 103843 1 2 1541 Polk St 1 Sidewalk: Curb side : Pot Tree 1   08/21/2013 12:00:00 AM 3 3x3   6006635.7 2116216.3 37.7911013847793 -122.420931274285 (37.7911013847793, -122.420931274285) 13 9 10 28858 21
82825 103844 1 2 1541 Polk St 2 Sidewalk: Curb side : Pot Tree 1   08/21/2013 12:00:00 AM 3 3x3   6006635.7 2116216.3 37.7911013847793 -122.420931274285 (37.7911013847793, -122.420931274285) 13 9 10 28858 21
89928 103848 1 2 1524 Polk St 1 Sidewalk: Curb side : Pot Tree 1   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042) 13 9 10 28858 21
93248 103851 1 2 1524 Polk St 4 Sidewalk: Curb side : Cutout Tree 2   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042) 13 9 10 28858 21
97816 103845 1 2 1540 Polk St 1 Sidewalk: Curb side : Pot Tree 1   08/21/2013 12:00:00 AM 3 3x3   6006747 2116248.1 37.7911949727431 -122.420548437624 (37.7911949727431, -122.420548437624) 13 9 10 28858 21
100917 103792 7 2 1214 Polk St 2 Sidewalk: Curb side : Cutout Tree 2   11/01/2009 12:00:00 AM 3 3x3   6006878.4 2115091.6 37.7880269138329 -122.420011690177 (37.7880269138329, -122.420011690177) 13 9 10 28858 21
105898 103793 7 2 1214 Polk St 3 Sidewalk: Curb side : Cutout Tree 2   11/01/2009 12:00:00 AM 3 3x3   6006878.4 2115091.6 37.7880269138329 -122.420011690177 (37.7880269138329, -122.420011690177) 13 9 10 28858 21
113636 103846 1 2 1540 Polk St 2 Sidewalk: Curb side : Pot Tree 1   08/21/2013 12:00:00 AM 3 3x3   6006747 2116248.1 37.7911949727431 -122.420548437624 (37.7911949727431, -122.420548437624) 13 9 10 28858 21
138526 103794 7 2 1214 Polk St 4 Sidewalk: Curb side : Cutout Tree 2   11/01/2009 12:00:00 AM 3 3x3   6006878.4 2115091.6 37.7880269138329 -122.420011690177 (37.7880269138329, -122.420011690177) 13 9 10 28858 21
146908 103849 1 2 1524 Polk St 2 Sidewalk: Curb side : Pot Tree 1   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042) 13 9 10 28858 21
158563 103862 1 2 1436 Polk St 2 Sidewalk: Curb side : Pot Tree 1   08/21/2013 12:00:00 AM 3 3x3   6006766.2 2115894.4 37.7902248822442 -122.420456889097 (37.7902248822442, -122.420456889097) 13 9 10 28858 21
161466 96015 7 2 999 California St 10 Sidewalk: Curb side : Cutout Tree 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767660 6009569 2116409 37.7917953978204 -122.410795730189 (37.7917953978204, -122.410795730189) 5 1 10 28857 21
172825 103850 1 2 1524 Polk St 3 Sidewalk: Curb side : Pot Tree 1   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042) 13 9 10 28858 21
188352 103791 7 2 1214 Polk St 1 Sidewalk: Curb side : Cutout Tree 2   11/01/2009 12:00:00 AM 3 3x3   6006878.4 2115091.6 37.7880269138329 -122.420011690177 (37.7880269138329, -122.420011690177) 13 9 10 28858 21
24900 13061 1 2 583 Lombard St 4 Sidewalk: Curb side : Cutout Tree 1   10/01/2013 12:00:00 AM 12 2X2   6009566.8887098 2120490.1657189 37.8030011583731 -122.411091436508 (37.8030011583731, -122.411091436508) 3 1 10 308 23
153966 98720 7 2 1500 Broadway 2 Sidewalk: Curb side : Cutout Tree 2   03/30/2012 12:00:00 AM   4x4 Permit Number 768751 6006413.8 2117997.6 37.795979878671 -122.421825625767 (37.795979878671, -122.421825625767) 13 9 10 28858 32
167714 98719 7 2 1500 Broadway 1 Sidewalk: Curb side : Cutout Tree 2   03/30/2012 12:00:00 AM     Permit Number 768751 6006413.8 2117997.6 37.795979878671 -122.421825625767 (37.795979878671, -122.421825625767) 13 9 10 28858 32
59261 83828 7 2 755-757 Green St 1 Sidewalk: Curb side : Cutout Tree 2   06/30/2009 12:00:00 AM     Permit Number 52235 6009406.96888923 2119078.72581504 37.7991167247732 -122.411545064383 (37.7991167247732, -122.411545064383) 3 1 10 308 4
85121 83826 7 2 755-757 Green St 3 Sidewalk: Curb side : Cutout Tree 2   06/30/2009 12:00:00 AM     Permit Number 52235 6009406.96888923 2119078.72581504 37.7991167247732 -122.411545064383 (37.7991167247732, -122.411545064383) 3 1 10 308 4
183348 83827 7 2 755-757 Green St 2 Sidewalk: Curb side : Cutout Tree 2   06/30/2009 12:00:00 AM     Permit Number 52235 6009406.96888923 2119078.72581504 37.7991167247732 -122.411545064383 (37.7991167247732, -122.411545064383) 3 1 10 308 4