sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
157374 122908 3 430 2x 12th Ave 4 3 1 2     14     5992093.66064 2114888.38015 37.7866248560676 -122.471148981632 (37.7866248560676, -122.471148981632)
149526 226828 3 425 100x Dolores St 2 3 1 2     18     6004803.7155 2107705.9695200003 37.7676306780299 -122.42666359364901 (37.7676306780299, -122.426663593649)
130411 136579 3 422 1306x Montgomery St 36 3 1 2     22 Width 8ft   6011426.53654 2120156.27295 37.8021884811707 -122.404632533662 (37.8021884811707, -122.404632533662)
70677 187788 3 398 1300x De Haro St 15 3 1 2     2     6012267.84735 2102159.07234 37.7528192891044 -122.400456276334 (37.7528192891044, -122.400456276334)
35411 190035 3 388 1300x De Haro St 34 3 1 2     27     6012271.55994 2101940.28585 37.7522187560075 -122.40042807090599 (37.7522187560075, -122.400428070906)
34583 197479 3 386 1700x Quesada Ave 48 3 1 2     4     6014300.68484 2095327.0716 37.734173198123706 -122.392948336615 (37.7341731981237, -122.392948336615)
129957 197481 3 386 1700x Quesada Ave 21 3 1 2     4     6014505.90634 2095186.14654 37.73379764393329 -122.392228962601 (37.7337976439333, -122.392228962601)
155525 188536 3 366 900x Carolina St 17 3 1 2     12     6012479.96595 2103541.08212 37.7566258135487 -122.399819761371 (37.7566258135487, -122.399819761371)
34522 196562 3 362 1498x Tennessee St 11 3 1 2     6 Width 7ft   6015638.13327 2101940.5200799997 37.7524065650316 -122.388785850611 (37.7524065650316, -122.388785850611)
41956 246886 3 362 3090x Market St 19 3 1 2     9     5999895.8145 2105286.9731 37.7607100216774 -122.443465565401 (37.7607100216774, -122.443465565401)
186834 246885 3 362 3090x Market St 18 3 1 2     8     5999879.22099 2105284.18163 37.760701410669206 -122.44352275418899 (37.7607014106692, -122.443522754189)
59175 217814 3 340 1x Junipero Serra Blvd 1 3 1 2     39     5991642.1645 2095884.13354 37.734418100595995 -122.47132584741001 (37.734418100596, -122.47132584741)
123415 247578 3 340 300x Alemany Blvd 2 3 1 2     43     6008699.141969999 2095317.61632 37.733834496346 -122.412314043462 (37.733834496346, -122.412314043462)
23773 222832 3 335 3250x Cesar Chavez St 4 3 1 2     6 Width 10ft   6007936.88236 2100571.1337200003 37.7482166910686 -122.415321190215 (37.7482166910686, -122.415321190215)
24347 222775 3 335 2950x Cesar Chavez St 9 3 1 2     3     6009484.1227400005 2100580.43593 37.7483290712363 -122.40997151459 (37.7483290712363, -122.40997151459)
27546 222774 3 335 2950x Cesar Chavez St 10 3 1 2     1     6009463.63512 2100579.86171 37.748326346280706 -122.41004232002301 (37.7483263462807, -122.410042320023)
30314 222818 3 335 3500x Cesar Chavez St 11 3 1 2     5 Width 10ft   6006120.27144 2100551.46467 37.7480604176603 -122.42160158864701 (37.7480604176603, -122.421601588647)
31210 222842 3 335 3100x Cesar Chavez St 9 3 1 2     3 Width 10ft   6008782.20284 2100575.62151 37.748276486974 -122.412398404384 (37.748276486974, -122.412398404384)
37406 222810 3 335 3400x Cesar Chavez St 9 3 1 2     4 Width 10ft   6006867.8232 2100561.0017 37.7481287283566 -122.41901725364599 (37.7481287283566, -122.419017253646)
37743 222835 3 335 3050x Cesar Chavez St 4 3 1 2     4 Width 10ft   6009216.18805 2100578.21721 37.74830795876021 -122.410897872946 (37.7483079587602, -122.410897872946)
39879 222824 3 335 3200x Cesar Chavez St 4 3 1 2     1 Width 10ft   6008202.20567 2100572.2127900003 37.7482345623906 -122.41440378373001 (37.7482345623906, -122.41440378373)
45519 222813 3 335 3400x Cesar Chavez St 15 3 1 2     6 Width 10ft   6006748.5872 2100559.98827 37.748119230616105 -122.419429496578 (37.7481192306161, -122.419429496578)
47288 222807 3 335 3400x Cesar Chavez St 6 3 1 2     3 Width 10ft   6006935.06482 2100562.99304 37.7481379823795 -122.41878487513901 (37.7481379823795, -122.418784875139)
48340 222814 3 335 3500x Cesar Chavez St 4 3 1 2     2 Width 10ft   6006266.09505 2100563.37105 37.748101331408 -122.42109818053801 (37.748101331408, -122.421098180538)
48674 222834 3 335 3250x Cesar Chavez St 6 3 1 2     4 Width 10ft   6007896.6136300005 2100571.958 37.7482166910443 -122.415460497013 (37.7482166910443, -122.415460497013)
50345 222833 3 335 3250x Cesar Chavez St 5 3 1 2     4 Width 10ft   6007916.1727 2100571.5576299997 37.74821669106021 -122.41539283380502 (37.7482166910602, -122.415392833805)
56033 222845 3 335 3100x Cesar Chavez St 15 3 1 2     2 Width 10ft   6008656.93174 2100575.27687 37.7482685099843 -122.41283156553699 (37.7482685099843, -122.412831565537)
61445 222840 3 335 3100x Cesar Chavez St 7 3 1 2     4 Width 10ft   6008831.315769999 2100575.76415 37.7482796345996 -122.412228582693 (37.7482796345996, -122.412228582693)
61802 222823 3 335 3500x Cesar Chavez St 16 3 1 2     4 Width 10ft   6006010.36461 2100542.85713 37.7480305853438 -122.42198103152 (37.7480305853438, -122.42198103152)
65215 222839 3 335 3100x Cesar Chavez St 5 3 1 2     5 Width 10ft   6008877.383769999 2100577.11513 37.7482859289696 -122.412069375694 (37.7482859289696, -122.412069375694)
71153 222777 3 335 2950x Cesar Chavez St 7 3 1 2     2     6009523.38261 2100580.00732 37.748330094656296 -122.409835724135 (37.7483300946563, -122.409835724135)
71273 222812 3 335 3400x Cesar Chavez St 14 3 1 2     4 Width 10ft   6006765.73797 2100560.2571400004 37.748120934852 -122.419370208764 (37.748120934852, -122.419370208764)
71603 222843 3 335 3100x Cesar Chavez St 13 3 1 2     3 Width 10ft   6008698.15924 2100574.66503 37.7482691440259 -122.41268895824699 (37.7482691440259, -122.412688958247)
75185 222805 3 335 3400x Cesar Chavez St 4 3 1 2     3 Width 10ft   6006981.21986 2100563.9092900003 37.7481430968362 -122.41862533719299 (37.7481430968362, -122.418625337193)
80208 222808 3 335 3400x Cesar Chavez St 7 3 1 2     3 Width 10ft   6006921.0363300005 2100562.97022 37.7481371298399 -122.41883338366699 (37.7481371298399, -122.418833383667)
83204 222837 3 335 3050x Cesar Chavez St 6 3 1 2     6 Width 10ft   6009168.225740001 2100578.0507 37.7483048120351 -122.411063714243 (37.7483048120351, -122.411063714243)
117340 222838 3 335 3100x Cesar Chavez St 4 3 1 2     4 Width 10ft   6008897.709980001 2100576.69978 37.748285928947794 -122.41199905860701 (37.7482859289478, -122.411999058607)
119114 222806 3 335 3400x Cesar Chavez St 5 3 1 2     3 Width 10ft   6006951.5861 2100562.96476 37.748138834942296 -122.418727742984 (37.7481388349423, -122.418727742984)
130302 222816 3 335 3500x Cesar Chavez St 6 3 1 2     4 Width 10ft   6006226.8204 2100563.5564200003 37.748099626297204 -122.421234004258 (37.7480996262972, -122.421234004258)
132912 222776 3 335 2950x Cesar Chavez St 8 3 1 2     2     6009504.41429 2100580.51468 37.7483304247098 -122.40990135219 (37.7483304247098, -122.40990135219)
147384 222844 3 335 3100x Cesar Chavez St 14 3 1 2     3 Width 10ft   6008676.6905 2100575.48577 37.7482701926188 -122.412763254825 (37.7482701926188, -122.412763254825)
151226 222831 3 335 3300x Cesar Chavez St 8 3 1 2     4 Width 10ft   6007377.19749 2100569.29044 37.7481801578885 -122.417256437759 (37.7481801578885, -122.417256437759)
153216 222828 3 335 3300x Cesar Chavez St 5 3 1 2     4 Width 10ft   6007445.92362 2100568.5836 37.7481820833534 -122.417018734321 (37.7481820833534, -122.417018734321)
153800 222815 3 335 3500x Cesar Chavez St 5 3 1 2     1 Width 10ft   6006246.77566 2100563.7677 37.7481013314143 -122.42116501457 (37.7481013314143, -122.42116501457)
155021 222830 3 335 3300x Cesar Chavez St 7 3 1 2     5 Width 10ft   6007397.542119999 2100569.68358 37.7481823819289 -122.417186114357 (37.7481823819289, -122.417186114357)
157582 222822 3 335 3500x Cesar Chavez St 15 3 1 2     2 Width 10ft   6006028.774680001 2100543.7206599996 37.7480339946844 -122.42191743145399 (37.7480339946844, -122.421917431454)
158171 222817 3 335 3500x Cesar Chavez St 10 3 1 2     5 Width 10ft   6006145.22502 2100552.1939 37.7480638269962 -122.421515351753 (37.7480638269962, -122.421515351753)
158255 222780 3 335 2950x Cesar Chavez St 2 3 1 2     3     6009674.91221 2100582.2196400003 37.7483446600884 -122.409311892454 (37.7483446600884, -122.409311892454)
161196 222825 3 335 3200x Cesar Chavez St 5 3 1 2     3 Width 10ft   6008183.00365 2100572.10257 37.748233181035104 -122.414470176157 (37.7482331810351, -122.414470176157)
163812 222779 3 335 2950x Cesar Chavez St 3 3 1 2     4     6009657.1726 2100582.18465 37.7483435701032 -122.40937323338301 (37.7483435701032, -122.409373233383)
165397 222821 3 335 3500x Cesar Chavez St 14 3 1 2     2 Width 10ft   6006053.42295 2100544.76657 37.748038256564705 -122.421832272848 (37.7480382565647, -122.421832272848)
166206 222826 3 335 3200x Cesar Chavez St 6 3 1 2     3 Width 10ft   6008154.70095 2100571.67515 37.7482304174003 -122.414568016118 (37.7482304174003, -122.414568016118)
167079 222829 3 335 3300x Cesar Chavez St 6 3 1 2     3 Width 10ft   6007416.24383 2100569.3004099997 37.748182381931294 -122.417121417131 (37.7481823819313, -122.417121417131)
167752 222836 3 335 3050x Cesar Chavez St 5 3 1 2     4 Width 10ft   6009193.154069999 2100577.54159 37.7483048120374 -122.410977476444 (37.7483048120374, -122.410977476444)
168768 222841 3 335 3100x Cesar Chavez St 8 3 1 2     5 Width 10ft   6008807.15459 2100576.2579200002 37.7482796346101 -122.412312166586 (37.7482796346101, -122.412312166586)
169363 222778 3 335 2950x Cesar Chavez St 4 3 1 2     4     6009634.2446099995 2100581.8585900003 37.7483413901636 -122.409452495138 (37.7483413901636, -122.409452495138)
171532 222820 3 335 3500x Cesar Chavez St 13 3 1 2     3 Width 10ft   6006079.97911 2100547.63598 37.748047632887705 -122.421740646313 (37.7480476328877, -122.421740646313)
178654 222819 3 335 3500x Cesar Chavez St 12 3 1 2     2 Width 10ft   6006102.45265 2100549.0367799997 37.7480527464562 -122.42166303303001 (37.7480527464562, -122.42166303303)
178690 222809 3 335 3400x Cesar Chavez St 8 3 1 2     3 Width 10ft   6006905.75522 2100562.66292 37.748135425630394 -122.418886203547 (37.7481354256304, -122.418886203547)
182508 222827 3 335 3300x Cesar Chavez St 4 3 1 2     5 Width 10ft   6007469.113419999 2100569.02723 37.748184605929204 -122.41693857595399 (37.7481846059292, -122.416938575954)
186445 222811 3 335 3400x Cesar Chavez St 13 3 1 2     4 Width 10ft   6006785.0700900005 2100560.48159 37.748122639944704 -122.419303374748 (37.7481226399447, -122.419303374748)
136109 223862 3 325 3700x Cesar Chavez St 1 3 1 2     6 Width 10ft   6005812.2615 2100535.54919 37.7479993446903 -122.42266554600401 (37.7479993446903, -122.422665546004)
183989 223863 3 325 3700x Cesar Chavez St 2 3 1 2     9 Width 10ft   6005802.979169999 2100534.20381 37.7479951268836 -122.422697548374 (37.7479951268836, -122.422697548374)
56501 190642 3 322 180x Bay Shore Blvd 2 3 1 2     4     6011171.25582 2099566.12799 37.7456384147754 -122.404066047117 (37.7456384147754, -122.404066047117)
69752 219170 3 322 1485x Northwood Dr 2 3 1 2     26     5995884.37538 2093916.02711 37.729258640557106 -122.45651695051501 (37.7292586405571, -122.456516950515)
149672 190645 3 322 1427x Innes Ave 10 3 1 2     25     6016289.875580001 2096646.78665 37.737907162586396 -122.38616298323 (37.7379071625864, -122.38616298323)
172713 219171 3 322 1485x Northwood Dr 3 3 1 2     7     5995877.5181599995 2093932.37838 37.72930314352 -122.456541838346 (37.72930314352, -122.456541838346)
176097 190644 3 322 1427x Innes Ave 8 3 1 2     26     6016311.73446 2096627.56435 37.7378555918516 -122.38608606604299 (37.7378555918516, -122.386086066043)
23725 234421 3 319 1500x Dolores St 7 3 1 2     13     6005260.39309 2099383.33918 37.7448044887417 -122.42449194134701 (37.7448044887417, -122.424491941347)
42786 234419 3 319 200x Dolores St 3 3 1 2     23     6004837.25989 2107079.17093 37.765911535819896 -122.426502931588 (37.7659115358199, -122.426502931588)
50677 234420 3 319 200x Dolores St 4 3 1 2     23     6004838.40305 2107062.4953799997 37.7658658133753 -122.426497790147 (37.7658658133753, -122.426497790147)
27784 177494 3 315 1002x Naples St 8 3 1 2     1     6001533.96245 2088133.73568 37.7137045060241 -122.43657215399901 (37.7137045060241, -122.436572153999)
51303 116542 3 315 1002x Naples St 5 3 1 2     3 3x3   6001553.5279 2088171.08536 37.7138081717955 -122.436507200445 (37.7138081717955, -122.436507200445)
137930 116541 3 315 1041x Naples St 4 3 1 2     1 3x3   6001548.78537 2088145.26253 37.7137369985308 -122.436521745206 (37.7137369985308, -122.436521745206)
175406 191510 3 312 900x Carolina St 34 3 1 2     26     6012478.66144 2103273.09419 37.7558899046023 -122.399805455861 (37.7558899046023, -122.399805455861)
25864 211289 3 306 100x Idora Ave 8 3 1 2     5 Width 9ft   5995366.53481 2099407.6063200003 37.744307426259205 -122.45870456127399 (37.7443074262592, -122.458704561274)
26840 194523 3 306 900x Carolina St 72 3 1 2     3     6012512.869530001 2102814.17539 37.7546317206991 -122.399654931846 (37.7546317206991, -122.399654931846)
112600 113194 3 306 699X Noe St 1 3 1 2     12     6003039.779709999 2104315.51778 37.7582214335608 -122.432522620301 (37.7582214335608, -122.432522620301)
135702 211288 3 306 800x Miramar Ave 6 3 1 2     16     5995401.87913 2094414.4819 37.7305995639058 -122.458221033587 (37.7305995639058, -122.458221033587)
32869 189966 3 299 900x Carolina St 73 3 1 2     1     6012515.82864 2102790.5172099997 37.754566925442795 -122.39964303739201 (37.7545669254428, -122.399643037392)
70532 190081 3 278 1700x Quesada Ave 44 3 1 2     4     6014340.94145 2095303.98967 37.734112055908604 -122.392807541432 (37.7341120559086, -122.392807541432)
74497 190073 3 278 1700x Quesada Ave 35 3 1 2     1     6014423.28579 2095240.49948 37.7339422980969 -122.392518409417 (37.7339422980969, -122.392518409417)
147232 190067 3 278 1150x Tennessee St 12 3 1 2     1 Width 8ft   6015567.2875 2103497.11447 37.7566767169834 -122.389139526978 (37.7566767169834, -122.389139526978)
160097 190072 3 278 1700x Quesada Ave 34 3 1 2     1     6014428.21738 2095237.1411700002 37.7339333507341 -122.392501124441 (37.7339333507341, -122.392501124441)
41518 203592 3 274 1485x Northwood Dr 1 3 1 2     2     5995892.33391 2093907.44512 37.729235533389705 -122.45648881700899 (37.7292355333897, -122.456488817009)
42524 189228 3 274 1300x De Haro St 16 3 1 2     1     6012274.4793300005 2102155.74686 37.752810527903 -122.40043310802 (37.752810527903, -122.40043310802)
162948 250141 3 265 2550x Lyon St 9 3 1 2     8     5999216.75628 2117624.1444599996 37.79454597318011 -122.446701808162 (37.7945459731801, -122.446701808162)
153771 199428 3 253 1427x Innes Ave 6 3 1 2     10     6016347.26409 2096602.7687900001 37.7377894745941 -122.385961493726 (37.7377894745941, -122.385961493726)
135366 217818 3 247 1x Junipero Serra Blvd 5 3 1 2     37     5991630.64581 2095733.14753 37.7340028647425 -122.471354673377 (37.7340028647425, -122.471354673377)
24866 189991 3 246 1427x Innes Ave 18 3 1 2     20     6016204.83732 2096710.6252 37.7380777432808 -122.386461454743 (37.7380777432808, -122.386461454743)
36635 189990 3 246 1427x Innes Ave 16 3 1 2     17     6016227.39671 2096690.1847299999 37.7380228666701 -122.386382030231 (37.7380228666701, -122.386382030231)
185837 189989 3 246 1427x Innes Ave 7 3 1 2     4     6016321.76004 2096621.1016 37.737838401311706 -122.386050952014 (37.7378384013117, -122.386050952014)
54821 246877 3 243 3090x Market St 10 3 1 2     8     5999897.283969999 2105334.9627099996 37.760841873084004 -122.443463930427 (37.760841873084, -122.443463930427)
61666 246880 3 243 3090x Market St 13 3 1 2     9     5999883.5078300005 2105331.77962 37.7608323474605 -122.44351134718201 (37.7608323474605, -122.443511347182)
64328 246881 3 243 3090x Market St 14 3 1 2     6     5999878.735309999 2105330.61775 37.760828885074204 -122.443527769696 (37.7608288850742, -122.443527769696)
70975 246878 3 243 3090x Market St 11 3 1 2     10     5999893.61927 2105333.85578 37.760838624734 -122.443476525446 (37.760838624734, -122.443476525446)
71259 246882 3 243 3090x Market St 15 3 1 2     13     5999873.9494900005 2105329.5043 37.7608255548764 -122.443544241685 (37.7608255548764, -122.443544241685)
155162 246879 3 243 3090x Market St 12 3 1 2     7     5999888.19644 2105332.59474 37.760834852969296 -122.443495189965 (37.7608348529693, -122.443495189965)
169178 246876 3 243 3090x Market St 9 3 1 2     5     5999901.9935099995 2105335.75905 37.7608443282147 -122.44344769946998 (37.7608443282147, -122.44344769947)
183939 246883 3 243 3090x Market St 16 3 1 2     10     5999870.066869999 2105328.2836599997 37.76082198187 -122.443557582215 (37.76082198187, -122.443557582215)
27904 210220 3 239 198x San Anselmo Ave 17 3 1 2     15     5993632.14987 2096264.78649 37.7355781918881 -122.464473499973 (37.7355781918881, -122.464473499973)
Powered by Datasette · Query took 15.648ms · Data source: data.sfgov.org