trees
8,659 rows where qSpecies_id = 11 sorted by DBH
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22412 | 121393 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1200 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992068.87064248 | 2106619.25975245 | 37.7639186591654 | -122.470632238353 | (37.7639186591654, -122.470632238353) | 11 | 8 | 11 | 56 | 12 | ||||
| 22827 | 49536 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 201& HOWARD 11th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/2003 12:00:00 AM | Permit Number 46432 | 6008076.54225013 | 2109644.21971492 | 37.77313714597 | -122.415480506783 | (37.77313714597, -122.415480506783) | 8 | 2 | 9 | 28853 | 34 | ||
| 22919 | 87960 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1792- 1796 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50995 | 6004410 | 2118774 | 37.7979984691166 | -122.428814538952 | (37.7979984691166, -122.428814538952) | 13 | 9 | 1 | 57 | 17 | ||
| 22990 | 41029 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3201 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1999 12:00:00 AM | Permit Number 41820 | 6016035.99249362 | 2100680.99703482 | 37.7489702208778 | -122.387322123038 | (37.7489702208778, -122.387322123038) | 10 | 3 | 8 | 58 | 1 | |||
| 23072 | 57766 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1274 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/16/2004 12:00:00 AM | Permit Number 30721 | 6003208.09722534 | 2100816.36733347 | 37.7486231381102 | -122.431690681163 | (37.7486231381102, -122.431690681163) | 2 | 4 | 5 | 28862 | 22 | ||
| 23169 | 254046 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3098 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3x3 | 5996155 | 2111465 | 37.7774592380037 | -122.456850126351 | (37.7774592380037, -122.456850126351) | 11 | 6 | 2 | 54 | 16 | |||
| 23479 | 67557 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2250 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2002 12:00:00 AM | Permit Number 31107 | 6011809.01803035 | 2102821.27858421 | 37.7546119642664 | -122.402089552597 | (37.7546119642664, -122.402089552597) | 10 | 3 | 8 | 28856 | 29 | ||
| 23543 | 58665 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 19 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | 5x5 | Permit Number 17888 | 5997899.21227379 | 2107824.94085215 | 37.7675645727548 | -122.45055385809 | (37.7675645727548, -122.45055385809) | 15 | 5 | 11 | 29492 | 9 | ||
| 23573 | 60472 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | 3x3 | Permit Number 20066 | 5997184 | 2089426 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | 9 | 8 | 6 | 28861 | 24 | |
| 23683 | 41329 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1099 23rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2000 12:00:00 AM | Permit Number 41989 | 6015050.89700095 | 2102949.47487395 | 37.7551443758892 | -122.390887135154 | (37.7551443758892, -122.390887135154) | 10 | 3 | 8 | 28856 | 29 | |||
| 23745 | 68771 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 618 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32699 | 6002994.19815115 | 2104668.66714897 | 37.7591885121441 | -122.432705487622 | (37.7591885121441, -122.432705487622) | 2 | 4 | 5 | 28862 | 3 | ||
| 23821 | 33448 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 296 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37549 | 6006236.86053546 | 2098275.58852233 | 37.7418179502003 | -122.421036857631 | (37.7418179502003, -122.421036857631) | 2 | 7 | 7 | 28859 | 2 | |||
| 24066 | 66880 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 180 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 30191 | 6001054.37420438 | 2105375.891539 | 37.7610201730934 | -122.439465011148 | (37.7610201730934, -122.439465011148) | 15 | 4 | 5 | 28862 | 3 | ||
| 24169 | 86998 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1x HOFF ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/2007 12:00:00 AM | 3x3 | Permit Number 49941 | 6006557 | 2106415 | 37.7641849474554 | -122.420507546061 | (37.7641849474554, -122.420507546061) | 8 | 4 | 7 | 28859 | 19 | ||
| 24188 | 35766 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3532 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1998 12:00:00 AM | Permit Number 39027 | 6005329.08197768 | 2106078.91803326 | 37.7631928700742 | -122.424730655342 | (37.7631928700742, -122.424730655342) | 8 | 4 | 5 | 28859 | 19 | ||
| 24227 | 61164 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 915 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | Permit Number 21022 | 6007598.38021485 | 2104325.81612988 | 37.7585071641193 | -122.416757683766 | (37.7585071641193, -122.416757683766) | 2 | 4 | 7 | 28859 | 19 | ||
| 24304 | 42792 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2000 12:00:00 AM | Permit Number 42757 | 6004214.17005009 | 2106015.94399708 | 37.7629569261619 | -122.42858227503 | (37.7629569261619, -122.42858227503) | 8 | 4 | 5 | 28862 | 3 | |||
| 24320 | 47869 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 745 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2002 12:00:00 AM | Permit Number 45622 | 5993251.273182 | 2113455.25810423 | 37.7827567838111 | -122.467039725997 | (37.7827567838111, -122.467039725997) | 11 | 6 | 2 | 54 | 11 | |||
| 24347 | 33767 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 161 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1982 12:00:00 AM | Permit Number 37818 | 6008553.70103317 | 2113013.7239739 | 37.7824158124941 | -122.414068369022 | (37.7824158124941, -122.414068369022) | 7 | 10 | 9 | 28852 | 36 | ||
| 24399 | 62832 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2017 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/2005 12:00:00 AM | Permit Number 23197 | 5999678.92885006 | 2092144.34740146 | 37.7246111411292 | -122.443271689799 | (37.7246111411292, -122.443271689799) | 9 | 7 | 6 | 28861 | 25 | ||
| 24507 | 62329 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 126 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/1985 12:00:00 AM | Permit Number 22471 | 6004740.38487171 | 2095929.71347498 | 37.7352922369935 | -122.426044223473 | (37.7352922369935, -122.426044223473) | 2 | 7 | 5 | 28861 | 2 | ||
| 24593 | 37536 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 601 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39981 | 6008418.75092202 | 2114143.5333589 | 37.7855104162406 | -122.41461521535 | (37.7855104162406, -122.41461521535) | 7 | 10 | 9 | 28858 | 36 | ||
| 24834 | 60616 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 152 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20240 | 6004848.50630576 | 2097410.92341249 | 37.7393654155838 | -122.425775803338 | (37.7393654155838, -122.425775803338) | 2 | 7 | 5 | 63 | 7 | ||
| 24984 | 39429 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 350Bldg #15 Haight St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40931 | 6004450.98112316 | 2109482.57981657 | 37.772488871091 | -122.428010274079 | (37.772488871091, -122.428010274079) | 7 | 9 | 11 | 28852 | 10 | |||
| 25097 | 39452 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 205 13th St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1999 12:00:00 AM | Permit Number 40934 | 6007392.37160238 | 2108419.72859009 | 37.7697365039652 | -122.417760336994 | (37.7697365039652, -122.417760336994) | 8 | 4 | 7 | 28853 | 19 | ||
| 25217 | 121314 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 124 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
| 25368 | 108741 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 100x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 25527 | 117367 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 3199X LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003762 | 2119666 | 37.8004109732815 | -122.431120504486 | (37.8004109732815, -122.431120504486) | 13 | 9 | 1 | 57 | 17 | ||||
| 25588 | 64303 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1617 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1988 12:00:00 AM | Permit Number 25114 | 6004013.37542651 | 2098859.53431589 | 37.743295740519 | -122.428766558424 | (37.743295740519, -122.428766558424) | 2 | 7 | 5 | 63 | 22 | ||
| 25638 | 66832 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4673 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30130 | 6000067.53156969 | 2105147.37083387 | 37.7603364996217 | -122.442861650033 | (37.7603364996217, -122.442861650033) | 2 | 4 | 5 | 28862 | 3 | ||
| 25739 | 66947 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 111 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/1992 12:00:00 AM | Permit Number 30274 | 5996487.19434686 | 2112266.4433637 | 37.7796788598798 | -122.455758910511 | (37.7796788598798, -122.455758910511) | 11 | 6 | 2 | 54 | 16 | ||
| 26164 | 48522 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1(REVISED) Church St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.429132262601 | (37.7703294028669, -122.429132262601) | 7 | 9 | 5 | 29492 | 10 | |||
| 26236 | 99105 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1400@ Mendell Evans Ave | 1 | Front Yard : Yard | Tree | Private 2 | 04/09/2012 12:00:00 AM | Permit Number 768768 | 6016404 | 2098045.1 | 37.7417529632601 | -122.385865834439 | (37.7417529632601, -122.385865834439) | 10 | 3 | 8 | 58 | 1 | |||
| 26279 | 39000 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2180 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1999 12:00:00 AM | Permit Number 40764 | 6008727.07607359 | 2105746.22742921 | 37.7624707078907 | -122.412954561883 | (37.7624707078907, -122.412954561883) | 8 | 4 | 7 | 28859 | 19 | ||
| 26464 | 251519 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | 7 | 9 | 5 | 28862 | 3 | ||||
| 26548 | 47533 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 254 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45404 | 6004948.86039834 | 2098452.49541166 | 37.7422310063648 | -122.425502929799 | (37.7422310063648, -122.425502929799) | 2 | 7 | 5 | 63 | 22 | ||
| 26595 | 68196 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4343 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/1993 12:00:00 AM | Permit Number 31974 | 6001608.50667492 | 2104649.85550995 | 37.7590581756639 | -122.437496517824 | (37.7590581756639, -122.437496517824) | 2 | 4 | 5 | 28862 | 3 | ||
| 26618 | 94068 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2010 12:00:00 AM | 3x3 | Permit Number 53461. Tree 2 on 18th St. | 6015474 | 2105663 | 37.7626186026962 | -122.389613415677 | (37.7626186026962, -122.389613415677) | 10 | 3 | 8 | 28856 | 29 | ||
| 26814 | 68650 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1979 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32555 | 5990630.42882931 | 2101932.6813693 | 37.7509672741353 | -122.475265151572 | (37.7509672741353, -122.475265151572) | 1 | 8 | 4 | 29491 | 12 | ||
| 26884 | 255995 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 145 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 6014490.38163 | 2116022.05926 | 37.791007660723 | -122.393740530522 | (37.791007660723, -122.393740530522) | 12 | 2 | 9 | 28855 | 6 | ||||
| 26916 | 39462 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 205 13th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1999 12:00:00 AM | Permit Number 40934 | 6007392.37160238 | 2108419.72859009 | 37.7697365039652 | -122.417760336994 | (37.7697365039652, -122.417760336994) | 8 | 4 | 7 | 28853 | 19 | ||
| 27063 | 47380 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1515 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | 3x3 | Permit Number 46367 | 6006307.07862293 | 2118296.63950756 | 37.7967949468883 | -122.422216159163 | (37.7967949468883, -122.422216159163) | 13 | 9 | 10 | 28858 | 32 | ||
| 27075 | 30527 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 142 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1995 12:00:00 AM | Permit Number 34532 | 6008613.3918835 | 2112962.19179435 | 37.7822776699047 | -122.413858217761 | (37.7822776699047, -122.413858217761) | 7 | 10 | 9 | 28852 | 36 | ||
| 27132 | 51777 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2095 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.412408020241 | (37.7644507242066, -122.412408020241) | 8 | 4 | 7 | 28859 | 19 | |||
| 27214 | 108859 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 6015632.2 | 2115560.3 | 37.7898031599115 | -122.389757582477 | (37.7898031599115, -122.389757582477) | 6 | 2 | 9 | 28855 | 6 | ||||
| 27371 | 65435 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 765 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/1989 12:00:00 AM | Permit Number 28308 | 6007639.8007417 | 2114035.88363544 | 37.7851710424556 | -122.417302529369 | (37.7851710424556, -122.417302529369) | 7 | 10 | 9 | 28858 | 36 | ||
| 27429 | 116566 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1610 INNES AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015424 | 2097316 | 37.739696723386 | -122.38920348056 | (37.739696723386, -122.38920348056) | 10 | 3 | 8 | 58 | 1 | ||||
| 27434 | 59578 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 667 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1981 12:00:00 AM | Permit Number 18968 | 6007441.38229264 | 2095859.69357085 | 37.7352522623528 | -122.416700897177 | (37.7352522623528, -122.416700897177) | 2 | 7 | 7 | 28859 | 2 | ||
| 27551 | 63945 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 264 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1987 12:00:00 AM | Permit Number 24675 | 6004856.58665432 | 2099033.15113958 | 37.7438201403882 | -122.425863306487 | (37.7438201403882, -122.425863306487) | 2 | 7 | 5 | 63 | 22 | ||
| 27569 | 86819 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1010 Capitol Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49755 | 5995086.4 | 2090661.6 | 37.7202769199461 | -122.45904005327 | (37.7202769199461, -122.45904005327) | 9 | 8 | 6 | 28861 | 24 | ||||
| 27762 | 48831 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 900& Ellis ST Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2002 12:00:00 AM | Permit Number 46052 | 6006585.19880022 | 2113562.98152006 | 37.7838131798102 | -122.420917544452 | (37.7838131798102, -122.420917544452) | 7 | 9 | 9 | 28858 | 36 | |||
| 27789 | 187645 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 880x Clipper Ter | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999931 | 2100716 | 37.7481612516949 | -122.443015603116 | (37.7481612516949, -122.443015603116) | 2 | 4 | 5 | 63 | 22 | ||||
| 27837 | 46519 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2355 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2002 12:00:00 AM | Permit Number 44683 | 6008210.39839255 | 2104720.72598575 | 37.7596259002337 | -122.414668990427 | (37.7596259002337, -122.414668990427) | 2 | 4 | 7 | 28859 | 19 | |||
| 27874 | 256014 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 5ft | 6014659.2386 | 2115111.85167 | 37.7885178228739 | -122.393092572574 | (37.7885178228739, -122.393092572574) | 6 | 2 | 9 | 28855 | 6 | ||||
| 27875 | 56612 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 139 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31089 | 5996720.86601097 | 2098424.62291363 | 37.7416861435861 | -122.453950621575 | (37.7416861435861, -122.453950621575) | 9 | 7 | 4 | 59 | 40 | ||
| 27920 | 101997 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 501X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014257 | 2114662 | 37.7872602812755 | -122.394452755334 | (37.7872602812755, -122.394452755334) | 6 | 2 | 9 | 28855 | 6 | ||||
| 27972 | 254416 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 351 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6009490 | 2109608 | 37.7731170407572 | -122.410588595525 | (37.7731170407572, -122.410588595525) | 8 | 2 | 9 | 28853 | 34 | ||||
| 27987 | 50742 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 350 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2004 12:00:00 AM | Permit Number 47290 | 6008892.30804875 | 2106599.83050345 | 37.7648237794264 | -122.41244342296 | (37.7648237794264, -122.41244342296) | 8 | 4 | 7 | 28859 | 19 | |||
| 28074 | 42804 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2000 12:00:00 AM | Permit Number 42757 | 6004214.17005009 | 2106015.94399708 | 37.7629569261619 | -122.42858227503 | (37.7629569261619, -122.42858227503) | 8 | 4 | 5 | 28862 | 3 | |||
| 28076 | 62735 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 208 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/07/1986 12:00:00 AM | Permit Number 23082 | 6001065.67884929 | 2105174.65584565 | 37.7604682724893 | -122.439411488062 | (37.7604682724893, -122.439411488062) | 2 | 4 | 5 | 28862 | 3 | ||
| 28294 | 98584 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2415 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015851.26334 | 2104350.49273 | 37.7590356503023 | -122.388216981957 | (37.7590356503023, -122.388216981957) | 10 | 3 | 8 | 28856 | 29 | ||||
| 28317 | 47582 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 301 Folsom St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | Permit Number 45427 | 6014780.11094225 | 2115147.42860331 | 37.7886222227295 | -122.392676859355 | (37.7886222227295, -122.392676859355) | 6 | 2 | 9 | 28855 | 6 | |||
| 28347 | 122501 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 575 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997973.69250609 | 2108644.65485494 | 37.7698195609286 | -122.450355338753 | (37.7698195609286, -122.450355338753) | 15 | 5 | 11 | 29492 | 9 | ||||
| 28350 | 254415 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 351 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/2010 12:00:00 AM | 3x3 | 6009490 | 2109608 | 37.7731170407572 | -122.410588595525 | (37.7731170407572, -122.410588595525) | 8 | 2 | 9 | 28853 | 34 | |||
| 28424 | 61527 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5100 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | Permit Number 32018 | 5991235.95531236 | 2112730.29387914 | 37.7806497014798 | -122.473958895196 | (37.7806497014798, -122.473958895196) | 11 | 6 | 2 | 54 | 26 | ||
| 28559 | 39437 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 350Bldg #15 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40931 | 6004450.98112316 | 2109482.57981657 | 37.772488871091 | -122.428010274079 | (37.772488871091, -122.428010274079) | 7 | 9 | 11 | 28852 | 10 | |||
| 28694 | 60656 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 159 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20290 | 6004348.70731442 | 2097373.30443411 | 37.7392338661268 | -122.427501208362 | (37.7392338661268, -122.427501208362) | 2 | 7 | 5 | 63 | 7 | ||
| 28821 | 87755 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 19 Cook St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50410 | 5997460 | 2113566 | 37.7833028815315 | -122.452487379595 | (37.7833028815315, -122.452487379595) | 15 | 6 | 1 | 54 | 31 | ||
| 29362 | 61169 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 989 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | Permit Number 21028 | 6007621.28893018 | 2103912.36255672 | 37.7573732040434 | -122.416649165846 | (37.7573732040434, -122.416649165846) | 2 | 4 | 7 | 28859 | 19 | ||
| 29452 | 51779 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 380 Alabama St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.412408020241 | (37.7644507242066, -122.412408020241) | 8 | 4 | 7 | 28859 | 19 | |||
| 29529 | 109009 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2130 HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008727 | 2105981.7 | 37.7631172571998 | -122.412971474783 | (37.7631172571998, -122.412971474783) | 8 | 4 | 7 | 28859 | 19 | ||||
| 29581 | 253281 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5997149.818 | 2108070.0101 | 37.7681945486983 | -122.453163595144 | (37.7681945486983, -122.453163595144) | 15 | 5 | 11 | 29492 | 9 | ||||
| 29588 | 66763 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 131 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1991 12:00:00 AM | Permit Number 30016 | 6005869.86993162 | 2108458.14834432 | 37.7697561997572 | -122.423029364321 | (37.7697561997572, -122.423029364321) | 8 | 4 | 5 | 28853 | 19 | ||
| 29677 | 47472 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3000 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45373 | 5999998.46325144 | 2115118.74868782 | 37.78771143635 | -122.443816926647 | (37.78771143635, -122.443816926647) | 13 | 6 | 1 | 29490 | 27 | ||
| 29768 | 87422 | - 12 | Lophostemon confertus :: Brisbane Box 11 | 45X Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 6009092.517834 | 2112687.614007 | 37.7815506408215 | -122.412181237011 | (37.7815506408215, -122.412181237011) | 7 | 10 | 9 | 28852 | 36 | ||||
| 29897 | 86721 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 South Park | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2007 12:00:00 AM | Permit Number 49703 | 6014686.1 | 2112756.9 | 37.7820531563646 | -122.392834816441 | (37.7820531563646, -122.392834816441) | 6 | 2 | 9 | 28856 | 6 | ||||
| 29940 | 67983 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 90 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31707 | 5996243.31807004 | 2090478.67458978 | 37.7198410887436 | -122.455027781571 | (37.7198410887436, -122.455027781571) | 9 | 8 | 6 | 28861 | 24 | ||
| 29955 | 107081 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 140 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2014 12:00:00 AM | 3x3 | Permit Number 773442 | 6004058.03758 | 2108126.05047 | 37.7687419329219 | -122.429272756988 | (37.7687419329219, -122.429272756988) | 7 | 9 | 5 | 28862 | 3 | ||
| 30073 | 113257 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 45 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994580 | 2092875 | 37.7263252596904 | -122.46095083712 | (37.7263252596904, -122.46095083712) | 9 | 8 | 4 | 28861 | 40 | ||||
| 30076 | 68711 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3836 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32624 | 6003383.98615061 | 2105968.81220438 | 37.7627804967989 | -122.431450228755 | (37.7627804967989, -122.431450228755) | 15 | 4 | 5 | 28862 | 3 | ||
| 30471 | 45641 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 322 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2001 12:00:00 AM | Permit Number 44344 | 6011059.60106207 | 2111405.70929076 | 37.7781410078025 | -122.405285735451 | (37.7781410078025, -122.405285735451) | 14 | 2 | 9 | 28853 | 34 | |||
| 30588 | 63607 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 560 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 24244 | 5999723.18942621 | 2110395.84048973 | 37.774727842932 | -122.44442976453 | (37.774727842932, -122.44442976453) | 15 | 5 | 11 | 29492 | 16 | ||
| 30800 | 32059 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3630 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | Permit Number 35436 | 6004683.75496729 | 2106042.80535333 | 37.7630572446514 | -122.426960055073 | (37.7630572446514, -122.426960055073) | 8 | 4 | 5 | 28859 | 3 | ||
| 30884 | 94312 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5800 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013721.0222 | 2091953.33052 | 37.7248773762602 | -122.39471624425 | (37.7248773762602, -122.39471624425) | 10 | 3 | 8 | 58 | 1 | ||
| 30993 | 113664 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 115 Wisconsin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6012589.13870894 | 2106969.27475819 | 37.7660449583156 | -122.399682898168 | (37.7660449583156, -122.399682898168) | 14 | 3 | 8 | 28856 | 20 | |||
| 31205 | 52366 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 701JONES Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | Permit Number 48500 | 6008788.51328068 | 2114892.18368885 | 37.7875867962818 | -122.413388905547 | (37.7875867962818, -122.413388905547) | 5 | 1 | 10 | 28852 | 36 | ||
| 31258 | 21953 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2455 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6015846.1997029 | 2104173.3207168 | 37.7585488931446 | -122.388222129716 | (37.7585488931446, -122.388222129716) | 10 | 3 | 8 | 28856 | 29 | ||||
| 31327 | 61160 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 837 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | Permit Number 21018 | 6007572.8609515 | 2104786.57925421 | 37.7597708781506 | -122.416878585473 | (37.7597708781506, -122.416878585473) | 2 | 4 | 7 | 28859 | 19 | ||
| 31385 | 84067 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4205 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51810 | 6002526.85422191 | 2101191.83741791 | 37.749615451607 | -122.434073245414 | (37.749615451607, -122.434073245414) | 2 | 4 | 5 | 28862 | 22 | ||
| 31418 | 110533 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 100X ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | City College | 3x3 | 5998750 | 2110223 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | 15 | 5 | 11 | 29492 | 16 | |||
| 31622 | 66948 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 121 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1992 12:00:00 AM | Permit Number 30275 | 5996514.31326577 | 2112183.61035143 | 37.7794529785744 | -122.455659105933 | (37.7794529785744, -122.455659105933) | 11 | 6 | 2 | 54 | 16 | ||
| 31715 | 39448 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 495Bldg #11 Rose St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1998 12:00:00 AM | Permit Number 40933 | 6004232.67570269 | 2109577.47214005 | 37.7727370691634 | -122.428772180203 | (37.7727370691634, -122.428772180203) | 7 | 9 | 11 | 28852 | 10 | |||
| 31802 | 86727 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 550X 02ND ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2007 12:00:00 AM | Permit Number 49703 | 6014686 | 2112756 | 37.7820506796147 | -122.392835099414 | (37.7820506796147, -122.392835099414) | 6 | 2 | 9 | 28856 | 6 | |||
| 32110 | 86992 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 301 Executive Park Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2007 12:00:00 AM | 3x3 | Permit Number 49938 | 6014761.5 | 2086930.3 | 37.7111429140183 | -122.390768534473 | (37.7111429140183, -122.390768534473) | 10 | 3 | 8 | 58 | 1 | ||
| 32311 | 68797 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2439 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32736 | 5992318.97731321 | 2098848.50110466 | 37.7425966331498 | -122.469201588083 | (37.7425966331498, -122.469201588083) | 1 | 8 | 4 | 29491 | 40 | ||
| 32378 | 39002 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2180 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1999 12:00:00 AM | Permit Number 40764 | 6008727.07607359 | 2105746.22742921 | 37.7624707078907 | -122.412954561883 | (37.7624707078907, -122.412954561883) | 8 | 4 | 7 | 28859 | 19 | ||
| 32497 | 46108 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 798 Stanyan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | 3x3 | Permit Number 44472 | 5997167.07493712 | 2107760.6930909 | 37.767346232554 | -122.453081574039 | (37.767346232554, -122.453081574039) | 15 | 5 | 11 | 29492 | 9 | ||
| 32841 | 103295 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 50 Francisco St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2013 12:00:00 AM | 3x3 | Permit Number 769976 | 6011114.9 | 2121460 | 37.805750773231 | -122.405802839637 | (37.805750773231, -122.405802839637) | 3 | 1 | 10 | 308 | 23 | ||
| 32865 | 84109 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 101 Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50446 | 6000855.51640972 | 2103710.16878886 | 37.7564351859154 | -122.440033328655 | (37.7564351859154, -122.440033328655) | 2 | 4 | 5 | 28862 | 38 | ||
| 32890 | 9796 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/08/2006 12:00:00 AM | 3X3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );