trees

Custom SQL query returning 41 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
11200 4249 2 36 4043 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree 2   04/05/1995 12:00:00 AM 12 4x4   6003613.964 2100376.48243 37.7474383143284 -122.430255820476 (37.7474383143284, -122.430255820476) 2 4 5 63 22
11885 157920 2 14 4147 26th St 1 Sidewalk: Curb side : Cutout Tree 2   08/23/2019 12:00:00 AM 3 3x3 Permit Number 777832 6002961.17206 2100636.31842 37.7481147664022 -122.432531686182 (37.7481147664022, -122.432531686182) 2 4 5 63 22
18063 259659 2 1 4061 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree 2   07/29/2019 12:00:00 AM 3 3x3 Permit Number 784440 6003514 2100377 37.7474340728524 -122.430601526112 (37.7474340728524, -122.430601526112) 2 4 5 63 22
91584 157471 2 36 844 Duncan St 1 Sidewalk: Curb side : Cutout Tree 2   08/22/2018 12:00:00 AM 3 3x3   6001109 2099712 37.7454716006778 -122.438870189158 (37.7454716006778, -122.438870189158) 2 4 5 63 22
152110 239088 2 44 3855 26th St 1 Sidewalk: Curb side : Cutout Tree 1     13 3x3 Permit Number 780732 6004794.15723 2100737.40071 37.748496089722 -122.426200479689 (37.748496089722, -122.426200479689) 2 4 5 63 22
172284 256143 2 14 4068 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree 2   09/17/2018 12:00:00 AM 3 3x3   6003463 2100411 37.7475245395629 -122.430780306583 (37.7475245395629, -122.430780306583) 2 4 5 63 22
8622 256682 2 36 330 Twin Peaks Blvd 8 Front Yard : Yard Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
19663 256686 2 385 330 Twin Peaks Blvd 11 Back Yard : Yard Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
23587 256680 2 36 330 Twin Peaks Blvd 6 Front Yard : Yard Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
28167 256679 2 26 330 Twin Peaks Blvd 5 Sidewalk: Curb side : Cutout Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
32624 258085 2 385 330 Twin Peaks Blvd 12 Sidewalk: Property side : Yard Tree 2   03/27/2019 12:00:00 AM 3 10x10   5998725.10706 2103975.38052 37.7570418811558 -122.447420092492 (37.7570418811558, -122.447420092492) 15 5 4 63 38
75229 256683 2 385 330 Twin Peaks Blvd 1 Back Yard : Yard Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
75947 256676 2 26 330 Twin Peaks Blvd 1 Sidewalk: Curb side : Cutout Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
78128 256675 2 146 330 Twin Peaks Blvd 3 Side Yard : Cutout Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
123272 256677 2 26 330 Twin Peaks Blvd 2 Sidewalk: Curb side : Cutout Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
127405 256685 2 385 330 Twin Peaks Blvd 10 Back Yard : Yard Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
130529 256674 2 385 330 Twin Peaks Blvd 2 Side Yard : Cutout Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
158426 256673 2 385 330 Twin Peaks Blvd 1 Side Yard : Cutout Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
161826 256678 2 26 330 Twin Peaks Blvd 4 Sidewalk: Curb side : Cutout Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
176698 256681 2 36 330 Twin Peaks Blvd 7 Front Yard : Yard Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
185964 256684 2 385 330 Twin Peaks Blvd 9 Back Yard : Yard Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
2678 157809 2 14 647 Duncan St 1 Sidewalk: Curb side : Cutout Tree 2   11/06/2019 12:00:00 AM 3 3x3 Permit Number 781831 6002443.37703 2099727.28553 37.7455893990301 -122.4342572226 (37.7455893990301, -122.4342572226) 2 7 5 63 22
3850 262121 2 48 296x Day St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6004047 2098716 37.7429035313116 -122.428640063872 (37.7429035313116, -122.428640063872) 2 7 5 63 22
5173 169519 2 9 1753 Noe St 1 Front Yard : Yard Tree 2     0 8x8 Permit Number 779099 6003417.91334 2098032.77345 37.7409919262491 -122.430766523865 (37.7409919262491, -122.430766523865) 2 7 5 63 7
7182 262122 2 48 296x Day St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6004047 2098716 37.7429035313116 -122.428640063872 (37.7429035313116, -122.428640063872) 2 7 5 63 22
15356 251313 2 13 390 28th St 1 Sidewalk: Curb side : Cutout Tree 2   08/20/2019 12:00:00 AM 3 4x4 Permit Number 779703 6003369 2099547 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183) 2 7 5 63 22
18657 251312 2 13 1499 Noe St 1 Sidewalk: Curb side : Cutout Tree 2   08/20/2019 12:00:00 AM 3 4x4 Permit Number 779703 6003369 2099547 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183) 2 7 5 63 22
27355 239457 2 40 165 Sussex St 2 Sidewalk: Curb side : Cutout Tree 1   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001959.66963 2096487.1672 37.7366653238346 -122.435698035437 (37.7366653238346, -122.435698035437) 2 7 5 63 7
51236 243740 2 51 550 Laidley St 1 Sidewalk: Curb side : Cutout Tree 2   11/15/2017 12:00:00 AM 3 3x3 Permit Number 776473 6003047.05577 2096015.80768 37.7354327831918 -122.431904827248 (37.7354327831918, -122.431904827248) 2 7 5 63 7
90355 222216 2 67 2 Van Buren St 1 Sidewalk: Curb side : Cutout Tree 1     10 Width 3ft Permit Number 780743 6002014.89564 2096488.79408 37.7366729276156 -122.435507211887 (37.7366729276156, -122.435507211887) 2 7 5 63 7
108115 242845 2 22 1559 Church St 1 Sidewalk: Curb side : Cutout Tree 2   07/18/2018 12:00:00 AM 3 3x3   6004609.7731 2099770.4554 37.7458306574531 -122.426769226215 (37.7458306574531, -122.426769226215) 2 7 5 63 22
112660 169518 2 11 1783 Noe St 1 Front Yard : Yard Tree 2   05/01/2018 12:00:00 AM 3 3x3 Permit Number 780948 6003426.12868 2097901.04069 37.7406306838602 -122.430728719953 (37.7406306838602, -122.430728719953) 2 7 5 63 7
115391 224618 2 97 165 Sussex St 1 Sidewalk: Curb side : Cutout Tree 1     13 Width 3ft Permit Number 780743 6001936.24436 2096476.10277 37.7366336128599 -122.435778235198 (37.7366336128599, -122.435778235198) 2 7 5 63 7
124453 158406 2 9 50 Conrad St 1 Sidewalk: Curb side : Cutout Tree 2   10/25/2017 12:00:00 AM 3 3X3 Permit Number 770857 6001789.37716 2096842.5543 37.7376314601307 -122.436312235543 (37.7376314601307, -122.436312235543) 2 7 5 63 7
133424 254076 2 31 416 28th St 1 Sidewalk: Curb side : Cutout Tree 2   12/20/2017 12:00:00 AM 3 3x3   6003139 2099532 37.7450926486102 -122.431837924964 (37.7450926486102, -122.431837924964) 2 7 5 63 22
144520 43569 2 22 601 29TH ST 3 Sidewalk: Curb side : Cutout Tree 2   07/20/2000 12:00:00 AM   3x3 Permit Number 43230 6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7
156678 255580 2 22 384 28th St 1 Sidewalk: Curb side : Cutout Tree 2   06/18/2018 12:00:00 AM 3 3x3 Permit Number 778885 6003411.13256 2099532.22132 37.7451086791398 -122.430896954644 (37.7451086791398, -122.430896954644) 2 7 5 63 22
159683 239458 2 40 165 Sussex St 3 Sidewalk: Curb side : Cutout Tree 1   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001977.4736 2096494.97635 37.7366877772239 -122.435637038029 (37.7366877772239, -122.435637038029) 2 7 5 63 7
168649 243745 2 19 130 Mateo St 1 Sidewalk: Curb side : Cutout Tree 2   12/22/2017 12:00:00 AM 3 3x3 Permit Number 774373 6003834.27428 2096405.12406 37.7365463534355 -122.429210869408 (37.7365463534355, -122.429210869408) 2 7 5 63 7
170182 258184 2 14 95 Laidley St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6003372 2097903 37.74063299685 -122.430916015884 (37.74063299685, -122.430916015884) 2 7 5 63 7
191974 108030 2 14 601 29th St 1 Sidewalk: Curb side : Cutout Tree 2   11/17/2014 12:00:00 AM 3 3x3   6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7