Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3395 | 3395 | 46141 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 3539 | 3539 | 46147 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 4975 | 4975 | 47475 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 6723 | 6723 | 36868 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 6846 | 6846 | 38806 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 7010 | 7010 | 38798 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 8297 | 8297 | 38797 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 8580 | 8580 | 36870 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9592 | 9592 | 38801 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 11087 | 11087 | 38804 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 11836 | 11836 | 38805 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 12478 | 12478 | 46150 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44491 | |||||||||
| 12569 | 12569 | 38803 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 12668 | 12668 | 38799 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 13157 | 13157 | 36846 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 13310 | 13310 | 38802 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 13534 | 13534 | 46142 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 13983 | 13983 | 47477 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 14298 | 14298 | 46149 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44491 | |||||||||
| 14565 | 14565 | 47478 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 14731 | 14731 | 38800 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 15807 | 15807 | 47476 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 16699 | 16699 | 36867 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 16882 | 16882 | 46143 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 78823 | 78823 | 12380 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/17/2013 12:00:00 AM | 3 | 3x3 | 6004345.46385 | 2113763.0093400003 | 37.7842359045501 | -122.42868045552099 | (37.7842359045501, -122.428680455521) | |||
| 80596 | 80596 | 45384 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | ||||
| 82825 | 82825 | 45388 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | ||||
| 83297 | 83297 | 48840 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2002 12:00:00 AM | Permit Number 46057 | 5993902.71442412 | 2107430.11074384 | 37.766250916351396 | -122.464348446646 | (37.7662509163514, -122.464348446646) | ||||
| 97324 | 97324 | 45386 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | ||||
| 113309 | 113309 | 45387 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | ||||
| 124016 | 124016 | 45381 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | ||||
| 139690 | 139690 | 45385 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | ||||
| 142470 | 142470 | 48842 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2002 12:00:00 AM | Permit Number 46057 | 5993902.71442412 | 2107430.11074384 | 37.766250916351396 | -122.464348446646 | (37.7662509163514, -122.464348446646) | ||||
| 145691 | 145691 | 48841 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2002 12:00:00 AM | Permit Number 46057 | 5993902.71442412 | 2107430.11074384 | 37.766250916351396 | -122.464348446646 | (37.7662509163514, -122.464348446646) | ||||
| 136838 | 136838 | 104722 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Garces Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 770294 | 5989426.465469999 | 2089157.7784799999 | 37.7158208086468 | -122.478494450472 | (37.7158208086468, -122.478494450472) | |||
| 29386 | 29386 | 177222 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5989183.517969999 | 2089355.54971 | 37.7163497314364 | -122.479348640047 | (37.7163497314364, -122.479348640047) | ||||
| 51076 | 51076 | 177220 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5989003.1682400005 | 2089530.2906900002 | 37.7168190498446 | -122.47998478988801 | (37.7168190498446, -122.479984789888) | ||||
| 70417 | 70417 | 177219 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988139.55796 | 2089802.05972 | 37.7175150450661 | -122.48298973781 | (37.7175150450661, -122.48298973781) | ||||
| 152141 | 152141 | 177221 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989179.19874 | 2089367.33922 | 37.7163818516244 | -122.479364431248 | (37.7163818516244, -122.479364431248) | ||||
| 176115 | 176115 | 177224 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5989267.30759 | 2089305.68388 | 37.716217678587704 | -122.47905538010401 | (37.7162176785877, -122.479055380104) | ||||
| 179243 | 179243 | 177223 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989192.47222 | 2089346.91127 | 37.7163265325079 | -122.47931705855 | (37.7163265325079, -122.47931705855) | ||||
| 177719 | 177719 | 192675 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Ardath Ct | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017430.4676 | 2095259.4825 | 37.7341609646599 | -122.382122877889 | (37.7341609646599, -122.382122877889) | |||
| 117013 | 117013 | 40267 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41424 | 6006673.49895553 | 2103768.88738222 | 37.756925903179706 | -122.419916824047 | (37.7569259031797, -122.419916824047) | ||
| 172639 | 172639 | 202554 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Bluxome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013758.02553 | 2111098.91503 | 37.777449115509704 | -122.395929335581 | (37.7774491155097, -122.395929335581) | |||
| 185084 | 185084 | 202555 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Bluxome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6013779.77553 | 2111120.49842 | 37.777509588621 | -122.39585560737301 | (37.777509588621, -122.395855607373) | |||
| 72883 | 72883 | 246708 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Bonview St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6007726.70462 | 2099154.93537 | 37.7443163124548 | -122.41594770744 | (37.7443163124548, -122.41594770744) | ||||
| 89279 | 89279 | 111066 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 CHURCH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776039 | 6004144.0 | 2108564.0 | 37.7699493022624 | -122.42900664813801 | (37.7699493022624, -122.429006648138) | |
| 29442 | 29442 | 228705 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002214.265869999 | 2108099.32345 | 37.7685639944579 | -122.435648302939 | (37.7685639944579, -122.435648302939) | |||
| 31038 | 31038 | 228696 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002229.37907 | 2107814.55853 | 37.767782958442 | -122.435575653008 | (37.767782958442, -122.435575653008) | |||
| 32689 | 32689 | 228700 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002223.53274 | 2107938.08202 | 37.7681217915164 | -122.435604712784 | (37.7681217915164, -122.435604712784) | |||
| 38734 | 38734 | 228703 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002218.18982 | 2108060.54864 | 37.768457751251795 | -122.435631955955 | (37.7684577512518, -122.435631955955) | |||
| 68875 | 68875 | 228710 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002204.28579 | 2108226.06827 | 37.768911437647795 | -122.43569189219 | (37.7689114376478, -122.43569189219) | |||
| 129947 | 129947 | 228699 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002226.22775 | 2107916.06493 | 37.7680614910733 | -122.435593815727 | (37.7680614910733, -122.435593815727) | |||
| 131072 | 131072 | 228701 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002218.92091 | 2108019.74793 | 37.7683457640688 | -122.435626507852 | (37.7683457640688, -122.435626507852) | |||
| 131568 | 131568 | 228707 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002211.38134 | 2108137.55369 | 37.7686688014434 | -122.43566101573799 | (37.7686688014434, -122.435661015738) | |||
| 135313 | 135313 | 228709 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002207.50573 | 2108204.04031 | 37.7688511371909 | -122.43567917847601 | (37.7688511371909, -122.435679178476) | |||
| 150780 | 150780 | 228706 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002214.15201 | 2108119.19553 | 37.7686185518295 | -122.435650118658 | (37.7686185518295, -122.435650118658) | |||
| 152852 | 152852 | 228708 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002208.68036 | 2108184.6693599997 | 37.768798016053296 | -122.435673729467 | (37.7687980160533, -122.435673729467) | |||
| 174470 | 174470 | 228698 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002228.01388 | 2107900.86391 | 37.7680198542585 | -122.435586550083 | (37.7680198542585, -122.435586550083) | |||
| 176656 | 176656 | 228702 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002219.92161 | 2108042.73438 | 37.768408936042 | -122.435624691229 | (37.768408936042, -122.435624691229) | |||
| 178992 | 178992 | 228697 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002229.3298 | 2107837.56703 | 37.7678461313291 | -122.435577469652 | (37.7678461313291, -122.435577469652) | |||
| 186154 | 186154 | 228704 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002216.55507 | 2108083.06654 | 37.7685194870101 | -122.43563922159201 | (37.7685194870101, -122.435639221592) | |||
| 38120 | 38120 | 229033 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Church St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004110.756130001 | 2108651.39041 | 37.7701873732864 | -122.42912787005599 | (37.7701873732864, -122.429127870056) | |||
| 62136 | 62136 | 229030 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Church St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004115.33651 | 2108537.43782 | 37.7698747464442 | -122.429103900418 | (37.7698747464442, -122.429103900418) | |||
| 108510 | 108510 | 48524 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.42913226260099 | (37.7703294028669, -122.429132262601) | |||
| 149128 | 149128 | 229029 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004118.1154 | 2108504.17178 | 37.7697835632819 | -122.429091916071 | (37.7697835632819, -122.429091916071) | |||
| 149764 | 149764 | 229032 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Church St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004113.21783 | 2108623.73759 | 37.7701115847144 | -122.42911738307501 | (37.7701115847144, -122.429117383075) | |||
| 157224 | 157224 | 229031 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Church St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004113.41719 | 2108591.38745 | 37.7700227703754 | -122.429114386541 | (37.7700227703754, -122.429114386541) | |||
| 70407 | 70407 | 228111 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 2ft | 5998337.908430001 | 2104673.37607 | 37.7589362690164 | -122.448809441314 | (37.7589362690164, -122.448809441314) | |||
| 123826 | 123826 | 228114 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 2ft | 5998381.85659 | 2104680.5063 | 37.758958359952295 | -122.448657962201 | (37.7589583599523, -122.448657962201) | |||
| 136765 | 136765 | 228112 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 2ft | 5998354.55607 | 2104676.41702 | 37.7589455706972 | -122.448752085261 | (37.7589455706972, -122.448752085261) | |||
| 150933 | 150933 | 228115 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 5998394.20963 | 2104681.51955 | 37.758961848437295 | -122.448615312752 | (37.7589618484373, -122.448615312752) | |||
| 169481 | 169481 | 228109 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 5998303.37296 | 2104669.01402 | 37.7589223169244 | -122.448928566402 | (37.7589223169244, -122.448928566402) | |||
| 177915 | 177915 | 228113 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 5998368.6269 | 2104678.24115 | 37.758951383917996 | -122.44870355333 | (37.758951383918, -122.44870355333) | |||
| 180113 | 180113 | 228110 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 5998319.578 | 2104671.21717 | 37.7589292929624 | -122.448872680737 | (37.7589292929624, -122.448872680737) | |||
| 168367 | 168367 | 208328 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Elmhurst Dr | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5991213.15323 | 2094380.3449 | 37.7302642498839 | -122.47269945752 | (37.7302642498839, -122.47269945752) | |||
| 54788 | 54788 | 228768 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006523.42178 | 2110145.56548 | 37.774426301663205 | -122.420888562059 | (37.7744263016632, -122.420888562059) | |||
| 83145 | 83145 | 118340 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 1 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006507.0 | 2110162.0 | 37.774470501260296 | -122.42094653529199 | (37.7744705012603, -122.420946535292) | ||||
| 121990 | 121990 | 118341 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 1 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006507.0 | 2110162.0 | 37.774470501260296 | -122.42094653529199 | (37.7744705012603, -122.420946535292) | ||||
| 136252 | 136252 | 228767 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006518.15917 | 2110170.18038 | 37.7744935916325 | -122.420908514428 | (37.7744935916325, -122.420908514428) | |||
| 94323 | 94323 | 114023 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HANGAH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010635.0 | 2117072.0 | 37.7936755489769 | -122.407154109442 | (37.7936755489769, -122.407154109442) | ||||
| 119979 | 119979 | 114021 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HANGAH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010635.0 | 2117072.0 | 37.7936755489769 | -122.407154109442 | (37.7936755489769, -122.407154109442) | ||||
| 121286 | 121286 | 114022 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HANGAH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010635.0 | 2117072.0 | 37.7936755489769 | -122.407154109442 | (37.7936755489769, -122.407154109442) | ||||
| 76166 | 76166 | 108293 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 79166 | 79166 | 108289 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 82065 | 82065 | 108279 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 84985 | 84985 | 108281 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 110031 | 110031 | 108276 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | |||
| 115108 | 115108 | 108280 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 117468 | 117468 | 108291 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 118258 | 118258 | 108278 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 119619 | 119619 | 108292 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 121945 | 121945 | 108290 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 126194 | 126194 | 108285 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 139211 | 139211 | 108277 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 141261 | 141261 | 108283 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 145921 | 145921 | 108288 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 37995 | 37995 | 228900 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Haight St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006045.73511 | 2109652.55935 | 37.7730456885414 | -122.422505934299 | (37.7730456885414, -122.422505934299) | |||
| 4932 | 4932 | 253743 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4941 | 4941 | 253741 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");