trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
50796 176161 1 41 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard Tree 2     2     5990361.86615 2090050.7376 37.7183269161272 -122.475326462647 (37.7183269161272, -122.475326462647) 1 8 4 64 14
164419 176160 1 41 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree 2     2     5990378.89561 2089837.21304 37.7177416175535 -122.475252019477 (37.7177416175535, -122.475252019477) 1 8 4 64 14
97887 176159 1 41 0 Serrano Dr 1 Sidewalk: Curb side : Yard Tree 2     2     5989661.71527 2090692.24218 37.720047719404 -122.477793431626 (37.720047719404, -122.477793431626) 1 8 4 64 14
123634 190965 1 41 1 24th St 17 : Yard Tree 2     6     6017293.94065 2102634.43336 37.7544035402038 -122.383108032109 (37.7544035402038, -122.383108032109) 10 3 8 28856 29
8751 262427 6 41 1 Avalon Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
11014 262425 6 41 1 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
15980 262426 6 41 1 Avalon Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
94042 246716 1 41 1 Bonview St 22 Sidewalk: Curb side : Yard Tree 2     45     6007832.06726 2099366.51815 37.7449031947197 -122.415598362177 (37.7449031947197, -122.415598362177) 2 7 7 28859 2
160950 246711 1 41 1 Bonview St 17 Sidewalk: Curb side : Yard Tree 2     15     6007747.55824 2099198.25056 37.7444364187148 -122.415878666471 (37.7444364187148, -122.415878666471) 2 7 7 28859 2
185053 99826 6 41 1 Cascade Walk 1 Front Yard : Yard Tree 2           5992183.1 2103187.3 37.7545020044945 -122.469987253468 (37.7545020044945, -122.469987253468) 1 8 4 56 12
37147 201718 1 41 1 Hawkins Ln 3 Side Yard : Yard Tree 2     14     6017093.28201 2095356.32471 37.7344082458391 -122.383295385174 (37.7344082458391, -122.383295385174) 10 3 8 58 1
58228 201724 1 41 1 Hawkins Ln 7 Side Yard : Yard Tree 2     28     6017165.24184 2095383.9343 37.7344880327856 -122.383048514986 (37.7344880327856, -122.383048514986) 10 3 8 58 1
108416 201716 1 41 1 Hawkins Ln 1 Side Yard : Yard Tree 2     17     6017085.91329 2095352.6498 37.7343977480421 -122.38332060578 (37.7343977480421, -122.38332060578) 10 3 8 58 1
110903 201720 1 41 1 Hawkins Ln 5 Side Yard : Yard Tree 2     17     6017109.38533 2095355.23584 37.7344061459337 -122.383239634411 (37.7344061459337, -122.383239634411) 10 3 8 58 1
143641 201719 1 41 1 Hawkins Ln 4 Side Yard : Yard Tree 2     15     6017095.79964 2095357.42104 37.7344113952763 -122.383286757105 (37.7344113952763, -122.383286757105) 10 3 8 58 1
152247 201723 1 41 1 Hawkins Ln 6 Side Yard : Yard Tree 2     10     6017160.60225 2095378.34378 37.7344724259609 -122.383064166774 (37.7344724259609, -122.383064166774) 10 3 8 58 1
156131 201717 1 41 1 Hawkins Ln 2 Side Yard : Yard Tree 2     24     6017089.1408 2095350.86435 37.7343930239173 -122.383309322872 (37.7343930239173, -122.383309322872) 10 3 8 58 1
40198 253709 1 41 1 Monument Way 3 Unaccepted Street : Yard Tree 2       10x10   5999088 2105836 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118) 15 5 5 29492 3
80195 253710 1 41 1 Monument Way 1 Unaccepted Street : Yard Tree 2       10x10   5999088 2105836 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118) 15 5 5 29492 3
85669 253711 1 41 1 Monument Way 5 Unaccepted Street : Yard Tree 2       10x10   5999088 2105836 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118) 15 5 5 29492 3
145135 253708 1 41 1 Monument Way 2 Unaccepted Street : Yard Tree 2       10x10   5999088 2105836 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118) 15 5 5 29492 3
181580 253707 1 41 1 Monument Way 4 Unaccepted Street : Yard Tree 2       10x10   5999088 2105836 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118) 15 5 5 29492 3
169893 223816 1 41 1 Ohlone Way 1 Back Yard : Yard Tree 2     45 Width 5ft   6002135.08017 2096585.18119 37.7369444095655 -122.435098574335 (37.7369444095655, -122.435098574335) 2 7 5 63 7
2750 206896 1 41 1 Pizarro Way 4 Sidewalk: Curb side : Yard Tree 2     6 Width 3ft   5995094.72754 2093951.90742 37.7293117922974 -122.459249411033 (37.7293117922974, -122.459249411033) 9 7 4 28861 40
89917 206897 1 41 1 Pizarro Way 2 Sidewalk: Curb side : Yard Tree 2     6 Width 3ft   5995088.9482 2093956.71246 37.729324653504 -122.459269738418 (37.729324653504, -122.459269738418) 9 7 4 28861 40
109911 206898 1 41 1 Pizarro Way 3 Sidewalk: Curb side : Yard Tree 2     7 Width 3ft   5995090.77505 2093954.09784 37.7293175794217 -122.459263233611 (37.7293175794217, -122.459263233611) 9 7 4 28861 40
136762 206895 1 41 1 Pizarro Way 9 Sidewalk: Curb side : Yard Tree 2     6 Width 3ft   5995113.71049 2093937.45787 37.7292732086872 -122.459182739799 (37.7292732086872, -122.459182739799) 9 7 4 28861 40
140987 176113 1 41 1 Santa Barbara Ave 5 Sidewalk: Property side : Yard Tree 2     1 Width 8ft   5993424.30452 2086604.0814 37.709040256765 -122.464490865868 (37.709040256765, -122.464490865868) 9 8 6 28861 25
945 217846 1 41 1 Woodacre Dr 1 Sidewalk: Curb side : Yard Tree 2     54     5991427.31798 2095733.50913 37.7339920935414 -122.472057659936 (37.7339920935414, -122.472057659936) 1 8 4 64 40
69300 218295 1 41 1 Woodacre Dr 19 Sidewalk: Curb side : Yard Tree 2     40     5991182.78288 2095348.63112 37.7329211619833 -122.472875029477 (37.7329211619833, -122.472875029477) 1 8 4 64 40
84051 218296 1 41 1 Woodacre Dr 20 Sidewalk: Curb side : Yard Tree 2     38     5991178.95125 2095337.51782 37.7328904258451 -122.472887466195 (37.7328904258451, -122.472887466195) 1 8 4 64 40
87268 217847 1 41 1 Woodacre Dr 2 Sidewalk: Curb side : Yard Tree 2     33     5991420.07679 2095725.93853 37.7339708875491 -122.472082143088 (37.7339708875491, -122.472082143088) 1 8 4 64 40
161365 217851 1 41 1 Woodacre Dr 6 Sidewalk: Curb side : Yard Tree 2     11     5991372.3988 2095655.75321 37.7337754172003 -122.472241864493 (37.7337754172003, -122.472241864493) 1 8 4 64 40
79130 206846 1 41 10 Brotherhood Way 1 Side Yard : Cutout Tree 2     25 Width 0ft   5993694.0595 2087568.46764 37.7117037797802 -122.463628505047 (37.7117037797802, -122.463628505047) 9 8 4 64 24
115250 206847 1 41 10 Brotherhood Way 2 : Tree 2     16 Width 0ft   5993688.70591 2087590.28087 37.7117633652539 -122.463648590504 (37.7117633652539, -122.463648590504) 9 8 4 64 24
164123 206848 1 41 10 Brotherhood Way 3 : Tree 2     11 Width 0ft   5993673.9414 2087579.01676 37.7117315859181 -122.46369880328 (37.7117315859181, -122.46369880328) 9 8 4 64 24
45889 223720 1 41 10 Crescent Ave 3 Side Yard : Yard Tree 2     15 Width 3ft   6005295.72226 2095902.89747 37.7352499770995 -122.424122309196 (37.7352499770995, -122.424122309196) 2 7 7 28859 2
116416 223719 1 41 10 Crescent Ave 4 Side Yard : Yard Tree 2     6 Width 3ft   6005300.64092 2095902.62438 37.7352495049691 -122.424105284154 (37.7352495049691, -122.424105284154) 2 7 7 28859 2
14861 176144 1 41 10 Lake Merced Blvd 5 : Tree 2     39 Width 0ft   5987593.26623 2090234.31177 37.7186700965335 -122.484909687836 (37.7186700965335, -122.484909687836) 1 8 4 64 14
36507 176151 1 41 10 Lake Merced Blvd 12 : Tree 2     28 Width 0ft   5987601.77319 2090779.60025 37.7201678157831 -122.484920265686 (37.7201678157831, -122.484920265686) 1 8 4 64 14
48447 176148 1 41 10 Lake Merced Blvd 9 : Tree 2     34 Width 0ft   5987583.49684 2090495.06547 37.7193854910228 -122.484962576086 (37.7193854910228, -122.484962576086) 1 8 4 64 14
56804 176140 1 41 10 Lake Merced Blvd 3 : Tree 2     15 Width 0ft   5987455.89858 2088588.29538 37.7141425496068 -122.485263793215 (37.7141425496068, -122.485263793215) 1 8 4 64 14
56809 176146 1 41 10 Lake Merced Blvd 7 : Tree 2     40 Width 0ft   5987590.81022 2090334.92594 37.7189462144818 -122.48492555459 (37.7189462144818, -122.48492555459) 1 8 4 64 14
56871 176139 1 41 10 Lake Merced Blvd 2 : Tree 2     10 Width 0ft   5987453.25598 2088569.38174 37.7140904635658 -122.485271539962 (37.7140904635658, -122.485271539962) 1 8 4 64 14
61082 176147 1 41 10 Lake Merced Blvd 8 : Tree 2     40 Width 0ft   5987595.02111 2090461.30064 37.7192934526127 -122.484920265678 (37.7192934526127, -122.484920265678) 1 8 4 64 14
97386 176141 1 41 10 Lake Merced Blvd 1 : Tree 2     48 Width 0ft   5987562.65817 2089512.73136 37.7166870365437 -122.484962576069 (37.7166870365437, -122.484962576069) 1 8 4 64 14
105177 176138 1 41 10 Lake Merced Blvd 1 : Tree 2     16 Width 0ft   5987453.76086 2088540.35852 37.7140108025207 -122.485267666593 (37.7140108025207, -122.485267666593) 1 8 4 64 14
112546 176142 1 41 10 Lake Merced Blvd 2 : Tree 2     38 Width 0ft   5987571.34971 2089706.0579 37.7172183686082 -122.48494670935 (37.7172183686082, -122.48494670935) 1 8 4 64 14
129760 176143 1 41 10 Lake Merced Blvd 4 : Tree 2     60 Width 0ft   5987585.53383 2089941.92941 37.7178668382624 -122.484914976762 (37.7178668382624, -122.484914976762) 1 8 4 64 14
136571 176150 1 41 10 Lake Merced Blvd 11 : Tree 2     36 Width 0ft   5987592.48981 2090630.47985 37.7197578283347 -122.484941420412 (37.7197578283347, -122.484941420412) 1 8 4 64 14
168161 176145 1 41 10 Lake Merced Blvd 6 : Tree 2     41 Width 0ft   5987592.83524 2090286.12579 37.7188123395933 -122.484914976763 (37.7188123395933, -122.484914976763) 1 8 4 64 14
171645 176149 1 41 10 Lake Merced Blvd 10 : Tree 2     58 Width 0ft   5987588.89275 2090533.04242 37.7194900803794 -122.48494670934 (37.7194900803794, -122.48494670934) 1 8 4 64 14
61895 176115 1 41 10 Skyline Blvd 1 : Tree 2     8 Width 0ft   5982387.31367 2092831.90061 37.7254977881756 -122.503096467121 (37.7254977881756, -122.503096467121) 1 8 4 64 14
101320 176116 1 41 10 Skyline Blvd 2 : Tree 2     9 Width 0ft   5982365.02042 2092827.72294 37.7254850070203 -122.503173222486 (37.7254850070203, -122.503173222486) 1 8 4 64 14
7283 176114 1 41 10 Zoo Rd 1 Front Yard : Yard Tree 2     24 Width 10ft   5982696.49512 2094384.4536 37.7297788507039 -122.502142508582 (37.7297788507039, -122.502142508582) 1 8 4 64 14
142056 116669 1 41 100 Esmeralda Ave 6 Unaccepted Street : Yard Tree 1     20     6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
83721 206802 1 41 100 Judah St 1 Sidewalk: Property side : Cutout Tree 2     13 Width 1ft   5994234.49251 2106025.56842 37.7624135282762 -122.463098978843 (37.7624135282762, -122.463098978843) 1 5 11 56 12
141416 118356 9 41 100 RACCOON DR 2 Back Yard : Cutout Tree 2     48     5998776 2103987 37.7570766935068 -122.447244922317 (37.7570766935068, -122.447244922317) 15 5 5 63 3
22642 253769 1 41 100 Raccoon Dr 2 Back Yard : Yard Tree 2           5998692 2104165 37.7575606372552 -122.447548237739 (37.7575606372552, -122.447548237739) 15 5 5 28862 3
113507 253768 8 41 100 Raccoon Dr 1 Back Yard : Yard Tree 2           5998692 2104165 37.7575606372552 -122.447548237739 (37.7575606372552, -122.447548237739) 15 5 5 28862 3
795 19570 1 41 100 STAIRWAY1 4 Sidewalk: Curb side : Cutout Tree 1     48 100ST                      
3078 19568 1 41 100 STAIRWAY1 2 Sidewalk: Curb side : Cutout Tree 1     48 100ST                      
3191 19565 1 41 100 STAIRWAY1 -11 Sidewalk: Curb side : Cutout Tree 1     36 100ST                      
7644 19569 1 41 100 STAIRWAY1 3 Sidewalk: Curb side : Cutout Tree 1     48 100ST                      
19615 19566 1 41 100 STAIRWAY1 -9 Sidewalk: Curb side : Cutout Tree 1     36 100ST                      
8411 19699 1 41 100 STAIRWAY11 1 Sidewalk: Curb side : Cutout Tree 1     24 40ST                      
13223 19700 1 41 100 STAIRWAY11 2 Sidewalk: Curb side : Cutout Tree 1     36 40ST                      
12674 19753 1 41 100 STAIRWAY15 11 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
13143 19776 1 41 100 STAIRWAY18 2 Sidewalk: Curb side : Cutout Tree 1     18 50ST                      
8937 19804 1 41 100 STAIRWAY22 3 Sidewalk: Curb side : Cutout Tree 1     6 20                      
12679 19813 1 41 100 STAIRWAY24 4 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
18542 19869 1 41 100 STAIRWAY33 1 Sidewalk: Curb side : Cutout Tree 1     24 25ST                      
509 19905 1 41 100 STAIRWAY35 1 Sidewalk: Curb side : Cutout Tree 1     12 120ST                      
3028 19906 1 41 100 STAIRWAY35 2 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
3052 19908 1 41 100 STAIRWAY35 4 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
7787 19910 1 41 100 STAIRWAY35 6 Sidewalk: Curb side : Cutout Tree 1     12 120ST                      
12224 19907 1 41 100 STAIRWAY35 3 Sidewalk: Curb side : Cutout Tree 1     12 120ST                      
16638 19909 1 41 100 STAIRWAY35 5 Sidewalk: Curb side : Cutout Tree 1     12 120ST                      
2302 19935 1 41 100 STAIRWAY38 4 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
5357 19933 1 41 100 STAIRWAY38 2 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
9387 19932 1 41 100 STAIRWAY38 1 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
12968 19943 1 41 100 STAIRWAY38 12 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
16093 19936 1 41 100 STAIRWAY38 5 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
18123 19934 1 41 100 STAIRWAY38 3 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
720 19950 1 41 100 STAIRWAY39 7 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
3011 19948 1 41 100 STAIRWAY39 5 Sidewalk: Curb side : Cutout Tree 1     18 25ST                      
5295 19947 1 41 100 STAIRWAY39 4 Sidewalk: Curb side : Cutout Tree 1     18 25ST                      
8582 19955 1 41 100 STAIRWAY39 12 Sidewalk: Curb side : Cutout Tree 1     12 2ST                      
13417 19945 1 41 100 STAIRWAY39 2 Sidewalk: Curb side : Cutout Tree 1     6 25ST                      
14026 19949 1 41 100 STAIRWAY39 6 Sidewalk: Curb side : Cutout Tree 1     24 25ST                      
16465 19951 1 41 100 STAIRWAY39 8 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
19208 19953 1 41 100 STAIRWAY39 10 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
16153 19978 1 41 100 STAIRWAY45 5 Sidewalk: Curb side : Cutout Tree 1     36 30ST                      
19500 20013 1 41 100 STAIRWAY47 1 Sidewalk: Curb side : Cutout Tree 1     6 100ST                      
13064 19694 1 41 100 STAIRWAY7 1 Sidewalk: Curb side : Cutout Tree 1     24 12ST                      
49827 53726 1 41 100 Topeka Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/07/1972 12:00:00 AM 8   Permit Number 9405 6012451.87174 2095251.14558 37.7338618519323 -122.399334980939 (37.7338618519323, -122.399334980939) 10 3 8 58 1
121032 190987 1 41 100 Topeka Ave 3 Sidewalk: Property side : Yard Tree 2     8 Width 5ft   6012468.98817 2095242.94143 37.7338402790006 -122.39927522817 (37.7338402790006, -122.39927522817) 10 3 8 58 1
12287 95982 6 41 100 Vasquez Ave 1 Back Yard : Yard Tree 2           5995122.4 2099706.3 37.7451135296363 -122.459570350972 (37.7451135296363, -122.459570350972) 1 8 4 59 40
167754 107159 6 41 1000 ESMERALDA AVE   Front Yard : Yard Tree 2           6009839 2098688 37.7431527400861 -122.408610872619 (37.7431527400861, -122.408610872619) 10 7 7 28859 2
5408 261480 1 41 1000 Portola Dr 9 Median : Yard Tree 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
159510 251717 1 41 1000X San Jose Ave 1 Front Yard : Yard Tree 1           6004710 2096486 37.7368179571536 -122.426188866367 (37.7368179571536, -122.426188866367) 2 7 5 28859 7