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 | ||||||||
| 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) |
| 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) | |
| 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) | |
| 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) | ||
| 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 | ||||||||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 12941 | 12941 | 86283 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1350 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988360.9485 | 2106155.0675 | 37.7624290027378 | -122.48342264230301 | (37.7624290027378, -122.483422642303) | ||
| 12950 | 12950 | 86281 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1350 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988363.654 | 2106078.2308 | 37.7622181875649 | -122.483407652112 | (37.7622181875649, -122.483407652112) | ||
| 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) | ||
| 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) | ||
| 16069 | 16069 | 26134 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1506 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/22/1997 12:00:00 AM | 6 | 3x3 | 6015502.3956 | 2095169.2882 | 37.733806634802896 | -122.388782595026 | (37.7338066348029, -122.388782595026) | ||
| 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) | ||
| 16411 | 16411 | 27537 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016137.088719999 | 2102884.43561 | 37.755026000570105 | -122.38712619673599 | (37.7550260005701, -122.387126196736) | ||
| 16646 | 16646 | 27538 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 15 | 3X3 | 6016138.60969 | 2102846.2663 | 37.7549212799101 | -122.38711827459998 | (37.7549212799101, -122.3871182746) | ||
| 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) | |
| 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) | |
| 26194 | 26194 | 31939 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1370 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 7 | Permit Number 35354 | 5981544.9955 | 2105760.2879 | 37.7609459982399 | -122.50696680963199 | (37.7609459982399, -122.506966809632) | |
| 29014 | 29014 | 43250 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 266 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 7 | Permit Number 43038 | 6009538.8668599995 | 2093129.97083 | 37.7278747727781 | -122.40925652566601 | (37.7278747727781, -122.409256525666) | |
| 30056 | 30056 | 68330 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1443 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 3 | Permit Number 32145 | 5991076.10581 | 2110608.88252 | 37.774815627769705 | -122.474357034376 | (37.7748156277697, -122.474357034376) | |
| 30502 | 30502 | 30752 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1507 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 11 | Permit Number 34633 | 6015383.6793 | 2093790.5859 | 37.73001441519 | -122.389096804708 | (37.73001441519, -122.389096804708) | |
| 30527 | 30527 | 33381 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | Permit Number 37503 | 5992540.871562201 | 2093773.0831922002 | 37.72867362771839 | -122.46806524141199 | (37.7286736277184, -122.468065241412) | |||
| 30543 | 30543 | 104420 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 622 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770538 | 5982306.9 | 2111497.7 | 37.776744114760106 | -122.504756894571 | (37.7767441147601, -122.504756894571) | ||||
| 30741 | 30741 | 95375 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2062 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2011 12:00:00 AM | 11 | 3x3 | Permit Number 767247 | 6003151.187940001 | 2118254.14775 | 37.7964997620133 | -122.43313322381701 | (37.7964997620133, -122.433133223817) | |
| 30854 | 30854 | 96684 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 375@32nd Ave 32nd Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 20 | Permit Number 768040 | 5985882.68379 | 2113417.37347 | 37.7822246913621 | -122.492528778473 | (37.7822246913621, -122.492528778473) | ||
| 31268 | 31268 | 51730 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3950 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 48012 | 5995856.51987 | 2115213.07332 | 37.787733304083 | -122.458153993141 | (37.787733304083, -122.458153993141) | |||
| 32479 | 32479 | 46784 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 20 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 12 | Permit Number 44875 | 6002869.92629 | 2093520.6249 | 37.728571535144404 | -122.432339079298 | (37.7285715351444, -122.432339079298) | |
| 33375 | 33375 | 40695 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 239 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 9 | Permit Number 41675 | 6004959.82025 | 2094081.1149900001 | 37.7302287977163 | -122.425154059106 | (37.7302287977163, -122.425154059106) | |
| 33552 | 33552 | 43314 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 143 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 14 | 6x9 | Permit Number 43077 | 6003948.96614 | 2092962.71195 | 37.7271007559741 | -122.428569025964 | (37.7271007559741, -122.428569025964) |
| 34713 | 34713 | 33176 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3245 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | 3.5x6 | Permit Number 37389 | 5985863.4598 | 2098187.5285 | 37.74040663959 | -122.491473929368 | (37.74040663959, -122.491473929368) |
| 36735 | 36735 | 39593 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 45 Southern Heights Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1998 12:00:00 AM | 4 | Permit Number 41001 | 6012273.08907 | 2104003.23751 | 37.7578832555154 | -122.400567684363 | (37.7578832555154, -122.400567684363) | ||
| 37390 | 37390 | 39700 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 360 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41085 | 5995865.64470652 | 2094899.35552532 | 37.7319575477065 | -122.45665278849701 | (37.7319575477065, -122.456652788497) | ||
| 37404 | 37404 | 40499 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 44 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | 3x3 | Permit Number 50329 | 5993102.74682774 | 2094714.88282209 | 37.731292009719894 | -122.466191234844 | (37.7312920097199, -122.466191234844) | ||
| 38344 | 38344 | 33199 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 740 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37404 | 5995918.52562455 | 2099456.80293437 | 37.7444742187741 | -122.45679946352 | (37.7444742187741, -122.45679946352) | ||
| 38920 | 38920 | 31779 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 926 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35253 | 5990034.0009 | 2097707.4772 | 37.73933137655229 | -122.477018926471 | (37.7393313765523, -122.477018926471) | |
| 39361 | 39361 | 45486 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2924 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 9 | Permit Number 44265 | 5990007.82234 | 2095770.7534900003 | 37.734012111575495 | -122.476967961016 | (37.7340121115755, -122.476967961016) | |
| 39906 | 39906 | 41404 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1252 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | 7 | Permit Number 42021 | 6008157.91792 | 2087132.40574 | 37.7113292562177 | -122.413606495143 | (37.7113292562177, -122.413606495143) | |
| 40494 | 40494 | 42892 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2338 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 0 | Permit Number 42810 | 5988796.038108099 | 2098341.45660017 | 37.741000222372605 | -122.48134561704599 | (37.7410002223726, -122.481345617046) |
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");