Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9112 | 9112 | 122861 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:43:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9209 | 9209 | 122858 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:48:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9268 | 9268 | 122855 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:30:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9272 | 9272 | 122860 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:54:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9280 | 9280 | 122859 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:46:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9291 | 9291 | 122856 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:13:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9327 | 9327 | 122854 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:40:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9354 | 9354 | 122862 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:57:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9406 | 9406 | 122857 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:17:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 85331 | 85331 | 115871 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 84X Cordova St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/29/2016 12:00:00 AM | 3 | Permit Number 775902. On Athens St frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | ||
| 10028 | 10028 | 161764 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 142 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779227 | 6000990.7389 | 2087787.91218 | 37.7127240669257 | -122.43842496696001 | (37.7127240669257, -122.43842496696) | |
| 42751 | 42751 | 108789 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 82210 | 82210 | 108786 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 84872 | 84872 | 108785 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 99997 | 99997 | 108787 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 142924 | 142924 | 108788 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 19942 | 19942 | 26077 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 261 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 02:44:00 PM | 3 | 3X3 | 5994378.441000001 | 2088053.8388 | 37.7130759052536 | -122.461298276453 | (37.7130759052536, -122.461298276453) | ||
| 97339 | 97339 | 85212 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 229 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2007 12:00:00 AM | 3 | 3x3 | maintenance agreement through 7/2/2010 | 5994738.0 | 2088050.0 | 37.7130860517587 | -122.46005525076299 | (37.7130860517587, -122.460055250763) | |
| 116632 | 116632 | 29949 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 239 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3x3 | 5994631.9727903 | 2088054.39173388 | 37.7130920115953 | -122.460422031825 | (37.7130920115953, -122.460422031825) | ||
| 98063 | 98063 | 29947 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 203 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 3x3 | 5994985.99771987 | 2088049.72518423 | 37.7130995578919 | -122.45919807332301 | (37.7130995578919, -122.459198073323) | ||
| 163 | 163 | 29943 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 242 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:23:00 PM | 3 | 3x3 | 5994593.32204167 | 2088106.90572275 | 37.7132339790874 | -122.460559423837 | (37.7132339790874, -122.460559423837) | ||
| 78942 | 78942 | 29941 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 3x3 | 5995006.35114609 | 2088101.46141456 | 37.7132427835292 | -122.459131469448 | (37.7132427835292, -122.459131469448) | ||
| 107773 | 107773 | 26043 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 3X3 | 5996178.64561 | 2088089.5286700001 | 37.7132773431944 | -122.455078779743 | (37.7132773431944, -122.455078779743) | ||
| 88818 | 88818 | 18610 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 615 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778725 | 5992407.5548851 | 2088503.1314627 | 37.7141959284164 | -122.468142922603 | (37.7141959284164, -122.468142922603) | |
| 143672 | 143672 | 18582 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993482.998785401 | 2088541.1278418999 | 37.7143623091404 | -122.46442855867399 | (37.7143623091404, -122.464428558674) | ||
| 145771 | 145771 | 18583 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993482.998785401 | 2088541.1278418999 | 37.7143623091404 | -122.46442855867399 | (37.7143623091404, -122.464428558674) | ||
| 108188 | 108188 | 25464 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 308 Randolph St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/24/1998 12:00:00 AM | 3 | 3X3 | 5993086.26773 | 2088550.30696 | 37.714364635542395 | -122.46580047311001 | (37.7143646355424, -122.46580047311) | ||
| 77490 | 77490 | 25459 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2003 12:00:00 AM | 3 | 3X3 | 5993585.96467 | 2088543.99773 | 37.714376124024504 | -122.464072878916 | (37.7143761240245, -122.464072878916) | ||
| 92289 | 92289 | 25458 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2003 12:00:00 AM | 3 | 3X3 | 5993547.93552 | 2088545.97374 | 37.7143793578368 | -122.464204465034 | (37.7143793578368, -122.464204465034) | ||
| 81791 | 81791 | 115420 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 248 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 772989 | 5994528.8 | 2089058.5 | 37.7158431194451 | -122.46085135599199 | (37.7158431194451, -122.460851355992) | ||
| 130663 | 130663 | 52526 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 143 Rome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 3 | Permit Number 48626 | 5998907.21488 | 2089072.37485 | 37.7161321755247 | -122.445718577547 | (37.7161321755247, -122.445718577547) | |
| 4672 | 4672 | 160512 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 718 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:07:00 PM | 3 | Width 0ft | 6001887.21385 | 2089766.7884 | 37.7182085743334 | -122.43546794121 | (37.7182085743334, -122.43546794121) | |
| 82309 | 82309 | 109567 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 56 Seneca Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775012 | 6000375.8 | 2089821.0 | 37.7182714712375 | -122.440696127295 | (37.7182714712375, -122.440696127295) |
| 4720 | 4720 | 160434 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 France Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 12:17:00 PM | 3 | Width 0ft | 6002057.78511 | 2089843.09143 | 37.7184277715106 | -122.434883803643 | (37.7184277715106, -122.434883803643) | |
| 14801 | 14801 | 22531 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6619 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2015 08:00:00 AM | 3 | 3X3 | 6012836.07271 | 2089639.80613 | 37.7184756630977 | -122.397613243265 | (37.7184756630977, -122.397613243265) | ||
| 4732 | 4732 | 160902 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 687 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 03:13:00 PM | 3 | Width 0ft | 6002042.96964 | 2089934.48855 | 37.718677886450294 | -122.43494154733101 | (37.7186778864503, -122.434941547331) | |
| 4637 | 4637 | 160693 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:34:00 PM | 3 | Width 0ft | 6003044.40323 | 2089957.59001 | 37.7187981275985 | -122.431481646786 | (37.7187981275985, -122.431481646786) | |
| 93952 | 93952 | 108380 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 286 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773804 | 6004439.17229 | 2090775.7474099998 | 37.7211235626427 | -122.426718715963 | (37.7211235626427, -122.426718715963) |
| 4758 | 4758 | 161382 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 523 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2017 03:54:00 PM | 3 | Width 0ft | 6002614.99011 | 2090841.7835900001 | 37.721201579268495 | -122.43302909312901 | (37.7212015792685, -122.433029093129) | ||
| 4745 | 4745 | 253432 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:09:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
| 4788 | 4788 | 253430 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:04:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
| 4805 | 4805 | 253431 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:07:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
| 4352 | 4352 | 178029 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 398x Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 10:03:00 AM | 3 | Width 3ft | 6003930.0 | 2091029.0 | 37.7217901378795 | -122.428496818895 | (37.7217901378795, -122.428496818895) | ||
| 4320 | 4320 | 178028 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 398x Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 09:59:00 AM | 3 | Width 3ft | 6004185.0 | 2091264.0 | 37.7224498233553 | -122.427632084441 | (37.7224498233553, -122.427632084441) | ||
| 89000 | 89000 | 108555 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 68X Wanda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773714 | 6000555.61606 | 2091513.15028 | 37.7229279706553 | -122.440195859767 | (37.7229279706553, -122.440195859767) |
| 66829 | 66829 | 180437 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008563.45544 | 2091354.3626700002 | 37.7229446335792 | -122.41250309714701 | (37.7229446335792, -122.412503097147) | |||
| 69274 | 69274 | 25308 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 279X Ocean Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2011 12:00:00 AM | 3 | 3x3 | 6000039.97311 | 2091577.8604700002 | 37.7230762793257 | -122.44198296803499 | (37.7230762793257, -122.441982968035) | ||
| 173467 | 173467 | 180439 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008542.9646 | 2091418.4171799999 | 37.723119363752396 | -122.41257845583701 | (37.7231193637524, -122.412578455837) | |||
| 152200 | 152200 | 180431 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 247 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000123.6007 | 2091618.30287 | 37.723192090118104 | -122.44169678599701 | (37.7231920901181, -122.441696785997) | |||
| 11064 | 11064 | 25312 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 163 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3 | 3X3 | 6000515.96101 | 2091667.5202400002 | 37.7233495775944 | -122.440344004183 | (37.7233495775944, -122.440344004183) | ||
| 78777 | 78777 | 25313 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 131 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/24/1998 12:00:00 AM | 3 | 3X3 | 6000709.1204 | 2091674.68705 | 37.723380252154605 | -122.439676803494 | (37.7233802521546, -122.439676803494) | ||
| 82363 | 82363 | 28573 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1220X Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995089.2906 | 2091962.0897099997 | 37.72384792002239 | -122.459124181231 | (37.7238479200224, -122.459124181231) | ||
| 104360 | 104360 | 28574 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1220X Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995089.2906 | 2091962.0897099997 | 37.72384792002239 | -122.459124181231 | (37.7238479200224, -122.459124181231) | ||
| 128535 | 128535 | 28571 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1220X Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995089.2906 | 2091962.0897099997 | 37.72384792002239 | -122.459124181231 | (37.7238479200224, -122.459124181231) | ||
| 145812 | 145812 | 28572 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1220X Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995089.2906 | 2091962.0897099997 | 37.72384792002239 | -122.459124181231 | (37.7238479200224, -122.459124181231) | ||
| 169259 | 169259 | 38181 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 50 Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767436 | 6011332.25565 | 2091638.61946 | 37.723880142534 | -122.40295185454599 | (37.723880142534, -122.402951854546) |
| 78972 | 78972 | 28575 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
| 82629 | 82629 | 28579 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3x3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
| 86549 | 86549 | 28577 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
| 114325 | 114325 | 28578 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
| 120407 | 120407 | 28576 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
| 140327 | 140327 | 28595 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1418 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 3 | 3X3 | 5995511.49061 | 2092119.93233 | 37.724305580756 | -122.45767612998999 | (37.724305580756, -122.45767612999) | ||
| 116363 | 116363 | 108569 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 586 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773764 | 6010254.2951 | 2091832.3673599998 | 37.7243518811862 | -122.40669185444901 | (37.7243518811862, -122.406691854449) |
| 26540 | 26540 | 70481 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 934 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 3 | 6005107.91916 | 2092023.60961 | 37.7245877066523 | -122.424495766183 | (37.7245877066523, -122.424495766183) | ||
| 4422 | 4422 | 253158 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 07:47:00 AM | 3 | 3x3 | 6004446.0 | 2092174.0 | 37.7249632430066 | -122.426794641082 | (37.7249632430066, -122.426794641082) | ||
| 10663 | 10663 | 110033 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 206 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775206 | 6003103.36951 | 2092214.97197 | 37.724999739126794 | -122.431438884895 | (37.7249997391268, -122.431438884895) |
| 140816 | 140816 | 107323 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 752 CAYUGA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 4x2 | Permit Number 773710 | 6001347.5 | 2092637.6 | 37.726060507123705 | -122.43753897171801 | (37.7260605071237, -122.437538971718) | |
| 168011 | 168011 | 180473 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008102.7284699995 | 2092853.30423 | 37.727034540698206 | -122.414201739328 | (37.7270345406982, -122.414201739328) | |||
| 139858 | 139858 | 109529 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 33 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774999 | 5993241.2 | 2093283.4 | 37.7273694976755 | -122.465608622621 | (37.7273694976755, -122.465608622621) |
| 148915 | 148915 | 180433 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 25 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003815.49396 | 2093259.7707900002 | 37.727908858899795 | -122.429051608444 | (37.7279088588998, -122.429051608444) | |||
| 112324 | 112324 | 25284 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 3 | 3X3 | 5992640.87111 | 2093746.9102599998 | 37.728607537869294 | -122.46771763720699 | (37.7286075378693, -122.467717637207) | ||
| 10929 | 10929 | 28307 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2003 12:00:00 AM | 3 | 6000526.74804 | 2093584.98162 | 37.7286151010044 | -122.440444169789 | (37.7286151010044, -122.440444169789) | |||
| 11707 | 11707 | 28306 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 6000533.35164 | 2093598.6883900003 | 37.7286531126447 | -122.440422323457 | (37.7286531126447, -122.440422323457) | |||
| 12474 | 12474 | 28305 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 6000543.0489 | 2093613.5897099997 | 37.7286945803894 | -122.440389867794 | (37.7286945803894, -122.440389867794) | |||
| 129239 | 129239 | 108878 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 275 Staples Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773301 | 5998271.57935 | 2093779.45417 | 37.7290204086136 | -122.44825438236 | (37.7290204086136, -122.44825438236) | |
| 78080 | 78080 | 15703 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4260 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2009 12:00:00 AM | 3 | 3X3 | 6003241.43292 | 2093747.9611099998 | 37.7292168076411 | -122.431070980005 | (37.7292168076411, -122.431070980005) | ||
| 12427 | 12427 | 35723 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 80 Dartmouth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 772467 | 6008403.94814 | 2093755.2917799999 | 37.729528120608 | -122.41322417987499 | (37.729528120608, -122.413224179875) | |
| 118476 | 118476 | 109665 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 230X Craut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775017 | 6004046.411069999 | 2093890.0445599998 | 37.729652518606 | -122.42829822368 | (37.729652518606, -122.42829822368) |
| 123793 | 123793 | 25217 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2395 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5992118.57098 | 2094231.7213 | 37.7299085366508 | -122.469558520109 | (37.7299085366508, -122.469558520109) | ||
| 62060 | 62060 | 44209 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 170 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | 3 | Permit Number 43657 | 6004467.73015 | 2094024.43109 | 37.7300453450179 | -122.426851245286 | (37.7300453450179, -122.426851245286) | ||
| 81259 | 81259 | 25214 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2425 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3 | 3X3 | 5991946.77441 | 2094328.2654 | 37.7301636922535 | -122.47015946302601 | (37.7301636922535, -122.470159463026) | ||
| 13559 | 13559 | 106005 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 59 Reddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6013632.51665 | 2093922.487 | 37.7302793593954 | -122.395160068985 | (37.7302793593954, -122.395160068985) | ||
| 12988 | 12988 | 904 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1179 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2016 12:00:00 AM | 3 | 2X2 | 6003419.3756099995 | 2094263.29224 | 37.7306418725253 | -122.430492572378 | (37.7306418725253, -122.430492572378) | ||
| 167921 | 167921 | 104000 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 157 Apollo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2013 12:00:00 AM | 3 | 3x3 | Permit Number 58584 | 6012594.010480001 | 2094120.56345 | 37.7307654285701 | -122.39876424420099 | (37.7307654285701, -122.398764244201) | |
| 123665 | 123665 | 29663 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2200X Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 5991214.62649 | 2094785.7483599999 | 37.731377471178206 | -122.472723912001 | (37.7313774711782, -122.472723912001) | |||
| 66929 | 66929 | 198422 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1196 La Salle Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017170.944180001 | 2094491.5929599998 | 37.7320381554174 | -122.38296671716199 | (37.7320381554174, -122.382966717162) | |||
| 12132 | 12132 | 99909 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 210 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774553 | 6009399.78383 | 2095020.3189400001 | 37.7330574731105 | -122.40987072487499 | (37.7330574731105, -122.409870724875) | |
| 92920 | 92920 | 108889 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 534 Mangels Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773372 | 5997888.03427 | 2095280.4903 | 37.7331199631343 | -122.449688444288 | (37.7331199631343, -122.449688444288) | |
| 162876 | 162876 | 219443 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 550 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5997790.17005 | 2095292.68219 | 37.733147839699896 | -122.45002766386699 | (37.7331478396999, -122.450027663867) | ||||
| 17386 | 17386 | 857 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 400X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2015 09:50:00 AM | 3 | 3x3 | 6008157.97396 | 2095088.68273 | 37.7331755118234 | -122.41416883853701 | (37.7331755118234, -122.414168838537) | ||
| 9629 | 9629 | 173614 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2955 20th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776469 | 5990236.78382 | 2095590.4495400002 | 37.7335303227244 | -122.476163213901 | (37.7335303227244, -122.476163213901) | |
| 9631 | 9631 | 173613 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2955 20th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776469 | 5990236.78382 | 2095590.4495400002 | 37.7335303227244 | -122.476163213901 | (37.7335303227244, -122.476163213901) | |
| 104977 | 104977 | 52781 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6X Murray St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48826 | 6004650.74465418 | 2095312.97087544 | 37.733593733659795 | -122.42631024629 | (37.7335937336598, -122.42631024629) | |
| 107614 | 107614 | 52782 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6X Murray St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48826 | 6004650.74465418 | 2095312.97087544 | 37.733593733659795 | -122.42631024629 | (37.7335937336598, -122.42631024629) | |
| 48995 | 48995 | 52026 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 55 Elmira St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2005 12:00:00 AM | 3 | Permit Number 48241 | 6011182.7446 | 2096571.6762 | 37.7374169340467 | -122.403815649781 | (37.7374169340467, -122.403815649781) | ||
| 74858 | 74858 | 198278 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 55 Elmira St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011181.32508 | 2096617.93728 | 37.7375438778404 | -122.403823812042 | (37.7375438778404, -122.403823812042) | |||
| 9186 | 9186 | 10962 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1431 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 3 | 3X4 | 6016563.2925523 | 2096760.0557493 | 37.7382333059102 | -122.385225528118 | (37.7382333059102, -122.385225528118) | ||
| 22225 | 22225 | 15638 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3620 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774763 | 6005333.2664 | 2097101.2564 | 37.7385425216055 | -122.42407769940901 | (37.7385425216055, -122.424077699409) | |
| 77786 | 77786 | 124717 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 610 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 775784 | 6007724.21349 | 2097196.46477 | 37.738938646129704 | -122.41581766964899 | (37.7389386461297, -122.415817669649) | |
| 86220 | 86220 | 124718 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 610 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 775784 | 6007724.21349 | 2097196.46477 | 37.738938646129704 | -122.41581766964899 | (37.7389386461297, -122.415817669649) |
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");