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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 129093 | 129093 | 447 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 700x 23rd Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/19/2015 10:02:00 AM | 3 | 8-HOA | 5988844.179766299 | 2110365.2900002 | 37.7740172309193 | -122.48205978958599 | (37.7740172309193, -122.482059789586) | ||
| 131764 | 131764 | 460 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 760x 23rd Ave | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 5988827.36485 | 2110053.67584 | 37.773160646819 | -122.482095121354 | (37.773160646819, -122.482095121354) | ||||
| 103239 | 103239 | 461 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 760x 23rd Ave | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/19/2015 10:10:00 AM | 3 | 8x100 | 5988827.12869 | 2110042.5268099997 | 37.7731300209347 | -122.48209512132799 | (37.7731300209347, -122.482095121328) | ||
| 98682 | 98682 | 837 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4255X Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 05:35:00 PM | 3 | 3X3 | 5981362.6566223 | 2105522.5911084 | 37.7602826110734 | -122.50757979099501 | (37.7602826110734, -122.507579790995) | ||
| 99004 | 99004 | 1942 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/1995 12:00:00 AM | 6 | 3X4 | 6017638.082631599 | 2095207.7846551002 | 37.7340304768318 | -122.381401486036 | (37.7340304768318, -122.381401486036) | ||
| 104238 | 104238 | 1943 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1997 12:00:00 AM | 6 | 3X4 | 6017638.082631599 | 2095207.7846551002 | 37.7340304768318 | -122.381401486036 | (37.7340304768318, -122.381401486036) | ||
| 77963 | 77963 | 1947 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 12 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1995 12:00:00 AM | 6 | 3X4 | 6017600.7966789 | 2095158.5318762 | 37.733893179879104 | -122.38152697242501 | (37.7338931798791, -122.381526972425) | ||
| 98998 | 98998 | 1948 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 12 Bertha Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2000 12:00:00 AM | 12 | 3X4 | 6017600.7966789 | 2095158.5318762 | 37.733893179879104 | -122.38152697242501 | (37.7338931798791, -122.381526972425) | ||
| 117020 | 117020 | 1950 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 22 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/1995 12:00:00 AM | 12 | 3X4 | 6017592.1686028 | 2095111.1070948 | 37.733762484425604 | -122.38155350563 | (37.7337624844256, -122.38155350563) | ||
| 102343 | 102343 | 1952 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 22 Bertha Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/1999 12:00:00 AM | 6 | 3X4 | 6017592.1686028 | 2095111.1070948 | 37.733762484425604 | -122.38155350563 | (37.7337624844256, -122.38155350563) | ||
| 83637 | 83637 | 1956 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 28 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1995 12:00:00 AM | 12 | 3X3 | 6017599.7808961 | 2095067.264352 | 37.7336425212053 | -122.381524139501 | (37.7336425212053, -122.381524139501) | ||
| 83031 | 83031 | 1959 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 35 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1999 12:00:00 AM | 6 | 3X4 | 6017662.293002901 | 2095057.1852268998 | 37.73361829711779 | -122.381307314085 | (37.7336182971178, -122.381307314085) | ||
| 142105 | 142105 | 1974 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 75 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2004 12:00:00 AM | 3 | 3X4 | 6017781.0101898 | 2094915.5294804 | 37.7332358914551 | -122.380887025623 | (37.7332358914551, -122.380887025623) | ||
| 141322 | 141322 | 1975 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 81 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2004 12:00:00 AM | 3 | 3X4 | 6017802.667442501 | 2094895.5028312001 | 37.73318209752429 | -122.38081075812201 | (37.7331820975243, -122.380810758122) | ||
| 20622 | 20622 | 1979 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 96 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/1995 12:00:00 AM | 6 | 3X4 | 6017818.374320901 | 2094812.8777716998 | 37.7329560922326 | -122.38075071303601 | (37.7329560922326, -122.380750713036) | ||
| 103134 | 103134 | 1983 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 102 Bertha Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1996 12:00:00 AM | 12 | 3X4 | 6017840.507549 | 2094792.7784106003 | 37.732902124826104 | -122.38067279528299 | (37.7329021248261, -122.380672795283) | ||
| 87861 | 87861 | 1990 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 118 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2004 12:00:00 AM | 3 | 3X4 | 6017898.3946760995 | 2094740.9470538998 | 37.73276300053679 | -122.380469061304 | (37.7327630005368, -122.380469061304) | ||
| 82644 | 82644 | 2402 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2711 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/27/1999 12:00:00 AM | 6 | 3X3 | 6009821.702585 | 2101547.9400274 | 37.7510045378629 | -122.40887241759899 | (37.7510045378629, -122.408872417599) | ||
| 18766 | 18766 | 2403 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2719 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1992 12:00:00 AM | 10 | 3X3 | 6009830.59992 | 2101497.63424 | 37.75086690769329 | -122.408838100808 | (37.7508669076933, -122.408838100808) | ||
| 22321 | 22321 | 3630 | Private 5 | Melaleuca quinquenervia :: Cajeput 50 | 100X Cargo Way | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017698.24794 | 2098446.68655 | 37.7429271764597 | -122.381418626885 | (37.7429271764597, -122.381418626885) | |||
| 22679 | 22679 | 9226 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 6332 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5987316.8892 | 2112613.5319 | 37.7801013217352 | -122.487508066232 | (37.7801013217352, -122.487508066232) | |||
| 7440 | 7440 | 9542 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6003977.1107 | 2112193.8912 | 37.7799066435706 | -122.429842866574 | (37.7799066435706, -122.429842866574) | ||
| 7827 | 7827 | 9544 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6003937.8747 | 2112189.6367 | 37.7798927397998 | -122.429978297745 | (37.7798927397998, -122.429978297745) | |||
| 112928 | 112928 | 9545 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6004321.7721315995 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | |||
| 100247 | 100247 | 9546 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004321.7721315995 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | ||
| 143168 | 143168 | 9547 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6004321.7721315995 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | ||
| 125436 | 125436 | 10854 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1299X HUDSON AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/31/1998 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 9157 | 9157 | 10857 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X HUDSON AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 9111 | 9111 | 10861 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X HUDSON AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 85301 | 85301 | 11491 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 80072 | 80072 | 11492 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 102462 | 102462 | 11493 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 140516 | 140516 | 11495 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 87201 | 87201 | 11504 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 109551 | 109551 | 11514 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018414.23901 | 2096612.7330099999 | 37.7379310078681 | -122.378815574261 | (37.7379310078681, -122.378815574261) | ||
| 78194 | 78194 | 11543 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Jennings St | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018704.60401 | 2097015.07701 | 37.7390517691962 | -122.377839546083 | (37.7390517691962, -122.377839546083) | ||
| 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) | ||
| 84631 | 84631 | 12889 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 200X Larch St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2005 12:00:00 AM | 3 | 3X3 | 6006589.39642 | 2113072.01589 | 37.78246534478271 | -122.420868153744 | (37.7824653447827, -122.420868153744) | ||
| 124720 | 124720 | 13115 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1626 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 60 | 3x3 | 6004582.24244 | 2119837.84859 | 37.80092927108829 | -122.428294391798 | (37.8009292710883, -122.428294391798) | ||
| 143539 | 143539 | 15005 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 600X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1993 12:00:00 AM | 12 | 3x3 | 6016372.25512 | 2097272.64218 | 37.7396301943656 | -122.385921767044 | (37.7396301943656, -122.385921767044) | ||
| 100947 | 100947 | 15006 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 600X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2002 12:00:00 AM | 3 | 3x3 | 6016372.25512 | 2097272.64218 | 37.7396301943656 | -122.385921767044 | (37.7396301943656, -122.385921767044) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 10774 | 10774 | 15813 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 5017 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000686.592 | 2089771.9365 | 37.71815444799179 | -122.439618338087 | (37.7181544479918, -122.439618338087) | ||
| 10847 | 10847 | 15814 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 5017 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1995 12:00:00 AM | 12 | 3X3 | 6000703.7551 | 2089800.5417 | 37.7182339682695 | -122.43956106225401 | (37.7182339682695, -122.439561062254) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 145012 | 145012 | 15826 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 5081 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1995 12:00:00 AM | 6 | 3X3 | 6000584.2194 | 2089509.2478099999 | 37.7174273368683 | -122.43995337049401 | (37.7174273368683, -122.439953370494) | ||
| 22095 | 22095 | 16101 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 300 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000029.1931 | 2094706.63805 | 37.731666565451896 | -122.442244727636 | (37.7316665654519, -122.442244727636) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 101762 | 101762 | 22620 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1115 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1992 12:00:00 AM | 14 | 3X3 | 6004661.4370099995 | 2112589.46724 | 37.7810315265304 | -122.427503666216 | (37.7810315265304, -122.427503666216) | ||
| 87381 | 87381 | 22633 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1171 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/1990 12:00:00 AM | 10 | 3X3 | 6004419.15464 | 2112535.54329 | 37.7808697581914 | -122.428337997055 | (37.7808697581914, -122.428337997055) | ||
| 81318 | 81318 | 22640 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1224 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/2001 12:00:00 AM | 6 | 3X3 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 118267 | 118267 | 22655 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1993 12:00:00 AM | 12 | 5x6 | 6004058.9793568 | 2112500.5432525002 | 37.780753269773705 | -122.42958152263999 | (37.7807532697737, -122.42958152264) | ||
| 23057 | 23057 | 22656 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/1990 12:00:00 AM | 13 | 5x6 | 6004159.3035 | 2112511.1004 | 37.7807879370459 | -122.429235205882 | (37.7807879370459, -122.429235205882) | ||
| 8432 | 8432 | 22657 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5x6 | 6004182.2536 | 2112515.9686 | 37.780802603117706 | -122.42915615755899 | (37.7808026031177, -122.429156157559) | |||
| 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) | ||
| 121769 | 121769 | 22659 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1251 Turk St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004058.6621900005 | 2112505.54701 | 37.7807669908902 | -122.42958297683901 | (37.7807669908902, -122.429582976839) | |||
| 103373 | 103373 | 22663 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1264 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2005 12:00:00 AM | 3 | 3X3 | 6003978.879930001 | 2112555.0183200003 | 37.780898309109 | -122.42986251206699 | (37.780898309109, -122.429862512067) | ||
| 104772 | 104772 | 24069 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 187X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/2000 12:00:00 AM | 6 | 3X3 | 6016398.9565531 | 2095907.2518992 | 37.7358825859465 | -122.38573430379101 | (37.7358825859465, -122.385734303791) | ||
| 117807 | 117807 | 24078 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 161X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/1996 12:00:00 AM | 6 | 3X3 | 6016395.7853594 | 2095946.5828375 | 37.735990405317004 | -122.385748008424 | (37.735990405317, -122.385748008424) | ||
| 9276 | 9276 | 24081 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 141X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2001 12:00:00 AM | 3 | 3X3 | 6016393.5495733 | 2095983.6738742 | 37.7360921261264 | -122.38575832291299 | (37.7360921261264, -122.385758322913) | ||
| 9378 | 9378 | 24087 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 141X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2000 12:00:00 AM | 9 | 3X3 | 6016393.5495733 | 2095983.6738742 | 37.7360921261264 | -122.38575832291299 | (37.7360921261264, -122.385758322913) | ||
| 9342 | 9342 | 24095 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 105X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1996 12:00:00 AM | 5 | 3x3 | 6016397.2233978 | 2096041.0813580002 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | ||
| 128942 | 128942 | 24111 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 180X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/06/1997 12:00:00 AM | 6 | 3X3 | 6016348.1117358 | 2095906.4833443002 | 37.735877662010296 | -122.38591004253 | (37.7358776620103, -122.38591004253) | ||
| 9153 | 9153 | 24125 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 140X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2016 12:00:00 AM | 3 | 3X3 | 6016343.6401634 | 2095980.6654178002 | 37.736081103602096 | -122.38593067194799 | (37.7360811036021, -122.385930671948) | ||
| 9103 | 9103 | 24126 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 140X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1997 12:00:00 AM | 9 | 3X3 | 6016343.6401634 | 2095980.6654178002 | 37.736081103602096 | -122.38593067194799 | (37.7360811036021, -122.385930671948) | ||
| 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) | |||
| 9427 | 9427 | 24136 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 120X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1996 12:00:00 AM | 6 | 3x3 | 6016341.404377299 | 2096017.7564546003 | 37.736182824394206 | -122.38594098669901 | (37.7361828243942, -122.385940986699) | ||
| 9483 | 9483 | 24137 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 120X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1996 12:00:00 AM | 12 | 3x3 | 6016341.404377299 | 2096017.7564546003 | 37.736182824394206 | -122.38594098669901 | (37.7361828243942, -122.385940986699) |
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");