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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119814 | 119814 | 10990 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1510X Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6016177.2650192 | 2097109.9051336003 | 37.739172558680394 | -122.386584620553 | (37.7391725586804, -122.386584620553) | |||
| 107254 | 107254 | 10991 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1510X Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6016177.2650192 | 2097109.9051336003 | 37.739172558680394 | -122.386584620553 | (37.7391725586804, -122.386584620553) | |||
| 78332 | 78332 | 11476 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 10X Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 6 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | ||
| 80896 | 80896 | 11479 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 10X Jennings St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | ||
| 24426 | 24426 | 11480 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 10X Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 1 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | ||
| 98638 | 98638 | 11485 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 10X Jennings St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | ||
| 119826 | 119826 | 11490 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 100 Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 22254 | 22254 | 16148 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 383 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/1998 12:00:00 AM | 3 | 3X3 | 5999549.4531 | 2094641.0103799999 | 37.7314590136113 | -122.443898565568 | (37.7314590136113, -122.443898565568) | ||
| 142877 | 142877 | 16478 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 9X Newhall St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/1997 12:00:00 AM | 6 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | ||
| 1748 | 1748 | 17869 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2132 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 12 | 3X3 | 6003712.3639 | 2115281.4031 | 37.788369180682295 | -122.430979161307 | (37.7883691806823, -122.430979161307) | ||
| 79339 | 79339 | 22648 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1251 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 5x6 | 6004058.9793568 | 2112500.5432525002 | 37.780753269773705 | -122.42958152263999 | (37.7807532697737, -122.42958152264) | ||
| 7495 | 7495 | 22650 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1251 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2014 12:00:00 AM | 30 | 5x6 | Permit Number 771274 | 6003965.2704 | 2112486.0639 | 37.7807082067095 | -122.42990467410401 | (37.7807082067095, -122.429904674104) | |
| 117844 | 117844 | 24729 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 7426 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2002 12:00:00 AM | 3 | 3X3 | 5983935.56611 | 2112495.9733599997 | 37.7795807585716 | -122.49919672398701 | (37.7795807585716, -122.499196723987) | ||
| 13648 | 13648 | 25580 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1511 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6016141.48149 | 2097069.66658 | 37.7390600907376 | -122.386705539738 | (37.7390600907376, -122.386705539738) | |||
| 54630 | 54630 | 30537 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 3722 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34537 | 6005491.53551058 | 2104330.95324967 | 37.7584025443246 | -122.42404447057501 | (37.7584025443246, -122.424044470575) | |||
| 142953 | 142953 | 30898 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 297 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35111 | 5997006.0436186 | 2112479.77213692 | 37.7802943673215 | -122.453979406515 | (37.7802943673215, -122.453979406515) | ||
| 112850 | 112850 | 31024 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 8 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34789 | 6006834.3629047 | 2096806.40851611 | 37.7378175725917 | -122.418866712143 | (37.7378175725917, -122.418866712143) | |||
| 136985 | 136985 | 31241 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2523 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 8 | 3x3 | Permit Number 51260 | 5991071.68732 | 2098204.4604599997 | 37.740756110504606 | -122.47346734365401 | (37.7407561105046, -122.473467343654) | |
| 56651 | 56651 | 31242 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2523 17th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50225 | 5991071.12499 | 2098214.14208 | 37.7407826611875 | -122.473469993967 | (37.7407826611875, -122.473469993967) | |
| 126334 | 126334 | 31571 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 297 Parker Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35111 | 5997006.0436186 | 2112479.77213692 | 37.7802943673215 | -122.453979406515 | (37.7802943673215, -122.453979406515) | ||
| 119563 | 119563 | 31572 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 297 Parker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35111 | 5997006.0436186 | 2112479.77213692 | 37.7802943673215 | -122.453979406515 | (37.7802943673215, -122.453979406515) | ||
| 86699 | 86699 | 32726 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 200X Farallones St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/29/1996 12:00:00 AM | 20 | 6x9 | Permit Number 37116 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) |
| 87708 | 87708 | 32729 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 200X Farallones St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/29/1996 12:00:00 AM | 12 | 3x3 | Permit Number 37116 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) |
| 172757 | 172757 | 32796 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1762 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 13 | 6x9 | Permit Number 37159 | 5999381.3452 | 2110511.5654 | 37.7750260834738 | -122.445620592615 | (37.7750260834738, -122.445620592615) |
| 184968 | 184968 | 32799 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1798 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 16 | Permit Number 37162 | 5999260.9625 | 2110496.5962 | 37.7749781082682 | -122.446035944061 | (37.7749781082682, -122.446035944061) | |
| 73199 | 73199 | 32800 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1798 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 17 | Permit Number 37162 | 5999302.9591 | 2110503.3456 | 37.7749990384826 | -122.44589115485701 | (37.7749990384826, -122.445891154857) | |
| 91194 | 91194 | 33442 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 226-228 COLERIDGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | 11 | 3x3 | Permit Number 37544 | 6006358.9 | 2098532.1 | 37.7425291518006 | -122.42063308943399 | (37.7425291518006, -122.420633089434) | |
| 122722 | 122722 | 34219 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1370 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1997 12:00:00 AM | Permit Number 38033 | 6000008.28588346 | 2109211.48049839 | 37.771492152788895 | -122.443358473205 | (37.7714921527889, -122.443358473205) | |||
| 113675 | 113675 | 34343 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1317 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2009 12:00:00 AM | 3x3 | Permit Number 52424 | 6010096.96953858 | 2101529.27558283 | 37.750968704365 | -122.40791919675101 | (37.750968704365, -122.407919196751) | ||
| 101319 | 101319 | 34727 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 425 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | Permit Number 38381 | 6001684.86819442 | 2109854.98569558 | 37.7733545230282 | -122.43760518979299 | (37.7733545230282, -122.437605189793) | |||
| 122729 | 122729 | 34740 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 705 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | Permit Number 43445 | 6007343.63156622 | 2103198.8616292 | 37.7553984743068 | -122.41755884954901 | (37.7553984743068, -122.417558849549) | ||
| 8070 | 8070 | 34969 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | Permit Number 38555 | |||||||||
| 12777 | 12777 | 34970 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | Permit Number 38555 | |||||||||
| 10743 | 10743 | 34971 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | Permit Number 38555 | |||||||||
| 4629 | 4629 | 34972 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | Permit Number 38555 | |||||||||
| 105859 | 105859 | 35067 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1596 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | 5x5 | Permit Number 38622 | 5992794.35186018 | 2104611.07661365 | 37.758446640276205 | -122.467976958338 | (37.7584466402762, -122.467976958338) | |
| 119433 | 119433 | 35068 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1596 11th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | 5x5 | Permit Number 38622 | 5992794.35186018 | 2104611.07661365 | 37.758446640276205 | -122.467976958338 | (37.7584466402762, -122.467976958338) | |
| 109047 | 109047 | 35717 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 134 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50475 | 6003705.65484578 | 2097579.13426741 | 37.739762635310505 | -122.429739271762 | (37.7397626353105, -122.429739271762) | ||
| 11714 | 11714 | 36835 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 15932 | 15932 | 36841 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 17102 | 17102 | 36842 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 2842 | 2842 | 36843 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 13876 | 13876 | 36845 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 12848 | 12848 | 36855 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 92906 | 92906 | 37472 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1319 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39943 | 5992678.14782815 | 2106476.43113031 | 37.7635617025927 | -122.46851455722799 | (37.7635617025927, -122.468514557228) | ||
| 120924 | 120924 | 38007 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2559 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40218 | 5992036.49853368 | 2098028.9849412 | 37.7403301235811 | -122.47011864707198 | (37.7403301235811, -122.470118647072) | ||
| 125166 | 125166 | 38697 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 350 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | Permit Number 40609 | 5999049.03055654 | 2111655.4434909 | 37.7781479007957 | -122.446852464186 | (37.7781479007957, -122.446852464186) | ||
| 108976 | 108976 | 38700 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 350 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | Permit Number 40609 | 5999049.03055654 | 2111655.4434909 | 37.7781479007957 | -122.446852464186 | (37.7781479007957, -122.446852464186) | ||
| 138464 | 138464 | 38701 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 350 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | Permit Number 40609 | 5999049.03055654 | 2111655.4434909 | 37.7781479007957 | -122.446852464186 | (37.7781479007957, -122.446852464186) | ||
| 112627 | 112627 | 38723 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 3001 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/1998 12:00:00 AM | Permit Number 40627 | 6008254.48795424 | 2103263.18040432 | 37.755626289704296 | -122.414413372355 | (37.7556262897043, -122.414413372355) | ||
| 58711 | 58711 | 38956 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 8 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | Permit Number 40751 | 5996587.36499389 | 2089039.02359818 | 37.715907875316404 | -122.45373463447201 | (37.7159078753164, -122.453734634472) | |||
| 128659 | 128659 | 38957 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 12 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | Permit Number 40752 | 5996558.09311124 | 2089039.4094406003 | 37.7159072565345 | -122.45383583904699 | (37.7159072565345, -122.453835839047) | |||
| 83129 | 83129 | 38958 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 16 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | Permit Number 40753 | 5996528.82123529 | 2089039.79528294 | 37.715906637665704 | -122.453937043597 | (37.7159066376657, -122.453937043597) | |||
| 126548 | 126548 | 40171 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1116 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1999 12:00:00 AM | Permit Number 41363 | 6009436.98979788 | 2102661.78090656 | 37.754041339457295 | -122.41028143257601 | (37.7540413394573, -122.410281432576) | |||
| 127731 | 127731 | 40270 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 113 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41426 | 6006709.49037908 | 2103117.55777514 | 37.7551395299146 | -122.41974613814101 | (37.7551395299146, -122.419746138141) | ||
| 142243 | 142243 | 40271 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 117 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41427 | 6006710.72414035 | 2103095.23075414 | 37.7550782945555 | -122.419740287299 | (37.7550782945555, -122.419740287299) | ||
| 110802 | 110802 | 40272 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 117 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41427 | 6006710.72414035 | 2103095.23075414 | 37.7550782945555 | -122.419740287299 | (37.7550782945555, -122.419740287299) | ||
| 87115 | 87115 | 40273 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 117 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41427 | 6006710.72414035 | 2103095.23075414 | 37.7550782945555 | -122.419740287299 | (37.7550782945555, -122.419740287299) | ||
| 82338 | 82338 | 40307 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 290 San Carlos St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1999 12:00:00 AM | Permit Number 41451 | 6006678.89773096 | 2104433.61663539 | 37.7587513999254 | -122.419945322483 | (37.7587513999254, -122.419945322483) | |||
| 125352 | 125352 | 40308 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 290 San Carlos St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1999 12:00:00 AM | Permit Number 41451 | 6006678.89773096 | 2104433.61663539 | 37.7587513999254 | -122.419945322483 | (37.7587513999254, -122.419945322483) | |||
| 85821 | 85821 | 40310 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 290 San Carlos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1999 12:00:00 AM | Permit Number 41451 | 6006678.89773096 | 2104433.61663539 | 37.7587513999254 | -122.419945322483 | (37.7587513999254, -122.419945322483) | |||
| 107825 | 107825 | 41291 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 43 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2005 12:00:00 AM | Permit Number 48376 | 6005814.23563799 | 2107007.08717813 | 37.765768791987206 | -122.42311864616 | (37.7657687919872, -122.42311864616) | ||
| 123014 | 123014 | 41299 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 309 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2000 12:00:00 AM | Permit Number 42939 | 6006925.05019077 | 2097284.78598569 | 37.7391361969704 | -122.41858707457399 | (37.7391361969704, -122.418587074574) | ||
| 65795 | 65795 | 41300 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 309 Bocana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2000 12:00:00 AM | Permit Number 42939 | 6006925.05019077 | 2097284.78598569 | 37.7391361969704 | -122.41858707457399 | (37.7391361969704, -122.418587074574) | ||
| 100590 | 100590 | 42602 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2000 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42672 | 6005206.416391299 | 2116498.11175578 | 37.791794500383794 | -122.425896619276 | (37.7917945003838, -122.425896619276) | ||
| 119807 | 119807 | 42603 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2000 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42672 | 6005206.416391299 | 2116498.11175578 | 37.791794500383794 | -122.425896619276 | (37.7917945003838, -122.425896619276) | ||
| 17915 | 17915 | 42604 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2000 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42672 | 6005206.416391299 | 2116498.11175578 | 37.791794500383794 | -122.425896619276 | (37.7917945003838, -122.425896619276) | ||
| 6782 | 6782 | 42639 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1651 Union St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/2014 12:00:00 AM | 8 | 3x3 | Permit Number 42688 | 6005258.416780001 | 2118846.41372 | 37.798245281357204 | -122.425883928195 | (37.7982452813572, -122.425883928195) |
| 119394 | 119394 | 42643 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1600X GREEN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 12 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 123614 | 123614 | 42858 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2599 31st Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | Permit Number 42787 | 5986745.41813509 | 2097587.07290157 | 37.7388094476944 | -122.488380388139 | (37.7388094476944, -122.488380388139) | ||
| 122164 | 122164 | 42972 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1178 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42857 | 6007671.24291545 | 2092548.45120306 | 37.7261732335214 | -122.41567180667299 | (37.7261732335214, -122.415671806673) | ||
| 125853 | 125853 | 42976 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 110 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42861 | 6006321.17218067 | 2093381.09781925 | 37.728383514956896 | -122.42039800876002 | (37.7283835149569, -122.42039800876) | ||
| 145909 | 145909 | 42986 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2X Yale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 3 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 142357 | 142357 | 42987 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2X Yale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 8 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 149572 | 149572 | 43131 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 10 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 13 | Permit Number 42949 | 6005359.04012 | 2093269.09738 | 37.7280217211146 | -122.42371618797199 | (37.7280217211146, -122.423716187972) | |
| 159209 | 159209 | 43237 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1755 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43024 | 5989647.1667 | 2103405.5114 | 37.754954234035296 | -122.47877303584299 | (37.7549542340353, -122.478773035843) | |
| 4391 | 4391 | 43330 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 345 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 10:55:00 AM | 3 | 3x3 | Permit Number 43087 | 6003248.07835 | 2091845.00305 | 37.723992087443904 | -122.430912250911 | (37.7239920874439, -122.430912250911) |
| 11454 | 11454 | 43480 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2000 12:00:00 AM | Permit Number 43169 | |||||||||
| 12567 | 12567 | 43481 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2000 12:00:00 AM | Permit Number 43169 | |||||||||
| 14707 | 14707 | 43482 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2000 12:00:00 AM | Permit Number 43169 | |||||||||
| 5335 | 5335 | 43483 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2000 12:00:00 AM | Permit Number 43169 | |||||||||
| 13966 | 13966 | 43484 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2000 12:00:00 AM | Permit Number 43169 | |||||||||
| 9365 | 9365 | 43485 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2000 12:00:00 AM | Permit Number 43169 | |||||||||
| 16937 | 16937 | 43486 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2000 12:00:00 AM | Permit Number 43169 | |||||||||
| 11466 | 11466 | 43487 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2000 12:00:00 AM | Permit Number 43169 | |||||||||
| 8248 | 8248 | 43488 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2000 12:00:00 AM | Permit Number 43169 | |||||||||
| 107187 | 107187 | 43508 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 365 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43185 | 6007185.94120426 | 2096295.67071243 | 37.7364349893984 | -122.417614943337 | (37.7364349893984, -122.417614943337) | ||
| 140438 | 140438 | 43510 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 328 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43187 | 6008795.38963063 | 2097297.9923892 | 37.7392775798002 | -122.412121197389 | (37.7392775798002, -122.412121197389) | ||
| 84830 | 84830 | 43511 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 332 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43188 | 6008793.48988589 | 2097277.55283539 | 37.7392213506528 | -122.412126321732 | (37.7392213506528, -122.412126321732) | ||
| 119945 | 119945 | 43535 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1860 Hayes St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2000 12:00:00 AM | Permit Number 43204 | 5998953.15578019 | 2110104.23073393 | 37.7738831913239 | -122.447072466868 | (37.7738831913239, -122.447072466868) | |||
| 127991 | 127991 | 43738 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 840 Mount Vernon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.45213982606899 | (37.7199634590291, -122.452139826069) | ||
| 140169 | 140169 | 44397 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 565 Cordova St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43752 | 6002176.67433037 | 2086290.72530889 | 37.708680505828205 | -122.43421903392901 | (37.7086805058282, -122.434219033929) | ||
| 119422 | 119422 | 44488 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 10 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43793 | 6005343.80293821 | 2093494.88287982 | 37.728640818207104 | -122.423784911051 | (37.7286408182071, -122.423784911051) | ||
| 171080 | 171080 | 45079 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2055 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 4 | Permit Number 43962 | 5987243.8715 | 2101293.373 | 37.7490150322711 | -122.486929100697 | (37.7490150322711, -122.486929100697) | |
| 141386 | 141386 | 45130 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 28 Williar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2001 12:00:00 AM | Permit Number 43988 | 5997158.09722254 | 2090807.46215117 | 37.7207962994949 | -122.45188943392701 | (37.7207962994949, -122.451889433927) | |||
| 95210 | 95210 | 45394 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 70 Corona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2001 12:00:00 AM | Permit Number 44205 | 5992817.08595268 | 2091645.26575902 | 37.722847111297 | -122.466955731171 | (37.722847111297, -122.466955731171) | ||
| 94856 | 94856 | 45395 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 70 Corona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2001 12:00:00 AM | Permit Number 44205 | 5992817.08595268 | 2091645.26575902 | 37.722847111297 | -122.466955731171 | (37.722847111297, -122.466955731171) | ||
| 56067 | 56067 | 46886 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1459 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | 5 | Permit Number 44942 | 6006067.63902 | 2118611.69594 | 37.7976465037326 | -122.423067081588 | (37.7976465037326, -122.423067081588) | |
| 110390 | 110390 | 46910 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1464 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2002 12:00:00 AM | Permit Number 44967 | 5993383.10107837 | 2105521.03376114 | 37.7609791270142 | -122.466006939197 | (37.7609791270142, -122.466006939197) | |||
| 145775 | 145775 | 49331 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 24@ 18th ST Dearborn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/25/2003 12:00:00 AM | Permit Number 46324 | 6005789.13540114 | 2105946.44196511 | 37.7628550947119 | -122.423130065007 | (37.7628550947119, -122.423130065007) |
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");