trees

Custom SQL query returning 31 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
153338 113795 10 58 331 TERESITA BLVD 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5997873 2098382 37.7416351035083 -122.449963874894 (37.7416351035083, -122.449963874894) 9 7 4 59 40
154253 117141 10 8 2203x NEWCOMB AVE 6 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
157435 113601 10 9 550 FLORIDA ST 2 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3 Permit Number 773946 6009233 2105681 37.7623199946126 -122.411200142124 (37.7623199946126, -122.411200142124) 8 4 7 28859 19
160668 72837 10 182 2624 21st St 1 Sidewalk: Curb side : Cutout Tree 2   05/06/2015 12:00:00 AM 3 3x3 Permit Number 770762 6010331.33933918 2104014.11752446 37.7578046465334 -122.407283867997 (37.7578046465334, -122.407283867997) 10 4 7 28859 19
163668 113604 10 9 2900 18TH ST 2 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
167623 117139 10 8 2203x NEWCOMB AVE 4 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
168085 118341 10 11 1 Franklin St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6006507 2110162 37.7744705012603 -122.420946535292 (37.7744705012603, -122.420946535292) 7 9 11 28852 10
169034 103467 10 33 890X Sansome St 3 Sidewalk: Curb side : Cutout Tree 2           6012118 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264) 3 1 10 28860 6
169504 112369 10 7 550 Jessie St 2 Sidewalk: Curb side : Cutout Tree 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
170467 85453 10 17 271 Guerrero St 1 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
172332 117144 10 8 2203x NEWCOMB AVE 9 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
181612 113609 10 9 2900 18TH ST 7 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
182184 109118 10 22 2036x 15TH ST 4 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
183384 70518 10 84 27 Edinburg St 1 Sidewalk: Curb side : Cutout Tree 2   06/25/1994 12:00:00 AM   3x3 Permit Number 775094 6004529.42153392 2093371.60291271 37.7282563119694 -122.426591501924 (37.7282563119694, -122.426591501924) 9 7 6 28861 5
184745 101925 10 39 1099X Hyde St 2 Sidewalk: Curb side : Cutout Tree 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639 2116135.7 37.7909365792809 -122.417454166812 (37.7909365792809, -122.417454166812) 13 1 10 28858 21
186791 118339 10 14 2 Page St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6006507 2110162 37.7744705012603 -122.420946535292 (37.7744705012603, -122.420946535292) 7 9 11 28852 10
188204 101924 10 39 1099X Hyde St 1 Sidewalk: Curb side : Cutout Tree 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639 2116135.7 37.7909365792809 -122.417454166812 (37.7909365792809, -122.417454166812) 13 1 10 28858 21
189972 17872 10 49 2148 Pine St 2 Sidewalk: Curb side : Cutout Tree 1 Private 07/21/2010 12:00:00 AM 0 3X3 Permit Number 53638 6003654.7045158 2115269.5781823 37.7883334451781 -122.431177809024 (37.7883334451781, -122.431177809024) 13 9 1 29490 27
191841 109941 10 39 400x CLEMENTINA ST 1 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
192360 109949 10 39 400x CLEMENTINA ST 9 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
193056 113612 10 9 595 ALABAMA ST 3 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009000 2105472 37.7617330585457 -122.411991234579 (37.7617330585457, -122.411991234579) 8 4 7 28859 19
193590 108823 10 110 101x FREMONT ST 3 Sidewalk: Curb side : Cutout Tree 2       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258) 12 2 9 28855 6
41654 112585 10 6 3400x WAWONA ST 6 Sidewalk: Property side : Cutout Tree 2       4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
46414 112583 10 6 3400x WAWONA ST 1 Sidewalk: Property side : Cutout Tree 2     1 4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
132551 112584 10 6 3400x WAWONA ST 5 Sidewalk: Property side : Cutout Tree 2       4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
147556 112586 10 6 3400x WAWONA ST 7 Sidewalk: Property side : Cutout Tree 2       4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
43048 98285 10 136 300 Mangels Ave 1 Sidewalk: Property side : Yard Tree 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
54018 98287 10 136 300 Mangels Ave 3 Sidewalk: Property side : Yard Tree 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
54581 98286 10 136 300 Mangels Ave 2 Sidewalk: Property side : Yard Tree 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
84488 112892 10 373 1X WEBSTER ST 4 Sidewalk: Property side : Yard Tree 2       3x3   6004219 2108568 37.7699645303419 -122.428747509741 (37.7699645303419, -122.428747509741) 7 9 5 28862 10
103216 112891 10 373 1X WEBSTER ST 3 Sidewalk: Property side : Yard Tree 2       3x3   6004219 2108568 37.7699645303419 -122.428747509741 (37.7699645303419, -122.428747509741) 7 9 5 28862 10