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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18679 | 18679 | 86291 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1339 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988318.888394 | 2106196.850699 | 37.7625412799726 | -122.483571174333 | (37.7625412799726, -122.483571174333) | |||
| 88989 | 88989 | 108732 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1690 12th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774636 | 5992500.062999999 | 2103959.4468900003 | 37.756640436376 | -122.46894731040001 | (37.756640436376, -122.4689473104) | |
| 104720 | 104720 | 108666 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 687 45th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774612 | 5981944.00662 | 2111079.6776799997 | 37.7755749935311 | -122.50598122863501 | (37.7755749935311, -122.505981228635) | |
| 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) | ||
| 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 | ||||||||
| 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) | |||
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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 | |||||||||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 12222 | 12222 | 85921 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1754 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988153.7734 | 2103347.5571 | 37.754708280483605 | -122.483933299665 | (37.7547082804836, -122.483933299665) | ||
| 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) | |
| 12264 | 12264 | 86408 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1801X 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 6 | 3x3 | 5988118.8805 | 2102991.671 | 37.753729081636 | -122.484027871479 | (37.753729081636, -122.484027871479) | ||
| 12353 | 12353 | 86294 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1375 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2007 12:00:00 AM | 3 | 3x3 | 5988325.7768 | 2105957.0237 | 37.7618831813474 | -122.48352976705799 | (37.7618831813474, -122.483529767058) | ||
| 12374 | 12374 | 15776 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4804 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | Permit Number 773279 | 6001272.7685 | 2090814.9657 | 37.721051717250795 | -122.43766683913601 | (37.7210517172508, -122.437666839136) | ||
| 12405 | 12405 | 86416 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2227 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988214.8811 | 2100128.059 | 37.74587195560729 | -122.483485965678 | (37.7458719556073, -122.483485965678) | ||
| 12495 | 12495 | 85911 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2226 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988257.1282 | 2100144.275 | 37.745918939271604 | -122.483341071389 | (37.7459189392716, -122.483341071389) | ||
| 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) | |
| 12535 | 12535 | 86270 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1506 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988399.8879 | 2105026.8471 | 37.7593334823774 | -122.483205264351 | (37.7593334823774, -122.483205264351) | ||
| 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) | |
| 12691 | 12691 | 86301 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1459 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988345.5662 | 2105396.6847 | 37.7603457946748 | -122.48342024517 | (37.7603457946748, -122.48342024517) | ||
| 12692 | 12692 | 86310 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1523 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988361.5167 | 2104922.9048 | 37.759045851915396 | -122.48333034952499 | (37.7590458519154, -122.483330349525) | ||
| 12891 | 12891 | 86300 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1443 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988341.8236 | 2105477.7745 | 37.760568227410495 | -122.483439133627 | (37.7605682274105, -122.483439133627) | ||
| 12932 | 12932 | 86289 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1305X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988311.167 | 2106360.1458 | 37.762989194328 | -122.483609852071 | (37.762989194328, -122.483609852071) | ||
| 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) | ||
| 12995 | 12995 | 85903 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2270 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988266.5164 | 2099871.5891 | 37.745170762324705 | -122.483288623432 | (37.7451707623247, -122.483288623432) | ||
| 13035 | 13035 | 86292 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1355 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988320.3657 | 2106091.7584 | 37.762252811164295 | -122.483558359909 | (37.7622528111643, -122.483558359909) | ||
| 13054 | 13054 | 86311 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1527 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988363.4596 | 2104894.2478 | 37.758967280631 | -122.483321529451 | (37.758967280631, -122.483321529451) | ||
| 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) | ||
| 13088 | 13088 | 15792 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4871 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/1995 12:00:00 AM | 6 | 3X3 | 6001201.0318 | 2090588.783 | 37.7204265914192 | -122.43789861905199 | (37.7204265914192, -122.437898619052) | ||
| 13120 | 13120 | 86293 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1367 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988324.1535 | 2106004.0997 | 37.762012344734 | -122.48353883273701 | (37.762012344734, -122.483538832737) | ||
| 13126 | 13126 | 86287 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1300 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/30/2015 08:24:00 AM | 3 | 3x3 | 5988357.1608 | 2106342.2893 | 37.76294284228629 | -122.48344946811301 | (37.7629428422863, -122.483449468113) | ||
| 13195 | 13195 | 85902 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2278 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988268.6501 | 2099821.6607 | 37.7450337963146 | -122.483277586342 | (37.7450337963146, -122.483277586342) | ||
| 13274 | 13274 | 187630 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4255x Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/23/2015 05:35:00 PM | 3x3 | 5981269.0 | 2105492.0 | 37.760193098921796 | -122.50790142928699 | (37.7601930989218, -122.507901429287) | ||
| 13633 | 13633 | 26120 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1469 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6015722.0682 | 2094937.3446 | 37.733181937191205 | -122.388006934363 | (37.7331819371912, -122.388006934363) | ||
| 13905 | 13905 | 25980 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1951 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 18 | 3x3 | 6013173.42584 | 2096838.9136400002 | 37.738261722099 | -122.396951618345 | (37.738261722099, -122.396951618345) |
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");