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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12073 | 12073 | 109711 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 46 Wanda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773351 | 6000527.40359 | 2091492.50948 | 37.7228696894556 | -122.44029190466999 | (37.7228696894556, -122.44029190467) |
12125 | 12125 | 15819 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 5050 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/11/2001 12:00:00 AM | 12 | 3X3 | 6000495.0068 | 2089582.3782 | 37.717623057493896 | -122.440266977896 | (37.7176230574939, -122.440266977896) | ||
12187 | 12187 | 50191 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 347 Richard Av | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2003 12:00:00 AM | Permit Number 46897 | ||||||||
12197 | 12197 | 15810 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 5006 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778853 | 6000668.1276 | 2089853.0317 | 37.7183760661823 | -122.43968797212901 | (37.7183760661823, -122.439687972129) | |
12222 | 12222 | 85921 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1754 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988153.7734 | 2103347.5571 | 37.754708280483605 | -122.483933299665 | (37.7547082804836, -122.483933299665) | ||
12245 | 12245 | 72809 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 3x3 | 5998733.92072 | 2087172.14442 | 37.710904679081395 | -122.446180954109 | (37.7109046790814, -122.446180954109) | |
12251 | 12251 | 97320 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1044 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774147 | 5989913.4382 | 2099069.7096 | 37.7430647189098 | -122.47753531433399 | (37.7430647189098, -122.477535314334) | |
12264 | 12264 | 86408 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1801X 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 6 | 3x3 | 5988118.8805 | 2102991.671 | 37.753729081636 | -122.484027871479 | (37.753729081636, -122.484027871479) | ||
12353 | 12353 | 86294 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1375 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2007 12:00:00 AM | 3 | 3x3 | 5988325.7768 | 2105957.0237 | 37.7618831813474 | -122.48352976705799 | (37.7618831813474, -122.483529767058) | ||
12374 | 12374 | 15776 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4804 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | Permit Number 773279 | 6001272.7685 | 2090814.9657 | 37.721051717250795 | -122.43766683913601 | (37.7210517172508, -122.437666839136) | ||
12405 | 12405 | 86416 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2227 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988214.8811 | 2100128.059 | 37.74587195560729 | -122.483485965678 | (37.7458719556073, -122.483485965678) | ||
12495 | 12495 | 85911 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2226 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988257.1282 | 2100144.275 | 37.745918939271604 | -122.483341071389 | (37.7459189392716, -122.483341071389) | ||
12523 | 12523 | 66532 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3722 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/1991 12:00:00 AM | 18 | 3x3 | Permit Number 29707 | 5984457.3026 | 2098196.9463 | 37.7403502256776 | -122.496336488295 | (37.7403502256776, -122.496336488295) | |
12535 | 12535 | 86270 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1506 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988399.8879 | 2105026.8471 | 37.7593334823774 | -122.483205264351 | (37.7593334823774, -122.483205264351) | ||
12678 | 12678 | 108261 | Planning Code 138.1 required 4 | Melaleuca quinquenervia :: Cajeput 50 | 379 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774479 | 6002548.02456 | 2091247.69967 | 37.7223123355393 | -122.43328956378201 | (37.7223123355393, -122.433289563782) | |
12691 | 12691 | 86301 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1459 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988345.5662 | 2105396.6847 | 37.7603457946748 | -122.48342024517 | (37.7603457946748, -122.48342024517) | ||
12692 | 12692 | 86310 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1523 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988361.5167 | 2104922.9048 | 37.759045851915396 | -122.48333034952499 | (37.7590458519154, -122.483330349525) | ||
12891 | 12891 | 86300 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1443 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988341.8236 | 2105477.7745 | 37.760568227410495 | -122.483439133627 | (37.7605682274105, -122.483439133627) | ||
12932 | 12932 | 86289 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1305X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988311.167 | 2106360.1458 | 37.762989194328 | -122.483609852071 | (37.762989194328, -122.483609852071) | ||
12941 | 12941 | 86283 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1350 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988360.9485 | 2106155.0675 | 37.7624290027378 | -122.48342264230301 | (37.7624290027378, -122.483422642303) | ||
12950 | 12950 | 86281 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1350 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988363.654 | 2106078.2308 | 37.7622181875649 | -122.483407652112 | (37.7622181875649, -122.483407652112) | ||
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) | ||
12983 | 12983 | 73822 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 3x3 | 5998761.76944 | 2087100.1867 | 37.7107086898252 | -122.44607953033999 | (37.7107086898252, -122.44607953034) | |
12985 | 12985 | 76427 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 3 | 3x3 | 5998792.69271 | 2087037.2667900003 | 37.710537691825294 | -122.445968130449 | (37.7105376918253, -122.445968130449) | |
12995 | 12995 | 85903 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2270 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988266.5164 | 2099871.5891 | 37.745170762324705 | -122.483288623432 | (37.7451707623247, -122.483288623432) | ||
13035 | 13035 | 86292 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1355 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988320.3657 | 2106091.7584 | 37.762252811164295 | -122.483558359909 | (37.7622528111643, -122.483558359909) | ||
13054 | 13054 | 86311 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1527 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988363.4596 | 2104894.2478 | 37.758967280631 | -122.483321529451 | (37.758967280631, -122.483321529451) | ||
13062 | 13062 | 15760 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 4726 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1995 12:00:00 AM | 6 | 3X3 | 6001637.4054 | 2091396.9197 | 37.7226703580975 | -122.43644802923201 | (37.7226703580975, -122.436448029232) | ||
13088 | 13088 | 15792 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4871 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/1995 12:00:00 AM | 6 | 3X3 | 6001201.0318 | 2090588.783 | 37.7204265914192 | -122.43789861905199 | (37.7204265914192, -122.437898619052) | ||
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) | ||
13626 | 13626 | 25954 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2424 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6011648.47337 | 2098048.0207700003 | 37.741496669839705 | -122.402309171152 | (37.7414966698397, -122.402309171152) | ||
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) | ||
13918 | 13918 | 25904 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1700 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/1997 12:00:00 AM | 3 | 3X3 | 6014497.75019 | 2095918.5425099998 | 37.7358082006905 | -122.39230836824899 | (37.7358082006905, -122.392308368249) | ||
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) | ||
14012 | 14012 | 106954 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 29 Lydia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6012839.09683 | 2092807.12473 | 37.727172647775 | -122.397824840259 | (37.727172647775, -122.397824840259) | |||
14184 | 14184 | 25546 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 211 Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 20 | 2X3 | 6010986.1155199995 | 2096981.2518200001 | 37.7385305546342 | -122.40452431464199 | (37.7385305546342, -122.404524314642) | ||
14209 | 14209 | 25967 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2121 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6012203.8178199995 | 2097553.63348 | 37.740170171620704 | -122.40035425186599 | (37.7401701716207, -122.400354251866) | ||
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) | ||
14310 | 14310 | 25921 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6013425.09297 | 2096721.31671 | 37.737952831067 | -122.39607323250601 | (37.737952831067, -122.396073232506) | ||
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) | ||
14492 | 14492 | 25920 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6013439.08711 | 2096707.4096400002 | 37.7379154237493 | -122.396023873224 | (37.7379154237493, -122.396023873224) | ||
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) | |||
14665 | 14665 | 24958 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3150 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1995 12:00:00 AM | 3 | 3x2 | 6015944.400780001 | 2100851.85574 | 37.7494342903725 | -122.387650769466 | (37.7494342903725, -122.387650769466) | ||
14840 | 14840 | 25979 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1955 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6013151.4880800005 | 2096853.8753799999 | 37.7383015827389 | -122.39702851757299 | (37.7383015827389, -122.397028517573) | ||
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) | ||
15065 | 15065 | 25926 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/1997 12:00:00 AM | 14 | 3x3 | 6013312.92964 | 2096802.5667400002 | 37.7381696854804 | -122.396466732646 | (37.7381696854804, -122.396466732646) | ||
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) | ||
15126 | 15126 | 25968 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2121 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2000 12:00:00 AM | 3 | 2x3 | 6012223.9288800005 | 2097537.9675 | 37.7401282776092 | -122.400283615495 | (37.7401282776092, -122.400283615495) | ||
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) | ||
15345 | 15345 | 25550 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 8 | 3X3 | 6012164.070040001 | 2097372.25832 | 37.739669937231 | -122.40047894733999 | (37.739669937231, -122.40047894734) | ||
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) | ||
15380 | 15380 | 25906 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1726 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 6 | 3X3 | 6014385.46965 | 2096004.245 | 37.7360372867842 | -122.392702562673 | (37.7360372867842, -122.392702562673) | ||
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) | ||
15990 | 15990 | 25908 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1744 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/1997 12:00:00 AM | 6 | 3X3 | 6014300.07795 | 2096067.0404400001 | 37.736204967168895 | -122.393002190722 | (37.7362049671689, -122.393002190722) | ||
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) | ||
16069 | 16069 | 26134 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1506 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/22/1997 12:00:00 AM | 6 | 3x3 | 6015502.3956 | 2095169.2882 | 37.733806634802896 | -122.388782595026 | (37.7338066348029, -122.388782595026) | ||
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) | ||
16119 | 16119 | 25909 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1748 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 6 | 3X3 | 6014281.93138 | 2096080.88268 | 37.7362419670851 | -122.393065899587 | (37.7362419670851, -122.393065899587) | ||
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) | ||
16411 | 16411 | 27537 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016137.088719999 | 2102884.43561 | 37.755026000570105 | -122.38712619673599 | (37.7550260005701, -122.387126196736) | ||
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) | ||
16646 | 16646 | 27538 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 15 | 3X3 | 6016138.60969 | 2102846.2663 | 37.7549212799101 | -122.38711827459998 | (37.7549212799101, -122.3871182746) | ||
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) | ||
17069 | 17069 | 232077 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 256 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 6006071.88671 | 2096082.4988799999 | 37.7357869155289 | -122.42145157094299 | (37.7357869155289, -122.421451570943) | ||||
17982 | 17982 | 40992 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/04/2005 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500288997 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | ||
18679 | 18679 | 86291 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1339 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988318.888394 | 2106196.850699 | 37.7625412799726 | -122.483571174333 | (37.7625412799726, -122.483571174333) | |||
18766 | 18766 | 2403 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2719 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1992 12:00:00 AM | 10 | 3X3 | 6009830.59992 | 2101497.63424 | 37.75086690769329 | -122.408838100808 | (37.7508669076933, -122.408838100808) | ||
19134 | 19134 | 42608 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1775 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42675 | 6004555.83509625 | 2118398.4069888 | 37.796975439849 | -122.428283124742 | (37.796975439849, -122.428283124742) | ||
19153 | 19153 | 32201 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1600 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35526 | 6009257.49106 | 2100036.19276 | 37.746821995456706 | -122.410716774664 | (37.7468219954567, -122.410716774664) |
19640 | 19640 | 41394 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
19682 | 19682 | 46465 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2098 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2002 12:00:00 AM | Permit Number 44668 | 6002328.64862435 | 2119517.88465055 | 37.7999229605029 | -122.436069860968 | (37.7999229605029, -122.436069860968) | |||
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) | ||
20729 | 20729 | 25193 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 3351 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5999854.12011 | 2104362.71552 | 37.758169860475995 | -122.443543372027 | (37.758169860476, -122.443543372027) | |||
21033 | 21033 | 32203 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1600 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35526 | 6009258.562059999 | 2100000.95105 | 37.7467252895536 | -122.410710582833 | (37.7467252895536, -122.410710582833) | |
21193 | 21193 | 32202 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1600 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35526 | 6009258.02214 | 2100018.34894 | 37.7467730300449 | -122.410713678287 | (37.7467730300449, -122.410713678287) | |
21548 | 21548 | 31364 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2295 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779235 | 5991014.76631 | 2099859.25307 | 37.745296448467 | -122.47378484391001 | (37.745296448467, -122.47378484391) | |
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) | |||
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) | |||
22562 | 22562 | 24431 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 10X Peter Yorke Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005684.88689 | 2114317.71447 | 37.7858347009549 | -122.42408598197599 | (37.7858347009549, -122.424085981976) | ||
22566 | 22566 | 24430 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 10X Peter Yorke Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005698.75494 | 2114337.53552 | 37.7858899076294 | -122.42403941239999 | (37.7858899076294, -122.4240394124) | ||
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) |
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");