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)
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
54759 102523 10 37 2192 Funston Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/29/2013 12:00:00 AM   3X3 Permit Number 769544 5992300.8 2100554.8 37.7472806432819 -122.469388612726 (37.7472806432819, -122.469388612726) 1 8 4 29491 40
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
117249 110651 10 16 127 CENTRAL AVE 1 Sidewalk: Curb side : Cutout Tree 2     1 3x3   5999845 2108967 37.770811558248 -122.44390571749 (37.770811558248, -122.44390571749) 15 5 11 29492 9
56667 103097 10 483 1199X Pacific Ave 1 Sidewalk: Curb side : Cutout Tree 2   03/20/2013 12:00:00 AM   3x3 Permit Number 768649 6008392.3 2117900.9 37.7958257402639 -122.414972764224 (37.7958257402639, -122.414972764224) 5 1 10 308 21
23848 114246 10 19 54 COMMONWEALTH AVE 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5996571 2114184 37.7849487713586 -122.455607632252 (37.7849487713586, -122.455607632252) 11 6 1 54 31
6326 117138 10 8 2203x NEWCOMB AVE 3 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
55582 117143 10 8 2203x NEWCOMB AVE 8 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
90738 117140 10 8 2203x NEWCOMB AVE 5 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
114728 117145 10 8 2203x NEWCOMB AVE 10 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
126441 117136 10 8 2203x NEWCOMB AVE 1 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
132994 117150 10 8 928 TOLAND ST 5 Front Yard : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011950 2098029 37.7414612698949 -122.401265252936 (37.7414612698949, -122.401265252936) 10 3 8 58 1
140065 117142 10 8 2203x NEWCOMB AVE 7 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
143699 117137 10 8 2203x NEWCOMB AVE 2 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
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
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
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
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
67384 112573 10 13 56 ROCKWOOD CT 1 Sidewalk: Curb side : Cutout Tree 2   12/31/2015 12:00:00 AM   3x6 Permit Number 776002 5995685 2098946 37.7430582687021 -122.457569991387 (37.7430582687021, -122.457569991387) 1 8 4 59 40
90728 113796 10 163 331 TERESITA BLVD 2 Hanging basket : Cutout Tree 2       3x3   5997873 2098382 37.7416351035083 -122.449963874894 (37.7416351035083, -122.449963874894) 9 7 4 59 40
102643 98306 10 40 155 Terrace Dr   Sidewalk: Curb side : Cutout Tree 2           5993776 2096639 37.7366139805049 -122.464003314893 (37.7366139805049, -122.464003314893) 1 8 4 59 40
144718 112574 10 13 56 ROCKWOOD CT 2 Sidewalk: Curb side : Cutout Tree 2   12/31/2015 12:00:00 AM   3x6 Permit Number 776002 5995685 2098946 37.7430582687021 -122.457569991387 (37.7430582687021, -122.457569991387) 1 8 4 59 40
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
33280 110797 10 146 440 29th St 1 Sidewalk: Curb side : Cutout Tree 2   05/06/2015 12:00:00 AM 3     6003697.7 2098979.2 37.7436064433062 -122.429866615733 (37.7436064433062, -122.429866615733) 2 7 5 63 22
42158 43568 10 22 601 29TH ST 2 Sidewalk: Curb side : Cutout Tree 2   07/20/2000 12:00:00 AM     Permit Number 43230 6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7
67230 107533 10 17 130 MATEO ST 1 Sidewalk: Curb side : Cutout Tree 2   02/05/2015 12:00:00 AM 3 3x3 Permit Number 774373 6003821.3 2096389.2 37.7365018950939 -122.429254591879 (37.7365018950939, -122.429254591879) 2 7 5 63 7
107804 112688 10 8 259 BRIGHT ST 1 Sidewalk: Curb side : Cutout Tree 2   08/18/2015 12:00:00 AM 3 5x4   5993720 2088919 37.71541351482 -122.4636368036 (37.71541351482, -122.4636368036) 9 8 6 64 24