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 | |||||||||
| 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) | ||||
| 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 | |||||||||
| 13339 | 13339 | 187694 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1600 Owens St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014163.0 | 2107701.0 | 37.7681417222521 | -122.394290422795 | (37.7681417222521, -122.394290422795) | ||||
| 13341 | 13341 | 187692 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1600 Owens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014163.0 | 2107701.0 | 37.7681417222521 | -122.394290422795 | (37.7681417222521, -122.394290422795) | ||||
| 13343 | 13343 | 187696 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1600 Owens St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014163.0 | 2107701.0 | 37.7681417222521 | -122.394290422795 | (37.7681417222521, -122.394290422795) | ||||
| 13347 | 13347 | 187693 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1600 Owens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014163.0 | 2107701.0 | 37.7681417222521 | -122.394290422795 | (37.7681417222521, -122.394290422795) | ||||
| 13349 | 13349 | 187695 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1600 Owens St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014163.0 | 2107701.0 | 37.7681417222521 | -122.394290422795 | (37.7681417222521, -122.394290422795) | ||||
| 13350 | 13350 | 187691 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1600 Owens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014163.0 | 2107701.0 | 37.7681417222521 | -122.394290422795 | (37.7681417222521, -122.394290422795) | ||||
| 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 | |||||||||
| 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) | ||
| 30131 | 30131 | 55549 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 96 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50803 | 6000472.03915397 | 2104921.57169603 | 37.7597395637692 | -122.441446447904 | (37.7597395637692, -122.441446447904) | ||
| 48380 | 48380 | 95810 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 691 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767553 | 6015464.0 | 2105840.0 | 37.763104051991604 | -122.38966036521799 | (37.7631040519916, -122.389660365218) | |
| 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) | |||
| 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) | |||
| 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) | ||
| 78242 | 78242 | 49826 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1600X 18TH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | Permit Number 46611 | 6012636.0 | 2105642.0 | 37.7624031691109 | -122.39942762428998 | (37.7624031691109, -122.39942762429) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 87510 | 87510 | 51942 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 372 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2005 12:00:00 AM | Permit Number 48167 | 5986873.09199122 | 2113441.82978085 | 37.782349698863 | -122.48910425375901 | (37.782349698863, -122.489104253759) | |||
| 88434 | 88434 | 52493 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 486 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | 3x3 | Permit Number 50263 | 6007453.06515215 | 2096556.98420794 | 37.7371675263955 | -122.4167098874 | (37.7371675263955, -122.4167098874) | ||
| 88945 | 88945 | 51870 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 200 Guerrero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2005 12:00:00 AM | Permit Number 48091 | 6005428.11196013 | 2107817.72698476 | 37.7679728182494 | -122.42451183378701 | (37.7679728182494, -122.424511833787) | |||
| 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) | |||
| 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) | ||
| 94409 | 94409 | 95887 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2070 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767596 | 5990723.7 | 2101308.7 | 37.7492593902194 | -122.474897072638 | (37.7492593902194, -122.474897072638) | |
| 94425 | 94425 | 119647 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1500 Owens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6013566.0 | 2107725.0 | 37.768174418031 | -122.396357081318 | (37.768174418031, -122.396357081318) | ||||
| 94635 | 94635 | 119655 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1500 Owens St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6013566.0 | 2107725.0 | 37.768174418031 | -122.396357081318 | (37.768174418031, -122.396357081318) | ||||
| 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) | ||
| 95050 | 95050 | 119650 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1500 Owens St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6013566.0 | 2107725.0 | 37.768174418031 | -122.396357081318 | (37.768174418031, -122.396357081318) | ||||
| 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) | ||
| 98382 | 98382 | 119657 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1500 Owens St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6013566.0 | 2107725.0 | 37.768174418031 | -122.396357081318 | (37.768174418031, -122.396357081318) | ||||
| 99757 | 99757 | 119649 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1500 Owens St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6013566.0 | 2107725.0 | 37.768174418031 | -122.396357081318 | (37.768174418031, -122.396357081318) | ||||
| 100044 | 100044 | 88719 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 301 WEBSTER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51654 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | ||
| 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) | ||
| 100953 | 100953 | 49827 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1600X 18TH ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | Permit Number 46611 | 6012636.0 | 2105642.0 | 37.7624031691109 | -122.39942762428998 | (37.7624031691109, -122.39942762429) | |||
| 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) | |||
| 101492 | 101492 | 87044 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 735 07th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 49983 | 5993767.4 | 2110524.4 | 37.774739213886704 | -122.465041226452 | (37.7747392138867, -122.465041226452) | ||
| 101624 | 101624 | 119648 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1500 Owens St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6013566.0 | 2107725.0 | 37.768174418031 | -122.396357081318 | (37.768174418031, -122.396357081318) | ||||
| 101684 | 101684 | 52136 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 120 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48315 | 6005996.33565342 | 2109871.15491536 | 37.773643112422796 | -122.42269235063299 | (37.7736431124228, -122.422692350633) | ||
| 102749 | 102749 | 119658 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1500 Owens St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6013566.0 | 2107725.0 | 37.768174418031 | -122.396357081318 | (37.768174418031, -122.396357081318) | ||||
| 103880 | 103880 | 119654 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1500 Owens St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6013566.0 | 2107725.0 | 37.768174418031 | -122.396357081318 | (37.768174418031, -122.396357081318) | ||||
| 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) | |
| 106135 | 106135 | 119651 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1500 Owens St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6013566.0 | 2107725.0 | 37.768174418031 | -122.396357081318 | (37.768174418031, -122.396357081318) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 109719 | 109719 | 51869 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 200 Guerrero St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2005 12:00:00 AM | Permit Number 48091 | 6005428.11196013 | 2107817.72698476 | 37.7679728182494 | -122.42451183378701 | (37.7679728182494, -122.424511833787) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 112694 | 112694 | 52547 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 95@ ROSE Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | Permit Number 48643 | 6006064.55137364 | 2109968.2662168997 | 37.7739136051161 | -122.422463283327 | (37.7739136051161, -122.422463283327) | ||
| 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) | |||
| 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) | ||
| 114204 | 114204 | 83200 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 48 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50793 | 6002617.64925284 | 2105619.68017249 | 37.76177840191961 | -122.434075755961 | (37.7617784019196, -122.434075755961) | ||
| 115037 | 115037 | 52548 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 95@ ROSE Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | Permit Number 48643 | 6006064.55137364 | 2109968.2662168997 | 37.7739136051161 | -122.422463283327 | (37.7739136051161, -122.422463283327) | ||
| 117336 | 117336 | 119646 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1500 Owens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6013566.0 | 2107725.0 | 37.768174418031 | -122.396357081318 | (37.768174418031, -122.396357081318) | ||||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |||
| 120309 | 120309 | 119656 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1500 Owens St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6013566.0 | 2107725.0 | 37.768174418031 | -122.396357081318 | (37.768174418031, -122.396357081318) | ||||
| 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) | ||
| 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) | ||
| 122630 | 122630 | 50255 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 162 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46962 | 6004921.50153584 | 2095905.9043341 | 37.735237097105 | -122.42541634218 | (37.735237097105, -122.42541634218) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 125196 | 125196 | 87190 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 265 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | 3x3 | Permit Number 50207 | 6004174.0 | 2099531.0 | 37.74514852036221 | -122.42825900525 | (37.7451485203622, -122.42825900525) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 126849 | 126849 | 52135 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 120 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48315 | 6005996.33565342 | 2109871.15491536 | 37.773643112422796 | -122.42269235063299 | (37.7736431124228, -122.422692350633) | ||
| 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) | ||
| 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) | ||
| 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) |
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");