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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 268 | 268 | 46773 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 35 San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2017 12:00:00 AM | 3 | Permit Number 779460 | 6001741.72526 | 2092006.08473 | 37.7243489150655 | -122.43613098976101 | (37.7243489150655, -122.436130989761) | |
| 501 | 501 | 251171 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:21:00 AM | 3 | ||||||||
| 959 | 959 | 83601 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2008 12:00:00 AM | 5 | 6009088.96788 | 2112689.1650900003 | 37.7815547005346 | -122.41219362785499 | (37.7815547005346, -122.412193627855) | ||
| 1224 | 1224 | 59196 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 272 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/1980 12:00:00 AM | 8 | Permit Number 779761 | 6009046.37885 | 2109959.18695 | 37.7740564365968 | -122.41214796834998 | (37.7740564365968, -122.41214796835) | ||
| 1355 | 1355 | 29680 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006072.343230001 | 2117086.04016 | 37.7934577026643 | -122.422942314134 | (37.7934577026643, -122.422942314134) | ||||
| 1392 | 1392 | 29683 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/11/2012 12:00:00 AM | 5 | 6006051.34304 | 2117188.93929 | 37.793739052873704 | -122.423022293545 | (37.7937390528737, -122.423022293545) | |||
| 1703 | 1703 | 29682 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006057.50051 | 2117137.8264200003 | 37.7935990572132 | -122.422997353566 | (37.7935990572132, -122.422997353566) | ||||
| 1796 | 1796 | 29783 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2000X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 6006016.33701 | 2117432.70817 | 37.794406405577 | -122.423160753176 | (37.794406405577, -122.423160753176) | |||
| 2615 | 2615 | 253153 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2030 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2017 12:00:00 AM | Permit Number 779475 | 6015677.29531 | 2106131.10604 | 37.763915191309295 | -122.38894296750799 | (37.7639151913093, -122.388942967508) | |||
| 3117 | 3117 | 38667 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | Permit Number 40586 | ||||||||
| 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 | |||||||||
| 3790 | 3790 | 51840 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 421 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2014 12:00:00 AM | 3 | Permit Number 774213 | 6007959.333430001 | 2113036.66888 | 37.7824454124529 | -122.416126251649 | (37.7824454124529, -122.416126251649) | ||
| 4286 | 4286 | 82212 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1460 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 12:01:00 PM | 3 | 6003690.1914 | 2113730.1839 | 37.784108667349 | -122.430945121973 | (37.784108667349, -122.430945121973) | |||
| 4441 | 4441 | 35439 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38882 | ||||||||
| 4712 | 4712 | 29681 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006062.7062 | 2117112.9687900003 | 37.79353109814161 | -122.42297757386001 | (37.7935310981416, -122.42297757386) | ||||
| 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 | |||||||||
| 4985 | 4985 | 83041 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:47:00 AM | 3 | 6018722.37051 | 2097684.4746 | 37.74089078129229 | -122.377824564564 | (37.7408907812923, -122.377824564564) | |||
| 4989 | 4989 | 83048 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:41:00 AM | 3 | 6018843.8838 | 2097592.61577 | 37.7406452501696 | -122.37739803950001 | (37.7406452501696, -122.3773980395) | |||
| 5225 | 5225 | 73666 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 725 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1988 12:00:00 AM | 8 | 6007366.2246900005 | 2113649.85624 | 37.7840957097951 | -122.418221641431 | (37.7840957097951, -122.418221641431) | ||
| 5594 | 5594 | 47610 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1201 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1994 12:00:00 AM | Permit Number 45444 | ||||||||
| 5684 | 5684 | 34899 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2530 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2016 12:00:00 AM | 3 | Permit Number 38504 | 6002713.84084 | 2116933.67027 | 37.7928492537523 | -122.434552073422 | (37.7928492537523, -122.434552073422) | ||
| 6008 | 6008 | 58349 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2016 12:00:00 AM | 3 | Permit Number 17374 | 6010655.85992 | 2115362.95788 | 37.7889840970931 | -122.40696141805599 | (37.7889840970931, -122.406961418056) | ||
| 6071 | 6071 | 29679 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006078.2689 | 2117059.9303200003 | 37.7933863459523 | -122.422919954291 | (37.7933863459523, -122.422919954291) | ||||
| 6217 | 6217 | 83680 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/23/2015 03:26:00 PM | 3 | 6008994.04445 | 2113694.03545 | 37.784308507385504 | -122.412593075226 | (37.7843085073855, -122.412593075226) | |||
| 6314 | 6314 | 11065 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1725 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2013 12:00:00 AM | 3 | 6007339.78583 | 2118266.86909 | 37.7967714004466 | -122.418640632867 | (37.7967714004466, -122.418640632867) | |||
| 6660 | 6660 | 41451 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | Permit Number 42044 | 6006045.39578 | 2110879.4024400003 | 37.7764142845255 | -122.422594304391 | (37.7764142845255, -122.422594304391) | |||
| 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 | |||||||||
| 6786 | 6786 | 83606 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 59X Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2014 12:00:00 AM | 3 | Permit Number 773870 | 6009071.055480001 | 2112812.89668 | 37.7818934328697 | -122.412264344238 | (37.7818934328697, -122.412264344238) | ||
| 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 | |||||||||
| 7001 | 7001 | 108984 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2468 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | Permit Number 772908 | 6001097.74629 | 2119009.51185 | 37.7984570968878 | -122.440292758998 | (37.7984570968878, -122.440292758998) | |
| 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 | |||||||||
| 7226 | 7226 | 47614 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45446 | ||||||||
| 7395 | 7395 | 32307 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1097 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | Permit Number 36882 | ||||||||
| 7520 | 7520 | 108983 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2468 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | Permit Number 772908 | 6001114.291780001 | 2119011.40091 | 37.798463225757104 | -122.44023564217501 | (37.7984632257571, -122.440235642175) | |
| 7812 | 7812 | 73980 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/23/1986 12:00:00 AM | 3 | Permit Number 769778 | 6007997.423219999 | 2113875.47963 | 37.7847507256189 | -122.416053899389 | (37.7847507256189, -122.416053899389) | |
| 7940 | 7940 | 29678 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006081.198059999 | 2117033.1392200002 | 37.793312949587396 | -122.42290791419599 | (37.7933129495874, -122.422907914196) | ||||
| 7950 | 7950 | 29665 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006305.69135 | 2115420.12127 | 37.7888966685937 | -122.422016510665 | (37.7888966685937, -122.422016510665) | ||||
| 8218 | 8218 | 49626 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 152211th/10th Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46481 | ||||||||
| 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 | |||||||||
| 8368 | 8368 | 29666 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006311.52888 | 2115387.29695 | 37.7888068703781 | -122.42199398086099 | (37.7888068703781, -122.421993980861) | ||||
| 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 | |||||||||
| 8851 | 8851 | 35438 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38882 | ||||||||
| 8860 | 8860 | 29672 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006314.6376 | 2115355.15166 | 37.788718782705395 | -122.421980940669 | (37.7887187827054, -122.421980940669) | ||||
| 8984 | 8984 | 32308 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1097 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | Permit Number 36882 | ||||||||
| 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 | |||||||||
| 9956 | 9956 | 173750 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 989 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007621.28893018 | 2103912.36255672 | 37.7573732040434 | -122.41664916584601 | (37.7573732040434, -122.416649165846) | ||||
| 10276 | 10276 | 82028 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2787 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2017 09:51:00 AM | 3 | 6000618.2299 | 2114794.6459999997 | 37.7868568655877 | -122.441649390834 | (37.7868568655877, -122.441649390834) | |||
| 10314 | 10314 | 87635 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2401 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6011029.25458 | 2086915.6444700002 | 37.7108948899543 | -122.40366713034099 | (37.7108948899543, -122.403667130341) | ||||
| 10317 | 10317 | 87652 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2158 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2010 12:00:00 AM | 3 | 6011710.82599 | 2087552.41903 | 37.712681395911204 | -122.40135616677901 | (37.7126813959112, -122.401356166779) | |||
| 10402 | 10402 | 47618 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45446 | ||||||||
| 10935 | 10935 | 47612 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1201 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1994 12:00:00 AM | Permit Number 45444 | ||||||||
| 10994 | 10994 | 1220 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3602X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 20 | 5993502.10505 | 2087589.31821 | 37.711749968047 | -122.46429345928301 | (37.711749968047, -122.464293459283) | |||
| 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 | |||||||||
| 11869 | 11869 | 38665 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | Permit Number 40586 | ||||||||
| 11973 | 11973 | 94643 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2049X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6012360.9913099995 | 2088176.1099200002 | 37.7144301806933 | -122.39915272701401 | (37.7144301806933, -122.399152727014) | ||||
| 12140 | 12140 | 87655 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2401 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2007 12:00:00 AM | 3 | 6011107.97471 | 2087042.08104 | 37.711246456543 | -122.40340394286001 | (37.711246456543, -122.40340394286) | |||
| 12220 | 12220 | 94642 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2090 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2010 12:00:00 AM | 3 | 6012050.15275 | 2087939.7205 | 37.713763774951296 | -122.400210523116 | (37.7137637749513, -122.400210523116) | |||
| 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 | |||||||||
| 12486 | 12486 | 87650 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2148 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 3 | 6011790.09435 | 2087616.19351 | 37.7128609302491 | -122.40108666691002 | (37.7128609302491, -122.40108666691) | |||
| 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 | |||||||||
| 12596 | 12596 | 35440 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38882 | ||||||||
| 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 | |||||||||
| 13057 | 13057 | 87634 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2445 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6010990.9044699995 | 2086850.9551099997 | 37.710715123576705 | -122.403795129051 | (37.7107151235767, -122.403795129051) | ||||
| 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 | |||||||||
| 13522 | 13522 | 51772 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2095 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
| 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 | |||||||||
| 13644 | 13644 | 51780 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2900x 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
| 13689 | 13689 | 32652 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 245 05th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 37086 | 6011382.82025 | 2112467.88535 | 37.781075561520204 | -122.404242374492 | (37.7810755615202, -122.404242374492) | |
| 13780 | 13780 | 100629 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 270X 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6011502.95528 | 2112245.6234 | 37.7804719941376 | -122.403811120803 | (37.7804719941376, -122.403811120803) | ||||
| 13794 | 13794 | 51777 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2095 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
| 13812 | 13812 | 38664 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | Permit Number 40586 | ||||||||
| 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 | |||||||||
| 14165 | 14165 | 97448 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2700 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 6015860.44953 | 2102690.8206599997 | 37.7544790517769 | -122.38806939221001 | (37.7544790517769, -122.38806939221) | ||||
| 14170 | 14170 | 51783 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2900x 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
| 14187 | 14187 | 34512 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 18 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777934 | 6014465.469769999 | 2114318.75935 | 37.7863294081139 | -122.393707455231 | (37.7863294081139, -122.393707455231) | ||
| 14262 | 14262 | 35437 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38882 | ||||||||
| 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 | |||||||||
| 14485 | 14485 | 47615 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45446 | ||||||||
| 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 | |||||||||
| 14757 | 14757 | 51782 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2095 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
| 14833 | 14833 | 47617 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45446 | ||||||||
| 14971 | 14971 | 32309 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1097 Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | Permit Number 36882 | ||||||||
| 15254 | 15254 | 32651 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 245 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 37086 | 6011423.97254 | 2112425.20329 | 37.7809606659531 | -122.404097002688 | (37.7809606659531, -122.404097002688) | |
| 15325 | 15325 | 32642 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 245 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 37086 | 6011410.82425 | 2112441.1225400004 | 37.7810036418498 | -122.40414361006701 | (37.7810036418498, -122.404143610067) | |
| 15357 | 15357 | 47616 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45446 | ||||||||
| 15399 | 15399 | 35441 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38882 | ||||||||
| 15796 | 15796 | 100585 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 270x 05th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6011529.62988 | 2112216.22494 | 37.780392762953504 | -122.40371677113501 | (37.7803927629535, -122.403716771135) | ||||
| 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 | |||||||||
| 15911 | 15911 | 51784 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2900X 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
| 15914 | 15914 | 32653 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 245 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 37086 | 6011396.32164 | 2112453.5559400003 | 37.7810369707226 | -122.404194657383 | (37.7810369707226, -122.404194657383) | |
| 15987 | 15987 | 97451 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2700 03rd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 6015865.4173 | 2102637.8152 | 37.7543337851952 | -122.388048513524 | (37.7543337851952, -122.388048513524) | ||||
| 16253 | 16253 | 51775 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2095 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
| 16539 | 16539 | 51776 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2095 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
| 16669 | 16669 | 47611 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1201 Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1994 12:00:00 AM | Permit Number 45444 | ||||||||
| 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 | |||||||||
| 16707 | 16707 | 11395 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1457 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6016269.02362 | 2096619.99737 | 37.7378324505092 | -122.386233212213 | (37.7378324505092, -122.386233212213) |
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");