trees

Custom SQL query returning 56 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
37788 34059 7 50 1736 Bryant St 1 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM 12 6x7 Permit Number 37961 6009447.37701969 2106694.23265708 37.7651141201322 -122.410530241296 (37.7651141201322, -122.410530241296) 8 4 7 28859 19
15488 228530 1 50 1736 Bryant St 1 Sidewalk: Curb side : Cutout Tree 2     10 6x6   6009448.17881 2106596.433 37.7648456296528 -122.410520561485 (37.7648456296528, -122.410520561485) 8 4 7 28859 19
119841 34060 7 50 1744 Bryant St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/05/1997 12:00:00 AM   3x3 Permit Number 37962 6009449.36433284 2106657.97750104 37.7650146832031 -122.410520807301 (37.7650146832031, -122.410520807301) 8 4 7 28859 19
5058 228531 1 50 1744 Bryant St 1 : Tree 2     8 Width 3ft   6009451.25319 2106552.40785 37.7647249190387 -122.410506818932 (37.7647249190387, -122.410506818932) 8 4 7 28859 19
34711 44001 2 50 2701X 17th St 5 Sidewalk: Curb side : Cutout Tree 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
37180 44003 2 50 2701X 17th St 9 Sidewalk: Curb side : Cutout Tree 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
72715 44010 2 50 405x Florida St 3 Sidewalk: Curb side : Cutout Tree 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
145930 44005 2 50 2701X 17th St 7 Sidewalk: Curb side : Cutout Tree 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
176140 44012 2 50 405X Florida St 1 Sidewalk: Curb side : Cutout Tree 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
177064 44004 2 50 2701X 17th St 8 Sidewalk: Curb side : Cutout Tree 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
191118 44013 2 50 2701X 17th St 6 Sidewalk: Curb side : Cutout Tree 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
51327 111062 7 50 1851 Bryant St 11 Sidewalk: Curb side : Cutout Tree 2       4x4   6009528.24804625 2106163.95855958 37.7636626423221 -122.410213085123 (37.7636626423221, -122.410213085123) 8 4 8 28859 19
51672 111057 7 50 1851 Bryant St 6 Sidewalk: Curb side : Cutout Tree 2       4x4   6009528.24804625 2106163.95855958 37.7636626423221 -122.410213085123 (37.7636626423221, -122.410213085123) 8 4 8 28859 19
172125 111063 7 50 1851 Bryant St 12 Sidewalk: Curb side : Cutout Tree 2       4x4   6009528.24804625 2106163.95855958 37.7636626423221 -122.410213085123 (37.7636626423221, -122.410213085123) 8 4 8 28859 19
144753 229809 1 50 1801 Bryant St 12 Sidewalk: Curb side : Cutout Tree 2     5 Width 4ft   6009528.66718 2106237.67868 37.7638650844166 -122.410216840643 (37.7638650844166, -122.410216840643) 8 4 8 28859 19
43619 229810 1 50 1801 Bryant St 14 Sidewalk: Curb side : Cutout Tree 2     8 Width 4ft   6009529.11729 2106277.27866 37.7639738421376 -122.4102180799 (37.7639738421376, -122.4102180799) 8 4 8 28859 19
85893 229808 1 50 1801 Bryant St 7 Sidewalk: Curb side : Cutout Tree 2     9 Width 4ft   6009536.40285 2106125.11646 37.7635564478901 -122.410182137596 (37.7635564478901, -122.410182137596) 8 4 8 28859 19
43209 39079 7 50 2280X Alameda St 5 Sidewalk: Curb side : Cutout Tree 2   11/18/1998 12:00:00 AM     Permit Number 40778 6010277.76687759 2108009.04739866 37.7687708195348 -122.40775082962 (37.7687708195348, -122.40775082962) 8 4 8 28853 19
138435 39077 7 50 2280X Alameda St 8 Sidewalk: Curb side : Cutout Tree 2   11/18/1998 12:00:00 AM     Permit Number 40778 6010277.76687759 2108009.04739866 37.7687708195348 -122.40775082962 (37.7687708195348, -122.40775082962) 8 4 8 28853 19
147709 110368 1 50 2299x Alameda St 1 Sidewalk: Curb side : Cutout Tree 2     5 3x3   6010339.5627 2107839.67142 37.768309211116 -122.407525138277 (37.768309211116, -122.407525138277) 8 4 8 28853 19
45167 110369 1 50 2299x Alameda St 2 Sidewalk: Curb side : Cutout Tree 2     5 3x3   6010361.75992 2107841.88666 37.7683165361048 -122.407448516042 (37.7683165361048, -122.407448516042) 8 4 8 28853 19
191355 190722 1 50 2200 Alameda St 8 Sidewalk: Curb side : Cutout Tree 2     8 Width 4ft   6010363.60354 2107883.96222 37.7684321691431 -122.407445105823 (37.7684321691431, -122.407445105823) 8 4 8 28853 19
76015 190723 1 50 2277 Alameda St 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 4ft   6010387.48096 2107844.66484 37.7683256039748 -122.407359744866 (37.7683256039748, -122.407359744866) 8 4 8 28853 19
30663 190724 1 50 2277 Alameda St 2 Sidewalk: Curb side : Cutout Tree 2     6 Width 4ft   6010411.73546 2107844.78326 37.7683272866084 -122.407275858794 (37.7683272866084, -122.407275858794) 8 4 8 28853 19
9980 110373 4 50 2299x ALAMEDA ST 6 Sidewalk: Curb side : Cutout Tree 2     5 3x3   6010419 2107687 37.7678944564601 -122.407239607329 (37.7678944564601, -122.407239607329) 8 4 8 28853 19
70077 110371 4 50 2299x ALAMEDA ST 4 Sidewalk: Curb side : Cutout Tree 2     5 3x3   6010419 2107687 37.7678944564601 -122.407239607329 (37.7678944564601, -122.407239607329) 8 4 8 28853 19
99494 110374 4 50 2299x ALAMEDA ST 7 Sidewalk: Curb side : Cutout Tree 2     5 3x3   6010419 2107687 37.7678944564601 -122.407239607329 (37.7678944564601, -122.407239607329) 8 4 8 28853 19
105723 110372 4 50 2299x ALAMEDA ST 5 Sidewalk: Curb side : Cutout Tree 2     5 3x3   6010419 2107687 37.7678944564601 -122.407239607329 (37.7678944564601, -122.407239607329) 8 4 8 28853 19
171679 110370 4 50 2299x ALAMEDA ST 3 Sidewalk: Curb side : Cutout Tree 2     5 3x3   6010419 2107687 37.7678944564601 -122.407239607329 (37.7678944564601, -122.407239607329) 8 4 8 28853 19
117455 190725 1 50 2211 Alameda St 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 4ft   6010439.75315 2107847.13146 37.7683353022519 -122.407179113336 (37.7683353022519, -122.407179113336) 8 4 8 28853 19
53107 190726 1 50 2211 Alameda St 2 Sidewalk: Curb side : Cutout Tree 2     6 Width 4ft   6010460.27046 2107847.89076 37.7683385353269 -122.40710819908 (37.7683385353269, -122.40710819908) 8 4 8 28853 19
127440 190721 1 50 2200 Alameda St 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 4ft   6010462.79733 2107890.40635 37.7684554148125 -122.407102456039 (37.7684554148125, -122.407102456039) 8 4 8 28853 19
77015 190727 1 50 2211 Alameda St 3 Sidewalk: Curb side : Cutout Tree 2     7 Width 4ft   6010484.13409 2107848.45184 37.7683414113517 -122.407025696183 (37.7683414113517, -122.407025696183) 8 4 8 28853 19
63833 190728 1 50 100 Utah St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 4ft   6010522.48931 2107817.1778 37.7682576862591 -122.406890823964 (37.7682576862591, -122.406890823964) 8 4 8 28853 19
175279 190729 1 50 100 Utah St 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 4ft   6010522.64899 2107794.80164 37.7681962553765 -122.406888694378 (37.7681962553765, -122.406888694378) 8 4 8 28853 19
102667 190730 1 50 100 Utah St 3 Sidewalk: Curb side : Cutout Tree 2     6 Width 4ft   6010525.46494 2107766.85443 37.7681196762964 -122.406876984296 (37.7681196762964, -122.406876984296) 8 4 8 28853 19
48019 190731 1 50 100 Utah St 4 Sidewalk: Curb side : Cutout Tree 2     5 Width 4ft   6010525.63223 2107742.12089 37.7680517730114 -122.406874662236 (37.7680517730114, -122.406874662236) 8 4 8 28853 19
151047 190732 1 50 100 Utah St 5 Sidewalk: Curb side : Cutout Tree 2     6 Width 4ft   6010527.29182 2107717.8289 37.7679851656226 -122.406867209579 (37.7679851656226, -122.406867209579) 8 4 8 28853 19
149430 190733 1 50 128 Utah St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 4ft   6010530.15081 2107694.73579 37.767921917195 -122.406855692832 (37.767921917195, -122.406855692832) 8 4 8 28853 19
156163 190734 1 50 128 Utah St 2 Sidewalk: Curb side : Cutout Tree 2     6 Width 4ft   6010530.37912 2107677.75559 37.7678753062214 -122.406853706245 (37.7678753062214, -122.406853706245) 8 4 8 28853 19
160502 190735 1 50 128 Utah St 3 Sidewalk: Curb side : Cutout Tree 2     5 Width 4ft   6010531.76595 2107657.21316 37.7678189790021 -122.406847461368 (37.7678189790021, -122.406847461368) 8 4 8 28853 19
121316 190737 1 50 168 Utah St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 4ft   6010533.36081 2107625.71159 37.7677325721273 -122.406839724475 (37.7677325721273, -122.406839724475) 8 4 8 28853 19
98448 190738 1 50 168 Utah St 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 4ft   6010533.72626 2107613.44503 37.7676989114041 -122.406837595798 (37.7676989114041, -122.406837595798) 8 4 8 28853 19
135288 190736 1 50 128 Utah St 4 Sidewalk: Curb side : Cutout Tree 2     6 Width 4ft   6010534.2694 2107640.09784 37.7677721243224 -122.406837595791 (37.7677721243224, -122.406837595791) 8 4 8 28853 19
21203 190740 1 50 168 Utah St 4 Sidewalk: Curb side : Cutout Tree 2     5 Width 4ft   6010535.58814 2107583.98443 37.7676181235051 -122.406829079197 (37.7676181235051, -122.406829079197) 8 4 8 28853 19
180841 190739 1 50 168 Utah St 3 Sidewalk: Curb side : Cutout Tree 2     5 Width 4ft   6010536.50922 2107598.98356 37.7676593592282 -122.406826950508 (37.7676593592282, -122.406826950508) 8 4 8 28853 19
15198 70134 1 50 342-344 Utah St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   7     6010584.92199 2106684.72003 37.7651517084965 -122.406595061225 (37.7651517084965, -122.406595061225) 8 4 8 28853 19
12120 70682 1 50 414 Utah St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   8     6010606.08274 2106339.87511 37.7642060264098 -122.406497569303 (37.7642060264098, -122.406497569303) 8 4 8 28859 19
14471 70661 1 50 460 Utah St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   10     6010614.613 2106160.28585 37.7637133921776 -122.40645540999 (37.7637133921776, -122.40645540999) 8 4 8 28859 19
29685 190682 1 50 546 Utah St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 4ft   6010644.58891 2105668.45784 37.7623646204591 -122.406317076288 (37.7623646204591, -122.406317076288) 8 4 8 28859 19
11549 70665 1 50 550 Utah St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   10     6010647.04803 2105639.57925 37.7622854639243 -122.406306536234 (37.7622854639243, -122.406306536234) 8 4 8 28859 19
19354 262188 9 50 490 Vermont St 1 Front Yard : Cutout Tree 1   05/19/2020 12:00:00 AM 3 3x3 Permit Number 784452 6011166 2106075 37.7635100471883 -122.404542318782 (37.7635100471883, -122.404542318782) 8 3 8 28856 29
147729 54450 1 50 435 Vermont St 1 Sidewalk: Curb side : Cutout Tree 2   09/16/2008 12:00:00 AM 2 3x3 Permit Number 51720 6011224.5432 2106327.02843 37.7642053321404 -122.40435757586 (37.7642053321404, -122.40435757586) 8 3 8 28856 29
32924 190747 1 50 200 Kansas St 7 Sidewalk: Property side : Yard Tree 2     13 Width 4ft   6011390.12769 2107238.80287 37.7667181107881 -122.403849027209 (37.7667181107881, -122.403849027209) 8 2 8 28853 20
109658 190748 1 50 200 Kansas St 8 Sidewalk: Property side : Yard Tree 2     18 Width 4ft   6011391.69355 2107207.84436 37.7666331931997 -122.403841432442 (37.7666331931997, -122.403841432442) 8 2 8 28853 20
140682 66211 1 50 543 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 03/29/2018 12:00:00 AM 6 3x3 Permit Number 53588 6011817.82357 2105837.41873 37.7628941088863 -122.402271150494 (37.7628941088863, -122.402271150494) 8 3 8 28856 29