Street_Tree_List

Data source: data.sfgov.org

1,505 rows where qSiteInfo = 3 sorted by qSpecies descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 823.557ms · Data source: data.sfgov.org