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)
2101 117036 4 70 2220x SUTTER ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
2158 95238 4 36 1220 Noe St 5 Sidewalk: Curb side : Cutout Tree 4 DPW     3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
2220 117168 4 84 299x ALMA ST 5 Sidewalk: Curb side : Cutout Tree 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
2258 264781 4 127 90x Guy Pl 15 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
2279 264803 4 110 99 Rutland St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6010906 2089373 37.7176354050598 -122.404265973296 (37.7176354050598, -122.404265973296) 10 7 8 309 39
2280 116028 4 53 1500 PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6006937 2117734 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467) 13 9 10 28858 32
2335 262272 4 17 99X Glendale St   Unaccepted Street : Yard Tree 2       3x3   5999984 2103563 37.7559814441149 -122.443036761048 (37.7559814441149, -122.443036761048) 2 5 5 28862 38
2343 99661 4 70 1365 Portola Dr 2 Sidewalk: Curb side : Cutout Tree 2           5993416.2 2097683.7 37.7394617231066 -122.465323151466 (37.7394617231066, -122.465323151466) 1 8 4 59 40
2361 256460 4 16 2901 Sunset Blvd 9 Median : Yard Tree 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
2398 262570 4 72 1801 03rd St 20 Sidewalk: Curb side : Cutout Tree 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
2450 251744 4 8 70 Winding Way 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6002620 2086992 37.710631205907 -122.432736905509 (37.710631205907, -122.432736905509) 9 7 6 28861 5
2589 262566 4 72 1801 03rd St 16 Sidewalk: Curb side : Cutout Tree 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
2670 262494 4 40 41 Miraloma Dr 1 Sidewalk: Property side : Cutout Tree 2       3x3   5994945 2097531 37.7391304944698 -122.4600262078 (37.7391304944698, -122.4600262078) 9 7 4 59 40
2879 261758 4 1 49 Bache St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6007215 2095432 37.7340651744382 -122.417453284567 (37.7340651744382, -122.417453284567) 2 7 7 28859 2
2911 258680 4 48 2824 21st St   Sidewalk: Curb side : Cutout Tree 2       3x3   6009247 2103976 37.7576392372832 -122.411031286576 (37.7576392372832, -122.411031286576) 2 4 7 28859 19
2913 264905 4 1 259 Clara St 3 Median : Cutout Tree 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
2945 98684 4 16 40 Bay View St 1 Sidewalk: Curb side : Cutout Tree 2           6014207 2094775 37.7326521179743 -122.393233618799 (37.7326521179743, -122.393233618799) 10 3 8 58 1
3022 264768 4 76 90x Guy Pl 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
3033 121390 4 66 1301x 07th Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5993851 2106604 37.7639796518152 -122.464467327674 (37.7639796518152, -122.464467327674) 1 8 11 56 12
3085 262583 4 27 2801X 14th Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5992317 2097142 37.7379108993029 -122.469084256099 (37.7379108993029, -122.469084256099) 1 8 4 59 40
3144 113684 4 27 500X THE EMBARCADERO 18 Sidewalk: Curb side : Cutout Tree 1       3x3   6013440 2119057 37.7992824654164 -122.3975877866 (37.7992824654164, -122.3975877866) 3 1 10 28860 6
3197 261564 4 15 1801 25th St 9 Sidewalk: Property side : Yard Tree 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
3300 113370 4 27 88 HOWARD ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6014757 2116474 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575) 12 2 9 28855 6
3347 121153 4 62 50X Trumbull St 2 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 778630 6003754 2094198 37.7304815449788 -122.429331070998 (37.7304815449788, -122.429331070998) 9 7 6 28861 5
3419 259044 4 72 3649 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5981832 2098708 37.7415992976029 -122.505451458513 (37.7415992976029, -122.505451458513) 1 8 3 29491 35
3496 98500 4 16 1670 17th Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5990941.3 2104038.3 37.7567667631156 -122.474343775715 (37.7567667631156, -122.474343775715) 1 8 4 56 12
3509 99817 4 91 1134 Castro St 1 Sidewalk: Curb side : Cutout Tree 2       7x6   6002486 2102282 37.7526064609065 -122.434292449268 (37.7526064609065, -122.434292449268) 2 4 5 28862 22
3596 264801 4 9 350 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6011023 2089107 37.7169115603385 -122.403842847789 (37.7169115603385, -122.403842847789) 10 7 8 309 39
3606 262564 4 72 1801 03rd St 14 Sidewalk: Curb side : Cutout Tree 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
3645 254418 4 42 1245x Ingalls St 12 Sidewalk: Curb side : Cutout Tree 2       3x3   6017856 2093901 37.7304543311207 -122.380557270451 (37.7304543311207, -122.380557270451) 10 3 8 58 1
3669 103667 4 17 350X Hickory St 6 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
3681 106711 4 65 3990 FOLSOM ST   Sidewalk: Curb side : Cutout Tree 2       3x3   6008366.1 2096547.2 37.7371919715517 -122.413552407719 (37.7371919715517, -122.413552407719) 2 7 7 28859 2
3723 260511 4 7 199X Stratford Dr 1 Sidewalk: Property side : Cutout Tree 2       3x3   5990954 2091213 37.7215525064104 -122.47336445039 (37.7215525064104, -122.47336445039) 9 8 4 64 40
3728 264799 4 1 698 Dwight St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6009708 2091117 37.7223570514359 -122.408529889307 (37.7223570514359, -122.408529889307) 10 3 7 309 28
3775 262460 4 72 88 06th St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6009992 2112469 37.7810008079546 -122.409054015659 (37.7810008079546, -122.409054015659) 14 2 9 28853 34
3800 261425 4 17 1001 Potrero Ave 19 Sidewalk: Curb side : Cutout Tree 2       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
3804 117402 4 53 75x BEACH ST 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
3825 263630 4 16 1020 Baker St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6000550 2112598 37.7808215534457 -122.441727743189 (37.7808215534457, -122.441727743189) 15 5 1 29490 16
3845 105016 4 14 1099X 23rd St 2 Sidewalk: Curb side : Cutout Tree 2         Marked for a basin expansion. SB 6015050.3 2102960.5 37.755174615412 -122.390889970266 (37.755174615412, -122.390889970266) 10 3 8 28856 29
3863 113716 4 201 498x 21ST AVE 3 Sidewalk: Curb side : Cutout Tree 2       3x3   5989370 2112285 37.7793187899318 -122.480381451803 (37.7793187899318, -122.480381451803) 11 6 2 55 26
3865 105892 4 28 1100 Masonic Ave 3 Sidewalk: Curb side : Cutout Tree 2           5999444.5 2109060.1 37.7710443339737 -122.445297745357 (37.7710443339737, -122.445297745357) 15 5 11 29492 9
3872 262252 4 15 4210 Ocean Ave 5 Sidewalk: Property side : Yard Tree 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
3957 101709 4 1 95X Milton St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6003767.7 2095277.7 37.7334469335284 -122.429360672359 (37.7334469335284, -122.429360672359) 2 7 5 28861 25
4013 264857 4 19 800x Polk St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6007181 2113695 37.7842092359088 -122.41886565636 (37.7842092359088, -122.41886565636) 7 9 9 28858 36
4070 262551 4 103 1835 Owens St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6014708 2106994 37.7662307347547 -122.392355853292 (37.7662307347547, -122.392355853292) 14 3 9 310 29
4084 259522 4 37 309 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5994311 2099921 37.7456563517477 -122.462391578862 (37.7456563517477, -122.462391578862) 1 8 4 29491 40
4147 261430 4 17 1001 Potrero Ave 24 Sidewalk: Curb side : Cutout Tree 2       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
4185 262568 4 72 1801 03rd St 18 Sidewalk: Curb side : Cutout Tree 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
4197 262260 4 16 2 Everglade Dr 4 Sidewalk: Property side : Yard Tree 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
4200 262567 4 72 1801 03rd St 17 Sidewalk: Curb side : Cutout Tree 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
4227 109316 4 116 1516 BROADWAY 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6006331.3 2118082.2 37.7962075161748 -122.422117105361 (37.7962075161748, -122.422117105361) 13 9 10 28858 32
4232 264908 4 1 259 Clara St 6 Sidewalk: Curb side : Cutout Tree 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
4280 264767 4 44 90x Guy Pl 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
4298 262513 4 16 2230 Jerrold Ave 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6012281 2099339 37.74507671213 -122.400212745638 (37.74507671213, -122.400212745638) 10 3 8 58 1
4323 264887 4 44 99x South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6007378 2109480 37.7726469495053 -122.417885217611 (37.7726469495053, -122.417885217611) 8 2 9 28853 19
4337 106918 4 127 274 PUTNAM ST 1 Sidewalk: Curb side : Cutout Tree 2           6009044.8 2096077.1 37.7359392652864 -122.411172625582 (37.7359392652864, -122.411172625582) 10 7 7 28859 2
4356 262525 4 17 410 Alpha St 1 Sidewalk: Curb side : Cutout Tree 2 FUF     4x6   6010538 2087515 37.7125131447181 -122.405407212047 (37.7125131447181, -122.405407212047) 9 7 8 309 39
4382 264774 4 76 90x Guy Pl 8 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
4438 254757 4 35 2450 California St 13 Front Yard : Yard Tree 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
4474 109514 4 38 1501x FULTON ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6000537 2110949 37.7762930788063 -122.441654341711 (37.7762930788063, -122.441654341711) 15 5 11 29492 16
4476 112909 4 17 1899X Beach St 2 Sidewalk: Curb side : Cutout Tree 2                              
4509 262192 4 70 1799x 12th Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5992411 2103494 37.7553572944486 -122.469221443954 (37.7553572944486, -122.469221443954) 1 8 4 56 12
4569 104897 4 67 303 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
4589 261026 4 65 758 20th Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/18/2019 12:00:00 AM   3x3   5989802 2110189 37.7735888483109 -122.478733667362 (37.7735888483109, -122.478733667362) 11 6 2 55 26
4591 113471 4 54 450 CHURCH ST 28 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
4623 106966 4 17 2391 47TH AVE   Sidewalk: Curb side : Cutout Tree 2           5981720.8 2098834.4 37.7419398125124 -122.505845312535 (37.7419398125124, -122.505845312535) 1 8 3 29491 35
4645 107053 4 31 450 Walnut St 4 Sidewalk: Curb side : Cutout Tree 2           5998625.9783 2115075.11894 37.7875132600186 -122.448562297399 (37.7875132600186, -122.448562297399) 13 6 1 54 31
4670 107425 4 127 1600X Waller St 1 Sidewalk: Curb side : Cutout Tree 2           5997832.17799 2108247.26578 37.7687203321672 -122.450816174345 (37.7687203321672, -122.450816174345) 15 5 11 29492 9
4696 117040 4 122 2220x SUTTER ST 8 Sidewalk: Curb side : Cutout Tree 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
4754 101985 4 17 205X Rose St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6005538.6 2109749.6 37.7732835163003 -122.424267082997 (37.7732835163003, -122.424267082997) 7 9 11 28852 10
4853 107519 4 17 100x CHURCH ST   Sidewalk: Curb side : Cutout Tree 2           6004015.5 2108290.9 37.7691921614924 -122.429431648714 (37.7691921614924, -122.429431648714) 7 9 5 28862 3
4862 113857 4 67 1201 SAN BRUNO AVE 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6011184 2102716 37.7542879873687 -122.40424363426 (37.7542879873687, -122.40424363426) 10 4 8 28859 19
4872 262191 4 70 1799x 12th Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5992411 2103494 37.7553572944486 -122.469221443954 (37.7553572944486, -122.469221443954) 1 8 4 56 12
4883 264808 4 19 801x Folsom St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6012291 2112706 37.7817800743931 -122.401117244746 (37.7817800743931, -122.401117244746) 6 2 9 28856 34
4918 104883 4 15 132 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree 2           5990322.1 2090011.1 37.7182157760013 -122.475461023549 (37.7182157760013, -122.475461023549) 1 8 4 64 14
4964 104791 4 17 98X 29th St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6005767 2099074 37.7439837097913 -122.422718209223 (37.7439837097913, -122.422718209223) 2 7 5 28859 22
4983 112267 4 53 1X Geary St 1 Sidewalk: Curb side : Cutout Tree 2                              
5012 261384 4 48 246 Leavenworth St   Sidewalk: Curb side : Cutout Tree 2       3x3   6008558 2113314 37.7832405398106 -122.41407474629 (37.7832405398106, -122.41407474629) 7 10 9 28852 36
5017 262484 4 15 10X Alpha St 2 Median : Yard Tree 2       3x3   6011300 2088596 37.7155239289484 -122.402849469545 (37.7155239289484, -122.402849469545) 9 7 8 309 39
5054 102983 4 16 555 Turk St 10 Sidewalk: Curb side : Cutout Tree 2       3x3   6007348.4 2112963.4 37.7822098643106 -122.41823462296 (37.7822098643106, -122.41823462296) 7 9 9 28852 36
5100 101532 4 17 11323 Palou Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3                      
5249 100990 4 17 1675 Bryant St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
5250 264790 4 48 2640 25th St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6011026 2101818 37.7518134471323 -122.404726825793 (37.7518134471323, -122.404726825793) 10 4 8 28859 19
5279 258778 4 15 701X Ortega Way 1 Unaccepted Street : Yard Tree 2       10x10   5991876 2102480 37.7525421857889 -122.470997752755 (37.7525421857889, -122.470997752755) 1 8 4 29491 12
5330 121676 4 7 65 Sotelo Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5993867 2101351 37.7495571916966 -122.464030639739 (37.7495571916966, -122.464030639739) 1 8 4 29491 40
5372 256588 4 22 2x Stillman St 15 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
5429 116488 4 70 2149 LYON ST   Sidewalk: Curb side : Cutout Tree 2       3x3   5999319 2116238 37.7907458271484 -122.446248274058 (37.7907458271484, -122.446248274058) 13 6 1 29490 31
5493 264903 4 1 259 Clara St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
5495 260381 4 50 1924 Jennings St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6015697 2093053 37.7280065148754 -122.387962157958 (37.7280065148754, -122.387962157958) 10 3 8 58 1
5584 110379 4 62 2194 PALOU AVE 1 Sidewalk: Curb side : Cutout Tree 2       27x18   6011949 2097537 37.7401102866319 -122.401234145483 (37.7401102866319, -122.401234145483) 10 3 8 58 1
5644 264791 4 48 2640 25th St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6011026 2101818 37.7518134471323 -122.404726825793 (37.7518134471323, -122.404726825793) 10 4 8 28859 19
5714 259658 4 7 239 Stonecrest Dr 1 Sidewalk: Property side : Yard Tree 2       3x3   5990787 2092898 37.7261694250404 -122.474064598028 (37.7261694250404, -122.474064598028) 9 8 4 64 40
5722 255886 4 53 50 Columbia Square St 7 Sidewalk: Curb side : Cutout Tree 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
5731 261315 4 14 198 Austin St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6006408 2115479 37.789064104593 -122.421666719739 (37.789064104593, -122.421666719739) 13 9 10 28858 21
5748 115724 4 243 250x Octavia St 1 Side Yard : Yard Tree 7                              
5772 262554 4 72 1801 03rd St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
5856 104233 4 58 298X Shrader St 3 Sidewalk: Curb side : Cutout Tree 2       6x6   5997366.55609 2109687.30332 37.7726476392362 -122.452530652813 (37.7726476392362, -122.452530652813) 15 5 11 29492 16
6007 261051 4 27 770 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
6071 258212 4 1 2501 Irving St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5987967 2106401 37.7630813299835 -122.484803190012 (37.7630813299835, -122.484803190012) 1 8 3 56 35
6145 117568 4 17 2636 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree 2           5990923 2095039.4 37.7320570487265 -122.473750606168 (37.7320570487265, -122.473750606168) 1 8 4 64 40
6188 111792 4 53 55X SHERMAN ST 9 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34