Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 638 | 638 | 251341 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | 3x3 | Permit Number 37503 | 5992527.0 | 2093770.0 | 37.7286643609316 | -122.46811297163299 | (37.7286643609316, -122.468112971633) | ||
| 864 | 864 | 37366 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 125 Street | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39871 | ||||||||
| 963 | 963 | 251419 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 970 | 970 | 251418 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 1005 | 1005 | 131220 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 411 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1994 12:00:00 AM | 8 | Width 5ft | Permit Number 33166 | 6008433.24487 | 2113895.82908 | 37.7848310944226 | -122.414547535863 | (37.7848310944226, -122.414547535863) | |
| 1402 | 1402 | 108699 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2956 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774624 | 6001032.64864 | 2118516.20126 | 37.797098889465 | -122.4404826167 | (37.797098889465, -122.4404826167) |
| 1852 | 1852 | 178671 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 624 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6002757.8843 | 2087321.68 | 37.7115442544376 | -122.432283877092 | (37.7115442544376, -122.432283877092) | |||
| 1977 | 1977 | 35358 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 861 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2017 12:00:00 AM | 3 | Permit Number 779956 | 6011891.4551800005 | 2104381.4501400003 | 37.758900452609794 | -122.401914128638 | (37.7589004526098, -122.401914128638) | |
| 2598 | 2598 | 110677 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1717 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2015 12:00:00 AM | 3 | 6009154.39159 | 2119176.95818 | 37.7993722757787 | -122.412426018055 | (37.7993722757787, -122.412426018055) | ||
| 3166 | 3166 | 210180 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 433 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 10 | Width 2ft | Permit Number 42521 | 6000082.86486 | 2095135.8413200001 | 37.7328481163341 | -122.4420899714 | (37.7328481163341, -122.4420899714) | |
| 3180 | 3180 | 210181 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 433 Congo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 12 | Width 2ft | Permit Number 42521 | 6000081.5883599995 | 2095118.51755 | 37.7328004765596 | -122.442093141495 | (37.7328004765596, -122.442093141495) | |
| 3253 | 3253 | 120896 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3760 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2016 12:00:00 AM | 3 | 2x6 | Permit Number 778876 | 6002561.2369800005 | 2121569.64726 | 37.805569771989205 | -122.43541187026399 | (37.8055697719892, -122.435411870264) | |
| 3609 | 3609 | 246906 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 491 Frederick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2010 12:00:00 AM | 3 | Width 5ft | Permit Number 53958 | 5997348.6484 | 2107404.24528 | 37.7663779224388 | -122.45242781498699 | (37.7663779224388, -122.452427814987) | |
| 3881 | 3881 | 232104 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 308 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1997 12:00:00 AM | 12 | Width 3ft | Permit Number 38019 | 6004039.72435 | 2096794.4699099998 | 37.7376270372551 | -122.42852828485901 | (37.7376270372551, -122.428528284859) | |
| 4151 | 4151 | 216680 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 430 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 07:33:00 AM | 3 | Width 3ft | 5995444.86919 | 2090582.23732 | 37.720079609356205 | -122.45779521180401 | (37.7200796093562, -122.457795211804) | ||
| 4208 | 4208 | 163311 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 261 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 08:33:00 AM | 3 | Width 0ft | 5994382.20064 | 2087745.46311 | 37.7122293948338 | -122.46126294184201 | (37.7122293948338, -122.461262941842) | ||
| 4262 | 4262 | 163377 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 210 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 08:24:00 AM | 3 | Width 0ft | 5994919.0 | 2087792.0 | 37.7123880531541 | -122.45941098523701 | (37.7123880531541, -122.459410985237) | ||
| 4263 | 4263 | 163376 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 204 Sadowa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 08:04:00 AM | 3 | Width 0ft | 5994976.692009999 | 2087776.5788200002 | 37.7123490271688 | -122.45921046950899 | (37.7123490271688, -122.459210469509) | ||
| 4269 | 4269 | 163375 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 204 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 07:56:00 AM | 3 | Width 0ft | 5994989.76466 | 2087776.26613 | 37.712348920149104 | -122.45916526416799 | (37.7123489201491, -122.459165264168) | ||
| 4397 | 4397 | 251730 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 536 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:34:00 AM | 3 | 3x3 | 6002599.0 | 2087392.0 | 37.71172832759 | -122.432838043044 | (37.71172832759, -122.432838043044) | ||
| 4829 | 4829 | 187456 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 4727 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1995 12:00:00 AM | 1 | Width 0ft | 6001715.1447 | 2091405.3885 | 37.722698028608 | -122.43617990767099 | (37.722698028608, -122.436179907671) | ||
| 4920 | 4920 | 224837 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 268 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2017 12:40:00 PM | 3 | Width 3ft | 6004749.38547 | 2102099.60781 | 37.752233863708895 | -122.42645227906601 | (37.7522338637089, -122.426452279066) | ||
| 5259 | 5259 | 42922 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42829 | |||||||||
| 5550 | 5550 | 37365 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 125 Street | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39871 | ||||||||
| 7765 | 7765 | 18879 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2315 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/1998 12:00:00 AM | 3 | 3X3 | 6003607.44812 | 2115913.14135 | 37.790097828305 | -122.431387267427 | (37.790097828305, -122.431387267427) | ||
| 8432 | 8432 | 22657 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5x6 | 6004182.2536 | 2112515.9686 | 37.780802603117706 | -122.42915615755899 | (37.7808026031177, -122.429156157559) | |||
| 8985 | 8985 | 106565 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3036 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773498 | 6001472.42472 | 2118868.9622400003 | 37.7980925099205 | -122.438986180768 | (37.7980925099205, -122.438986180768) | |
| 9103 | 9103 | 24126 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 140X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1997 12:00:00 AM | 9 | 3X3 | 6016343.6401634 | 2095980.6654178002 | 37.736081103602096 | -122.38593067194799 | (37.7360811036021, -122.385930671948) | ||
| 9111 | 9111 | 10861 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X HUDSON AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 9153 | 9153 | 24125 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 140X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2016 12:00:00 AM | 3 | 3X3 | 6016343.6401634 | 2095980.6654178002 | 37.736081103602096 | -122.38593067194799 | (37.7360811036021, -122.385930671948) | ||
| 9157 | 9157 | 10857 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X HUDSON AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 9247 | 9247 | 24150 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 100X Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1996 12:00:00 AM | 7 | 3x3 | 6016357.373923 | 2096088.8828188 | 37.736379006835996 | -122.385890729183 | (37.736379006836, -122.385890729183) | ||
| 9276 | 9276 | 24081 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 141X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2001 12:00:00 AM | 3 | 3X3 | 6016393.5495733 | 2095983.6738742 | 37.7360921261264 | -122.38575832291299 | (37.7360921261264, -122.385758322913) | ||
| 9330 | 9330 | 24138 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 120X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/1997 12:00:00 AM | 9 | 3x3 | 6016341.404377299 | 2096017.7564546003 | 37.736182824394206 | -122.38594098669901 | (37.7361828243942, -122.385940986699) | ||
| 9342 | 9342 | 24095 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 105X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1996 12:00:00 AM | 5 | 3x3 | 6016397.2233978 | 2096041.0813580002 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | ||
| 9378 | 9378 | 24087 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 141X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2000 12:00:00 AM | 9 | 3X3 | 6016393.5495733 | 2095983.6738742 | 37.7360921261264 | -122.38575832291299 | (37.7360921261264, -122.385758322913) | ||
| 9427 | 9427 | 24136 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 120X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1996 12:00:00 AM | 6 | 3x3 | 6016341.404377299 | 2096017.7564546003 | 37.736182824394206 | -122.38594098669901 | (37.7361828243942, -122.385940986699) | ||
| 9483 | 9483 | 24137 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 120X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1996 12:00:00 AM | 12 | 3x3 | 6016341.404377299 | 2096017.7564546003 | 37.736182824394206 | -122.38594098669901 | (37.7361828243942, -122.385940986699) | ||
| 9769 | 9769 | 159355 | Planning Code 138.1 required 4 | Melaleuca quinquenervia :: Cajeput 50 | 417 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998509.882680001 | 2087558.1907400002 | 37.7119518775514 | -122.44698304145001 | (37.7119518775514, -122.44698304145) | |
| 10286 | 10286 | 109713 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 643 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774155 | 6002421.08479 | 2090027.9033099997 | 37.7189558444233 | -122.43364123018 | (37.7189558444233, -122.43364123018) |
| 10294 | 10294 | 15756 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 4669 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1995 12:00:00 AM | 6 | 3X3 | 6001905.7706 | 2091706.1989 | 37.723534814894 | -122.435542465485 | (37.723534814894, -122.435542465485) | ||
| 10551 | 10551 | 15791 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 4859 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1995 12:00:00 AM | 7 | 3x3 | 6001243.5294 | 2090654.0842 | 37.720608310371794 | -122.437756393358 | (37.7206083103718, -122.437756393358) | ||
| 10706 | 10706 | 15766 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 4760 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1995 12:00:00 AM | 12 | 3X3 | 6001476.2489 | 2091134.8369 | 37.721941579108794 | -122.436986357081 | (37.7219415791088, -122.436986357081) | ||
| 10774 | 10774 | 15813 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 5017 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000686.592 | 2089771.9365 | 37.71815444799179 | -122.439618338087 | (37.7181544479918, -122.439618338087) | ||
| 11613 | 11613 | 15789 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 4855 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1995 12:00:00 AM | 8 | 3x3 | 6001259.5956 | 2090679.9975 | 37.720680375992295 | -122.437702712586 | (37.7206803759923, -122.437702712586) | ||
| 11621 | 11621 | 76445 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 3x3 | 5998808.0264099995 | 2086988.0844400001 | 37.710403523785 | -122.445911599067 | (37.710403523785, -122.445911599067) | |
| 11828 | 11828 | 15762 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 4731 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1995 12:00:00 AM | 6 | 3X3 | 6001687.4296 | 2091360.7739 | 37.722573952286794 | -122.436272521266 | (37.7225739522868, -122.436272521266) | ||
| 11931 | 11931 | 15807 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 4959 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1995 12:00:00 AM | 6 | 3X3 | 6000887.0139999995 | 2090089.1979 | 37.719036981600496 | -122.43894829066299 | (37.7190369816005, -122.438948290663) | ||
| 12038 | 12038 | 15746 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 4585 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1995 12:00:00 AM | 6 | 4x4 | 6002220.4386 | 2092206.761 | 37.72492711289 | -122.434490488851 | (37.72492711289, -122.434490488851) | ||
| 12073 | 12073 | 109711 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 46 Wanda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773351 | 6000527.40359 | 2091492.50948 | 37.7228696894556 | -122.44029190466999 | (37.7228696894556, -122.44029190467) |
| 12125 | 12125 | 15819 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 5050 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/11/2001 12:00:00 AM | 12 | 3X3 | 6000495.0068 | 2089582.3782 | 37.717623057493896 | -122.440266977896 | (37.7176230574939, -122.440266977896) | ||
| 12187 | 12187 | 50191 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 347 Richard Av | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2003 12:00:00 AM | Permit Number 46897 | ||||||||
| 12197 | 12197 | 15810 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 5006 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778853 | 6000668.1276 | 2089853.0317 | 37.7183760661823 | -122.43968797212901 | (37.7183760661823, -122.439687972129) | |
| 12245 | 12245 | 72809 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 3x3 | 5998733.92072 | 2087172.14442 | 37.710904679081395 | -122.446180954109 | (37.7109046790814, -122.446180954109) | |
| 12251 | 12251 | 97320 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1044 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774147 | 5989913.4382 | 2099069.7096 | 37.7430647189098 | -122.47753531433399 | (37.7430647189098, -122.477535314334) | |
| 12523 | 12523 | 66532 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3722 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/1991 12:00:00 AM | 18 | 3x3 | Permit Number 29707 | 5984457.3026 | 2098196.9463 | 37.7403502256776 | -122.496336488295 | (37.7403502256776, -122.496336488295) | |
| 12678 | 12678 | 108261 | Planning Code 138.1 required 4 | Melaleuca quinquenervia :: Cajeput 50 | 379 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774479 | 6002548.02456 | 2091247.69967 | 37.7223123355393 | -122.43328956378201 | (37.7223123355393, -122.433289563782) | |
| 12983 | 12983 | 73822 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 3x3 | 5998761.76944 | 2087100.1867 | 37.7107086898252 | -122.44607953033999 | (37.7107086898252, -122.44607953034) | |
| 12985 | 12985 | 76427 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 3 | 3x3 | 5998792.69271 | 2087037.2667900003 | 37.710537691825294 | -122.445968130449 | (37.7105376918253, -122.445968130449) | |
| 13062 | 13062 | 15760 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 4726 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1995 12:00:00 AM | 6 | 3X3 | 6001637.4054 | 2091396.9197 | 37.7226703580975 | -122.43644802923201 | (37.7226703580975, -122.436448029232) | ||
| 13626 | 13626 | 25954 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2424 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6011648.47337 | 2098048.0207700003 | 37.741496669839705 | -122.402309171152 | (37.7414966698397, -122.402309171152) | ||
| 13918 | 13918 | 25904 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1700 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/1997 12:00:00 AM | 3 | 3X3 | 6014497.75019 | 2095918.5425099998 | 37.7358082006905 | -122.39230836824899 | (37.7358082006905, -122.392308368249) | ||
| 14012 | 14012 | 106954 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 29 Lydia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6012839.09683 | 2092807.12473 | 37.727172647775 | -122.397824840259 | (37.727172647775, -122.397824840259) | |||
| 14184 | 14184 | 25546 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 211 Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 20 | 2X3 | 6010986.1155199995 | 2096981.2518200001 | 37.7385305546342 | -122.40452431464199 | (37.7385305546342, -122.404524314642) | ||
| 14209 | 14209 | 25967 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2121 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6012203.8178199995 | 2097553.63348 | 37.740170171620704 | -122.40035425186599 | (37.7401701716207, -122.400354251866) | ||
| 14310 | 14310 | 25921 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6013425.09297 | 2096721.31671 | 37.737952831067 | -122.39607323250601 | (37.737952831067, -122.396073232506) | ||
| 14492 | 14492 | 25920 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6013439.08711 | 2096707.4096400002 | 37.7379154237493 | -122.396023873224 | (37.7379154237493, -122.396023873224) | ||
| 14665 | 14665 | 24958 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3150 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1995 12:00:00 AM | 3 | 3x2 | 6015944.400780001 | 2100851.85574 | 37.7494342903725 | -122.387650769466 | (37.7494342903725, -122.387650769466) | ||
| 14840 | 14840 | 25979 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1955 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6013151.4880800005 | 2096853.8753799999 | 37.7383015827389 | -122.39702851757299 | (37.7383015827389, -122.397028517573) | ||
| 15065 | 15065 | 25926 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/1997 12:00:00 AM | 14 | 3x3 | 6013312.92964 | 2096802.5667400002 | 37.7381696854804 | -122.396466732646 | (37.7381696854804, -122.396466732646) | ||
| 15126 | 15126 | 25968 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2121 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2000 12:00:00 AM | 3 | 2x3 | 6012223.9288800005 | 2097537.9675 | 37.7401282776092 | -122.400283615495 | (37.7401282776092, -122.400283615495) | ||
| 15345 | 15345 | 25550 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 8 | 3X3 | 6012164.070040001 | 2097372.25832 | 37.739669937231 | -122.40047894733999 | (37.739669937231, -122.40047894734) | ||
| 15380 | 15380 | 25906 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1726 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 6 | 3X3 | 6014385.46965 | 2096004.245 | 37.7360372867842 | -122.392702562673 | (37.7360372867842, -122.392702562673) | ||
| 15990 | 15990 | 25908 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1744 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/1997 12:00:00 AM | 6 | 3X3 | 6014300.07795 | 2096067.0404400001 | 37.736204967168895 | -122.393002190722 | (37.7362049671689, -122.393002190722) | ||
| 16119 | 16119 | 25909 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1748 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 6 | 3X3 | 6014281.93138 | 2096080.88268 | 37.7362419670851 | -122.393065899587 | (37.7362419670851, -122.393065899587) | ||
| 17069 | 17069 | 232077 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 256 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 6006071.88671 | 2096082.4988799999 | 37.7357869155289 | -122.42145157094299 | (37.7357869155289, -122.421451570943) | ||||
| 17982 | 17982 | 40992 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/04/2005 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500288997 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | ||
| 18766 | 18766 | 2403 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2719 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1992 12:00:00 AM | 10 | 3X3 | 6009830.59992 | 2101497.63424 | 37.75086690769329 | -122.408838100808 | (37.7508669076933, -122.408838100808) | ||
| 19134 | 19134 | 42608 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1775 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42675 | 6004555.83509625 | 2118398.4069888 | 37.796975439849 | -122.428283124742 | (37.796975439849, -122.428283124742) | ||
| 19153 | 19153 | 32201 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1600 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35526 | 6009257.49106 | 2100036.19276 | 37.746821995456706 | -122.410716774664 | (37.7468219954567, -122.410716774664) |
| 19640 | 19640 | 41394 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 19682 | 19682 | 46465 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2098 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2002 12:00:00 AM | Permit Number 44668 | 6002328.64862435 | 2119517.88465055 | 37.7999229605029 | -122.436069860968 | (37.7999229605029, -122.436069860968) | |||
| 21033 | 21033 | 32203 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1600 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35526 | 6009258.562059999 | 2100000.95105 | 37.7467252895536 | -122.410710582833 | (37.7467252895536, -122.410710582833) | |
| 21193 | 21193 | 32202 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1600 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35526 | 6009258.02214 | 2100018.34894 | 37.7467730300449 | -122.410713678287 | (37.7467730300449, -122.410713678287) | |
| 21548 | 21548 | 31364 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2295 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779235 | 5991014.76631 | 2099859.25307 | 37.745296448467 | -122.47378484391001 | (37.745296448467, -122.47378484391) | |
| 22679 | 22679 | 9226 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 6332 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5987316.8892 | 2112613.5319 | 37.7801013217352 | -122.487508066232 | (37.7801013217352, -122.487508066232) | |||
| 23057 | 23057 | 22656 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/1990 12:00:00 AM | 13 | 5x6 | 6004159.3035 | 2112511.1004 | 37.7807879370459 | -122.429235205882 | (37.7807879370459, -122.429235205882) | ||
| 23453 | 23453 | 44513 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 150 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 12 | Permit Number 43807 | 6005815.01817 | 2093004.2329099998 | 37.72732019055479 | -122.422121046963 | (37.7273201905548, -122.422121046963) | |
| 23554 | 23554 | 193631 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2 Industrial St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012126.8471099995 | 2097436.10996 | 37.7398431844134 | -122.400612133368 | (37.7398431844134, -122.400612133368) | |||
| 23613 | 23613 | 177549 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1212 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008302.63413 | 2087080.3017900002 | 37.7111943147388 | -122.41310263557502 | (37.7111943147388, -122.413102635575) | |||
| 23756 | 23756 | 232044 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1312 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007145.81115 | 2107846.77823 | 37.7681494393824 | -122.418572549693 | (37.7681494393824, -122.418572549693) | |||
| 23830 | 23830 | 177533 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 475 Holyoke St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6009855.34609 | 2092245.89508 | 37.725465012383 | -122.408100121635 | (37.725465012383, -122.408100121635) | |||
| 24091 | 24091 | 193642 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2000 Oakdale Ave | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012823.32202 | 2097168.087 | 37.739146068631705 | -122.398185200408 | (37.7391460686317, -122.398185200408) | |||
| 24208 | 24208 | 177560 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 321 Ellington Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5998919.67884 | 2087945.88417 | 37.7130398000187 | -122.445594536777 | (37.7130398000187, -122.445594536777) | |||
| 24241 | 24241 | 193574 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1101 Illinois St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016138.78787 | 2103882.6002 | 37.7577668436722 | -122.38718994068701 | (37.7577668436722, -122.387189940687) | |||
| 24302 | 24302 | 232117 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 322 Elsie St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006376.96981 | 2097041.1204900001 | 37.7384362742185 | -122.420464800608 | (37.7384362742185, -122.420464800608) | |||
| 24403 | 24403 | 232085 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 119 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006812.50904 | 2096877.7534400001 | 37.7380122393768 | -122.41894733046401 | (37.7380122393768, -122.418947330464) | |||
| 24742 | 24742 | 54473 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 75 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1972 12:00:00 AM | 11 | Permit Number 10265 | 6012333.352419999 | 2095372.33986 | 37.73418801985999 | -122.39975324750799 | (37.73418801986, -122.399753247508) | ||
| 25066 | 25066 | 45114 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1432 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 7 | Permit Number 43977 | 5988656.3497 | 2100380.3456 | 37.7465903529409 | -122.481977924939 | (37.7465903529409, -122.481977924939) | |
| 25208 | 25208 | 66447 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1717 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 13 | Permit Number 32898 | 6009150.1903099995 | 2119198.2009799997 | 37.7994303674837 | -122.41244205838001 | (37.7994303674837, -122.41244205838) |
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");