trees
8,659 rows where qSpecies_id = 11 sorted by qLegalStatus_id descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12889 | 48521 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1(REVISED) Church St | 19 | 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 | |||
12891 | 47614 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45446 | |||||||||||||
12896 | 47476 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
12907 | 57882 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 285 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1991 12:00:00 AM | Permit Number 16832 | 6008642.54194369 | 2113136.6674883 | 37.7827583753423 | -122.413769716445 | (37.7827583753423, -122.413769716445) | 7 | 10 | 9 | 28852 | 36 | ||
13109 | 38799 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | Permit Number 40645 | ||||||||||||||
13263 | 27467 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3255 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016160.2227 | 2100486.94206 | 37.7484442654916 | -122.386878998841 | (37.7484442654916, -122.386878998841) | 10 | 3 | 8 | 58 | 1 | ||
13373 | 46149 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44491 | ||||||||||||||
13382 | 38798 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | Permit Number 40645 | ||||||||||||||
13404 | 46147 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
13438 | 41722 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 232 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42170 | 6009584.56743913 | 2109048.70213008 | 37.7715866403458 | -122.410221977607 | (37.7715866403458, -122.410221977607) | 8 | 2 | 9 | 28853 | 34 | ||
13560 | 37399 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4136 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51608 | 6002967.77146545 | 2101268.40014863 | 37.749850688501 | -122.432554007631 | (37.749850688501, -122.432554007631) | 2 | 4 | 5 | 28862 | 22 | ||
13590 | 38665 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/1998 12:00:00 AM | Permit Number 40586 | |||||||||||||
13602 | 32308 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1097 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | Permit Number 36882 | |||||||||||||
13749 | 39003 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2180 Harrison St | 6 | 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 | ||
13761 | 33744 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1198 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1996 12:00:00 AM | Permit Number 37802 | 6006363.721006 | 2102616.9286996 | 37.7537454336429 | -122.420906369809 | (37.7537454336429, -122.420906369809) | 2 | 4 | 5 | 28859 | 19 | |||
13907 | 68355 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 627 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32175 | 5989388.74548019 | 2111065.82314724 | 37.7759723585503 | -122.480227347988 | (37.7759723585503, -122.480227347988) | 11 | 6 | 2 | 55 | 26 | ||
13938 | 68635 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1762 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32540 | 5990632.43795796 | 2103398.44981419 | 37.7549920050668 | -122.475365208722 | (37.7549920050668, -122.475365208722) | 1 | 8 | 4 | 56 | 12 | ||
13966 | 29542 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2770X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014905.27203 | 2090859.09161 | 37.7219385849654 | -122.390545970165 | (37.7219385849654, -122.390545970165) | 10 | 3 | 8 | 58 | 1 | ||
14054 | 15140 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 780X Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6011508.1688 | 2113852.28114 | 37.7848837916732 | -122.403906177321 | (37.7848837916732, -122.403906177321) | 12 | 2 | 9 | 28853 | 6 | |||
14063 | 41563 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 181 Shipley St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2000 12:00:00 AM | Permit Number 42081 | 6011929.63995711 | 2112113.99187797 | 37.7801343920604 | -122.402325751057 | (37.7801343920604, -122.402325751057) | 6 | 2 | 9 | 28856 | 34 | |||
14068 | 13261 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2443 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 6 | 3X3 | 6000701.59201 | 2119217.25602 | 37.7990049442386 | -122.441678488129 | (37.7990049442386, -122.441678488129) | 13 | 9 | 1 | 57 | 17 | ||
14090 | 47478 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
14363 | 38802 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | Permit Number 40645 | ||||||||||||||
14389 | 95083 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 730@ Waller Stanyan Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2010 12:00:00 AM | 3x3 | Permit Number 54023 | ||||||||||||
14637 | 36870 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
14722 | 38664 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/1998 12:00:00 AM | Permit Number 40586 | |||||||||||||
15271 | 62738 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4521 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/07/1986 12:00:00 AM | Permit Number 23085 | 6000942.99197149 | 2105197.51217307 | 37.7605240475123 | -122.439837443247 | (37.7605240475123, -122.439837443247) | 2 | 4 | 5 | 28862 | 3 | ||
15429 | 60677 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1098 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1988 12:00:00 AM | Permit Number 25704 | 6001311.54507479 | 2109393.91334387 | 37.7720673006946 | -122.438863516223 | (37.7720673006946, -122.438863516223) | 15 | 5 | 11 | 29492 | 9 | ||
15513 | 9780 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
15930 | 69139 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 573 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/1994 12:00:00 AM | Permit Number 33171 | 6008555.67489002 | 2114162.36008798 | 37.7855698016133 | -122.4141428296 | (37.7855698016133, -122.4141428296) | 7 | 10 | 9 | 28852 | 36 | ||
16088 | 3829 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 150 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6016637.2908848 | 2096068.7489059 | 37.7363392097219 | -122.384921527511 | (37.7363392097219, -122.384921527511) | 10 | 3 | 8 | 58 | 1 | ||
16268 | 3823 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 101X Cashmere St | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2001 12:00:00 AM | 9 | 3X3 | 6017067.4579304 | 2095837.0108628 | 37.7357266870687 | -122.383418119044 | (37.7357266870687, -122.383418119044) | 10 | 3 | 8 | 58 | 1 | ||
16280 | 44358 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | 5 | 1 | 10 | 308 | 23 | |||
16288 | 38803 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | Permit Number 40645 | ||||||||||||||
16357 | 32543 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 101 Valencia St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | 8 | 2 | 9 | 28853 | 19 | |||
16366 | 101747 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1000 Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25770 | 6011635 | 2118713 | 37.7982372525996 | -122.403809528937 | (37.7982372525996, -122.403809528937) | 3 | 1 | 10 | 308 | 23 | ||||
16488 | 50137 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 543 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2003 12:00:00 AM | 3x3 | Permit Number 46867 | 6013559.60626144 | 2114860.75138826 | 37.7877672132903 | -122.396879545969 | (37.7877672132903, -122.396879545969) | 6 | 2 | 9 | 28855 | 6 | ||
16585 | 41499 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1475 Mission St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2002 12:00:00 AM | Permit Number 45525 | 6007725.96622091 | 2110155.42070503 | 37.7745210713046 | -122.4167294201 | (37.7745210713046, -122.4167294201) | 8 | 2 | 9 | 28853 | 34 | |||
16805 | 36846 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
16819 | 38805 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | Permit Number 40645 | ||||||||||||||
17005 | 101474 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | Permit Number 775316 | 6000089 | 2095440.1 | 37.7336838892166 | -122.442090592963 | (37.7336838892166, -122.442090592963) | 9 | 7 | 4 | 63 | 40 | |||
17069 | 45774 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 610 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2001 12:00:00 AM | Permit Number 44417 | 5986681.45723276 | 2115112.83682499 | 37.7869266168429 | -122.489890152931 | (37.7869266168429, -122.489890152931) | 11 | 6 | 1 | 55 | 33 | |||
17273 | 88119 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1313 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51123 | |||||||||||||
17401 | 41505 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1475 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2004 12:00:00 AM | Permit Number 47570 | 6007725.96622091 | 2110155.42070503 | 37.7745210713046 | -122.4167294201 | (37.7745210713046, -122.4167294201) | 8 | 2 | 9 | 28853 | 34 | |||
17715 | 3782 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 25 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1998 12:00:00 AM | 3 | 3X4 | 6017357.1865758 | 2095776.9967683 | 37.7355779085493 | -122.38241223027 | (37.7355779085493, -122.38241223027) | 10 | 3 | 8 | 58 | 1 | ||
18024 | 39449 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 205 13th St | 8 | 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 | ||
18553 | 64985 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 Kingston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1989 12:00:00 AM | Permit Number 26023 | 6005554.31706226 | 2098219.5570786 | 37.741625601295 | -122.423392889427 | (37.741625601295, -122.423392889427) | 2 | 7 | 7 | 28859 | 2 | ||
18604 | 35437 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38882 | |||||||||||||
18640 | 66851 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4314 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30156 | 6001689.12791695 | 2104706.38300314 | 37.7592179697276 | -122.437221739283 | (37.7592179697276, -122.437221739283) | 2 | 4 | 5 | 28862 | 3 | ||
18767 | 67393 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 723 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1992 12:00:00 AM | Permit Number 30890 | 5990653.53990007 | 2110457.0289972 | 37.7743741891543 | -122.475807670593 | (37.7743741891543, -122.475807670593) | 11 | 6 | 2 | 55 | 26 | ||
18779 | 38667 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/1998 12:00:00 AM | Permit Number 40586 | |||||||||||||
18797 | 86726 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 550X 02ND ST | 5 | Sidewalk: Property 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 | |||
18865 | 9713 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 505X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | 3 | 4X4 | 6005848.49792 | 2111505.90882 | 37.7781234086211 | -122.423319977441 | (37.7781234086211, -122.423319977441) | 7 | 9 | 11 | 28852 | 10 | ||
18990 | 97775 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 639 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2014 12:00:00 AM | 3 | Permit Number 773141 | 5991602.6 | 2111067.7 | 37.7761059040631 | -122.472569257531 | (37.7761059040631, -122.472569257531) | 11 | 6 | 2 | 54 | 26 | ||
19273 | 27325 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 324 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2013 04:12:00 PM | 30 | 4x4 | 6004570.65008 | 2109631.91786 | 37.7729056865905 | -122.427606968753 | (37.7729056865905, -122.427606968753) | 7 | 9 | 11 | 28852 | 10 | ||
19296 | 46101 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 250 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2001 12:00:00 AM | Permit Number 44468 | 6015276.73031133 | 2112998.11508414 | 37.7827482661819 | -122.39080835017 | (37.7827482661819, -122.39080835017) | 6 | 2 | 9 | 28856 | 6 | ||
19395 | 49709 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 601X Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46522 | 6006253.05747 | 2106023.17246 | 37.76309194781 | -122.421530967732 | (37.76309194781, -122.421530967732) | 8 | 4 | 7 | 28859 | 19 | |
19614 | 36867 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
19669 | 47662 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 130 De Haro St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | Permit Number 45458 | 6011932.12138648 | 2107802.29908765 | 37.7682956086843 | -122.402013969527 | (37.7682956086843, -122.402013969527) | 8 | 3 | 8 | 28853 | 20 | ||
19692 | 54342 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1355 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31371 | 5994852.82536741 | 2106359.83971446 | 37.7633669502332 | -122.460984638129 | (37.7633669502332, -122.460984638129) | 15 | 5 | 11 | 56 | 12 | ||
19694 | 91181 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
19776 | 48918 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3251-3253 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46109 | 6008506.45955953 | 2104446.15135662 | 37.7588886104642 | -122.413625638798 | (37.7588886104642, -122.413625638798) | 2 | 4 | 7 | 28859 | 19 | ||
19941 | 45822 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 388 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2001 12:00:00 AM | Permit Number 44446 | 6015130.27889909 | 2114753.4499855 | 37.7875598893056 | -122.391437767 | (37.7875598893056, -122.391437767) | 6 | 2 | 9 | 28855 | 6 | |||
20344 | 47571 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 301 Folsom St | 12 | 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 | |||
20474 | 29513 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1900X Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 8 | 3x3 | 6016255.22712 | 2092677.23147 | 37.7270056390015 | -122.386006149227 | (37.7270056390015, -122.386006149227) | 10 | 3 | 8 | 58 | 1 | ||
20592 | 42808 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 7 | 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 | |||
20677 | 64983 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 95 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 26021 | 6005946.03067017 | 2099918.9435099 | 37.7463138322094 | -122.422159177188 | (37.7463138322094, -122.422159177188) | 2 | 7 | 5 | 28859 | 22 | ||
20923 | 9411 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 601X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1999 12:00:00 AM | 6 | 3X3 | 6006553.11457 | 2112551.33182 | 37.7810336281325 | -122.420956693216 | (37.7810336281325, -122.420956693216) | 7 | 9 | 11 | 28852 | 41 | ||
21097 | 61167 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 959 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | Permit Number 21026 | 6007612.00161276 | 2104079.97887736 | 37.7578329176461 | -122.4166931592 | (37.7578329176461, -122.4166931592) | 2 | 4 | 7 | 28859 | 19 | ||
21162 | 67350 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1230 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | Permit Number 30837 | 6011375.31798535 | 2102623.00157463 | 37.7540433227835 | -122.403575462068 | (37.7540433227835, -122.403575462068) | 10 | 4 | 8 | 28859 | 19 | ||
21182 | 40083 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1049 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/1999 12:00:00 AM | Permit Number 41305 | 5997243.56909325 | 2106895.02493838 | 37.764973712631 | -122.452754506367 | (37.764973712631, -122.452754506367) | 15 | 5 | 11 | 29492 | 12 | |||
21195 | 32570 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3101 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37048 | 6007591.33969332 | 2103811.09310335 | 37.7570934569025 | -122.416745568241 | (37.7570934569025, -122.416745568241) | 2 | 4 | 7 | 28859 | 19 | |
21298 | 40287 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 534 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41435 | 6004220.36226055 | 2105786.11050454 | 37.7623262087653 | -122.42854447486 | (37.7623262087653, -122.42854447486) | 8 | 4 | 5 | 28862 | 3 | ||
21470 | 81452 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 730 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49733 | 5997103.70386372 | 2108221.85987986 | 37.768608846124 | -122.453334062784 | (37.768608846124, -122.453334062784) | 15 | 5 | 11 | 29492 | 9 | ||
21494 | 41538 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 75 Townsend St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | 6 | 3x3 | Permit Number 42068 | 6015524 | 2112347 | 37.7809741671498 | -122.389907397894 | (37.7809741671498, -122.389907397894) | 6 | 2 | 9 | 28856 | 20 | |
21496 | 47915 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1785 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2002 12:00:00 AM | Permit Number 45654 | 6001052.85094237 | 2111733.28065206 | 37.7784758923523 | -122.439926121657 | (37.7784758923523, -122.439926121657) | 15 | 5 | 11 | 29490 | 41 | ||
21556 | 64289 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 357 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25094 | 6004221.28750393 | 2098359.956664 | 37.7419357800281 | -122.428012059642 | (37.7419357800281, -122.428012059642) | 2 | 7 | 5 | 63 | 7 | ||
21625 | 14774 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1000X McAllister St | 9 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 05/13/1992 12:00:00 AM | 6 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
21718 | 47997 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1901 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | ||
21832 | 84944 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1315 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2009 12:00:00 AM | 3x3 | Permit Number 53001 | 5993891.7 | 2106504.6 | 37.7637090714706 | -122.464319342417 | (37.7637090714706, -122.464319342417) | 1 | 8 | 11 | 56 | 12 | ||
21979 | 51770 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 350 Alabama St | 1 | 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 | |||
22021 | 41036 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2945 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1999 12:00:00 AM | Permit Number 41822 | 6015996.54259327 | 2101883.18402093 | 37.7522689904023 | -122.387542401366 | (37.7522689904023, -122.387542401366) | 10 | 3 | 8 | 28856 | 1 | |||
22103 | 64141 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 450 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31503 | 6003668.99323589 | 2098381.3149539 | 37.7419631631413 | -122.429923237684 | (37.7419631631413, -122.429923237684) | 2 | 7 | 5 | 63 | 22 | ||
22155 | 63733 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 530 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2015 12:00:00 AM | 15 | 4x4 | Permit Number 775931 | 6004018.97158203 | 2109769.43043188 | 37.7732520422228 | -122.429525098662 | (37.7732520422228, -122.429525098662) | 7 | 9 | 11 | 29492 | 10 |
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 | ||
22963 | 14634 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 610X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006291.3344 | 2112208.29318 | 37.7800769680727 | -122.42183794834 | (37.7800769680727, -122.42183794834) | 7 | 9 | 11 | 28852 | 41 | |||
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 | ||
23144 | 75 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 888 14TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1995 12:00:00 AM | 40 | 6002921 | 2107736 | 37.7676065137922 | -122.433177807531 | (37.7676065137922, -122.433177807531) | 15 | 5 | 5 | 28862 | 3 | |||
23302 | 32572 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3101 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37048 | 6007591.33969332 | 2103811.09310335 | 37.7570934569025 | -122.416745568241 | (37.7570934569025, -122.416745568241) | 2 | 4 | 7 | 28859 | 19 | |
23345 | 468 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2490 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009704.8170941 | 2102845.113501 | 37.7545597392567 | -122.409368154592 | (37.7545597392567, -122.409368154592) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||
23750 | 52217 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2655 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2008 12:00:00 AM | 7 | 3x3 | Permit Number 48401 | 6005661.93398 | 2119519.49914 | 37.8001161980736 | -122.424535539885 | (37.8001161980736, -122.424535539885) | 13 | 9 | 1 | 57 | 17 | |
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 |
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) );