trees

Custom SQL query returning 38 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
60629 106612 6 91 1189 TENNESSEE ST   Front Yard : Yard Tree 2     55     6015654.1 2103577.3 37.7569017014681 -122.388844893024 (37.7569017014681, -122.388844893024) 10 3 8 28856 29
138347 116585 6 146 2100 22nd St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2018 12:00:00 AM 30 3x3   6011855.05017 2103755.96694 37.7571809821214 -122.401996064067 (37.7571809821214, -122.401996064067) 10 3 8 28856 29
16794 261146 6 101 375x Brannan St 1 Sidewalk: Curb side : Cutout Tree 2   01/14/2020 12:00:00 AM 3 3x3   6014494 2112212 37.780546313007 -122.393461254196 (37.780546313007, -122.393461254196) 6 2 9 28856 6
23612 253210 6 109 567 Mississippi St 1 Sidewalk: Property side : Yard Tree 2   05/02/2019 12:00:00 AM 3 3x3   6014163 2104519 37.7594046471392 -122.394067636073 (37.7594046471392, -122.394067636073) 10 3 8 28856 29
79585 108000 6 17 1000 Rhode Island St 1 Back Yard : Yard Tree 2   11/12/2014 12:00:00 AM 3   Permit Number 774025 6011852.20179 2103661.18899 37.7569205837919 -122.401999252275 (37.7569205837919, -122.401999252275) 10 3 8 28856 29
110183 112361 6 36 561X Folsom St 1 Front Yard : Yard Tree 2   11/16/2015 12:00:00 AM 3 10x30 Permit Number 775828 6013749.7362 2114198.90646 37.7859605214302 -122.396175324952 (37.7859605214302, -122.396175324952) 6 2 9 28856 6
135623 258062 6 109 567 Mississippi St 2 Sidewalk: Property side : Yard Tree 2   05/02/2019 12:00:00 AM 3 3x3   6014163 2104519 37.7594046471392 -122.394067636073 (37.7594046471392, -122.394067636073) 10 3 8 28856 29
119547 107080 6 147 401X TOWNSEND ST 8 Sidewalk: Property side : Cutout Tree 2     14 2x30   6013045 2110022 37.774452457479 -122.398320364295 (37.774452457479, -122.398320364295) 14 2 9 28856 20
168413 106611 6 67 1154 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree 2     12 4x4   6011908.79849 2103025.72201 37.7551788898075 -122.401758852609 (37.7551788898075, -122.401758852609) 10 3 8 28856 29
187289 115806 6 286 362 MISSOURI ST 1 Front Yard : Cutout Tree 2     12 3x3   6013446 2105415 37.7618249904211 -122.39661020099 (37.7618249904211, -122.39661020099) 10 3 8 28856 29
95493 100209 6 95 701 Rhode Island St 1 Front Yard : Yard Tree 2     10   Permit Number 769013 6011855.86556 2105057.10212 37.7607536567646 -122.402084714731 (37.7607536567646, -122.402084714731) 10 3 8 28856 29
684 260585 6 27 397 05th St 3 Sidewalk: Property side : Yard Tree 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
2321 48402 6 40 706 Wisconsin St 1 Sidewalk: Property side : Yard Tree 2   11/19/2010 12:00:00 AM     Permit Number 53935 6012689.64928807 2104214.1545054 37.7584856101735 -122.399141839868 (37.7584856101735, -122.399141839868) 10 3 8 28856 29
3099 104652 6 97 953 Indiana St 1 Front Yard : Cutout Tree 2           6015057.1 2104275.7 37.7587862506702 -122.390958369803 (37.7587862506702, -122.390958369803) 10 3 8 28856 29
4313 105327 6 17 2051 03rd St 1 Back Yard : Yard Tree 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
4938 260583 6 27 397 05th St 1 Sidewalk: Property side : Yard Tree 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
6111 260586 6 27 397 05th St 4 Sidewalk: Property side : Yard Tree 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
6121 260584 6 27 397 05th St 2 Sidewalk: Property side : Yard Tree 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
7964 105328 6 17 2051 03rd St 2 Back Yard : Yard Tree 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
9510 260587 6 27 890x Harrison St 1 Sidewalk: Property side : Yard Tree 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
12165 260922 6 155 866 Kansas St 1 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 774734 6011543 2104306 37.7586738299336 -122.403113948893 (37.7586738299336, -122.403113948893) 10 3 8 28856 29
15941 85313 6 53 610 Brannan St 1 unknown : Cutout Tree 2         Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
22679 108026 6 155 862 Kansas St   Front Yard : Yard Tree 2         Permit Number 774734 6011570 2104296 37.7586478799274 -122.403019866682 (37.7586478799274, -122.403019866682) 10 3 8 28856 29
38818 105964 6 17 360 MISSOURI ST 1 Front Yard : Yard Tree 2           6013401.8 2105413.2 37.7618175880082 -122.396762946114 (37.7618175880082, -122.396762946114) 10 3 8 28856 29
39513 98455 6 176 2200 22nd St 1 Front Yard : Yard Tree 2           6011565.2 2103754.7 37.7571613219705 -122.402998394603 (37.7571613219705, -122.402998394603) 10 3 8 28856 29
43892 99623 6 17 380 Connecticut St 1 Front Yard : Yard Tree 2   05/23/2012 12:00:00 AM     Permit Number 768850 6013171.4 2105301.7 37.7614986071193 -122.397551993257 (37.7614986071193, -122.397551993257) 10 3 8 28856 29
53862 173726 6 15 1101 Connecticut St 1 Front Yard : Yard Tree 2           6013424 2101939 37.7522794251173 -122.396442635345 (37.7522794251173, -122.396442635345) 10 3 8 28856 1
66713 107149 6 15 612 WISCONSIN ST 1 Back Yard : Yard Tree 2           6012651.9 2104553.6 37.7594155491308 -122.399296223309 (37.7594155491308, -122.399296223309) 10 3 8 28856 29
67194 106251 6 17 580 De Haro St 2 Front Yard : Yard Tree 2         Permit Number 770844 6012025.9 2105717.4 37.7625761768628 -122.401543046462 (37.7625761768628, -122.401543046462) 8 3 8 28856 29
67239 251216 6 62 399X Townsend St 1 Sidewalk: Property side : Cutout Tree 2       3x3   6013957 2110872 37.776837125863 -122.395225113019 (37.776837125863, -122.395225113019) 6 2 9 28856 20
81334 106255 6 17 1900X 18th St 1 Sidewalk: Property side : Yard Tree 2         Permit Number 770844 6012067 2105610 37.7622835736204 -122.401393347502 (37.7622835736204, -122.401393347502) 8 3 8 28856 29
85061 255144 6 204 101x Hawthorne St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6013362 2113756 37.7847228211314 -122.3974857221 (37.7847228211314, -122.3974857221) 6 2 9 28856 6
103863 251217 6 62 399X Townsend St 2 Sidewalk: Property side : Cutout Tree 2       3x3   6013957 2110872 37.776837125863 -122.395225113019 (37.776837125863, -122.395225113019) 6 2 9 28856 20
133327 255538 6 155 700x Folsom St 1 Sidewalk: Property side : Cutout Tree 2       3x3   6012646 2113072 37.7828048233647 -122.399914812284 (37.7828048233647, -122.399914812284) 6 2 9 28856 34
177101 96784 6 216 615 Rhode Island St   Sidewalk: Property side : Cutout Tree 2   07/19/2011 12:00:00 AM     Permit Number 767987 6011854.6 2105476.9 37.7619062576766 -122.402118605761 (37.7619062576766, -122.402118605761) 10 3 8 28856 29
185174 255539 6 155 700x Folsom St 17 Sidewalk: Property side : Cutout Tree 2       3x3   6012646 2113072 37.7828048233647 -122.399914812284 (37.7828048233647, -122.399914812284) 6 2 9 28856 34
191992 94463 6 15 744 Carolina St 1 : Tree 2   06/10/2010 12:00:00 AM     Permit Number 53681 6012327.5 2104524.9 37.7593186601765 -122.400416148756 (37.7593186601765, -122.400416148756) 10 3 8 28856 29
192621 106250 6 17 580 De Haro St 1 Front Yard : Yard Tree 2         Permit Number 770844 6012025.9 2105717.4 37.7625761768628 -122.401543046462 (37.7625761768628, -122.401543046462) 8 3 8 28856 29