Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, DBH, PlotSize
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 12980 | 12980 | 15822 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 5051 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1995 12:00:00 AM | 6 | 3X3 | 6000596.1995 | 2089622.0453 | 37.717737735333294 | -122.439920044053 | (37.7177377353333, -122.439920044053) | ||
| 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) | ||
| 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) | ||
| 13117 | 13117 | 86409 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1803X 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/2016 01:51:00 PM | 3 | 3x3 | 5988119.1620000005 | 2102979.6826 | 37.7536961811016 | -122.48402601894699 | (37.7536961811016, -122.484026018947) | ||
| 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) | ||
| 13623 | 13623 | 25924 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6013360.04633 | 2096769.62618 | 37.7380818594982 | -122.396301517325 | (37.7380818594982, -122.396301517325) | ||
| 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) | ||
| 13693 | 13693 | 25934 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1980 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 14 | 3x3 | 6013105.1413900005 | 2096960.5409 | 37.7385918838981 | -122.39719624022499 | (37.7385918838981, -122.397196240225) | ||
| 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) | ||
| 13934 | 13934 | 24172 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/2000 12:00:00 AM | 12 | 3x3 | 6016627.62077 | 2095425.11976 | 37.7345713981576 | -122.384910134993 | (37.7345713981576, -122.384910134993) | ||
| 13946 | 13946 | 25905 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1722 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/1997 12:00:00 AM | 6 | 3x3 | 6014408.7500599995 | 2095988.0053299998 | 37.7359939889401 | -122.39262093662501 | (37.7359939889401, -122.392620936625) | ||
| 14274 | 14274 | 25994 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1789 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6014073.074569999 | 2096169.5895900002 | 37.7364739337157 | -122.393794216455 | (37.7364739337157, -122.393794216455) | ||
| 14351 | 14351 | 24146 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 12:00:00 AM | 12 | 3x3 | 6016692.87185 | 2095191.38157 | 37.733933208639606 | -122.384668261453 | (37.7339332086396, -122.384668261453) | ||
| 14384 | 14384 | 25972 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2065 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2016 07:07:00 AM | 3 | 3x3 | 6012485.58798 | 2097305.21052 | 37.7395037631998 | -122.39936256315 | (37.7395037631998, -122.39936256315) | ||
| 14461 | 14461 | 25928 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1940 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2015 12:45:00 PM | 3 | 3x3 | 6013206.38179 | 2096882.0048599998 | 37.7383818760104 | -122.396840692362 | (37.7383818760104, -122.396840692362) | ||
| 14512 | 14512 | 24130 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016633.73992 | 2095504.76195 | 37.734790418140605 | -122.384894525455 | (37.7347904181406, -122.384894525455) | |||
| 14842 | 14842 | 26422 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2198 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3X3 | 6011934.89939 | 2097835.39684 | 37.7409288343056 | -122.401303863995 | (37.7409288343056, -122.401303863995) | ||
| 14863 | 14863 | 26487 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2130 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/1997 12:00:00 AM | 12 | 3X3 | 6012213.921519999 | 2097628.14131 | 37.7403753177698 | -122.400324549047 | (37.7403753177698, -122.400324549047) | ||
| 14974 | 14974 | 25942 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2040 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6012651.9981 | 2097296.89439 | 37.7394902023226 | -122.398786602234 | (37.7394902023226, -122.398786602234) | ||
| 15028 | 15028 | 25922 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6013411.01512 | 2096731.0793 | 37.737978853826604 | -122.396122590895 | (37.7379788538266, -122.396122590895) | ||
| 15112 | 15112 | 11554 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Jennings St | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018972.44427 | 2097338.24769 | 37.7399538873755 | -122.37693587968398 | (37.7399538873755, -122.376935879684) | ||
| 15244 | 15244 | 25951 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2198 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6011979.2336 | 2097803.31735 | 37.7408432242339 | -122.401148318148 | (37.7408432242339, -122.401148318148) | ||
| 15362 | 15362 | 25953 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2424 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6011669.28435 | 2098033.15665 | 37.741457017814795 | -122.402236168686 | (37.7414570178148, -122.402236168686) | ||
| 15448 | 15448 | 25937 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2000 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 10 | 3x3 | 6012876.83116 | 2097128.12307 | 37.7390393164014 | -122.39799738599702 | (37.7390393164014, -122.397997385997) | ||
| 15560 | 15560 | 26663 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2100 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/09/1999 12:00:00 AM | 6 | 3X3 | 6012286.22112 | 2097573.09512 | 37.7402282039703 | -122.40007069922899 | (37.7402282039703, -122.400070699229) | ||
| 15593 | 15593 | 26121 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1451 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1998 12:00:00 AM | 3 | 3X3 | 6015827.8735 | 2094858.5401 | 37.7329714171096 | -122.387635637434 | (37.7329714171096, -122.387635637434) | ||
| 16024 | 16024 | 25948 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2100 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3X3 | 6012350.25705 | 2097525.2305900003 | 37.740100348252 | -122.399845927154 | (37.740100348252, -122.399845927154) | ||
| 16052 | 16052 | 25950 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2130 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3X3 | 6012258.5541199995 | 2097593.00957 | 37.7402813422027 | -122.40016775945699 | (37.7402813422027, -122.400167759457) | ||
| 16088 | 16088 | 26417 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2100 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3X3 | 6012309.7802800005 | 2097554.6976900003 | 37.7401790020488 | -122.399987948985 | (37.7401790020488, -122.399987948985) | ||
| 16145 | 16145 | 25931 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1940 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6013151.64445 | 2096926.6357200001 | 37.738501376141 | -122.397033077137 | (37.738501376141, -122.397033077137) | ||
| 16636 | 16636 | 25943 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2040 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 16 | 3x3 | 6012631.62363 | 2097312.6354799997 | 37.739532288795 | -122.398858153188 | (37.739532288795, -122.398858153188) | ||
| 16675 | 16675 | 16465 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6018666.35636 | 2097096.27558 | 37.7392726167438 | -122.37797742504 | (37.7392726167438, -122.37797742504) | |||
| 16762 | 16762 | 25545 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 211 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1997 12:00:00 AM | 35 | 3X3 | 6010962.7216300005 | 2096974.8083 | 37.73851155467371 | -122.40460474641701 | (37.7385115546737, -122.404604746417) | ||
| 16833 | 16833 | 16463 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018612.88561 | 2097134.8000900003 | 37.7393754506279 | -122.378164978648 | (37.7393754506279, -122.378164978648) | |||
| 16884 | 16884 | 25933 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1980 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 8 | 3x3 | 6013124.42835 | 2096948.9932900001 | 37.7385612502888 | -122.397128745193 | (37.7385612502888, -122.397128745193) |
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");