trees

Custom SQL query returning 101 rows (hide)

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
118 236256 1 27 151 Valencia St 1 : Tree 2     9 Width 4ft   6006073.15075 2108915.83898 37.7710243776945 -122.422358744984 (37.7710243776945, -122.422358744984) 8 2 9 28853 19
138 203559 1 65 145 Lakeview Ave 1 : Tree 2     1 Width 3ft   5997146.51683 2089373.33367 37.7168578537955 -122.45182605794 (37.7168578537955, -122.45182605794) 9 8 6 28861 24
146 190658 1 45 1461 Fairfax Ave 4 : Tree 2     7 Width 3ft   6016241.73559 2097685.48667 37.7407565574799 -122.386401828788 (37.7407565574799, -122.386401828788) 10 3 8 58 1
147 198543 1 31 1700 Newcomb Ave 1 : Tree 2     3 Width 0ft   6014375.16951 2096346.21278 37.7369756879815 -122.392762090617 (37.7369756879815, -122.392762090617) 10 3 8 58 1
152 235666 1 7 1301 Jessie St 4 : Tree 2     3 Width 2ft   6006462.25734 2109005.38337 37.7712921868165 -122.421019169707 (37.7712921868165, -122.421019169707) 8 2 9 28853 19
211 196303 1 7 249 Shipley St 1 : Tree 2     1 Width 5ft   6011469.59111 2111688.37468 37.7789400547713 -122.403887319468 (37.7789400547713, -122.403887319468) 14 2 9 28856 34
219 131064 1 58 1877 Greenwich St 1 : Tree 2     3 Width 4ft   6003926.06281 2119346.70194 37.7995435588443 -122.430529985984 (37.7995435588443, -122.430529985984) 13 9 1 57 17
252 204152 1 14 900 Junipero Serra Blvd 37 : Tree 2     1 Width 0ft   5991169.92245 2090751.38969 37.7202975393725 -122.472584434247 (37.7202975393725, -122.472584434247) 9 8 4 64 40
272 232035 1 10 39 Scott St 1 : Tree 2     5 Width 3ft   6002379.25876 2108512.04182 37.769706587622 -122.435107129612 (37.769706587622, -122.435107129612) 15 5 5 29492 9
274 232433 1 9 100 Church St 2 : Tree 2     7 Width 3ft   6004078.25972 2108290.75217 37.7691953086514 -122.429214555715 (37.7691953086514, -122.429214555715) 7 9 5 28862 3
278 247719 1 27 12 Broderick St 1 : Tree 2     2 Width 3ft   6001402.47389 2108783.95066 37.770397668046 -122.438505276404 (37.770397668046, -122.438505276404) 15 5 11 29492 9
291 210733 1 9 239 Ramsell St 1 : Tree 2     7 Width 3ft   5992956.15258 2088805.34296 37.7150573966491 -122.466268722147 (37.7150573966491, -122.466268722147) 9 8 6 64 24
310 218546 1 1 25 Elmhurst Dr 5 : Tree 2     7 Width 3ft   5991216.07157 2094485.7269 37.730553771324 -122.472697049151 (37.730553771324, -122.472697049151) 9 8 4 64 40
312 201949 1 7 1650 Carroll Ave 18 : Tree 2     2 Width 3ft   6013468.57071 2092447.06427 37.7262190300648 -122.395623522912 (37.7262190300648, -122.395623522912) 10 3 8 58 1
317 189161 1 89 109 Kissling St 4 : Tree 2     2 Width 3ft   6008149.50016 2109391.65635 37.7724477670719 -122.415210253457 (37.7724477670719, -122.415210253457) 8 2 9 28853 19
318 190050 1 90 601 Amador St 1 : Tree 2     6 Width 3ft   6016946.57228 2099501.56467 37.7457821291547 -122.384091181786 (37.7457821291547, -122.384091181786) 10 3 8 58 1
320 228444 1 45 399 Haight St 1 : Tree 2     4 Width 3ft   6004268.91864 2109406.82097 37.7722705538615 -122.428634644993 (37.7722705538615, -122.428634644993) 7 9 11 28852 10
326 228441 1 45 419 Haight St 1 : Tree 1   04/08/2008 12:00:00 AM 6 Width 3ft   6004104.36681 2109385.12417 37.7722016657998 -122.429202297052 (37.7722016657998, -122.429202297052) 7 9 11 29492 10
328 197129 1 83 400 Newhall St 11 : Tree 2     5 Width 3ft   6015974.4503 2097856.83037 37.7412122331485 -122.387337958305 (37.7412122331485, -122.387337958305) 10 3 8 58 1
330 250773 1 18 259 32nd Ave 1 : Tree 2     14 Width 3ft   5985865.92055 2114194.89594 37.7843585636424 -122.492644052605 (37.7843585636424, -122.492644052605) 11 6 1 55 33
331 194117 1 92 2 13th St 9 : Tree 2     2 Width 3ft   6009035.07102 2108345.44011 37.7696248302591 -122.412073015253 (37.7696248302591, -122.412073015253) 8 4 9 28853 19
356 233580 1 95 1317 Clayton St 1 : Tree 2     6 Width 3ft   5999035.80578 2105154.14715 37.7602962318988 -122.44643038196 (37.7602962318988, -122.44643038196) 15 5 5 28862 12
368 234039 1 36 93 Scott St 1 : Tree 2     12 Width 4ft   6002347.86623 2108745.44445 37.7703456710482 -122.435232412346 (37.7703456710482, -122.435232412346) 15 5 5 29492 9
372 189871 1 5 400 Newhall St 9 : Tree 2     7 Width 3ft   6016028.58203 2097927.48174 37.7414092251604 -122.387155715173 (37.7414092251604, -122.387155715173) 10 3 8 58 1
409 187885 1 75 1600 Indiana St 23 : Tree 2     3 Width 3ft   6015152.38977 2100397.43257 37.748142637288 -122.390357841268 (37.748142637288, -122.390357841268) 10 3 8 58 1
411 247779 1 1 254 30th St 1 : Tree 2     6 Width 3ft   6004930.81683 2098452.72536 37.7422306182373 -122.42556533529 (37.7422306182373, -122.42556533529) 2 7 5 63 22
418 191568 1 11 1610 Innes Ave 7 : Tree 2     6 Width 3ft   6015230.3015 2097471.78413 37.7401137346697 -122.389884091895 (37.7401137346697, -122.389884091895) 10 3 8 58 1
437 202267 1 7 28 Orsi Cir 1 : Tree 2     5 Width 2ft   6013033.98272 2093207.99375 37.7282842035544 -122.397179214247 (37.7282842035544, -122.397179214247) 10 3 8 58 1
440 204255 1 106 40 Rossmoor Dr 1 : Tree 2     2 Width 3ft   5991076.25798 2094451.16026 37.7304507656815 -122.473177880653 (37.7304507656815, -122.473177880653) 9 8 4 64 40
441 200380 1 11 199x Shipley St 2 : Tree 2     7 Width 2ft   6011866.27149 2112076.32254 37.7800274232626 -122.402542323073 (37.7800274232626, -122.402542323073) 6 2 9 28856 34
457 198704 1 98 1675 Bay Shore Blvd 2 : Tree 2     11 Width 3ft   6012158.49704 2090987.28634 37.7221378175792 -122.400049934761 (37.7221378175792, -122.400049934761) 10 3 8 58 1
469 245799 1 108 50 Church St 1 : Tree 2     21 Width 6ft   6004070.93701 2108481.83175 37.7697195522468 -122.429253511635 (37.7697195522468, -122.429253511635) 7 9 5 29492 10
472 221573 1 110 40 Elgin Park 1 : Tree 2     1 Width 3ft   6005806.54195 2108839.22973 37.7707989842145 -122.423275507581 (37.7707989842145, -122.423275507581) 8 2 5 28853 19
473 175337 1 14 114 De Long St 4 : Tree 2     14 Width 3ft   5994455.45704 2086824.92953 37.7097060419823 -122.460943071888 (37.7097060419823, -122.460943071888) 9 8 6 28861 25
480 225991 1 22 99 Laussat St 2 : Tree 2     1 Width 3ft   6004313.0789 2109253.93974 37.7718532783246 -122.428470991768 (37.7718532783246, -122.428470991768) 7 9 11 28852 10
482 175383 1 14 3001 Ocean Ave 1 : Tree 2     8 Width 3ft   5989487.94212 2095224.7734 37.7324828171076 -122.478725410769 (37.7324828171076, -122.478725410769) 1 8 4 64 35
648 189633 1 38 45 11th St 10 : Tree 2     10 Width 3ft   6007281.55408 2110475.16176 37.775373998252 -122.418289406239 (37.775373998252, -122.418289406239) 8 2 9 28853 34
649 189627 1 38 45 11th St 4 : Tree 2     16 Width 3ft   6007528.52851 2110215.72509 37.7746755460784 -122.417416671761 (37.7746755460784, -122.417416671761) 8 2 9 28853 34
806 189267 1 8 1300 Fairfax Ave 6 : Tree 2     1 Width 4ft   6017011.55747 2097196.03632 37.7394552087924 -122.383705980546 (37.7394552087924, -122.383705980546) 10 3 8 58 1
832 211486 1 143 300 Junipero Serra Blvd 17 : Tree 2     56 Width 0ft   5991389.83684 2094502.84602 37.7306108333036 -122.47209757005 (37.7306108333036, -122.47209757005) 9 8 4 64 40
1021 213351 1 40 752 Head St 1 : Tree 2     3 Width 3ft   5993534.80603 2090819.23886 37.7206204409725 -122.464414798499 (37.7206204409725, -122.464414798499) 9 8 6 64 24
1024 200362 1 145 1300 Phelps St 3 : Tree 2     7 Width 5ft   6014166.7855 2096532.27247 37.7374749933851 -122.393495590258 (37.7374749933851, -122.393495590258) 10 3 8 58 1
1042 189625 1 38 45 11th St 2 : Tree 2     18 Width 3ft   6007555.58457 2110185.16197 37.7745931492825 -122.417320912844 (37.7745931492825, -122.417320912844) 8 2 9 28853 34
1113 188226 1 106 1350 19th St 3 : Tree 2   11/01/1996 12:00:00 AM 6 Width 3ft Permit Number 37286 6013575.41694 2105253.06849 37.7613875637091 -122.396151246903 (37.7613875637091, -122.396151246903) 10 3 8 28856 29
1115 238053 1 40 426 Lily St 2 : Tree 2     9 Width 3ft   6004459.53739 2109991.59452 37.7738869854343 -122.428016956418 (37.7738869854343, -122.428016956418) 7 9 11 28852 10
1258 190419 1 22 1300 Evans Ave 15 : Tree 2   05/01/2017 12:00:00 AM 3 Width 3ft   6017844.32202 2096957.74462 37.7388469037738 -122.380810054756 (37.7388469037738, -122.380810054756) 10 3 8 58 1
1289 190652 1 45 310 Arkansas St 1 : Tree 2     8 Width 3ft   6012893.9262 2105541.86403 37.7621425904374 -122.398528520183 (37.7621425904374, -122.398528520183) 10 3 8 28856 29
1454 247689 1 64 2 Central Ave 4 : Tree 2     24 Width 4ft   5999999.2126 2108392.11953 37.7692418764422 -122.443330996248 (37.7692418764422, -122.443330996248) 15 5 11 29492 9
1550 201970 1 7 1651 Carroll Ave 21 : Tree 2     3 Width 3ft   6013765.00423 2092206.62002 37.7255753034535 -122.39458193082 (37.7255753034535, -122.39458193082) 10 3 8 58 1
1688 213308 1 40 219 Tara St 1 : Tree 2     3 Width 3ft   5997858.51511 2090428.83634 37.7197967734736 -122.44944104777 (37.7197967734736, -122.44944104777) 9 8 6 28861 24
1727 249457 1 9 201 Olive St 2 : Tree 2     11 Width 4ft   6006319.82833 2113698.46294 37.7841702168319 -122.421845255461 (37.7841702168319, -122.421845255461) 7 9 11 28858 41
1839 227130 1 6 200 Portola Dr 2 : Tree 2     3 Width 3ft   5999573.30223 2100550.73469 37.7476870722101 -122.444240631696 (37.7476870722101, -122.444240631696) 2 4 5 63 38
1925 250092 1 95 1698 Gough St 1 : Tree 2     6 Width 3ft   6005353.59952 2115427.24795 37.7888624934521 -122.425311128409 (37.7888624934521, -122.425311128409) 13 9 1 28858 41
2067 211204 1 15 700 Junipero Serra Blvd 150 : Tree 2     8 Width 0ft   5991184.95958 2091479.43645 37.7222974463483 -122.472585508941 (37.7222974463483, -122.472585508941) 9 8 4 64 40
2070 213331 1 40 151 Byxbee St 1 : Tree 2     6 Width 2ft   5991924.78555 2089552.62516 37.7170496899626 -122.469887910591 (37.7170496899626, -122.469887910591) 9 8 6 64 24
2082 195047 1 27 360 06th St 2 : Tree 1   02/25/2002 12:00:00 AM 3 Width 3ft Permit Number 42039 6011214.59355 2111232.18316 37.7776732094966 -122.404737337955 (37.7776732094966, -122.404737337955) 14 2 9 28853 34
2322 218250 1 27 2751 14th Ave 1 : Tree 2     14 Width 3ft   5992235.80201 2097238.62713 37.738171520993 -122.469372026199 (37.738171520993, -122.469372026199) 1 8 4 59 40
2378 239239 1 83 101 Scott St 1 : Tree 2     20 Width 6ft   6002329.06188 2108869.34471 37.7706848027038 -122.435306320439 (37.7706848027038, -122.435306320439) 15 5 11 29492 9
2432 250771 1 58 244 32nd Ave 1 : Tree 2     8 Width 3ft   5985908.77802 2114250.76348 37.7845144656071 -122.492499898474 (37.7845144656071, -122.492499898474) 11 6 1 55 33
2464 190663 1 45 1360 Fairfax Ave 5 : Tree 2     2 Width 3ft   6016747.40621 2097393.16894 37.7399818904553 -122.384633036796 (37.7399818904553, -122.384633036796) 10 3 8 58 1
2491 193810 1 16 285 Texas St 3 : Tree 2     10 Width 3ft   6013775.34661 2105819.12575 37.7629529551453 -122.395499427275 (37.7629529551453, -122.395499427275) 14 3 8 28856 29
2505 196318 1 7 323 11th St 1 : Tree 2     4 Width 3ft   6008553.79261 2109149.29537 37.7718050135221 -122.413794615322 (37.7718050135221, -122.413794615322) 8 2 9 28853 34
2617 247759 1 25 75 Alpine Ter 1 : Tree 2     10 Width 3ft   6001668.74952 2108376.80716 37.7692948959648 -122.437555068929 (37.7692948959648, -122.437555068929) 15 5 5 29492 9
2621 202038 1 83 75 Crane St 2 : Tree 2     2 Width 3ft   6012275.87253 2090920.17769 37.7219600944649 -122.399639484201 (37.7219600944649, -122.399639484201) 10 3 8 58 1
2766 247224 1 91 135 Divisadero St 1 : Tree 2   08/07/2019 12:00:00 AM 3 Width 3ft   6001887.60725 2108459.11842 37.7695333431173 -122.436803945272 (37.7695333431173, -122.436803945272) 15 5 5 29492 9
2787 194758 1 36 750 Phelps St 43 : Tree 2     1 Width 2ft   6015105.78884 2097790.25184 37.740981275571 -122.390336854658 (37.740981275571, -122.390336854658) 10 3 8 58 1
2811 246987 1 7 70 Clipper St 1 : Tree 2     11 Width 3ft   6004726.23458 2101068.69852 37.7494019174823 -122.426458941248 (37.7494019174823, -122.426458941248) 2 4 5 28862 22
2850 178600 1 27 200 Winston Dr 6 : Tree 2     6 Width 0ft   5989476.93903 2093627.59215 37.7280967254778 -122.478646687712 (37.7280967254778, -122.478646687712) 1 8 4 64 14
3047 189052 1 38 1498 Fairfax Ave 9 : Tree 2   04/13/2020 12:00:00 AM 3 Width 4ft   6016122.19881 2097851.77649 37.7412065377553 -122.386826739572 (37.7412065377553, -122.386826739572) 10 3 8 58 1
3132 241639 1 1 200 Guerrero St 1 : Tree 2     4 Width 2ft   6005424.1713 2107755.72538 37.7678023541299 -122.424521053307 (37.7678023541299, -122.424521053307) 8 4 5 28853 19
3164 249333 1 38 840 Post St 4 : Tree 2     15 Width 4ft   6008047.50765 2114838.3401 37.7873973224712 -122.415948831592 (37.7873973224712, -122.415948831592) 13 1 10 28858 21
3177 191238 1 6 1600 Newhall St 8 : Tree 2     2 Width 2ft   6014118.19632 2095356.58877 37.7342441078693 -122.393581327137 (37.7342441078693, -122.393581327137) 10 3 8 58 1
3192 247788 1 70 0 30th St 4 : Tree 2     14 Width 3ft   6004361.25599 2098418.69842 37.7421049892529 -122.427532277614 (37.7421049892529, -122.427532277614) 2 7 5 63 22
3314 193435 1 49 600 Missouri St 1 : Tree 2     7 Width 3ft   6013537.44197 2104295.86136 37.7587571690323 -122.396215498963 (37.7587571690323, -122.396215498963) 10 3 8 28856 29
3340 192835 1 19 333 03rd St 5 : Tree 2     1 Width 2ft   6013082.87743 2113319.47205 37.7835086710412 -122.398420759824 (37.7835086710412, -122.398420759824) 6 2 9 28856 6
3344 197494 1 91 401 Texas St 3 : Tree 2     23 Width 7ft   6013811.84722 2105166.53521 37.7611631145139 -122.395327465206 (37.7611631145139, -122.395327465206) 10 3 8 28856 29
3377 227135 1 6 200 Portola Dr 11 : Tree 2     2 Width 3ft   5999460.85655 2100362.14837 37.7471628438967 -122.444615908893 (37.7471628438967, -122.444615908893) 2 4 5 63 38
3538 249405 1 27 430 Turk St 1 : Tree 2     8 Width 4ft   6007893.39158 2113084.10787 37.7825719605735 -122.416357743418 (37.7825719605735, -122.416357743418) 7 10 9 28852 36
3586 217748 1 11 611 Frederick St 1 : Tree 2     6 Width 3ft   5996609.14457 2107297.9343 37.766043624629 -122.45497792451 (37.766043624629, -122.45497792451) 15 5 11 29492 12
3615 190055 1 90 601 Amador St 7 : Tree 2     6 Width 3ft   6017078.53264 2099510.1323 37.7458129489113 -122.383635473719 (37.7458129489113, -122.383635473719) 10 3 8 58 1
3646 189251 1 8 120 Loomis St 1 : Tree 2     1 Width 4ft   6010844.92077 2097998.29295 37.7413152397136 -122.405084094075 (37.7413152397136, -122.405084094075) 10 3 8 58 1
3743 193316 1 13 136 Hawthorne St 2 : Tree 2     9 Width 2ft   6013300.83104 2113672.81478 37.7844910077044 -122.397691511273 (37.7844910077044, -122.397691511273) 6 2 9 28856 6
3805 250547 1 58 120 El Camino Del Mar 2 : Tree 2     2 Width 4ft   5988224.27982 2115368.83764 37.7877194875147 -122.484571190206 (37.7877194875147, -122.484571190206) 11 6 1 55 33
3807 204110 1 14 500 Junipero Serra Blvd 24 : Tree 2     3 Width 0ft   5991353.72908 2093672.35856 37.7283284331018 -122.472161885976 (37.7283284331018, -122.472161885976) 9 8 4 64 40
3820 247644 1 187 390 Ogden Ave 4 : Tree 2     3 Width 3ft   6008136.34334 2096071.82568 37.7358737936308 -122.414313159039 (37.7358737936308, -122.414313159039) 2 7 7 28859 2
3999 213261 1 16 255 Ramsell St 1 : Tree 2     7 Width 3ft   5992959.15066 2088902.16567 37.7153234215169 -122.466265391939 (37.7153234215169, -122.466265391939) 9 8 6 64 24
4014 201331 1 10 95 Bitting Ave 2 : Tree 2     6 Width 2ft   6012535.62971 2092785.01018 37.7270950209928 -122.398872378676 (37.7270950209928, -122.398872378676) 10 3 8 58 1
4100 204072 1 14 216 Arch St 1 : Tree 2   04/14/2020 12:00:00 AM 3 Width 3ft Permit Number 767875 5992726.82301 2088588.57169 37.7144489603362 -122.467045625763 (37.7144489603362, -122.467045625763) 9 8 6 64 24
4277 192886 1 19 2 Rizal St 7 : Tree 2     9 Width 3ft   6012771.99776 2112717.29257 37.7818379024256 -122.399453999917 (37.7818379024256, -122.399453999917) 6 2 9 28856 34
4292 190709 1 50 715 Wisconsin St 1 : Tree 2     11 Width 3ft   6012742.49696 2104176.10053 37.7583840672751 -122.398956396912 (37.7583840672751, -122.398956396912) 10 3 8 28856 29
4543 206871 1 41 700 Junipero Serra Blvd 167 : Tree 2     28 Width 0ft   5991178.39011 2091334.01969 37.7218977876304 -122.472597620991 (37.7218977876304, -122.472597620991) 9 8 4 64 40
4551 189261 1 8 2215 Newcomb Ave 1 : Tree 2     1 Width 3ft   6011901.66973 2098145.68488 37.7417789652237 -122.401440561855 (37.7417789652237, -122.401440561855) 10 3 8 58 1
4565 187804 1 110 1022 Minna St 8 : Tree 2     3 Width 3ft   6007516.81394 2109678.2468 37.7731990993886 -122.417419096312 (37.7731990993886, -122.417419096312) 8 2 9 28853 19
4676 204157 1 14 900 Junipero Serra Blvd 109 : Tree 2     2 Width 0ft   5991141.76494 2090345.59901 37.7191817082419 -122.472652193669 (37.7191817082419, -122.472652193669) 9 8 4 64 40
4812 198517 1 31 1763 Newcomb Ave 2 : Tree 2     5 Width 7ft   6014346.73951 2096322.78373 37.7369097775472 -122.392858747949 (37.7369097775472, -122.392858747949) 10 3 8 58 1
4823 190051 1 90 601 Amador St 2 : Tree 2     5 Width 3ft   6016961.70348 2099501.73786 37.7457834412444 -122.384038871819 (37.7457834412444, -122.384038871819) 10 3 8 58 1
5037 215607 1 99 900 Junipero Serra Blvd 47 : Tree 2     2 Width 0ft   5991157.54734 2090681.21679 37.7201041455671 -122.472622096933 (37.7201041455671, -122.472622096933) 9 8 4 64 40
5051 192939 1 19 1559 Howard St 3 : Tree 2     5 Width 3ft   6007881.70364 2109409.76028 37.7724824224706 -122.416137872687 (37.7724824224706, -122.416137872687) 8 2 9 28853 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
5120 197001 1 123 2 Napoleon St 16 : Tree 2     9 Width 4ft   6013598.90827 2100122.82985 37.7473023413409 -122.395710528743 (37.7473023413409, -122.395710528743) 10 3 8 58 1
5138 247774 1 14 222 30th St 1 : Tree 2     7 Width 3ft   6005147.38191 2098466.01095 37.7422793318144 -122.424817464458 (37.7422793318144, -122.424817464458) 2 7 5 63 22