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)
2187 46061 7 17   103 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2189 48278 7 17   88 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2196 48265 7 17   129 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2200 54869 7 17 1967 Hayes St 1 Sidewalk: Curb side : Cutout Tree 2   08/17/1972 12:00:00 AM     Permit Number 10729 5998462.86042081 2109983.76069669 37.773524386553 -122.448759792732 (37.773524386553, -122.448759792732) 15 5 11 29492 16
2203 45984 7 17   123 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2204 92844 7 14 198 Anderson St 4 Sidewalk: Curb side : Cutout Tree 2   12/11/2009 12:00:00 AM     Permit Number 53065 6007909 2097721 37.7403892908842 -122.415215881965 (37.7403892908842, -122.415215881965) 2 7 7 28859 2
2210 53264 7 17 523 Head St 1 Sidewalk: Curb side : Cutout Tree 2   07/28/1969 12:00:00 AM     Permit Number 6154 5993474.77624345 2089341.33970508 37.7165590253308 -122.464515046881 (37.7165590253308, -122.464515046881) 9 8 6 64 24
2216 63596 7 17 253 Wallber St 1 Sidewalk: Curb side : Cutout Tree 2   05/05/1987 12:00:00 AM     Permit Number 24230                    
2225 44536 7 17   33 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2226 44987 7 17   59 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2228 48000 7 16 1901 16th Ave 4 Sidewalk: Curb side : Cutout Tree 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45728 5991233.33873947 2102463.46573508 37.752459596695 -122.47321895744 (37.752459596695, -122.47321895744) 1 8 4 29491 12
2241 46289 7 196   14 Sidewalk: Curb side : Cutout Tree 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
2246 67733 7 95 1373 12th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/12/1992 12:00:00 AM     Permit Number 31352 5992380.40422552 2106114.34696678 37.7625503119139 -122.469517989556 (37.7625503119139, -122.469517989556) 1 8 11 56 12
2263 31189 7 45 744 Shields St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34885 5992088.16257343 2089881.74957895 37.7179628280945 -122.469347142572 (37.7179628280945, -122.469347142572) 9 8 6 64 24
2265 48308 7 17   174 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2267 46716 7 14   3 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
2269 58628 7 17 1240 Cole St 1 Sidewalk: Curb side : Cutout Tree 2   04/04/1979 12:00:00 AM     Permit Number 17846 5998229.96040674 2106129.9560019 37.7629294984974 -122.449287716214 (37.7629294984974, -122.449287716214) 15 5 11 29492 9
2275 46014 7 17   200 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2277 44912 7 17   185 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2283 49626 7 11 152211th/10th Houston St 1 Sidewalk: Curb side : Cutout Tree 2   05/13/2003 12:00:00 AM     Permit Number 46481                    
2287 63935 7 17 4086 26th St 1 Sidewalk: Curb side : Cutout Tree 2   10/19/1992 12:00:00 AM     Permit Number 31216 6003335.30229838 2100703.31540535 37.7483199335724 -122.431242739217 (37.7483199335724, -122.431242739217) 2 4 5 28862 22
2294 84947 7 17 1812 Webster St 1 Sidewalk: Curb side : Cutout Tree 2           6003475 2114918 37.7873579154126 -122.431774444579 (37.7873579154126, -122.431774444579) 13 9 11 29490 27
2296 32307 7 11 1097 Houston St 1 Sidewalk: Curb side : Cutout Tree 2   08/19/1996 12:00:00 AM     Permit Number 36882                    
2318 61432 7 17 234 La Espiral St 1 Sidewalk: Curb side : Cutout Tree 2   05/07/1984 12:00:00 AM     Permit Number 21363                    
2319 34069 7 25 955 Kennedy Ave 3 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
2323 35205 7 16   16 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2328 57118 7 17 567 London St 1 Sidewalk: Curb side : Cutout Tree 2   10/23/1974 12:00:00 AM     Permit Number 14388 6001433.85993869 2090479.06392424 37.7201385647203 -122.437085957535 (37.7201385647203, -122.437085957535) 9 7 6 28861 5
2336 59785 7 17 237 Sanchez St 1 Sidewalk: Curb side : Cutout Tree 2   07/24/1981 12:00:00 AM     Permit Number 19234 6003567.2308667 2106887.18352857 37.7653125069264 -122.430881994524 (37.7653125069264, -122.430881994524) 8 4 5 28862 3
2339 44535 7 17   34 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2356 57206 7 62 2202 Divisadero St 1 Sidewalk: Curb side : Cutout Tree 2   01/08/1975 12:00:00 AM     Permit Number 774014 6000908.32678769 2115906.78943665 37.7899270475037 -122.44072552972 (37.7899270475037, -122.44072552972) 13 6 1 29490 27
2358 35806 7 225 48 Sycamore St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/22/1998 12:00:00 AM     Permit Number 39050 6006557.62447631 2105882.41132606 37.7627226190877 -122.420467579489 (37.7627226190877, -122.420467579489) 8 4 7 28859 19
2359 35980 7 9 349 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39134 6006399.96537133 2097866.62265006 37.740704214618 -122.420443871581 (37.740704214618, -122.420443871581) 2 7 7 28859 2
2366 45917 7 17   63 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2371 57894 7 17 972 Terminal Way 1 Sidewalk: Curb side : Cutout Tree 2   05/25/1977 12:00:00 AM     Permit Number 16848                    
2375 58506 7 17 1378 Waller St 1 Sidewalk: Curb side : Cutout Tree 2   03/29/1979 12:00:00 AM     Permit Number 17681 5999108.40955672 2108391.40839874 37.7691890857648 -122.446412174677 (37.7691890857648, -122.446412174677) 15 5 11 29492 9
2380 51181 7 44 2550& VICENTE 24th Ave 32 Sidewalk: Curb side : Cutout Tree 2   07/28/2004 12:00:00 AM     Permit Number 47565 5988957.29016327 2097975.36056036 37.7400043920325 -122.480761277613 (37.7400043920325, -122.480761277613) 1 8 3 29491 35
2396 61859 7 57 1160 Hampshire St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/23/1985 12:00:00 AM 8   Permit Number 21899 6010253.66087773 2102459.66274806 37.75353211276 -122.407442925811 (37.75353211276, -122.407442925811) 2 4 7 28859 19
2407 38882 7 29 101 Commonwealth Ave 3 Sidewalk: Curb side : Cutout Tree 2 FUF 11/02/1998 12:00:00 AM     Permit Number 40703 5996508.72142362 2113802.71293841 37.7838982845648 -122.455795523067 (37.7838982845648, -122.455795523067) 11 6 1 54 31
2424 61752 7 17 3014 Rolison Road 1 Sidewalk: Curb side : Cutout Tree 2   12/18/1984 12:00:00 AM     Permit Number 21763                    
2425 31630 7 16 2482 Great Hwy 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/22/1995 12:00:00 AM     Permit Number 35147 5981478.22688702 2098193.22560061 37.7401650446812 -122.506636494986 (37.7401650446812, -122.506636494986) 1 8 3 29491 35
2426 100409 7 148 201 Franklin St 5 Sidewalk: Curb side : Cutout Tree 2   08/16/2012 12:00:00 AM     Permit Number 767727 6006409.6 2110870.2 37.7764095571607 -122.421333763494 (37.7764095571607, -122.421333763494) 7 9 11 28852 10
2434 44999 7 17   103 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2445 48349 7 17   152 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2451 44962 7 17   75 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2453 49617 7 83 1626 Folsom St 7 Sidewalk: Curb side : Cutout Tree 2   05/13/2003 12:00:00 AM     Permit Number 46477 6008114.57908688 2108709.83276472 37.7705736773564 -122.415282774124 (37.7705736773564, -122.415282774124) 8 2 9 28853 19
2454 46118 7 27 2 Folsom St 11 Sidewalk: Curb side : Cutout Tree 2   12/27/2001 12:00:00 AM     Permit Number 44476 6015543.8 2115940.8 37.7908430231508 -122.390090033136 (37.7908430231508, -122.390090033136) 6 2 9 28855 6
2466 68381 7 7 42 Uranus Ter 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32206 5999268.74613245 2105519.44927205 37.7613125625383 -122.445651023552 (37.7613125625383, -122.445651023552) 15 5 5 28862 3
2478 110785 7 17 2 Edna St 2 Front Yard : Yard Tree 2   05/06/2015 12:00:00 AM 3     5998788.4 2092979.9 37.7268545527586 -122.446410203741 (37.7268545527586, -122.446410203741) 9 7 4 28861 40
2483 34134 7 14   5 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
2499 55575 7 17 622 09th St 1 Sidewalk: Curb side : Cutout Tree 2   12/06/1972 12:00:00 AM     Permit Number 11546 6010538.99497753 2108399.45644768 37.7698574135988 -122.40687477594 (37.7698574135988, -122.40687477594) 8 2 9 28853 19
2508 40281 7 7 379 Capp St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41433 6007237.3550509 2105117.81917656 37.7606615087743 -122.418062420589 (37.7606615087743, -122.418062420589) 2 4 7 28859 19
2509 27941 7 160 699 The Embarcadero 2 Median : Cutout Tree 6   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.8014446443351 -122.399901749617 (37.8014446443351, -122.399901749617) 3 1 10 28860 6
2516 45863 7 17   85 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2521 32694 7 36 3732 23rd St 2 Sidewalk: Curb side : Cutout Tree 2   10/29/1996 12:00:00 AM     Permit Number 37102 6004840.63533052 2102540.6946209 37.7534501432299 -122.426168121736 (37.7534501432299, -122.426168121736) 2 4 5 28862 22
2524 30480 7 17   3 Sidewalk: Curb side : Cutout Tree 2   09/05/1956 12:00:00 AM     Permit Number 147                    
2534 48332 7 17   142 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2539 34247 7 237 156 20th Ave 1 Sidewalk: Curb side : Cutout Tree 2   07/08/1997 12:00:00 AM     Permit Number 38057 5989633.42177993 2114324.27605098 37.7849333758181 -122.479619426106 (37.7849333758181, -122.479619426106) 11 6 2 55 26
2542 32891 7 122 1515 06th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/30/1996 12:00:00 AM     Permit Number 37234 5994269.30013039 2105266.22888454 37.7603305839468 -122.462923499947 (37.7603305839468, -122.462923499947) 1 5 4 56 12
2544 49162 7 116 804 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/23/2003 12:00:00 AM     Permit Number 46282 5994926.32764665 2093370.69967083 37.7277062535492 -122.459789497745 (37.7277062535492, -122.459789497745) 9 7 4 28861 40
2549 31437 7 17 4206 02nd St 1 Sidewalk: Curb side : Cutout Tree 2   05/01/1995 12:00:00 AM     Permit Number 35012                    
2552 42536 7 11 95 Brady St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42642 6006853.97359683 2109407.99798814 37.7724197439799 -122.419692774816 (37.7724197439799, -122.419692774816) 8 2 9 28853 19
2554 48167 7 17   60 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2559 48211 7 17   54 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2566 35200 7 14   3 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2570 60640 7 58 163 Fairmount St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/12/1983 12:00:00 AM     Permit Number 20267 6004543.66233737 2097218.34669513 37.7388194121969 -122.426816108434 (37.7388194121969, -122.426816108434) 2 7 5 63 7
2573 60778 7 17 3933 29th St 1 Sidewalk: Curb side : Cutout Tree 2   03/03/1983 12:00:00 AM     Permit Number 20448                    
2583 34124 7 14   1 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37982                    
2586 66958 7 17 283 Sadowa St 1 Sidewalk: Curb side : Cutout Tree 2   01/21/1992 12:00:00 AM     Permit Number 30294 5994190.17633556 2087741.03649596 37.7122061872577 -122.461926308953 (37.7122061872577, -122.461926308953) 9 8 6 28861 24
2602 42924 7 33   2 Sidewalk: Curb side : Cutout Tree 2   07/05/2000 12:00:00 AM     Permit Number 42829                    
2603 50904 7 149 2094 17th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/26/2004 12:00:00 AM     Permit Number 47411 5991019.11429888 2101160.98347731 37.7488709142667 -122.473864759666 (37.7488709142667, -122.473864759666) 1 8 4 29491 12
2610 31853 7 135 1263 Houston St 1 Sidewalk: Curb side : Cutout Tree 2   06/19/1995 12:00:00 AM     Permit Number 35300                    
2611 52930 7 11 36 Havelock St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/03/2006 12:00:00 AM     Permit Number 48915 5999971.05699015 2092944.44477133 37.7268246780096 -122.442319255194 (37.7268246780096, -122.442319255194) 9 7 6 28861 25
2612 48088 7 17   198 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2627 44717 7 60 1991 21st Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/03/2001 12:00:00 AM     Permit Number 43839 5989704.86545465 2101822.42727681 37.7506108546658 -122.478457743126 (37.7506108546658, -122.478457743126) 1 8 3 29491 35
2630 47383 7 11 1515 Vallejo St 4 Sidewalk: Curb side : Cutout Tree 2   03/25/2003 12:00:00 AM     Permit Number 46367 6006307.07862293 2118296.63950756 37.7967949468883 -122.422216159163 (37.7967949468883, -122.422216159163) 13 9 10 28858 32
2632 48281 7 17   91 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2646 44909 7 17   132 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2656 44646 7 17   66 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2660 62615 7 17 1868 10th Ave 1 Sidewalk: Curb side : Cutout Tree 2   02/24/1986 12:00:00 AM     Permit Number 22925 5993167.63363514 2102765.07828361 37.7533995564178 -122.466551819518 (37.7533995564178, -122.466551819518) 1 8 4 56 12
2664 45874 7 17   28 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2666 48202 7 17   45 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2667 66672 7 17 4307 02nd St 1 Sidewalk: Curb side : Cutout Tree 2   06/25/1991 12:00:00 AM     Permit Number 29892                    
2677 36640 7 196   14 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
2690 44593 7 17   133 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2691 58348 7 17   1 Sidewalk: Curb side : Cutout Tree 2   11/08/1978 12:00:00 AM     Permit Number 17373                    
2697 49874 7 17 0@ 14th ST Trainor St 2 Sidewalk: Curb side : Cutout Tree 2   06/30/2003 12:00:00 AM     Permit Number 46642                    
2702 48207 7 17   50 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2705 54005 7 17 515 Alvarado St 1 Sidewalk: Curb side : Cutout Tree 2   04/05/1972 12:00:00 AM     Permit Number 9724 6003024.81931846 2102680.10849791 37.7537301410207 -122.432457552268 (37.7537301410207, -122.432457552268) 2 4 5 28862 22
2708 50426 7 13 250 Howth St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/12/2014 12:00:00 AM 3   Permit Number 773627 5997303.25557645 2090612.9654569 37.7202705700793 -122.45137364778 (37.7202705700793, -122.45137364778) 9 8 6 28861 24
2710 44606 7 17   170 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2714 113322 7 9 100 Church St 2 Sidewalk: Curb side : Cutout Tree 2 FUF         6004079.74050315 2108375.213269 37.7694273021614 -122.42921545709 (37.7694273021614, -122.42921545709) 7 9 5 28862 3
2715 57888 7 17 2382 Fost St 1 Sidewalk: Curb side : Cutout Tree 2   05/04/1977 12:00:00 AM     Permit Number 16841                    
2716 48065 7 17   219 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2722 48074 7 17   240 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2746 44553 7 17   4 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2756 39703 7 122 634 Edna St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41088 5998596.64163755 2094795.02743762 37.7318275120035 -122.4472036828 (37.7318275120035, -122.4472036828) 9 7 4 59 40
2762 46200 7 83   2 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
2763 48152 7 17   262 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2768 48107 7 17   202 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2775 45022 7 17   95 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2779 117319 7 45 1935 09th Ave 1 Sidewalk: Curb side : Cutout Tree 2           5993426.4 2102307.1 37.7521569948021 -122.465623688401 (37.7521569948021, -122.465623688401) 1 8 4 29491 12