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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 149 | 149 | 26071 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 247 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 01:41:00 PM | 3 | 3X3 | 5993990.1569314 | 2088190.8403771 | 37.7134297247264 | -122.46265023824101 | (37.7134297247264, -122.462650238241) | ||
| 626 | 626 | 251342 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/1996 12:00:00 AM | 3x3 | Permit Number 37503 | 5992527.0 | 2093770.0 | 37.7286643609316 | -122.46811297163299 | (37.7286643609316, -122.468112971633) | ||
| 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) |
| 1808 | 1808 | 26069 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 271 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/27/1997 12:00:00 AM | 3 | 3X3 | 5993995.7894187 | 2088348.3730133998 | 37.713862596316 | -122.462642190986 | (37.713862596316, -122.462642190986) | ||
| 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) | |
| 1995 | 1995 | 193739 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 65 Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 4ft | 6016922.219330001 | 2094905.4243400001 | 37.7331607080971 | -122.383855425397 | (37.7331607080971, -122.383855425397) | |||
| 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 | ||||||||
| 6555 | 6555 | 22647 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/1990 12:00:00 AM | 18 | 3X3 | 6003892.2472 | 2112477.7184 | 37.780681156415895 | -122.430156700947 | (37.7806811564159, -122.430156700947) | ||
| 6939 | 6939 | 22658 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1992 12:00:00 AM | 12 | 3X3 | 6004212.8538 | 2112518.7504 | 37.7808119734419 | -122.429050494981 | (37.7808119734419, -122.429050494981) | ||
| 7440 | 7440 | 9542 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6003977.1107 | 2112193.8912 | 37.7799066435706 | -122.429842866574 | (37.7799066435706, -122.429842866574) | ||
| 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) | ||
| 7827 | 7827 | 9544 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6003937.8747 | 2112189.6367 | 37.7798927397998 | -122.429978297745 | (37.7798927397998, -122.429978297745) | |||
| 7858 | 7858 | 22652 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1992 12:00:00 AM | 18 | 3X3 | 6004004.2161 | 2112490.9321 | 37.7807237790226 | -122.429770289505 | (37.7807237790226, -122.429770289505) | ||
| 8253 | 8253 | 22651 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/1990 12:00:00 AM | 18 | 3X3 | 6003985.4387 | 2112488.1502 | 37.7807150772953 | -122.4298350511 | (37.7807150772953, -122.4298350511) | ||
| 8410 | 8410 | 22654 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x6 | 6004084.8894 | 2112499.2776 | 37.7807512616309 | -122.42949179698 | (37.7807512616309, -122.42949179698) | |||
| 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) | |||
| 8672 | 8672 | 22653 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004029.2526 | 2112495.8003 | 37.7807385635944 | -122.429684023491 | (37.7807385635944, -122.429684023491) | |||
| 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) | |
| 10185 | 10185 | 86271 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1498X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988421.0 | 2105155.0 | 37.7596865840953 | -122.48314164268601 | (37.7596865840953, -122.483141642686) | ||
| 10186 | 10186 | 86272 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1498X 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988421.0 | 2105155.0 | 37.7596865840953 | -122.48314164268601 | (37.7596865840953, -122.483141642686) | ||
| 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) | ||
| 10393 | 10393 | 85922 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1750 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988150.1283 | 2103379.9075 | 37.754796893765395 | -122.483948277297 | (37.7547968937654, -122.483948277297) | ||
| 10504 | 10504 | 86267 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1562 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988412.0307 | 2104673.7348 | 37.7583646382457 | -122.483137386721 | (37.7583646382457, -122.483137386721) | ||
| 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) | ||
| 10552 | 10552 | 86314 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1563 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988370.7453 | 2104668.8777 | 37.758348899365394 | -122.483279812102 | (37.7583488993654, -122.483279812102) | ||
| 10566 | 10566 | 85914 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1882 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988180.9701 | 2102501.3004 | 37.7523862701891 | -122.483777202176 | (37.7523862701891, -122.483777202176) | ||
| 10576 | 10576 | 85916 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1838 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988170.1375 | 2102775.399 | 37.753138240815204 | -122.48383475868201 | (37.7531382408152, -122.483834758682) | ||
| 10583 | 10583 | 86264 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1694 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988441.0116 | 2103811.0505 | 37.755997626406206 | -122.482973932182 | (37.7559976264062, -122.482973932182) | ||
| 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) | ||
| 10847 | 10847 | 15814 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 5017 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1995 12:00:00 AM | 12 | 3X3 | 6000703.7551 | 2089800.5417 | 37.7182339682695 | -122.43956106225401 | (37.7182339682695, -122.439561062254) | ||
| 10916 | 10916 | 86279 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1370 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988367.4417 | 2105985.7022 | 37.761964349683396 | -122.48338776877199 | (37.7619643496834, -122.483387768772) | ||
| 10918 | 10918 | 86319 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1687 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988396.6413 | 2103838.6204 | 37.756070744005605 | -122.483129398253 | (37.7560707440056, -122.483129398253) | ||
| 11034 | 11034 | 15821 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 5051 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1995 12:00:00 AM | 6 | 3X3 | 6000582.469 | 2089604.8822 | 37.717689827708895 | -122.43996627417101 | (37.7176898277089, -122.439966274171) | ||
| 11050 | 11050 | 86410 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1823 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988122.3065 | 2102871.1988 | 37.7533984968143 | -122.484007190165 | (37.7533984968143, -122.484007190165) | ||
| 11063 | 11063 | 86318 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1659 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988389.7488 | 2104019.117 | 37.7565659379204 | -122.48316646418999 | (37.7565659379204, -122.48316646419) | ||
| 11211 | 11211 | 85907 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2246 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988262.6758 | 2100024.3615 | 37.7455900114068 | -122.48331310017299 | (37.7455900114068, -122.483313100173) | ||
| 11245 | 11245 | 85919 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1792 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988158.7855 | 2103127.4828 | 37.7541043074668 | -122.483899830474 | (37.7541043074668, -122.483899830474) | ||
| 11255 | 11255 | 86284 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1330 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988359.3252 | 2106249.2195 | 37.762687423978 | -122.483435159107 | (37.762687423978, -122.483435159107) | ||
| 11263 | 11263 | 86266 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1650 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988431.5344 | 2104067.7951 | 37.75670202642571 | -122.483025524044 | (37.7567020264257, -122.483025524044) | ||
| 11299 | 11299 | 86306 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1483 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988351.387999999 | 2105239.4954 | 37.7599145343681 | -122.483388587245 | (37.7599145343681, -122.483388587245) | ||
| 11342 | 11342 | 86268 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1554 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988410.0879 | 2104736.3916 | 37.7585365638092 | -122.483148698285 | (37.7585365638092, -122.483148698285) | ||
| 11405 | 11405 | 86274 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1470 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988390.8371 | 2105304.6829 | 37.7600958174171 | -122.48325693207899 | (37.7600958174171, -122.483256932079) | ||
| 11446 | 11446 | 15765 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4750 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1995 12:00:00 AM | 12 | 3X3 | 6001511.2475 | 2091189.3697 | 37.7220933031097 | -122.436869277919 | (37.7220933031097, -122.436869277919) | ||
| 11485 | 11485 | 86280 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1366 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988366.3595 | 2106019.7917 | 37.7620578871803 | -122.483394010737 | (37.7620578871803, -122.483394010737) | ||
| 11502 | 11502 | 86307 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1491 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988352.2197 | 2105195.8317 | 37.7597946941019 | -122.483382509952 | (37.7597946941019, -122.483382509952) | ||
| 11561 | 11561 | 85917 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1830 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988168.9979 | 2102827.2497 | 37.7532805425745 | -122.48384250118299 | (37.7532805425745, -122.483842501183) | ||
| 11583 | 11583 | 86277 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1390 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988371.7706 | 2105858.0017 | 37.761613970822 | -122.48336343539101 | (37.761613970822, -122.483363435391) | ||
| 11585 | 11585 | 15794 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4929 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2007 12:00:00 AM | 8 | 3x3 | 6000979.6747 | 2090237.6292 | 37.7194498121599 | -122.43863862911199 | (37.7194498121599, -122.438638629112) | ||
| 11590 | 11590 | 15745 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4570 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/1995 12:00:00 AM | 15 | 3X3 | 6002141.222999999 | 2092193.7491 | 37.7248868880905 | -122.434763397745 | (37.7248868880905, -122.434763397745) | ||
| 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) | |
| 11631 | 11631 | 15824 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 5060 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1995 12:00:00 AM | 12 | 3X3 | 6000432.8297 | 2089486.0645 | 37.7173550615336 | -122.440474991501 | (37.7173550615336, -122.440474991501) | ||
| 11647 | 11647 | 24814 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4749 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/1995 12:00:00 AM | 12 | 3X3 | 6001619.1557 | 2091250.5894 | 37.7222675310536 | -122.436500645989 | (37.7222675310536, -122.436500645989) | ||
| 11661 | 11661 | 86405 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1751 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988101.9893 | 2103387.0665 | 37.7548137478444 | -122.48411527814501 | (37.7548137478444, -122.484115278145) | ||
| 11676 | 11676 | 86269 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1514 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988401.8308 | 2104975.3617 | 37.7591922304865 | -122.48319477105301 | (37.7591922304865, -122.483194771053) | ||
| 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) | ||
| 11830 | 11830 | 86278 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1386 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988372.3117 | 2105874.2348 | 37.761658573987496 | -122.483362753995 | (37.7616585739875, -122.483362753995) | ||
| 11857 | 11857 | 86285 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1326 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988357.7019 | 2106271.4048 | 37.762748244281795 | -122.483442399915 | (37.7627482442818, -122.483442399915) | ||
| 11872 | 11872 | 86305 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1475 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988348.892999999 | 2105280.6641 | 37.7600274272341 | -122.483400234139 | (37.7600274272341, -122.483400234139) | ||
| 11892 | 11892 | 86407 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1767 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988104.9226 | 2103286.9146 | 37.7545389284857 | -122.48409779006599 | (37.7545389284857, -122.484097790066) | ||
| 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) | ||
| 11961 | 11961 | 86303 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1467 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988346.8137 | 2105325.1594 | 37.7601494782311 | -122.48341068724599 | (37.7601494782311, -122.483410687246) | ||
| 11977 | 11977 | 86290 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1323 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988313.8725 | 2106295.7544 | 37.7628125505969 | -122.483595773705 | (37.7628125505969, -122.483595773705) | ||
| 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) | ||
| 12056 | 12056 | 85925 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1730 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988145.2074 | 2103504.7685 | 37.7551394419513 | -122.483974450282 | (37.7551394419513, -122.483974450282) |
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");