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)
12625 97159 5 91 1079 Le Conte Ave 6 Sidewalk: Curb side : Cutout Tree 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012757.60574 2089814.3813 37.7189506418481 -122.397896712286 (37.7189506418481, -122.397896712286) 10 3 8 58 1
6293 97158 5 91 1079 Le Conte Ave 5 Sidewalk: Curb side : Cutout Tree 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012744.23117 2089823.98249 37.7189762599209 -122.397943616401 (37.7189762599209, -122.397943616401) 10 3 8 58 1
18330 97157 5 91 1079 Le Conte Ave 4 Sidewalk: Curb side : Cutout Tree 2   08/25/2011 12:00:00 AM 2   Permit Number 768080 6012734.70575 2089832.2191 37.7189983454895 -122.397977119771 (37.7189983454895, -122.397977119771) 10 3 8 58 1
12626 97156 5 91 1079 Le Conte Ave 3 Sidewalk: Curb side : Cutout Tree 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012721.62132 2089840.20593 37.7190195469812 -122.398022907844 (37.7190195469812, -122.398022907844) 10 3 8 58 1
18353 97155 5 91 1079 Le Conte Ave 2 Sidewalk: Curb side : Cutout Tree 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012703.24235 2089857.95173 37.7190672497343 -122.398087681509 (37.7190672497343, -122.398087681509) 10 3 8 58 1
6990 97154 5 91 1079 Le Conte Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/25/2011 12:00:00 AM 4   Permit Number 768080 6012676.26956 2089874.1029 37.7191100952408 -122.398182049174 (37.7191100952408, -122.398182049174) 10 3 8 58 1
2107 113082 5 215 414 Somerset St 1 Sidewalk: Curb side : Cutout Tree 2   09/08/2015 12:00:00 AM 3 3x3   6010030.65327 2092539.3572 37.7262806120542 -122.407514778095 (37.7262806120542, -122.407514778095) 10 3 7 309 28
33 261067 5 19 1832 Egbert Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/13/2020 12:00:00 AM 3 4x6 Permit Number 782484 6011934 2092960 37.727541965346 -122.400964507068 (37.727541965346, -122.400964507068) 10 3 8 58 1
4387 264910 5 19 1615 Wallace Ave 1 Front Yard : Cutout Tree 2   11/04/2020 12:00:00 AM 3 4x4 Permit Number 775989 6014687.7877 2092924.6213 37.7275980500808 -122.391442091837 (37.7275980500808, -122.391442091837) 10 3 8 58 1
4750 113090 5 44 1213 Silver Ave 1 Sidewalk: Curb side : Cutout Tree 2   09/08/2015 12:00:00 AM 3 3x3   6008675.52728 2094042.60872 37.7303322746045 -122.41230559973 (37.7303322746045, -122.41230559973) 9 3 7 309 28
6880 24222 5 78 54 Whitney Young Cir 1 Sidewalk: Curb side : Cutout Tree 2   05/07/2010 12:00:00 AM 3 4x4 this is original dpw basin record. 6017205.2608 2094992.48681 37.7334154068844 -122.382882921904 (37.7334154068844, -122.382882921904) 10 3 8 58 1
8512 117149 5 8 928 Toland St 4 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011929.15518 2097982.19203 37.7413315821976 -122.401334038935 (37.7413315821976, -122.401334038935) 10 3 8 58 1
18014 117148 5 8 928 Toland St 3 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011961.8463 2098027.63913 37.7414581941431 -122.401224196662 (37.7414581941431, -122.401224196662) 10 3 8 58 1
10674 117147 5 8 928 Toland St 2 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011972.25416 2098042.58697 37.7414998183769 -122.40118925978 (37.7414998183769, -122.40118925978) 10 3 8 58 1
8525 117146 5 8 928 Toland St 1 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011982.52405 2098055.99364 37.741537203178 -122.401154691646 (37.741537203178, -122.401154691646) 10 3 8 58 1
194328 258403 5 8 1052 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree 2   05/10/2019 12:00:00 AM 3 3x5   6011869 2103486 37.7564404909426 -122.401928842587 (37.7564404909426, -122.401928842587) 10 3 8 28856 29
18648 108454 5 276 696 Pennsylvania Ave 6 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6014383.50929 2103916.35065 37.757762155526 -122.393262829511 (37.757762155526, -122.393262829511) 10 3 8 28856 29
14750 108453 5 140 696 Pennsylvania Ave 5 Sidewalk: Curb side : Cutout Tree 2     11 3x3   6014383.1993 2103935.66602 37.7578151741454 -122.393265253191 (37.7578151741454, -122.393265253191) 10 3 8 28856 29
10248 108452 5 140 696 Pennsylvania Ave 4 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6014381.40925 2103952.18314 37.757860427147 -122.393272599772 (37.757860427147, -122.393272599772) 10 3 8 28856 29
7842 108451 5 140 696 Pennsylvania Ave 3 Sidewalk: Curb side : Cutout Tree 2     7 3x3   6014380.97285 2103975.72487 37.7579250434155 -122.393275756387 (37.7579250434155, -122.393275756387) 10 3 8 28856 29
5719 108450 5 140 696 Pennsylvania Ave 2 Sidewalk: Curb side : Cutout Tree 2     6 3x3   6014379.30863 2103997.39375 37.7579844490278 -122.393283028308 (37.7579844490278, -122.393283028308) 10 3 8 28856 29
8951 108447 5 140 696 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree 2     12 3x3   6014378.0974 2104018.35584 37.7580419391129 -122.393288684138 (37.7580419391129, -122.393288684138) 10 3 8 28856 29
1757 261740 5 25 540 De Haro St 8 Sidewalk: Property side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
2679 261736 5 14 540 De Haro St 4 Sidewalk: Property side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
3337 261748 5 49 540 De Haro St 16 Sidewalk: Curb side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
3374 261742 5 25 540 De Haro St 10 Sidewalk: Property side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
3836 261734 5 51 540 De Haro St 2 Sidewalk: Property side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
4604 261733 5 51 540 De Haro St 1 Sidewalk: Property side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
5885 261744 5 25 540 De Haro St 12 Sidewalk: Property side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
7112 261737 5 14 540 De Haro St 5 Sidewalk: Property side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
9940 261738 5 14 540 De Haro St 6 Sidewalk: Property side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
11461 261747 5 49 540 De Haro St 15 Sidewalk: Curb side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
12766 261739 5 25 540 De Haro St 7 Sidewalk: Property side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
14638 261745 5 25 540 De Haro St 13 Sidewalk: Property side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
14658 261743 5 25 540 De Haro St 11 Sidewalk: Property side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
15024 261746 5 49 540 De Haro St 14 Sidewalk: Curb side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
16452 261741 5 25 540 De Haro St 9 Sidewalk: Property side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
17602 261735 5 14 540 De Haro St 3 Sidewalk: Property side : Yard Tree 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29