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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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) | ||
| 4292 | 4292 | 216904 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 242 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 08:52:00 AM | 3 | Width 3ft | 5994565.97342 | 2087471.1429299999 | 37.7114867508906 | -122.46060790712299 | (37.7114867508906, -122.460607907123) | ||
| 4427 | 4427 | 251739 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 142 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:37:00 AM | 3 | 3x3 | 6001760.0 | 2087388.0 | 37.7116697228473 | -122.435737565176 | (37.7116697228473, -122.435737565176) | ||
| 61530 | 61530 | 210062 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 224 Farallones St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994777.61707 | 2088417.5696299998 | 37.7140975898175 | -122.459944932339 | (37.7140975898175, -122.459944932339) | |||
| 134548 | 134548 | 210061 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 224 Farallones St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5994794.2029800005 | 2088418.1226 | 37.71410006202971 | -122.45988764551599 | (37.7141000620297, -122.459887645516) | |||
| 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) |
| 4118 | 4118 | 159211 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 209 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 09:04:00 AM | 3 | Width 0ft | 5998530.42986 | 2088425.22535 | 37.714333731083705 | -122.44697437828998 | (37.7143337310837, -122.44697437829) | ||
| 4011 | 4011 | 159210 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 221 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:50:00 AM | 3 | Width 0ft | 5998496.560769999 | 2088461.7916599999 | 37.71443219875 | -122.447094072659 | (37.71443219875, -122.447094072659) | ||
| 171988 | 171988 | 70909 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 8 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 18 | 6000778.8754199995 | 2088453.96135 | 37.7145408359612 | -122.439204941777 | (37.7145408359612, -122.439204941777) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 4436 | 4436 | 160539 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 766 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:48:00 AM | 3 | Width 0ft | 6001957.37061 | 2089373.1576 | 37.717131736014 | -122.435197300138 | (37.717131736014, -122.435197300138) | |
| 4429 | 4429 | 160538 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 762 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:54:00 AM | 3 | Width 0ft | 6001968.73126 | 2089389.7304599998 | 37.7171778865305 | -122.435159216538 | (37.7171778865305, -122.435159216538) | |
| 4827 | 4827 | 160418 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 645 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 04:39:00 PM | 3 | Width 0ft | 6002625.21582 | 2089488.7759200002 | 37.7174871004251 | -122.43289713470199 | (37.7174871004251, -122.432897134702) | |
| 5126 | 5126 | 210064 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 281 Ralston St | 4 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 4 | Width 3ft | 5992187.95019 | 2089731.22021 | 37.7175552771373 | -122.46899127483299 | (37.7175552771373, -122.468991274833) | |||
| 60568 | 60568 | 210065 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 281 Ralston St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992187.31943 | 2089760.63173 | 37.717635997575606 | -122.468995594294 | (37.7176359975756, -122.468995594294) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 35721 | 35721 | 210066 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 281 Ralston St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992186.75081 | 2089801.16852 | 37.7177472688886 | -122.469000508172 | (37.7177472688886, -122.469000508172) | |||
| 55371 | 55371 | 210067 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 281 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992187.12648 | 2089819.0212400001 | 37.717796309821 | -122.46900050817499 | (37.717796309821, -122.469000508175) | |||
| 187061 | 187061 | 65596 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 660 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/1990 12:00:00 AM | 26 | Permit Number 28498 | 6002534.62585 | 2089782.9928599999 | 37.718289816404706 | -122.433231273322 | (37.7182898164047, -122.433231273322) | |
| 4122 | 4122 | 216725 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 15 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 08:13:00 AM | 3 | Width 3ft | 5995301.59886 | 2090016.3450200001 | 37.7185175715201 | -122.458249508816 | (37.7185175715201, -122.458249508816) | ||
| 159474 | 159474 | 210059 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 26 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5996229.33603 | 2090073.80403 | 37.71872860732471 | -122.45504687193701 | (37.7187286073247, -122.455046871937) | |||
| 126924 | 126924 | 81400 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 246 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49724 | 5994763.99672797 | 2090230.45745087 | 37.7190745663947 | -122.46012326841002 | (37.7190745663947, -122.46012326841) | ||
| 69328 | 69328 | 210060 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 54 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5995643.813159999 | 2090256.27948 | 37.7191960335366 | -122.45708396854299 | (37.7191960335366, -122.457083968543) | |||
| 47576 | 47576 | 210063 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 830 Mount Vernon Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997086.66101 | 2090487.45579 | 37.7199135450448 | -122.452113288813 | (37.7199135450448, -122.452113288813) | |||
| 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) | ||
| 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) | |||
| 48510 | 48510 | 65202 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 415 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 29 | Permit Number 27188 | 6004121.8153800005 | 2090701.65991 | 37.7209021868562 | -122.42781045049999 | (37.7209021868562, -122.4278104505) | |
| 76963 | 76963 | 65206 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 459 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 21 | 9x12 | Permit Number 27192 | 6003301.10322 | 2090923.4573 | 37.7214647316905 | -122.43066322322201 | (37.7214647316905, -122.430663223222) |
| 89202 | 89202 | 88314 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 536 Brazil Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51305 | 6003410.9 | 2091265.7 | 37.7224106741337 | -122.430308091157 | (37.7224106741337, -122.430308091157) | |||
| 31086 | 31086 | 65191 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 367 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 20 | Permit Number 27175 | 6002591.9069300005 | 2091314.8257799998 | 37.7224991382206 | -122.433142666707 | (37.7224991382206, -122.433142666707) | |
| 42360 | 42360 | 72161 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 362 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 29 | 6002558.54368 | 2091345.46237 | 37.7225813668208 | -122.433260183829 | (37.7225813668208, -122.433260183829) | ||
| 129771 | 129771 | 78290 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 955 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 8 | 6000834.424430001 | 2091470.6153799999 | 37.722827049001104 | -122.439229031908 | (37.7228270490011, -122.439229031908) | ||
| 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) | ||
| 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) | ||
| 4428 | 4428 | 253149 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 374 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 10:27:00 AM | 3 | 3x3 | Permit Number 46728 | 6003548.0 | 2091427.0 | 37.722861333032604 | -122.429845667808 | (37.7228613330326, -122.429845667808) | |
| 57383 | 57383 | 78113 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 955 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 6 | 6000841.06544 | 2091483.71454 | 37.722863394221605 | -122.439207013809 | (37.7228633942216, -122.439207013809) | ||
| 50200 | 50200 | 72162 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 342 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 25 | 6002176.04158 | 2091749.35017 | 37.723668645372705 | -122.43461127221201 | (37.7236686453727, -122.434611272212) | ||
| 152941 | 152941 | 65194 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 275 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 19 | Permit Number 27178 | 6002912.43487 | 2091820.06668 | 37.723904594192 | -122.432070736891 | (37.723904594192, -122.432070736891) | |
| 23544 | 23544 | 65192 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 271 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 16 | Permit Number 27176 | 6002926.25519 | 2091846.82738 | 37.7239788566282 | -122.432024872357 | (37.7239788566282, -122.432024872357) | |
| 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) |
| 186496 | 186496 | 65188 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 259 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 15 | 3x3 | Permit Number 27172 | 6002967.27009 | 2091905.5125900002 | 37.7241423183013 | -122.43188727879101 | (37.7241423183013, -122.431887278791) |
| 173531 | 173531 | 65187 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 255 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 15 | Permit Number 27171 | 6002982.8034 | 2091932.08237 | 37.7242161535455 | -122.43183547875 | (37.7242161535455, -122.43183547875) | |
| 26567 | 26567 | 65184 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 233 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 17 | Permit Number 27168 | 6003041.22151 | 2092024.75933 | 37.7244739352114 | -122.43164014959 | (37.7244739352114, -122.43164014959) | |
| 12861 | 12861 | 75133 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 125 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 14 | 4x4 | 6002899.19862 | 2092441.61812 | 37.7256104849218 | -122.43216085884501 | (37.7256104849218, -122.432160858845) | |
| 11215 | 11215 | 75214 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 125 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 14 | 4x5 | 6002868.59368 | 2092460.8085599998 | 37.725661442297294 | -122.432268027453 | (37.7256614422973, -122.432268027453) | |
| 59054 | 59054 | 177528 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 151 London St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002778.05258 | 2092622.23465 | 37.7260995479431 | -122.432592546014 | (37.7260995479431, -122.432592546014) | |||
| 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) | ||
| 65437 | 65437 | 177526 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 158 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6001537.685319999 | 2093082.5457900001 | 37.7272930382249 | -122.436913353185 | (37.7272930382249, -122.436913353185) | |||
| 12818 | 12818 | 72149 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 157 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 22 | 3x3 | 6001449.82558 | 2093091.8640599998 | 37.727313630005895 | -122.437217750315 | (37.7273136300059, -122.437217750315) | |
| 12651 | 12651 | 73720 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 157 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 22 | 3x3 | 6001432.84153 | 2093102.8758 | 37.7273429002463 | -122.437277252154 | (37.7273429002463, -122.437277252154) | |
| 181177 | 181177 | 62211 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 161 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 17 | Permit Number 22333 | 6001411.760559999 | 2093118.78018 | 37.7273853716221 | -122.43735126725599 | (37.7273853716221, -122.437351267256) | |
| 123976 | 123976 | 73721 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 169 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 21 | 6001384.47149 | 2093138.9933799999 | 37.7274393210434 | -122.43744705223801 | (37.7274393210434, -122.437447052238) | ||
| 75562 | 75562 | 62235 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 201 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 25 | Permit Number 33624 | 6001134.77871 | 2093315.77185 | 37.727910515444 | -122.438322898409 | (37.727910515444, -122.438322898409) | |
| 132276 | 132276 | 72151 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 209 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 22 | 6001102.51971 | 2093339.22374 | 37.7279730740759 | -122.438436097863 | (37.7279730740759, -122.438436097863) | ||
| 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) | |
| 155548 | 155548 | 62205 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 220 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 24 | Permit Number 22327 | 6001113.38576 | 2093381.7245900002 | 37.728090389747294 | -122.438401577384 | (37.7280903897473, -122.438401577384) | |
| 4406 | 4406 | 170515 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 227 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:09:00 AM | 3 | Width 3ft | 6001017.73881 | 2093400.96927 | 37.7281377903136 | -122.438733609782 | (37.7281377903136, -122.438733609782) | ||
| 4421 | 4421 | 170514 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 233 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:11:00 AM | 3 | Width 3ft | 6001001.3973900005 | 2093412.5948700001 | 37.7281687818638 | -122.43879093525699 | (37.7281687818638, -122.438790935257) | ||
| 4398 | 4398 | 62391 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 239 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 11:14:00 AM | 3 | Permit Number 22541 | 6000966.42413 | 2093436.7300599997 | 37.7282330617995 | -122.438913567729 | (37.7282330617995, -122.438913567729) | |
| 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) | ||
| 40284 | 40284 | 72154 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 251 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 22 | 6000880.62926 | 2093500.16908 | 37.7284023690599 | -122.439214708412 | (37.7284023690599, -122.439214708412) | ||
| 130473 | 130473 | 62208 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 271 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 16 | Permit Number 22330 | 6000800.08235 | 2093553.4663799999 | 37.7285441273917 | -122.43949698130899 | (37.7285441273917, -122.439496981309) | |
| 59089 | 59089 | 72156 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 275 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 10 | 6000789.13565 | 2093562.0541400001 | 37.728567084393895 | -122.439535439929 | (37.7285670843939, -122.439535439929) | ||
| 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) | ||
| 162997 | 162997 | 177527 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 280 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6000766.09435 | 2093627.21139 | 37.728744679818 | -122.43961976396601 | (37.728744679818, -122.439619763966) | |||
| 5129 | 5129 | 253815 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 144 Paloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5991858.0 | 2093861.0 | 37.728875565325 | -122.470432347955 | (37.728875565325, -122.470432347955) | ||||
| 5158 | 5158 | 253816 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 144 Paloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5991858.0 | 2093861.0 | 37.728875565325 | -122.470432347955 | (37.728875565325, -122.470432347955) | ||||
| 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) |
| 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) |
| 130800 | 130800 | 210081 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 895 Darien Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994340.20261 | 2093967.5512 | 37.7293113381429 | -122.461858986406 | (37.7293113381429, -122.461858986406) | |||
| 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) | ||
| 164295 | 164295 | 50028 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 311 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 11 | Permit Number 46758 | 6008950.6958 | 2094817.37342 | 37.732475049678 | -122.411409014325 | (37.732475049678, -122.411409014325) | |
| 157514 | 157514 | 210086 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 318 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6000783.6649 | 2095060.05805 | 37.7326799458246 | -122.439661702027 | (37.7326799458246, -122.439661702027) | |||
| 133741 | 133741 | 210089 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 307 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000737.29959 | 2095071.19 | 37.7327078724724 | -122.43982279579599 | (37.7327078724724, -122.439822795796) | |||
| 47560 | 47560 | 210085 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 224 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001434.36658 | 2095084.51158 | 37.7327841043881 | -122.43741382050501 | (37.7327841043881, -122.437413820505) |
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");