trees

Custom SQL query returning 21 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
754 34739 7 65 581 Capp St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/28/1997 12:00:00 AM   3x3 Permit Number 38389 6007302.61875581 2103939.58827334 37.7574300317864 -122.417753185833 (37.7574300317864, -122.417753185833) 2 4 7 28859 19
21022 69205 7 65 2860 Harrison St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33254 6008952.43931379 2101803.50283851 37.7516575269948 -122.411896484829 (37.7516575269948, -122.411896484829) 2 4 7 28859 19
23336 63134 7 65 27 Winfield St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23649 6007447.90223159 2099378.78534919 37.7449152757931 -122.416927606356 (37.7449152757931, -122.416927606356) 2 7 7 28859 2
33290 63461 7 65 45 Powers Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/16/1987 12:00:00 AM     Permit Number 24052 6006867.21716204 2099801.68707108 37.7460437878528 -122.418965501899 (37.7460437878528, -122.418965501899) 2 7 7 28859 2
35130 63135 7 65 25 Winfield St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23650 6007455.65629161 2099393.17627053 37.7449552262088 -122.416901813576 (37.7449552262088, -122.416901813576) 2 7 7 28859 2
56987 63133 7 65 28 Winfield St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23648 6007400.02445462 2099399.55358264 37.7449696074565 -122.417094630618 (37.7449696074565, -122.417094630618) 2 7 7 28859 2
58635 63004 7 65 368 Highland Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/22/1986 12:00:00 AM 20 4x6 Permit Number 23414 6007279.07639479 2096499.56656681 37.7370000828457 -122.417307379598 (37.7370000828457, -122.417307379598) 2 7 7 28859 2
67823 103022 7 65 40X Coleridge St 3 Sidewalk: Curb side : Cutout Tree 2 FUF 03/15/2013 12:00:00 AM 3 3x3 Permit Number 770067 6006901 2099544.2 37.7453386886112 -122.418830426928 (37.7453386886112, -122.418830426928) 2 7 7 28859 2
69147 33484 7 65 300 Coleridge St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/25/1996 12:00:00 AM 30 6x6 Permit Number 37610 6006227.43678663 2098258.25526822 37.741769825751 -122.421068211473 (37.741769825751, -122.421068211473) 2 7 7 28859 2
74836 66622 7 65 867 Hampshire St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/15/1991 12:00:00 AM     Permit Number 29826 6010209.78585513 2104179.32451342 37.7582514640983 -122.407715901057 (37.7582514640983, -122.407715901057) 10 4 7 28859 19
76448 108926 7 65 36 Winfield St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772355 6007347.4 2099299.8 37.7446927459132 -122.417269529335 (37.7446927459132, -122.417269529335) 2 7 7 28859 2
93872 102475 7 65 581 Capp St 2 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 38389 6007298 2103932 37.7574089362149 -122.417768621509 (37.7574089362149, -122.417768621509) 2 4 7 28859 19
129447 63292 7 65 3075 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23858 6009183.06965006 2100534.27317896 37.7481854410784 -122.411009292537 (37.7481854410784, -122.411009292537) 2 4 7 28859 2
129894 69204 7 65 2850 Harrison St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33252 6008949.31851966 2101859.27420808 37.7518104876034 -122.411911217702 (37.7518104876034, -122.411911217702) 2 4 7 28859 19
130795 81299 7 65 109 Bartlett St 1 Sidewalk: Curb side : Cutout Tree 2   06/02/2008 12:00:00 AM 12 3x3 Permit Number 50541 6006708.25661782 2103139.88479614 37.7552007652727 -122.419751988993 (37.7552007652727, -122.419751988993) 2 4 7 28859 19
132523 115548 7 65 368 Highland Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF   20 4x6   6007279.07639479 2096499.56656681 37.7370000828457 -122.417307379598 (37.7370000828457, -122.417307379598) 2 7 7 28859 2
132571 63129 7 65 34 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23643 6007144.61352889 2099320.79872129 37.7447389927671 -122.417972215495 (37.7447389927671, -122.417972215495) 2 7 7 28859 2
142834 33539 7 65 253 BOCANA ST 1 Sidewalk: Curb side : Cutout Tree 2   08/06/2015 12:00:00 AM   4x4 Permit Number 775951 6007035 2097463 37.7396317225537 -122.418219548801 (37.7396317225537, -122.418219548801) 2 7 7 28859 2
150990 64607 7 65 2451 Folsom St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/18/1988 12:00:00 AM 20   Permit Number 25510 6008240.6573587 2104159.54552526 37.7580867271242 -122.414524628823 (37.7580867271242, -122.414524628823) 2 4 7 28859 19
167156 69206 7 65 2864 Harrison St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33255 6008953.68763074 2101781.1943032 37.7515963427841 -122.411890591701 (37.7515963427841, -122.411890591701) 2 4 7 28859 19
185506 63233 7 65 200x ESMERALDA AVE 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/13/1987 12:00:00 AM     Permit Number 23781 6007093 2098828 37.7433829729046 -122.41811575542 (37.7433829729046, -122.41811575542) 2 7 7 28859 2