Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 38852 | 38852 | 177570 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 478 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010169.953290001 | 2089428.2061400001 | 37.7177458326947 | -122.406814054248 | (37.7177458326947, -122.406814054248) | |||
| 184150 | 184150 | 187445 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 5025 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000654.5541 | 2089723.8798 | 37.718020671595895 | -122.439725635648 | (37.7180206715959, -122.439725635648) | |||
| 68553 | 68553 | 187446 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 5025 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000667.1404 | 2089741.0429 | 37.7180685139976 | -122.439683360165 | (37.7180685139976, -122.439683360165) | |||
| 37688 | 37688 | 72518 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1385 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/09/1996 12:00:00 AM | 14 | 5999282.60736 | 2089782.0179599999 | 37.718102119793 | -122.44447201828599 | (37.718102119793, -122.444472018286) | ||
| 77615 | 77615 | 15817 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 5017 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1995 12:00:00 AM | 12 | 3X3 | 6000711.60071 | 2089768.80667 | 37.71814727755579 | -122.439531669663 | (37.7181472775558, -122.439531669663) | ||
| 80505 | 80505 | 15815 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 5017 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1995 12:00:00 AM | 12 | 3X3 | 6000711.60071 | 2089768.80667 | 37.71814727755579 | -122.439531669663 | (37.7181472775558, -122.439531669663) | ||
| 122087 | 122087 | 15816 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 5017 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1995 12:00:00 AM | 12 | 3X3 | 6000711.60071 | 2089768.80667 | 37.71814727755579 | -122.439531669663 | (37.7181472775558, -122.439531669663) | ||
| 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) | ||
| 90949 | 90949 | 15811 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 5012 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1995 12:00:00 AM | 12 | 3X3 | 6000615.26363 | 2089800.6494599998 | 37.7182292272974 | -122.439866946622 | (37.7182292272974, -122.439866946622) | ||
| 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) | ||
| 171502 | 171502 | 70698 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 591 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 8 | 6003529.56495 | 2089763.1909299998 | 37.7182918362743 | -122.429790778347 | (37.7182918362743, -122.429790778347) | ||
| 34726 | 34726 | 187449 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 5010 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000654.7168 | 2089835.9634 | 37.718328437150504 | -122.43973310452 | (37.7183284371505, -122.43973310452) | |||
| 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) | |
| 165200 | 165200 | 177567 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 686 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002012.03154 | 2089965.68745 | 37.7187617949906 | -122.43505071783599 | (37.7187617949906, -122.435050717836) | |||
| 68491 | 68491 | 187448 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4970 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000759.5646 | 2089995.6734 | 37.718772932153705 | -122.439382132493 | (37.7187729321537, -122.439382132493) | |||
| 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) |
| 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) | ||
| 66355 | 66355 | 187443 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4959 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000895.7282 | 2090103.1406 | 37.7190757609174 | -122.438919167767 | (37.7190757609174, -122.438919167767) | |||
| 114534 | 114534 | 15808 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4966 MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1995 12:00:00 AM | 6 | 5x4 | 6000832.0 | 2090106.0 | 37.7190799861125 | -122.43913965588301 | (37.7190799861125, -122.439139655883) | ||
| 83008 | 83008 | 15806 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4951 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1995 12:00:00 AM | 5 | 3X3 | 6000923.94149 | 2090106.32995 | 37.719086123330996 | -122.438821873955 | (37.719086123331, -122.438821873955) | ||
| 39294 | 39294 | 187465 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4900 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000831.495 | 2090115.1511 | 37.7191050842337 | -122.439142056993 | (37.7191050842337, -122.439142056993) | |||
| 172653 | 172653 | 210165 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 671 Head St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5993494.02777 | 2090293.78319 | 37.71917531585721 | -122.4645176216 | (37.7191753158572, -122.4645176216) | |||
| 128140 | 128140 | 34205 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 615 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767518 | 6002522.9923571 | 2090183.36055345 | 37.719388477306 | -122.433300078328 | (37.719388477306, -122.433300078328) | |
| 170903 | 170903 | 177565 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 601 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002521.384190001 | 2090187.9469 | 37.719400979162 | -122.43330596470699 | (37.719400979162, -122.433305964707) | |||
| 54357 | 54357 | 177531 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 179 Seneca Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5999891.06101 | 2090255.57698 | 37.7194371040088 | -122.44240284192301 | (37.7194371040088, -122.442402841923) | |||
| 61109 | 61109 | 177566 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 601 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002531.79574 | 2090204.60346 | 37.719447305029504 | -122.43327116543301 | (37.7194473050295, -122.433271165433) | |||
| 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) | ||
| 35094 | 35094 | 177530 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 179 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999882.65893 | 2090264.59961 | 37.719461399191104 | -122.442432532145 | (37.7194613991911, -122.442432532145) | |||
| 68968 | 68968 | 177529 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 179 Seneca Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5999866.21722 | 2090287.94662 | 37.7195245675911 | -122.44249104023399 | (37.7195245675911, -122.442491040234) | |||
| 96287 | 96287 | 45361 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 494 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2001 12:00:00 AM | Permit Number 44186 | 5993280.54401179 | 2090440.20724826 | 37.7195650519649 | -122.465266177702 | (37.7195650519649, -122.465266177702) | ||
| 93835 | 93835 | 15804 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4950 Mission St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/05/1997 12:00:00 AM | 6 | 4x4 | 6000922.5163 | 2090289.03562 | 37.7195877108284 | -122.438839886053 | (37.7195877108284, -122.438839886053) | ||
| 87552 | 87552 | 50508 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 502 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47143 | 6002555.80481261 | 2090259.94955548 | 37.719600635122795 | -122.43319212748301 | (37.7196006351228, -122.433192127483) | ||
| 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) | ||
| 35887 | 35887 | 177568 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3303 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011984.2913 | 2090294.781 | 37.7202266242306 | -122.400603502565 | (37.7202266242306, -122.400603502565) | |||
| 180566 | 180566 | 177569 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3299 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011976.8504 | 2090342.3740700001 | 37.7203568901522 | -122.40063256504801 | (37.7203568901522, -122.400632565048) | |||
| 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) | ||
| 84821 | 84821 | 46840 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 323 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44911 | 6004343.05626617 | 2090535.8229652 | 37.7204593479865 | -122.427033881485 | (37.7204593479865, -122.427033881485) | ||
| 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) | ||
| 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) | ||
| 149757 | 149757 | 210161 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 28 Williar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997155.78029 | 2090782.2268700001 | 37.7207268766131 | -122.451895623196 | (37.7207268766131, -122.451895623196) | |||
| 28114 | 28114 | 210164 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 556 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993014.635559999 | 2090870.2943400003 | 37.7207306285937 | -122.466216557854 | (37.7207306285937, -122.466216557854) | |||
| 105604 | 105604 | 115254 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 20 Edgar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 772988 | 5997135.3 | 2090888.7 | 37.7210180538388 | -122.451974094521 | (37.7210180538388, -122.451974094521) | |||
| 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) | ||
| 71442 | 71442 | 210163 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 855 Niagara Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997165.5867800005 | 2090928.2862900002 | 37.72112848326571 | -122.451872256998 | (37.7211284832657, -122.451872256998) | |||
| 125636 | 125636 | 15773 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 4787 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1995 12:00:00 AM | 6 | 3X3 | 6001512.82985 | 2091082.39205 | 37.7217996565285 | -122.43685615369101 | (37.7217996565285, -122.436856153691) | ||
| 178103 | 178103 | 187458 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4787 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001518.7729 | 2091094.7764 | 37.721833998936 | -122.436836496254 | (37.721833998936, -122.436836496254) | |||
| 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) | ||
| 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) | ||
| 96899 | 96899 | 24507 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 4750 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1995 12:00:00 AM | 12 | 3X3 | 6001492.23136 | 2091194.61222 | 37.7221066170749 | -122.436935387053 | (37.7221066170749, -122.436935387053) | ||
| 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) | ||
| 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) | |
| 57610 | 57610 | 83253 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 327 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52326 | 6004450.68298 | 2091222.5682400002 | 37.7223510855067 | -122.42671072981199 | (37.7223510855067, -122.426710729812) | |
| 27719 | 27719 | 210162 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 251 Harold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996802.41479 | 2091448.3649900001 | 37.7225356893565 | -122.453165155657 | (37.7225356893565, -122.453165155657) | |||
| 88964 | 88964 | 40469 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 251 Harold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41554 | 5996794.30906624 | 2091457.62107189 | 37.722560639803795 | -122.453193843047 | (37.7225606398038, -122.453193843047) | ||
| 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) | ||
| 115385 | 115385 | 15761 | 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 | 6 | 3X3 | 6001709.53638 | 2091375.2421099998 | 37.7226149347727 | -122.43619713806999 | (37.7226149347727, -122.43619713807) | ||
| 105723 | 105723 | 50424 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 234 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47077 | 5995672.60024173 | 2091512.71167993 | 37.7226475514283 | -122.45707529796101 | (37.7226475514283, -122.457075297961) | ||
| 94205 | 94205 | 113378 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4726 MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001617.0 | 2091393.0 | 37.7226584359628 | -122.4365182857 | (37.7226584359628, -122.4365182857) | |||
| 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) | ||
| 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) | ||
| 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) |
| 111765 | 111765 | 40740 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 60 Alviso St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/2002 12:00:00 AM | Permit Number 44235 | 5992200.51411552 | 2091694.39813825 | 37.7229464099622 | -122.46909064509899 | (37.7229464099622, -122.469090645099) | ||
| 76672 | 76672 | 177561 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 10 Ruth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6001695.33402 | 2091574.4813599999 | 37.7231611939064 | -122.436260484046 | (37.7231611939064, -122.436260484046) | |||
| 64294 | 64294 | 177562 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 10 Ruth St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6001656.83533 | 2091594.1990900002 | 37.7232131468593 | -122.43639497677201 | (37.7232131468593, -122.436394976772) | |||
| 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) | ||
| 84892 | 84892 | 42485 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2002 12:00:00 AM | Permit Number 44826 | 5997092.52001 | 2092229.35701 | 37.724696732278204 | -122.45221865729799 | (37.7246967322782, -122.452218657298) | ||
| 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) | ||
| 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) | ||
| 84323 | 84323 | 52932 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 189 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48918 | 6000194.36437989 | 2092360.19829328 | 37.7252331965683 | -122.441505382551 | (37.7252331965683, -122.441505382551) | ||
| 71452 | 71452 | 177539 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 502 Wayland St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009921.82598 | 2092169.2471599998 | 37.7252582753325 | -122.40786490304501 | (37.7252582753325, -122.407864903045) | |||
| 49046 | 49046 | 177538 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 502 Wayland St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009941.38457 | 2092176.41263 | 37.7252790451735 | -122.40779779564699 | (37.7252790451735, -122.407797795647) | |||
| 184630 | 184630 | 177537 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 502 Wayland St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009958.79969 | 2092181.94095 | 37.725295199712 | -122.40773798263001 | (37.725295199712, -122.40773798263) | |||
| 81817 | 81817 | 42478 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997094.69001 | 2092450.71201 | 37.7253046451535 | -122.4522271205 | (37.7253046451535, -122.4522271205) | ||
| 182442 | 182442 | 177536 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 502 Wayland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010025.44735 | 2092201.17388 | 37.7253517400837 | -122.407508942403 | (37.7253517400837, -122.407508942403) | |||
| 145021 | 145021 | 42482 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997095.77501 | 2092473.4980099997 | 37.725367272281396 | -122.45222501316499 | (37.7253672722814, -122.452225013165) | ||
| 55375 | 55375 | 177535 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 502 Wayland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010045.83235 | 2092207.4821400002 | 37.7253702022583 | -122.407438917579 | (37.7253702022583, -122.407438917579) | |||
| 133120 | 133120 | 177532 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 475 Holyoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6009861.69511 | 2092224.11932 | 37.7254055761992 | -122.40807663852101 | (37.7254055761992, -122.408076638521) | |||
| 56144 | 56144 | 177534 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 502 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010094.64304 | 2092221.1954700002 | 37.7254105881115 | -122.407271149051 | (37.7254105881115, -122.407271149051) | |||
| 90470 | 90470 | 42480 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997093.60501 | 2092500.6250099998 | 37.7254416323021 | -122.452234471094 | (37.7254416323021, -122.452234471094) | ||
| 23830 | 23830 | 177533 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 475 Holyoke St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6009855.34609 | 2092245.89508 | 37.725465012383 | -122.408100121635 | (37.725465012383, -122.408100121635) | |||
| 65625 | 65625 | 78240 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 783 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 15 | 6001313.10029 | 2092436.35435 | 37.7255059765042 | -122.43764348306999 | (37.7255059765042, -122.43764348307) | ||
| 101038 | 101038 | 43273 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 531 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43045 | 6010798.16682948 | 2092260.35598148 | 37.725557463887704 | -122.404841874666 | (37.7255574638877, -122.404841874666) | ||
| 163351 | 163351 | 78279 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 773 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 16 | 6001349.14865 | 2092521.0021 | 37.7257404495571 | -122.43752492633101 | (37.7257404495571, -122.437524926331) | ||
| 79937 | 79937 | 43271 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 449 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50498 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 96928 | 96928 | 43261 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 449 Holyoke St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 101407 | 101407 | 43269 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 449 Holyoke St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 119873 | 119873 | 43270 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 449 Holyoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 124145 | 124145 | 43263 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 449 Holyoke St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 124388 | 124388 | 43268 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 449 Holyoke St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 125400 | 125400 | 43264 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 449 Holyoke St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 128866 | 128866 | 43267 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 449 Holyoke St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 139785 | 139785 | 43266 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 449 Holyoke St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 140533 | 140533 | 43265 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 449 Holyoke St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 143991 | 143991 | 43272 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 449 Holyoke St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 161488 | 161488 | 78242 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 767 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 12 | 6001367.70534 | 2092560.86013 | 37.725850945661 | -122.437463630336 | (37.725850945661, -122.437463630336) | ||
| 103542 | 103542 | 95135 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 450@ Wayland Somerset St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010071.0 | 2092425.0 | 37.725968869436706 | -122.40736724249399 | (37.7259688694367, -122.407367242494) | ||||
| 113155 | 113155 | 42472 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997104.45601 | 2092710.04301 | 37.72601726622629 | -122.452212064054 | (37.7260172662263, -122.452212064054) | ||
| 120765 | 120765 | 42481 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997101.20001 | 2092733.9150099999 | 37.7260826265676 | -122.452225041509 | (37.7260826265676, -122.452225041509) | ||
| 115902 | 115902 | 42479 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997100.11501 | 2092762.1260099998 | 37.726160025142796 | -122.452230826947 | (37.7261600251428, -122.452230826947) |
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");